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; }