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))); }