示例#1
0
        public HttpResponseBase GetContactUsQuestionList()
        {
            string json = string.Empty;
            DataTable _dt = new DataTable();
            ContactUsQuestionQuery cuQuery = new ContactUsQuestionQuery();
            cuQuery.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
            cuQuery.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
            try
            {

                cuQuery.search_type = Convert.ToInt32(Request.Params["search_type"]);
                cuQuery.searchcontent = Request.Params["searchcontent"];
                if (!string.IsNullOrEmpty(Request.Params["dateStart"]))
                {
                    cuQuery.datestart = Convert.ToDateTime(Request.Params["dateStart"]);//建立時間
                }
                if (!string.IsNullOrEmpty(Request.Params["dateEnd"]))
                {
                    cuQuery.dateend = Convert.ToDateTime(Request.Params["dateEnd"]);
                }
                cuQuery.question_type = Convert.ToUInt32(Request.Params["qusetion_type"]);
                if (Convert.ToBoolean(Request.Params["radio2"]) == true)//待回覆
                {
                    cuQuery.question_status = 3;
                }
                else if (Convert.ToBoolean(Request.Params["radio3"]) == true)//已回覆
                {
                    cuQuery.question_status = 4;
                }
                else if (Convert.ToBoolean(Request.Params["radio4"]) == true)//已處理
                {
                    cuQuery.question_status = 2;
                }
                if (!string.IsNullOrEmpty(Request.Params["relation_id"]))
                {
                    cuQuery.question_id = Convert.ToUInt32(Request.Params["relation_id"]);
                }
                if (Convert.ToBoolean(Request.Params["isSecret"]))
                {
                    cuQuery.isSecret = true;
                }
                int totalCount = 0;
                _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString);
                _dt = _ctactMgr.GetContactUsQuestionList(cuQuery, out totalCount);
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式     
                timeConverter.DateTimeFormat = "yyyy-MM-dd";
                json = "{success:true,'msg':'user',totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, Formatting.Indented, timeConverter) + "}";//返回json數據
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                json = "{success:false,totalCount:0,data:[]}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;
        }
示例#2
0
        public void GetContactUsQuestionExcelList()
        {
            string json = string.Empty;
            DataTable _dt = new DataTable();
            DataTable dtHZ = new DataTable();
            ContactUsQuestionQuery cuQuery = new ContactUsQuestionQuery();
            try
            {
                string newExcelName = string.Empty;
                dtHZ.Columns.Add("問題流水號", typeof(String));
                dtHZ.Columns.Add("公司", typeof(String));
                dtHZ.Columns.Add("姓名", typeof(String));
                //dtHZ.Columns.Add("電話", typeof(String));
                // dtHZ.Columns.Add("電子信箱", typeof(String));

                dtHZ.Columns.Add("問題類型", typeof(String));
                dtHZ.Columns.Add("問題分類", typeof(String));
                dtHZ.Columns.Add("狀態", typeof(String));
                dtHZ.Columns.Add("問題內容", typeof(String));
                dtHZ.Columns.Add("回覆內容", typeof(String));

                dtHZ.Columns.Add("建立日期", typeof(String));
                dtHZ.Columns.Add("回覆日期", typeof(String));

                _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString);
                cuQuery.search_type = Convert.ToInt32(Request.Params["search_type"]);
                cuQuery.searchcontent = Request.Params["searchcontent"];
                //  cuQuery.date_type = Convert.ToInt32(Request.Params["date_type"]);
                if (!string.IsNullOrEmpty(Request.Params["dateStart"]) && Request.Params["dateStart"]!="0")
                {
                    cuQuery.datestart = Convert.ToDateTime(Request.Params["dateStart"]);//建立時間
                }
                if (!string.IsNullOrEmpty(Request.Params["dateEnd"]) && Request.Params["dateEnd"] != "0")
                {
                    cuQuery.dateend = Convert.ToDateTime(Request.Params["dateEnd"]);
                }
                cuQuery.question_type = Convert.ToUInt32(Request.Params["qusetion_type"]);
                if (Convert.ToBoolean(Request.Params["radio2"]) == true)//待回覆
                {
                    cuQuery.question_status = 3;
                }
                else if (Convert.ToBoolean(Request.Params["radio3"]) == true)//已回覆
                {
                    cuQuery.question_status = 4;
                }
                else if (Convert.ToBoolean(Request.Params["radio4"]) == true)
                {
                    cuQuery.question_status = 2;
                }
                _dt = _ctactMgr.GetContactUsQuestionExcelList(cuQuery);
                if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
                {
                    System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
                }
                for (int i = 0; i < _dt.Rows.Count; i++)
                {
                    DataRow dr = dtHZ.NewRow();
                    dr[0] = _dt.Rows[i]["question_id"];
                    dr[1] = _dt.Rows[i]["question_company"];
                    dr[2] = _dt.Rows[i]["question_username"];
                    //dr[3] = _dt.Rows[i]["question_phone"];
                    //dr[4] = _dt.Rows[i]["question_email"];

                    dr[3] = _dt.Rows[i]["question_type_name"];
                    dr[4] = _dt.Rows[i]["question_problem_name"];
                    dr[5] = _dt.Rows[i]["question_status_name"];
                    dr[6] = _dt.Rows[i]["question_content"];


                    dr[8] = _dt.Rows[i]["question_createdate"];
                    if (_dt.Rows[i]["question_status"].ToString() == "0")
                    {
                        dr[9] = "~";
                        dr[7] = "";
                    }
                    else
                    {
                        dr[9] = _dt.Rows[i]["response_createdate"];
                        dr[7] = _dt.Rows[i]["response_content"];
                    }
                    dtHZ.Rows.Add(dr);
                }
                if (dtHZ.Rows.Count > 0)
                {
                    string fileName = DateTime.Now.ToString("聯絡客服列表_yyyyMMddHHmmss") + ".xls";
                    MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "聯絡客服列表_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
                    Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
                    Response.BinaryWrite(ms.ToArray());
                }
                else
                {
                    Response.Write("匯出數據不存在");
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                json = "{success:false,totalCount:0,data:[]}";
            }
        }
示例#3
0
        public JsonResult UpdateActive()
        {
            string json = string.Empty;
            ContactUsQuestionQuery query = new ContactUsQuestionQuery();
            _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString);
            try
            {
                if (!string.IsNullOrEmpty(Request.Params["id"]))
                {
                    query.question_id = Convert.ToUInt32(Request.Params["id"]);
                }

                if (!string.IsNullOrEmpty(Request.Params["active"]))
                {
                    query.question_status = Convert.ToUInt32(Request.Params["active"]);
                }
                if (query.question_id != 0)
                {
                    string sql = _ctactMgr.UpdateSql(query);
                    _ctactMgr.UpdateActive(sql);
                    return Json(new { success = "true", msg = "" });
                }
                else
                {
                    return Json(new { success = "false", msg = "" });
                }
            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);
                return Json(new { success = "false", msg = "" });
            }
        }