/// <summary> /// 获得投诉管理Model /// </summary> /// <param name="ComplaintId">投诉管理编号</param> /// <returns></returns> public Model.CrmStructure.MCrmComplaint GetCrmComplaintModel(string ComplaintId) { Model.CrmStructure.MCrmComplaint complaintModel = new EyouSoft.Model.CrmStructure.MCrmComplaint(); DbCommand dc = _db.GetSqlStringCommand(sql_Crm_SelectComplaint); _db.AddInParameter(dc, "ComplaintId", DbType.AnsiStringFixedLength, ComplaintId); using (IDataReader reader = DbHelper.ExecuteReader(dc, _db)) { while (reader.Read()) { complaintModel.CompanyId = !reader.IsDBNull(reader.GetOrdinal("CompanyId")) ? (string)reader["CompanyId"] : string.Empty; complaintModel.ComplaintsId = ComplaintId; complaintModel.ComplaintsIdentity = !reader.IsDBNull(reader.GetOrdinal("ComplaintsIdentity")) ? (string)reader["ComplaintsIdentity"] : string.Empty; complaintModel.ComplaintsName = !reader.IsDBNull(reader.GetOrdinal("ComplaintsName")) ? (string)reader["ComplaintsName"] : string.Empty; complaintModel.ComplaintsOpinion = !reader.IsDBNull(reader.GetOrdinal("ComplaintsOpinion")) ? (string)reader["ComplaintsOpinion"] : string.Empty; complaintModel.ComplaintsTel = !reader.IsDBNull(reader.GetOrdinal("ComplaintsTel")) ? (string)reader["ComplaintsTel"] : string.Empty; complaintModel.ComplaintsTime = !reader.IsDBNull(reader.GetOrdinal("ComplaintsTime")) ? (DateTime?)reader["ComplaintsTime"] : null; complaintModel.ComplaintsType = !reader.IsDBNull(reader.GetOrdinal("ComplaintsType")) ? (string)reader["ComplaintsType"] : string.Empty; complaintModel.HandleName = !reader.IsDBNull(reader.GetOrdinal("HandleName")) ? (string)reader["HandleName"] : string.Empty; complaintModel.HandleOpinion = !reader.IsDBNull(reader.GetOrdinal("HandleOpinion")) ? (string)reader["HandleOpinion"] : string.Empty; complaintModel.HandleTime = !reader.IsDBNull(reader.GetOrdinal("HandleTime")) ? (DateTime?)reader["HandleTime"] : null; complaintModel.IsHandle = !reader.IsDBNull(reader.GetOrdinal("IsHandle")) ? reader["IsHandle"].ToString() == "0" ? false : true : false; complaintModel.IssueTime = (DateTime)reader["IssueTime"]; complaintModel.OperatorId = !reader.IsDBNull(reader.GetOrdinal("OperatorId")) ? (string)reader["OperatorId"] : string.Empty; complaintModel.TourCode = !reader.IsDBNull(reader.GetOrdinal("TourCode")) ? (string)reader["TourCode"] : string.Empty; } } return(complaintModel); }
/// <summary> /// 初始化 /// </summary> private void PageInit(string id) { EyouSoft.BLL.CrmStructure.BCrmComplaint BLL = new EyouSoft.BLL.CrmStructure.BCrmComplaint(); EyouSoft.Model.CrmStructure.MCrmComplaint model = BLL.GetCrmComplaintModel(id); if (model != null) { this.hidComplaintsId.Value = model.ComplaintsId; this.lbTourCode.Text = model.TourCode; this.lbComplaintsName.Text = model.ComplaintsName; this.lbComplaintsTime.Text = string.Format("{0:yyyy-MM-dd}", model.ComplaintsTime); this.lbComplaintsIdentity.Text = model.ComplaintsIdentity; this.lbComplaintsTel.Text = model.ComplaintsTel; this.lbComplaintsType.Text = model.ComplaintsType; this.lbComplaintsOpinion.Text = model.ComplaintsOpinion; this.lbHandleName.Text = model.HandleName; this.txtHandleName.Text = model.HandleName; this.lbHandleTime.Text = model.HandleTime.HasValue ? model.HandleTime.Value.ToString("yyyy-MM-dd") : ""; this.txtHandleTime.Text = model.HandleTime.HasValue ? model.HandleTime.Value.ToString("yyyy-MM-dd") : ""; this.lbHandleResult.Text = model.HandleOpinion; this.txtHandleResult.Text = model.HandleOpinion; if (model.IsHandle) { handle.Checked = true; } else { nohandle.Checked = true; } this.lbIsHandle.Text = model.IsHandle ? "是" : "否"; } }