public JsonResult UpdateOrderQuestionActive() { string json = string.Empty; OrderQuestionQuery query = new OrderQuestionQuery(); _IOrderQuesMgr = new OrderQuestionMgr(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) { _IOrderQuesMgr.UpdateQuestionStatus(query); 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 = "" }); } }
/// <summary> /// 獲取回覆記錄列表 /// </summary> /// <returns>回覆記錄json格式數據</returns> public HttpResponseBase GetOrderQuestionResponseList() { string json = string.Empty; DataTable dtQuestionResponseList = new DataTable(); int totalCount = 0; OrderQuestionQuery query = new OrderQuestionQuery(); string question_id = Request.Params["question_id"]; if (!string.IsNullOrEmpty(question_id)) { query.question_id = Convert.ToUInt32(question_id); } query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; try { dtQuestionResponseList = _IOrderQuesMgr.GetList(query, out totalCount); if (dtQuestionResponseList.Rows.Count > 0) { #region // //for (int i = 0; i < dtQuestionResponseList.Rows.Count; i++) //{ // string user_id = dtQuestionResponseList.Rows[i]["user_id"].ToString(); // string product_id = dtQuestionResponseList.Rows[i]["product_id"].ToString(); // string item_id = string.Empty; // List<ProductItem> listProductItem = _IProductItemMgr.GetProductItemByID(Convert.ToInt32(product_id)); // if (listProductItem.Count > 0) // { // item_id = listProductItem[0].Item_Id.ToString(); // } // OrderMasterQuery orderMasterQuery = new OrderMasterQuery // { // User_Id = Convert.ToUInt32(dtQuestionResponseList.Rows[i]["user_id"]), // Item_Id = Convert.ToInt32(item_id) // }; // dtQuestionResponseList.Rows[i]["buyCount"] = _IOrderMasterMgr.GetBuyCount(orderMasterQuery); //} #endregion json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dtQuestionResponseList, Formatting.Indented, timeConverter) + "}"; } else { json = "{success:false,msg:0}"; } } 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,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase OrderQuestionSave() { OrderQuestion query = new OrderQuestion(); _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["orderid"])) { query.order_id = uint.Parse(Request.Params["orderid"]); } if (!string.IsNullOrEmpty(Request.Params["questiontype"])) { query.question_type = uint.Parse(Request.Params["questiontype"]); } if (!string.IsNullOrEmpty(Request.Params["name"])) { query.question_username = Request.Params["name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["email_id"])) { query.question_email = Request.Params["email_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["linkphone"])) { query.question_phone = Request.Params["linkphone"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["content"])) { query.question_content = Request.Params["content"].ToString(); } //回復方式 bool reply1 = false; bool reply2 = false; bool reply3 = false; if (!string.IsNullOrEmpty(Request.Params["reply1"])) { reply1 = Convert.ToBoolean(Request.Params["reply1"]); } if (!string.IsNullOrEmpty(Request.Params["reply2"])) { reply2 = Convert.ToBoolean(Request.Params["reply2"]); } if (!string.IsNullOrEmpty(Request.Params["reply3"])) { reply3 = Convert.ToBoolean(Request.Params["reply3"]); } if (reply3) { if (!string.IsNullOrEmpty(Request.Params["ddlstatus"])) { query.question_reply_time = int.Parse(Request.Params["ddlstatus"]); } else { query.question_reply_time = 4; } } else { query.question_reply_time = 0; } if (reply1) { query.question_reply = query.question_reply + "1|"; if (reply2) { query.question_reply = query.question_reply + "1|"; if (reply3) { query.question_reply = query.question_reply + "1"; } else { query.question_reply = query.question_reply + "0"; } } else { query.question_reply = query.question_reply + "0|"; if (reply3) { query.question_reply = query.question_reply + "1"; } else { query.question_reply = query.question_reply + "0"; } } } else { query.question_reply = query.question_reply + "0|"; if (reply2) { query.question_reply = query.question_reply + "1|"; if (reply3) { query.question_reply = query.question_reply + "1"; } else { query.question_reply = query.question_reply + "0"; } } else { query.question_reply = query.question_reply + "0|"; if (reply3) {//當電話被選擇時在判斷在什麼時間段 query.question_reply = query.question_reply + "1"; } else { query.question_reply = query.question_reply + "0"; } } } //System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList; //query.question_ipfrom = addlist[0].ToString(); query.question_ipfrom = CommonFunction.GetIP4Address(Request.UserHostAddress.ToString()); query.question_status = 0; DateTime createdate = DateTime.Now; query.question_createdate = uint.Parse(CommonFunction.GetPHPTime(createdate.ToString()).ToString()); _IOrderQuesMgr.InsertOrderQuestion(query); json = "{success:true}";//返回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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase ReplyQuestion() { string timestr = string.Empty; string path = Server.MapPath(xmlPath); SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); SiteConfig Mail_From = _siteConfigMgr.GetConfigByName("Mail_From"); SiteConfig Mail_Host = _siteConfigMgr.GetConfigByName("Mail_Host"); SiteConfig Mail_Port = _siteConfigMgr.GetConfigByName("Mail_Port"); SiteConfig Mail_UserName = _siteConfigMgr.GetConfigByName("Mail_UserName"); SiteConfig Mail_UserPasswd = _siteConfigMgr.GetConfigByName("Mail_UserPasswd"); string EmailFrom = Mail_From.Value;//發件人郵箱 string SmtpHost = Mail_Host.Value;//smtp服务器 string SmtpPort = Mail_Port.Value;//smtp服务器端口 string EmailUserName = Mail_UserName.Value;//郵箱登陸名 string EmailPassWord = Mail_UserPasswd.Value;//郵箱登陸密碼 string json = string.Empty; _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); _IOrderResponseMgr = new OrderResponseMgr(mySqlConnectionString); OrderQuestionQuery query = new OrderQuestionQuery(); OrderResponse ormodel = new OrderResponse(); SmsQuery smsquery = new SmsQuery(); //if (!string.IsNullOrEmpty(Request.Params["question_content"])) //{ // query.question_content = Request.Params["question_content"]; //} //string order_id = Request.Params["OrderId"].ToString(); //if (!string.IsNullOrEmpty(order_id)) //{ // query.order_id = Convert.ToUInt32(order_id); //} try { if (!string.IsNullOrEmpty(Request.Params["question_id"])) { query.question_id = Convert.ToUInt32(Request.Params["question_id"]); ormodel.question_id = query.question_id; } if (!string.IsNullOrEmpty(Request.Params["order_id"])) { smsquery.order_id = Convert.ToInt32(Request.Params["order_id"]); } //if (!string.IsNullOrEmpty(Request.Params["status"])) //{ // query.question_status = Convert.ToUInt32(Request.Params["status"]); //} if (!string.IsNullOrEmpty(Request.Params["response_content"])) { ormodel.response_content = Request.Params["response_content"].Replace("\\", "\\\\"); ; smsquery.content = ormodel.response_content.Replace("\\", "\\\\"); ; } if (!string.IsNullOrEmpty(Request.Params["question_createdate"])) { timestr = Request.Params["question_createdate"]; } if (!string.IsNullOrEmpty(Request.Params["question_username"])) { query.question_username = Request.Params["question_username"]; } if (!string.IsNullOrEmpty(Request.Params["this_question_email"])) { query.question_email = Request.Params["this_question_email"]; } if (!string.IsNullOrEmpty(Request.Params["question_phone"])) { smsquery.mobile = Request.Params["question_phone"].ToString(); } //回複方式 bool reply1 = false; bool reply2 = false; bool reply3 = false; if (!string.IsNullOrEmpty(Request.Params["reply_mail"])) { reply1 = Convert.ToBoolean(Request.Params["reply_mail"]); } if (!string.IsNullOrEmpty(Request.Params["reply_sms"])) { reply2 = Convert.ToBoolean(Request.Params["reply_sms"]); } if (!string.IsNullOrEmpty(Request.Params["reply_phone"])) { reply3 = Convert.ToBoolean(Request.Params["reply_phone"]); } //如果選擇結案就更新問題狀態 //更新order_question表狀態 query.question_status = 1; _IOrderQuesMgr.UpdateQuestionStatus(query); //獲取數據往回覆表添加數據 ormodel.user_id = uint.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); ormodel.response_ipfrom = CommonFunction.GetIP4Address(Request.UserHostAddress.ToString()); ; ormodel.response_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString())); //判斷選擇的回複方式 if (reply1 || !reply1 && !reply2 && !reply3) { ormodel.response_type = 1; _IOrderResponseMgr.insert(ormodel); FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/OrderQuestionResponse.html"), FileMode.OpenOrCreate, FileAccess.Read); StreamReader sr = new StreamReader(fs, Encoding.UTF8); string strTemp = sr.ReadToEnd(); sr.Close(); fs.Close(); strTemp = strTemp.Replace("{{$s_datetime$}}", timestr);//添加提問時間 strTemp = strTemp.Replace("{{$s_username$}}", query.question_username);//添加提問用戶名 strTemp = strTemp.Replace("{{$consultInfo$}}", query.question_content);//添加提問內容 strTemp = strTemp.Replace("{{$consultAnwser$}}", ormodel.response_content.Replace("\\\\", "\\")); sendmail(EmailFrom, FromName, query.question_email, query.question_username, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord); } else if (reply2) { ormodel.response_type = 2; _IOrderResponseMgr.insert(ormodel); smsquery.type = 11;//10表示聯絡客服列表保存過去的 smsquery.send = 0; smsquery.trust_send = "9"; smsquery.created = DateTime.Now; smsquery.modified = DateTime.Now; _ISmsMgr = new SmsMgr(mySqlConnectionString); _ISmsMgr.InsertSms(smsquery); } else if (reply3) { ormodel.response_type = 3; _IOrderResponseMgr.insert(ormodel); } //if (!reply1 && !reply2 && !reply3) //{ // ormodel.response_type = 4; // _IOrderResponseMgr.insert(ormodel); //} json = "{success:true}"; } 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,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetDDL() { List<Parametersrc> stores = new List<Parametersrc>(); _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); string json = string.Empty; try { int totalCount = 0; stores = _IOrderQuesMgr.GetDDL(); json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores) + "}";//返回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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public void OrderQuestionExcel() { OrderQuestionQuery query = new OrderQuestionQuery(); _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["ddlSel"])) { query.ddlSel = Convert.ToInt32(Request.Params["ddlSel"]); } if (!string.IsNullOrEmpty(Request.Params["selcontent"])) { query.selcontent = Request.Params["selcontent"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["ddtSel"])) { query.ddtSel = Convert.ToInt32(Request.Params["ddtSel"]); } if (!string.IsNullOrEmpty(Request.Params["time_start"]) && Request.Params["time_start"] != "null") { query.question_createdates = Convert.ToDateTime(Request.Params["time_start"]); query.time_start = Convert.ToUInt32(CommonFunction.GetPHPTime(query.question_createdates.ToString())); } if (!string.IsNullOrEmpty(Request.Params["time_end"]) && Request.Params["time_end"] != "null") { query.response_createdates = Convert.ToDateTime(Request.Params["time_end"]); query.time_end = Convert.ToUInt32(CommonFunction.GetPHPTime(query.response_createdates.ToString())); } if (!string.IsNullOrEmpty(Request.Params["ddrSel"])) { query.question_type = Convert.ToUInt32(Request.Params["ddrSel"]); } if (!string.IsNullOrEmpty(Request.Params["ddlstatus"])) { query.ddlstatus = Request.Params["ddlstatus"]; } DataTable dtMain = _IOrderQuesMgr.GetOrderQuestionExcel(query); DataTable new_Table = new DataTable(); #region new_Table表頭 new_Table.Columns.Add(new DataColumn("問題流水號")); new_Table.Columns.Add(new DataColumn("付款單號")); new_Table.Columns.Add(new DataColumn("姓名")); //new_Table.Columns.Add(new DataColumn("聯絡電話")); //new_Table.Columns.Add(new DataColumn("電子信箱")); new_Table.Columns.Add(new DataColumn("問題分類")); new_Table.Columns.Add(new DataColumn("狀態")); new_Table.Columns.Add(new DataColumn("問題內容")); new_Table.Columns.Add(new DataColumn("回覆內容")); new_Table.Columns.Add(new DataColumn("建立日期")); new_Table.Columns.Add(new DataColumn("回覆日期")); #endregion for (int i = 0; i < dtMain.Rows.Count; i++) { DataRow dr1 = new_Table.NewRow(); dr1["問題流水號"] = dtMain.Rows[i]["question_id"].ToString(); dr1["付款單號"] = dtMain.Rows[i]["order_id"].ToString(); dr1["姓名"] = dtMain.Rows[i]["question_username"].ToString(); //dr1["聯絡電話"] = dtMain.Rows[i]["question_phone"].ToString(); //dr1["電子信箱"] = dtMain.Rows[i]["question_email"].ToString(); dr1["問題分類"] = dtMain.Rows[i]["question_type_name"].ToString(); dr1["狀態"] = dtMain.Rows[i]["question_status_name"].ToString(); dr1["問題內容"] = dtMain.Rows[i]["question_content"].ToString(); //CommonFunction.GetNetTime(item.question_createdate); dr1["建立日期"] = CommonFunction.GetNetTime(uint.Parse(dtMain.Rows[i]["question_createdate"].ToString())); if (dtMain.Rows[i]["question_status"].ToString() == "0") { dr1["回覆日期"] = "~"; dr1["回覆內容"] = ""; } else { dr1["回覆內容"] = dtMain.Rows[i]["response_content"].ToString(); if (!string.IsNullOrEmpty(dtMain.Rows[i]["response_createdate"].ToString())) { dr1["回覆日期"] = CommonFunction.GetNetTime(uint.Parse(dtMain.Rows[i]["response_createdate"].ToString())); } else { dr1["回覆日期"] = "~"; } } new_Table.Rows.Add(dr1); } if (new_Table.Rows.Count > 0) { string fileName = "訂單問題" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; MemoryStream ms = ExcelHelperXhf.ExportDT(new_Table, "訂單問題" + 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); } }
public HttpResponseBase OrderQuestionlist() { List<OrderQuestionQuery> store = new List<OrderQuestionQuery>(); string json = string.Empty; int totalCount = 0; _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); try { OrderQuestionQuery query = new OrderQuestionQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } if (!string.IsNullOrEmpty(Request.Params["ddlSel"])) { query.ddlSel = Convert.ToInt32(Request.Params["ddlSel"]); } if (!string.IsNullOrEmpty(Request.Params["selcontent"])) { query.selcontent = Request.Params["selcontent"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["ddtSel"])) { query.ddtSel = Convert.ToInt32(Request.Params["ddtSel"]); } if (!string.IsNullOrEmpty(Request.Params["time_start"])) { query.question_createdates = Convert.ToDateTime(Request.Params["time_start"]); query.time_start = Convert.ToUInt32(CommonFunction.GetPHPTime(query.question_createdates.ToString())); } if (!string.IsNullOrEmpty(Request.Params["time_end"])) { query.response_createdates = Convert.ToDateTime(Request.Params["time_end"]); query.time_end = Convert.ToUInt32(CommonFunction.GetPHPTime(query.response_createdates.ToString())); } if (!string.IsNullOrEmpty(Request.Params["ddrSel"])) { query.question_type = Convert.ToUInt32(Request.Params["ddrSel"]); } if (!string.IsNullOrEmpty(Request.Params["ddlstatus"])) { query.ddlstatus = Request.Params["ddlstatus"]; } else { query.ddlstatus = "-1"; } if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆 { query.question_id = Convert.ToUInt32(Request.Params["relation_id"]); } store = _IOrderQuesMgr.GetOrderQuestionList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { if (Convert.ToBoolean(Request.Params["isSecret"])) { if (!string.IsNullOrEmpty(item.question_username)) { item.question_username = item.question_username.Substring(0, 1) + "**"; } item.question_email = item.question_email.Split('@')[0] + "@***"; if (item.question_phone.ToString().Length > 3) { item.question_phone = item.question_phone.Substring(0, 3) + "***"; } else { item.question_phone = item.question_phone + "***"; } } item.question_createdates = CommonFunction.GetNetTime(item.question_createdate); item.response_createdates = CommonFunction.GetNetTime(item.response_createdate); } //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, 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; }