public HttpResponseBase EventChinaTrustBagSave() { string json = string.Empty; EventChinaTrustBagQuery query = new EventChinaTrustBagQuery(); EventChinaTrustBagQuery oldModel = new EventChinaTrustBagQuery(); try { if (!string.IsNullOrEmpty(Request.Params["event_id"])) { query.event_id = Request.Params["event_id"]; } if (!string.IsNullOrEmpty(Request.Params["bag_name"])) { query.bag_name = Request.Params["bag_name"]; } if (!string.IsNullOrEmpty(Request.Params["bag_desc"])) { query.bag_desc = Request.Params["bag_desc"]; } if (!string.IsNullOrEmpty(Request.Params["bag_banner"])) { query.bag_banner = Request.Params["bag_banner"]; } if (!string.IsNullOrEmpty(Request.Params["bag_start_time"])) { query.bag_start_time =Convert.ToDateTime( Request.Params["bag_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["bag_end_time"])) { query.bag_end_time = Convert.ToDateTime(Request.Params["bag_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["bag_show_start_time"])) { query.bag_show_start_time = Convert.ToDateTime(Request.Params["bag_show_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["bag_show_end_time"])) { query.bag_show_end_time =Convert.ToDateTime(Request.Params["bag_show_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["product_number"])) { query.product_number =Convert.ToInt32(Request.Params["product_number"]); } if (string.IsNullOrEmpty(Request.Params["bag_id"]))//新增 { query.bag_create_user=(Session["caller"] as Caller).user_id; query.bag_update_user = (Session["caller"] as Caller).user_id; query.bag_create_time = DateTime.Now; query.bag_update_time = query.bag_create_time; } else//編輯 { query.bag_id = Convert.ToInt32(Request.Params["bag_id"]); query.bag_update_time = DateTime.Now; query.bag_update_user = (Session["caller"] as Caller).user_id; } _eventChinaTrustBag = new EventChinaTrustBagMgr(mySqlConnectionString); #region 上傳圖片 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_Min_Element"); 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 + PaperPath;//圖片存儲地址 if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 FileManagement fileLoad = new FileManagement(); fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localPromoPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); string ErrorMsg = string.Empty; if (query.bag_id != 0) { oldModel = _eventChinaTrustBag.GetSinggleData(query); if (oldModel.bag_banner != "") { string oldFileName = oldModel.bag_banner; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除 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); } } } try { Resource.CoreMessage = new CoreResource("Product"); bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.bag_banner = fileName; } } 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); } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonStr = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); } } } else { query.bag_banner = oldModel.bag_banner; } #endregion if (_eventChinaTrustBag.EventChinaTrustBagSave(query) > 0) { json = "{success:true}"; } else { json = "{success:false}"; } } 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; }
/// <summary> /// 會員活動新增編輯 /// </summary> /// <returns></returns> public HttpResponseBase SaveMemberEvent() { string json = string.Empty; try { MemberEventQuery query = new MemberEventQuery(); _memberEvent = new MemberEventMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["rowID"])) { query.rowID = int.Parse(Request.Params["rowID"]); } query.me_name = Request.Params["me_name"]; query.me_desc = Request.Params["me_desc"]; query.event_id = Request.Params["event_id"]; if (!string.IsNullOrEmpty(Request.Params["me_startdate"])) { query.me_startdate = DateTime.Parse(Request.Params["me_startdate"]); } if (!string.IsNullOrEmpty(Request.Params["me_enddate"])) { query.me_enddate = DateTime.Parse(Request.Params["me_enddate"]); } if (!string.IsNullOrEmpty(Request.Params["me_birthday"])) { //query.me_birthday = int.Parse(Request.Params["me_birthday"]); if (Request.Params["me_birthday"] == "1") { query.me_birthday = 1; } else { query.me_birthday = 0; } } if (!string.IsNullOrEmpty(Request.Params["me_bonus_onetime"])) { if (Request.Params["me_bonus_onetime"] == "1") { query.me_bonus_onetime = 1; } else { query.me_bonus_onetime = 0; } } if (!string.IsNullOrEmpty(Request.Params["me_banner_link"])) { query.me_banner_link = Request.Params["me_banner_link"]; } if (!string.IsNullOrEmpty(Request.Params["code"])) { query.ml_code = Request.Params["code"].TrimEnd(','); } else { query.ml_code = "0"; } if (!string.IsNullOrEmpty(Request.Params["et_id"])) { query.et_id = int.Parse(Request.Params["et_id"]); } //query.et_name = Request.Params["et_name"]; switch (Request.Params["et_name"]) { case "1": query.et_name = "DD"; query.et_date_parameter = ""; break; case "2": query.et_name = "WW"; if (!string.IsNullOrEmpty(Request.Params["week"])) { query.et_date_parameter = Request.Params["week"].TrimEnd(','); } break; case "3": query.et_name = "MM"; if (!string.IsNullOrEmpty(Request.Params["month"])) { query.et_date_parameter = Request.Params["month"].TrimEnd(','); } break; } #region 處理每天的開始結束時間 query.et_starttime = Request.Params["et_starttime"]; query.et_endtime = Request.Params["et_endtime"]; #endregion query.k_user = (Session["caller"] as Caller).user_id; query.m_user = (Session["caller"] as Caller).user_id; query.k_date = DateTime.Now; query.m_date = query.k_date; string event_json=_memberEvent.IsGetEventID(query.event_id); if (event_json.IndexOf("true") > 0) { #region 判斷數據不能重複 if (_memberEvent.IsRepeat(query))//不重複 { #region 上傳圖片 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_Min_Element"); 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 localMemberEventPath = imgLocalPath + MemberEventPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); int totalCount = 0; MemberEventQuery oldQuery = _memberEvent.Query(new MemberEventQuery { rowID = query.rowID }, out totalCount).FirstOrDefault(); if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string[] dirPath = new string[2]; //dirPath[0] = NewFileName.Substring(0, 2)+"/"; //dirPath[1] = NewFileName.Substring(2, 2)+"/"; string ServerPath = string.Empty; FTP f_cf = new FTP(); CreateFolder(localMemberEventPath, dirPath); fileName = NewFileName + fileExtention; NewFileName = localMemberEventPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + MemberEventPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (query.rowID != 0) { if (oldQuery.me_big_banner != "") { string oldFileName = oldQuery.me_big_banner; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localMemberEventPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localMemberEventPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localMemberEventPath + oldFileName); } } } try { Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.me_big_banner = fileName; } } 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); } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonStr = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { query.me_big_banner = oldQuery.me_big_banner; } } #endregion if (_memberEvent.MemberEventSave(query) > 0) { //json = "{success:true}"; if (!string.IsNullOrEmpty(Request.Params["rowID"])) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:true,msg:'新增成功!'}"; } } else { if (!string.IsNullOrEmpty(Request.Params["rowID"])) { json = "{success:false,msg:'修改失敗!'}"; } else { json = "{success:false,msg:'新增失敗!'}"; } } } else { json = "{success:false,msg:'數據重複!'}"; } #endregion } else { json = "{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); json = "{success:false,msg:'異常!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase BannerImageEdit() { string json = string.Empty; BannerContent bc = new BannerContent(); Serial serial = new Serial(); _bcMgr = new BannerContentMgr(mySqlConnectionString); _ISerImplMgr = new SerialMgr(mySqlConnectionString); serial = _ISerImplMgr.GetSerialById(72); 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 = imgLocalServerPath + promoPath;//圖片存儲地址 /aimg.gigade100.com/ +/promotion/dev/ string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { string oldImg = string.Empty; serial = _ISerImplMgr.GetSerialById(6); List<BannerContent> store = new List<BannerContent>(); if (!string.IsNullOrEmpty(Request.Params["banner_content_id"])) { int totalCount = 0; bc.IsPage = false; bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (Request.Params["history"] == "1") { bc.banner_status = 3; } store = _bcMgr.GetList(bc, out totalCount); foreach (var item in store) { oldImg = item.banner_image; } } bc = new BannerContent(); bc.banner_title = Request.Params["banner_title"]; bc.banner_link_url = Request.Params["banner_link_url"]; if (!string.IsNullOrEmpty(Request.Params["banner_site_id"])) { bc.banner_site_id = uint.Parse(Request.Params["banner_site_id"]); } if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"])) { bc.banner_link_mode = int.Parse(Request.Params["banner_link_mode"]); } if (!string.IsNullOrEmpty(Request.Params["banner_sort"])) { bc.banner_sort = uint.Parse(Request.Params["banner_sort"]); } if (!string.IsNullOrEmpty(Request.Params["banner_statuses"])) { bc.banner_status = uint.Parse(Request.Params["banner_statuses"]); } if (!string.IsNullOrEmpty(Request.Params["banner_start"])) { bc.banner_start = DateTime.Parse(DateTime.Parse(Request.Params["banner_start"]).ToString("yyyy-MM-dd") + " 00:00:00"); } if (!string.IsNullOrEmpty(Request.Params["banner_end"])) { bc.banner_end = DateTime.Parse(DateTime.Parse(Request.Params["banner_end"]).ToString("yyyy-MM-dd") + " 23:59:59"); } bc.banner_ipfrom = CommonFunction.GetClientIPNew(); if (bc.banner_ipfrom == "::1") { bc.banner_ipfrom = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName())[2].ToString(); } if (!string.IsNullOrEmpty(Request.Params["banner_content_id"]) && Request.Params["banner_image"] == oldImg) { bc.banner_image = oldImg; } if (Request.Files["banner_image"] != null && Request.Files["banner_image"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["banner_image"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; string filename = NewName.Substring(0, NewName.LastIndexOf(".")); //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是哈希字符串 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(filename, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; NewFileName = NewFileName + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; string localPromoDirectory = Server.MapPath(localPromoPath); if (!System.IO.Directory.Exists(localPromoDirectory)) { System.IO.Directory.CreateDirectory(localPromoDirectory); } FTP ftp = new FTP(); string directorys = promoPath + firstFolder + secondFolder; ftp.MakeMultiDirectory(imgLocalPath+"/", directorys.Substring(1, directorys.Length - 2).Split('/'), ftpuser, ftppwd); //NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(localPromoPath + firstFolder + secondFolder); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, imgLocalPath + directorys + NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (!result) { json = "{success:false,msg:'圖片上傳失敗!'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } bc.banner_image = NewName; string oldImgPath = string.Empty; string ftppath = string.Empty; if (oldImg.Length >= 4) { oldImgPath = localPromoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/" + oldImg; } if (System.IO.File.Exists(Server.MapPath(oldImgPath))) { ftppath=imgLocalPath + promoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/"; System.IO.File.Delete(Server.MapPath(oldImgPath)); FTP ftp1 = new FTP(ftppath, ftpuser, ftppwd); List<string> tem = ftp1.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(ftppath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(ftppath + oldImg); } } } else { json = "{success:false,msg:'上傳圖片不能超過" + maxValue + "K'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } #region 新增 if (String.IsNullOrEmpty(Request.Params["banner_content_id"])) { bc.banner_content_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_bcMgr.Add(bc) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ json = "{success:true,msg:\"" + "新增成功!" + "\"}"; } } #endregion #region 編輯 else { bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (_bcMgr.Update(bc) > 0) { json = "{success:true,msg:\"" + "修改成功!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveChinatrust() { string json = string.Empty; try { _eventChinatrust = new EventChinatrustMgr(mySqlConnectionString); FileManagement fileLoad = new FileManagement(); EventChinatrustQuery query = new EventChinatrustQuery(); EventChinatrustQuery oldModel = new EventChinatrustQuery(); List<EventChinatrustQuery> store = new List<EventChinatrustQuery>(); if (!string.IsNullOrEmpty(Request.Params["row_id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.event_active = -1; query.row_id = int.Parse(Request.Params["row_id"]); store = _eventChinatrust.GetEventChinatrustList(query, out totalCount); } #region 需要更改的屬性 if (!string.IsNullOrEmpty(Request.Params["row_id"])) { query.row_id = Convert.ToInt32(Request.Params["row_id"]); } if (!string.IsNullOrEmpty(Request.Params["event_name"])) { query.event_name = Request.Params["event_name"]; } if (!string.IsNullOrEmpty(Request.Params["event_desc"])) { query.event_desc = Request.Params["event_desc"]; } if (!string.IsNullOrEmpty(Request.Params["event_start_time"])) { query.event_start_time = DateTime.Parse(Request.Params["event_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["event_end_time"])) { query.event_end_time = DateTime.Parse(Request.Params["event_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["user_register_time"])) { query.user_register_time=DateTime.Parse(Request.Params["user_register_time"]); } if (!string.IsNullOrEmpty(Request.Params["event_banner"])) { query.event_banner = Request.Params["event_banner"]; } #endregion query.event_type = "EC"; #region 上傳圖片 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_Min_Element"); 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 + PaperPath;//圖片存儲地址 if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localPromoPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (query.row_id != 0) { oldModel = store.FirstOrDefault(); if (oldModel.event_banner != "") { string oldFileName = oldModel.event_banner; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 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); } } } try { Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.event_banner = fileName; } } 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); } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonStr = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } } #endregion if (query.row_id == 0) { query.event_create_time = DateTime.Now; query.event_update_time = query.event_create_time; query.event_create_user = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); query.event_update_user = query.event_create_user; if (_eventChinatrust.AddEventChinatrust(query) > 0) { json = "{success:true }"; } else { json = "{success:false,msg:'新增失敗!'}"; } } else { query.event_update_time = DateTime.Now; query.event_update_user = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); if (_eventChinatrust.UpdateEventChinatrust(query) > 0) { json = "{success:true }"; } else { json = "{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); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase SaveInspectionRe() { string json = "{success:'false',msg:'5'}"; try { _inspectionReport = new InspectionReportMgr(mySqlConnectionString); InspectionReportQuery query = new InspectionReportQuery(); InspectionReportQuery oldQuery = new InspectionReportQuery(); if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } if (!string.IsNullOrEmpty(Request.Params["brand_id"])) { query.brand_id = Convert.ToUInt32(Request.Params["brand_id"]); } if (!string.IsNullOrEmpty(Request.Params["certificate_type1"])) { query.certificate_type1 = Request.Params["certificate_type1"]; } if (!string.IsNullOrEmpty(Request.Params["certificate_type2"])) { query.certificate_type2 = Request.Params["certificate_type2"]; } if (!string.IsNullOrEmpty(Request.Params["certificate_expdate"])) { query.certificate_expdate = Convert.ToDateTime(Request.Params["certificate_expdate"]); } if (!string.IsNullOrEmpty(Request.Params["certificate_desc"])) { query.certificate_desc = Request.Params["certificate_desc"]; } if (!string.IsNullOrEmpty(Request.Params["certificate_filename"])) { query.certificate_filename = Request.Params["certificate_filename"]; } if (!string.IsNullOrEmpty(Request.Params["rowID"])) { query.rowID = Convert.ToInt32(Request.Params["rowID"]); oldQuery = _inspectionReport.oldQuery(query); } if (!string.IsNullOrEmpty(Request.Params["sort"])) { query.sort = Convert.ToInt32(Request.Params["sort"]); } if (!string.IsNullOrEmpty(Request.Params["old_sort"])) { query.old_sort = Convert.ToInt32(Request.Params["old_sort"]); } query.k_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.m_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; #region 排序是否重複 if (_inspectionReport.IsSortExist(query) || query.old_sort == query.sort)//sort不重複 { if (!_inspectionReport.IsExist(query)) { HttpPostedFileBase picFile = Request.Files["certificate_filename"]; //檢查上傳的圖片名稱和拼出來的圖片名稱是否一樣,不一樣則不能上傳 //拼成圖片名稱 #region 上傳圖片 try { 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_Min_Element"); 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 localInspectionReportPath = imgLocalPath + InspectionReportPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 // //文件夾名稱 string[] dirPath = new string[2]; dirPath[0] = query.brand_id.ToString() + "/".ToString(); dirPath[1] = query.product_id.ToString() + "/".ToString(); // fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { string[] mapPath = new string[2]; mapPath[0] = _inspectionReport.GetType1Folder(query); mapPath[1] = _inspectionReport.GetType2Folder(query); string NewFileName = string.Empty; NewFileName = query.brand_id + "-" + query.product_id + "-" + mapPath[0].Replace('/', ' ').Replace(" ", "") + "-" + mapPath[1].Replace('/', ' ').Replace(" ", ""); #region 判斷圖片名稱是否正確,正確則保存 if (picFile.FileName.Substring(0, picFile.FileName.LastIndexOf(".")) == NewFileName) { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); CreateFolder(localInspectionReportPath, dirPath); //壓縮圖片 源文件 string sourcePath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1] + fileName + fileExtention); if (!Directory.Exists(Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]))) { Directory.CreateDirectory(Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1])); } file.SaveAs(sourcePath); fileName = NewFileName + fileExtention; NewFileName = localInspectionReportPath + dirPath[0] + dirPath[1] + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]); string ErrorMsg = string.Empty; if (query.rowID != 0) { string oldFileName = oldQuery.certificate_filename; CommonFunction.DeletePicFile(ServerPath + oldFileName); FTP ftp = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1], ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName); } } try { Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.ZIPUpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd, sourcePath); if (result)//上傳成功 { query.certificate_filename = fileName; //刪除本地圖片 CommonFunction.DeletePicFile(sourcePath); json = _inspectionReport.SaveInspectionRe(query); } } 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); query.certificate_filename = oldQuery.certificate_filename; } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonPic = string.Empty; jsonPic = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(jsonPic); this.Response.End(); return this.Response; } } else { json = "{success:'false',msg:'3'}";//圖片名稱不對 } #endregion } else { query.certificate_filename = oldQuery.certificate_filename; json = _inspectionReport.SaveInspectionRe(query); } } } 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); query.certificate_filename = oldQuery.certificate_filename; } #endregion // picFile.SaveAs(); } else { json = "{success:'false',msg:'2'}";//重複數據 } } else { json = "{success:'false',msg:'4'}";//重複數據 } #endregion } 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 SaveElementDetaiil() { string resultJson = "{success:false}"; ElementDetail model = new ElementDetail(); ElementDetail oldModel = new ElementDetail(); _detailMgr = new ElementDetailMgr(mySqlConnectionString); #region 獲取圖片信息 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_Min_Element"); 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 localBannerPath = imgLocalPath + ElementPath;//圖片存儲地址 #endregion if (!String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_id = Convert.ToInt32(Request.Params["element_id"].ToString()); oldModel = _detailMgr.GetModel(model); } #region 獲取數據 int isTranInt = 0; //if (Int32.TryParse(Request.Params["element_area_id"].ToString(), out isTranInt)) //{ // model.element_area_id = Convert.ToInt32(Request.Params["element_area_id"].ToString()); //} //else //{ // model.element_area_id = oldModel.element_area_id; //} if (!string.IsNullOrEmpty(Request.Params["element_name"].ToString())) { model.element_name = Request.Params["element_name"].ToString(); } else { model.element_name = oldModel.element_name; } if (!string.IsNullOrEmpty(Request.Params["packet_id"])) { model.packet_id = Convert.ToInt32(Request.Params["packet_id"]); } if (Int32.TryParse(Request.Params["element_type"].ToString(), out isTranInt)) { model.element_type = Convert.ToInt32(Request.Params["element_type"]); } if (model.element_type == 1) { #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 0; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (iFile == 0 && fileName == oldModel.element_content) { fileName = ""; } if(iFile == 1 && string.IsNullOrEmpty(Request.Params["element_img_big"].ToString()) ) { fileName = Request.Params["element_img_big"].ToString(); } if (!String.IsNullOrEmpty(fileName)) { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_content; if (iFile == 1) { oldFileName = oldModel.element_img_big; } CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } try { //上傳 Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { if (iFile == 0) { model.element_content = fileName; } else { model.element_img_big = fileName; } } } 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); model.element_content = oldModel.element_content; } if (!string.IsNullOrEmpty(ErrorMsg)) { if (iFile == 0) { ErrorMsg = "元素圖 " + ErrorMsg; } else { ErrorMsg = "元素圖(大) " + ErrorMsg; } string json = string.Empty; json = "{success:true,msg:\""+ ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (iFile == 0) { model.element_content = oldModel.element_content; } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } //model.element_img_big = oldModel.element_img_big; } } } } 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); model.element_content = oldModel.element_content; } #endregion } else if (model.element_type == 2) { if (!string.IsNullOrEmpty(Request.Params["element_content"].ToString())) { model.element_content = Request.Params["element_content"].ToString(); } else { model.element_content = oldModel.element_content; } } else if (model.element_type == 3) { if (int.TryParse(Request.Params["element_product_id"].ToString(), out isTranInt)) { model.element_content = Request.Params["element_product_id"].ToString(); } else { model.element_content = oldModel.element_content; } #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 1; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (!String.IsNullOrEmpty(fileName) && !String.IsNullOrEmpty(Request.Params["element_img_big"].ToString())) {//可獲取文件,名稱不為空則變更圖片 fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_img_big; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } try { //上傳 Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { model.element_img_big = fileName; } } 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); model.element_img_big = oldModel.element_img_big; } if (!string.IsNullOrEmpty(ErrorMsg)) { ErrorMsg = "元素圖(大)" + ErrorMsg; string json = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } } } } 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); model.element_img_big = oldModel.element_img_big; } #endregion } if (int.TryParse(Request.Params["category_id_s"].ToString(), out isTranInt)) { model.category_id = uint.Parse(Request.Params["category_id_s"].ToString()); } else { model.category_id = 0; } model.category_name = Server.HtmlDecode(Request.Params["category_name_s"].ToString()); if (!string.IsNullOrEmpty(Request.Params["element_link_url"].ToString())) { model.element_link_url = Request.Params["element_link_url"].ToString(); } //else //{ // model.element_link_url = oldModel.element_link_url; //} if (int.TryParse(Request.Params["element_link_mode"].ToString(), out isTranInt)) { model.element_link_mode = Convert.ToInt32(Request.Params["element_link_mode"]); } else { model.element_link_mode = oldModel.element_link_mode; } if (!string.IsNullOrEmpty(Request.Params["element_sort"].ToString())) { model.element_sort = Convert.ToInt32(Request.Params["element_sort"].ToString()); } //else //{ // model.element_sort = oldModel.element_sort; //} if (!string.IsNullOrEmpty(Request.Params["element_start"].ToString())) { model.element_start = Convert.ToDateTime(Request.Params["element_start"].ToString()); } else { model.element_start = oldModel.element_start; } if (!string.IsNullOrEmpty(Request.Params["element_end"].ToString())) { model.element_end = Convert.ToDateTime(Request.Params["element_end"].ToString()); } else { model.element_end = oldModel.element_end; } model.element_remark = (Request.Params["element_remark"].ToString()); model.element_status = 0;//默認為不啟用 #endregion try { //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_createdate = DateTime.Now; model.element_updatedate = model.element_createdate; model.create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; model.update_userid = model.create_userid; //這裡加上各種參數 if (_detailMgr.Save(model) > 0) { resultJson = "{success:true}";//返回json數據 } } else { //model.element_createdate = oldModel.element_createdate; model.element_updatedate = DateTime.Now; model.update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; // model.create_userid = oldModel.create_userid; //這裡加上各種參數 if (_detailMgr.Update(model) > 0)//如果可以獲取到rowid則進行修改 { resultJson = "{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); resultJson = "{success:false}"; } this.Response.Clear(); this.Response.Write(resultJson); this.Response.End(); return this.Response; }
public HttpResponseBase UpdateTrial() { string jsonStr = String.Empty; int isTranInt = 0; try { string trial_id = Request.Params["trial_id"].ToString(); string isEdit = Request.Params["isEdit"].ToString(); _promotionsAmountTrialMgr = new PromotionsAmountTrialMgr(mySqlConnectionString); _ucMgr = new UserConditionMgr(mySqlConnectionString); PromotionsAmountTrialQuery model = new PromotionsAmountTrialQuery(); PromotionsAmountTrialQuery OldModel = new PromotionsAmountTrialQuery(); #region 第一面板數據 if (!string.IsNullOrEmpty(Request.Params["trial_id"])) { model.id = Convert.ToInt32(Request.Params["trial_id"]); OldModel = _promotionsAmountTrialMgr.Select(model.id); } if (!string.IsNullOrEmpty(Request.Params["name"])) {//活動名稱 model.name = Request.Params["name"].ToString(); } int event_type = 0; if (!string.IsNullOrEmpty(Request.Params["event_type"])) { if (int.TryParse(Request.Params["event_type"], out event_type)) { if (event_type == 1) { model.event_type = "T1"; } else if (event_type == 2) { model.event_type = "T2"; } } } model.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString()); int paper_id = 0; if (int.TryParse(Request.Params["paper_id"].ToString(), out paper_id)) { model.paper_id = paper_id; } if (!string.IsNullOrEmpty(Request.Params["event_url"].ToString())) { model.url = Request.Params["event_url"]; } if (!string.IsNullOrEmpty(Request.Params["start_date"])) { model.start_date = Convert.ToDateTime(Request.Params["start_date"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["end_date"])) { model.end_date = Convert.ToDateTime(Request.Params["end_date"].ToString()); } //活動描述 if (!string.IsNullOrEmpty(Request.Params["event_desc"])) { model.event_desc = Request.Params["event_desc"].ToString(); } #endregion #region 第二面板數據 if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString())) { if (int.TryParse(Request.Params["group_id"].ToString(), out isTranInt)) { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } else { model.group_id = OldModel.group_id; } //當編輯活動時將會員條件改為會員群組則刪除原有的會員條件 if (OldModel.condition_id != 0) { UserCondition uc = new UserCondition(); uc.condition_id = OldModel.condition_id; if (_ucMgr.Delete(uc) > 0) { jsonStr = "{success:true}"; model.condition_id = 0; } else { jsonStr = "{success:false,msg:'user_condition刪除出錯!'}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } //當活動設置完會員條件又改為會員群組時刪除設置的會員條件 if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { UserCondition uc = new UserCondition(); uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]); if (_ucMgr.Delete(uc) > 0) { jsonStr = "{success:true}"; model.condition_id = 0; } else { jsonStr = "{success:false,msg:'user_condition刪除出錯!'}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); model.group_id = 0; } if (!string.IsNullOrEmpty(Request.Params["count_by"])) { model.count_by = Convert.ToInt32(Request.Params["count_by"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["numLimit"])) { model.num_limit = Convert.ToInt32(Request.Params["numLimit"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["gift_mundane"])) { model.gift_mundane = Convert.ToInt32(Request.Params["gift_mundane"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["IsRepeat"])) { model.repeat = Convert.ToInt32(Request.Params["IsRepeat"].ToString()) == 1 ? true : false; } if (!string.IsNullOrEmpty(Request.Params["freight_type"].ToString())) { if (int.TryParse(Request.Params["freight_type"].ToString(), out isTranInt)) { model.freight_type = Convert.ToInt32(Request.Params["freight_type"].ToString()); } else { model.freight_type = OldModel.freight_type; } } if (!string.IsNullOrEmpty(Request.Params["device_name"])) { model.device = Convert.ToInt32(Request.Params["device_name"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName { Regex reg = new Regex("^([0-9]+,)*([0-9]+)$"); if (reg.IsMatch(Request.Params["site"].ToString())) { model.site = Request.Params["site"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08 } else { model.site = OldModel.site; } } #endregion #region 第三面板數據 if (!string.IsNullOrEmpty(Request.Params["product_id"])) { model.product_id = Convert.ToInt32(Request.Params["product_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["product_name"])) { model.product_name = Request.Params["product_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["sale_product_id"])) { model.sale_productid = Convert.ToInt32(Request.Params["sale_product_id"].ToString()); } model.category_id = Convert.ToUInt32(Request.Params["category_id"].ToString()); model.brand_id = Convert.ToInt32(Request.Params["brand_id"].ToString()); model.market_price = Convert.ToInt32(Request.Params["market_price"].ToString()); model.show_number = Convert.ToInt32(Request.Params["show_number"].ToString()); model.apply_limit = Convert.ToInt32(Request.Params["apply_limit"].ToString()); model.apply_sum = Convert.ToInt32(Request.Params["apply_sum"].ToString()); #region 上傳圖片 try { 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;//圖片存儲地址 string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 bool result = false; string NewFileName = string.Empty;//編譯后的文件名 string oldFile = ""; string ServerPath = string.Empty; string ErrorMsg = string.Empty; //判斷目錄是否存在,不存在則創建 CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/')); FileManagement fileLoad = new FileManagement(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { if (iFile == 0 && !string.IsNullOrEmpty(Request.Params["prod_file"])) { model.product_img = Request.Params["prod_file"].ToString().Substring(Request.Params["prod_file"].ToString().LastIndexOf("/") + 1); } else { HttpPostedFileBase file = Request.Files[iFile]; Random rand = new Random(); int newRand = rand.Next(1000, 9999); fileName = Path.GetFileName(file.FileName); if (fileName != "") { switch (iFile) { case 1: oldFile = OldModel.event_img_small; break; case 2: oldFile = OldModel.event_img; break; case 0: oldFile = OldModel.product_img; break; } FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFile)) { FTP ftps = new FTP(localPromoPath + oldFile, ftpuser, ftppwd); ftps.DeleteFile(localPromoPath + oldFile);//刪除ftp:71.159上的舊圖片 DeletePicFile(ServerPath + oldFile);//刪除本地圖片 } fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = model.event_id + newRand + fileExtention; fileName = NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); try { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { switch (iFile) { case 1: model.event_img_small = fileName; break; case 2: model.event_img = fileName; break; case 0: model.product_img = fileName; break; } } } 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); } } else { switch (iFile) { case 1: model.event_img_small = OldModel.event_img_small; break; case 2: model.event_img = OldModel.event_img; break; case 0: model.product_img = OldModel.product_img; break; } } } } } 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); } #endregion #endregion #region 更新表結構 if (string.IsNullOrEmpty(isEdit))//新增數據 { model.active = 0;//默認不啟用 model.status = 1;//第二步保存為有效數據 model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.created = DateTime.Now; model.muser = model.kuser; model.modified = model.created; if (_promotionsAmountTrialMgr.Update(model) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回json數據 } } else//編輯數據 { model.active = OldModel.active; model.status = OldModel.status; model.kuser = OldModel.kuser; model.created = OldModel.created; model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.modified = DateTime.Now; if (_promotionsAmountTrialMgr.Update(model) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回json數據 } } #endregion } 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:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase PromoPairEdit() { string jsonStr = String.Empty; _promopairMgr = new PromoPairMgr(mySqlConnectionString); PromoPair model = new PromoPair(); PromoPair oldermodel = new PromoPair(); PromoPairQuery PPQuery = new PromoPairQuery(); ProductCategory olderpcmodel = new ProductCategory(); PromoPairQuery oldPPQuery = new PromoPairQuery(); if (!String.IsNullOrEmpty(Request.Params["rowid"])) { try { model.id = Convert.ToInt32(Request.Params["rowid"].ToString()); model.category_id = Convert.ToInt32(Request.Params["categoryid"].ToString()); oldermodel = _promopairMgr.GetModelById(model.id); olderpcmodel = _produCateMgr.GetModelById(Convert.ToUInt32(model.category_id)); model.event_name = Request.Params["event_name"].ToString(); model.event_desc = Request.Params["event_desc"].ToString(); model.event_type = oldermodel.event_type; model.vendor_coverage = int.Parse(Request.Params["vendor_coverage"]); #region 會員群組 會員條件 if (Request.Params["group_id"].ToString() != "") { try//group_id { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } catch (Exception) { model.group_id = oldermodel.group_id; } if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { UserCondition uc = new UserCondition(); uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]); if (_ucMgr.Delete(uc) > 0) { jsonStr = "{success:true}"; } else { jsonStr = "{success:false,msg:'user_condition刪除出錯!'}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } model.condition_id = 0; } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { try//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } catch (Exception) { model.condition_id = oldermodel.condition_id; } model.group_id = 0; } #endregion model.deliver_type = Convert.ToInt32(Request.Params["deliver_id"].ToString()); model.device = Request.Params["device_id"].ToString(); //model.website = Request.Params["side"].ToString(); if (!string.IsNullOrEmpty(Request.Params["side"].ToString()))//修改時傳的值為siteName { Regex reg = new Regex("^([0-9]+,)*[0-9]+$"); if (reg.IsMatch(Request.Params["side"].ToString())) { model.website = Request.Params["side"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08 } else { model.website = oldermodel.website; } } #region 紅+綠 if (Request.Params["price"].ToString() != "") { try//price { model.price = Convert.ToInt32(Request.Params["price"].ToString()); } catch (Exception) { model.price = oldermodel.group_id; } model.discount = 0; } else if (Request.Params["discount"].ToString() != "") { try//discount { model.discount = Convert.ToInt32(Request.Params["discount"].ToString()); } catch (Exception) { model.discount = oldermodel.condition_id; } model.price = 0; } #endregion model.starts = Convert.ToDateTime(Request.Params["starts"].ToString()); model.end = Convert.ToDateTime(Request.Params["end"].ToString()); model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.modified = DateTime.Now; PPQuery.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString()); #region 上傳圖片 try { 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); FileManagement fileLoad = new FileManagement(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { HttpPostedFileBase file = Request.Files[iFile]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = Path.GetFileName(file.FileName); // string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = PPQuery.event_id + newRand + fileExtention; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 //string[] mapPath = new string[1]; //mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); //string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); 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 { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { PPQuery.banner_image = fileName; } } catch (Exception) { PPQuery.banner_image = olderpcmodel.banner_image; } } } catch (Exception) { PPQuery.banner_image = olderpcmodel.banner_image; } #endregion #region 注釋上傳圖片 ////string nowtime = DateTime.Now.ToString("hhmm"); //Random rand = new Random(); //int nowtime = rand.Next(1000, 9999); //try //{ // string saveFoler = Server.MapPath("~/aimg.gigade100.com/active/"); // string savePath, fileName, oldsavePath; // for (int iFile = 0; iFile < Request.Files.Count; iFile++) // { // HttpPostedFileBase postedFile = Request.Files[iFile]; // fileName = Path.GetFileName(postedFile.FileName); // if (fileName != "") // { // string fileType = fileName.Substring(fileName.LastIndexOf(".")); // string newName = GetEventId(oldermodel.event_type, model.id.ToString()) + nowtime + fileType; // oldsavePath = olderpcmodel.banner_image; // oldsavePath = saveFoler + oldsavePath; // savePath = saveFoler + newName; // if (System.IO.File.Exists(oldsavePath)) // {//检查是否在服务器上已经存在用户上传的同名文件 // System.IO.File.Delete(oldsavePath); // } // if (fileType.ToLower() == ".jpg" || fileType.ToLower() == ".png" || fileType.ToLower() == ".gif" || fileType.ToLower() == ".jpeg") // { // if (postedFile.ContentLength <= 300 * 1024) // { // postedFile.SaveAs(savePath); // PPQuery.banner_image = newName; // } // else // { // jsonStr = "{success:false,msg:1}"; // this.Response.Clear(); // this.Response.Write(jsonStr.ToString()); // this.Response.End(); // return this.Response; // } // } // else // { // jsonStr = "{success:false,msg:2}"; // this.Response.Clear(); // this.Response.Write(jsonStr.ToString()); // this.Response.End(); // return this.Response; // } // } // else // { // PPQuery.banner_image = olderpcmodel.banner_image; // } // } //} //catch (Exception) //{ // PPQuery.banner_image = olderpcmodel.banner_image; //} #endregion try//存連接地址 id是否也添加時間 { PPQuery.category_link_url = phpwebhost + "/pair/red_green_match.php?event_id=" + PPQuery.event_id; } catch (Exception) { PPQuery.category_link_url = oldPPQuery.category_link_url; } //foreach (string rid in Request.Params["rowid"].ToString().Split('|')) //{ // if (!string.IsNullOrEmpty(rid)) // { // query.id = Convert.ToInt32(rid); // _promopairMgr.Update(query); // } //} if (_promopairMgr.CategoryID(model).ToString() == "true") { _promopairMgr.Update(model, PPQuery); jsonStr = "{success:true}"; } else { jsonStr = "{success:false,msg:3}"; } } 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}"; } } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public HttpResponseBase SaveVoteArticle() { string json = string.Empty; #region 圖片用 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_Min_Element"); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); #endregion try { _votearticle = new VoteArticleMgr(mySqlConnectionString); List<VoteArticleQuery> store = new List<VoteArticleQuery>(); VoteArticleQuery query = new VoteArticleQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.article_id = int.Parse(Request.Params["id"]); store = _votearticle.GetAll(query, out totalCount); } //product_id if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } if (!string.IsNullOrEmpty(Request.Params["event_id"])) { query.event_id = Convert.ToInt32(Request.Params["event_id"]); } if (!string.IsNullOrEmpty(Request.Params["article_title"])) { query.article_title = Request.Params["article_title"]; } if (!string.IsNullOrEmpty(Request.Params["user_id"])) { query.user_id = int.Parse(Request.Params["user_id"]); } if (!string.IsNullOrEmpty(Request.Params["article_content"])) { query.article_content = Request.Params["article_content"]; } if (!string.IsNullOrEmpty(Request.Params["article_sort"])) { query.article_sort =Convert.ToInt32(Request.Params["article_sort"]); } if (!string.IsNullOrEmpty(Request.Params["prod_link"])) { query.prod_link = Request.Params["prod_link"]; } if (!string.IsNullOrEmpty(Request.Params["vote_count"])) { query.vote_count = int.Parse(Request.Params["vote_count"]); } if (!string.IsNullOrEmpty(Request.Params["article_start_time"])) { query.article_start_time =Convert.ToDateTime(Request.Params["article_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_end_time"])) { query.article_end_time = Convert.ToDateTime(Request.Params["article_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_show_start_time"])) { query.article_show_start_time = Convert.ToDateTime(Request.Params["article_show_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_show_end_time"])) { query.article_show_end_time = Convert.ToDateTime(Request.Params["article_show_end_time"]); } #region 上傳圖片 string oldImg = string.Empty; foreach (var item in store) { oldImg = item.article_banner; } if (!string.IsNullOrEmpty(Request.Params["id"]) && Request.Params["article_banner"] == oldImg) { query.article_banner = oldImg; } else { string ServerPath = string.Empty; try { ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files["article_banner"] != null && Request.Files["article_banner"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["article_banner"]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = Path.GetFileName(file.FileName); //獲得後綴名 fileExtention = Path.GetExtension(file.FileName); //獲得不帶後綴名的文件名 fileName = Path.GetFileNameWithoutExtension(file.FileName); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { query.article_banner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } query.article_banner = ""; } } 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:'圖片上傳失敗!'}"; } } #endregion query.article_status = 0;//默認啟用 query.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.create_time = DateTime.Now; query.update_time = DateTime.Now; if (query.article_id > 0) {//編輯 if (_votearticle.Update(query) > 0) { json = "{success:true}"; } else { json = "{success:false,msg:'修改失敗!'}"; } } else {//新增 if (_votearticle.Save(query) > 0) { json = "{success:true}"; } else { json = "{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); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 新增或者修改 /// </summary> /// <returns></returns> public HttpResponseBase SaveEvent() { string json = string.Empty; VoteEvent vevent = new VoteEvent(); veMgr = new VoteEventMgr(mySqlConnectionString); 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_Min_Element"); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); try { List<VoteEventQuery> store = new List<VoteEventQuery>(); VoteEventQuery veq = new VoteEventQuery(); if (!string.IsNullOrEmpty(Request.Params["event_id"])) { int totalCount = 0; veq.IsPage = false; veq.event_id = int.Parse(Request.Params["event_id"]); store = veMgr.GetVoteEventList(veq, out totalCount); } vevent.event_name = Request.Params["event_name"]; vevent.event_desc = Request.Params["event_desc"]; if (!string.IsNullOrEmpty(Request.Params["event_start"])) { vevent.event_start = DateTime.Parse(Request.Params["event_start"]); } if (!string.IsNullOrEmpty(Request.Params["event_end"])) { vevent.event_end = DateTime.Parse(Request.Params["event_end"]); } if (!string.IsNullOrEmpty(Request.Params["word_length"])) { vevent.word_length = int.Parse(Request.Params["word_length"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyone_limit"])) { vevent.vote_everyone_limit = int.Parse(Request.Params["vote_everyone_limit"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyday_limit"])) { vevent.vote_everyday_limit = int.Parse(Request.Params["vote_everyday_limit"]); } if (!string.IsNullOrEmpty(Request.Params["number_limit"])) { vevent.number_limit = int.Parse(Request.Params["number_limit"]); } if (!string.IsNullOrEmpty(Request.Params["is_repeat"])) { vevent.is_repeat = int.Parse(Request.Params["is_repeat"]); } vevent.present_event_id = Request.Params["present_event_id"]; vevent.event_status = 0; vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; vevent.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; #region 上傳圖片 string oldImg = string.Empty; foreach (var item in store) { oldImg = item.event_banner; } if (!string.IsNullOrEmpty(Request.Params["event_id"]) && Request.Params["event_banner"] == oldImg) { vevent.event_banner = oldImg; } else { string ServerPath = string.Empty; try { ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files["event_banner"] != null && Request.Files["event_banner"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["event_banner"]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = Path.GetFileName(file.FileName); //獲得後綴名 fileExtention = Path.GetExtension(file.FileName); //獲得不帶後綴名的文件名 fileName = Path.GetFileNameWithoutExtension(file.FileName); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { vevent.event_banner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } vevent.event_banner = ""; } } 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}"; } } #endregion if (!string.IsNullOrEmpty(Request.Params["event_id"])) { vevent.event_id = int.Parse(Request.Params["event_id"]); //rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString(); if (veMgr.Update(vevent) > 0) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:true,msg:'修改失敗!'}"; } } else { vevent.create_time = DateTime.Now; vevent.update_time = vevent.create_time; if (veMgr.Save(vevent) > 0) { json = "{success:true,msg:'保存成功!'}"; } else { json = "{success:true,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); json = "{success:false,msg:'操作失敗!'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SecondSaveFare() { string jsonStr = String.Empty; int stringTranInt = 0;//使用tryParse使string轉換為int時保存轉換的值 try { string rowID = Request.Params["rowid"].ToString() ?? "0"; string isEdit = Request.Params["isEdit"].ToString() ?? ""; _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); PromotionsAmountFareQuery model = new PromotionsAmountFareQuery(); PromotionsAmountFareQuery OldModel = _promoAmountFareMgr.Select(Convert.ToInt32(rowID)); #region 獲取數據 if (!string.IsNullOrEmpty(Request.Params["rowid"])) { model.id = Convert.ToInt32(Request.Params["rowid"]); } else { model.id = 0; } model.category_id = OldModel.category_id; if (!string.IsNullOrEmpty(Request.Params["name"])) { model.name = Request.Params["name"].ToString(); } else { model.name = OldModel.name; } if (!string.IsNullOrEmpty(Request.Params["desc"])) { model.event_desc = Request.Params["desc"].ToString(); } else { model.event_desc = OldModel.event_desc; } if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"])) { model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString()); } else { model.vendor_coverage = 0; } if (!string.IsNullOrEmpty(Request.Params["sclass_id"])) { if (int.TryParse(Request.Params["sclass_id"].ToString(), out stringTranInt)) { model.class_id = Convert.ToInt32(Request.Params["sclass_id"].ToString() == "" ? "0" : Request.Params["sclass_id"].ToString()); } else { model.class_id = OldModel.class_id; } } else { model.class_id = 0; } if (!string.IsNullOrEmpty(Request.Params["sbrand_id"])) { if (int.TryParse(Request.Params["sbrand_id"].ToString(), out stringTranInt)) { model.brand_id = Convert.ToInt32(Request.Params["sbrand_id"].ToString() == "" ? "0" : Request.Params["sbrand_id"].ToString()); } else { model.brand_id = OldModel.brand_id; } } else { model.brand_id = 0; } if (!string.IsNullOrEmpty(Request.Params["allClass"])) { model.allClass = Convert.ToInt32(Request.Params["allClass"].ToString() == "1" ? "1" : "0"); if (1 == model.allClass) { model.product_id = 999999; } } else { model.allClass = 0; } if (!string.IsNullOrEmpty(Request.Params["event_type"])) { //獲取event_type和category_father_id _parasrcMgr = new ParameterMgr(mySqlConnectionString); List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", parameterName = Request.Params["event_type"].ToString(), Used = 1 }); if (fatherIdResult.Count == 1) { model.event_type = fatherIdResult[0].ParameterCode; model.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty); } } if (!string.IsNullOrEmpty(Request.Params["amount"])) { model.amount = Convert.ToInt32(Request.Params["amount"].ToString()); } else { model.amount = OldModel.amount; } if (!string.IsNullOrEmpty(Request.Params["quantity"])) { model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString()); } else { model.quantity = OldModel.quantity; } if (!string.IsNullOrEmpty(Request.Params["fare_percent"])) { model.fare_percent = Convert.ToInt32(Request.Params["fare_percent"].ToString()); } else { model.fare_percent = OldModel.fare_percent; } if (!string.IsNullOrEmpty(Request.Params["off_times"])) { model.off_times = Convert.ToInt32(Request.Params["off_times"].ToString()); } else { model.off_times = OldModel.off_times; } if (model.id != 0) { model.event_id = BLL.gigade.Common.CommonFunction.GetEventId(model.event_type, model.id.ToString()); } if (Request.Params["group_id"].ToString() != "") {//會員群組不為空時,要清空已存在的會員條件 if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString()) && int.TryParse(Request.Params["group_id"].ToString(), out stringTranInt))//group_id { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } else { model.group_id = OldModel.group_id; } if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { UserCondition uc = new UserCondition(); uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]); _ucMgr = new UserConditionMgr(mySqlConnectionString); if (_ucMgr.Delete(uc) > 0) { jsonStr = "{success:true}"; model.condition_id = 0; } else { jsonStr = "{success:false,msg:3}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { try//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } catch (Exception) { model.condition_id = OldModel.condition_id; } model.group_id = 0; } if (!string.IsNullOrEmpty(Request.Params["type"]) && int.TryParse(Request.Params["type"].ToString(), out stringTranInt)) { model.type = Convert.ToInt32(Request.Params["type"].ToString()); } else { model.type = OldModel.type; } if (!string.IsNullOrEmpty(Request.Params["deliver"].ToString()) && int.TryParse(Request.Params["deliver"].ToString(), out stringTranInt)) { model.delivery_store = Convert.ToInt32(Request.Params["deliver"].ToString()); } else { model.delivery_store = OldModel.delivery_store; } if (!string.IsNullOrEmpty(Request.Params["devicename"].ToString())) { model.device = Convert.ToInt32(Request.Params["devicename"].ToString()); } else { model.device = OldModel.device; } if (!string.IsNullOrEmpty(Request.Params["payment"].ToString())) { Regex reg = new Regex("^([0-9]+,)*[0-9]+$"); if (reg.IsMatch(Request.Params["payment"].ToString())) { model.payment_code = Request.Params["payment"].ToString(); } else { model.payment_code = OldModel.payment_code; } } if (!string.IsNullOrEmpty(Request.Params["start_time"].ToString())) { model.start = Convert.ToDateTime(Request.Params["start_time"].ToString()); } else { model.start = OldModel.start_time; } if (!string.IsNullOrEmpty(Request.Params["end_time"].ToString())) { model.end = Convert.ToDateTime(Request.Params["end_time"].ToString()); } else { model.end = OldModel.end_time; } if (!string.IsNullOrEmpty(Request.Params["site"].ToString())) { Regex reg = new Regex("^([0-9]+,)*[0-9]+$"); if (reg.IsMatch(Request.Params["site"].ToString())) { model.site = Request.Params["site"].ToString(); } else { model.site = OldModel.site; } } model.status = 1; if (!string.IsNullOrEmpty(Request.Params["url_by"].ToString())) { model.url_by = Convert.ToInt32(Request.Params["url_by"].ToString()); } else { model.url_by = OldModel.url_by; } #endregion ////講圖片和鏈接保存至product_category中 if (model.url_by == 1) { #region 上傳圖片 try { 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);//獲取隨機數重命名圖片 if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = Path.GetFileName(file.FileName); if (fileName != "") { // string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = model.event_id + newRand + fileExtention; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 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); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 string oldFileName = OldModel.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);//刪除本地圖片 } FileManagement fileLoad = new FileManagement(); //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { model.banner_image = fileName; } } else { model.banner_image = OldModel.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:0}"; model.banner_image = OldModel.banner_image; } #endregion if (!string.IsNullOrEmpty(Request.Params["banner_url"].ToString())) { model.category_link_url = Request.Params["banner_url"].ToString(); } else { model.category_link_url = OldModel.category_link_url; } } else//url_by=0 { //刪除上傳的圖片 string oldFileName = OldModel.banner_image; FTP ftp = new FTP(imgLocalPath + promoPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(imgLocalPath + promoPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(imgLocalPath + promoPath + oldFileName);//刪除ftp:71.159上的舊圖片 DeletePicFile(Server.MapPath(imgLocalServerPath + promoPath) + oldFileName);//刪除本地圖片 } model.category_link_url = ""; model.banner_image = ""; } _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); if (string.IsNullOrEmpty(isEdit)) { model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.created = DateTime.Now; model.muser = model.kuser; model.modified = model.created; if (_promoAmountFareMgr.ReSave(model) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回json數據 } } else { model.kuser = OldModel.kuser; model.created = OldModel.created; model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.modified = DateTime.Now; if (_promoAmountFareMgr.Update(model, OldModel.event_id) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回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); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase SaveWebContentType2() { WebContentType2 model = new WebContentType2(); WebContentType2 oldModel = new WebContentType2(); int isTranInt = 0; if (!String.IsNullOrEmpty(Request.Params["rowid"]))//如果不存在該id說明是添加頁面 { model.content_id = Convert.ToInt32(Request.Params["rowid"].ToString()); oldModel = _wctMgr2.GetModel(model); } #region 獲取數據 model.site_id = 7; try { model.page_id = Convert.ToInt32(Request.Params["page_id"].ToString()); } catch { model.page_id = oldModel.page_id; } try { model.area_id = Convert.ToInt32(Request.Params["area_id"].ToString()); } catch { model.area_id = oldModel.area_id; } model.content_title = Request.Params["content_title"].ToString(); model.home_title = Request.Params["home_title"].ToString(); model.home_text = Request.Params["home_text"].ToString(); #region 圖片上傳 try { ImagePathConfig(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { HttpPostedFileBase file = Request.Files[iFile]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localHealthPath.Substring(0, localHealthPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/'), ftpuser, ftppwd); // CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/')); // returnName += promoPath + NewFileName; fileName = NewFileName + fileExtention; NewFileName = localHealthPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + healthPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.content_id != 0) { string oldFileName = oldModel.content_image; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localHealthPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localHealthPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localHealthPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } try { //上傳 Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { model.content_image = fileName; } } 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); model.content_image = oldModel.content_image; } if (!string.IsNullOrEmpty(ErrorMsg)) { string json = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { model.content_image = oldModel.content_image; } } } catch (Exception) { model.content_image = oldModel.content_image; } #endregion if (!string.IsNullOrEmpty(Request.Params["product_id"].ToString())) { if (int.TryParse(Request.Params["product_id"].ToString(), out isTranInt)) { model.product_id = Convert.ToInt32(Request.Params["product_id"]); } else { model.product_id = oldModel.product_id; } } else { model.product_id = 0; } model.content_default = Convert.ToInt32(Request.Params["content_default"]); model.content_status = Convert.ToInt32(Request.Params["content_status"]); model.link_url = Request.Params["link_url"].ToString(); if (!string.IsNullOrEmpty(Request.Params["start_time"].ToString())) { model.start_time = DateTime.Parse(Request.Params["start_time"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["end_time"].ToString())) { model.end_time = DateTime.Parse(Request.Params["end_time"].ToString()); } //model.link_page = Request.Params["link_page"].ToString(); model.link_mode = Convert.ToInt32(Request.Params["link_mode"]); #endregion //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["content_id"]))//如果不存在該id說明是添加頁面 { model.created_on = DateTime.Now; model.update_on = model.created_on;//這裡加上各種參數 return InsertWebContentType2(model);//如果獲取不到則進行新增 } else { model.update_on = DateTime.Now;//這裡加上各種參數 return updateWebContentType2(model);//如果可以獲取到rowid則進行修改 } }
public HttpResponseBase PromoAdditionalPriceEdit() { string jsonStr = String.Empty; _promoadditionproceMgr = new PromoAdditionalPriceMgr(mySqlConnectionString); PromoAdditionalPrice model = new PromoAdditionalPrice(); PromoAdditionalPrice oldermodel = new PromoAdditionalPrice(); PromoAdditionalPriceQuery PPQuery = new PromoAdditionalPriceQuery(); ProductCategory olderpcmodel = new ProductCategory(); PromoAdditionalPriceQuery oldPPQuery = new PromoAdditionalPriceQuery(); if (!String.IsNullOrEmpty(Request.Params["rowid"])) { try { model.id = Convert.ToInt32(Request.Params["rowid"].ToString()); oldermodel = _promoadditionproceMgr.GetModel(model.id); model.category_id = oldermodel.category_id; olderpcmodel = _produCateMgr.GetModelById(Convert.ToUInt32(model.category_id)); model.event_name = Request.Params["event_name"].ToString(); model.event_desc = Request.Params["event_desc"].ToString(); model.event_type = oldermodel.event_type; if (!string.IsNullOrEmpty(Request.Params["url_by"])) { model.url_by =Convert.ToInt32(Request.Params["url_by"]); } #region 會員群組 會員條件 if (Request.Params["group_id"].ToString() != "") { try//group_id { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } catch (Exception) { model.group_id = oldermodel.group_id; } model.condition_id = 0; } if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { try//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } catch (Exception) { model.condition_id = oldermodel.condition_id; } model.group_id = 0; } #endregion model.deliver_type = Convert.ToInt32(Request.Params["deliver_id"].ToString()); model.device = Request.Params["device_id"].ToString(); model.website = Request.Params["side"].ToString(); PPQuery.event_id = GetEventId(model.event_type, model.id.ToString()); try { model.fixed_price = Convert.ToInt32(Request.Params["fixed_price"].ToString()); } catch (Exception) { model.fixed_price = oldermodel.fixed_price; } try { model.buy_limit = Convert.ToInt32(Request.Params["buy_limit"].ToString()); } catch (Exception) { model.fixed_price = oldermodel.fixed_price; } model.starts = Convert.ToDateTime(Request.Params["starts"].ToString()); //string s = Request.Params["starts"]; //model.starts = DateTime.Parse(Request.Params["starts"]); model.end = Convert.ToDateTime(Request.Params["end"].ToString()); model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.modified = DateTime.Now; //20140925 add 折扣 if (model.event_type == "A3") { model.discount = Int32.Parse(Request.Params["discount"].ToString()); } else { model.discount = 0; } PPQuery.category_ipfrom = Request.UserHostAddress; PPQuery.event_id = GetEventId(model.event_type, model.id.ToString()); try//存連接地址 { PPQuery.category_link_url = Request.Params["banner_url"].ToString(); if (PPQuery.category_link_url == "" || PPQuery.category_link_url == null) { model.url_by = 0; //刪除上傳的圖片 string oldFileName = olderpcmodel.banner_image; FTP ftp = new FTP(imgLocalPath + promoPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(imgLocalPath + promoPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(imgLocalPath + promoPath + oldFileName);//刪除ftp:71.159上的舊圖片 DeletePicFile(Server.MapPath(imgLocalServerPath + promoPath) + oldFileName);//刪除本地圖片 } PPQuery.category_link_url = ""; PPQuery.banner_image = ""; } else { model.url_by = 1; #region 上傳圖片 try { 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); FileManagement fileLoad = new FileManagement(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { HttpPostedFileBase file = Request.Files[iFile]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = Path.GetFileName(file.FileName); // string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = PPQuery.event_id + newRand + fileExtention; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 //string[] mapPath = new string[1]; //mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); //string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); 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 { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { PPQuery.banner_image = fileName; } } catch (Exception) { PPQuery.banner_image = olderpcmodel.banner_image; } } } catch (Exception) { PPQuery.banner_image = olderpcmodel.banner_image; } #endregion } } catch (Exception) { PPQuery.category_link_url = oldPPQuery.category_link_url; } model.active = false; if (_promoadditionproceMgr.CategoryID(model).ToString() == "true") { _promoadditionproceMgr.Update(model, PPQuery); jsonStr = "{success:true}"; } else { jsonStr = "{success:false,msg:3}"; } } 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}"; } } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public HttpResponseBase SecondSaveGift() { string jsonStr = String.Empty; try { string rowID = Request.Params["rowid"].ToString(); string isEdit = Request.Params["isEdit"].ToString(); _promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString); PromotionsAmountGiftQuery model = new PromotionsAmountGiftQuery(); PromotionsAmountGiftQuery OldModel = _promoAmountGiftMgr.Select(Convert.ToInt32(rowID)); OldModel.event_id = CommonFunction.GetEventId(OldModel.event_type, OldModel.id.ToString()); #region 獲取數據 if (!string.IsNullOrEmpty(Request.Params["rowid"])) { model.id = Convert.ToInt32(Request.Params["rowid"]); } else { model.id = OldModel.id; } model.category_id = OldModel.category_id; if (!string.IsNullOrEmpty(Request.Params["event_name"])) { model.name = Request.Params["event_name"].ToString(); } else { model.name = OldModel.name; } if (!string.IsNullOrEmpty(Request.Params["event_desc"])) { model.event_desc = Request.Params["event_desc"].ToString(); } else { model.event_desc = OldModel.event_desc; } if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"])) { model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString()); } else { model.vendor_coverage = 0; } if (!string.IsNullOrEmpty(Request.Params["event_type"])) { model.event_type = Request.Params["event_type"].ToString(); } else { model.event_type = OldModel.event_type; } if (Request.Params["amount"].ToString() != "" && Request.Params["amount"].ToString() != "0") { if (!string.IsNullOrEmpty(Request.Params["amount"])) { model.amount = Convert.ToInt32(Request.Params["amount"].ToString()); model.quantity = 0; } else { model.amount = OldModel.amount; model.quantity = 0; } } else { if (!string.IsNullOrEmpty(Request.Params["quantity"])) { model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString()); model.amount = 0; } else { model.quantity = OldModel.quantity; model.amount = 0; } } if (model.id != 0) { model.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString()); } else { model.event_id = CommonFunction.GetEventId(OldModel.event_type, OldModel.id.ToString()); } #endregion #region 講圖片和鏈接保存至product_category中 ////講圖片和鏈接保存至product_category中 if (!string.IsNullOrEmpty(Request.Params["url_by"])) { model.url_by = Convert.ToInt32(Request.Params["url_by"].ToString()); if (model.url_by == 1)//是專區 { #region 上傳圖片 try { 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); FileManagement fileLoad = new FileManagement(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { HttpPostedFileBase file = Request.Files[iFile]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = Path.GetFileName(file.FileName); // string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = model.event_id + newRand + fileExtention; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 //string[] mapPath = new string[1]; //mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); //string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); 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 = OldModel.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 { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { model.banner_image = fileName; } } catch (Exception) { model.banner_image = OldModel.banner_image; } } } catch (Exception) { model.banner_image = OldModel.banner_image; } #endregion if (!string.IsNullOrEmpty(Request.Params["banner_url"])) { model.category_link_url = Request.Params["banner_url"].ToString(); } else { model.category_link_url = OldModel.category_link_url; } if (!string.IsNullOrEmpty(Request.Params["sbrand_id"].ToString())) { int brandTranId = 0; if (int.TryParse(Request.Params["sbrand_id"].ToString(), out brandTranId)) { model.brand_id = Convert.ToInt32(Request.Params["sbrand_id"].ToString()); } else { model.brand_id = OldModel.brand_id; } } else { model.brand_id = 0; } if (!string.IsNullOrEmpty(Request.Params["sclass_id"].ToString())) { int classTranId = 0; if (int.TryParse(Request.Params["sclass_id"].ToString(), out classTranId)) { model.class_id = Convert.ToInt32(Request.Params["sclass_id"].ToString()); } else { model.class_id = OldModel.class_id; } } else { model.class_id = 0; } if (!string.IsNullOrEmpty(Request.Params["allClass"])) { if (Request.Params["allClass"] == "1") { model.quanguan = 1; model.class_id = 0; model.brand_id = 0; model.product_id = 999999; } else { model.quanguan = 0; } } } else//非專區 { model.category_link_url = ""; model.banner_image = ""; if (!string.IsNullOrEmpty(Request.Params["nobrand_id"].ToString())) { int brandTranId = 0; if (int.TryParse(Request.Params["nobrand_id"].ToString(), out brandTranId)) { model.brand_id = Convert.ToInt32(Request.Params["nobrand_id"].ToString()); } else { model.brand_id = OldModel.brand_id; } } else { model.brand_id = OldModel.brand_id; } if (!string.IsNullOrEmpty(Request.Params["noclass_id"].ToString())) { int classTranId = 0; if (int.TryParse(Request.Params["noclass_id"].ToString(), out classTranId)) { model.class_id = Convert.ToInt32(Request.Params["noclass_id"].ToString()); } else { model.class_id = OldModel.class_id; } } else { model.class_id = OldModel.class_id; } if (!string.IsNullOrEmpty(Request.Params["product_id"])) { model.product_id = Convert.ToInt32(Request.Params["product_id"].ToString()); } else { model.product_id = OldModel.product_id; } if (!string.IsNullOrEmpty(Request.Params["noallClass"])) { if (Request.Params["noallClass"] == "1" || Request.Params["noallClass"] == "true") { model.quanguan = 1; model.class_id = 0; model.brand_id = 0; model.product_id = 999999; } else { model.quanguan = 0; } } } } else { model.url_by = OldModel.url_by; } #endregion #region 獲取數據 if (Request.Params["group_id"].ToString() != "") { int groupTryId = 0; if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString()) && int.TryParse(Request.Params["group_id"].ToString(), out groupTryId)) { model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString()); } else { model.group_id = OldModel.group_id; } if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { UserCondition uc = new UserCondition(); uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]); if (_ucMgr.Delete(uc) > 0) { jsonStr = "{success:true}"; model.condition_id = 0; } else { jsonStr = "{success:false,msg:'user_condition刪除出錯!'}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } } else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0") { if (!string.IsNullOrEmpty(Request.Params["condition_id"]))//condition_id { model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString()); } else { model.condition_id = OldModel.condition_id; } model.group_id = 0; } if (!string.IsNullOrEmpty(Request.Params["count_by"])) { model.count_by = Convert.ToInt32(Request.Params["count_by"].ToString()); } else { model.count_by = OldModel.count_by; } if (!string.IsNullOrEmpty(Request.Params["numLimit"])) { model.num_limit = Convert.ToInt32(Request.Params["numLimit"].ToString()); } else { model.num_limit = OldModel.num_limit; } if (!string.IsNullOrEmpty(Request.Params["IsRepeat"])) { model.repeat = Convert.ToInt32(Request.Params["IsRepeat"].ToString()) == 1 ? true : false; } else { model.repeat = OldModel.repeat; } if (!string.IsNullOrEmpty(Request.Params["frieghttype"].ToString())) { int typeId = 0; if (int.TryParse(Request.Params["frieghttype"].ToString(), out typeId)) { model.type = Convert.ToInt32(Request.Params["frieghttype"].ToString()); } else { model.type = OldModel.type; } } else { model.type = OldModel.type; } if (!string.IsNullOrEmpty(Request.Params["devicename"])) { model.device = Convert.ToInt32(Request.Params["devicename"].ToString()); } else { model.device = OldModel.device; } if (!string.IsNullOrEmpty(Request.Params["payment"].ToString())) { Regex reg = new Regex("^([0-9]+,)*[0-9]+$"); if (reg.IsMatch(Request.Params["payment"].ToString())) { model.payment_code = Request.Params["payment"].ToString(); } else { model.payment_code = OldModel.payment_code; } } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { model.startdate = Convert.ToDateTime(Request.Params["start_time"].ToString()); } else { model.startdate = OldModel.startdate; } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { model.enddate = Convert.ToDateTime(Request.Params["end_time"].ToString()); } else { model.enddate = OldModel.enddate; } //int siteTranId = 0; //if (!string.IsNullOrEmpty(Request.Params["site"].ToString()) && int.TryParse(Request.Params["site"].ToString(), out siteTranId))//site //{ // model.site = Convert.ToInt32(Request.Params["site"].ToString()); //} //else //{ // model.site = OldModel.site; //} if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName { Regex reg = new Regex("^([0-9]+,)*[0-9]+$"); if (reg.IsMatch(Request.Params["site"].ToString())) { model.site = Request.Params["site"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08 } else { model.site = OldModel.site; } } #endregion #region 贈品處理 if (!string.IsNullOrEmpty(Request.Params["gift_type"]))//gift_type when 1 then '商品' WHEN 2 then '機會' when 3 then '購物金' when 4 then '抵用券' { model.gift_type = Convert.ToInt32(Request.Params["gift_type"].ToString()); if (OldModel.gift_type == 2) { if (model.gift_type == 2) { if (OldModel.ticket_id != 0) { model.ticket_id = OldModel.ticket_id; } else { model.ticket_id = 0; } model.ticket_name = model.name; } else { if (_ptMgr.Delete(OldModel.ticket_id) > 0) { jsonStr = "{success:success}"; model.ticket_id = 0; model.ticket_name = ""; } else { jsonStr = "{success:false,msg:'promo_ticket刪除出錯!'}"; this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; } } } if (model.gift_type == 1) { model.gift_id = Convert.ToInt32(Request.Params["gift_id"].ToString()); model.gift_product_number = Convert.ToInt32(Request.Params["gift_product_number"].ToString()); } else if (model.gift_type == 3) { model.bonus_type = 1; } else if (model.gift_type == 4) { model.bonus_type = 2; } if (!string.IsNullOrEmpty(Request.Params["activeNow"])) { model.active_now = Convert.ToInt32(Request.Params["activeNow"].ToString()); } else { model.active_now = OldModel.active_now; } if (!string.IsNullOrEmpty(Request.Params["startdate"])) { model.use_start = Convert.ToDateTime(Request.Params["startdate"].ToString()); } else { model.use_start = OldModel.use_start; } if (!string.IsNullOrEmpty(Request.Params["enddate"])) { model.use_end = Convert.ToDateTime(Request.Params["enddate"].ToString()); } else { model.use_end = OldModel.use_end; } try { TimeSpan ts1 = new TimeSpan(model.use_end.Ticks); TimeSpan ts2 = new TimeSpan(model.use_start.Ticks); TimeSpan ts3 = ts1.Subtract(ts2).Duration(); int isAddDay = ts3.Hours > 0 ? 1 : 0; model.valid_interval = ts3.Days + isAddDay; } catch { model.valid_interval = OldModel.valid_interval; } if (!string.IsNullOrEmpty(Request.Params["bonusAmount"])) { model.deduct_welfare = Convert.ToUInt32(Request.Params["bonusAmount"].ToString()); } else { model.deduct_welfare = OldModel.deduct_welfare; } } else { model.gift_type = OldModel.gift_type; model.ticket_id = OldModel.ticket_id; model.ticket_name = OldModel.ticket_name; } #endregion model.status = 1; _promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString); if (string.IsNullOrEmpty(isEdit)) { model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.created = DateTime.Now; model.muser = model.kuser; model.modified = model.created; if (_promoAmountGiftMgr.Update(model, OldModel.event_id) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回json數據 } } else { model.kuser = OldModel.kuser; model.created = OldModel.created; model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.modified = DateTime.Now; if (_promoAmountGiftMgr.Update(model, OldModel.event_id) > 0) { jsonStr = "{success:true,msg:0}";//返回json數據 } else { jsonStr = "{success:false,msg:0}";//返回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); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase PaperEdit() { string json = string.Empty; Paper p = new Paper(); _paperMgr = new PaperMgr(mySqlConnectionString); 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_Min_Element"); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); try { List<Paper> store = new List<Paper>(); if (!string.IsNullOrEmpty(Request.Params["paper_id"])) { int totalCount = 0; p.IsPage = false; p.paperID = int.Parse(Request.Params["paper_id"]); store = _paperMgr.GetPaperList(p, out totalCount); } string oldImg = string.Empty; foreach (var item in store) { oldImg = item.paperBanner; } p = new Paper(); p.paperName = Request.Params["paper_name"]; p.paperMemo = Request.Params["paper_memo"]; p.bannerUrl = Request.Params["banner_url"]; if (!string.IsNullOrEmpty(Request.Params["paper_start"])) { p.paperStart = DateTime.Parse(DateTime.Parse(Request.Params["paper_start"]).ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["paper_end"])) { p.paperEnd = DateTime.Parse(DateTime.Parse(Request.Params["paper_end"]).ToString("yyyy-MM-dd HH:mm:ss")); } p.event_ID = Request.Params["eventid"]; if (!string.IsNullOrEmpty(Request.Params["isRepeatGift"])) { p.isRepeatGift = int.Parse(Request.Params["isRepeatGift"]); } //if (!string.IsNullOrEmpty(Request.Params["isPromotion"])) //{ // p.isPromotion = int.Parse(Request.Params["isPromotion"]); // if (p.isPromotion == 1) // { // p.promotionUrl = Request.Params["promotion_url"]; // } //} //if (!string.IsNullOrEmpty(Request.Params["isPromotion"])) //{ // p.isPromotion = int.Parse(Request.Params["isPromotion"]); // if (p.isPromotion == 1) // { // p.promotionUrl = Request.Params["promotion_url"]; // } //} //if (!string.IsNullOrEmpty(Request.Params["isGiveBonus"])) //{ // p.isGiveBonus = int.Parse(Request.Params["isGiveBonus"]); // if (p.isGiveBonus == 1) // { // if (!string.IsNullOrEmpty(Request.Params["bonus_num"])) // { // p.bonusNum = int.Parse(Request.Params["bonus_num"]); // } // } //} //if (!string.IsNullOrEmpty(Request.Params["isGiveProduct"])) //{ // p.isGiveProduct = int.Parse(Request.Params["isGiveProduct"]); // if (p.isGiveProduct == 1) // { // if (!string.IsNullOrEmpty(Request.Params["product_id"])) // { // p.productID = int.Parse(Request.Params["product_id"]); // } // } //} if (!string.IsNullOrEmpty(Request.Params["isRepeatWrite"])) { p.isRepeatWrite = int.Parse(Request.Params["isRepeatWrite"]); } if (!string.IsNullOrEmpty(Request.Params["isNewMember"])) { p.isNewMember = int.Parse(Request.Params["isNewMember"]); } p.creator = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList; if (addlist.Length > 0) { p.ipfrom = addlist[0].ToString(); } if (!string.IsNullOrEmpty(Request.Params["paper_id"]) && Request.Params["paper_banner"] == oldImg) { p.paperBanner = oldImg; } else { string ServerPath = string.Empty; ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files.Count > 0)//單個圖片上傳 { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { p.paperBanner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } else { p.paperBanner = oldImg; } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } p.paperBanner = ""; } } } #region 新增 if (String.IsNullOrEmpty(Request.Params["paper_id"])) { if (_paperMgr.Add(p) > 0) { json = "{success:true,msg:\"" + "新增成功!" + "\"}"; } } #endregion #region 編輯 else { p.paperID = int.Parse(Request.Params["paper_id"]); p.modifier = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); if (_paperMgr.Update(p) > 0) { json = "{success:true,msg:\"" + "修改成功!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public void InsertIntoPromoShareCon(PromoShareCondition query) { List<PromoShareCondition> list = new List<PromoShareCondition>(); PshareConMgr = new PromoShareConditionMgr(mySqlConnectionString); string json = string.Empty; DataTable _dt=new DataTable(); try { for (int i = 0; i < condition.Length; i++) { if (!string.IsNullOrEmpty(Request.Params[condition[i]])) { query = new PromoShareConditionQuery(); query.promo_id = Convert.ToInt32(Request.Params["promo_id"]); query.condition_name = condition[i]; query.condition_value = Request.Params[ condition[i]]; if (query.condition_name == "picture") { #region 上傳圖片 string ErrorMsg = string.Empty; 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_Min_Element"); 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;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; HashEncrypt hash = new HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localPromoPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); //上傳之前刪除已有的圖片 if (query.promo_id != 0) { _dt = PshareConMgr.Get(condition, query); if (_dt.Rows[0]["picture"].ToString() != "") { string oldFileName = _dt.Rows[0]["picture"].ToString(); CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 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); } } } try { Resource.CoreMessage = new CoreResource("Product"); bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.condition_value = fileName; } } 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); } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonStr = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); } } } else { query.condition_value = _dt.Rows[0]["picture"].ToString(); } #endregion } list.Add(query); } } PshareConMgr.AddSql(list); } 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}"; } }
// [HttpPost] public HttpResponseBase SaveVipUserGroup() { NameValueCollection param = Request.Params; VipUserGroup userGroup = new VipUserGroup(); string json = string.Empty; bool size = true; Serial serial = new Serial(); _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); _ISerImplMgr = new SerialMgr(mySqlConnectionString); serial = _ISerImplMgr.GetSerialById(72); 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); string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { #region 新增 if (String.IsNullOrEmpty(param["group_id"])) { if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath)); try { if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; } } else { size = false; } } } catch (Exception) { userGroup.image_name = string.Empty; } if (!string.IsNullOrEmpty(Request.Params["check_iden"])) { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } userGroup.createdate = (uint)CommonFunction.GetPHPTime(DateTime.Now.ToString()); userGroup.group_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_userGroupMgr.Insert(userGroup) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "新增失敗!" + "\"}"; } } #endregion #region 編輯 else { _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); userGroup.group_id = Convert.ToUInt32(param["group_id"]); VipUserGroup oldUserGroup = _userGroupMgr.GetModelById(userGroup.group_id); if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } try { //如果圖片沒有改變 if (Request.Form["image_name"] == oldUserGroup.image_name) { userGroup.image_name = Request.Form["image_name"]; } else { //圖片改變了 if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); // returnName += promoPath + NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 string oldFileName = oldUserGroup.image_name; //FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); //List<string> tem = ftp.GetFileList(); //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; if (System.IO.File.Exists(ServerPath + oldFileName)) { FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); if (System.IO.File.Exists(localPromoPath + oldFileName)) { ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 } DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 } } else { userGroup.image_name = oldUserGroup.image_name; } } else { size = false; userGroup.image_name = oldUserGroup.image_name; } } } } catch (Exception) { userGroup.image_name = oldUserGroup.image_name; } try { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } catch (Exception) { userGroup.check_iden = 0; } if (_userGroupMgr.Update(userGroup) > 0) { if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "修改失敗!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase InsertNewPromoCarnet() { NewPromoCarnetQuery query = new NewPromoCarnetQuery(); NewPromoCarnetQuery oldModel = new NewPromoCarnetQuery(); _INewPromoCarnetMgr = new NewPromoCarnetMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["row_id"])) { query.row_id = Convert.ToInt32(Request.Params["row_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["present_event_id"])) { query.present_event_id = Request.Params["present_event_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToInt32(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["new_user"])) { query.new_user = Convert.ToInt32(Request.Params["new_user"]); } if (!string.IsNullOrEmpty(Request.Params["new_user_date"])) { query.new_user_date = Convert.ToDateTime(Request.Params["new_user_date"]); } if (!string.IsNullOrEmpty(Request.Params["count_by"])) { query.count_by = Convert.ToInt32(Request.Params["count_by"]); } if (!string.IsNullOrEmpty(Request.Params["count"])) { query.count = Convert.ToInt32(Request.Params["count"]); } if (!string.IsNullOrEmpty(Request.Params["device"])) { query.device = (Request.Params["device"]); } if (!string.IsNullOrEmpty(Request.Params["message_mode"])) { query.message_mode = Convert.ToInt32(Request.Params["message_mode"]); } if (!string.IsNullOrEmpty(Request.Params["message_content"])) { query.message_content = (Request.Params["message_content"]); } if (!string.IsNullOrEmpty(Request.Params["link_url"])) { query.link_url = (Request.Params["link_url"]); } if (!string.IsNullOrEmpty(Request.Params["promo_image"])) { query.promo_image = Request.Params["promo_image"]; } if (!string.IsNullOrEmpty(Request.Params["active_now"])) { query.active_now = Convert.ToInt32(Request.Params["active_now"]); } #region 上傳圖片 string ErrorMsg = string.Empty; 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_Min_Element"); 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 + NewPromoPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 fileName = fileLoad.NewFileName(file.FileName); if (fileName != "") { fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString(); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - NewPromoPath.Length + 1), NewPromoPath.Substring(1, NewPromoPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localPromoPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + NewPromoPath); //上傳之前刪除已有的圖片 if (query.row_id != 0) { oldModel = _INewPromoCarnetMgr.GetModel(query); if (oldModel.promo_image != "") { string oldFileName = oldModel.promo_image; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 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); } } } try { Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.promo_image = fileName; } } 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); } if (!string.IsNullOrEmpty(ErrorMsg)) { string jsonStr = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } } else { query.promo_image = oldModel.promo_image; } #endregion if (!string.IsNullOrEmpty(Request.Params["event_name"])) { query.event_name = Request.Params["event_name"]; } if (!string.IsNullOrEmpty(Request.Params["event_desc"])) { query.event_desc = Request.Params["event_desc"]; } if (!string.IsNullOrEmpty(Request.Params["start"])) { query.start = Convert.ToDateTime(Request.Params["start"]); } if (!string.IsNullOrEmpty(Request.Params["end"])) { query.end = Convert.ToDateTime(Request.Params["end"]); } if (query.row_id == 0) { query.kuser = (Session["caller"] as Caller).user_id; query.muser = query.kuser; query.created = DateTime.Now; query.modified = query.created; query.row_id = _INewPromoCarnetMgr.GetNewPromoCarnetMaxId(); query.event_id = BLL.gigade.Common.CommonFunction.GetEventId("F2", query.row_id.ToString()); if (_INewPromoCarnetMgr.InsertNewPromoCarnet(query) > 0) { json = "{success:true}"; } else { json = "{success:false}"; } } else { query.muser = (Session["caller"] as Caller).user_id; query.modified = DateTime.Now; if (_INewPromoCarnetMgr.UpdateNewPromoCarnet(query)) { json = "{success:true}"; } else { json = "{success:false}"; } } } 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 DeleteInspectionRe() { string json = string.Empty; InspectionReportQuery query = new InspectionReportQuery(); List<InspectionReportQuery> list = new List<InspectionReportQuery>(); try { _inspectionReport = new BLL.gigade.Mgr.InspectionReportMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Form["rowID"])) { string rowIDs = Request.Form["rowID"]; if (rowIDs.IndexOf("∑") != -1) { foreach (string id in rowIDs.Split('∑')) { if (!string.IsNullOrEmpty(id)) { query = new InspectionReportQuery(); string[] data = id.Split(','); query.rowID = Convert.ToInt32(data[0]); query.brand_id = Convert.ToUInt32(data[1]); query.product_id = Convert.ToUInt32(data[2]); string oldFileName = data[3]; list.Add(query); #region 刪除圖片 string localInspectionReportPath = imgLocalPath + InspectionReportPath;//圖片存儲地址 string[] dirPath = new string[2]; dirPath[0] = query.brand_id.ToString() + "/".ToString(); dirPath[1] = query.product_id.ToString() + "/".ToString(); string ServerPath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]); CommonFunction.DeletePicFile(ServerPath + oldFileName); FTP ftp = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1], ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName); } #endregion } } } } json = _inspectionReport.DeleteInspectionRe(list); } 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; }