DotNet.Business/Model/SqlExecute.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//--------------------------------------------------------------------
// All Rights Reserved , Copyright (C) 2014 , Hairihan TECH, Ltd.
//--------------------------------------------------------------------

using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Runtime.Serialization;

namespace DotNet.Business
{
    using DotNet.Utilities;
    
    [DataContract]
	[KnownType(typeof(DbParameter))]
	public class SqlExecute
	{
		public SqlExecute()
			: this("", null, CommandType.Text)
		{
		}

		public SqlExecute(string commandText)
			: this(commandText, null, CommandType.Text)
		{
		}

		public SqlExecute(string commandText, CommandType commandType)
			: this(commandText, null, commandType)
		{
		}

		public SqlExecute(string commandText, object parameters, CommandType commandType)
		{
			CommandText = commandText;
			CommandType = commandType;
			if(parameters != null)
			{
				if(parameters is DbParameter[])
				{
					Parameters = (parameters as DbParameter[]).ToList();
				}
				else
				{
					foreach(var item in parameters.GetType().GetProperties())
					{
						object value = item.GetValue(parameters, null);
						Parameters.Add(new DbParameter(item.Name, value));
					}
				}
			}
		}

		public SqlExecute AddParameter(string name, object value, ParameterDirection parameterDirection)
		{
			Parameters.Add(new DbParameter(name, value, parameterDirection));
			return this;
		}

		public void SetValueAt(int index, object value)