Пример #1
0
        /// <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);
        }
Пример #2
0
        /// <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 ? "是" : "否";
            }
        }