/// <summary>
/// 更新一条记录（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <bool> UpdateAsync(CollectionExclosionEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "Update CollectionExclosion SET " +
"ExclosionName = @ExclosionName," +
"ExclosionType = @ExclosionType," +
"ExclosionStringType = @ExclosionStringType," +
"ExclosionString = @ExclosionString," +
"IsExclosionDesignatedNumber = @IsExclosionDesignatedNumber," +
"ExclosionDesignatedNumber = @ExclosionDesignatedNumber," +
"IsExclosionMaxNumber = @IsExclosionMaxNumber," +
"ExclosionMaxNumber = @ExclosionMaxNumber," +
"IsExclosionMinNumber = @IsExclosionMinNumber," +
"ExclosionMinNumber = @ExclosionMinNumber," +
"IsExclosionDesignatedDateTime = @IsExclosionDesignatedDateTime," +
"ExclosionDesignatedDateTime = @ExclosionDesignatedDateTime," +
"IsExclosionMaxDateTime = @IsExclosionMaxDateTime," +
"ExclosionMaxDateTime = @ExclosionMaxDateTime," +
"IsExclosionMinDateTime = @IsExclosionMinDateTime," +
"ExclosionMinDateTime = @ExclosionMinDateTime" +
" WHERE " +
"ExclosionID = @ExclosionID";
return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)));
}
/// <summary>
/// 增加一条记录，返回新的ID号。需要有一个单一主键，并且开启有标识符属性（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <int> InsertAsync(CollectionExclosionEntity entity)
{
if (entity.ExclosionID <= 0)
{
entity.ExclosionID = GetNewID();
}
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into CollectionExclosion (" +
"ExclosionID," +
"ExclosionName," +
"ExclosionType," +
"ExclosionStringType," +
"ExclosionString," +
"IsExclosionDesignatedNumber," +
"ExclosionDesignatedNumber," +
"IsExclosionMaxNumber," +
"ExclosionMaxNumber," +
"IsExclosionMinNumber," +
"ExclosionMinNumber," +
"IsExclosionDesignatedDateTime," +
"ExclosionDesignatedDateTime," +
"IsExclosionMaxDateTime," +
"ExclosionMaxDateTime," +
"IsExclosionMinDateTime," +
"ExclosionMinDateTime) " +
"values(" +
"@ExclosionID," +
"@ExclosionName," +
"@ExclosionType," +
"@ExclosionStringType," +
"@ExclosionString," +
"@IsExclosionDesignatedNumber," +
"@ExclosionDesignatedNumber," +
"@IsExclosionMaxNumber," +
"@ExclosionMaxNumber," +
"@IsExclosionMinNumber," +
"@ExclosionMinNumber," +
"@IsExclosionDesignatedDateTime," +
"@ExclosionDesignatedDateTime," +
"@IsExclosionMaxDateTime," +
"@ExclosionMaxDateTime," +
"@IsExclosionMinDateTime," +
"@ExclosionMinDateTime)";
if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)))
{
return(DataConverter.CLng(entity.ExclosionID));
}
return(-1);
}
/// <summary>
/// 获取实体（异步方式）
/// </summary>
/// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
/// <param name="dict">参数的名/值集合</param>
/// <returns></returns>
public virtual async Task <CollectionExclosionEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null)
{
CollectionExclosionEntity obj = null;
string strSQL = "select top 1 * from CollectionExclosion where 1=1 " + strWhere;
using (NullableDataReader reader = await Task.Run(() => _DB.GetDataReader(strSQL, dict)))
{
if (reader.Read())
{
obj = GetEntityFromrdr(reader);
}
}
return(obj);
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(CollectionExclosionEntity entity)
{
if (entity.ExclosionID <= 0)
{
entity.ExclosionID = GetNewID();
}
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into CollectionExclosion (" +
"ExclosionID," +
"ExclosionName," +
"ExclosionType," +
"ExclosionStringType," +
"ExclosionString," +
"IsExclosionDesignatedNumber," +
"ExclosionDesignatedNumber," +
"IsExclosionMaxNumber," +
"ExclosionMaxNumber," +
"IsExclosionMinNumber," +
"ExclosionMinNumber," +
"IsExclosionDesignatedDateTime," +
"ExclosionDesignatedDateTime," +
"IsExclosionMaxDateTime," +
"ExclosionMaxDateTime," +
"IsExclosionMinDateTime," +
"ExclosionMinDateTime) " +
"values(" +
"@ExclosionID," +
"@ExclosionName," +
"@ExclosionType," +
"@ExclosionStringType," +
"@ExclosionString," +
"@IsExclosionDesignatedNumber," +
"@ExclosionDesignatedNumber," +
"@IsExclosionMaxNumber," +
"@ExclosionMaxNumber," +
"@IsExclosionMinNumber," +
"@ExclosionMinNumber," +
"@IsExclosionDesignatedDateTime," +
"@ExclosionDesignatedDateTime," +
"@IsExclosionMaxDateTime," +
"@ExclosionMaxDateTime," +
"@IsExclosionMinDateTime," +
"@ExclosionMinDateTime)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 把实体类转换成键/值对集合
/// </summary>
/// <param name="entity"></param>
/// <param name="dict"></param>
private static void GetParameters(CollectionExclosionEntity entity, Dictionary <string, object> dict)
{
dict.Add("ExclosionID", entity.ExclosionID);
dict.Add("ExclosionName", entity.ExclosionName);
dict.Add("ExclosionType", entity.ExclosionType);
dict.Add("ExclosionStringType", entity.ExclosionStringType);
dict.Add("ExclosionString", entity.ExclosionString);
dict.Add("IsExclosionDesignatedNumber", entity.IsExclosionDesignatedNumber);
dict.Add("ExclosionDesignatedNumber", entity.ExclosionDesignatedNumber);
dict.Add("IsExclosionMaxNumber", entity.IsExclosionMaxNumber);
dict.Add("ExclosionMaxNumber", entity.ExclosionMaxNumber);
dict.Add("IsExclosionMinNumber", entity.IsExclosionMinNumber);
dict.Add("ExclosionMinNumber", entity.ExclosionMinNumber);
dict.Add("IsExclosionDesignatedDateTime", entity.IsExclosionDesignatedDateTime);
dict.Add("ExclosionDesignatedDateTime", entity.ExclosionDesignatedDateTime);
dict.Add("IsExclosionMaxDateTime", entity.IsExclosionMaxDateTime);
dict.Add("ExclosionMaxDateTime", entity.ExclosionMaxDateTime);
dict.Add("IsExclosionMinDateTime", entity.IsExclosionMinDateTime);
dict.Add("ExclosionMinDateTime", entity.ExclosionMinDateTime);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static CollectionExclosionEntity GetEntityFromrdr(NullableDataReader rdr)
{
CollectionExclosionEntity info = new CollectionExclosionEntity();
info.ExclosionID = rdr.GetInt32("ExclosionID");
info.ExclosionName = rdr.GetString("ExclosionName");
info.ExclosionType = rdr.GetInt32("ExclosionType");
info.ExclosionStringType = rdr.GetInt32("ExclosionStringType");
info.ExclosionString = rdr.GetString("ExclosionString");
info.IsExclosionDesignatedNumber = rdr.GetBoolean("IsExclosionDesignatedNumber");
info.ExclosionDesignatedNumber = rdr.GetInt32("ExclosionDesignatedNumber");
info.IsExclosionMaxNumber = rdr.GetBoolean("IsExclosionMaxNumber");
info.ExclosionMaxNumber = rdr.GetInt32("ExclosionMaxNumber");
info.IsExclosionMinNumber = rdr.GetBoolean("IsExclosionMinNumber");
info.ExclosionMinNumber = rdr.GetInt32("ExclosionMinNumber");
info.IsExclosionDesignatedDateTime = rdr.GetBoolean("IsExclosionDesignatedDateTime");
info.ExclosionDesignatedDateTime = rdr.GetNullableDateTime("ExclosionDesignatedDateTime");
info.IsExclosionMaxDateTime = rdr.GetBoolean("IsExclosionMaxDateTime");
info.ExclosionMaxDateTime = rdr.GetNullableDateTime("ExclosionMaxDateTime");
info.IsExclosionMinDateTime = rdr.GetBoolean("IsExclosionMinDateTime");
info.ExclosionMinDateTime = rdr.GetNullableDateTime("ExclosionMinDateTime");
return(info);
}
/// <summary>
/// 增加或更新一条记录（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <param name="IsSave">是否增加</param>
/// <returns></returns>
public virtual async Task <bool> AddOrUpdateAsync(CollectionExclosionEntity entity, bool IsSave)
{
return(IsSave ? await AddAsync(entity) : await UpdateAsync(entity));
}
/// <summary>
/// 增加或更新一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <param name="IsSave">是否增加</param>
/// <returns></returns>
public virtual bool AddOrUpdate(CollectionExclosionEntity entity, bool IsSave)
{
return(IsSave ? Add(entity) : Update(entity));
}
