public HttpResponseBase UpdateItemPrice()
{
string json = string.Empty;
try
{
if (!PriceMaster.CheckProdName(Request.Form["product_name"]))
{
json = "{success:false,msg:'" + Resources.Product.FORBIDDEN_CHARACTER + "'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
JavaScriptSerializer jsSer = new JavaScriptSerializer();
uint priceMasterId = uint.Parse(Request.Form["price_master_id"] ?? "0");
float default_bonus_percent = float.Parse(Request.Form["default_bonus_percent"] ?? "1");
float bonus_percent = float.Parse(Request.Form["bonus_percent"] ?? "1");
int same_price = (Request.Form["same_price"] ?? "") == "on" ? 1 : 0;
int accumulated_bonus = (Request.Form["accumulated_bonus"] ?? "") == "on" ? 1 : 0;
string start = Request.Form["event_start"] != null ? Request.Form["event_start"] : "0";//edit by zhuoqin0830w 2015/01/14 判斷時間是否為null
string end = Request.Form["event_end"] != null ? Request.Form["event_end"] : "0";//edit by zhuoqin0830w 2015/01/14 判斷時間是否為null
string bonus_start = Request.Form["bonus_percent_start"] ?? "";
string bonus_end = Request.Form["bonus_percent_end"] ?? "";
string valid_start = Request.Form["valid_start"] ?? "0";//edit by zhuoqin0830w 2015/01/28 判斷時間是否為null
string valid_end = Request.Form["valid_end"] ?? "0";//edit by zhuoqin0830w 2015/01/28 判斷時間是否為null
string items = Request.Form["Items"];
List<ItemPrice> newPrices = jsSer.Deserialize<List<ItemPrice>>(items);
_priceMasterMgr = new PriceMasterMgr(connectionString);
_priceMasterTsMgr = new PriceMasterTsMgr("");
PriceMaster priceMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = priceMasterId }).FirstOrDefault();
if (priceMaster != null)
{
#region 處理PriceMaster
priceMaster.user_id = 0;
priceMaster.product_name = PriceMaster.Product_Name_FM(Request.Form["productFormat"] ?? "");
priceMaster.same_price = same_price;
priceMaster.accumulated_bonus = Convert.ToUInt32(accumulated_bonus);
priceMaster.user_level = uint.Parse(Request.Form["user_level"] ?? "1");
if (!string.IsNullOrEmpty(start))
{
priceMaster.event_start = Convert.ToUInt32(CommonFunction.GetPHPTime(start));
}
if (!string.IsNullOrEmpty(end))
{
priceMaster.event_end = Convert.ToUInt32(CommonFunction.GetPHPTime(end));
}
if (!string.IsNullOrEmpty(bonus_start))
{
priceMaster.bonus_percent_start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_start));
}
if (!string.IsNullOrEmpty(bonus_end))
{
priceMaster.bonus_percent_end = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_end));
}
if (!string.IsNullOrEmpty(valid_start))
{
priceMaster.valid_start = Convert.ToInt32(CommonFunction.GetPHPTime(valid_start));
}
if (!string.IsNullOrEmpty(valid_end))
{
priceMaster.valid_end = Convert.ToInt32(CommonFunction.GetPHPTime(valid_end));
}
if (!string.IsNullOrEmpty(Request.Form["user_id"]))
{
_usersMgr = new UsersMgr(connectionString);
System.Data.DataTable dt_User = _usersMgr.Query(Request.Form["user_id"]);
if (dt_User != null && dt_User.Rows.Count > 0)
{
priceMaster.user_id = Convert.ToUInt32(dt_User.Rows[0]["user_id"]);
}
}
priceMaster.price = Convert.ToInt32(newPrices.Min(m => m.item_money));
priceMaster.event_price = Convert.ToInt32(newPrices.Min(m => m.event_money));
if (same_price == 0)
{
priceMaster.max_price = Convert.ToInt32(newPrices.Max(m => m.item_money));
priceMaster.max_event_price = Convert.ToInt32(newPrices.Max(m => m.event_money));
}
priceMaster.cost = Convert.ToInt32(newPrices.Min(m => m.item_cost));
priceMaster.event_cost = Convert.ToInt32(newPrices.Min(m => m.event_cost));
priceMaster.bonus_percent = bonus_percent;
priceMaster.default_bonus_percent = default_bonus_percent;
priceMaster.price_status = 2;//申請審核
#endregion
bool isExist = false;
List<PriceMasterCustom> masterList = _priceMasterMgr.Query(new PriceMaster { site_id = priceMaster.site_id, user_id = priceMaster.user_id, user_level = priceMaster.user_level, product_id = priceMaster.product_id });
List<PriceMasterCustom> resultList = masterList.Where(p => p.price_master_id != priceMaster.price_master_id).ToList();
if (resultList != null && resultList.Count() > 0)
{
if (priceMaster.user_id != 0 || (priceMaster.user_id == 0 && resultList.Where(p => p.user_id == 0).Count() > 0))
{
json = "{success:false,msg:'" + Resources.Product.SITE_EXIST + "'}";
isExist = true;
}
}
if (!isExist)
{
ArrayList excuteSql = new ArrayList();
Product product = null;
if (priceMaster.site_id == 1 && priceMaster.user_level == 1 && priceMaster.user_id == 0)
{
#region 處理Product
_productMgr = new ProductMgr(connectionString);
product = _productMgr.Query(new Product { Product_Id = priceMaster.product_id }).FirstOrDefault();
if (product != null)
{
product.Default_Bonus_Percent = default_bonus_percent;
product.Bonus_Percent = bonus_percent;
}
excuteSql.Add(_productMgr.Update(product, 0));
#endregion
#region 處理ProductItem
//_productItemMgr = new ProductItemMgr(connectionString);
//List<ProductItem> productItems = _productItemMgr.Query(new ProductItem { Product_Id = priceMaster.product_id });
//if (productItems != null)
//{
// if (!string.IsNullOrEmpty(start))
// {
// productItems.ForEach(m => m.Event_Product_Start = Convert.ToUInt32(CommonFunction.GetPHPTime(start)));
// }
// if (!string.IsNullOrEmpty(end))
// {
// productItems.ForEach(m => m.Event_Product_End = Convert.ToUInt32(CommonFunction.GetPHPTime(end)));
// }
// newPrices.ForEach(m =>{
// ProductItem pi = productItems.Find(n => n.Item_Id == m.item_id);
// pi.Item_Money = m.item_money;
// pi.Item_Cost = m.item_cost;
// pi.Event_Item_Money = m.event_money;
// pi.Event_Item_Cost = m.event_cost;
// });
// productItems.ForEach(m => excuteSql.Add(_productItemMgr.Update(m)));
//}
#endregion
}
//價格修改 申請審核
PriceUpdateApply priceUpdateApply = new PriceUpdateApply { price_master_id = priceMasterId };
priceUpdateApply.apply_user = Convert.ToUInt32((Session["caller"] as Caller).user_id);
//價格審核記錄
PriceUpdateApplyHistory applyHistroy = new PriceUpdateApplyHistory();
applyHistroy.user_id = Convert.ToInt32(priceUpdateApply.apply_user);
//applyHistroy.price_status = 1;
//applyHistroy.type = 3;
applyHistroy.price_status = 1; //edit by wwei0216w 2014/12/16 價格修改時 price_status為 2申請審核
applyHistroy.type = 1;//edit by wwei0216w 所作操作為 1:申請審核的操作
_priceUpdateApplyMgr = new PriceUpdateApplyMgr(connectionString);
_priceUpdateApplyHistoryMgr = new PriceUpdateApplyHistoryMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
bool result = true;
int apply_id = _priceUpdateApplyMgr.Save(priceUpdateApply);
if (apply_id != -1)
{
priceMaster.apply_id = Convert.ToUInt32(apply_id);
applyHistroy.apply_id = apply_id;
//excuteSql.Add(_priceMasterMgr.Update(priceMaster));
excuteSql.Add(_priceMasterTsMgr.UpdateTs(priceMaster)); //修改站台價格，不再更新price_master表，改為更新price_master_ts表 edit by xiangwang0413w 2014/07/21
excuteSql.Add(_priceUpdateApplyHistoryMgr.SaveSql(applyHistroy));
//item_price_id==0 新增規格，做新增動作
_itemPriceMgr = new ItemPriceMgr(connectionString);
newPrices.FindAll(m => m.item_price_id == 0).ForEach(m => excuteSql.Add(_itemPriceMgr.Save(m)));
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/Product/ProductSave");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid };
batch.batchno = Request.Params["batch"] ?? "";
batch.kuser = (Session["caller"] as Caller).user_email;
if (_tableHistoryMgr.SaveHistory<PriceMaster>(priceMaster, batch, excuteSql))
{
//_itemPriceMgr = new ItemPriceMgr("");
_itemPriceTsMgr = new ItemPriceTsMgr("");
foreach (var item in newPrices.FindAll(m => m.item_price_id != 0))
{
item.apply_id = (uint)apply_id;//细项与主项使用相同的apply_id
excuteSql = new ArrayList();
//excuteSql.Add(_itemPriceMgr.Update(item));
excuteSql.Add(_itemPriceTsMgr.UpdateTs(item));//修改站台價格，不再更新item_price表，改為更新item_price_ts表 edit by xiangwang0413w 2014/07/21
if (!_tableHistoryMgr.SaveHistory<ItemPrice>(item, batch, excuteSql))
{
result = false;
}
}
}
else
{
result = false;
}
}
else
{
result = false;
}
//若為單一商品,則把product_item.export_flag改為2 edit by xiangwang0413w 2014/06/30
//if (result&&product != null && product.Combination == 1)
//{
// _productItemMgr = new ProductItemMgr(connectionString);
// ProductItem pro_Item = new ProductItem() { Product_Id = product.Product_Id, Export_flag = 2 };
// _productItemMgr.UpdateExportFlag(pro_Item);
//}
json = "{success:" + result.ToString().ToLower() + "}";
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public string ComboPriceSave()
{
string json = "{success:true}";
if (!PriceMaster.CheckProdName(Request.Form["product_name"]))
{
return "{success:false,msg:'" + Resources.Product.FORBIDDEN_CHARACTER + "'}";
}
ProductTemp pTemp = new ProductTemp();
List<PriceMasterTemp> pMasterListT = new List<PriceMasterTemp>();
List<PriceMaster> pMasterList = new List<PriceMaster>();
List<List<ItemPrice>> ItemPList = new List<List<ItemPrice>>();
PriceMasterTemp pMasterTemp = new PriceMasterTemp();
if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
{
pTemp.Product_Id = Request.Form["OldProductId"];
pMasterTemp.product_id = Request.Form["OldProductId"];
}
string paramValue = Request.Params["paramValue"];
#region 參數
int writer_id = (Session["caller"] as Caller).user_id;
string product_name = PriceMaster.Product_Name_FM(Request.Params["product_name"]);
string price_type = Request.Params["price_type"];
string product_price_list = Request.Params["product_price_list"];
string default_bonus_percent = Request.Params["default_bonus_percent"];
string price = Request.Params["price"];
string cost = Request.Params["cost"];
string max_price = Request.Params["max_price"];
string bonus_percent = Request.Params["bonus_percent"];
string event_price = Request.Params["event_price"];
string event_cost = Request.Params["event_cost"];
string max_event_price = Request.Params["max_event_price"];
string event_start = Request.Params["event_start"];
string event_end = Request.Params["event_end"];
string site_id = Request.Params["site_id"];
string user_level = Request.Params["user_level"];
string user_mail = Request.Params["user_mail"];
string bag_check_money = Request.Params["bag_check_money"] == "" ? "0" : Request.Params["bag_check_money"];
string accumulated_bonus = Request.Params["accumulated_bonus"];
string bonus_percent_start = Request.Params["bonus_percent_start"];
string bonus_percent_end = Request.Params["bonus_percent_end"];
string same_price = Request.Params["same_price"];
string show_listprice = Request.Params["show_listprice"];
string valid_start = Request.Params["valid_start"];
string valid_end = Request.Params["valid_end"];
#endregion
List<MakePriceCustom> PriceStore = new List<MakePriceCustom>();
if (price_type == "2")//各自定價
{
JavaScriptSerializer jss = new JavaScriptSerializer();
string priceStr = Request.Params["priceStr"];
PriceStore = jss.Deserialize<List<MakePriceCustom>>(priceStr);
}
if (!string.IsNullOrEmpty(Request.Params["product_id"]))
{
#region 正式表操作
List<PriceMaster> pMList = new List<PriceMaster>();
//插入price_master
_priceMasterMgr = new PriceMasterMgr(connectionString);
_priceMasterTsMgr = new PriceMasterTsMgr(connectionString);
PriceMaster pMaster = new PriceMaster();
//查詢price_master
if (!string.IsNullOrEmpty(Request.Params["price_master_id"]))
{
pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = uint.Parse(Request.Params["price_master_id"]) }).FirstOrDefault();
}
pMaster.product_id = uint.Parse(Request.Params["product_id"]);
pMaster.child_id = int.Parse(Request.Params["product_id"]);
pMaster.site_id = uint.Parse(site_id);
uint userId = 0;
if (!string.IsNullOrEmpty(Request.Form["user_mail"]))
{
_usersMgr = new UsersMgr(connectionString);
System.Data.DataTable dt_User = _usersMgr.Query(Request.Form["user_mail"]);
if (dt_User != null && dt_User.Rows.Count > 0)
{
userId = Convert.ToUInt32(dt_User.Rows[0]["user_id"]);
}
}
if (userId != 0)
{
pMaster.user_id = userId;
}
if (user_level != "")
{
pMaster.user_level = uint.Parse(user_level);
}
pMaster.product_name = product_name;
pMaster.bonus_percent = float.Parse(bonus_percent);
pMaster.cost = int.Parse(cost);
pMaster.price = int.Parse(price);
pMaster.max_price = int.Parse(max_price);
pMaster.max_event_price = int.Parse(max_event_price);
pMaster.default_bonus_percent = float.Parse(default_bonus_percent);
pMaster.event_price = int.Parse(event_price);
pMaster.event_cost = int.Parse(event_cost);
pMaster.same_price = int.Parse(same_price);
pMaster.price_status = 2;//申請審核
pMaster.accumulated_bonus = uint.Parse(accumulated_bonus);
#region 時間 活動時間
if (event_start != "")
{
pMaster.event_start = Convert.ToUInt32(CommonFunction.GetPHPTime(event_start));
}
if (event_end != "")
{
pMaster.event_end = Convert.ToUInt32(CommonFunction.GetPHPTime(event_end));
}
if (bonus_percent_start != "")
{
pMaster.bonus_percent_start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_start));
}
if (bonus_percent_end != "")
{
pMaster.bonus_percent_end = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_end));
}
if (!string.IsNullOrEmpty(valid_start))
{
pMaster.valid_start = Convert.ToInt32(CommonFunction.GetPHPTime(valid_start));
}
if (!string.IsNullOrEmpty(valid_end))
{
pMaster.valid_end = Convert.ToInt32(CommonFunction.GetPHPTime(valid_end));
}
#endregion
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/ProductCombo");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid };
batch.batchno = Request.Params["batch"] ?? "";
batch.kuser = (Session["caller"] as Caller).user_email;
List<ItemPrice> update = new List<ItemPrice>();
if (price_type == "2") //各自定價
{
CreateList(PriceStore, pMaster, null, same_price, ItemPList, pMasterListT, pMasterList, update);
}
pMasterList.Add(pMaster);
try
{
//價格修改 申請審核
PriceUpdateApply priceUpdateApply = new PriceUpdateApply();
priceUpdateApply.apply_user = Convert.ToUInt32((Session["caller"] as Caller).user_id);
//價格審核記錄
PriceUpdateApplyHistory applyHistroy = new PriceUpdateApplyHistory();
applyHistroy.user_id = Convert.ToInt32(priceUpdateApply.apply_user);
applyHistroy.price_status = 1;
//applyHistroy.type = 3;
applyHistroy.type = 1;//edit by wwei0216w 所作操作為 1:申請審核的操作
_priceUpdateApplyMgr = new PriceUpdateApplyMgr(connectionString);
_priceUpdateApplyHistoryMgr = new PriceUpdateApplyHistoryMgr(connectionString);
_tableHistoryMgr = new TableHistoryMgr(connectionString);
ArrayList excuteSql = new ArrayList();
if (!string.IsNullOrEmpty(Request.Params["price_master_id"]))
{
#region 修改
priceUpdateApply.price_master_id = pMaster.price_master_id;
PriceMaster priceMster = _priceMasterMgr.QueryPMaster(new PriceMaster()
{
site_id = uint.Parse(site_id),
user_level = uint.Parse(user_level == "" ? "0" : user_level),
user_id = userId,
product_id = uint.Parse(Request.Params["product_id"]),
price_master_id = uint.Parse(Request.Params["price_master_id"])
});
//更新price_master
if (priceMster != null)
{
json = "{success:true,msg:'" + Resources.Product.SITE_EXIST + "'}";
}
else
{
int apply_id = _priceUpdateApplyMgr.Save(priceUpdateApply);
if (apply_id != -1)
{
bool flag = false;
foreach (var item in pMasterList)
{
item.apply_id = (uint)apply_id;
excuteSql = new ArrayList();
if (item == pMaster)
{
pMaster.apply_id = Convert.ToUInt32(apply_id);
applyHistroy.apply_id = apply_id;
excuteSql.Add(_priceUpdateApplyHistoryMgr.SaveSql(applyHistroy));
}
//excuteSql.Add(_priceMasterMgr.Update(item));
excuteSql.Add(_priceMasterTsMgr.UpdateTs(item));//edit by xiangwang0413w 2014/07/16 將數據更新到pirce_master_ts表
flag = _tableHistoryMgr.SaveHistory<PriceMaster>(item, batch, excuteSql);
}
if (flag)
{
//更新item_price
//_itemPriceMgr = new ItemPriceMgr("");
_itemPriceTsMgr = new ItemPriceTsMgr(connectionString);
foreach (var iPrice in update)
{
iPrice.apply_id = (uint)apply_id;
excuteSql = new ArrayList();
//excuteSql.Add(_itemPriceMgr.Update(iPrice));
excuteSql.Add(_itemPriceTsMgr.UpdateTs(iPrice));//edit by xiangwang0413w 2014/07/17 將數據更新到pirce_master_ts表
if (!_tableHistoryMgr.SaveHistory<ItemPrice>(iPrice, batch, excuteSql))
{
json = "{success:true,msg:'" + Resources.Product.EDIT_FAIL + "'}";
}
}
json = "{success:true,msg:'" + Resources.Product.EDIT_SUCCESS + "'}";
}
else
{
json = "{success:true,msg:'" + Resources.Product.EDIT_FAIL + "'}";
}
}
else
{
json = "{success:true,msg:'" + Resources.Product.EDIT_FAIL + "'}";
}
}
#endregion
}
else
{
#region 新增
string msg = string.Empty;
int status = 0;
List<ItemPrice> iprice = (ItemPList == null || ItemPList.Count == 0) ? null : ItemPList[pMasterList.IndexOf(pMaster)];
int priceMasterId = _priceMasterMgr.Save(pMaster, iprice, null, ref msg);
if (priceMasterId != -1)
{
priceUpdateApply.price_master_id = Convert.ToUInt32(priceMasterId);
int apply_id = _priceUpdateApplyMgr.Save(priceUpdateApply);
if (apply_id != -1)
{
pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
pMaster.apply_id = Convert.ToUInt32(apply_id);
excuteSql.Add(_priceMasterMgr.Update(pMaster));
excuteSql.Add(_priceMasterTsMgr.UpdateTs(pMaster)); //edit by xiangwang0413w 2014/07/22 更新price_master_ts表後同時更新price_master_ts表，以便價格審核
foreach (var item in pMasterList.FindAll(m => m.product_id != m.child_id))
{
iprice = (ItemPList == null || ItemPList.Count == 0) ? null : ItemPList[pMasterList.IndexOf(item)];
priceMasterId = _priceMasterMgr.Save(item, iprice, null, ref msg);
pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
if (priceMasterId != -1)
{
priceUpdateApply.price_master_id = Convert.ToUInt32(priceMasterId);
pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
pMaster.apply_id = Convert.ToUInt32(apply_id);
excuteSql.Add(_priceMasterMgr.Update(pMaster));
excuteSql.Add(_priceMasterTsMgr.UpdateTs(pMaster)); //edit by xiangwang0413w 2014/07/22 更新price_master_ts表後同時更新price_master_ts表，以便價格審核
}
else { status = 2; }
}
}
else { status = 3; }
}
else { status = 3; }
excuteSql.Add(_priceUpdateApplyHistoryMgr.SaveSql(applyHistroy));
_tableHistoryMgr = new TableHistoryMgr(connectionString);
if (_tableHistoryMgr.SaveHistory<PriceMaster>(pMaster, batch, excuteSql))
{
status = 1;
}
else { status = 2; }
//foreach (var item in pMasterList)
//{
// List<ItemPrice> iprice = (ItemPList == null || ItemPList.Count == 0) ? null : ItemPList[pMasterList.IndexOf(item)];
// int priceMasterId = _priceMasterMgr.Save(item, iprice, null, ref msg);
// if (apply_id != -1)
// {
// pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
// }
// if (priceMasterId != -1)
// {
// if (item != pMaster) { status = 1; continue; }
// priceUpdateApply.price_master_id = Convert.ToUInt32(priceMasterId);
// int apply_id = _priceUpdateApplyMgr.Save(priceUpdateApply);
// if (apply_id != -1)
// {
// pMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
// pMaster.apply_id = Convert.ToUInt32(apply_id);
// applyHistroy.apply_id = apply_id;
// excuteSql.Add(_priceMasterMgr.Update(pMaster));
// excuteSql.Add(_priceMasterTsMgr.UpdateTs(pMaster)); //edit by xiangwang0413w 2014/07/22 更新price_master_ts表後同時更新price_master_ts表，以便價格審核
// excuteSql.Add(_priceUpdateApplyHistoryMgr.SaveSql(applyHistroy));
// _tableHistoryMgr = new TableHistoryMgr(connectionString);
// if (_tableHistoryMgr.SaveHistory<PriceMaster>(pMaster, batch, excuteSql))
// {
// status = 1;
// }
// else { status = 2; }
// }
// else { status = 2; }
// }
// else { status = 3; }
//}
if (status == 1)
{
json = "{success:true,msg:'" + Resources.Product.ADD_SUCCESS + "'}";
}
else if (status == 2)
{
json = "{success:false,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
else
{
json = "{success:false,msg:'" + msg + "'}";
}
#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,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
#endregion
}
else
{
#region 新增至臨時表
try
{
_productTempMgr = new ProductTempMgr(connectionString);
_pMasterTempMgr = new PriceMasterTempMgr(connectionString);
//product_temp
pTemp.Product_Price_List = uint.Parse(product_price_list);
pTemp.Writer_Id = writer_id;
pTemp.Combo_Type = COMBO_TYPE;
pTemp.Price_type = int.Parse(price_type);
pTemp.Bag_Check_Money = uint.Parse(bag_check_money);
pTemp.show_listprice = uint.Parse(show_listprice);
pTemp.Bonus_Percent = float.Parse(bonus_percent);
pTemp.Default_Bonus_Percent = float.Parse(default_bonus_percent);
//Price_Master
pMasterTemp.product_name = product_name; ;
pMasterTemp.default_bonus_percent = float.Parse(default_bonus_percent);
pMasterTemp.writer_Id = writer_id;
pMasterTemp.combo_type = COMBO_TYPE;
//默認站臺1:吉甲地,(按統一價格比例拆分)會員等級1：普通會員
pMasterTemp.site_id = 1;
pMasterTemp.user_level = 1;
pMasterTemp.same_price = int.Parse(same_price);
pMasterTemp.accumulated_bonus = uint.Parse(accumulated_bonus);
pMasterTemp.bonus_percent = float.Parse(bonus_percent);
pMasterTemp.price = int.Parse(price);
pMasterTemp.cost = int.Parse(cost);
pMasterTemp.max_price = int.Parse(max_price);
pMasterTemp.max_event_price = int.Parse(max_event_price);
pMasterTemp.event_price = int.Parse(event_price);
pMasterTemp.event_cost = int.Parse(event_cost);
#region 時間 活動時間
if (event_start != "")
{
pMasterTemp.event_start = Convert.ToUInt32(CommonFunction.GetPHPTime(event_start));
}
if (event_end != "")
{
pMasterTemp.event_end = Convert.ToUInt32(CommonFunction.GetPHPTime(event_end));
}
if (bonus_percent_start != "")
{
pMasterTemp.bonus_percent_start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_start));
pTemp.Bonus_Percent_Start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_start));
}
if (bonus_percent_end != "")
{
pMasterTemp.bonus_percent_end = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_end));
pTemp.Bonus_Percent_End = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_percent_end));
}
if (!string.IsNullOrEmpty(valid_start))
{
pMasterTemp.valid_start = Convert.ToInt32(CommonFunction.GetPHPTime(valid_start));
}
if (!string.IsNullOrEmpty(valid_end))
{
pMasterTemp.valid_end = Convert.ToInt32(CommonFunction.GetPHPTime(valid_end));
}
#endregion
pMasterTemp.price_status = 1;
_productItemMgr = new ProductItemMgr(connectionString);
string oldProductId = "0";
if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
{
oldProductId = Request.Form["OldProductId"];
}
List<ItemPrice> update = new List<ItemPrice>();
if (price_type == "2")
{
_combTempMgr = new ProductComboTempMgr(connectionString);
List<ProductComboCustom> combResultList = _combTempMgr.priceComboQuery(new ProductComboCustom { Writer_Id = writer_id, Parent_Id = int.Parse(oldProductId.ToString()) });
bool match = true;
if (combResultList.Count() > 0)
{
int countBySearchPile = combResultList.GroupBy(m => m.Pile_Id).Count(); //庫中原有價格數據
int countByStorePile = PriceStore.GroupBy(m => m.Pile_Id).Count(); //頁面store數據
//判斷群組數量是否相同
if (countBySearchPile == countByStorePile)
{
for (int i = 1; i <= countBySearchPile; i++)
{
//組合類型為固定或任選時pile_id為0;
var tempSearch = combResultList.Where(m => m.Pile_Id == (combResultList[0].Pile_Id == 0 ? 0 : i)).ToList().GroupBy(m => m.Child_Id).ToList();
var tempPrice = PriceStore.Where(m => m.Pile_Id == (combResultList[0].Pile_Id == 0 ? 0 : i)).ToList().GroupBy(m => m.Child_Id).ToList();
//判斷當前組中子商品的數量是否相同
if (tempSearch.Count() == tempPrice.Count())
{
foreach (var item in tempPrice)
{
if (tempSearch.Where(m => m.Key == item.Key.ToString()).ToList().Count() <= 0)//edit 2014/09/24
{
match = false;
break;
}
}
}
else
{
match = false;
break;
}
}
}
else
{
match = false;
}
}
else
{
match = false;
}
if (!match)
{
_combTempMgr = new ProductComboTempMgr(connectionString);
_combTempMgr.comboPriceDelete(new ProductComboTemp { Writer_Id = writer_id, Combo_Type = COMBO_TYPE, Parent_Id = oldProductId });
PriceStore.ForEach(rec => rec.price_master_id = 0);
}
CreateList(PriceStore, null, pMasterTemp, same_price, ItemPList, pMasterListT, pMasterList, update);
}
pMasterListT.Add(pMasterTemp);
//如果原價格為複製價格，則需刪除原複製價格並將child_id設為oldProductId
if (oldProductId != "0")
{
pMasterListT.ForEach(m =>
{
if (m.child_id == "0")
{
m.child_id = oldProductId;
}
});
}
//查詢
PriceMasterProductCustom queryReust = _pMasterTempMgr.Query(new PriceMasterTemp() { writer_Id = writer_id, child_id = oldProductId, product_id = oldProductId, combo_type = COMBO_TYPE });
//檢查價格類型是否有變動，如果有則刪除原有價格數據
if (queryReust != null)
{
if (!price_type.Equals(queryReust.price_type.ToString()))
{
_combTempMgr = new ProductComboTempMgr(connectionString);
_combTempMgr.comboPriceDelete(new ProductComboTemp { Writer_Id = writer_id, Combo_Type = COMBO_TYPE, Parent_Id = oldProductId.ToString() });
queryReust = null;
}
}
if (queryReust == null)//插入
{
if (price_type == "1")
{
_pMasterTempMgr.Save(pMasterListT, null, null);
}
else
{
_pMasterTempMgr.Save(pMasterListT, ItemPList, null);
}
}
else//更新
{
if (price_type == "1")
{
_pMasterTempMgr.Update(pMasterListT, null);
}
else
{
_pMasterTempMgr.Update(pMasterListT, update);
}
}
_productTempMgr.PriceBonusInfoSave(pTemp);
}
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.Product.SAVE_FAIL + "'}";
}
#endregion
}
return json;
}
public string QueryMail(string code)
{
_userMgr = new UsersMgr(connectionString);
BLL.gigade.Model.Users user = _userMgr.Query(new BLL.gigade.Model.Users { user_id = ulong.Parse(code) }).FirstOrDefault();
if (user != null)
{
return user.user_email;
}
return code;
}
public HttpResponseBase SaveItemPrice()
{
string json = string.Empty;
string msg = string.Empty;
try
{
if (!PriceMaster.CheckProdName(Request.Form["product_name"]))
{
json = "{success:false,msg:'" + Resources.Product.FORBIDDEN_CHARACTER + "'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
JavaScriptSerializer jsSer = new JavaScriptSerializer();
string items = Request.Form["Items"];
float default_bonus_percent = 0;
float.TryParse(Request.Form["default_bonus_percent"] ?? "1", out default_bonus_percent);
float bonus_percent = 0;
float.TryParse(Request.Form["bonus_percent"] ?? "1", out bonus_percent);
int same_price = (Request.Form["same_price"] ?? "") == "on" ? 1 : 0;
int accumulated_bonus = (Request.Form["accumulated_bonus"] ?? "") == "on" ? 1 : 0;
string start = Request.Form["event_product_start"] ?? Request.Form["event_start"];
string end = Request.Form["event_product_end"] ?? Request.Form["event_end"];
string bonus_start = Request.Form["bonus_percent_start"];
string bonus_end = Request.Form["bonus_percent_end"];
string valid_start = Request.Form["valid_start"];
string valid_end = Request.Form["valid_end"];
if (!string.IsNullOrEmpty(Request.Form["ProductId"]) && !string.IsNullOrEmpty(Request.Form["site_name"]))
{
#region price_master,item_price 新增站台价格
List<ItemPrice> itemPrices = jsSer.Deserialize<List<ItemPrice>>(items);
PriceMaster priceMaster = new PriceMaster { bonus_percent = bonus_percent, default_bonus_percent = default_bonus_percent };
if (!string.IsNullOrEmpty(start))
{
priceMaster.event_start = Convert.ToUInt32(CommonFunction.GetPHPTime(start));
}
if (!string.IsNullOrEmpty(end))
{
priceMaster.event_end = Convert.ToUInt32(CommonFunction.GetPHPTime(end));
}
priceMaster.product_name = PriceMaster.Product_Name_FM(Request.Form["product_name"]);
priceMaster.site_id = uint.Parse(Request.Form["site_name"]);
priceMaster.product_id = uint.Parse(Request.Form["ProductId"]);
priceMaster.user_level = uint.Parse(Request.Form["user_level"] ?? "1");
priceMaster.same_price = same_price;
priceMaster.accumulated_bonus = Convert.ToUInt32(accumulated_bonus);
priceMaster.price_status = 2;//申請審核
priceMaster.price = Convert.ToInt32(itemPrices.Min(m => m.item_money));
priceMaster.event_price = Convert.ToInt32(itemPrices.Min(m => m.event_money));
priceMaster.cost = Convert.ToInt32(itemPrices.Min(m => m.item_cost));
priceMaster.event_cost = Convert.ToInt32(itemPrices.Min(m => m.event_cost));
if (same_price == 0)
{
priceMaster.max_price = Convert.ToInt32(itemPrices.Max(m => m.item_money));
priceMaster.max_event_price = Convert.ToInt32(itemPrices.Max(m => m.event_money));
}
if (!string.IsNullOrEmpty(bonus_start))
{
priceMaster.bonus_percent_start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_start));
}
if (!string.IsNullOrEmpty(bonus_start))
{
priceMaster.bonus_percent_end = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_end));
}
if (!string.IsNullOrEmpty(valid_start))
{
priceMaster.valid_start = Convert.ToInt32(CommonFunction.GetPHPTime(valid_start));
}
if (!string.IsNullOrEmpty(valid_end))
{
priceMaster.valid_end = Convert.ToInt32(CommonFunction.GetPHPTime(valid_end));
}
_usersMgr = new UsersMgr(connectionString);
System.Data.DataTable dt_User = _usersMgr.Query(Request.Form["user_id"] ?? "");
if (dt_User != null && dt_User.Rows.Count > 0)
{
priceMaster.user_id = Convert.ToUInt32(dt_User.Rows[0]["user_id"]);
}
Resource.CoreMessage = new CoreResource("Product");
_priceMasterMgr = new PriceMasterMgr(connectionString);
_priceMasterTsMgr = new PriceMasterTsMgr("");
int priceMasterId = _priceMasterMgr.Save(priceMaster, itemPrices, null, ref msg);
if (priceMasterId != -1)
{
//價格修改 申請審核
PriceUpdateApply priceUpdateApply = new PriceUpdateApply { price_master_id = Convert.ToUInt32(priceMasterId) };
priceUpdateApply.apply_user = Convert.ToUInt32((Session["caller"] as Caller).user_id);
//價格審核記錄
PriceUpdateApplyHistory applyHistroy = new PriceUpdateApplyHistory();
applyHistroy.user_id = Convert.ToInt32(priceUpdateApply.apply_user);
//applyHistroy.price_status = 1;
//applyHistroy.type = 3;
applyHistroy.price_status = 1; //edit by wwei0216w 2014/12/16 價格修改時 price_status為 2申請審核
applyHistroy.type = 1;//edit by wwei0216w 所作操作為 1:申請審核的操作
_priceUpdateApplyMgr = new PriceUpdateApplyMgr(connectionString);
_priceUpdateApplyHistoryMgr = new PriceUpdateApplyHistoryMgr(connectionString);
int apply_id = _priceUpdateApplyMgr.Save(priceUpdateApply);
if (apply_id != -1)
{
priceMaster = _priceMasterMgr.Query(new PriceMaster { price_master_id = Convert.ToUInt32(priceMasterId) }).FirstOrDefault();
priceMaster.apply_id = Convert.ToUInt32(apply_id);
applyHistroy.apply_id = apply_id;
ArrayList excuteSql = new ArrayList();
excuteSql.Add(_priceMasterMgr.Update(priceMaster));
excuteSql.Add(_priceMasterTsMgr.UpdateTs(priceMaster));//edit by xiangwang0413w 2014/07/22 更新price_master_ts表後用時更新price_master_ts表，以便價格審核
excuteSql.Add(_priceUpdateApplyHistoryMgr.SaveSql(applyHistroy));
_functionMgr = new FunctionMgr(connectionString);
string function = Request.Params["function"] ?? "";
Function fun = _functionMgr.QueryFunction(function, "/Product/ProductSave");
int functionid = fun == null ? 0 : fun.RowId;
HistoryBatch batch = new HistoryBatch { functionid = functionid };
batch.batchno = Request.Params["batch"] ?? "";
batch.kuser = (Session["caller"] as Caller).user_email;
_tableHistoryMgr = new TableHistoryMgr(connectionString);
if (_tableHistoryMgr.SaveHistory<PriceMaster>(priceMaster, batch, excuteSql))
{
json = "{success:true}";
}
else
{
json = "{success:false,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
}
else
{
json = "{success:false,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
}
else
{
json = "{success:false,msg:'" + msg + "'}";
}
#endregion
}
else
{
#region product_item_temp 修改临时表数据
ProductTemp proTemp = new ProductTemp { Bonus_Percent = bonus_percent, Default_Bonus_Percent = default_bonus_percent };
List<ProductItemTemp> proItemTemps = jsSer.Deserialize<List<ProductItemTemp>>(items);
if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
{
proTemp.Product_Id = Request.Form["OldProductId"];
proItemTemps.ForEach(m => m.Product_Id = proTemp.Product_Id);
}
if (!string.IsNullOrEmpty(start))
{
proTemp.Bonus_Percent_Start = Convert.ToUInt32(CommonFunction.GetPHPTime(start));
proItemTemps.ForEach(m => m.Event_Product_Start = proTemp.Bonus_Percent_Start);
}
if (!string.IsNullOrEmpty(end))
{
proTemp.Bonus_Percent_End = Convert.ToUInt32(CommonFunction.GetPHPTime(end));
proItemTemps.ForEach(m => m.Event_Product_End = proTemp.Bonus_Percent_End);
}
if (!string.IsNullOrEmpty(Request.Form["product_price_list"]))
{
uint product_price_list = 0;
uint.TryParse(Request.Form["product_price_list"] ?? "0", out product_price_list);
proTemp.Product_Price_List = product_price_list;
}
if (!string.IsNullOrEmpty(Request.Form["bag_check_money"]))
{
proTemp.Bag_Check_Money = uint.Parse(Request.Form["bag_check_money"]);
}
proTemp.show_listprice = Convert.ToUInt32((Request.Form["show_listprice"] ?? "") == "on" ? 1 : 0);
proTemp.Writer_Id = (Session["caller"] as Caller).user_id;
proTemp.Combo_Type = COMBO_TYPE;
proItemTemps.ForEach(m => m.Writer_Id = proTemp.Writer_Id);
_productTempMgr = new ProductTempMgr(connectionString);
#region PriceMasterTemp
PriceMasterTemp priceMasterTemp = new PriceMasterTemp { price_status = 1, default_bonus_percent = default_bonus_percent, bonus_percent = bonus_percent, same_price = same_price };
priceMasterTemp.accumulated_bonus = Convert.ToUInt32(accumulated_bonus);
priceMasterTemp.product_id = proTemp.Product_Id;
priceMasterTemp.combo_type = COMBO_TYPE;
priceMasterTemp.product_name = PriceMaster.Product_Name_FM(Request.Form["product_name"] ?? "");
priceMasterTemp.writer_Id = proTemp.Writer_Id;
priceMasterTemp.site_id = 1;//默認站臺1:吉甲地
priceMasterTemp.user_level = 1;
priceMasterTemp.price = Convert.ToInt32(proItemTemps.Min(m => m.Item_Money));
priceMasterTemp.event_price = Convert.ToInt32(proItemTemps.Min(m => m.Event_Item_Money));
priceMasterTemp.cost = Convert.ToInt32(proItemTemps.Min(m => m.Item_Cost));
priceMasterTemp.event_cost = Convert.ToInt32(proItemTemps.Min(m => m.Event_Item_Cost));
if (same_price == 0)
{
priceMasterTemp.max_price = Convert.ToInt32(proItemTemps.Max(m => m.Item_Money));
priceMasterTemp.max_event_price = Convert.ToInt32(proItemTemps.Max(m => m.Event_Item_Money));
}
if (!string.IsNullOrEmpty(bonus_start))
{
priceMasterTemp.bonus_percent_start = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_start));
}
if (!string.IsNullOrEmpty(bonus_start))
{
priceMasterTemp.bonus_percent_end = Convert.ToUInt32(CommonFunction.GetPHPTime(bonus_end));
}
if (!string.IsNullOrEmpty(start))
{
priceMasterTemp.event_start = Convert.ToUInt32(CommonFunction.GetPHPTime(start));
}
if (!string.IsNullOrEmpty(end))
{
priceMasterTemp.event_end = Convert.ToUInt32(CommonFunction.GetPHPTime(end));
}
if (!string.IsNullOrEmpty(valid_start))
{
priceMasterTemp.valid_start = Convert.ToInt32(CommonFunction.GetPHPTime(valid_start));
}
if (!string.IsNullOrEmpty(valid_end))
{
priceMasterTemp.valid_end = Convert.ToInt32(CommonFunction.GetPHPTime(valid_end));
}
#endregion
_productItemTempMgr = new ProductItemTempMgr(connectionString);
_priceMasterTempMgr = new PriceMasterTempMgr(connectionString);
if (_productItemTempMgr.UpdateCostMoney(proItemTemps) && _productTempMgr.PriceBonusInfoSave(proTemp) > 0)
{
bool result = false;
PriceMasterTemp query = new PriceMasterTemp { writer_Id = priceMasterTemp.writer_Id, product_id = proTemp.Product_Id, combo_type = COMBO_TYPE };
if (_priceMasterTempMgr.Query(query) == null)//插入
{
result = _priceMasterTempMgr.Save(new List<PriceMasterTemp> { priceMasterTemp }, null, null);
}
else//更新
{
result = _priceMasterTempMgr.Update(new List<PriceMasterTemp> { priceMasterTemp }, null);
}
json = "{success:" + result.ToString().ToLower() + "}";
}
else
{
json = "{success:false}";
}
#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,msg:'" + Resources.Product.SAVE_FAIL + "'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetVipList()
{
/********************************************************/
List<UserVipListQuery> stores = new List<UserVipListQuery>();
string json = string.Empty;
try
{
UserVipListQuery query = new UserVipListQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Params["dateOne"]))
{
query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["dateTwo"]))
{
query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["user_id"]))
{
query.user_id = uint.Parse(Request.Params["user_id"]);
}
usersMgr = new UsersMgr(mySqlConnectionString);
int totalCount = 0;
stores = usersMgr.GetVipList(query, ref totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
// timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
DataTable _dt = new DataTable();
foreach (var item in stores)
{
if (!string.IsNullOrEmpty(item.user_name))
{
item.user_name = item.user_name.Substring(0, 1) + "**";
}
//item.sum_bonus = item.normal_deduct_bonus + item.low_deduct_bonus;
//item.sum_amount = item.normal_product + item.low_product;
//獲取客單價的上限
decimal s = item.sum_amount / item.cou;
int sint = Convert.ToInt32(s);
item.aver_amount = s > sint ? sint + 1 : sint;
//獲取時間
item.reg_date = CommonFunction.GetNetTime(item.user_reg_date);
item.create_date = CommonFunction.GetNetTime(item.order_createdate);
item.birthday = item.user_birthday_year.ToString() + "/" + item.user_birthday_month.ToString() + "/" + item.user_birthday_day.ToString();
item.mytype = item.user_type == 1 ? "網絡會員" : "電話會員";
item.vip = "N";
_dt = usersMgr.IsVipUserId(item.user_id);
if (_dt.Rows.Count != 0)
{
item.vip = "Y";
}
}
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase ExportVipListCsv()
{
string json = string.Empty;
UserVipListQuery query = new UserVipListQuery();
List<UserVipListQuery> stores = new List<UserVipListQuery>();
try
{
if (!string.IsNullOrEmpty(Request.Params["dateOne"]))
{
query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["dateTwo"]))
{
query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["user_id"]))
{
query.user_id = uint.Parse(Request.Params["user_id"]);
}
int totalCount = 0;
query.IsPage = false;
zMgr = new ZipMgr(mySqlConnectionString);
usersMgr = new UsersMgr(mySqlConnectionString);
stores = usersMgr.ExportVipListCsv(query, ref totalCount);
DataTable _vipdt = usersMgr.IsVipUserId(0);
DataTable newDt = new DataTable();
newDt.Columns.Add("user_id", typeof(string));
newDt.Columns.Add("user_status", typeof(string));
newDt.Columns.Add("user_name", typeof(string));
newDt.Columns.Add("user_gender", typeof(string));
newDt.Columns.Add("VIP", typeof(string));
// newDt.Columns.Add("user_email", typeof(string));
newDt.Columns.Add("age", typeof(string));
newDt.Columns.Add("user_birthday_month", typeof(string));
// newDt.Columns.Add("user_address", typeof(string));
newDt.Columns.Add("user_reg_date", typeof(string));//需要轉
newDt.Columns.Add("order_createdate", typeof(string));//需要轉
newDt.Columns.Add("last_time", typeof(string));//需要轉
newDt.Columns.Add("sum_amount", typeof(string));
newDt.Columns.Add("cou", typeof(string));
newDt.Columns.Add("aver_amount", typeof(string));//計算得出
newDt.Columns.Add("sum_bonus", typeof(string));
newDt.Columns.Add("normal_product", typeof(string));
newDt.Columns.Add("freight_normal", typeof(string));
newDt.Columns.Add("low_product", typeof(string));
newDt.Columns.Add("freight_low", typeof(string));
newDt.Columns.Add("ct", typeof(string));
newDt.Columns.Add("HG", typeof(string));
newDt.Columns.Add("ht", typeof(string));
newDt.Columns.Add("ml_code", typeof(string));
//newDt.Columns.Add("order_product_subtotal", typeof(string));
for (int i = 0; i < stores.Count; i++)
{
DataRow newRow = newDt.NewRow();
newRow["user_id"] = stores[i].user_id;
//newRow["user_status"] = stores[i].user_status;
switch (stores[i].user_status)
{
case 0: newRow["user_status"] = "未啟用";
break;
case 1: newRow["user_status"] = "已啟用";
break;
case 2: newRow["user_status"] = "停用";
break;
case 5: newRow["user_status"] = "簡易會員";
break;
}
newRow["user_name"] = stores[i].user_name;
newRow["user_gender"] = stores[i].user_gender == 0 ? "小姐" : "先生";
newRow["VIP"] = "N";
for (int j = 0; j < _vipdt.Rows.Count; j++)
{
if (_vipdt.Rows[j]["user_id"] != null)
{
if (stores[i].user_id.ToString() == _vipdt.Rows[j]["user_id"].ToString())
{
newRow["VIP"] = "Y";
break;
}
}
}
//newRow["user_email"] = stores[i].user_email;
newRow["age"] = DateTime.Now.Year - stores[i].user_birthday_year;
newRow["user_birthday_month"] = stores[i].user_birthday_month;
//if (zMgr.QueryCityAndZip(stores[i].user_zip.ToString()) != null)
//{
// newRow["user_address"] = zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).middle + " " + zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).small;
//}
//else
//{
// newRow["user_address"] = "";
//}
newRow["user_reg_date"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].user_reg_date));
newRow["order_createdate"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].order_createdate));
newRow["last_time"] = newRow["order_createdate"];
//if (stores[i].last_time == Convert.ToUInt32(CommonFunction.GetPHPTime("1970-1-1 8:00")))
//{
// newRow["last_time"] = "";
//}
//else
//{
// newRow["last_time"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].last_time));
//}
newRow["sum_amount"] = stores[i].sum_amount;
newRow["cou"] = stores[i].cou;
decimal s = stores[i].sum_amount / stores[i].cou;
int sint = Convert.ToInt32(s);
newRow["aver_amount"] = s > sint ? sint + 1 : sint;
newRow["sum_bonus"] = stores[i].sum_bonus;
newRow["normal_product"] = stores[i].normal_product;
newRow["freight_normal"] = stores[i].freight_normal;
newRow["low_product"] = stores[i].low_product;
newRow["freight_low"] = stores[i].freight_low;
newRow["ct"] = stores[i].ct;
newRow["HG"] = stores[i].ct;
newRow["ht"] = stores[i].ht;
newRow["ml_code"] = stores[i].ml_code;
//newRow["order_product_subtotal"] = stores[i].order_product_subtotal;
newDt.Rows.Add(newRow);
}
// string[] columnName = { "編號", "會員狀態", "姓名", "性別", "VIP", "電子郵件", "年齡", "生日月份", "居住區", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵" };
string[] columnName = { "會員編號", "會員狀態", "姓名", "性別", "VIP", "年齡", "生日月份", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵", "會員等級" };//, "近期累積金額" };
string fileName = "Vip_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
string newFileName = Server.MapPath(excelPath) + fileName;
json = "{success:'true',filename:'" + fileName + "'}";
CsvHelper.ExportDataTableToCsv(newDt, newFileName, columnName, true);
}
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 SavePhone()
{
string jsonStr = string.Empty;
UserQuery user = new UserQuery();
HashEncrypt hmd5 = new HashEncrypt();
try
{
if (!string.IsNullOrEmpty(Request.Params["name"]))
{
user.user_name = Request.Params["name"].ToString();
}
else
{
user.user_name = "";
}
if (!string.IsNullOrEmpty(Request.Params["tel"]))
{
if (!CommonFunction.isMobile(Request.Params["tel"].ToString()))
{
jsonStr = "{success:false,msg:0}";
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
else
{
//user.user_mobile = EncryptComputer.EncryptDecryptTextByApi(Request.Params["tel"].ToString());
user.user_mobile = Request.Params["tel"].ToString();
}
//if (user.user_mobile.Length < 10 || user.user_mobile.Substring(0, 2).ToString() != "09")
//{
// for (int i = user.user_mobile.Length; i < 10; i++)
// {
// user.user_mobile = "0" + user.user_mobile;
// }
//}
}
else
{
user.user_mobile = "";
}
user.user_email = Request.Params["tel"] + "@user.gigade.com.tw";
#region 獲取生日的年月日
try
{
DateTime birth = Convert.ToDateTime(Request.Params["birth"].ToString());
user.user_birthday_year = Convert.ToUInt32(birth.Year);
user.user_birthday_month = Convert.ToUInt32(birth.Month);
user.user_birthday_day = Convert.ToUInt32(birth.Day);
}
catch (Exception)
{
user.user_birthday_year = 1970;
user.user_birthday_month = 0;
user.user_birthday_day = 0;
}
#endregion
#region 密碼
user.user_password = "******" + user.user_birthday_year;
if (user.user_birthday_month.ToString().Length == 1)
{
user.user_password += "0" + user.user_birthday_month;
}
else
{
user.user_password += user.user_birthday_month;
}
if (user.user_birthday_day.ToString().Length == 1)
{
user.user_password += "0" + user.user_birthday_day;
}
else
{
user.user_password += user.user_birthday_day;
}
user.user_password = hmd5.SHA256Encrypt(user.user_password);
#endregion
if (!string.IsNullOrEmpty(Request.Params["zip"]))
{
user.user_zip = Convert.ToUInt32(Request.Params["zip"].ToString());
}
else
{
user.user_zip = 0;
}
if (!string.IsNullOrEmpty(Request.Params["address"]))
{
user.user_address = Request.Params["address"].ToString();
}
else
{
user.user_address = "";
}
if (!string.IsNullOrEmpty(Request.Params["IsAcceptAd"]))
{
if (Request.Params["IsAcceptAd"].ToString() == "on")
{
user.send_sms_ad = true;
}
}
else
{
user.send_sms_ad = false;
}
if (!string.IsNullOrEmpty(Request.Params["Remark"]))
{
user.adm_note = Request.Params["Remark"].ToString();
}
else
{
user.adm_note = "";
}
user.ip = Request.UserHostAddress;
user.file_name = "UserPhone.chtml";
user.created = DateTime.Now;
user.kuser_id = Convert.ToUInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
mgr = new CallerMgr(mySqlConnectionString);
Caller caller = new Caller();
caller = mgr.GetUserById(Convert.ToInt32(user.kuser_id));
user.kuser_name = caller.user_username;
user.content = "user_email:" + user.user_email + ",user_mobile:" + user.user_mobile + ",user_birthday_year" + user.user_birthday_year + ",user_birthday_month" + user.user_birthday_month + ",user_birthday_day" + user.user_birthday_day + ",user_zip" + user.user_zip + ",user_address" + user.user_address + ",send_sms_ad" + user.send_sms_ad + ",adm_note" + user.adm_note;
user.user_status = 1;
user.user_source = "電話會員";
user.user_login_attempts = 0;
user.user_reg_date = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
user.user_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
user.user_type = 2;
_usmpgr = new UsersMgr(mySqlConnectionString);//實現方法
if (_usmpgr.QueryByUserMobile(user.user_mobile).Rows.Count == 0)
{
_usmpgr = new UsersMgr(mySqlConnectionString);
if (_usmpgr.SaveUserPhone(user) > 0)
{
jsonStr = "{success:true,msg:1}";
}
else
{
jsonStr = "{success:false,msg:2 }";
}
}
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,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public HttpResponseBase ExportCsv()
{
string filename = string.Empty;
string json = "{success:false}";//json字符串
userioMgr = new UserIOMgr(mySqlConnectionString);
usersMgr = new UsersMgr(mySqlConnectionString);
siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath));
try
{
if (Request.Files["ImportCsvFile"] != null && Request.Files["ImportCsvFile"].ContentLength > 0)//判斷文件是否為空
{
HttpPostedFileBase excelFile = Request.Files["ImportCsvFile"];//獲取文件流
FileManagement fileManagement = new FileManagement();//實例化 FileManagement
string fileLastName = excelFile.FileName.Substring((excelFile.FileName).LastIndexOf('.')).ToLower().Trim();
if (fileLastName.Equals(".csv"))
{
string newExcelName = Server.MapPath(excelPath) + "user_io" + fileManagement.NewFileName(excelFile.FileName);//處理文件名，獲取新的文件名
System.Data.DataTable _dt = new DataTable();
excelFile.SaveAs(newExcelName);//上傳文件
//excelHelper = new NPOI4ExcelHelper(newExcelName);
_dt = CsvHelper.ReadCsvToDataTable(newExcelName, true);//獲取csv里的數據
Regex num = new System.Text.RegularExpressions.Regex("^[0-9]+$");
string sqlAdition = "";
for (int i = 0; i < _dt.Rows.Count; i++)
{
if (_dt.Rows[i][0].ToString() != "")
{
if (!num.IsMatch(_dt.Rows[i][0].ToString()))//判斷是否匹配正則表達式
{
System.IO.File.Delete(newExcelName);//刪除上傳過的excle
int rows = i + 2;
int cloumns = 1;
json = "{success:false,msg:\"" + "第" + rows + "條第" + cloumns + "列數據錯誤" + "\"}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
else
{
if (i == 0)
{
sqlAdition = _dt.Rows[i][0].ToString();
}
else
{
sqlAdition += "," + Convert.ToUInt32(_dt.Rows[i][0].ToString());//獲取id，以，隔開id
}
}
}
}
DataTable dtexcel = userioMgr.GetExcelTable(sqlAdition);//從數據庫里獲取csv里的id的數據
#region 讀取會員資料
json = string.Empty;
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
try
{
string[] colname = new string[dtexcel.Columns.Count];
filename = "user_io" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".csv";
string newExcelfilename = Server.MapPath(excelPath) + filename;
for (int i = 0; i < dtexcel.Columns.Count; i++)
{
colname[i] = dtexcel.Columns[i].ColumnName;
}
if (System.IO.File.Exists(newExcelfilename))
{
System.IO.File.Delete(newExcelfilename);
}
excelFile.SaveAs(newExcelfilename);//上傳文件
CsvHelper.ExportDataTableToCsv(dtexcel, newExcelfilename, colname, true);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "true";
}
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 = "false,";
}
#endregion
#region ///更改前的內容
//string[] colname = new string[dtexcel.Columns.Count];//定義一個數組
//for (int i = 0; i < dtexcel.Columns.Count; i++)
//{
// colname[i] = dtexcel.Columns[i].ColumnName;//獲取列名
//}
//CsvHelper.ExportDataTableToCsv(dtexcel, newExcelName, colname, true);
////打開導出的Excel 文件
//System.Diagnostics.Process Excelopen = new System.Diagnostics.Process();
//Excelopen.StartInfo.FileName = newExcelName;
//Excelopen.Start();
#endregion
json = "{success:true,msg:\"" + filename + "\"}";
}
else
{
json = "{success:false,msg:\"" + "請匯入CSV格式檔案" + "\"}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 通過郵箱獲取該用戶的信息
/// </summary>
/// <returns></returns>
public HttpResponseBase GetUserName()
{
UserQuery user = new UserQuery();
List<UserQuery> userList = new List<UserQuery>();
string user_email = "";
uint group_id = 0;
if (!string.IsNullOrEmpty(Request.Params["Email"]))
{
user_email = Request.Params["Email"];
}
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
group_id = uint.Parse(Request.Params["group_id"]);
}
_usmpgr = new UsersMgr(mySqlConnectionString);
string jsonStr = string.Empty;
try
{
userList = _usmpgr.GetUserByEmail(user_email, group_id);
if (userList.Count() > 0)//查詢到會員
{
jsonStr = "{success:true,msg:\"" + 99 + "\"}";//該用戶已在此群組中
}
else
{
userList = _usmpgr.GetUserByEmail(user_email, 0);
if (userList.Count() > 0)
{
jsonStr = "{success:true,msg:\"" + 100 + "\",user_id:'" + userList[0].user_id + "',user_name:'" + userList[0].user_name + "'}";//返回json數據
}
else
{
jsonStr = "{success:true,msg:\"" + 98 + "\"}";//此用戶不存在
}
}
}
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 GetUserName()
{
Users user = new Users();
if (!string.IsNullOrEmpty(Request.Params["user_id"]))
{
user.user_id = ulong.Parse(Request.Params["user_id"]);
}
_usersMgr = new UsersMgr(mySqlConnectionString);
string jsonStr =string.Empty;
try
{
List<Users> userList = new List<Users>();
userList = _usersMgr.GetUser(user);
if (userList.Count > 0)
{
jsonStr = "{success:true,msg:\"" + userList[0].user_name + "\"}";
}
else
{
jsonStr = "{success:true,msg:\"" +100+ "\"}";
}
}
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 GetUserName()
{
List<Users> store = new List<Users>();
string json = "{success:true,msg:'0'}";
try
{
Users query = new Users();
_uMgr = new UsersMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.user_id = Convert.ToUInt32(Request.Params["id"]);
}
if (query.user_id > 0)
{
store = _uMgr.GetUser(query);
foreach (var item in store)
{
json = "{success:true,msg:'" + item.user_name + "'}";//返回json數據
}
}
else
{
json = "{success:true,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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
