public HttpResponseBase GetBag() { List<EventChinaTrustBag> store = new List<EventChinaTrustBag>(); string json = string.Empty; try { EventChinaTrustBagQuery query = new EventChinaTrustBagQuery(); _eventChinaTrustBag = new EventChinaTrustBagMgr(mySqlConnectionString); //query.event_status = 1; store = _eventChinaTrustBag.GetBag(query); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); json = "{success:true,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 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; }
public JsonResult UpdateActive() { { try { EventChinaTrustBagQuery query = new EventChinaTrustBagQuery(); if (!string.IsNullOrEmpty(Request.Params["bag_id"].ToString())) { query.bag_id = Convert.ToInt32(Request.Params["bag_id"].ToString()); } query.bag_active = Convert.ToInt32(Request.Params["bag_active"] ?? "0"); _eventChinaTrustBag = new EventChinaTrustBagMgr(mySqlConnectionString); query.bag_update_user = (Session["caller"] as Caller).user_id; query.bag_update_time = DateTime.Now; if (_eventChinaTrustBag.EventChinaTrustBagStatus(query) > 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 EventChinaTrustBagList() { EventChinaTrustBagQuery query = new EventChinaTrustBagQuery(); List<EventChinaTrustBagQuery> store = new List<EventChinaTrustBagQuery>(); string json = string.Empty; int totalCount = 0; try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["eventId"])) { query.event_id = Request.Params["eventId"]; } if (!string.IsNullOrEmpty(Request.Params["bag_status"])) { query.bag_active =Convert.ToInt32(Request.Params["bag_status"]); } if (!string.IsNullOrEmpty(Request.Params["bag_search_name"])) { query.bag_name = Request.Params["bag_search_name"]; } if (!string.IsNullOrEmpty(Request.Params["date"])) { query.date =Convert.ToInt32(Request.Params["date"]); } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { query.start_time = Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd HH:mm:ss"); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.end_time = Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd HH:mm:ss"); } _eventChinaTrustBag = new EventChinaTrustBagMgr(mySqlConnectionString); store=_eventChinaTrustBag.EventChinaTrustBagList(query, out totalCount); foreach (var item in store) { item.start_time = CommonFunction.DateTimeToString(item.bag_start_time); item.end_time = CommonFunction.DateTimeToString(item.bag_end_time); item.show_start_time = CommonFunction.DateTimeToString(item.bag_show_start_time); item.show_end_time = CommonFunction.DateTimeToString(item.bag_show_end_time); item.create_time= CommonFunction.DateTimeToString(item.bag_create_time); item.update_time = CommonFunction.DateTimeToString(item.bag_update_time); if (item.bag_banner != "") { item.s_bag_banner=imgServerPath + PaperPath + item.bag_banner; } else { item.s_bag_banner = defaultImg; } } 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }