private static ComplainItemInfo ComplainFromDataReader(NullableDataReader rdr)
{
ComplainItemInfo info = new ComplainItemInfo();
info.ItemId = rdr.GetInt32("ItemID");
info.ClientId = rdr.GetInt32("ClientID");
info.ContacterId = rdr.GetInt32("ContacterID");
info.ComplainMode = rdr.GetInt32("ComplainMode");
info.ComplainType = rdr.GetInt32("ComplainType");
info.ConfirmCaller = rdr.GetString("ConfirmCaller");
info.ConfirmFeedback = rdr.GetString("ConfirmFeedback");
info.ConfirmScore = rdr.GetInt32("ConfirmScore");
info.ConfirmTime = rdr.GetNullableDateTime("ConfirmTime");
info.Content = rdr.GetString("Content");
info.CurrentOwner = rdr.GetString("CurrentOwner");
info.DateAndTime = rdr.GetDateTime("DateAndTime");
info.EndTime = rdr.GetNullableDateTime("EndTime");
info.Feedback = rdr.GetString("Feedback");
info.FirstReceiver = rdr.GetString("FirstReceiver");
info.MagnitudeOfExigence = rdr.GetInt32("MagnitudeOfExigence");
info.Process = rdr.GetString("Process");
info.Processor = rdr.GetString("Processor");
info.Remark = rdr.GetString("Remark");
info.Result = rdr.GetString("Result");
info.ShortedForm = rdr.GetString("ShortedForm");
info.Status = rdr.GetInt32("Status");
info.Title = rdr.GetString("Title");
info.Defendant = rdr.GetString("Defendant");
return(info);
}
private static Parameters GetParameters(ComplainItemInfo info)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@ItemID", DbType.Int32, info.ItemId);
parameters.AddInParameter("@ClientID", DbType.Int32, info.ClientId);
parameters.AddInParameter("@ContacterID", DbType.Int32, info.ContacterId);
parameters.AddInParameter("@ComplainType", DbType.Int32, info.ComplainType);
parameters.AddInParameter("@ComplainMode", DbType.Int32, info.ComplainMode);
parameters.AddInParameter("@Title", DbType.String, info.Title);
parameters.AddInParameter("@Content", DbType.String, info.Content);
parameters.AddInParameter("@FirstReceiver", DbType.String, info.FirstReceiver);
parameters.AddInParameter("@DateAndTime", DbType.DateTime, info.DateAndTime);
parameters.AddInParameter("@MagnitudeOfExigence", DbType.Int32, info.MagnitudeOfExigence);
parameters.AddInParameter("@Process", DbType.String, info.Process);
parameters.AddInParameter("@Processor", DbType.String, info.Processor);
parameters.AddInParameter("@Result", DbType.String, info.Result);
parameters.AddInParameter("@EndTime", DbType.DateTime, info.EndTime);
parameters.AddInParameter("@Feedback", DbType.String, info.Feedback);
parameters.AddInParameter("@ConfirmTime", DbType.DateTime, info.ConfirmTime);
parameters.AddInParameter("@ConfirmCaller", DbType.String, info.ConfirmCaller);
parameters.AddInParameter("@ConfirmScore", DbType.Int32, info.ConfirmScore);
parameters.AddInParameter("@ConfirmFeedback", DbType.String, info.ConfirmFeedback);
parameters.AddInParameter("@Status", DbType.Int32, info.Status);
parameters.AddInParameter("@CurrentOwner", DbType.String, info.CurrentOwner);
parameters.AddInParameter("@Remark", DbType.String, info.Remark);
parameters.AddInParameter("@Defendant", DbType.String, info.Defendant);
return(parameters);
}
public bool Add(ComplainItemInfo info)
{
if (info.ItemId <= 0)
{
info.ItemId = this.GetMaxId() + 1;
}
return(DBHelper.ExecuteProc("PR_Crm_ComplainItem_Add", GetParameters(info)));
}
protected void EgvComplain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ComplainItemInfo dataItem = e.Row.DataItem as ComplainItemInfo;
e.Row.Cells[2].Text = Complain.GetFiledNameById("ComplainType", dataItem.ComplainType);
e.Row.Cells[4].Text = Complain.GetFiledNameById("MagnitudeOfExigence", dataItem.MagnitudeOfExigence);
e.Row.Cells[5].Text = Complain.GetStatus(dataItem.Status);
}
}
protected void EgvComplain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ComplainItemInfo dataItem = e.Row.DataItem as ComplainItemInfo;
e.Row.Cells[2].Text = Complain.GetFiledNameById("ComplainType", dataItem.ComplainType);
e.Row.Cells[4].Text = Complain.GetFiledNameById("MagnitudeOfExigence", dataItem.MagnitudeOfExigence);
e.Row.Cells[5].Text = Complain.GetStatus(dataItem.Status);
if (this.ShowOptions == 1)
{
HyperLink link = (HyperLink)e.Row.FindControl("LnkClientShow2");
link.NavigateUrl = string.Empty;
HyperLink link2 = (HyperLink)e.Row.FindControl("LnkComplainTitle");
link2.NavigateUrl = string.Empty;
}
}
}
public static bool Update(ComplainItemInfo info)
{
return((info != null) && dal.Update(info));
}
public static bool Add(ComplainItemInfo info)
{
return((info != null) && dal.Add(info));
}
public bool Update(ComplainItemInfo info)
{
return(DBHelper.ExecuteProc("PR_Crm_ComplainItem_Update", GetParameters(info)));
}
