/// <summary> /// 新增編輯類別信息 /// </summary> /// <returns></returns> public HttpResponseBase ProductCategorySave() { string json = string.Empty; string jsonStr = string.Empty; CategoryQuery cq = new CategoryQuery(); IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString); string errorInfo = string.Empty; try { _proCategoryImplMgr = new CategoryMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["category_id"])) { cq.category_id = Convert.ToUInt32(Request.Params["category_id"]); } CategoryQuery oldCq = _proCategoryImplMgr.GetProductCategoryById(cq); if (oldCq != null) { cq.banner_image = oldCq.banner_image; cq.category_image_in = oldCq.category_image_in; cq.category_image_out = oldCq.category_image_out; cq.category_image_app = oldCq.category_image_app; } #region 上傳圖片 try { if (Request.Files.Count != 0) { string path = Server.MapPath(xmlPath); SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format"); SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME"); SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD"); //擴展名、最小值、最大值 string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value; string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value; string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value; string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址 for (int a = 0; a < Request.Files.Count; a++) { string fileName = string.Empty; //當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 HttpPostedFileBase file = Request.Files[a]; fileName = Path.GetFileName(file.FileName); if (string.IsNullOrEmpty(fileName)) { continue; } bool result = false; string NewFileName = string.Empty; string ServerPath = string.Empty; string ErrorMsg = string.Empty; string oldFileName = string.Empty; //舊文件名 //生成隨機數,用於圖片的重命名 Random rand = new Random(); int newRand = rand.Next(1000, 9999); fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = newRand + fileExtention; //判斷目錄是否存在,不存在則創建 CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/')); fileName = NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); try { //上傳 FileManagement fileLoad = new FileManagement(); result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { switch (a) { case 0: cq.banner_image = fileName; break; case 1: cq.category_image_in = fileName; break; case 2: cq.category_image_out = fileName; break; case 3: cq.category_image_app = fileName; break; default: break; } } else { //圖片上傳失敗則圖片名稱為原有圖片名稱 switch (a) { case 0: cq.banner_image = fileName; break; case 1: cq.category_image_in = fileName; break; case 2: cq.category_image_out = fileName; break; case 3: cq.category_image_app = fileName; break; default: break; } errorInfo += "第" + (a + 1) + "張" + ErrorMsg + "<br/>"; } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); jsonStr = "{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); jsonStr = "{success:false,msg:'圖片上傳失敗'}"; } #endregion if (!string.IsNullOrEmpty(Request.Params["comboFrontCage"])) { cq.category_father_id = Convert.ToUInt32(Request.Params["comboFrontCage"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["category_name"])) { cq.category_name = Request.Params["category_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["category_sort"])) { cq.category_sort = Convert.ToUInt32(Request.Params["category_sort"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["category_display"])) { cq.category_display = Convert.ToUInt32(Request.Params["category_display"]); } if (!string.IsNullOrEmpty(Request.Params["categorylinkmode"])) { cq.category_link_mode = Convert.ToUInt32(Request.Params["categorylinkmode"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["category_link_url"])) { cq.category_link_url = Request.Params["category_link_url"].ToString(); } //if (!string.IsNullOrEmpty(Request.Params["photo"])) //{ // #region 上傳圖片 // try // { // if (Request.Files.Count != 0) // { // string path = Server.MapPath(xmlPath); // SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); // SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format"); // SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); // SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); // SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME"); // SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD"); // //擴展名、最小值、最大值 // string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value; // string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value; // string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value; // string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址 // //生成隨機數,用於圖片的重命名 // Random rand = new Random(); // int newRand = rand.Next(1000, 9999); // //獲取上傳的圖片 // HttpPostedFileBase file = Request.Files[0]; // string fileName = string.Empty;//當前文件名 // string fileExtention = string.Empty;//當前文件的擴展名 // fileName = Path.GetFileName(file.FileName); // if (!string.IsNullOrEmpty(fileName)) // { // bool result = false; // string NewFileName = string.Empty; // fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); // //NewFileName = pacdModel.event_id + newRand + fileExtention;//圖片重命名為event_id+4位隨機數+擴展名 // NewFileName = newRand + fileExtention; // string ServerPath = string.Empty; // //判斷目錄是否存在,不存在則創建 // CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/')); // // returnName += promoPath + NewFileName; // fileName = NewFileName; // NewFileName = localPromoPath + NewFileName;//絕對路徑 // ServerPath = Server.MapPath(imgLocalServerPath + promoPath); // string ErrorMsg = string.Empty; // //上傳之前刪除已有的圖片 // //string oldFileName = olderpcmodel.banner_image; // FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); // List<string> tem = ftp.GetFileList(); // //if (tem.Contains(oldFileName)) // //{ // // //FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); // // //ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 // // //DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 // //} // try // { // //上傳 // FileManagement fileLoad = new FileManagement(); // result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); // if (result)//上傳成功 // { // cq.banner_image = fileName; // } // } // catch (Exception ex) // { // Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); // logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message); // logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; // log.Error(logMessage); // jsonStr = "{success:false,msg:'圖片上傳失敗'}"; // //pacdModel.banner_image = olderpcmodel.banner_image; // } // } // else // { // //pacdModel.banner_image = olderpcmodel.banner_image; // } // } // } // 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); // jsonStr = "{success:false,msg:'圖片上傳失敗'}"; // //pacdModel.banner_image = olderpcmodel.banner_image; // } // #endregion //} if (!string.IsNullOrEmpty(Request.Params["banner_status"])) { cq.banner_status = Convert.ToUInt32(Request.Params["banner_status"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"])) { cq.banner_link_mode = Convert.ToUInt32(Request.Params["banner_link_mode"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["banner_link_url"])) { cq.banner_link_url = Request.Params["banner_link_url"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["startdate"])) { cq.banner_show_start = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["startdate"].ToString())); } if (!string.IsNullOrEmpty(Request.Params["enddate"])) { cq.banner_show_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["enddate"].ToString())); } if (!string.IsNullOrEmpty(Request.Params["short_description"])) { cq.short_description = Request.Params["short_description"].ToString(); } if (string.IsNullOrEmpty(Request.Params["category_id"])) { cq.category_ipfrom = CommonFunction.GetClientIP(); cq.category_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); cq.category_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); cq.status = 1; _proCategoryImplMgr = new CategoryMgr(mySqlConnectionString); int i = _proCategoryImplMgr.ProductCategorySave(cq); if (i > 0) { json = "{success:true}"; } } else { //_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString); //cq.category_id = Convert.ToUInt32(Request.Params["category_id"]); //CategoryQuery oldCq = _proCategoryImplMgr.GetProductCategoryById(cq); //if (!string.IsNullOrEmpty(Request.Params["comboFrontCage"])) //{ // cq.category_father_id = Convert.ToUInt32(Request.Params["comboFrontCage"].ToString()); //} //else //{ // cq.category_father_id = oldCq.category_father_id; //} //if (!string.IsNullOrEmpty(Request.Params["category_name"])) //{ // cq.category_name = Request.Params["category_name"].ToString(); //} //else //{ // cq.category_name = oldCq.category_name; //} //if (!string.IsNullOrEmpty(Request.Params["category_sort"])) //{ // cq.category_sort = Convert.ToUInt32(Request.Params["category_sort"].ToString()); //} //else //{ // cq.category_sort = oldCq.category_sort; //} //if (!string.IsNullOrEmpty(Request.Params["category_display"])) //{ // cq.category_display = Convert.ToUInt32(Request.Params["category_display"]); //} //else //{ // cq.category_display = oldCq.category_display; //} //if (!string.IsNullOrEmpty(Request.Params["categorylinkmode"])) //{ // cq.category_link_mode = Convert.ToUInt32(Request.Params["categorylinkmode"].ToString()); //} //else //{ // cq.category_link_mode = oldCq.category_link_mode; //} //cq.category_link_url = Request.Params["category_link_url"].ToString(); //if (!string.IsNullOrEmpty(Request.Params["photo"])) //{ // #region 上傳圖片 // try // { // if (Request.Files.Count != 0) // { // string path = Server.MapPath(xmlPath); // SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); // SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format"); // SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); // SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); // SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME"); // SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD"); // 擴展名、最小值、最大值 // string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value; // string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value; // string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value; // string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址 // 生成隨機數,用於圖片的重命名 // Random rand = new Random(); // int newRand = rand.Next(1000, 9999); // 獲取上傳的圖片 // HttpPostedFileBase file = Request.Files[0]; // string fileName = string.Empty;//當前文件名 // string fileExtention = string.Empty;//當前文件的擴展名 // fileName = Path.GetFileName(file.FileName); // if (!string.IsNullOrEmpty(fileName)) // { // bool result = false; // string NewFileName = string.Empty; // fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); // NewFileName = pacdModel.event_id + newRand + fileExtention;//圖片重命名為event_id+4位隨機數+擴展名 // NewFileName = newRand + fileExtention; // string ServerPath = string.Empty; // 判斷目錄是否存在,不存在則創建 // CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/')); // returnName += promoPath + NewFileName; // fileName = NewFileName; // NewFileName = localPromoPath + NewFileName;//絕對路徑 // ServerPath = Server.MapPath(imgLocalServerPath + promoPath); // string ErrorMsg = string.Empty; // 上傳之前刪除已有的圖片 // string oldFileName = oldCq.banner_image; // FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); // List<string> tem = ftp.GetFileList(); // if (tem.Contains(oldFileName)) // { // FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); // ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 // DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 // } // try // { // 上傳 // FileManagement fileLoad = new FileManagement(); // result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); // if (result)//上傳成功 // { // cq.banner_image = fileName; // } // } // catch (Exception ex) // { // Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); // logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message); // logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; // log.Error(logMessage); // jsonStr = "{success:false,msg:'圖片上傳失敗'}"; // cq.banner_image = oldCq.banner_image; // } // } // else // { // cq.banner_image = oldCq.banner_image; // } // } // } // 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); // jsonStr = "{success:false,msg:'圖片上傳失敗'}"; // cq.banner_image = oldCq.banner_image; // } // #endregion //} //else //{ // cq.banner_image = oldCq.banner_image; //} //if (!string.IsNullOrEmpty(Request.Params["banner_status"])) //{ // cq.banner_status = Convert.ToUInt32(Request.Params["banner_status"].ToString()); //} //else //{ // cq.banner_status = oldCq.banner_status; //} //if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"])) //{ // cq.banner_link_mode = Convert.ToUInt32(Request.Params["banner_link_mode"].ToString()); //} //else //{ // cq.banner_link_mode = oldCq.banner_link_mode; //} //cq.banner_link_url = Request.Params["banner_link_url"].ToString(); //cq.short_description = Request.Params["short_description"].ToString(); //cq.banner_show_start = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["startdate"].ToString())); //cq.banner_show_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["enddate"].ToString())); cq.category_ipfrom = CommonFunction.GetClientIP(); cq.category_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); int j = _proCategoryImplMgr.ProductCategorySave(cq); if (j > 0) { 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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetWebContent() { string json = string.Empty; string jsonStr = string.Empty; EdmContentQuery cq = new EdmContentQuery(); IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["webtext"])) { jsonStr = Request.Params["webtext"].ToString(); Uri httpURL = new Uri(jsonStr); //HttpWebRequest类继承于WebRequest,并没有自己的构造函数,需通过WebRequest的Creat方法 建立,并进行强制的类型转换 httpReq = (HttpWebRequest)WebRequest.Create(httpURL); //通过HttpWebRequest的GetResponse()方法建立HttpWebResponse,强制类型转换 httpResp = (HttpWebResponse)httpReq.GetResponse(); //GetResponseStream()方法获取HTTP响应的数据流,并尝试取得URL中所指定的网页内容 //若成功取得网页的内容,则以System.IO.Stream形式返回,若失败则产生ProtoclViolationException错 误。在此正确的做法应将以下的代码放到一个try块中处理。这里简单处理 Stream respStream = httpResp.GetResponseStream(); //返回的内容是Stream形式的,所以可以利用StreamReader类获取GetResponseStream的内容,并以 //StreamReader类的Read方法依次读取网页源程序代码每一行的内容,直至行尾(读取的编码格式:UTF8) StreamReader respStreamReader = new StreamReader(respStream, Encoding.UTF8); byteRead = respStreamReader.Read(cbuffer, 0, 256); while (byteRead != 0) { string strResp = new string(cbuffer, 0, byteRead); strBuff = strBuff + strResp; byteRead = respStreamReader.Read(cbuffer, 0, 256); } respStream.Close(); json = strBuff; } //int i = 0; //if (i > 0) //{ // 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 = ""; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 新增編輯區域包信息 /// </summary> /// <returns></returns> public HttpResponseBase AreaPactetSave() { string json = string.Empty; AreaPacket ap = new AreaPacket(); IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString); try { if (string.IsNullOrEmpty(Request.Params["id"])) { if (!string.IsNullOrEmpty(Request.Params["name"])) { ap.packet_name = Request.Params["name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["element_type"])) { ap.element_type = Convert.ToInt32(Request.Params["element_type"]); } if (!string.IsNullOrEmpty(Request.Params["packet_desc"])) { ap.packet_desc = Request.Params["packet_desc"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["show_number"])) { ap.show_number = Convert.ToInt32(Request.Params["show_number"]); } if (!string.IsNullOrEmpty(Request.Params["packet_sort"])) { ap.packet_sort = Convert.ToInt32(Request.Params["packet_sort"].ToString()); } ap.create_userid = (Session["caller"] as Caller).user_id; ap.update_userid = (Session["caller"] as Caller).user_id; ap.packet_createdate = DateTime.Now; ap.packet_updatedate = DateTime.Now; int i = _iareaPacketMgr.AreaPacketSave(ap); if (i > 0) { json = "{success:true}"; } } else { AreaPacket areaPacketTemp = new AreaPacket(); areaPacketTemp.packet_id = Convert.ToInt32(Request.Params["id"]); AreaPacket oldap = _iareaPacketMgr.GetModelById(areaPacketTemp); ap.packet_id = Convert.ToInt32(Request.Params["id"]); ap.packet_name = Request.Params["name"].ToString(); if (!string.IsNullOrEmpty(Request.Params["element_type"])) { ap.element_type = Convert.ToInt32(Request.Params["element_type"]); } else { ap.element_type = oldap.element_type; } ap.packet_desc = Request.Params["packet_desc"].ToString(); ap.show_number = Convert.ToInt32(Request.Params["show_number"]); ap.packet_sort = Convert.ToInt32(Request.Params["packet_sort"].ToString()); ap.update_userid = (Session["caller"] as Caller).user_id; ap.packet_updatedate = DateTime.Now; ap.packet_status = oldap.packet_status; int j = _iareaPacketMgr.AreaPacketSave(ap); if (j > 0) { 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:true,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// /// </summary> /// <returns></returns> public HttpResponseBase SaveProductConsultAnswer() { 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; string jsonStr = string.Empty; ProductConsultQuery query = new ProductConsultQuery(); IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString); _productconsultMgr = new ProductConsultMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["consult_id"])) { query.consult_id = Convert.ToInt32(Request.Params["consult_id"]); } if (!string.IsNullOrEmpty(Request.Params["answer_status"])) { if (Convert.ToInt32(Request.Params["answer_status"]) == 2) { query.answer_status = 2; query.answer_user = ((Caller)Session["caller"]).user_id; query.delay_reason = Request.Params["delay_reason"].ToString(); _productconsultMgr.UpdateAnswerStatus(query); json = "{success:true}"; } else { query.answer_status = 3; if (!string.IsNullOrEmpty(Request.Params["status"])) { query.status = Convert.ToInt32(Request.Params["status"]); } if (!string.IsNullOrEmpty(Request.Params["is_sendEmail"])) { query.is_sendEmail = Convert.ToInt32(Request.Params["is_sendEmail"]); } if (!string.IsNullOrEmpty(Request.Params["consult_answer"])) { query.consult_answer = Request.Params["consult_answer"].ToString(); } query.answer_date = DateTime.Now; query.answer_user = ((Caller)Session["caller"]).user_id; int i = _productconsultMgr.SaveProductConsultAnswer(query); if (!string.IsNullOrEmpty(Request.Params["is_sendEmail"])) { int j = Convert.ToInt32(Request.Params["is_sendEmail"]); if (j == 1 && i > 0) { string userName = string.Empty; string product_name = string.Empty; string consultInfo = string.Empty; string answerInfo = string.Empty; string consultUrl = string.Empty; string productUrl = string.Empty; string userEmail = string.Empty; if (!string.IsNullOrEmpty(Request.Params["user_name"])) { userName = Request.Params["user_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["user_email"])) { userEmail = Request.Params["user_email"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["consult_info"])) { consultInfo = Request.Params["consult_info"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["consult_answer"])) { answerInfo = Request.Params["consult_answer"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["product_url"])) { productUrl = Request.Params["product_url"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } if (!string.IsNullOrEmpty(Request.Params["consult_url"])) { consultUrl = Request.Params["consult_url"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { query.item_id = Convert.ToInt32(Request.Params["item_id"].ToString()); } ProductConsultQuery queryTemp = _productconsultMgr.GetProductInfo(query); FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/productConsultAnwser.html"), FileMode.OpenOrCreate, FileAccess.Read); StreamReader sr = new StreamReader(fs, Encoding.UTF8); string strTemp = sr.ReadToEnd(); sr.Close(); fs.Close(); //if (queryTemp.spec_name1 == "" && queryTemp.spec_name2 == "") //{ // product_name = queryTemp.brand_name + queryTemp.product_name; //} //else //{ // product_name = queryTemp.brand_name + queryTemp.product_name + "(" + queryTemp.spec_name1 + " " + queryTemp.spec_name2 + ")"; //} product_name = queryTemp.product_name; strTemp = strTemp.Replace("{{$username$}}", userName); strTemp = strTemp.Replace("{{$productName$}}", product_name); strTemp = strTemp.Replace("{{$consultInfo$}}", consultInfo); strTemp = strTemp.Replace("{{$consultAnwser$}}", answerInfo); strTemp = strTemp.Replace("{{$productUrl$}}", productUrl); sendmail(EmailFrom, FromName, userEmail, userName, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord); } } if (i > 0) { 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:true,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }