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;
}
/// <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 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 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 HttpResponseBase SaveInspectionRe()
{
string json = "{success:'false',msg:'5'}";
try
{
_inspectionReport = new InspectionReportMgr(mySqlConnectionString);
InspectionReportQuery query = new InspectionReportQuery();
InspectionReportQuery oldQuery = new InspectionReportQuery();
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
query.product_id = Convert.ToUInt32(Request.Params["product_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["brand_id"]))
{
query.brand_id = Convert.ToUInt32(Request.Params["brand_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["certificate_type1"]))
{
query.certificate_type1 = Request.Params["certificate_type1"];
}
if (!string.IsNullOrEmpty(Request.Params["certificate_type2"]))
{
query.certificate_type2 = Request.Params["certificate_type2"];
}
if (!string.IsNullOrEmpty(Request.Params["certificate_expdate"]))
{
query.certificate_expdate = Convert.ToDateTime(Request.Params["certificate_expdate"]);
}
if (!string.IsNullOrEmpty(Request.Params["certificate_desc"]))
{
query.certificate_desc = Request.Params["certificate_desc"];
}
if (!string.IsNullOrEmpty(Request.Params["certificate_filename"]))
{
query.certificate_filename = Request.Params["certificate_filename"];
}
if (!string.IsNullOrEmpty(Request.Params["rowID"]))
{
query.rowID = Convert.ToInt32(Request.Params["rowID"]);
oldQuery = _inspectionReport.oldQuery(query);
}
if (!string.IsNullOrEmpty(Request.Params["sort"]))
{
query.sort = Convert.ToInt32(Request.Params["sort"]);
}
if (!string.IsNullOrEmpty(Request.Params["old_sort"]))
{
query.old_sort = Convert.ToInt32(Request.Params["old_sort"]);
}
query.k_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.m_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
#region 排序是否重複
if (_inspectionReport.IsSortExist(query) || query.old_sort == query.sort)//sort不重複
{
if (!_inspectionReport.IsExist(query))
{
HttpPostedFileBase picFile = Request.Files["certificate_filename"];
//檢查上傳的圖片名稱和拼出來的圖片名稱是否一樣，不一樣則不能上傳
//拼成圖片名稱
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_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 localInspectionReportPath = imgLocalPath + InspectionReportPath;//圖片存儲地址
FileManagement fileLoad = new FileManagement();
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
//
//文件夾名稱
string[] dirPath = new string[2];
dirPath[0] = query.brand_id.ToString() + "/".ToString();
dirPath[1] = query.product_id.ToString() + "/".ToString();
//
fileName = fileLoad.NewFileName(file.FileName);
if (fileName != "")
{
string[] mapPath = new string[2];
mapPath[0] = _inspectionReport.GetType1Folder(query);
mapPath[1] = _inspectionReport.GetType2Folder(query);
string NewFileName = string.Empty;
NewFileName = query.brand_id + "-" + query.product_id + "-" + mapPath[0].Replace('/', ' ').Replace(" ", "") + "-" + mapPath[1].Replace('/', ' ').Replace(" ", "");
#region 判斷圖片名稱是否正確，正確則保存
if (picFile.FileName.Substring(0, picFile.FileName.LastIndexOf(".")) == NewFileName)
{
fileName = fileName.Substring(0, fileName.LastIndexOf("."));
fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString();
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
FTP f_cf = new FTP();
CreateFolder(localInspectionReportPath, dirPath);
//壓縮圖片 源文件
string sourcePath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1] + fileName + fileExtention);
if (!Directory.Exists(Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1])))
{
Directory.CreateDirectory(Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]));
}
file.SaveAs(sourcePath);
fileName = NewFileName + fileExtention;
NewFileName = localInspectionReportPath + dirPath[0] + dirPath[1] + NewFileName + fileExtention;
ServerPath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]);
string ErrorMsg = string.Empty;
if (query.rowID != 0)
{
string oldFileName = oldQuery.certificate_filename;
CommonFunction.DeletePicFile(ServerPath + oldFileName);
FTP ftp = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1], ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName);
}
}
try
{
Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件
bool result = fileLoad.ZIPUpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd, sourcePath);
if (result)//上傳成功
{
query.certificate_filename = fileName;
//刪除本地圖片
CommonFunction.DeletePicFile(sourcePath);
json = _inspectionReport.SaveInspectionRe(query);
}
}
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);
query.certificate_filename = oldQuery.certificate_filename;
}
if (!string.IsNullOrEmpty(ErrorMsg))
{
string jsonPic = string.Empty;
jsonPic = "{success:true,msg:\"" + ErrorMsg + "\"}";
this.Response.Clear();
this.Response.Write(jsonPic);
this.Response.End();
return this.Response;
}
}
else
{
json = "{success:'false',msg:'3'}";//圖片名稱不對
}
#endregion
}
else
{
query.certificate_filename = oldQuery.certificate_filename;
json = _inspectionReport.SaveInspectionRe(query);
}
}
}
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);
query.certificate_filename = oldQuery.certificate_filename;
}
#endregion
// picFile.SaveAs();
}
else
{
json = "{success:'false',msg:'2'}";//重複數據
}
}
else
{
json = "{success:'false',msg:'4'}";//重複數據
}
#endregion
}
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 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 UpdateTrial()
{
string jsonStr = String.Empty;
int isTranInt = 0;
try
{
string trial_id = Request.Params["trial_id"].ToString();
string isEdit = Request.Params["isEdit"].ToString();
_promotionsAmountTrialMgr = new PromotionsAmountTrialMgr(mySqlConnectionString);
_ucMgr = new UserConditionMgr(mySqlConnectionString);
PromotionsAmountTrialQuery model = new PromotionsAmountTrialQuery();
PromotionsAmountTrialQuery OldModel = new PromotionsAmountTrialQuery();
#region 第一面板數據
if (!string.IsNullOrEmpty(Request.Params["trial_id"]))
{
model.id = Convert.ToInt32(Request.Params["trial_id"]);
OldModel = _promotionsAmountTrialMgr.Select(model.id);
}
if (!string.IsNullOrEmpty(Request.Params["name"]))
{//活動名稱
model.name = Request.Params["name"].ToString();
}
int event_type = 0;
if (!string.IsNullOrEmpty(Request.Params["event_type"]))
{
if (int.TryParse(Request.Params["event_type"], out event_type))
{
if (event_type == 1)
{
model.event_type = "T1";
}
else if (event_type == 2)
{
model.event_type = "T2";
}
}
}
model.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString());
int paper_id = 0;
if (int.TryParse(Request.Params["paper_id"].ToString(), out paper_id))
{
model.paper_id = paper_id;
}
if (!string.IsNullOrEmpty(Request.Params["event_url"].ToString()))
{
model.url = Request.Params["event_url"];
}
if (!string.IsNullOrEmpty(Request.Params["start_date"]))
{
model.start_date = Convert.ToDateTime(Request.Params["start_date"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["end_date"]))
{
model.end_date = Convert.ToDateTime(Request.Params["end_date"].ToString());
}
//活動描述
if (!string.IsNullOrEmpty(Request.Params["event_desc"]))
{
model.event_desc = Request.Params["event_desc"].ToString();
}
#endregion
#region 第二面板數據
if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString()))
{
if (int.TryParse(Request.Params["group_id"].ToString(), out isTranInt))
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
else
{
model.group_id = OldModel.group_id;
}
//當編輯活動時將會員條件改為會員群組則刪除原有的會員條件
if (OldModel.condition_id != 0)
{
UserCondition uc = new UserCondition();
uc.condition_id = OldModel.condition_id;
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
model.condition_id = 0;
}
else
{
jsonStr = "{success:false,msg:'user_condition刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
//當活動設置完會員條件又改為會員群組時刪除設置的會員條件
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
model.condition_id = 0;
}
else
{
jsonStr = "{success:false,msg:'user_condition刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
}
else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
model.group_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["count_by"]))
{
model.count_by = Convert.ToInt32(Request.Params["count_by"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["numLimit"]))
{
model.num_limit = Convert.ToInt32(Request.Params["numLimit"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["gift_mundane"]))
{
model.gift_mundane = Convert.ToInt32(Request.Params["gift_mundane"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["IsRepeat"]))
{
model.repeat = Convert.ToInt32(Request.Params["IsRepeat"].ToString()) == 1 ? true : false;
}
if (!string.IsNullOrEmpty(Request.Params["freight_type"].ToString()))
{
if (int.TryParse(Request.Params["freight_type"].ToString(), out isTranInt))
{
model.freight_type = Convert.ToInt32(Request.Params["freight_type"].ToString());
}
else
{
model.freight_type = OldModel.freight_type;
}
}
if (!string.IsNullOrEmpty(Request.Params["device_name"]))
{
model.device = Convert.ToInt32(Request.Params["device_name"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName
{
Regex reg = new Regex("^([0-9]+,)*([0-9]+)$");
if (reg.IsMatch(Request.Params["site"].ToString()))
{
model.site = Request.Params["site"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08
}
else
{
model.site = OldModel.site;
}
}
#endregion
#region 第三面板數據
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
model.product_id = Convert.ToInt32(Request.Params["product_id"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["product_name"]))
{
model.product_name = Request.Params["product_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["sale_product_id"]))
{
model.sale_productid = Convert.ToInt32(Request.Params["sale_product_id"].ToString());
}
model.category_id = Convert.ToUInt32(Request.Params["category_id"].ToString());
model.brand_id = Convert.ToInt32(Request.Params["brand_id"].ToString());
model.market_price = Convert.ToInt32(Request.Params["market_price"].ToString());
model.show_number = Convert.ToInt32(Request.Params["show_number"].ToString());
model.apply_limit = Convert.ToInt32(Request.Params["apply_limit"].ToString());
model.apply_sum = Convert.ToInt32(Request.Params["apply_sum"].ToString());
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
bool result = false;
string NewFileName = string.Empty;//編譯后的文件名
string oldFile = "";
string ServerPath = string.Empty;
string ErrorMsg = string.Empty;
//判斷目錄是否存在，不存在則創建
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
FileManagement fileLoad = new FileManagement();
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
if (iFile == 0 && !string.IsNullOrEmpty(Request.Params["prod_file"]))
{
model.product_img = Request.Params["prod_file"].ToString().Substring(Request.Params["prod_file"].ToString().LastIndexOf("/") + 1);
}
else
{
HttpPostedFileBase file = Request.Files[iFile];
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
fileName = Path.GetFileName(file.FileName);
if (fileName != "")
{
switch (iFile)
{
case 1:
oldFile = OldModel.event_img_small;
break;
case 2:
oldFile = OldModel.event_img;
break;
case 0:
oldFile = OldModel.product_img;
break;
}
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFile))
{
FTP ftps = new FTP(localPromoPath + oldFile, ftpuser, ftppwd);
ftps.DeleteFile(localPromoPath + oldFile);//刪除ftp:71.159上的舊圖片
DeletePicFile(ServerPath + oldFile);//刪除本地圖片
}
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = model.event_id + newRand + fileExtention;
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
try
{
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
switch (iFile)
{
case 1:
model.event_img_small = fileName;
break;
case 2:
model.event_img = fileName;
break;
case 0:
model.product_img = fileName;
break;
}
}
}
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);
}
}
else
{
switch (iFile)
{
case 1:
model.event_img_small = OldModel.event_img_small;
break;
case 2:
model.event_img = OldModel.event_img;
break;
case 0:
model.product_img = OldModel.product_img;
break;
}
}
}
}
}
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);
}
#endregion
#endregion
#region 更新表結構
if (string.IsNullOrEmpty(isEdit))//新增數據
{
model.active = 0;//默認不啟用
model.status = 1;//第二步保存為有效數據
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.muser = model.kuser;
model.modified = model.created;
if (_promotionsAmountTrialMgr.Update(model) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
else//編輯數據
{
model.active = OldModel.active;
model.status = OldModel.status;
model.kuser = OldModel.kuser;
model.created = OldModel.created;
model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.modified = DateTime.Now;
if (_promotionsAmountTrialMgr.Update(model) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
#endregion
}
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 PromoPairEdit()
{
string jsonStr = String.Empty;
_promopairMgr = new PromoPairMgr(mySqlConnectionString);
PromoPair model = new PromoPair();
PromoPair oldermodel = new PromoPair();
PromoPairQuery PPQuery = new PromoPairQuery();
ProductCategory olderpcmodel = new ProductCategory();
PromoPairQuery oldPPQuery = new PromoPairQuery();
if (!String.IsNullOrEmpty(Request.Params["rowid"]))
{
try
{
model.id = Convert.ToInt32(Request.Params["rowid"].ToString());
model.category_id = Convert.ToInt32(Request.Params["categoryid"].ToString());
oldermodel = _promopairMgr.GetModelById(model.id);
olderpcmodel = _produCateMgr.GetModelById(Convert.ToUInt32(model.category_id));
model.event_name = Request.Params["event_name"].ToString();
model.event_desc = Request.Params["event_desc"].ToString();
model.event_type = oldermodel.event_type;
model.vendor_coverage = int.Parse(Request.Params["vendor_coverage"]);
#region 會員群組 會員條件
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = oldermodel.group_id;
}
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
}
else
{
jsonStr = "{success:false,msg:'user_condition刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
model.condition_id = 0;
}
else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = oldermodel.condition_id;
}
model.group_id = 0;
}
#endregion
model.deliver_type = Convert.ToInt32(Request.Params["deliver_id"].ToString());
model.device = Request.Params["device_id"].ToString();
//model.website = Request.Params["side"].ToString();
if (!string.IsNullOrEmpty(Request.Params["side"].ToString()))//修改時傳的值為siteName
{
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(Request.Params["side"].ToString()))
{
model.website = Request.Params["side"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08
}
else
{
model.website = oldermodel.website;
}
}
#region 紅+綠
if (Request.Params["price"].ToString() != "")
{
try//price
{
model.price = Convert.ToInt32(Request.Params["price"].ToString());
}
catch (Exception)
{
model.price = oldermodel.group_id;
}
model.discount = 0;
}
else if (Request.Params["discount"].ToString() != "")
{
try//discount
{
model.discount = Convert.ToInt32(Request.Params["discount"].ToString());
}
catch (Exception)
{
model.discount = oldermodel.condition_id;
}
model.price = 0;
}
#endregion
model.starts = Convert.ToDateTime(Request.Params["starts"].ToString());
model.end = Convert.ToDateTime(Request.Params["end"].ToString());
model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.modified = DateTime.Now;
PPQuery.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString());
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
FileManagement fileLoad = new FileManagement();
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
HttpPostedFileBase file = Request.Files[iFile];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
fileName = Path.GetFileName(file.FileName);
// string returnName = imgServerPath;
bool result = false;
string NewFileName = string.Empty;
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = PPQuery.event_id + newRand + fileExtention;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
//string[] mapPath = new string[1];
//mapPath[0] = promoPath.Substring(1, promoPath.Length - 2);
//string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1);
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
// returnName += promoPath + NewFileName;
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
string oldFileName = olderpcmodel.banner_image;
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
}
try
{
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
PPQuery.banner_image = fileName;
}
}
catch (Exception)
{
PPQuery.banner_image = olderpcmodel.banner_image;
}
}
}
catch (Exception)
{
PPQuery.banner_image = olderpcmodel.banner_image;
}
#endregion
#region 注釋上傳圖片
////string nowtime = DateTime.Now.ToString("hhmm");
//Random rand = new Random();
//int nowtime = rand.Next(1000, 9999);
//try
//{
// string saveFoler = Server.MapPath("~/aimg.gigade100.com/active/");
// string savePath, fileName, oldsavePath;
// for (int iFile = 0; iFile < Request.Files.Count; iFile++)
// {
// HttpPostedFileBase postedFile = Request.Files[iFile];
// fileName = Path.GetFileName(postedFile.FileName);
// if (fileName != "")
// {
// string fileType = fileName.Substring(fileName.LastIndexOf("."));
// string newName = GetEventId(oldermodel.event_type, model.id.ToString()) + nowtime + fileType;
// oldsavePath = olderpcmodel.banner_image;
// oldsavePath = saveFoler + oldsavePath;
// savePath = saveFoler + newName;
// if (System.IO.File.Exists(oldsavePath))
// {//检查是否在服务器上已经存在用户上传的同名文件
// System.IO.File.Delete(oldsavePath);
// }
// if (fileType.ToLower() == ".jpg" || fileType.ToLower() == ".png" || fileType.ToLower() == ".gif" || fileType.ToLower() == ".jpeg")
// {
// if (postedFile.ContentLength <= 300 * 1024)
// {
// postedFile.SaveAs(savePath);
// PPQuery.banner_image = newName;
// }
// else
// {
// jsonStr = "{success:false,msg:1}";
// this.Response.Clear();
// this.Response.Write(jsonStr.ToString());
// this.Response.End();
// return this.Response;
// }
// }
// else
// {
// jsonStr = "{success:false,msg:2}";
// this.Response.Clear();
// this.Response.Write(jsonStr.ToString());
// this.Response.End();
// return this.Response;
// }
// }
// else
// {
// PPQuery.banner_image = olderpcmodel.banner_image;
// }
// }
//}
//catch (Exception)
//{
// PPQuery.banner_image = olderpcmodel.banner_image;
//}
#endregion
try//存連接地址 id是否也添加時間
{
PPQuery.category_link_url = phpwebhost + "/pair/red_green_match.php?event_id=" + PPQuery.event_id;
}
catch (Exception)
{
PPQuery.category_link_url = oldPPQuery.category_link_url;
}
//foreach (string rid in Request.Params["rowid"].ToString().Split('|'))
//{
// if (!string.IsNullOrEmpty(rid))
// {
// query.id = Convert.ToInt32(rid);
// _promopairMgr.Update(query);
// }
//}
if (_promopairMgr.CategoryID(model).ToString() == "true")
{
_promopairMgr.Update(model, PPQuery);
jsonStr = "{success:true}";
}
else
{
jsonStr = "{success:false,msg:3}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}
public HttpResponseBase 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;
}
/// <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 SecondSaveFare()
{
string jsonStr = String.Empty;
int stringTranInt = 0;//使用tryParse使string轉換為int時保存轉換的值
try
{
string rowID = Request.Params["rowid"].ToString() ?? "0";
string isEdit = Request.Params["isEdit"].ToString() ?? "";
_promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString);
PromotionsAmountFareQuery model = new PromotionsAmountFareQuery();
PromotionsAmountFareQuery OldModel = _promoAmountFareMgr.Select(Convert.ToInt32(rowID));
#region 獲取數據
if (!string.IsNullOrEmpty(Request.Params["rowid"]))
{
model.id = Convert.ToInt32(Request.Params["rowid"]);
}
else
{
model.id = 0;
}
model.category_id = OldModel.category_id;
if (!string.IsNullOrEmpty(Request.Params["name"]))
{
model.name = Request.Params["name"].ToString();
}
else
{
model.name = OldModel.name;
}
if (!string.IsNullOrEmpty(Request.Params["desc"]))
{
model.event_desc = Request.Params["desc"].ToString();
}
else
{
model.event_desc = OldModel.event_desc;
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"]))
{
model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
else
{
model.vendor_coverage = 0;
}
if (!string.IsNullOrEmpty(Request.Params["sclass_id"]))
{
if (int.TryParse(Request.Params["sclass_id"].ToString(), out stringTranInt))
{
model.class_id = Convert.ToInt32(Request.Params["sclass_id"].ToString() == "" ? "0" : Request.Params["sclass_id"].ToString());
}
else
{
model.class_id = OldModel.class_id;
}
}
else
{
model.class_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["sbrand_id"]))
{
if (int.TryParse(Request.Params["sbrand_id"].ToString(), out stringTranInt))
{
model.brand_id = Convert.ToInt32(Request.Params["sbrand_id"].ToString() == "" ? "0" : Request.Params["sbrand_id"].ToString());
}
else
{
model.brand_id = OldModel.brand_id;
}
}
else
{
model.brand_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["allClass"]))
{
model.allClass = Convert.ToInt32(Request.Params["allClass"].ToString() == "1" ? "1" : "0");
if (1 == model.allClass)
{
model.product_id = 999999;
}
}
else
{
model.allClass = 0;
}
if (!string.IsNullOrEmpty(Request.Params["event_type"]))
{
//獲取event_type和category_father_id
_parasrcMgr = new ParameterMgr(mySqlConnectionString);
List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", parameterName = Request.Params["event_type"].ToString(), Used = 1 });
if (fatherIdResult.Count == 1)
{
model.event_type = fatherIdResult[0].ParameterCode;
model.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty);
}
}
if (!string.IsNullOrEmpty(Request.Params["amount"]))
{
model.amount = Convert.ToInt32(Request.Params["amount"].ToString());
}
else
{
model.amount = OldModel.amount;
}
if (!string.IsNullOrEmpty(Request.Params["quantity"]))
{
model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString());
}
else
{
model.quantity = OldModel.quantity;
}
if (!string.IsNullOrEmpty(Request.Params["fare_percent"]))
{
model.fare_percent = Convert.ToInt32(Request.Params["fare_percent"].ToString());
}
else
{
model.fare_percent = OldModel.fare_percent;
}
if (!string.IsNullOrEmpty(Request.Params["off_times"]))
{
model.off_times = Convert.ToInt32(Request.Params["off_times"].ToString());
}
else
{
model.off_times = OldModel.off_times;
}
if (model.id != 0)
{
model.event_id = BLL.gigade.Common.CommonFunction.GetEventId(model.event_type, model.id.ToString());
}
if (Request.Params["group_id"].ToString() != "")
{//會員群組不為空時，要清空已存在的會員條件
if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString()) && int.TryParse(Request.Params["group_id"].ToString(), out stringTranInt))//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
else
{
model.group_id = OldModel.group_id;
}
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
_ucMgr = new UserConditionMgr(mySqlConnectionString);
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
model.condition_id = 0;
}
else
{
jsonStr = "{success:false,msg:3}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
}
else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = OldModel.condition_id;
}
model.group_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["type"]) && int.TryParse(Request.Params["type"].ToString(), out stringTranInt))
{
model.type = Convert.ToInt32(Request.Params["type"].ToString());
}
else
{
model.type = OldModel.type;
}
if (!string.IsNullOrEmpty(Request.Params["deliver"].ToString()) && int.TryParse(Request.Params["deliver"].ToString(), out stringTranInt))
{
model.delivery_store = Convert.ToInt32(Request.Params["deliver"].ToString());
}
else
{
model.delivery_store = OldModel.delivery_store;
}
if (!string.IsNullOrEmpty(Request.Params["devicename"].ToString()))
{
model.device = Convert.ToInt32(Request.Params["devicename"].ToString());
}
else
{
model.device = OldModel.device;
}
if (!string.IsNullOrEmpty(Request.Params["payment"].ToString()))
{
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(Request.Params["payment"].ToString()))
{
model.payment_code = Request.Params["payment"].ToString();
}
else
{
model.payment_code = OldModel.payment_code;
}
}
if (!string.IsNullOrEmpty(Request.Params["start_time"].ToString()))
{
model.start = Convert.ToDateTime(Request.Params["start_time"].ToString());
}
else
{
model.start = OldModel.start_time;
}
if (!string.IsNullOrEmpty(Request.Params["end_time"].ToString()))
{
model.end = Convert.ToDateTime(Request.Params["end_time"].ToString());
}
else
{
model.end = OldModel.end_time;
}
if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))
{
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(Request.Params["site"].ToString()))
{
model.site = Request.Params["site"].ToString();
}
else
{
model.site = OldModel.site;
}
}
model.status = 1;
if (!string.IsNullOrEmpty(Request.Params["url_by"].ToString()))
{
model.url_by = Convert.ToInt32(Request.Params["url_by"].ToString());
}
else
{
model.url_by = OldModel.url_by;
}
#endregion
////講圖片和鏈接保存至product_category中
if (model.url_by == 1)
{
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
Random rand = new Random();
int newRand = rand.Next(1000, 9999);//獲取隨機數重命名圖片
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
fileName = Path.GetFileName(file.FileName);
if (fileName != "")
{
// string returnName = imgServerPath;
bool result = false;
string NewFileName = string.Empty;
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = model.event_id + newRand + fileExtention;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
string oldFileName = OldModel.banner_image;
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
}
FileManagement fileLoad = new FileManagement();
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
model.banner_image = fileName;
}
}
else
{
model.banner_image = OldModel.banner_image;
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->圖片上傳失敗！", ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:0}";
model.banner_image = OldModel.banner_image;
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["banner_url"].ToString()))
{
model.category_link_url = Request.Params["banner_url"].ToString();
}
else
{
model.category_link_url = OldModel.category_link_url;
}
}
else//url_by=0
{
//刪除上傳的圖片
string oldFileName = OldModel.banner_image;
FTP ftp = new FTP(imgLocalPath + promoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(imgLocalPath + promoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(imgLocalPath + promoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(Server.MapPath(imgLocalServerPath + promoPath) + oldFileName);//刪除本地圖片
}
model.category_link_url = "";
model.banner_image = "";
}
_promoAmountFareMgr = new PromotionsAmountFareMgr(mySqlConnectionString);
if (string.IsNullOrEmpty(isEdit))
{
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.muser = model.kuser;
model.modified = model.created;
if (_promoAmountFareMgr.ReSave(model) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
else
{
model.kuser = OldModel.kuser;
model.created = OldModel.created;
model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.modified = DateTime.Now;
if (_promoAmountFareMgr.Update(model, OldModel.event_id) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
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 HttpResponseBase PromoAdditionalPriceEdit()
{
string jsonStr = String.Empty;
_promoadditionproceMgr = new PromoAdditionalPriceMgr(mySqlConnectionString);
PromoAdditionalPrice model = new PromoAdditionalPrice();
PromoAdditionalPrice oldermodel = new PromoAdditionalPrice();
PromoAdditionalPriceQuery PPQuery = new PromoAdditionalPriceQuery();
ProductCategory olderpcmodel = new ProductCategory();
PromoAdditionalPriceQuery oldPPQuery = new PromoAdditionalPriceQuery();
if (!String.IsNullOrEmpty(Request.Params["rowid"]))
{
try
{
model.id = Convert.ToInt32(Request.Params["rowid"].ToString());
oldermodel = _promoadditionproceMgr.GetModel(model.id);
model.category_id = oldermodel.category_id;
olderpcmodel = _produCateMgr.GetModelById(Convert.ToUInt32(model.category_id));
model.event_name = Request.Params["event_name"].ToString();
model.event_desc = Request.Params["event_desc"].ToString();
model.event_type = oldermodel.event_type;
if (!string.IsNullOrEmpty(Request.Params["url_by"]))
{
model.url_by =Convert.ToInt32(Request.Params["url_by"]);
}
#region 會員群組 會員條件
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = oldermodel.group_id;
}
model.condition_id = 0;
}
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = oldermodel.condition_id;
}
model.group_id = 0;
}
#endregion
model.deliver_type = Convert.ToInt32(Request.Params["deliver_id"].ToString());
model.device = Request.Params["device_id"].ToString();
model.website = Request.Params["side"].ToString();
PPQuery.event_id = GetEventId(model.event_type, model.id.ToString());
try
{
model.fixed_price = Convert.ToInt32(Request.Params["fixed_price"].ToString());
}
catch (Exception)
{
model.fixed_price = oldermodel.fixed_price;
}
try
{
model.buy_limit = Convert.ToInt32(Request.Params["buy_limit"].ToString());
}
catch (Exception)
{
model.fixed_price = oldermodel.fixed_price;
}
model.starts = Convert.ToDateTime(Request.Params["starts"].ToString());
//string s = Request.Params["starts"];
//model.starts = DateTime.Parse(Request.Params["starts"]);
model.end = Convert.ToDateTime(Request.Params["end"].ToString());
model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.modified = DateTime.Now;
//20140925 add 折扣
if (model.event_type == "A3")
{
model.discount = Int32.Parse(Request.Params["discount"].ToString());
}
else
{
model.discount = 0;
}
PPQuery.category_ipfrom = Request.UserHostAddress;
PPQuery.event_id = GetEventId(model.event_type, model.id.ToString());
try//存連接地址
{
PPQuery.category_link_url = Request.Params["banner_url"].ToString();
if (PPQuery.category_link_url == "" || PPQuery.category_link_url == null)
{
model.url_by = 0;
//刪除上傳的圖片
string oldFileName = olderpcmodel.banner_image;
FTP ftp = new FTP(imgLocalPath + promoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(imgLocalPath + promoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(imgLocalPath + promoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(Server.MapPath(imgLocalServerPath + promoPath) + oldFileName);//刪除本地圖片
}
PPQuery.category_link_url = "";
PPQuery.banner_image = "";
}
else
{
model.url_by = 1;
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
FileManagement fileLoad = new FileManagement();
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
HttpPostedFileBase file = Request.Files[iFile];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
fileName = Path.GetFileName(file.FileName);
// string returnName = imgServerPath;
bool result = false;
string NewFileName = string.Empty;
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = PPQuery.event_id + newRand + fileExtention;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
//string[] mapPath = new string[1];
//mapPath[0] = promoPath.Substring(1, promoPath.Length - 2);
//string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1);
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
// returnName += promoPath + NewFileName;
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
string oldFileName = olderpcmodel.banner_image;
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
}
try
{
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
PPQuery.banner_image = fileName;
}
}
catch (Exception)
{
PPQuery.banner_image = olderpcmodel.banner_image;
}
}
}
catch (Exception)
{
PPQuery.banner_image = olderpcmodel.banner_image;
}
#endregion
}
}
catch (Exception)
{
PPQuery.category_link_url = oldPPQuery.category_link_url;
}
model.active = false;
if (_promoadditionproceMgr.CategoryID(model).ToString() == "true")
{
_promoadditionproceMgr.Update(model, PPQuery);
jsonStr = "{success:true}";
}
else
{
jsonStr = "{success:false,msg:3}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}
public HttpResponseBase SecondSaveGift()
{
string jsonStr = String.Empty;
try
{
string rowID = Request.Params["rowid"].ToString();
string isEdit = Request.Params["isEdit"].ToString();
_promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString);
PromotionsAmountGiftQuery model = new PromotionsAmountGiftQuery();
PromotionsAmountGiftQuery OldModel = _promoAmountGiftMgr.Select(Convert.ToInt32(rowID));
OldModel.event_id = CommonFunction.GetEventId(OldModel.event_type, OldModel.id.ToString());
#region 獲取數據
if (!string.IsNullOrEmpty(Request.Params["rowid"]))
{
model.id = Convert.ToInt32(Request.Params["rowid"]);
}
else
{
model.id = OldModel.id;
}
model.category_id = OldModel.category_id;
if (!string.IsNullOrEmpty(Request.Params["event_name"]))
{
model.name = Request.Params["event_name"].ToString();
}
else
{
model.name = OldModel.name;
}
if (!string.IsNullOrEmpty(Request.Params["event_desc"]))
{
model.event_desc = Request.Params["event_desc"].ToString();
}
else
{
model.event_desc = OldModel.event_desc;
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"]))
{
model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
else
{
model.vendor_coverage = 0;
}
if (!string.IsNullOrEmpty(Request.Params["event_type"]))
{
model.event_type = Request.Params["event_type"].ToString();
}
else
{
model.event_type = OldModel.event_type;
}
if (Request.Params["amount"].ToString() != "" && Request.Params["amount"].ToString() != "0")
{
if (!string.IsNullOrEmpty(Request.Params["amount"]))
{
model.amount = Convert.ToInt32(Request.Params["amount"].ToString());
model.quantity = 0;
}
else
{
model.amount = OldModel.amount;
model.quantity = 0;
}
}
else
{
if (!string.IsNullOrEmpty(Request.Params["quantity"]))
{
model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString());
model.amount = 0;
}
else
{
model.quantity = OldModel.quantity;
model.amount = 0;
}
}
if (model.id != 0)
{
model.event_id = CommonFunction.GetEventId(model.event_type, model.id.ToString());
}
else
{
model.event_id = CommonFunction.GetEventId(OldModel.event_type, OldModel.id.ToString());
}
#endregion
#region 講圖片和鏈接保存至product_category中
////講圖片和鏈接保存至product_category中
if (!string.IsNullOrEmpty(Request.Params["url_by"]))
{
model.url_by = Convert.ToInt32(Request.Params["url_by"].ToString());
if (model.url_by == 1)//是專區
{
#region 上傳圖片
try
{
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
FileManagement fileLoad = new FileManagement();
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
HttpPostedFileBase file = Request.Files[iFile];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
fileName = Path.GetFileName(file.FileName);
// string returnName = imgServerPath;
bool result = false;
string NewFileName = string.Empty;
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = model.event_id + newRand + fileExtention;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
//string[] mapPath = new string[1];
//mapPath[0] = promoPath.Substring(1, promoPath.Length - 2);
//string s = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1);
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
// returnName += promoPath + NewFileName;
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
string oldFileName = OldModel.banner_image;
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片
DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
}
try
{
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
model.banner_image = fileName;
}
}
catch (Exception)
{
model.banner_image = OldModel.banner_image;
}
}
}
catch (Exception)
{
model.banner_image = OldModel.banner_image;
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["banner_url"]))
{
model.category_link_url = Request.Params["banner_url"].ToString();
}
else
{
model.category_link_url = OldModel.category_link_url;
}
if (!string.IsNullOrEmpty(Request.Params["sbrand_id"].ToString()))
{
int brandTranId = 0;
if (int.TryParse(Request.Params["sbrand_id"].ToString(), out brandTranId))
{
model.brand_id = Convert.ToInt32(Request.Params["sbrand_id"].ToString());
}
else
{
model.brand_id = OldModel.brand_id;
}
}
else
{
model.brand_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["sclass_id"].ToString()))
{
int classTranId = 0;
if (int.TryParse(Request.Params["sclass_id"].ToString(), out classTranId))
{
model.class_id = Convert.ToInt32(Request.Params["sclass_id"].ToString());
}
else
{
model.class_id = OldModel.class_id;
}
}
else
{
model.class_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["allClass"]))
{
if (Request.Params["allClass"] == "1")
{
model.quanguan = 1;
model.class_id = 0;
model.brand_id = 0;
model.product_id = 999999;
}
else
{
model.quanguan = 0;
}
}
}
else//非專區
{
model.category_link_url = "";
model.banner_image = "";
if (!string.IsNullOrEmpty(Request.Params["nobrand_id"].ToString()))
{
int brandTranId = 0;
if (int.TryParse(Request.Params["nobrand_id"].ToString(), out brandTranId))
{
model.brand_id = Convert.ToInt32(Request.Params["nobrand_id"].ToString());
}
else
{
model.brand_id = OldModel.brand_id;
}
}
else
{
model.brand_id = OldModel.brand_id;
}
if (!string.IsNullOrEmpty(Request.Params["noclass_id"].ToString()))
{
int classTranId = 0;
if (int.TryParse(Request.Params["noclass_id"].ToString(), out classTranId))
{
model.class_id = Convert.ToInt32(Request.Params["noclass_id"].ToString());
}
else
{
model.class_id = OldModel.class_id;
}
}
else
{
model.class_id = OldModel.class_id;
}
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
model.product_id = Convert.ToInt32(Request.Params["product_id"].ToString());
}
else
{
model.product_id = OldModel.product_id;
}
if (!string.IsNullOrEmpty(Request.Params["noallClass"]))
{
if (Request.Params["noallClass"] == "1" || Request.Params["noallClass"] == "true")
{
model.quanguan = 1;
model.class_id = 0;
model.brand_id = 0;
model.product_id = 999999;
}
else
{
model.quanguan = 0;
}
}
}
}
else
{
model.url_by = OldModel.url_by;
}
#endregion
#region 獲取數據
if (Request.Params["group_id"].ToString() != "")
{
int groupTryId = 0;
if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString()) && int.TryParse(Request.Params["group_id"].ToString(), out groupTryId))
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
else
{
model.group_id = OldModel.group_id;
}
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
if (_ucMgr.Delete(uc) > 0)
{
jsonStr = "{success:true}";
model.condition_id = 0;
}
else
{
jsonStr = "{success:false,msg:'user_condition刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
}
else if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
if (!string.IsNullOrEmpty(Request.Params["condition_id"]))//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
else
{
model.condition_id = OldModel.condition_id;
}
model.group_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["count_by"]))
{
model.count_by = Convert.ToInt32(Request.Params["count_by"].ToString());
}
else
{
model.count_by = OldModel.count_by;
}
if (!string.IsNullOrEmpty(Request.Params["numLimit"]))
{
model.num_limit = Convert.ToInt32(Request.Params["numLimit"].ToString());
}
else
{
model.num_limit = OldModel.num_limit;
}
if (!string.IsNullOrEmpty(Request.Params["IsRepeat"]))
{
model.repeat = Convert.ToInt32(Request.Params["IsRepeat"].ToString()) == 1 ? true : false;
}
else
{
model.repeat = OldModel.repeat;
}
if (!string.IsNullOrEmpty(Request.Params["frieghttype"].ToString()))
{
int typeId = 0;
if (int.TryParse(Request.Params["frieghttype"].ToString(), out typeId))
{
model.type = Convert.ToInt32(Request.Params["frieghttype"].ToString());
}
else
{
model.type = OldModel.type;
}
}
else
{
model.type = OldModel.type;
}
if (!string.IsNullOrEmpty(Request.Params["devicename"]))
{
model.device = Convert.ToInt32(Request.Params["devicename"].ToString());
}
else
{
model.device = OldModel.device;
}
if (!string.IsNullOrEmpty(Request.Params["payment"].ToString()))
{
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(Request.Params["payment"].ToString()))
{
model.payment_code = Request.Params["payment"].ToString();
}
else
{
model.payment_code = OldModel.payment_code;
}
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))
{
model.startdate = Convert.ToDateTime(Request.Params["start_time"].ToString());
}
else
{
model.startdate = OldModel.startdate;
}
if (!string.IsNullOrEmpty(Request.Params["end_time"]))
{
model.enddate = Convert.ToDateTime(Request.Params["end_time"].ToString());
}
else
{
model.enddate = OldModel.enddate;
}
//int siteTranId = 0;
//if (!string.IsNullOrEmpty(Request.Params["site"].ToString()) && int.TryParse(Request.Params["site"].ToString(), out siteTranId))//site
//{
// model.site = Convert.ToInt32(Request.Params["site"].ToString());
//}
//else
//{
// model.site = OldModel.site;
//}
if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName
{
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(Request.Params["site"].ToString()))
{
model.site = Request.Params["site"].ToString();// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08
}
else
{
model.site = OldModel.site;
}
}
#endregion
#region 贈品處理
if (!string.IsNullOrEmpty(Request.Params["gift_type"]))//gift_type when 1 then '商品' WHEN 2 then '機會' when 3 then '購物金' when 4 then '抵用券'
{
model.gift_type = Convert.ToInt32(Request.Params["gift_type"].ToString());
if (OldModel.gift_type == 2)
{
if (model.gift_type == 2)
{
if (OldModel.ticket_id != 0)
{
model.ticket_id = OldModel.ticket_id;
}
else
{
model.ticket_id = 0;
}
model.ticket_name = model.name;
}
else
{
if (_ptMgr.Delete(OldModel.ticket_id) > 0)
{
jsonStr = "{success:success}";
model.ticket_id = 0;
model.ticket_name = "";
}
else
{
jsonStr = "{success:false,msg:'promo_ticket刪除出錯！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
}
if (model.gift_type == 1)
{
model.gift_id = Convert.ToInt32(Request.Params["gift_id"].ToString());
model.gift_product_number = Convert.ToInt32(Request.Params["gift_product_number"].ToString());
}
else if (model.gift_type == 3)
{
model.bonus_type = 1;
}
else if (model.gift_type == 4)
{
model.bonus_type = 2;
}
if (!string.IsNullOrEmpty(Request.Params["activeNow"]))
{
model.active_now = Convert.ToInt32(Request.Params["activeNow"].ToString());
}
else
{
model.active_now = OldModel.active_now;
}
if (!string.IsNullOrEmpty(Request.Params["startdate"]))
{
model.use_start = Convert.ToDateTime(Request.Params["startdate"].ToString());
}
else
{
model.use_start = OldModel.use_start;
}
if (!string.IsNullOrEmpty(Request.Params["enddate"]))
{
model.use_end = Convert.ToDateTime(Request.Params["enddate"].ToString());
}
else
{
model.use_end = OldModel.use_end;
}
try
{
TimeSpan ts1 = new TimeSpan(model.use_end.Ticks);
TimeSpan ts2 = new TimeSpan(model.use_start.Ticks);
TimeSpan ts3 = ts1.Subtract(ts2).Duration();
int isAddDay = ts3.Hours > 0 ? 1 : 0;
model.valid_interval = ts3.Days + isAddDay;
}
catch
{
model.valid_interval = OldModel.valid_interval;
}
if (!string.IsNullOrEmpty(Request.Params["bonusAmount"]))
{
model.deduct_welfare = Convert.ToUInt32(Request.Params["bonusAmount"].ToString());
}
else
{
model.deduct_welfare = OldModel.deduct_welfare;
}
}
else
{
model.gift_type = OldModel.gift_type;
model.ticket_id = OldModel.ticket_id;
model.ticket_name = OldModel.ticket_name;
}
#endregion
model.status = 1;
_promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString);
if (string.IsNullOrEmpty(isEdit))
{
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.muser = model.kuser;
model.modified = model.created;
if (_promoAmountGiftMgr.Update(model, OldModel.event_id) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
else
{
model.kuser = OldModel.kuser;
model.created = OldModel.created;
model.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.modified = DateTime.Now;
if (_promoAmountGiftMgr.Update(model, OldModel.event_id) > 0)
{
jsonStr = "{success:true,msg:0}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
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 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 DeleteInspectionRe()
{
string json = string.Empty;
InspectionReportQuery query = new InspectionReportQuery();
List<InspectionReportQuery> list = new List<InspectionReportQuery>();
try
{
_inspectionReport = new BLL.gigade.Mgr.InspectionReportMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Form["rowID"]))
{
string rowIDs = Request.Form["rowID"];
if (rowIDs.IndexOf("∑") != -1)
{
foreach (string id in rowIDs.Split('∑'))
{
if (!string.IsNullOrEmpty(id))
{
query = new InspectionReportQuery();
string[] data = id.Split(',');
query.rowID = Convert.ToInt32(data[0]);
query.brand_id = Convert.ToUInt32(data[1]);
query.product_id = Convert.ToUInt32(data[2]);
string oldFileName = data[3];
list.Add(query);
#region 刪除圖片
string localInspectionReportPath = imgLocalPath + InspectionReportPath;//圖片存儲地址
string[] dirPath = new string[2];
dirPath[0] = query.brand_id.ToString() + "/".ToString();
dirPath[1] = query.product_id.ToString() + "/".ToString();
string ServerPath = Server.MapPath(imgLocalServerPath + InspectionReportPath + dirPath[0] + dirPath[1]);
CommonFunction.DeletePicFile(ServerPath + oldFileName);
FTP ftp = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1], ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localInspectionReportPath + dirPath[0] + dirPath[1] + oldFileName);
}
#endregion
}
}
}
}
json = _inspectionReport.DeleteInspectionRe(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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}