public ActionResult Index() { HttpCookie cookies = Request.Cookies["vendor"]; if (cookies != null) { ViewBag.LoginEmail = cookies["email"]; } else { ViewBag.LoginEmail = null; } if (Session["vendor"] != null) { return RedirectToAction("", "home"); } else { string vendorid = Request.QueryString["vendor_id"]; string key = Request.QueryString["key"]; string keysec = string.Empty; if (!string.IsNullOrEmpty(vendorid) && !string.IsNullOrEmpty(key)) { int vendor_id = Convert.ToInt32(vendorid); _vendorImp = new VendorMgr(connectionString); string str = _vendorImp.GetLoginId(vendor_id); HashEncrypt hmd5 = new HashEncrypt(); string mdlogin_id = hmd5.Md5Encrypt(str, "MD5"); keysec = hmd5.Md5Encrypt(mdlogin_id + str, "MD5"); if (key.ToString().Trim() != keysec.ToString().Trim()) { return View(); } else { BLL.gigade.Model.Vendor vendor = new BLL.gigade.Model.Vendor(); BLL.gigade.Model.Vendor ven = new BLL.gigade.Model.Vendor(); vendor.vendor_id = Convert.ToUInt32(vendorid); _vendorImp = new VendorMgr(connectionString); ven = _vendorImp.GetSingle(vendor); ven.vendor_password = ""; Session["vendor"] = ven; Session["lgnName"] = ven.vendor_name_simple; return RedirectToAction("", "home"); } } else { return View(); } } }
public int IlocInsert(Model.Iloc loc) { StringBuilder sb = new StringBuilder(); try { HashEncrypt hashpt=new HashEncrypt(); sb.AppendFormat(@"insert into iloc(dc_id,whse_id,loc_id,llts_id,bkfill_loc,ldes_id, ldim_id,x_coord,y_coord,z_coord,bkfill_x_coord,bkfill_y_coord, bkfill_z_coord,lsta_id,sel_stk_pos,sel_seq_loc,sel_pos_hgt,rsv_stk_pos, rsv_pos_hgt,stk_lmt,stk_pos_wid,lev,lhnd_id,ldsp_id, create_user,create_dtim,comingle_allow,change_user,change_dtim,lcat_id, space_remain,max_loc_wgt,loc_status,stk_pos_dep,hash_loc_id ) values ('{0}','{1}','{2}','{3}','{4}','{5}', '{6}','{7}','{8}','{9}','{10}','{11}', '{12}','{13}','{14}','{15}','{16}','{17}', '{18}','{19}','{20}','{21}','{22}','{23}', '{24}','{25}','{26}','{27}','{28}','{29}', '{30}','{31}','{32}','{33}','{34}')", loc.dc_id, loc.whse_id, loc.loc_id, loc.llts_id, loc.bkfill_loc, loc.ldes_id, loc.ldim_id, loc.x_coord, loc.y_coord, loc.z_coord, loc.bkfill_x_coord, loc.bkfill_y_coord, loc.bkfill_z_coord, loc.lsta_id, loc.sel_stk_pos, loc.sel_seq_loc, loc.sel_pos_hgt, loc.rsv_stk_pos, loc.rsv_pos_hgt, loc.stk_lmt, loc.stk_pos_wid, loc.lev, loc.lhnd_id, loc.ldsp_id, loc.create_user, Common.CommonFunction.DateTimeToString(loc.create_dtim), loc.comingle_allow, loc.change_user, Common.CommonFunction.DateTimeToString(loc.change_dtim), loc.lcat_id, loc.space_remain, loc.max_loc_wgt, loc.loc_status, loc.stk_pos_dep, hashpt.Md5Encrypt(loc.loc_id, "16") ); return _access.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("IlocDao-->IlocInsert-->" + ex.Message + sb.ToString(), ex); } }
/// <summary> /// 供應商出貨單 /// </summary> /// <returns></returns> public HttpResponseBase OrderWaitDeliverList() { string jsonStr = String.Empty; StringBuilder sb = new StringBuilder(); HashEncrypt hmd5 = new HashEncrypt(); _IOrderSlaveMgr = new OrderSlaveMgr(mySqlConnectionString); _OrderPaymentNcccMgr = new OrderPaymentNcccMgr(mySqlConnectionString); _SinopacMgr = new SinopacDetailMgr(mySqlConnectionString); _vendorImp = new VendorMgr(mySqlConnectionString); try { #region 前提查詢條件 if (!string.IsNullOrEmpty(Request.Params["search_type"]))//查詢條件 { int search_type = int.Parse(Request.Params["search_type"]); string searchcontent = ""; if (!string.IsNullOrEmpty(Request.Params["searchcontent"])) { searchcontent = Request.Params["searchcontent"]; } switch (search_type) { case 1: sb.AppendFormat(" and om.order_id LIKE '%{0}%' ", searchcontent); break; case 2: sb.AppendFormat(" AND om.order_name LIKE '%{0}%' ", searchcontent); break; case 3: sb.AppendFormat(" AND u.user_email LIKE '%{0}%' ", searchcontent); break; case 4: sb.AppendFormat(" AND om.delivery_name LIKE '%{0}%' ", searchcontent); break; case 5: sb.AppendFormat(" AND om.source_trace LIKE '%{0}%' ", searchcontent); break; default: sb.Append(" "); break; } } if (!string.IsNullOrEmpty(Request.Params["search_vendor"]))//供應商條件 { if (int.Parse(Request.Params["search_vendor"]) != 0) { sb.AppendFormat(" AND os.vendor_id = '{0}' ", Request.Params["search_vendor"]); } } #endregion List<OrderSlaveQuery> store = new List<OrderSlaveQuery>(); OrderSlaveQuery query = new OrderSlaveQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 int totalCount = 0; store = _IOrderSlaveMgr.GetOrderWaitDeliver(query, sb.ToString(), out totalCount);//查询出供應商出貨單 int vendor_id = 0; string loginIdStr = string.Empty; string mdlogin_id = string.Empty; StringBuilder Order_id_store = new StringBuilder(); foreach (var item in store) { Order_id_store.AppendFormat("{0},", item.order_id); } string dtSql = "and order_id in(" + Order_id_store.ToString().TrimEnd(',') + ") ";//去查詢DataTable DataTable _dtNccc = _OrderPaymentNcccMgr.OrderPaymentNccc(null, dtSql); DataTable _dtSino = _SinopacMgr.GetSinopacDetai(null, dtSql); // String Sql = "123"; foreach (var item in store) { //組裝用於登錄到供應商後臺的金鑰 vendor_id = Convert.ToInt32(item.vendor_id); loginIdStr = _vendorImp.GetLoginId(vendor_id); mdlogin_id = hmd5.Md5Encrypt(loginIdStr, "MD5"); //http://localhost:32088/?vendor_id=2&key=f32bef1b57de24330d8bf900cee4ba5e item.key = vendorServerPath + "?vendor_id=" + item.vendor_id + "&key=" + hmd5.Md5Encrypt(mdlogin_id + loginIdStr, "MD5"); item.status = "待出貨"; if (item.order_payment == 1)//付款方式为ATM { DataRow[] rows = _dtSino.Select("order_id='" + item.order_id + "'"); if (rows.Count() != 0) { item.pay_time = DateTime.Parse(rows[0]["pay_time"].ToString()).ToString("yyyy/MM/dd HH:mm:ss"); } else { item.pay_time = ""; } } else { DataRow[] rows = _dtNccc.Select("order_id='" + item.order_id + "'"); if (rows.Count() != 0) { item.pay_time = DateTime.Parse(rows[0]["pay_time"].ToString()).ToString("yyyy/MM/dd HH:mm:ss"); } else { item.pay_time = ""; } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; jsonStr = "{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); jsonStr = "{success:false,msg:0}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public HttpResponseBase IlocUploadExcel() { string newName = string.Empty; string json = string.Empty; List<IlocQuery> store = new List<IlocQuery>(); HashEncrypt hashpt = new HashEncrypt(); try { DTIlocExcel.Clear(); DTIlocExcel.Columns.Clear(); DTIlocExcel.Columns.Add("料位編號", typeof(String)); DTIlocExcel.Columns.Add("料位類型", typeof(String)); DTIlocExcel.Columns.Add("所在層數"); DTIlocExcel.Columns.Add("不能匯入的原因", typeof(String)); int result = 0; int count = 0;//總匯入數 int entercount = 0;//插入失敗個數 int errorcount = 0;//數據異常個數 int create_user = (Session["caller"] as Caller).user_id; if (Request.Files["ImportExcelFile"] != null && Request.Files["ImportExcelFile"].ContentLength > 0) { HttpPostedFileBase excelFile = Request.Files["ImportExcelFile"]; newName = Server.MapPath(excelPath) + excelFile.FileName; excelFile.SaveAs(newName); DataTable dt = new DataTable(); NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newName); dt = helper.SheetData(); if (dt.Rows.Count > 0) { _IlocMgr = new IlocMgr(mySqlConnectionString); _IiplasMgr = new IplasMgr(mySqlConnectionString); int i = 0; foreach (DataRow dr in dt.Rows) { StringBuilder strsql = new StringBuilder(); Iloc ic = new BLL.gigade.Model.Iloc(); i++; try { if (!string.IsNullOrEmpty(dr[0].ToString()) && Regex.IsMatch(dr[0].ToString(), @"^[A-Z]{2}\d{3}[A-Z]\d{2}$") && !string.IsNullOrEmpty(dr[1].ToString()) && (dr[1].ToString() == "S" || dr[1].ToString() == "R")) { int loc_id_exsit = _IiplasMgr.YesOrNoLocIdExsit(dr[0].ToString());//判斷料位是否存在 ic.loc_id = dr[0].ToString(); ic.lsta_id = "F"; ic.lcat_id = dr[1].ToString(); ic.create_dtim = DateTime.Now; ic.change_dtim = DateTime.Now; ic.create_user = create_user; ic.change_user = create_user; ic.loc_status = 1; ic.lev = GetIntByString(dr[2].ToString()); if (loc_id_exsit > 0) { DataRow drtwo = DTIlocExcel.NewRow(); drtwo[0] = dr[0].ToString(); drtwo[1] = dr[1].ToString(); drtwo[2] = dr[2].ToString(); drtwo[3] = "該料位已存在"; DTIlocExcel.Rows.Add(drtwo); errorcount++; continue; } else//料位不存在 { string has = hashpt.Md5Encrypt(ic.loc_id, "16"); strsql.AppendFormat(@"insert into iloc(dc_id,whse_id,loc_id,llts_id,bkfill_loc,ldes_id, ldim_id,x_coord,y_coord,z_coord,bkfill_x_coord,bkfill_y_coord, bkfill_z_coord,lsta_id,sel_stk_pos,sel_seq_loc,sel_pos_hgt,rsv_stk_pos, rsv_pos_hgt,stk_lmt,stk_pos_wid,lev,lhnd_id,ldsp_id, create_user,create_dtim,comingle_allow,change_user,change_dtim,lcat_id, space_remain,max_loc_wgt,loc_status,stk_pos_dep,hash_loc_id ) values ('{0}','{1}','{2}','{3}','{4}','{5}', '{6}','{7}','{8}','{9}','{10}','{11}', '{12}','{13}','{14}','{15}','{16}','{17}', '{18}','{19}','{20}','{21}','{22}','{23}', '{24}','{25}','{26}','{27}','{28}','{29}', '{30}','{31}','{32}','{33}','{34}');", ic.dc_id, ic.whse_id, ic.loc_id, ic.llts_id, ic.bkfill_loc, ic.ldes_id, ic.ldim_id, ic.x_coord, ic.y_coord, ic.z_coord, ic.bkfill_x_coord, ic.bkfill_y_coord, ic.bkfill_z_coord, ic.lsta_id, ic.sel_stk_pos, ic.sel_seq_loc, ic.sel_pos_hgt, ic.rsv_stk_pos, ic.rsv_pos_hgt, ic.stk_lmt, ic.stk_pos_wid, ic.lev, ic.lhnd_id, ic.ldsp_id, ic.create_user, BLL.gigade.Common.CommonFunction.DateTimeToString(ic.create_dtim), ic.comingle_allow, ic.change_user, BLL.gigade.Common.CommonFunction.DateTimeToString(ic.change_dtim), ic.lcat_id, ic.space_remain, ic.max_loc_wgt, ic.loc_status, ic.stk_pos_dep, has ); result = _IlocMgr.SaveBySql(strsql.ToString()); if (result > 0) { count++; continue; } else { DataRow drtwo = DTIlocExcel.NewRow(); drtwo[0] = dr[0].ToString(); drtwo[1] = dr[1].ToString(); drtwo[2] = dr[2].ToString(); drtwo[3] = "料位插入數據庫時失敗"; DTIlocExcel.Rows.Add(drtwo); entercount++; continue; } } } else { DataRow drtwo = DTIlocExcel.NewRow(); drtwo[0] = dr[0].ToString(); drtwo[1] = dr[1].ToString(); drtwo[2] = dr[2].ToString(); drtwo[3] = "料位編號或者料位類型或者所在層數不符合格式"; DTIlocExcel.Rows.Add(drtwo); errorcount++; continue; } } catch { DataRow drtwo = DTIlocExcel.NewRow(); drtwo[0] = dr[0].ToString(); drtwo[1] = dr[1].ToString(); drtwo[2] = dr[2].ToString(); drtwo[3] = "數據異常"; DTIlocExcel.Rows.Add(drtwo); errorcount++; continue; } } if (count > 0) { json = "{success:true,total:" + count + ",error:" + errorcount + ",entercount:" + entercount + "}"; } else { json = "{success:true,total:" + 0 + ",error:" + errorcount + ",entercount:" + entercount + "}"; } } else { json = "{success:true,total:" + 0 + ",error:" + 0 + ",entercount" + 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); json = "{success:false,data:" + "" + "}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveWebContentType2() { WebContentType2 model = new WebContentType2(); WebContentType2 oldModel = new WebContentType2(); int isTranInt = 0; if (!String.IsNullOrEmpty(Request.Params["rowid"]))//如果不存在該id說明是添加頁面 { model.content_id = Convert.ToInt32(Request.Params["rowid"].ToString()); oldModel = _wctMgr2.GetModel(model); } #region 獲取數據 model.site_id = 7; try { model.page_id = Convert.ToInt32(Request.Params["page_id"].ToString()); } catch { model.page_id = oldModel.page_id; } try { model.area_id = Convert.ToInt32(Request.Params["area_id"].ToString()); } catch { model.area_id = oldModel.area_id; } model.content_title = Request.Params["content_title"].ToString(); model.home_title = Request.Params["home_title"].ToString(); model.home_text = Request.Params["home_text"].ToString(); #region 圖片上傳 try { ImagePathConfig(); for (int iFile = 0; iFile < Request.Files.Count; iFile++) { HttpPostedFileBase file = Request.Files[iFile]; 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(localHealthPath.Substring(0, localHealthPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/'), ftpuser, ftppwd); // CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/')); // returnName += promoPath + NewFileName; fileName = NewFileName + fileExtention; NewFileName = localHealthPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + healthPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.content_id != 0) { string oldFileName = oldModel.content_image; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localHealthPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localHealthPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localHealthPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } 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)//上傳成功 { model.content_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); model.content_image = oldModel.content_image; } if (!string.IsNullOrEmpty(ErrorMsg)) { string json = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { model.content_image = oldModel.content_image; } } } catch (Exception) { model.content_image = oldModel.content_image; } #endregion if (!string.IsNullOrEmpty(Request.Params["product_id"].ToString())) { if (int.TryParse(Request.Params["product_id"].ToString(), out isTranInt)) { model.product_id = Convert.ToInt32(Request.Params["product_id"]); } else { model.product_id = oldModel.product_id; } } else { model.product_id = 0; } model.content_default = Convert.ToInt32(Request.Params["content_default"]); model.content_status = Convert.ToInt32(Request.Params["content_status"]); model.link_url = Request.Params["link_url"].ToString(); if (!string.IsNullOrEmpty(Request.Params["start_time"].ToString())) { model.start_time = DateTime.Parse(Request.Params["start_time"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["end_time"].ToString())) { model.end_time = DateTime.Parse(Request.Params["end_time"].ToString()); } //model.link_page = Request.Params["link_page"].ToString(); model.link_mode = Convert.ToInt32(Request.Params["link_mode"]); #endregion //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["content_id"]))//如果不存在該id說明是添加頁面 { model.created_on = DateTime.Now; model.update_on = model.created_on;//這裡加上各種參數 return InsertWebContentType2(model);//如果獲取不到則進行新增 } else { model.update_on = DateTime.Now;//這裡加上各種參數 return updateWebContentType2(model);//如果可以獲取到rowid則進行修改 } }
public ActionResult upLoadImg() { HttpPostedFileBase file = Request.Files["Filedata"]; int type = Request["appOrexplain"] == null ? 0 : Convert.ToInt32(Request["appOrexplain"]); string nameType = Request.Params["nameType"];// 將 nametype 提前 使其判斷傳入的圖片是否為商品主圖 edit by zhuoqin0830w 2015/01/29 int prodCheck = file.FileName.LastIndexOf("prod_");// 將 proCheck 提前 使其判斷批量上傳的圖片中是否存在商品主圖 edit by zhuoqin0830w 2015/01/30 if (prodCheck == 0 && type == 0) { type = 3; } int mobileCheck = file.FileName.LastIndexOf("mobile_"); if (mobileCheck == 0 && type == 0) { type = 4; } string path = Server.MapPath(xmlPath); siteConfigMgr = new SiteConfigMgr(path); ViewBag.moreFileOneTime = false; SiteConfig extention_config = siteConfigMgr.GetConfigByName("PIC_Extention_Format"); SiteConfig minValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); SiteConfig maxValue_config = null; //判斷 批量上傳 或 單個上傳 的圖片是否為 商品主圖 或 手機商品圖 edit by zhuoqin0830w 2015/03/24 switch (nameType) { //如果 nameType == prod 則表示 是 單個上傳 商品主圖 case "prod": maxValue_config = siteConfigMgr.GetConfigByName("PIC_280_Length_Max"); break; //如果 nameType == mobile 則表示 是 單個上傳 手機商品圖 case "mobile": maxValue_config = siteConfigMgr.GetConfigByName("PIC_640_Length_Max"); break; //如果 nameType == null 則表示 是 批量上傳 case null: //如果 prodCheck == 0 則表示 是 單個上傳 商品主圖 if (prodCheck == 0) { maxValue_config = siteConfigMgr.GetConfigByName("PIC_280_Length_Max"); } //如果 mobileCheck == 0 則表示 是 單個上傳 手機商品圖 else if (mobileCheck == 0) { maxValue_config = siteConfigMgr.GetConfigByName("PIC_640_Length_Max"); } else { maxValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); } break; default: maxValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); break; } 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; if ((nameType == "mobile" && type == 4) || (mobileCheck == 0 && type == 4)) //add by wwei0216w 2015/4/1 添加原因:手機圖片要放在640*640路徑下 { prodPath = prodMobile640; } string localProdPath = imgLocalPath + prodPath; //string localProd50Path = imgLocalPath + prod50Path; //string localProd150Path = imgLocalPath + prod150Path; //string localProd280Path = imgLocalPath + prod280Path; string localSpecPath = imgLocalPath + specPath; //string localSpec100Path = imgLocalPath + spec100Path; //string localSpec280Path = imgLocalPath + spec280Path; string[] Mappath = new string[2]; FileManagement fileLoad = new FileManagement(); string fileName = string.Empty; string fileExtention = string.Empty; ViewBag.spec_id = -1; if (nameType != null) { fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower(); } else { #region 批次上傳圖片操作 //此處由批次上傳進入. //判斷文件名格式是否正確 ViewBag.moreFileOneTime = true; //int prodCheck = file.FileName.LastIndexOf("prod_"); //int specCheck = file.FileName.LastIndexOf("spec_"); int descCheck = file.FileName.LastIndexOf("desc_"); int appCheck = file.FileName.LastIndexOf("app_"); string errorMsg = "ERROR/"; if (prodCheck == -1 && descCheck == -1 && appCheck == -1 && mobileCheck == -1) { errorMsg += "[" + file.FileName + "] "; errorMsg += Resources.Product.FILE_NAME_ERROR; ViewBag.fileName = errorMsg; return View("~/Views/Product/upLoad.cshtml"); } else { nameType = file.FileName.Split('_')[0]; if (nameType == "app") { type = 2; } else if (nameType == "desc") { type = 1; } fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')); } #endregion } SetPath(type);//設定圖片路徑 string localDescPath = imgLocalPath + descPath; //string localDesc400Path = imgLocalPath + desc400Path; string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; string ServerPath = string.Empty; if (nameType == "desc" || nameType == "app") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(localDescPath, Mappath); //CreateFolder(localDesc400Path, Mappath); localDescPath += firstFolder + secondFolder; //localDesc400Path += firstFolder + secondFolder; descPath += firstFolder + secondFolder; //localDesc400Path += NewFileName + fileExtention; returnName += descPath + NewFileName + fileExtention; NewFileName = localDescPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + descPath); } else { Mappath[0] = firstFolder; Mappath[1] = secondFolder; //Data:2014/06/26 //author:Castle //在前台如果各种尺寸的图档没有的时候,前台会自动产生!!! CreateFolder(localProdPath, Mappath); localProdPath += firstFolder + secondFolder; prodPath += firstFolder + secondFolder; returnName += prodPath + NewFileName + fileExtention; NewFileName = localProdPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + prodPath); } string ErrorMsg = string.Empty; Resource.CoreMessage = new CoreResource("Product"); try { //上傳圖片 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); //上傳對應大小圖片 //压缩图片至其它规格 } 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)) { ViewBag.fileName = returnName; ViewBag.Type = type; //獲取文件長度 add by zhuoqin0830w 2015/01/29 string[] strFile = file.FileName.Split('_'); //判斷文件名的長度是否大於 1 如果大於 1 則再次進行判斷是否為數字 如果不是則進行強制轉換 int image_sort = 0; int.TryParse(strFile.Length > 1 ? strFile[1] : "0", out image_sort); ViewBag.image_sort = image_sort; } else { // 判斷 批量上傳中 是否存在 商品圖 或 手機商品圖 edit by zhuoqin0830w 2015/03/24 if (prodCheck == 0 || mobileCheck == 0) { ViewBag.fileName = "ERROR/" + "[" + file.FileName + "] " + ErrorMsg; } else { ViewBag.fileName = "ERROR/" + "[" + file.FileName + "] " + ErrorMsg; } Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = "ERROR/" + ErrorMsg; logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return View("~/Views/Product/upLoad.cshtml"); }
public ActionResult upLoadImg() { try { HttpPostedFileBase file = Request.Files["Filedata"]; int type = Request["appOrexplain"] == null ? 0 : Convert.ToInt32(Request["appOrexplain"]); string nameType = Request.Params["nameType"]; // 將 nametype 提前 使其判斷傳入的圖片是否為商品主圖 edit by zhuoqin0830w 2015/01/29 int prodCheck = file.FileName.LastIndexOf("prod_"); // 將 proCheck 提前 使其判斷批量上傳的圖片中是否存在商品主圖 edit by zhuoqin0830w 2015/01/30 if (nameType == "spec") { type = 5; } if (prodCheck == 0 && type == 0) //批量上傳時type才會 ==0,其他單獨上傳時是不需要根據prod處理圖片的 { type = 3; } int mobileCheck = file.FileName.LastIndexOf("mobile_");//批量上傳時type才會 ==0,其他單獨上傳時是不需要根據prod處理圖片的 if (mobileCheck == 0 && type == 0) { type = 4; } string path = Server.MapPath(xmlPath); siteConfigMgr = new SiteConfigMgr(path); SiteConfig extention_config = siteConfigMgr.GetConfigByName("PIC_Extention_Format"); SiteConfig minValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MinValue"); SiteConfig maxValue_config = null; //判斷 批量上傳 或 單個上傳 的圖片是否為 商品主圖 或 手機商品圖 edit by zhuoqin0830w 2015/03/24 switch (nameType) { //如果 nameType == prod 則表示 是 單個上傳 商品主圖 case "prod": maxValue_config = siteConfigMgr.GetConfigByName("PIC_280_Length_Max"); break; //如果 nameType == mobile 則表示 是 單個上傳 手機商品圖 case "mobile": maxValue_config = siteConfigMgr.GetConfigByName("PIC_640_Length_Max"); break; //如果 nameType == null 則表示 是 批量上傳 case null: //如果 prodCheck == 0 則表示 是 批量上傳 中包含 商品主圖 if (prodCheck == 0) { maxValue_config = siteConfigMgr.GetConfigByName("PIC_280_Length_Max"); } //如果 mobileCheck == 0 則表示 是 批量上傳 中包含 手機商品圖 else if (mobileCheck == 0) { maxValue_config = siteConfigMgr.GetConfigByName("PIC_640_Length_Max"); } else { maxValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); } break; default: maxValue_config = siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); break; } 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; if ((nameType == "mobile" && type == 4) || (mobileCheck == 0 && type == 4)) //add by wwei0216w 2015/4/1 添加原因:手機圖片要放在640*640路徑下 { prodPath = prodMobile640; } string localProdPath = imgLocalPath + prodPath; //string localProd50Path = imgLocalPath + prod50Path; //string localProd150Path = imgLocalPath + prod150Path; //string localProd280Path = imgLocalPath + prod280Path; string localSpecPath = imgLocalPath + specPath; //string localSpec100Path = imgLocalPath + spec100Path; //string localSpec280Path = imgLocalPath + spec280Path; string[] Mappath = new string[2]; FileManagement fileLoad = new FileManagement(); string fileName = string.Empty; string fileExtention = string.Empty; ViewBag.spec_id = -1; if (nameType != null) { fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower(); } else { #region 批次上傳圖片操作 //此處由批次上傳進入. //判斷文件名格式是否正確 ViewBag.moreFileOneTime = true; //int prodCheck = file.FileName.LastIndexOf("prod_"); int specCheck = file.FileName.LastIndexOf("spec_"); int descCheck = file.FileName.LastIndexOf("desc_"); int appCheck = file.FileName.LastIndexOf("app_"); string errorMsg = "ERROR/"; if (prodCheck == -1 && specCheck == -1 && descCheck == -1 && appCheck == -1 && mobileCheck == -1) { errorMsg += "[" + file.FileName + "] "; errorMsg += Resources.Product.FILE_NAME_ERROR; ViewBag.fileName = errorMsg; return View("~/Views/Product/upLoad.cshtml"); } else { nameType = file.FileName.Split('_')[0]; if (nameType == "app") { type = 2; } else if (nameType == "desc") { type = 1; } else if (nameType == "spec") { type = 5; } fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')); } if (specCheck == 0) { Caller _caller = (Session["caller"] as Caller); string spec = file.FileName.Split('_')[1].Split('.')[0]; bool checkStatus = true; if (!string.IsNullOrEmpty(Request.Params["product_id"].Split(';')[0].ToString())) { //product_spec uint pid = uint.Parse(Request.Params["product_id"].Split(';')[0].ToString()); _specMgr = new ProductSpecMgr(connectionString); List<ProductSpec> pSpecList = _specMgr.Query(new ProductSpec { product_id = pid, spec_type = 1 }); foreach (var item in pSpecList) { if (item.spec_name == spec) { checkStatus = false; ViewBag.spec_id = item.spec_id; } } } else { //product_spec_temp _specTempMgr = new ProductSpecTempMgr(connectionString); List<ProductSpecTemp> pSpecTempList = _specTempMgr.Query(new ProductSpecTemp { Writer_Id = _caller.user_id, spec_type = 1 }); foreach (var item in pSpecTempList) { if (item.spec_name == spec) { checkStatus = false; ViewBag.spec_id = item.spec_id; } } } if (checkStatus)//表示沒有要上傳圖片規格相同的規格一 { errorMsg += "[" + file.FileName + "] " + Resources.Product.SPEC_NOT_FIND; ViewBag.fileName = errorMsg; return View("~/Views/Product/upLoad.cshtml"); } } #endregion } SetPath(type);//設定圖片路徑 string localDescPath = imgLocalPath + descPath; //string localDesc400Path = imgLocalPath + desc400Path; string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; string ServerPath = string.Empty; if (nameType == "spec") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(localSpecPath, Mappath); //CreateFolder(localSpec100Path, Mappath); //CreateFolder(localSpec280Path, Mappath); localSpecPath += firstFolder + secondFolder; //localSpec100Path += firstFolder + secondFolder; //localSpec280Path += firstFolder + secondFolder; specPath += firstFolder + secondFolder; returnName += specPath + NewFileName + fileExtention; //localSpec100Path += NewFileName + fileExtention; //localSpec280Path += NewFileName + fileExtention; NewFileName = localSpecPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + specPath); } else if (nameType == "desc" || nameType == "app") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(localDescPath, Mappath); //CreateFolder(localDesc400Path, Mappath); localDescPath += firstFolder + secondFolder; //localDesc400Path += firstFolder + secondFolder; descPath += firstFolder + secondFolder; //localDesc400Path += NewFileName + fileExtention; returnName += descPath + NewFileName + fileExtention; NewFileName = localDescPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + descPath); } else { Mappath[0] = firstFolder; Mappath[1] = secondFolder; //Data:2014/06/26 //author:Castle //在前台如果各种尺寸的图档没有的时候,前台会自动产生!!! CreateFolder(localProdPath, Mappath); //CreateFolder(localProd50Path, Mappath); //CreateFolder(localProd150Path, Mappath); //CreateFolder(localProd280Path, Mappath); localProdPath += firstFolder + secondFolder; //localProd50Path += firstFolder + secondFolder; //localProd150Path += firstFolder + secondFolder; //localProd280Path += firstFolder + secondFolder; prodPath += firstFolder + secondFolder; //localProd50Path += NewFileName + fileExtention; //localProd150Path += NewFileName + fileExtention; //localProd280Path += NewFileName + fileExtention; returnName += prodPath + NewFileName + fileExtention; NewFileName = localProdPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + prodPath); } string ErrorMsg = string.Empty; Resource.CoreMessage = new CoreResource("Product"); //上傳圖片 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); #region // //上傳對應大小圖片 //压缩图片至其它规格 //Data:2014/06/26 //author:Castle //在前台如果各种尺寸的图档没有的时候,前台会自动产生!!! //if (result) //{ // FTP ftp = null; // string newFileName = NewFileName.Substring(NewFileName.LastIndexOf("/")); // GigadeService.TransImageClient transImg = new GigadeService.TransImageClient(); // if (nameType == "spec") // { // string sourceImgPath = Server.MapPath(imgLocalServerPath + specPath + NewFileName.Substring(NewFileName.LastIndexOf("/"))); // ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + spec100Path + firstFolder + secondFolder), newFileName, 100, 100, admin_userName.Value, admin_passwd.Value); // if (string.IsNullOrWhiteSpace(ErrorMsg)) // { // file.SaveAs(Server.MapPath(imgLocalServerPath + spec100Path + firstFolder + secondFolder + newFileName)); // ftp = new FTP(localSpec100Path, ftpuser, ftppwd); // ftp.UploadFile(Server.MapPath(imgLocalServerPath + spec100Path + firstFolder + secondFolder + newFileName)); // } // if (!Directory.Exists(Server.MapPath(imgLocalServerPath + spec280Path + firstFolder + secondFolder))) // Directory.CreateDirectory(Server.MapPath(imgLocalServerPath + spec280Path + firstFolder + secondFolder)); // ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + spec280Path + firstFolder + secondFolder), newFileName, 280, 280, admin_userName.Value, admin_passwd.Value); // if (string.IsNullOrWhiteSpace(ErrorMsg)) // { // file.SaveAs(Server.MapPath(imgLocalServerPath + spec280Path + firstFolder + secondFolder + newFileName)); // ftp = new FTP(localSpec100Path, ftpuser, ftppwd); // ftp.UploadFile(Server.MapPath(imgLocalServerPath + spec280Path + firstFolder + secondFolder + newFileName)); // } // } // else if (nameType == "desc") // { // string sourceImgPath = Server.MapPath(imgLocalServerPath + descPath + NewFileName.Substring(NewFileName.LastIndexOf("/"))); // ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + desc400Path + firstFolder + secondFolder), newFileName, 400, 400, admin_userName.Value, admin_passwd.Value); // if (string.IsNullOrWhiteSpace(ErrorMsg)) // { // file.SaveAs(Server.MapPath(imgLocalServerPath + desc400Path + firstFolder + secondFolder + newFileName)); // ftp = new FTP(localSpec100Path, ftpuser, ftppwd); // ftp.UploadFile(Server.MapPath(imgLocalServerPath + desc400Path + firstFolder + secondFolder + newFileName)); // } // } // else // { // //string sourceImgPath = Server.MapPath(imgLocalServerPath + prodPath + NewFileName.Substring(NewFileName.LastIndexOf("/"))); // //ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + prod50Path + firstFolder + secondFolder), newFileName, 50, 50, admin_userName.Value, admin_passwd.Value); // //if (string.IsNullOrWhiteSpace(ErrorMsg)) // //{ // // file.SaveAs(Server.MapPath(imgLocalServerPath + prod50Path + firstFolder + secondFolder + newFileName)); // // ftp = new FTP(localProd50Path, ftpuser, ftppwd); // // ftp.UploadFile(Server.MapPath(imgLocalServerPath + prod50Path + firstFolder + secondFolder + newFileName)); // //} // //ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + prod150Path + firstFolder + secondFolder), newFileName, 150, 150, admin_userName.Value, admin_passwd.Value); // //if (string.IsNullOrWhiteSpace(ErrorMsg)) // //{ // // file.SaveAs(Server.MapPath(imgLocalServerPath + prod150Path + firstFolder + secondFolder + newFileName)); // // ftp = new FTP(localProd150Path, ftpuser, ftppwd); // // ftp.UploadFile(Server.MapPath(imgLocalServerPath + prod150Path + firstFolder + secondFolder + newFileName)); // //} // ////if (!Directory.Exists(Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder))) // //// Directory.CreateDirectory(Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder)); // ////ImageClass iC280 = new ImageClass(sourceImgPath); // //////iC280.ImageMagick(sourceImgPath, Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder + NewFileName.Substring(NewFileName.LastIndexOf("/"))), 280, 280, ref error); // ////iC150.MakeThumbnail(Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder + NewFileName.Substring(NewFileName.LastIndexOf("/"))), 280, 280, ref error); // //ErrorMsg = transImg.Trans(sourceImgPath, Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder), newFileName, 280, 280, admin_userName.Value, admin_passwd.Value); // //if (string.IsNullOrWhiteSpace(ErrorMsg)) // //{ // // file.SaveAs(Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder + newFileName)); // // ftp = new FTP(localProd280Path, ftpuser, ftppwd); // // ftp.UploadFile(Server.MapPath(imgLocalServerPath + prod280Path + firstFolder + secondFolder + newFileName)); // //} // } //} #endregion if (string.IsNullOrEmpty(ErrorMsg)) { ViewBag.fileName = returnName; ViewBag.Type = type; //獲取文件長度 add by zhuoqin0830w 2015/01/29 string[] strFile = file.FileName.Split('_'); //判斷文件名的長度是否大於 1 如果大於 1 則再次進行判斷是否為數字 如果不是則進行強制轉換 int image_sort = 0; int.TryParse(strFile.Length > 1 ? strFile[1] : "0", out image_sort); ViewBag.image_sort = image_sort; } else { // 判斷 批量上傳中 是否存在 商品圖 或 手機商品圖 edit by zhuoqin0830w 2015/03/24 if (prodCheck == 0 || mobileCheck == 0) { ViewBag.fileName = "ERROR/" + "[" + file.FileName + "] " + ErrorMsg; } else { ViewBag.fileName = "ERROR/" + "[" + file.FileName + "] " + ErrorMsg; } Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = "ERROR/" + ErrorMsg; logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } 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 View("~/Views/Product/upLoad.cshtml"); }
public HttpResponseBase ProductPreview() { _siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath)); _pMaster = new PriceMasterMgr(connectionString); List<SiteConfig> configList = _siteConfigMgr.Query(); PriceMaster Pm = new PriceMaster(); BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); string DomainName = configList.Where(m => m.Name.Equals("DoMain_Name")).FirstOrDefault().Value; string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["Product_Id"]))//商品ID { string type = Request.Form["Type"]; string product_id = Request.Form["Product_Id"].ToString(); string site_id = Request.Form["Site_Id"] == null ? "" : Request.Form["Site_Id"].ToString(); string user_level = Request.Form["Level"] == null ? "" : Request.Form["Level"].ToString(); string user_id = Request.Form["Master_User_Id"] == null ? "" : Request.Form["Master_User_Id"].ToString(); string result = ""; if (type == "0") { result += "http://" + DomainName + "/product.php?pid=" + product_id + "&view=" + DateTime.Now.ToString("yyyyMMdd");//商品預覽 } if (type == "1") { //商品預覽+價格頁面 result += "http://" + DomainName + "/product.php?pid=" + product_id + "&view=" + DateTime.Now.ToString("yyyyMMdd") + "&sid=" + site_id + "&ulv=" + user_level + "&uid=" + user_id + "&view=" + DateTime.Now.ToString("yyyyMMdd"); result += "|"; result += "http://" + DomainName + "/product.php?pid=" + product_id + "&sid=" + site_id + "&code=" + hash.Md5Encrypt(product_id + "&sid=" + site_id, "32");//商品隱賣連結: + "&ulv=" + user_level } json = result.ToString().ToLower(); } } 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 = "無預覽信息"; } 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 int HashAll() { StringBuilder sql = new StringBuilder(); StringBuilder str = new StringBuilder(); try { HashEncrypt hashpt=new HashEncrypt(); sql.AppendFormat("select row_id,loc_id,hash_loc_id from iloc where hash_loc_id is NULL;"); DataTable _dt = _access.getDataTable(sql.ToString()); for (int i = 0; i < _dt.Rows.Count; i++) { str.AppendFormat("UPDATE iloc SET hash_loc_id='{0}' WHERE row_id ='{1}';",hashpt.Md5Encrypt(_dt.Rows[i]["loc_id"].ToString(),"16"),_dt.Rows[i]["row_id"]); } if (!string.IsNullOrEmpty(str.ToString())) { return _access.execCommand(str.ToString()); } else { return 1; } } catch (Exception ex) { throw new Exception("IlocDao.HashAll-->" + ex.Message + str.ToString(), ex); } }
/// <summary> /// 上傳圖片 /// </summary> /// <returns></returns> public ActionResult SaveCourseImg() { string xmlPath = ConfigurationManager.AppSettings["SiteConfig"]; try { ViewBag.status = false; string path = Server.MapPath(xmlPath); ///<add key="SiteConfig" value="/Config.xml"/> ISiteConfigImplMgr 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_640_Length_Max"); 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; HttpPostedFileBase file = Request.Files["Filedata"]; //int courseCheck = file.FileName.LastIndexOf("course_"); string nameType = "course"; string imgServerPath = Unitle.GetImgGigade100ComSitePath(Unitle.ImgPathType.server); string coursePath = Unitle.GetImgGigade100ComPath(Unitle.ImgGigade100ComType.coursePath); string imgLocalPath = Unitle.GetImgGigade100ComSitePath(Unitle.ImgPathType.local);//<add key="imglocalpath" value=" ftp://192.168.18.166:2121/img"/> FTP路徑 string coursePicturePath = imgLocalPath + coursePath;//課程圖片保存路徑 string imgLocalServerPath = ConfigurationManager.AppSettings["imgLocalServerPath"]; string[] Mappath = new string[2]; FileManagement fileLoad = new FileManagement(); string fileName = string.Empty; string fileExtention = string.Empty; ViewBag.moreFileOneTime = true;//圖片狀態判斷 int courseNameCheck = file.FileName.LastIndexOf("course_");//獲取圖片前綴名稱 string errorMsg = "ERROR/"; //if (courseNameCheck==-1) //{ // errorMsg += "[" + file.FileName + "] "; // errorMsg += Resources.Product.FILE_NAME_ERROR; // ViewBag.fileName = errorMsg; // //return View("~/Views/Product/upLoad.cshtml"); // return View("~/Views/Course/upLoad.cshtml"); //} fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')); string NewFileName = string.Empty; string returnName = imgServerPath; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; string ServerPath = string.Empty; if (nameType == "course") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(coursePicturePath, Mappath); coursePicturePath += firstFolder + secondFolder; coursePath += firstFolder + secondFolder; returnName += coursePath + NewFileName + fileExtention; NewFileName = coursePicturePath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + coursePath); } string ErrorMsg = string.Empty; Resource.CoreMessage = new CoreResource("Product"); //上傳圖片 bool result = false; result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (string.IsNullOrEmpty(ErrorMsg)) { ViewBag.fileName = returnName; ViewBag.Type = nameType; ViewBag.status = true; //獲取文件長度 add by zhuoqin0830w 2015/01/29 string[] strFile = file.FileName.Split('_'); //判斷文件名的長度是否大於 1 如果大於 1 則再次進行判斷是否為數字 如果不是則進行強制轉換 int image_sort = 0; int.TryParse(strFile.Length > 1 ? strFile[1] : "0", out image_sort); ViewBag.image_sort = image_sort; } else { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = "ERROR/" + ErrorMsg; logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } 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 View("~/Views/Course/upLoad.cshtml"); }
/// <summary> /// 新增或者修改 /// </summary> /// <returns></returns> public HttpResponseBase SaveEvent() { string json = string.Empty; VoteEvent vevent = new VoteEvent(); veMgr = new VoteEventMgr(mySqlConnectionString); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); try { List<VoteEventQuery> store = new List<VoteEventQuery>(); VoteEventQuery veq = new VoteEventQuery(); if (!string.IsNullOrEmpty(Request.Params["event_id"])) { int totalCount = 0; veq.IsPage = false; veq.event_id = int.Parse(Request.Params["event_id"]); store = veMgr.GetVoteEventList(veq, out totalCount); } vevent.event_name = Request.Params["event_name"]; vevent.event_desc = Request.Params["event_desc"]; if (!string.IsNullOrEmpty(Request.Params["event_start"])) { vevent.event_start = DateTime.Parse(Request.Params["event_start"]); } if (!string.IsNullOrEmpty(Request.Params["event_end"])) { vevent.event_end = DateTime.Parse(Request.Params["event_end"]); } if (!string.IsNullOrEmpty(Request.Params["word_length"])) { vevent.word_length = int.Parse(Request.Params["word_length"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyone_limit"])) { vevent.vote_everyone_limit = int.Parse(Request.Params["vote_everyone_limit"]); } if (!string.IsNullOrEmpty(Request.Params["vote_everyday_limit"])) { vevent.vote_everyday_limit = int.Parse(Request.Params["vote_everyday_limit"]); } if (!string.IsNullOrEmpty(Request.Params["number_limit"])) { vevent.number_limit = int.Parse(Request.Params["number_limit"]); } if (!string.IsNullOrEmpty(Request.Params["is_repeat"])) { vevent.is_repeat = int.Parse(Request.Params["is_repeat"]); } vevent.present_event_id = Request.Params["present_event_id"]; vevent.event_status = 0; vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; vevent.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; #region 上傳圖片 string oldImg = string.Empty; foreach (var item in store) { oldImg = item.event_banner; } if (!string.IsNullOrEmpty(Request.Params["event_id"]) && Request.Params["event_banner"] == oldImg) { vevent.event_banner = oldImg; } else { string ServerPath = string.Empty; try { ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files["event_banner"] != null && Request.Files["event_banner"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["event_banner"]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = Path.GetFileName(file.FileName); //獲得後綴名 fileExtention = Path.GetExtension(file.FileName); //獲得不帶後綴名的文件名 fileName = Path.GetFileNameWithoutExtension(file.FileName); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { vevent.event_banner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } vevent.event_banner = ""; } } 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}"; } } #endregion if (!string.IsNullOrEmpty(Request.Params["event_id"])) { vevent.event_id = int.Parse(Request.Params["event_id"]); //rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString(); if (veMgr.Update(vevent) > 0) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:true,msg:'修改失敗!'}"; } } else { vevent.create_time = DateTime.Now; vevent.update_time = vevent.create_time; if (veMgr.Save(vevent) > 0) { json = "{success:true,msg:'保存成功!'}"; } else { json = "{success:true,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 SaveVoteArticle() { string json = string.Empty; #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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); #endregion try { _votearticle = new VoteArticleMgr(mySqlConnectionString); List<VoteArticleQuery> store = new List<VoteArticleQuery>(); VoteArticleQuery query = new VoteArticleQuery(); if (!string.IsNullOrEmpty(Request.Params["id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.article_id = int.Parse(Request.Params["id"]); store = _votearticle.GetAll(query, out totalCount); } //product_id if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } if (!string.IsNullOrEmpty(Request.Params["event_id"])) { query.event_id = Convert.ToInt32(Request.Params["event_id"]); } if (!string.IsNullOrEmpty(Request.Params["article_title"])) { query.article_title = Request.Params["article_title"]; } if (!string.IsNullOrEmpty(Request.Params["user_id"])) { query.user_id = int.Parse(Request.Params["user_id"]); } if (!string.IsNullOrEmpty(Request.Params["article_content"])) { query.article_content = Request.Params["article_content"]; } if (!string.IsNullOrEmpty(Request.Params["article_sort"])) { query.article_sort =Convert.ToInt32(Request.Params["article_sort"]); } if (!string.IsNullOrEmpty(Request.Params["prod_link"])) { query.prod_link = Request.Params["prod_link"]; } if (!string.IsNullOrEmpty(Request.Params["vote_count"])) { query.vote_count = int.Parse(Request.Params["vote_count"]); } if (!string.IsNullOrEmpty(Request.Params["article_start_time"])) { query.article_start_time =Convert.ToDateTime(Request.Params["article_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_end_time"])) { query.article_end_time = Convert.ToDateTime(Request.Params["article_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_show_start_time"])) { query.article_show_start_time = Convert.ToDateTime(Request.Params["article_show_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["article_show_end_time"])) { query.article_show_end_time = Convert.ToDateTime(Request.Params["article_show_end_time"]); } #region 上傳圖片 string oldImg = string.Empty; foreach (var item in store) { oldImg = item.article_banner; } if (!string.IsNullOrEmpty(Request.Params["id"]) && Request.Params["article_banner"] == oldImg) { query.article_banner = oldImg; } else { string ServerPath = string.Empty; try { ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); if (Request.Files["article_banner"] != null && Request.Files["article_banner"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["article_banner"]; string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = Path.GetFileName(file.FileName); //獲得後綴名 fileExtention = Path.GetExtension(file.FileName); //獲得不帶後綴名的文件名 fileName = Path.GetFileNameWithoutExtension(file.FileName); string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { query.article_banner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } query.article_banner = ""; } } 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:'圖片上傳失敗!'}"; } } #endregion query.article_status = 0;//默認啟用 query.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.create_time = DateTime.Now; query.update_time = DateTime.Now; if (query.article_id > 0) {//編輯 if (_votearticle.Update(query) > 0) { json = "{success:true}"; } else { json = "{success:false,msg:'修改失敗!'}"; } } else {//新增 if (_votearticle.Save(query) > 0) { json = "{success:true}"; } 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase BannerImageEdit() { string json = string.Empty; BannerContent bc = new BannerContent(); Serial serial = new Serial(); _bcMgr = new BannerContentMgr(mySqlConnectionString); _ISerImplMgr = new SerialMgr(mySqlConnectionString); serial = _ISerImplMgr.GetSerialById(72); 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 = imgLocalServerPath + promoPath;//圖片存儲地址 /aimg.gigade100.com/ +/promotion/dev/ string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { string oldImg = string.Empty; serial = _ISerImplMgr.GetSerialById(6); List<BannerContent> store = new List<BannerContent>(); if (!string.IsNullOrEmpty(Request.Params["banner_content_id"])) { int totalCount = 0; bc.IsPage = false; bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (Request.Params["history"] == "1") { bc.banner_status = 3; } store = _bcMgr.GetList(bc, out totalCount); foreach (var item in store) { oldImg = item.banner_image; } } bc = new BannerContent(); bc.banner_title = Request.Params["banner_title"]; bc.banner_link_url = Request.Params["banner_link_url"]; if (!string.IsNullOrEmpty(Request.Params["banner_site_id"])) { bc.banner_site_id = uint.Parse(Request.Params["banner_site_id"]); } if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"])) { bc.banner_link_mode = int.Parse(Request.Params["banner_link_mode"]); } if (!string.IsNullOrEmpty(Request.Params["banner_sort"])) { bc.banner_sort = uint.Parse(Request.Params["banner_sort"]); } if (!string.IsNullOrEmpty(Request.Params["banner_statuses"])) { bc.banner_status = uint.Parse(Request.Params["banner_statuses"]); } if (!string.IsNullOrEmpty(Request.Params["banner_start"])) { bc.banner_start = DateTime.Parse(DateTime.Parse(Request.Params["banner_start"]).ToString("yyyy-MM-dd") + " 00:00:00"); } if (!string.IsNullOrEmpty(Request.Params["banner_end"])) { bc.banner_end = DateTime.Parse(DateTime.Parse(Request.Params["banner_end"]).ToString("yyyy-MM-dd") + " 23:59:59"); } bc.banner_ipfrom = CommonFunction.GetClientIPNew(); if (bc.banner_ipfrom == "::1") { bc.banner_ipfrom = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName())[2].ToString(); } if (!string.IsNullOrEmpty(Request.Params["banner_content_id"]) && Request.Params["banner_image"] == oldImg) { bc.banner_image = oldImg; } if (Request.Files["banner_image"] != null && Request.Files["banner_image"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["banner_image"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; string filename = NewName.Substring(0, NewName.LastIndexOf(".")); //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是哈希字符串 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(filename, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; NewFileName = NewFileName + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; string localPromoDirectory = Server.MapPath(localPromoPath); if (!System.IO.Directory.Exists(localPromoDirectory)) { System.IO.Directory.CreateDirectory(localPromoDirectory); } FTP ftp = new FTP(); string directorys = promoPath + firstFolder + secondFolder; ftp.MakeMultiDirectory(imgLocalPath+"/", directorys.Substring(1, directorys.Length - 2).Split('/'), ftpuser, ftppwd); //NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(localPromoPath + firstFolder + secondFolder); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, imgLocalPath + directorys + NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (!result) { json = "{success:false,msg:'圖片上傳失敗!'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } bc.banner_image = NewName; string oldImgPath = string.Empty; string ftppath = string.Empty; if (oldImg.Length >= 4) { oldImgPath = localPromoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/" + oldImg; } if (System.IO.File.Exists(Server.MapPath(oldImgPath))) { ftppath=imgLocalPath + promoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/"; System.IO.File.Delete(Server.MapPath(oldImgPath)); FTP ftp1 = new FTP(ftppath, ftpuser, ftppwd); List<string> tem = ftp1.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(ftppath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(ftppath + oldImg); } } } else { json = "{success:false,msg:'上傳圖片不能超過" + maxValue + "K'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } #region 新增 if (String.IsNullOrEmpty(Request.Params["banner_content_id"])) { bc.banner_content_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_bcMgr.Add(bc) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ json = "{success:true,msg:\"" + "新增成功!" + "\"}"; } } #endregion #region 編輯 else { bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]); if (_bcMgr.Update(bc) > 0) { json = "{success:true,msg:\"" + "修改成功!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public ActionResult UpLoadImg() { string path = Server.MapPath(xmlPath); 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 elementPath = ConfigurationManager.AppSettings["elementPath"]; FileManagement fileLoad = new FileManagement(); HttpPostedFileBase file = Request.Files["Filedata"]; string fileName = string.Empty; string fileExtention = string.Empty; string[] Mappath = new string[2]; fileName = fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower(); string localElePath = imgLocalPath + elementPath; string returnName = imgServerPath;////"http://192.168.71.159:8080" bool result = false; string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; string ServerPath = string.Empty; Mappath[0] = firstFolder; Mappath[1] = secondFolder; //CreateFolder(localElePath, Mappath); // localElePath += firstFolder + secondFolder; // elementPath += firstFolder + secondFolder; returnName += elementPath + NewFileName + fileExtention; NewFileName = localElePath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + elementPath); string ErrorMsg = string.Empty; try { result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); } 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)) { ViewBag.fileName = returnName; ViewBag.Type = "pic"; } else { ViewBag.fileName = "ERROR/" + ErrorMsg; Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = "ERROR/" + ErrorMsg; logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return View("~/Views/PromotionsAmountTrial/upLoad.cshtml"); }
public HttpResponseBase SaveChinatrust() { string json = string.Empty; try { _eventChinatrust = new EventChinatrustMgr(mySqlConnectionString); FileManagement fileLoad = new FileManagement(); EventChinatrustQuery query = new EventChinatrustQuery(); EventChinatrustQuery oldModel = new EventChinatrustQuery(); List<EventChinatrustQuery> store = new List<EventChinatrustQuery>(); if (!string.IsNullOrEmpty(Request.Params["row_id"])) {//如果是編輯獲取該id數據 int totalCount = 0; query.IsPage = false; query.event_active = -1; query.row_id = int.Parse(Request.Params["row_id"]); store = _eventChinatrust.GetEventChinatrustList(query, out totalCount); } #region 需要更改的屬性 if (!string.IsNullOrEmpty(Request.Params["row_id"])) { query.row_id = Convert.ToInt32(Request.Params["row_id"]); } 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["event_start_time"])) { query.event_start_time = DateTime.Parse(Request.Params["event_start_time"]); } if (!string.IsNullOrEmpty(Request.Params["event_end_time"])) { query.event_end_time = DateTime.Parse(Request.Params["event_end_time"]); } if (!string.IsNullOrEmpty(Request.Params["user_register_time"])) { query.user_register_time=DateTime.Parse(Request.Params["user_register_time"]); } if (!string.IsNullOrEmpty(Request.Params["event_banner"])) { query.event_banner = Request.Params["event_banner"]; } #endregion query.event_type = "EC"; #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;//當前文件的擴展名 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.row_id != 0) { oldModel = store.FirstOrDefault(); if (oldModel.event_banner != "") { string oldFileName = oldModel.event_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");//尋找product.resx中的資源文件 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { query.event_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(); return this.Response; } } } #endregion if (query.row_id == 0) { query.event_create_time = DateTime.Now; query.event_update_time = query.event_create_time; query.event_create_user = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); query.event_update_user = query.event_create_user; if (_eventChinatrust.AddEventChinatrust(query) > 0) { json = "{success:true }"; } else { json = "{success:false,msg:'新增失敗!'}"; } } else { query.event_update_time = DateTime.Now; query.event_update_user = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id); if (_eventChinatrust.UpdateEventChinatrust(query) > 0) { json = "{success:true }"; } 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}"; } this.Response.Clear(); this.Response.Write(json.ToString()); this.Response.End(); return this.Response; }
public ActionResult upLoadImg() { BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];//獲取當前登入的供應商 int writerID = (int)vendorModel.vendor_id; string path = Server.MapPath(xmlPath); siteConfigMgr = new SiteConfigMgr(path); ViewBag.moreFileOneTime = false; 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 localProdPath = imgLocalPath + prodPath; //string localProd50Path = imgLocalPath + prod50Path; //string localProd150Path = imgLocalPath + prod150Path; //string localProd280Path = imgLocalPath + prod280Path; string localSpecPath = imgLocalPath + specPath; //string localSpec100Path = imgLocalPath + spec100Path; //string localSpec280Path = imgLocalPath + spec280Path; string localDescPath = imgLocalPath + descPath; //string localDesc400Path = imgLocalPath + desc400Path; string[] Mappath = new string[2]; FileManagement fileLoad = new FileManagement(); HttpPostedFileBase file = Request.Files["Filedata"]; string nameType = Request.Params["nameType"]; string fileName = string.Empty; string fileExtention = string.Empty; ViewBag.spec_id = -1; if (nameType != null) { fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower(); } else { #region 批次上傳圖片操作 //此處由批次上傳進入. //判斷文件名格式是否正確 ViewBag.moreFileOneTime = true; int prodCheck = file.FileName.LastIndexOf("prod_"); int specCheck = file.FileName.LastIndexOf("spec_"); int descCheck = file.FileName.LastIndexOf("desc_"); string errorMsg = "ERROR/"; if (prodCheck == -1 && specCheck == -1 && descCheck == -1) { errorMsg += "[" + file.FileName + "] "; errorMsg += Resources.VendorProduct.FILE_NAME_ERROR; ViewBag.fileName = errorMsg; return View("~/Views/VendorProduct/upLoad.cshtml"); } else { nameType = file.FileName.Split('_')[0]; fileName = nameType + fileLoad.NewFileName(file.FileName); fileName = fileName.Substring(0, fileName.LastIndexOf(".")); fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')); } if (specCheck == 0) { //Caller _caller = (Session["caller"] as Caller); ProductSpecTemp proSpecTemp = new ProductSpecTemp(); string spec = file.FileName.Split('_')[1].Split('.')[0]; bool checkStatus = true; if (!string.IsNullOrEmpty(Request.Params["product_id"].Split(';')[0].ToString())) { //product_spec proSpecTemp.product_id = Request.Params["product_id"].Split(';')[0].ToString(); } //product_spec_temp _specTempMgr = new ProductSpecTempMgr(connectionString); List<ProductSpecTemp> pSpecTempList = _specTempMgr.VendorQuery(new ProductSpecTemp { Writer_Id = writerID, spec_type = 1 }); foreach (var item in pSpecTempList) { if (item.spec_name == spec) { checkStatus = false; ViewBag.spec_id = item.spec_id; } } if (checkStatus)//表示沒有要上傳圖片規格相同的規格一 { errorMsg += "[" + file.FileName + "] " + Resources.VendorProduct.SPEC_NOT_FIND; ViewBag.fileName = errorMsg; return View("~/Views/VendorProduct/upLoad.cshtml"); } } #endregion } string returnName = imgServerPath; bool result = false; string NewFileName = string.Empty; BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string firstFolder = NewFileName.Substring(0, 2) + "/"; string secondFolder = NewFileName.Substring(2, 2) + "/"; string ServerPath = string.Empty; if (nameType == "spec") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(localSpecPath, Mappath); //CreateFolder(localSpec100Path, Mappath); //CreateFolder(localSpec280Path, Mappath); localSpecPath += firstFolder + secondFolder; //localSpec100Path += firstFolder + secondFolder; //localSpec280Path += firstFolder + secondFolder; specPath += firstFolder + secondFolder; returnName += specPath + NewFileName + fileExtention; //localSpec100Path += NewFileName + fileExtention; //localSpec280Path += NewFileName + fileExtention; NewFileName = localSpecPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + specPath); } else if (nameType == "desc") { Mappath[0] = firstFolder; Mappath[1] = secondFolder; CreateFolder(localDescPath, Mappath); //CreateFolder(localDesc400Path, Mappath); localDescPath += firstFolder + secondFolder; //localDesc400Path += firstFolder + secondFolder; descPath += firstFolder + secondFolder; //localDesc400Path += NewFileName + fileExtention; returnName += descPath + NewFileName + fileExtention; NewFileName = localDescPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + descPath); } else { Mappath[0] = firstFolder; Mappath[1] = secondFolder; //Data:2014/06/26 //author:Castle //在前台如果各种尺寸的图档没有的时候,前台会自动产生!!! CreateFolder(localProdPath, Mappath); //CreateFolder(localProd50Path, Mappath); //CreateFolder(localProd150Path, Mappath); //CreateFolder(localProd280Path, Mappath); localProdPath += firstFolder + secondFolder; //localProd50Path += firstFolder + secondFolder; //localProd150Path += firstFolder + secondFolder; //localProd280Path += firstFolder + secondFolder; prodPath += firstFolder + secondFolder; //localProd50Path += NewFileName + fileExtention; //localProd150Path += NewFileName + fileExtention; //localProd280Path += NewFileName + fileExtention; returnName += prodPath + NewFileName + fileExtention; NewFileName = localProdPath + NewFileName + fileExtention; ServerPath = Server.MapPath(imgLocalServerPath + prodPath); } string ErrorMsg = string.Empty; Resource.CoreMessage = new CoreResource("VendorProduct"); try { //上傳圖片 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); //上傳對應大小圖片 //压缩图片至其它规格 } 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)) { ViewBag.fileName = returnName; } else { ViewBag.fileName = "ERROR/" + ErrorMsg; Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = "ERROR/" + ErrorMsg; logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return View("~/Views/VendorProduct/upLoad.cshtml"); }
/// <summary> /// 會員活動新增編輯 /// </summary> /// <returns></returns> public HttpResponseBase SaveMemberEvent() { string json = string.Empty; try { MemberEventQuery query = new MemberEventQuery(); _memberEvent = new MemberEventMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["rowID"])) { query.rowID = int.Parse(Request.Params["rowID"]); } query.me_name = Request.Params["me_name"]; query.me_desc = Request.Params["me_desc"]; query.event_id = Request.Params["event_id"]; if (!string.IsNullOrEmpty(Request.Params["me_startdate"])) { query.me_startdate = DateTime.Parse(Request.Params["me_startdate"]); } if (!string.IsNullOrEmpty(Request.Params["me_enddate"])) { query.me_enddate = DateTime.Parse(Request.Params["me_enddate"]); } if (!string.IsNullOrEmpty(Request.Params["me_birthday"])) { //query.me_birthday = int.Parse(Request.Params["me_birthday"]); if (Request.Params["me_birthday"] == "1") { query.me_birthday = 1; } else { query.me_birthday = 0; } } if (!string.IsNullOrEmpty(Request.Params["me_bonus_onetime"])) { if (Request.Params["me_bonus_onetime"] == "1") { query.me_bonus_onetime = 1; } else { query.me_bonus_onetime = 0; } } if (!string.IsNullOrEmpty(Request.Params["me_banner_link"])) { query.me_banner_link = Request.Params["me_banner_link"]; } if (!string.IsNullOrEmpty(Request.Params["code"])) { query.ml_code = Request.Params["code"].TrimEnd(','); } else { query.ml_code = "0"; } if (!string.IsNullOrEmpty(Request.Params["et_id"])) { query.et_id = int.Parse(Request.Params["et_id"]); } //query.et_name = Request.Params["et_name"]; switch (Request.Params["et_name"]) { case "1": query.et_name = "DD"; query.et_date_parameter = ""; break; case "2": query.et_name = "WW"; if (!string.IsNullOrEmpty(Request.Params["week"])) { query.et_date_parameter = Request.Params["week"].TrimEnd(','); } break; case "3": query.et_name = "MM"; if (!string.IsNullOrEmpty(Request.Params["month"])) { query.et_date_parameter = Request.Params["month"].TrimEnd(','); } break; } #region 處理每天的開始結束時間 query.et_starttime = Request.Params["et_starttime"]; query.et_endtime = Request.Params["et_endtime"]; #endregion query.k_user = (Session["caller"] as Caller).user_id; query.m_user = (Session["caller"] as Caller).user_id; query.k_date = DateTime.Now; query.m_date = query.k_date; string event_json=_memberEvent.IsGetEventID(query.event_id); if (event_json.IndexOf("true") > 0) { #region 判斷數據不能重複 if (_memberEvent.IsRepeat(query))//不重複 { #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 localMemberEventPath = imgLocalPath + MemberEventPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); int totalCount = 0; MemberEventQuery oldQuery = _memberEvent.Query(new MemberEventQuery { rowID = query.rowID }, out totalCount).FirstOrDefault(); 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[] dirPath = new string[2]; //dirPath[0] = NewFileName.Substring(0, 2)+"/"; //dirPath[1] = NewFileName.Substring(2, 2)+"/"; string ServerPath = string.Empty; FTP f_cf = new FTP(); CreateFolder(localMemberEventPath, dirPath); fileName = NewFileName + fileExtention; NewFileName = localMemberEventPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + MemberEventPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (query.rowID != 0) { if (oldQuery.me_big_banner != "") { string oldFileName = oldQuery.me_big_banner; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localMemberEventPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localMemberEventPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localMemberEventPath + 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.me_big_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(); return this.Response; } } else { query.me_big_banner = oldQuery.me_big_banner; } } #endregion if (_memberEvent.MemberEventSave(query) > 0) { //json = "{success:true}"; if (!string.IsNullOrEmpty(Request.Params["rowID"])) { json = "{success:true,msg:'修改成功!'}"; } else { json = "{success:true,msg:'新增成功!'}"; } } else { if (!string.IsNullOrEmpty(Request.Params["rowID"])) { json = "{success:false,msg:'修改失敗!'}"; } else { json = "{success:false,msg:'新增失敗!'}"; } } } else { json = "{success:false,msg:'數據重複!'}"; } #endregion } 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 PaperEdit() { string json = string.Empty; Paper p = new Paper(); _paperMgr = new PaperMgr(mySqlConnectionString); 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 localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址 FileManagement fileLoad = new FileManagement(); try { List<Paper> store = new List<Paper>(); if (!string.IsNullOrEmpty(Request.Params["paper_id"])) { int totalCount = 0; p.IsPage = false; p.paperID = int.Parse(Request.Params["paper_id"]); store = _paperMgr.GetPaperList(p, out totalCount); } string oldImg = string.Empty; foreach (var item in store) { oldImg = item.paperBanner; } p = new Paper(); p.paperName = Request.Params["paper_name"]; p.paperMemo = Request.Params["paper_memo"]; p.bannerUrl = Request.Params["banner_url"]; if (!string.IsNullOrEmpty(Request.Params["paper_start"])) { p.paperStart = DateTime.Parse(DateTime.Parse(Request.Params["paper_start"]).ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["paper_end"])) { p.paperEnd = DateTime.Parse(DateTime.Parse(Request.Params["paper_end"]).ToString("yyyy-MM-dd HH:mm:ss")); } p.event_ID = Request.Params["eventid"]; if (!string.IsNullOrEmpty(Request.Params["isRepeatGift"])) { p.isRepeatGift = int.Parse(Request.Params["isRepeatGift"]); } //if (!string.IsNullOrEmpty(Request.Params["isPromotion"])) //{ // p.isPromotion = int.Parse(Request.Params["isPromotion"]); // if (p.isPromotion == 1) // { // p.promotionUrl = Request.Params["promotion_url"]; // } //} //if (!string.IsNullOrEmpty(Request.Params["isPromotion"])) //{ // p.isPromotion = int.Parse(Request.Params["isPromotion"]); // if (p.isPromotion == 1) // { // p.promotionUrl = Request.Params["promotion_url"]; // } //} //if (!string.IsNullOrEmpty(Request.Params["isGiveBonus"])) //{ // p.isGiveBonus = int.Parse(Request.Params["isGiveBonus"]); // if (p.isGiveBonus == 1) // { // if (!string.IsNullOrEmpty(Request.Params["bonus_num"])) // { // p.bonusNum = int.Parse(Request.Params["bonus_num"]); // } // } //} //if (!string.IsNullOrEmpty(Request.Params["isGiveProduct"])) //{ // p.isGiveProduct = int.Parse(Request.Params["isGiveProduct"]); // if (p.isGiveProduct == 1) // { // if (!string.IsNullOrEmpty(Request.Params["product_id"])) // { // p.productID = int.Parse(Request.Params["product_id"]); // } // } //} if (!string.IsNullOrEmpty(Request.Params["isRepeatWrite"])) { p.isRepeatWrite = int.Parse(Request.Params["isRepeatWrite"]); } if (!string.IsNullOrEmpty(Request.Params["isNewMember"])) { p.isNewMember = int.Parse(Request.Params["isNewMember"]); } p.creator = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList; if (addlist.Length > 0) { p.ipfrom = addlist[0].ToString(); } if (!string.IsNullOrEmpty(Request.Params["paper_id"]) && Request.Params["paper_banner"] == oldImg) { p.paperBanner = oldImg; } else { string ServerPath = string.Empty; ServerPath = Server.MapPath(imgLocalServerPath + PaperPath); 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"); //判斷目錄是否存在,不存在則創建 FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 string ErrorMsg = string.Empty; bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { p.paperBanner = fileName; //上傳新圖片成功后,再刪除舊的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } } else { p.paperBanner = oldImg; } } else { //上傳之前刪除已有的圖片 CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldImg)) { FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片 } p.paperBanner = ""; } } } #region 新增 if (String.IsNullOrEmpty(Request.Params["paper_id"])) { if (_paperMgr.Add(p) > 0) { json = "{success:true,msg:\"" + "新增成功!" + "\"}"; } } #endregion #region 編輯 else { p.paperID = int.Parse(Request.Params["paper_id"]); p.modifier = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); if (_paperMgr.Update(p) > 0) { json = "{success:true,msg:\"" + "修改成功!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public void InsertIntoPromoShareCon(PromoShareCondition query) { List<PromoShareCondition> list = new List<PromoShareCondition>(); PshareConMgr = new PromoShareConditionMgr(mySqlConnectionString); string json = string.Empty; DataTable _dt=new DataTable(); try { for (int i = 0; i < condition.Length; i++) { if (!string.IsNullOrEmpty(Request.Params[condition[i]])) { query = new PromoShareConditionQuery(); query.promo_id = Convert.ToInt32(Request.Params["promo_id"]); query.condition_name = condition[i]; query.condition_value = Request.Params[ condition[i]]; if (query.condition_name == "picture") { #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 + promoPath;//圖片存儲地址 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; HashEncrypt hash = new HashEncrypt(); NewFileName = hash.Md5Encrypt(fileName, "32"); string ServerPath = string.Empty; FTP f_cf = new FTP(); f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localPromoPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); //上傳之前刪除已有的圖片 if (query.promo_id != 0) { _dt = PshareConMgr.Get(condition, query); if (_dt.Rows[0]["picture"].ToString() != "") { string oldFileName = _dt.Rows[0]["picture"].ToString(); 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.condition_value = 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.condition_value = _dt.Rows[0]["picture"].ToString(); } #endregion } list.Add(query); } } PshareConMgr.AddSql(list); } 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}"; } }
// [HttpPost] public HttpResponseBase SaveVipUserGroup() { NameValueCollection param = Request.Params; VipUserGroup userGroup = new VipUserGroup(); string json = string.Empty; bool size = true; Serial serial = new Serial(); _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); _ISerImplMgr = new SerialMgr(mySqlConnectionString); serial = _ISerImplMgr.GetSerialById(72); 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); string NewName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 string NewFileName = string.Empty; FileManagement fileLoad = new FileManagement(); try { #region 新增 if (String.IsNullOrEmpty(param["group_id"])) { if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath)); try { if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; } } else { size = false; } } } catch (Exception) { userGroup.image_name = string.Empty; } if (!string.IsNullOrEmpty(Request.Params["check_iden"])) { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } userGroup.createdate = (uint)CommonFunction.GetPHPTime(DateTime.Now.ToString()); userGroup.group_id = uint.Parse((serial.Serial_Value + 1).ToString()); if (_userGroupMgr.Insert(userGroup) > 0) { serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/ _ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/ if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "新增失敗!" + "\"}"; } } #endregion #region 編輯 else { _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); userGroup.group_id = Convert.ToUInt32(param["group_id"]); VipUserGroup oldUserGroup = _userGroupMgr.GetModelById(userGroup.group_id); if (!string.IsNullOrEmpty(Request.Form["group_name"])) { userGroup.group_name = Request.Form["group_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["tax_id"])) { userGroup.tax_id = Request.Form["tax_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["eng_name"])) { userGroup.eng_name = Request.Form["eng_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["gift_bonus"])) { userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]); } if (!string.IsNullOrEmpty(Request.Form["group_category"])) { userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]); } try { //如果圖片沒有改變 if (Request.Form["image_name"] == oldUserGroup.image_name) { userGroup.image_name = Request.Form["image_name"]; } else { //圖片改變了 if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0) { HttpPostedFileBase file = Request.Files["image_name"]; if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024) { NewName = Path.GetFileName(file.FileName); bool result = false; //獲得文件的後綴名 fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower(); //新的文件名是隨機數字 BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention; NewName = NewFileName; string ServerPath = string.Empty; //判斷目錄是否存在,不存在則創建 string[] mapPath = new string[1]; mapPath[0] = promoPath.Substring(1, promoPath.Length - 2); string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1); CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath); // returnName += promoPath + NewFileName; NewFileName = localPromoPath + NewFileName;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + promoPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 string oldFileName = oldUserGroup.image_name; //FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd); //List<string> tem = ftp.GetFileList(); //上傳 result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result) { userGroup.image_name = NewName; if (System.IO.File.Exists(ServerPath + oldFileName)) { FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); if (System.IO.File.Exists(localPromoPath + oldFileName)) { ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 } DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 } } else { userGroup.image_name = oldUserGroup.image_name; } } else { size = false; userGroup.image_name = oldUserGroup.image_name; } } } } catch (Exception) { userGroup.image_name = oldUserGroup.image_name; } try { userGroup.check_iden = int.Parse(Request.Params["check_iden"]); } catch (Exception) { userGroup.check_iden = 0; } if (_userGroupMgr.Update(userGroup) > 0) { if (size) { json = "{success:true,msg:\"" + "" + "\"}"; } else { json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB!" + "\"}"; } } else { json = "{success:false,msg:\"" + "修改失敗!" + "\"}"; } } #endregion } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; 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); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetOrderDetailList() { List<OrderDetailQuery> stores = new List<OrderDetailQuery>(); string json = string.Empty; try { OrderDetailQuery query = new OrderDetailQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 //付款單號 query.Order_Id = Convert.ToUInt32(Request.Params["OrderId"].ToString()); query.isChildItem = 0; _orderDetailMgr = new OrderDetailMgr(mySqlConnectionString); int totalCount = 0; stores = _orderDetailMgr.GetOrderDetailList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 //獲取供應商後臺登陸的vendorMd5加密 _vendorImp = new VendorMgr(mySqlConnectionString); foreach (OrderDetailQuery item in stores) { string str = _vendorImp.GetLoginId(Convert.ToInt32(item.Vendor_Id)); if (str != "") { HashEncrypt hmd5 = new HashEncrypt(); string mdlogin_id = hmd5.Md5Encrypt(str, "MD5"); item.VendorMd5 = hmd5.Md5Encrypt(mdlogin_id + str, "MD5"); } if (item.item_mode == 2) { item.subtotal = (item.Single_Money * item.parent_num)-uint.Parse(item.Deduct_Happygo_Money.ToString())-item.Deduct_Welfare-item.Deduct_Bonus; } else { item.subtotal = (item.Single_Money * item.Buy_Num) -uint.Parse( item.Deduct_Happygo_Money.ToString()) - item.Deduct_Welfare - item.Deduct_Bonus; } } json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, 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:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase SaveElementDetaiil() { string resultJson = "{success:false}"; ElementDetail model = new ElementDetail(); ElementDetail oldModel = new ElementDetail(); _detailMgr = new ElementDetailMgr(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 localBannerPath = imgLocalPath + ElementPath;//圖片存儲地址 #endregion if (!String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_id = Convert.ToInt32(Request.Params["element_id"].ToString()); oldModel = _detailMgr.GetModel(model); } #region 獲取數據 int isTranInt = 0; //if (Int32.TryParse(Request.Params["element_area_id"].ToString(), out isTranInt)) //{ // model.element_area_id = Convert.ToInt32(Request.Params["element_area_id"].ToString()); //} //else //{ // model.element_area_id = oldModel.element_area_id; //} if (!string.IsNullOrEmpty(Request.Params["element_name"].ToString())) { model.element_name = Request.Params["element_name"].ToString(); } else { model.element_name = oldModel.element_name; } if (!string.IsNullOrEmpty(Request.Params["packet_id"])) { model.packet_id = Convert.ToInt32(Request.Params["packet_id"]); } if (Int32.TryParse(Request.Params["element_type"].ToString(), out isTranInt)) { model.element_type = Convert.ToInt32(Request.Params["element_type"]); } if (model.element_type == 1) { #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 0; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (iFile == 0 && fileName == oldModel.element_content) { fileName = ""; } if(iFile == 1 && string.IsNullOrEmpty(Request.Params["element_img_big"].ToString()) ) { fileName = Request.Params["element_img_big"].ToString(); } if (!String.IsNullOrEmpty(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(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_content; if (iFile == 1) { oldFileName = oldModel.element_img_big; } CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } 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)//上傳成功 { if (iFile == 0) { model.element_content = fileName; } else { model.element_img_big = 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); model.element_content = oldModel.element_content; } if (!string.IsNullOrEmpty(ErrorMsg)) { if (iFile == 0) { ErrorMsg = "元素圖 " + ErrorMsg; } else { ErrorMsg = "元素圖(大) " + ErrorMsg; } string json = string.Empty; json = "{success:true,msg:\""+ ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (iFile == 0) { model.element_content = oldModel.element_content; } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } //model.element_img_big = oldModel.element_img_big; } } } } 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); model.element_content = oldModel.element_content; } #endregion } else if (model.element_type == 2) { if (!string.IsNullOrEmpty(Request.Params["element_content"].ToString())) { model.element_content = Request.Params["element_content"].ToString(); } else { model.element_content = oldModel.element_content; } } else if (model.element_type == 3) { if (int.TryParse(Request.Params["element_product_id"].ToString(), out isTranInt)) { model.element_content = Request.Params["element_product_id"].ToString(); } else { model.element_content = oldModel.element_content; } #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 1; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (!String.IsNullOrEmpty(fileName) && !String.IsNullOrEmpty(Request.Params["element_img_big"].ToString())) {//可獲取文件,名稱不為空則變更圖片 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(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_img_big; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + oldFileName);//刪除ftp:71.159上的舊圖片 } } 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)//上傳成功 { model.element_img_big = 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); model.element_img_big = oldModel.element_img_big; } if (!string.IsNullOrEmpty(ErrorMsg)) { ErrorMsg = "元素圖(大)" + ErrorMsg; string json = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } } } } 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); model.element_img_big = oldModel.element_img_big; } #endregion } if (int.TryParse(Request.Params["category_id_s"].ToString(), out isTranInt)) { model.category_id = uint.Parse(Request.Params["category_id_s"].ToString()); } else { model.category_id = 0; } model.category_name = Server.HtmlDecode(Request.Params["category_name_s"].ToString()); if (!string.IsNullOrEmpty(Request.Params["element_link_url"].ToString())) { model.element_link_url = Request.Params["element_link_url"].ToString(); } //else //{ // model.element_link_url = oldModel.element_link_url; //} if (int.TryParse(Request.Params["element_link_mode"].ToString(), out isTranInt)) { model.element_link_mode = Convert.ToInt32(Request.Params["element_link_mode"]); } else { model.element_link_mode = oldModel.element_link_mode; } if (!string.IsNullOrEmpty(Request.Params["element_sort"].ToString())) { model.element_sort = Convert.ToInt32(Request.Params["element_sort"].ToString()); } //else //{ // model.element_sort = oldModel.element_sort; //} if (!string.IsNullOrEmpty(Request.Params["element_start"].ToString())) { model.element_start = Convert.ToDateTime(Request.Params["element_start"].ToString()); } else { model.element_start = oldModel.element_start; } if (!string.IsNullOrEmpty(Request.Params["element_end"].ToString())) { model.element_end = Convert.ToDateTime(Request.Params["element_end"].ToString()); } else { model.element_end = oldModel.element_end; } model.element_remark = (Request.Params["element_remark"].ToString()); model.element_status = 0;//默認為不啟用 #endregion try { //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_createdate = DateTime.Now; model.element_updatedate = model.element_createdate; model.create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; model.update_userid = model.create_userid; //這裡加上各種參數 if (_detailMgr.Save(model) > 0) { resultJson = "{success:true}";//返回json數據 } } else { //model.element_createdate = oldModel.element_createdate; model.element_updatedate = DateTime.Now; model.update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; // model.create_userid = oldModel.create_userid; //這裡加上各種參數 if (_detailMgr.Update(model) > 0)//如果可以獲取到rowid則進行修改 { resultJson = "{success:true}";//返回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); resultJson = "{success:false}"; } this.Response.Clear(); this.Response.Write(resultJson); this.Response.End(); return this.Response; }
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; }
public HttpResponseBase UploadHtmlEditorPicture() { String fileUrl = ""; try { ImagePathConfig(); HttpPostedFileBase file = Request.Files["imgFile"]; if (file == null) { showError("请选择文件。"); } string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.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(localHealthPath.Substring(0, localHealthPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localHealthPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + healthPath); string ErrorMsg = string.Empty; try { //上傳 bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd); if (result)//上傳成功 { fileUrl = imgServerPath + healthPath + fileName; } } catch (Exception) { showError("圖片上傳失敗。"); } } catch (Exception) { showError("圖片上傳失敗。"); } Hashtable hashResult = new Hashtable(); hashResult["error"] = 0; hashResult["url"] = fileUrl; this.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); this.Response.Write(JsonMapper.ToJson(hashResult)); this.Response.End(); return this.Response; }