public HttpResponseBase GetChinaTrustBagMapList() { List<EventChinaTrustBagMapQuery> store = new List<EventChinaTrustBagMapQuery>(); string json = string.Empty; int totalCount = 0; try { _ChinatrustBMMgr = new EventChinaTrustBagMapMgr(mySqlConnectionString); EventChinaTrustBagMapQuery query = new EventChinaTrustBagMapQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } //if (!string.IsNullOrEmpty(Request.Params["bag_id"])) //{ // query.bag_id = Convert.ToInt32(Request.Params["bag_id"]); //} if (!string.IsNullOrEmpty(Request.Params["bagid"])) { query.bag_id = Convert.ToInt32(Request.Params["bagid"]); } if (!string.IsNullOrEmpty(Request.Params["search_con"])) { query.search_con = Convert.ToInt32(Request.Params["search_con"]); } if (!string.IsNullOrEmpty(Request.Params["con"])) { query.con = Request.Params["con"]; } store = _ChinatrustBMMgr.GetChinaTrustBagMapList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { item.link = link; if (item.product_forbid_banner != "") { item.forbid_banner = imgServerPath + PaperPath + item.product_forbid_banner; } else { item.forbid_banner = defaultImg; } if (item.product_active_banner != "") { item.active_banner = imgServerPath + PaperPath + item.product_active_banner; } else { item.active_banner = defaultImg; } } //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveChinaTrustBagMap() { string json = string.Empty; bool pic = true; DataTable dt = new DataTable(); try { _ChinatrustBMMgr = new EventChinaTrustBagMapMgr(mySqlConnectionString); EventChinaTrustBagMapQuery store = new EventChinaTrustBagMapQuery(); EventChinaTrustBagMapQuery query = new EventChinaTrustBagMapQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.map_id = int.Parse(Request.Params["id"]); store = _ChinatrustBMMgr.GetChinaTrustBagMapList(query, out totalCount).FirstOrDefault(); query = store; } //product_id if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } else { query.product_id = 0; } if (!string.IsNullOrEmpty(Request.Params["bag_id"])) { query.bag_id = Convert.ToInt32(Request.Params["bag_id"]); } if (!string.IsNullOrEmpty(Request.Params["linkurl"])) { query.linkurl = Request.Params["linkurl"]; } if (!string.IsNullOrEmpty(Request.Params["product_forbid_banner"])) { query.product_forbid_banner = Request.Params["product_forbid_banner"]; } if (!string.IsNullOrEmpty(Request.Params["product_active_banner"])) { query.product_active_banner = Request.Params["product_active_banner"]; } if (!string.IsNullOrEmpty(Request.Params["ad_product_id"])) { string p_id = Request.Params["ad_product_id"]; RegexOptions options = RegexOptions.None; Regex regex = new Regex(@"[ ]{2,}", options); p_id = regex.Replace(p_id, @" "); p_id = p_id.Replace(" ", ","); for (int i = p_id.Length - 1; i > 0; i--) { if (p_id.Substring(p_id.Length - 1, 1) == ",") { p_id = p_id.Substring(0, p_id.Length - 1); } } string[] pr_id = p_id.Split(',').Distinct().ToArray(); ; string pro_id = ""; for (int i = 0; i < pr_id.Length; i++) { if (_ChinatrustBMMgr.IsProductId(pr_id[i].ToString())) { pro_id += pr_id[i].ToString() + ","; } } if (pro_id.Length > 0) { query.ad_product_id = pro_id.Substring(0, pro_id.Length - 1); } else { query.ad_product_id = null; } } else { query.ad_product_id = null; } if (!string.IsNullOrEmpty(Request.Params["product_desc"])) { query.product_desc = Request.Params["product_desc"]; } else { query.product_desc = null; } #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 + PaperPath;//圖片存儲地址 Random rand = new Random(); FileManagement fileLoad = new FileManagement(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { //int newRand = rand.Next(1000, 9999); HttpPostedFileBase file = Request.Files[iFile]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 bool result = false; string NewFileName = string.Empty; string ServerPath = string.Empty; fileName = Path.GetFileName(file.FileName); string newRand = hash.Md5Encrypt(fileLoad.NewFileName(fileName), "32"); string ErrorMsg = string.Empty; if (iFile == 0) { if (string.IsNullOrEmpty(file.FileName)) { query.product_forbid_banner = store.product_forbid_banner; } else { fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = newRand + fileExtention; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = PaperPath.Substring(1, PaperPath.Length - 1); string s = localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1), mapPath); // returnName += PaperPath + NewFileName; fileName = NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); string oldFileName = ""; oldFileName = store.product_forbid_banner; if (!string.IsNullOrEmpty(oldFileName)) { DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 } try { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { query.product_forbid_banner = fileName; } else { pic = false; } } catch (Exception) { query.product_forbid_banner = store.product_forbid_banner; query.product_active_banner = store.product_active_banner; } } } if (iFile == 1) { if (string.IsNullOrEmpty(file.FileName)) { query.product_active_banner = store.product_active_banner; } else { fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); NewFileName = newRand + fileExtention; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = PaperPath.Substring(1, PaperPath.Length - 1); string s = localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - PaperPath.Length + 1), mapPath); // returnName += PaperPath + NewFileName; fileName = NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); string oldFileName = ""; oldFileName = store.product_active_banner; if (!string.IsNullOrEmpty(oldFileName)) { DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 } try { //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { query.product_active_banner = fileName; } else { pic = false; } } catch (Exception) { query.product_forbid_banner = store.product_forbid_banner; query.product_active_banner = store.product_active_banner; } } } } } catch (Exception) { query.product_forbid_banner = store.product_forbid_banner; query.product_active_banner = store.product_active_banner; } #endregion if (pic) { if (query.map_id > 0) {//編輯 if (!string.IsNullOrEmpty(Request.Params["map_sort"])) { query.map_sort = Convert.ToInt32(Request.Params["map_sort"]); } if (_ChinatrustBMMgr.Update(query) > 0) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:false,msg:'修改失敗!'}"; } } else {//新增 dt = _ChinatrustBMMgr.GetMapSort(query); if (dt.Rows.Count > 0) { query.map_sort = int.Parse(dt.Rows[0]["map_sort"].ToString()) + 1; } else { query.map_sort = 0; } query.map_active = 0;//默認不啟用 if (_ChinatrustBMMgr.Save(query) > 0) { json = "{success:true,msg:'新增成功!'}"; } else { json = "{success:false,msg:'新增失敗!'}"; } } } 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 UpdateStats() { List<EventChinaTrustBagMapQuery> store = new List<EventChinaTrustBagMapQuery>(); string json = string.Empty; try { _ChinatrustBMMgr = new EventChinaTrustBagMapMgr(mySqlConnectionString); EventChinaTrustBagMapQuery query = new EventChinaTrustBagMapQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) { query.map_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["status"])) { query.map_active = Convert.ToInt32(Request.Params["status"]); } if (_ChinatrustBMMgr.UpdateStatus(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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }