/// <summary>
/// 根據UserCondition對象的id獲取整個model對象
/// </summary>
/// <param name="uc"></param>
/// <returns></returns>
public UserCondition GetModelById(UserCondition uc)
{
StringBuilder sql = new StringBuilder();
try
{
sql.Append("select * from user_condition");
sql.AppendFormat(" where 1=1 and status=1 and condition_id={0};", uc.condition_id);
return _access.getSinggleObj<UserCondition>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("UserConditionMgr-->GetModelById-->" + ex.Message + sql.ToString(), ex);
}
}
public HttpResponseBase SavePromotionsAmountDiscountTwo()
{
try
{
string jsonStr = string.Empty;
PromotionsAmountDiscount model = new PromotionsAmountDiscount();
ProductCategory pmodel = new ProductCategory();
int isTryInt = 0;
#region 獲取新增時promotionamountdiscount和productcategory model值
if (!string.IsNullOrEmpty(Request.Params["pid"].ToString()))
{
model.id = Convert.ToInt32(Request.Params["pid"].ToString());
}
PromotionsAmountDiscountCustom oldermodel = _promoAmountDiscountMgr.GetModelById(model.id);
model.category_id = oldermodel.category_id;
pmodel.category_id = Convert.ToUInt32(oldermodel.category_id);
ProductCategory olderpcmodel = _produCateMgr.GetModelById(pmodel.category_id);
PromotionsAmountDiscountCustom pacdModel = new PromotionsAmountDiscountCustom();
pacdModel.id = model.id;
pacdModel.category_id = model.category_id;
if (!string.IsNullOrEmpty(Request.Params["name"].ToString()))
{
pacdModel.name = Request.Params["name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["desc"].ToString()))
{
pacdModel.event_desc = Request.Params["desc"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["e_type"].ToString()))
{
pacdModel.event_type = Request.Params["e_type"].ToString();
}
pacdModel.event_id = CommonFunction.GetEventId(pacdModel.event_type.ToString(), pacdModel.id.ToString());
if (!string.IsNullOrEmpty(Request.Params["url_by"].ToString()))
{
pacdModel.url_by = Convert.ToInt32(Request.Params["url_by"].ToString());
}
else
{
pacdModel.url_by = oldermodel.url_by;
}
if (pacdModel.url_by == 1)
{
#region 上傳圖片
try
{
if (Request.Files.Count != 0)
{
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);
//獲取上傳的圖片
HttpPostedFileBase file = Request.Files[0];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
fileName = Path.GetFileName(file.FileName);
if (!string.IsNullOrEmpty(fileName))
{
bool result = false;
string NewFileName = string.Empty;
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = pacdModel.event_id + newRand + fileExtention;//圖片重命名為event_id+4位隨機數+擴展名
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
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
{
//上傳
FileManagement fileLoad = new FileManagement();
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
pacdModel.banner_image = fileName;
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:'圖片上傳失敗'}";
pacdModel.banner_image = olderpcmodel.banner_image;
}
}
else
{
pacdModel.banner_image = olderpcmodel.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:'圖片上傳失敗'}";
pacdModel.banner_image = olderpcmodel.banner_image;
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["banner_url"].ToString()))//存連接地址
{
pacdModel.category_link_url = Request.Params["banner_url"].ToString();
}
else
{
pacdModel.category_link_url = olderpcmodel.category_link_url;
}
if (!string.IsNullOrEmpty(Request.Params["sbrand_id"].ToString()))
{
int brandTranId = 0;
if (int.TryParse(Request.Params["sbrand_id"].ToString(), out brandTranId))
{
pacdModel.brand_id = Convert.ToInt32(Request.Params["sbrand_id"].ToString());
}
else
{
pacdModel.brand_id = oldermodel.brand_id;
}
}
else
{
pacdModel.brand_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["sclass_id"].ToString()))
{
int classTranId = 0;
if (int.TryParse(Request.Params["sclass_id"].ToString(), out classTranId))
{
pacdModel.class_id = Convert.ToInt32(Request.Params["sclass_id"].ToString());
}
else
{
pacdModel.class_id = oldermodel.class_id;
}
}
else
{
pacdModel.class_id = 0;
}
if (Request.Params["allClass"].ToString() == "1")//是否全館
{
string allClass = Request.Params["allClass"];
pacdModel.brand_id = 0;
pacdModel.class_id = 0;
pacdModel.product_id = 999999;
}
}
else
{
//刪除上傳的圖片
//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);//刪除本地圖片
// }
pacdModel.banner_image = "";
pacdModel.category_link_url = "";
if (!string.IsNullOrEmpty(Request.Params["noclass_id"]) && int.TryParse(Request.Params["noclass_id"].ToString(), out isTryInt))
{
pacdModel.class_id = Convert.ToInt32(Request.Params["noclass_id"]);
}
else
{
pacdModel.class_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["nobrand_id"]) && int.TryParse(Request.Params["nobrand_id"].ToString(), out isTryInt))
{
pacdModel.brand_id = Convert.ToInt32(Request.Params["nobrand_id"]);
}
else
{
pacdModel.brand_id =0;
}
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
pacdModel.product_id = Convert.ToInt32(Request.Params["product_id"]);
}
else
{
pacdModel.product_id = 0;
}
if (!string.IsNullOrEmpty(Request.Params["no_allClass"]))
{
if (Request.Params["no_allClass"].ToString() == "1")//是否全館
{
string allClass = Request.Params["no_allClass"];
pacdModel.brand_id = 0;
pacdModel.class_id = 0;
pacdModel.product_id = 999999;
}
}
if (!string.IsNullOrEmpty(Request.Params["no_amount"]))
{
pacdModel.amount = Convert.ToInt32(Request.Params["no_amount"]);
}
else
{
pacdModel.amount = 0;
}
if (!string.IsNullOrEmpty(Request.Params["no_discount"]))
{
pacdModel.discount = Convert.ToInt32(Request.Params["no_discount"]);
}
else
{
pacdModel.discount = 0;
}
if (!string.IsNullOrEmpty(Request.Params["no_quantity"]))
{
pacdModel.quantity = Convert.ToInt32(Request.Params["no_quantity"]);
}
else
{
pacdModel.quantity = 0;
}
}
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))
{
pacdModel.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
else
{
pacdModel.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 delete failure！'}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
}
pacdModel.condition_id = 0;
}
else
{
if (Request.Params["condition_id"].ToString() != "" && Request.Params["condition_id"].ToString() != "0")
{
if (!string.IsNullOrEmpty(Request.Params["condition_id"].ToString()))//condition_id
{
pacdModel.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
else
{
pacdModel.condition_id = oldermodel.condition_id;
}
pacdModel.group_id = 0;
}
}
if (!string.IsNullOrEmpty(Request.Params["devicename"].ToString()))//device
{
pacdModel.device = Convert.ToInt32(Request.Params["devicename"].ToString());
}
else
{
pacdModel.device = oldermodel.device;
}
if (!string.IsNullOrEmpty(Request.Params["start_date"].ToString()))//start
{
pacdModel.start = Convert.ToDateTime(Request.Params["start_date"].ToString());
}
else
{
pacdModel.start = oldermodel.date_state;
}
if (!string.IsNullOrEmpty(Request.Params["end_date"].ToString()))//end
{
pacdModel.end = Convert.ToDateTime(Request.Params["end_date"].ToString());
}
else
{
pacdModel.end = oldermodel.date_end;
}
if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName
{
string site = Request.Params["site"].ToString();
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(site))
{
pacdModel.site = site;// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08
}
else
{
if (site.LastIndexOf(',') == site.Length - 1)//最後一個字符為，時
{
pacdModel.site = site.Substring(0, site.Length - 1);
}
}
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"].ToString()))//vendor_coverage
{
pacdModel.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
else
{
pacdModel.vendor_coverage = oldermodel.vendor_coverage;
}
//獲取pacdModel.category_father_id
List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", Used = 1, ParameterCode = pacdModel.event_type });
if (fatherIdResult.Count > 0)
{
pacdModel.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty);
}
pacdModel.active = false;
pacdModel.category_updatedate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pacdModel.status = 1;
pacdModel.category_ipfrom = Request.UserHostAddress;
#endregion
if (Request.Params["type"].ToString() == "Add")
{
pacdModel.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
pacdModel.created = DateTime.Now;
pacdModel.muser = pacdModel.kuser;
pacdModel.modified = pacdModel.created;
return AddPromotionsAmountDiscount(pacdModel);
}
else
{
pacdModel.kuser = oldermodel.kuser;
pacdModel.created = oldermodel.created;
pacdModel.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
pacdModel.modified = DateTime.Now;
return UpdatePromotionsAmountDiscount(pacdModel, CommonFunction.GetEventId(oldermodel.event_type.ToString(), oldermodel.id.ToString()));
}
}
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);
this.Response.Clear();
this.Response.Write("{success:false,msg:0}");
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;
}
/// <summary>
///獲取數據 會員條件設定新增或編輯
/// </summary>
/// <returns>跳轉到執行方法</returns>
public HttpResponseBase SavePromotionsUser()
{
NameValueCollection param = Request.Params;
UserCondition uc = new UserCondition();
uc.condition_name = param["condition_name"];
if (param["condition_id"] == "0" || param["condition_id"] == "")
{
if (!string.IsNullOrEmpty(Request.Params["reg_start"]))
{
uc.reg_start = Convert.ToInt32(CommonFunction.GetPHPTime(param["reg_start"].ToString()));
}
else
{
uc.reg_start = Convert.ToInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["reg_end"]))
{
uc.reg_end = Convert.ToInt32(CommonFunction.GetPHPTime(param["reg_end"].ToString()));
}
else
{
uc.reg_end = Convert.ToInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["reg_interval"]))
{
uc.reg_interval = Convert.ToInt32(param["reg_interval"]);
}
else
{
uc.reg_interval = 0;
}
if (!string.IsNullOrEmpty(Request.Params["buy_times_min"]))
{
uc.buy_times_min = Convert.ToInt32(param["buy_times_min"]);
}
else
{
uc.buy_times_min = 0;
}
if (!string.IsNullOrEmpty(Request.Params["buy_times_max"]))
{
uc.buy_times_max = Convert.ToInt32(param["buy_times_max"]);
}
else
{
uc.buy_times_max = 0;
}
if (!string.IsNullOrEmpty(Request.Params["buy_amount_min"]))
{
uc.buy_amount_min = Convert.ToInt32(param["buy_amount_min"]);
}
else
{
uc.buy_amount_min = 0;
}
if (!string.IsNullOrEmpty(Request.Params["buy_amount_max"]))
{
uc.buy_amount_max = Convert.ToInt32(param["buy_amount_max"]);
}
else
{
uc.buy_amount_max = 0;
}
if (!string.IsNullOrEmpty(Request.Params["last_time_start"]))
{
uc.last_time_start = Convert.ToInt32(CommonFunction.GetPHPTime(param["last_time_start"].ToString()));
}
else
{
uc.last_time_start = Convert.ToInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["last_time_end"]))
{
uc.last_time_end = Convert.ToInt32(CommonFunction.GetPHPTime(param["last_time_end"].ToString()));
}
else
{
uc.last_time_end = Convert.ToInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["last_time_interval"]))
{
uc.last_time_interval = Convert.ToInt32(param["last_time_interval"]);
}
else
{
uc.last_time_interval = 0;
}
if (!string.IsNullOrEmpty(Request.Params["join_channel"]))
{
uc.join_channel = Convert.ToInt32(param["join_channel"]);
}
else
{
uc.join_channel = 0;
}
uc.status = 1;
return AddPromotionsUser(uc);
}
else
{
uc.condition_id = Convert.ToInt32(param["condition_id"].ToString());
UserCondition OldUc = _ucMgr.Select(uc);
if (!string.IsNullOrEmpty(Request.Params["reg_start"]))
{
uc.reg_start = Convert.ToInt32(CommonFunction.GetPHPTime(param["reg_start"].ToString()));
}
else
{
uc.reg_start = OldUc.reg_start;
}
if (!string.IsNullOrEmpty(Request.Params["reg_end"]))
{
uc.reg_end = Convert.ToInt32(CommonFunction.GetPHPTime(param["reg_end"].ToString()));
}
else
{
uc.reg_end = OldUc.reg_end;
}
if (!string.IsNullOrEmpty(Request.Params["reg_interval"]))
{
uc.reg_interval = Convert.ToInt32(param["reg_interval"]);
}
else
{
uc.reg_interval = OldUc.reg_interval;
}
if (!string.IsNullOrEmpty(Request.Params["buy_times_min"]))
{
uc.buy_times_min = Convert.ToInt32(param["buy_times_min"]);
}
else
{
uc.buy_times_min = OldUc.buy_times_min;
}
if (!string.IsNullOrEmpty(Request.Params["buy_times_max"]))
{
uc.buy_times_max = Convert.ToInt32(param["buy_times_max"]);
}
else
{
uc.buy_times_max = OldUc.buy_times_max;
}
if (!string.IsNullOrEmpty(Request.Params["buy_amount_min"]))
{
uc.buy_amount_min = Convert.ToInt32(param["buy_amount_min"]);
}
else
{
uc.buy_amount_min = OldUc.buy_amount_min;
}
if (!string.IsNullOrEmpty(Request.Params["buy_amount_max"]))
{
uc.buy_amount_max = Convert.ToInt32(param["buy_amount_max"]);
}
else
{
uc.buy_amount_max = OldUc.buy_amount_max;
}
if (!string.IsNullOrEmpty(Request.Params["last_time_start"]))
{
uc.last_time_start = Convert.ToInt32(CommonFunction.GetPHPTime(param["last_time_start"].ToString()));
}
else
{
uc.last_time_start = OldUc.last_time_start;
}
if (!string.IsNullOrEmpty(Request.Params["last_time_end"]))
{
uc.last_time_end = Convert.ToInt32(CommonFunction.GetPHPTime(param["last_time_end"].ToString()));
}
else
{
uc.last_time_end = OldUc.last_time_end;
}
if (!string.IsNullOrEmpty(Request.Params["last_time_interval"]))
{
uc.last_time_interval = Convert.ToInt32(param["last_time_interval"]);
}
else
{
uc.last_time_interval = OldUc.last_time_interval;
}
if (!string.IsNullOrEmpty(Request.Params["join_channel"].ToString()))
{
int channelId = 0;
if (int.TryParse(Request.Params["join_channel"].ToString(), out channelId))
{
uc.join_channel = Convert.ToInt32(param["join_channel"]);
}
else
{
uc.join_channel = OldUc.join_channel;
}
}
else
{
uc.join_channel = OldUc.join_channel;
}
uc.status = 1;
return UpdatePromotionsUser(uc);
}
}
public HttpResponseBase UserConInfo()
{
UserCondition uc = new UserCondition();
string json = string.Empty;
if (Request.Params["condition_id"] != "" && Request.Params["condition_id"] != "0")
{
if (!string.IsNullOrEmpty(Request.Params["condition_id"]))
{
uc.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
}
else
{
uc.condition_id = 0;
}
UserCondition ucResult = new UserCondition();
ucResult = _ucMgr.GetModelById(uc);
ucResult.reg_startDateTime = CommonFunction.GetNetTime(ucResult.reg_start);
ucResult.reg_endDateTime = CommonFunction.GetNetTime(ucResult.reg_end);
ucResult.last_time_startDateTime = CommonFunction.GetNetTime(ucResult.last_time_start);
ucResult.last_time_endDateTime = CommonFunction.GetNetTime(ucResult.last_time_end);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
//json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";//返回json數據
try
{
if (ucResult != null)
{
json = "{success:true,data:[" + JsonConvert.SerializeObject(ucResult, Formatting.Indented, timeConverter) + "]}";
}
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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 會員條件設定編輯
/// </summary>
/// <param name="uc">UserCondition uc對象</param>
/// <returns>執行結果</returns>
public HttpResponseBase UpdatePromotionsUser(UserCondition uc)
{
string json = string.Empty;
try
{
if (_ucMgr.Update(uc) > 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>
/// <param name="uc">UserCondition uc對象</param>
/// <returns>執行結果 json數組獲取condition_id</returns>
public HttpResponseBase AddPromotionsUser(UserCondition uc)
{
string json = string.Empty;
try
{
System.Data.DataTable query = _ucMgr.Add(uc);
if (query != null)
{
json = "{success:true,id:" + query.Rows[0]["condition_id"] + ",data:" + JsonConvert.SerializeObject(query) + "}";
}
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 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;
}
/// <summary>
/// 查詢數據
/// </summary>
/// <param name="uc"></param>
/// <returns></returns>
public UserCondition Select(UserCondition uc)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("select * from user_condition where status = '1';");
return _access.getSinggleObj<UserCondition>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("UserConditionMgr-->Select-->" + ex.Message + sql.ToString(), ex);
}
}
/// <summary>
/// 新增或修改數據
/// </summary>
/// <returns>數據庫操作結果</returns>
public HttpResponseBase SavePromotionsAccumulateBonus()
{
string json = string.Empty;
Caller caller = Session["caller"] as Caller;
string rowid = Request.Form["rowid"];
string name = Request.Form["name"];
string group_id = Request.Form["group_id"];
string startTime = Request.Form["startTime"];
string end = Request.Form["end"];
string bonus_rate = Request.Form["bonus_rate"];
string extra_point = Request.Form["extra_point"];
string bonus_expire_day = Request.Form["bonus_expire_day"];
string new_user = Request.Form["new_user"];
string repeat = Request.Form["repeatPresent"];
string present_time = Request.Form["present_time"];
string active = Request.Form["active"];
string event_desc = Request.Form["event_desc"];
string event_type = Request.Form["event_type"];
string condition_id = Request.Form["condition_id"];
string device = Request.Form["device"];
string payment_code = Request.Form["payment_code"];
int kuser = caller.user_id;
string new_user_date = Request.Form["new_user_date"];
PromotionsAccumulateBonus model=new PromotionsAccumulateBonus();
int result = 0; //操作數據庫結果
if (string.IsNullOrEmpty(rowid)) //新增
{
model.name = name;
model.event_desc = event_desc;
if (!string.IsNullOrEmpty(group_id) )
{
model.group_id = Convert.ToInt32(group_id);
//判斷condition_id是否存在如果存在刪除原有數據
if (!string.IsNullOrEmpty(condition_id) && condition_id != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(condition_id);
_ucMgr.Delete(uc);
}
model.condition_id = 0;
}
else if (!string.IsNullOrEmpty(condition_id))
{
model.condition_id = Convert.ToInt32(condition_id);
model.group_id = 0;
}
if (!string.IsNullOrEmpty(bonus_rate))
{
model.bonus_rate = Convert.ToUInt32(bonus_rate);
model.extra_point = 0;
}
else if (!string.IsNullOrEmpty(extra_point))
{
model.extra_point = Convert.ToInt32(extra_point);
model.bonus_rate = 0;
}
model.bonus_expire_day = Convert.ToInt32(bonus_expire_day);
if (Convert.ToInt32(repeat) == 0)
{
model.repeat = 0;
model.present_time = Convert.ToInt32(present_time);
}
else if (Convert.ToInt32(repeat) == 1)
{
model.repeat = 1;
model.present_time = 0; //贈送次數清0
}
else if (Convert.ToInt32(repeat) == 2)
{
model.repeat = 2;
model.present_time = 0; //贈送次數清0
}
if (!string.IsNullOrEmpty(Request.Params["payment"]))
{
model.payment_code = Request.Params["payment"].ToString();
}
model.startTime = Convert.ToDateTime(startTime);
model.end = Convert.ToDateTime(end);
model.created = DateTime.Now;
model.modified = DateTime.Now;
model.muser = kuser;
model.kuser = kuser;
model.active = active == null ? false : true;
try
{
result = _promAccBnus.Save(model);
if (result == 1)
{
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,msg:'" + Resources.Promotion.ADD_FAIL + "'}";
}
}
else //修改
{
model = _promAccBnus.GetModel(Convert.ToInt32(rowid));
model.name = name;
model.event_desc = event_desc;
if (!string.IsNullOrEmpty(group_id))
{
try
{
model.group_id = Convert.ToInt32(group_id);
//判斷condition_id是否存在如果存在刪除原有數據
if (!string.IsNullOrEmpty(condition_id) && condition_id != "0")
{
UserCondition uc = new UserCondition();
uc.condition_id = Convert.ToInt32(condition_id);
_ucMgr.Delete(uc);
}
model.condition_id = 0; //將會員條件清0
}
catch
{
}
}
else if (!string.IsNullOrEmpty(condition_id))
{
model.condition_id = Convert.ToInt32(condition_id);
model.group_id = 0; //將會員群組清0
}
if (!string.IsNullOrEmpty(bonus_rate))
{
model.bonus_rate = Convert.ToUInt32(bonus_rate);
model.extra_point = 0;
}
else if (!string.IsNullOrEmpty(extra_point))
{
model.extra_point = Convert.ToInt32(extra_point);
model.bonus_rate = 0;
}
model.bonus_expire_day = Convert.ToInt32(bonus_expire_day);
if (!string.IsNullOrEmpty(new_user))
{
model.new_user = false;
}
if (Convert.ToInt32(repeat)==0)
{
model.repeat = 0;
model.present_time = 0;
}
else if (Convert.ToInt32(repeat)==1)
{
model.repeat = 1;
//model.present_time = 0; //贈送次數清0
model.present_time = Convert.ToInt32(present_time);
}
else if (Convert.ToInt32(repeat)==2)
{
model.repeat = 2;
//model.present_time = 0; //贈送次數清0
model.present_time = Convert.ToInt32(present_time);
}
if (!string.IsNullOrEmpty(Request.Params["payment"]))
{
model.payment_code = Request.Params["payment"].ToString();
}
model.startTime = Convert.ToDateTime(startTime);
model.end = Convert.ToDateTime(end);
model.active = active == null ? false : true;
model.modified = DateTime.Now;
model.muser = kuser;
try
{
result = _promAccBnus.Update(model);
if (result == 1)
{
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,msg:'" + Resources.Promotion.SAVE_FAIL + "'}";
}
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//public HttpResponseBase getfkfs()
//{
// List<PaymentType> fklx = new List<PaymentType>();
// List<PaymentType> nfklx = new List<PaymentType>();
// string resultStr = "";
// try
// {
// _paytyMgr = new PaymentTypeMgr(mySqlConnectionString);
// fklx = _paytyMgr.Myfkfs();
// PaymentType pt1 = new PaymentType();
// pt1.payment_name = "不分";
// pt1.payment_code = "0";
// nfklx.Add(pt1);
// for (int i = 0; i < fklx.Count; i++)
// {
// PaymentType pt = new PaymentType();
// pt.payment_name = fklx[i].payment_name;
// pt.payment_code = fklx[i].payment_code;
// nfklx.Add(pt);
// }
// resultStr = JsonConvert.SerializeObject(nfklx);
// }
// 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);
// }
//this.Response.Clear();
//this.Response.Write(resultStr);
//this.Response.End();
//return this.Response;
//}
#endregion
#region 點數累積 判斷保存或者編輯 +HttpResponseBase Save()
public HttpResponseBase Save()
{
PromotionsAccumulateRate model = new PromotionsAccumulateRate();
model.muser=(System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
model.modified = DateTime.Now;
string jsonStr = String.Empty;
//判斷是否能夠獲取到rowid
if (String.IsNullOrEmpty(Request.Params["rowid"]))
{
//todo:對model進行賦值
model.kuser = model.muser;
model.created = model.modified;
#region try catch 應用
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = 0;
}
try
{
if (Convert.ToInt32(Request.Params["bonus_type"]) == 1)
{
model.bonus_type = 1;
}
else
{
model.bonus_type = 0;
}
}
catch
{
model.bonus_type = 0;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = DateTime.Now;
}
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = 0;
}
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 = 0;
}
model.group_id = 0;
}
try
{
model.start = Convert.ToDateTime(Request.Params["newstart"]);
}
catch (Exception)
{
model.start = DateTime.Now;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = "";
}
try
{
model.dollar = Convert.ToInt32(Request.Params["dollar"]);
}
catch (Exception)
{
model.dollar = 0;
}
try
{
model.point = Convert.ToInt32(Request.Params["points"]);
}
catch (Exception)
{
model.point = 0;
}
try
{
model.payment_type_rid = Request.Params["payment_id"];
}
catch (Exception)
{
model.payment_type_rid = "";
}
#endregion
return InsertPromotionsAccumulateRate(model);//如果獲取不到則進行新增
}
else
{
_padAccRateMgr = new PromotionsAccumulateRateMgr(mySqlConnectionString);
model.id = Convert.ToInt32(Request.Params["rowid"].ToString());
PromotionsAccumulateRate PAR = _padAccRateMgr.GetModel(model.id);
#region try catch應用
try
{
model.amount = Convert.ToInt32(Request.Params["amount"]);
}
catch (Exception)
{
model.amount = PAR.amount;
}
try
{
model.bonus_type = Convert.ToInt32(Request.Params["bonus_type"]);
}
catch (Exception)
{
model.bonus_type = PAR.bonus_type;
}
try
{
model.end = Convert.ToDateTime(Request.Params["end"]);
}
catch (Exception)
{
model.end = PAR.end;
}
try
{
model.start = Convert.ToDateTime(Request.Params["newstart"]);
}
catch (Exception)
{
model.start = PAR.start;
}
try
{
model.name = Request.Params["name"];
}
catch (Exception)
{
model.name = PAR.name;
}
try
{
model.dollar = Convert.ToInt32(Request.Params["dollar"]);
}
catch (Exception)
{
model.dollar = 0;
}
try
{
model.point = Convert.ToInt32(Request.Params["points"]);
}
catch (Exception)
{
model.point = PAR.point;
}
try
{
model.payment_type_rid = Request.Params["payment_id"];
}
catch (Exception)
{
model.payment_type_rid = PAR.payment_type_rid;
}
//try
//{
// model.group_id = Convert.ToInt32(Request.Params["group_id"]);
//}
//catch (Exception)
//{
// model.group_id = PAR.group_id;
//}
//try
//{
// if (Convert.ToInt32(Request.Params["condition_id"]) != 0)
// {
// model.condition_id = Convert.ToInt32(Request.Params["condition_id"]);
// //model.group_id = 0;
// }
// else
// {
// model.condition_id = 0;
// }
//}
//catch (Exception)
//{
// model.condition_id = PAR.condition_id;
//}
if (Request.Params["group_id"].ToString() != "")
{
try//group_id
{
model.group_id = Convert.ToInt32(Request.Params["group_id"].ToString());
}
catch (Exception)
{
model.group_id = PAR.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")
{
try//condition_id
{
model.condition_id = Convert.ToInt32(Request.Params["condition_id"].ToString());
}
catch (Exception)
{
model.condition_id = PAR.condition_id;
}
model.group_id = 0;
}
#endregion
model.active = false;
//todo:對model進行賦值
return UpdatePromotionsAccumulateRate(model);//如果可以獲取到rowid則進行修改
}
}
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 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;
}
