public HttpResponseBase GetPromoAmountFareList() { List<PromotionsAmountFareQuery> store = new List<PromotionsAmountFareQuery>(); string json = string.Empty; try { PromotionsAmountFareQuery query = new PromotionsAmountFareQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); if (!string.IsNullOrEmpty(Request.Params["limit"])) { query.Limit = Convert.ToInt32(Request.Params["limit"]); } else { query.Limit = 25; } if (!string.IsNullOrEmpty(Request.Params["expiredSel"])) { query.expired = Convert.ToInt32(Request.Params["expiredSel"]); } _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); _parasrcMgr = new ParameterMgr(mySqlConnectionString); int totalCount = 0;//獲取所有數據的行數 store = _promoAmountFareMgr.Query(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; foreach (var item in store) { if (item.banner_image != "") { item.banner_image = imgServerPath + promoPath + item.banner_image; } else { item.banner_image = defaultImg; } } 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; }
/// <summary> /// 更改活動使用狀態 /// </summary> /// <returns>數據庫操作結果</returns> public JsonResult UpdateActive() { try { string currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); string muser = string.Empty; int activeValue = Convert.ToInt32(Request.Params["active"]); if (!string.IsNullOrEmpty(Request.Params["muser"])) { muser = (Request.Params["muser"]); } if (currentUser == muser && activeValue == 1) { return Json(new { success = "stop" }); } int id = Convert.ToInt32(Request.Params["id"] ?? "0"); _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); PromotionsAmountFareQuery model = _promoAmountFareMgr.Select(id); if (model.url_by == 1) { model.category_link_url = _produCateMgr.GetModelById(model.category_id).category_link_url; } model.active = Convert.ToBoolean(activeValue); model.start = model.start_time; model.end = model.end_time; model.muser = currentUser; model.modified = DateTime.Now; if (_promoAmountFareMgr.UpdateActive(model) > 0) { return Json(new { success = "true" }); } else { return Json(new { 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); return Json(new { success = "false" }); } }
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; }
/// <summary> /// 刪除 滿件滿額免運 /// </summary> /// <returns></returns> public HttpResponseBase DeletePromoAmountFare() { string jsonStr = String.Empty; _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); if (!String.IsNullOrEmpty(Request.Params["rowID"])) { try { foreach (string rid in Request.Params["rowID"].ToString().Split('|')) { if (!string.IsNullOrEmpty(rid)) { if (_promoAmountFareMgr.Delete(Convert.ToInt32(rid)) > 0) { jsonStr = "{success:true}"; } else { jsonStr = "{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); jsonStr = "{success:false}"; } } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public HttpResponseBase FirstSaveFare() { string jsonStr = String.Empty; try { PromotionsAmountFareQuery model = new PromotionsAmountFareQuery(); if (!string.IsNullOrEmpty(Request.Params["name"].ToString())) { model.name = Request.Params["name"].ToString(); } else { model.name = string.Empty; } if (!string.IsNullOrEmpty(Request.Params["desc"].ToString())) { model.event_desc = Request.Params["desc"].ToString(); } else { model.event_desc = string.Empty; } 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["amount"].ToString())) { model.amount = Convert.ToInt32(Request.Params["amount"].ToString()); } else { model.amount = 0; } if (!string.IsNullOrEmpty(Request.Params["quantity"].ToString())) { model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString()); } else { model.quantity = 0; } if (!string.IsNullOrEmpty(Request.Params["fare_percent"].ToString())) { model.fare_percent = Convert.ToInt32(Request.Params["fare_percent"].ToString()); } else { model.fare_percent = 0; } if (!string.IsNullOrEmpty(Request.Params["off_times"].ToString())) { model.off_times = Convert.ToInt32(Request.Params["off_times"].ToString()); } else { model.off_times = 0; } model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString(); model.created = DateTime.Now; model.status = 0; //獲取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); } model.category_ipfrom = Request.UserHostAddress;//獲取當前ip _promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString); PromotionsAmountFare query = new PromotionsAmountFare(); query.id = _promoAmountFareMgr.Save(model); System.Data.DataTable dt = _promoAmountFareMgr.Select(query); if (dt.Rows.Count > 0) { jsonStr = "{success:true,\"id\":\"" + dt.Rows[0]["id"] + "\",\"cateID\":\"" + dt.Rows[0]["category_id"] + "\",\"event_type\":\"" + dt.Rows[0]["event_type"] + "\"}"; } else { jsonStr = "{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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }