public HttpResponseBase IsModifiable() { string json = string.Empty; _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); PromotionBannerQuery query = new PromotionBannerQuery(); try { if (!string.IsNullOrEmpty(Request.Params["pb_id"])) { query.pb_id = Convert.ToInt32(Request.Params["pb_id"]); } bool i = _promotionBannerMgr.IsModifiable(query); if (i) { json = "{success:true}"; } else { json = "{success:false,msg:\"-1\"}"; } } 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 GetBrandName() { string json = string.Empty; _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); PromotionBannerQuery query = new PromotionBannerQuery(); try { if (!string.IsNullOrEmpty(Request.Params["pb_id"])) { query.pb_id = Convert.ToInt32(Request.Params["pb_id"]); } if (!string.IsNullOrEmpty(Request.Params["brand_id"])) { query.singleBrand_id = Convert.ToUInt32(Request.Params["brand_id"]); } if (!string.IsNullOrEmpty(Request.Params["startdate"])) { query.date_start = Convert.ToDateTime(Request.Params["startdate"]); } if (!string.IsNullOrEmpty(Request.Params["enddate"])) { query.date_end = Convert.ToDateTime(Request.Params["enddate"]); } if (!string.IsNullOrEmpty(Request.Params["multi"])) { query.multi = Convert.ToInt32(Request.Params["multi"]); } if (query.singleBrand_id == 0) { json = "{success:false,msg:\"-1\"}"; } else { string name = _promotionBannerMgr.GetBrandName(query); if (name == "-1") { json = "{success:false,msg:\"-1\"}"; } else if (name == "-2") { json = "{success:false,msg:\"-2\"}"; } else { json = "{success:true,msg:\""+ name +" \"}"; } } } 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 DeleteImage() { string json = string.Empty; _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); PromotionBannerQuery query = new PromotionBannerQuery(); try { if (!string.IsNullOrEmpty(Request.Params["ids"])) { foreach (string item in Request.Params["ids"].Split('|')) { if (!string.IsNullOrEmpty(item)) { query.pb_id = Convert.ToInt32(item); bool result = _promotionBannerMgr.DeleteImage(query); if (result) { continue; } else { json = "{success:false}"; break; } } } 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.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase AddorEdit() { string json = string.Empty; string errorInfo = string.Empty; uint brand_id = 0; bool result = false; try { _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); int i = 0; PromotionBannerQuery query = new PromotionBannerQuery(); PromotionBannerQuery oldquery = new PromotionBannerQuery(); if (!string.IsNullOrEmpty(Request.Params["pb_id"])) { oldquery.pb_id = Convert.ToInt32(Request.Params["pb_id"]); List<PromotionBannerQuery> oldModel = _promotionBannerMgr.GetModelById(oldquery.pb_id); if (oldModel != null) { query.pb_image = oldModel[0].pb_image; } } #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_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 + brandPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); for (int j = 0; j < Request.Files.Count; j++) { string fileName = string.Empty;//當前文件名 HttpPostedFileBase file = Request.Files[j]; fileName = Path.GetFileName(file.FileName); if (string.IsNullOrEmpty(fileName)) { continue; } fileLoad = new FileManagement(); string oldFileName = string.Empty; //舊文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; string ServerPath = string.Empty; string newRand = string.Empty; string ErrorMsg = string.Empty; newRand = hash.Md5Encrypt(fileLoad.NewFileName(fileName) + DateTime.Now.ToString(), "32"); fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = newRand + fileExtention; string folder1 = NewFileName.Substring(0, 2) + "/"; //圖片名前兩碼 string folder2 = NewFileName.Substring(2, 2) + "/"; //圖片名第三四碼 FTP f_cf = new FTP(); localPromoPath = imgLocalPath + brandPath + folder1 + folder2; //圖片存儲地址 string s = localPromoPath.Substring(0, localPromoPath.Length - (brandPath + folder1 + folder2).Length + 1); f_cf.MakeMultiDirectory(s, (brandPath + folder1 + folder2).Substring(1, (brandPath + folder1 + folder2).Length - 2).Split('/'), ftpuser, ftppwd); ServerPath = Server.MapPath(imgLocalServerPath + brandPath + folder1 + folder2); fileName = NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件 //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { query.pb_image = fileName; } else { errorInfo += ErrorMsg; } } #endregion if (!string.IsNullOrEmpty(Request.Params["image_link"])) { query.pb_image_link = Request.Params["image_link"]; } if (!string.IsNullOrEmpty(Request.Params["begin_time"])) { query.pb_startdate = Convert.ToDateTime(Request.Params["begin_time"]); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.pb_enddate = Convert.ToDateTime(Request.Params["end_time"]); } if (!string.IsNullOrEmpty(Request.Params["vb_ids"])) { query.brandIDS = Request.Params["vb_ids"].Substring(0, Request.Params["vb_ids"].LastIndexOf(',')); } if (!string.IsNullOrEmpty(Request.Params["multi"])) { query.multi = Convert.ToInt32(Request.Params["multi"]); } if (!string.IsNullOrEmpty(Request.Params["pb_id"])) { //編輯 query.pb_id = Convert.ToInt32(Request.Params["pb_id"]); query.pb_muser = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); result = _promotionBannerMgr.UpdateImageInfo(query, out brand_id); if (result && string.IsNullOrEmpty(errorInfo)) { json = "{success:true}"; } else if (result == false && brand_id != 0) { json = "{success:false,msg:\"" + brand_id + "\"}";//brand_id重複 } else if (result && !string.IsNullOrEmpty(errorInfo)) { json = "{success:true,msg:\"數據保存成功<br/>但圖片保存失敗 <br/>" + errorInfo + "\"}"; } else { json = "{success:false}"; } } else { //新增 query.pb_kuser = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); query.pb_muser = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); result = _promotionBannerMgr.AddImageInfo(query, out brand_id); if (result && string.IsNullOrEmpty(errorInfo)) { json = "{success:true}"; } else if (result == false && brand_id != 0) { json = "{success:false,msg:\"" + brand_id + "\"}";//brand_id重複 } else if (result && !string.IsNullOrEmpty(errorInfo)) { json = "{success:true,msg:\"數據保存成功<br/>但圖片保存失敗 <br/>" + errorInfo + "\"}"; } 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.ToString()); this.Response.End(); return this.Response; }
public JsonResult UpdateStatus() { string json = string.Empty; uint brand_id; PromotionBannerQuery query = new PromotionBannerQuery(); try { if (!string.IsNullOrEmpty(Request.Params["id"])) { query.pb_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["status"])) { query.pb_status = Convert.ToInt32(Request.Params["status"]); } if (!string.IsNullOrEmpty(Request.Params["multi"])) { query.multi = Convert.ToInt32(Request.Params["multi"]); } query.pb_muser = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); int i = _promotionBannerMgr.UpdateStatus(query,out brand_id); if (i > 0) { return Json(new { success = "true", error = "" }); } else if (i == -1) { return Json(new { success = "false", error = "-1" }); //促銷圖片已過期,不可修改 } else if (i == -2) { return Json(new { success = "false", error = "-2", id = brand_id }); //品牌編號已存在促銷圖,不可重複添加 } else { return Json(new { success = "false", error = "0" }); } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); return Json(new { success = "false", msg = "" }); } }
public HttpResponseBase GetPromotionBannerList() { string json = string.Empty; int totalCount = 0; PromotionBannerQuery query = new PromotionBannerQuery(); List<PromotionBannerQuery> store = new List<PromotionBannerQuery>(); try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 if (!string.IsNullOrEmpty(Request.Params["dateCon"])) { query.dateCon = Convert.ToInt32(Request.Params["dateCon"]); } if (!string.IsNullOrEmpty(Request.Params["date_start"])) { query.date_start =Convert.ToDateTime( Request.Params["date_start"]); query.date_start = Convert.ToDateTime(query.date_start.ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["date_end"])) { query.date_end =Convert.ToDateTime( Request.Params["date_end"]); query.date_end = Convert.ToDateTime(query.date_end.ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["activeStatus"])) { query.pb_status = Convert.ToInt32(Request.Params["activeStatus"]); } if (!string.IsNullOrEmpty(Request.Params["showStatus"])) { query.showStatus = Convert.ToInt32(Request.Params["showStatus"]); } if (!string.IsNullOrEmpty(Request.Params["brand_name"])) { query.brand_name = Request.Params["brand_name"].Trim(); ; } if (!string.IsNullOrEmpty(Request.Params["brand_id"])) { query.singleBrand_id = Convert.ToUInt32(Request.Params["brand_id"]); } _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); store = _promotionBannerMgr.GetPromotionBannerList(query, out totalCount); foreach (var item in store) { if (!string.IsNullOrEmpty(item.pb_image)) { string folder5 = item.pb_image.Substring(0, 2) + "/"; //圖片名前兩碼 string folder6 = item.pb_image.Substring(2, 2) + "/"; //圖片名第三四碼 item.pb_image = imgServerPath + brandPath + folder5 + folder6 + item.pb_image; } else { item.pb_image = defaultImg; } if (!string.IsNullOrEmpty(item.pb_image_link)) { item.pb_image_link = item.pb_image_link.Replace("''", "'"); } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } 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 AllowMultiOrNot() { string json = string.Empty; PromotionBannerQuery query = new PromotionBannerQuery(); _promotionBannerMgr = new PromotionBannerMgr(mySqlConnectionString); try { uint id = 0; if (!string.IsNullOrEmpty(Request.Params["change"])) { if (Request.Params["change"] == "true") { query.changeMode = 1; } } int result = _promotionBannerMgr.AllowMultiOrNot(query, out id); if (id == 0) { json = "{success:true,msg:\"" + result + "\"}"; } else { if (query.changeMode == 0) { json = "{success:true,msg:\"" + result + "\"}"; } else { json = "{success:false,msg:\"" + result + "\",id:\"" + id + "\"}"; } } } 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; }