/// <summary>
/// 更新一条记录（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <bool> UpdateAsync(ComplainLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "Update ComplainLog SET " +
"ClientID = @ClientID," +
"ContacterID = @ContacterID," +
"ComplainType = @ComplainType," +
"ComplainMode = @ComplainMode," +
"Title = @Title," +
"Content = @Content," +
"FirstReceiver = @FirstReceiver," +
"DateAndTime = @DateAndTime," +
"ExigenceLevel = @ExigenceLevel," +
"Process = @Process," +
"Processor = @Processor," +
"Result = @Result," +
"EndTime = @EndTime," +
"Feedback = @Feedback," +
"ConfirmTime = @ConfirmTime," +
"ConfirmCaller = @ConfirmCaller," +
"ConfirmScore = @ConfirmScore," +
"ConfirmFeedback = @ConfirmFeedback," +
"Status = @Status," +
"CurrentOwner = @CurrentOwner," +
"Remark = @Remark," +
"Defendant = @Defendant" +
" WHERE " +
"ItemID = @ItemID";
return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)));
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static ComplainLogEntity GetEntityFromrdr(NullableDataReader rdr)
{
ComplainLogEntity info = new ComplainLogEntity();
info.ItemID = rdr.GetInt32("ItemID");
info.ClientID = rdr.GetInt32("ClientID");
info.ContacterID = rdr.GetInt32("ContacterID");
info.ComplainType = rdr.GetInt32("ComplainType");
info.ComplainMode = rdr.GetInt32("ComplainMode");
info.Title = rdr.GetString("Title");
info.Content = rdr.GetString("Content");
info.FirstReceiver = rdr.GetString("FirstReceiver");
info.DateAndTime = rdr.GetNullableDateTime("DateAndTime");
info.ExigenceLevel = rdr.GetInt32("ExigenceLevel");
info.Process = rdr.GetString("Process");
info.Processor = rdr.GetString("Processor");
info.Result = rdr.GetString("Result");
info.EndTime = rdr.GetNullableDateTime("EndTime");
info.Feedback = rdr.GetString("Feedback");
info.ConfirmTime = rdr.GetNullableDateTime("ConfirmTime");
info.ConfirmCaller = rdr.GetString("ConfirmCaller");
info.ConfirmScore = rdr.GetInt32("ConfirmScore");
info.ConfirmFeedback = rdr.GetString("ConfirmFeedback");
info.Status = rdr.GetInt32("Status");
info.CurrentOwner = rdr.GetString("CurrentOwner");
info.Remark = rdr.GetString("Remark");
info.Defendant = rdr.GetString("Defendant");
return(info);
}
/// <summary>
/// 把实体类转换成键/值对集合
/// </summary>
/// <param name="entity"></param>
/// <param name="dict"></param>
private static void GetParameters(ComplainLogEntity entity, Dictionary <string, object> dict)
{
dict.Add("ItemID", entity.ItemID);
dict.Add("ClientID", entity.ClientID);
dict.Add("ContacterID", entity.ContacterID);
dict.Add("ComplainType", entity.ComplainType);
dict.Add("ComplainMode", entity.ComplainMode);
dict.Add("Title", entity.Title);
dict.Add("Content", entity.Content);
dict.Add("FirstReceiver", entity.FirstReceiver);
dict.Add("DateAndTime", entity.DateAndTime);
dict.Add("ExigenceLevel", entity.ExigenceLevel);
dict.Add("Process", entity.Process);
dict.Add("Processor", entity.Processor);
dict.Add("Result", entity.Result);
dict.Add("EndTime", entity.EndTime);
dict.Add("Feedback", entity.Feedback);
dict.Add("ConfirmTime", entity.ConfirmTime);
dict.Add("ConfirmCaller", entity.ConfirmCaller);
dict.Add("ConfirmScore", entity.ConfirmScore);
dict.Add("ConfirmFeedback", entity.ConfirmFeedback);
dict.Add("Status", entity.Status);
dict.Add("CurrentOwner", entity.CurrentOwner);
dict.Add("Remark", entity.Remark);
dict.Add("Defendant", entity.Defendant);
}
/// <summary>
/// 获取实体（异步方式）
/// </summary>
/// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
/// <param name="dict">参数的名/值集合</param>
/// <returns></returns>
public virtual async Task <ComplainLogEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null)
{
ComplainLogEntity obj = null;
string strSQL = "select top 1 * from ComplainLog 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>
/// <param name="IsSave">是否增加</param>
/// <returns></returns>
public virtual async Task <bool> AddOrUpdateAsync(ComplainLogEntity 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(ComplainLogEntity entity, bool IsSave)
{
return(IsSave ? Add(entity) : Update(entity));
}
/// <summary>
/// 增加一条记录，返回新的ID号。需要有一个单一主键，并且开启有标识符属性（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <int> InsertAsync(ComplainLogEntity entity)
{
if (entity.ItemID <= 0)
{
entity.ItemID = GetNewID();
}
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into ComplainLog (" +
"ItemID," +
"ClientID," +
"ContacterID," +
"ComplainType," +
"ComplainMode," +
"Title," +
"Content," +
"FirstReceiver," +
"DateAndTime," +
"ExigenceLevel," +
"Process," +
"Processor," +
"Result," +
"EndTime," +
"Feedback," +
"ConfirmTime," +
"ConfirmCaller," +
"ConfirmScore," +
"ConfirmFeedback," +
"Status," +
"CurrentOwner," +
"Remark," +
"Defendant) " +
"values(" +
"@ItemID," +
"@ClientID," +
"@ContacterID," +
"@ComplainType," +
"@ComplainMode," +
"@Title," +
"@Content," +
"@FirstReceiver," +
"@DateAndTime," +
"@ExigenceLevel," +
"@Process," +
"@Processor," +
"@Result," +
"@EndTime," +
"@Feedback," +
"@ConfirmTime," +
"@ConfirmCaller," +
"@ConfirmScore," +
"@ConfirmFeedback," +
"@Status," +
"@CurrentOwner," +
"@Remark," +
"@Defendant)";
if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)))
{
return(DataConverter.CLng(entity.ItemID));
}
return(-1);
}