public HttpResponseBase specTempSave()
{
string resultStr = "{success:true}";
bool result = true;
try
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerID = (int)vendorModel.vendor_id;
string specType = Request.Params["specType"];
string spec1Name = Request.Params["spec1Name"];
string spec1Result = Request.Params["spec1Result"];
string spec2Name = Request.Params["spec2Name"];
string spec2Result = Request.Params["spec2Result"];
_specTempMgr = new ProductSpecTempMgr(connectionString);
_productTempMgr = new ProductTempMgr(connectionString);
_productItemTempMgr = new ProductItemTempMgr(connectionString);
_serialMgr = new SerialMgr(connectionString);
#region 臨時表修改
string proId = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["ProductId"]))
{
proId = Request.Params["ProductId"].ToString();
}
if (!string.IsNullOrEmpty(proId))
{
if (!specType.Equals("0") && !string.IsNullOrEmpty(specType))
{
#region 有規格
List<ProductSpecTemp> spec1List;
List<ProductSpecTemp> spec2List;
List<ProductSpecTemp> specAllList = new List<ProductSpecTemp>();
JavaScriptSerializer jss = new JavaScriptSerializer();
spec1List = jss.Deserialize<List<ProductSpecTemp>>(spec1Result);
foreach (ProductSpecTemp item in spec1List)
{
item.Writer_Id = writerID;// item.Writer_Id = _caller.user_id;
item.product_id = proId;
item.spec_type = 1;
item.spec_image = "";
specAllList.Add(item);
}
if (specType.Equals("2"))
{
spec2List = jss.Deserialize<List<ProductSpecTemp>>(spec2Result);
foreach (ProductSpecTemp item in spec2List)
{
item.Writer_Id = writerID;// item.Writer_Id = _caller.user_id;
item.product_id = proId;
item.spec_type = 2;
item.spec_image = "";
specAllList.Add(item);
}
}
List<ProductSpecTemp> tempList = _specTempMgr.VendorQuery(new ProductSpecTemp { Writer_Id = writerID, product_id = proId });
if (tempList == null || tempList.Count() <= 0)
{
#region 保存
specAllList.ForEach(p => p.spec_id = uint.Parse(_serialMgr.NextSerial(18).ToString()));
bool saveSpecResult = _specTempMgr.SaveByVendor(specAllList);
if (saveSpecResult)
{
_productItemTempMgr.DeleteByVendor(new ProductItemTemp { Writer_Id = writerID, Product_Id = proId });
#region 保存ProductItemTemp
List<ProductSpecTemp> specAllResultList = _specTempMgr.VendorQuery(new ProductSpecTemp { Writer_Id = writerID, product_id = proId });
List<ProductSpecTemp> spec1ResultList = specAllResultList.Where(m => m.spec_type == 1).ToList();
List<ProductSpecTemp> spec2ResultList = specAllResultList.Where(m => m.spec_type == 2).ToList();
List<ProductItemTemp> saveItemList = new List<ProductItemTemp>();
if (specType.Equals("1"))
{
foreach (ProductSpecTemp specTemp1 in spec1ResultList)
{
ProductItemTemp itemTemp = new ProductItemTemp();
itemTemp.Writer_Id = writerID;
itemTemp.Product_Id = proId;
itemTemp.Spec_Id_1 = specTemp1.spec_id;
itemTemp.Item_Stock = 10;
itemTemp.Item_Alarm = 1;
saveItemList.Add(itemTemp);
}
}
else if (specType.Equals("2"))
{
foreach (ProductSpecTemp specTemp1 in spec1ResultList)
{
foreach (ProductSpecTemp specTemp2 in spec2ResultList)
{
ProductItemTemp itemTemp = new ProductItemTemp();
itemTemp.Writer_Id = writerID;
itemTemp.Product_Id = proId;
itemTemp.Spec_Id_1 = specTemp1.spec_id;
itemTemp.Spec_Id_2 = specTemp2.spec_id;
itemTemp.Item_Stock = 10;
itemTemp.Item_Alarm = 1;
itemTemp.Item_Code = "";
itemTemp.Barcode = "";
saveItemList.Add(itemTemp);
}
}
}
bool saveItemResult = _productItemTempMgr.SaveByVendor(saveItemList);
if (!saveItemResult)
{
result = false;
}
#endregion
}
else
{
result = false;
}
#endregion
}
else
{
#region 更新
string strSpecInit = Request.Params["specInit"];
string[] specs = strSpecInit.Trim().Split(',');
List<ProductSpecTemp> addList = specAllList.Where(p => p.spec_id == 0).ToList();
if (addList.Count() > 0)
{
addList.ForEach(p => p.spec_id = uint.Parse(_serialMgr.NextSerial(18).ToString()));
List<ProductSpecTemp> specAllResultList = _specTempMgr.VendorQuery(new ProductSpecTemp { Writer_Id = writerID, product_id = proId });
List<ProductSpecTemp> spec1ResultList = specAllResultList.Where(m => m.spec_type == 1).ToList();
List<ProductSpecTemp> spec2ResultList = specAllResultList.Where(m => m.spec_type == 2).ToList();
List<ProductItemTemp> saveItemList = new List<ProductItemTemp>();
foreach (ProductSpecTemp item in addList)
{
if (specType.Equals("1"))
{
if (item.spec_type == 1)
{
ProductItemTemp saveTemp = new ProductItemTemp();
saveTemp.Writer_Id = writerID;
saveTemp.Spec_Id_1 = item.spec_id;
saveTemp.Product_Id = proId;
saveTemp.Item_Stock = 10;
saveTemp.Item_Alarm = 1;
saveItemList.Add(saveTemp);
}
else
{
ProductItemTemp saveTemp = new ProductItemTemp();
saveTemp.Writer_Id = writerID;
saveTemp.Spec_Id_2 = item.spec_id;
saveTemp.Product_Id = proId;
saveTemp.Item_Stock = 10;
saveTemp.Item_Alarm = 1;
saveItemList.Add(saveTemp);
}
}
else
{
if (item.spec_type == 1)
{
foreach (ProductSpecTemp item1 in spec2ResultList)
{
ProductItemTemp saveTemp = new ProductItemTemp();
saveTemp.Writer_Id = writerID;
saveTemp.Spec_Id_1 = item.spec_id;
saveTemp.Spec_Id_2 = item1.spec_id;
saveTemp.Item_Stock = 10;
saveTemp.Item_Alarm = 1;
saveTemp.Product_Id = proId;
saveItemList.Add(saveTemp);
}
foreach (ProductSpecTemp item1 in addList.Where(p => p.spec_type == 2).ToList())
{
ProductItemTemp saveTemp = new ProductItemTemp();
saveTemp.Writer_Id = writerID;
saveTemp.Spec_Id_1 = item.spec_id;
saveTemp.Spec_Id_2 = item1.spec_id;
saveTemp.Item_Stock = 10;
saveTemp.Item_Alarm = 1;
saveTemp.Product_Id = proId;
saveItemList.Add(saveTemp);
}
}
else
{
foreach (ProductSpecTemp item2 in spec1ResultList)
{
ProductItemTemp saveTemp = new ProductItemTemp();
saveTemp.Writer_Id = writerID;
saveTemp.Spec_Id_1 = item2.spec_id;
saveTemp.Spec_Id_2 = item.spec_id;
saveTemp.Product_Id = proId;
saveTemp.Item_Stock = 10;
saveTemp.Item_Alarm = 1;
saveItemList.Add(saveTemp);
}
}
}
}
_specTempMgr.SaveByVendor(addList);
_productItemTempMgr.SaveByVendor(saveItemList);
}
if (specs.Length > 0 && !string.IsNullOrEmpty(strSpecInit.Trim()))
{
List<ProductSpecTemp> updateList = new List<ProductSpecTemp>();
foreach (string initSpecId in specs)
{
ProductSpecTemp nowItem = specAllList.Where(p => p.spec_id == uint.Parse(initSpecId)).FirstOrDefault();
if (nowItem != null)
{
updateList.Add(nowItem);
}
else
{
ProductItemTemp delTemp = new ProductItemTemp { Writer_Id = writerID, Product_Id = proId };
uint spectype = _specTempMgr.VendorQuery(new ProductSpecTemp { spec_id = uint.Parse(initSpecId), product_id = proId })[0].spec_type;
if (spectype == 1)
{
delTemp.Spec_Id_1 = uint.Parse(initSpecId);
}
else if (spectype == 2)
{
delTemp.Spec_Id_2 = uint.Parse(initSpecId);
}
if (!_productItemTempMgr.DeleteByVendor(delTemp))
{
result = false;
}
if (!_specTempMgr.DeleteByVendor(new ProductSpecTemp { spec_id = uint.Parse(initSpecId), Writer_Id = writerID, product_id = proId }))
{
result = false;
}
DeletePicOnServer(false, true, false, uint.Parse(initSpecId), Convert.ToString(proId));
}
}
if (!_specTempMgr.Update(updateList, "spec"))
{
result = false;
}
}
#endregion
}
#region 更新ProductTemp
ProductTemp proTemp = new ProductTemp();
proTemp.Writer_Id = writerID;
proTemp.Product_Spec = uint.Parse(specType);
proTemp.Spec_Title_1 = spec1Name;
proTemp.Spec_Title_2 = spec2Name;
proTemp.Combo_Type = COMBO_TYPE;
proTemp.Product_Id = proId;
bool saveProductResult = _productTempMgr.vendorSpecInfoSave(proTemp) > 0 ? true : false;
if (!saveProductResult)
{
result = false;
}
#endregion
#endregion
}
else
{
#region 無規格
ProductTemp query = _productTempMgr.GetVendorProTemp(new ProductTemp { Writer_Id = writerID, Combo_Type = COMBO_TYPE, Product_Id = proId });
//如果原數據有規格
if (query.Product_Spec != 0)
{
//刪除服務器上對應的圖片
DeletePicOnServer(false, true, false, 0, proId);
_productItemTempMgr.DeleteByVendor(new ProductItemTemp { Writer_Id = writerID, Product_Id = proId });
_specTempMgr.DeleteByVendor(new ProductSpecTemp { Writer_Id = writerID, product_id = proId });
_productTempMgr.vendorSpecInfoSave(new ProductTemp { Product_Spec = 0, Spec_Title_1 = "", Spec_Title_2 = "", Writer_Id = writerID, Combo_Type = COMBO_TYPE, Product_Id = proId });
List<ProductItemTemp> saveList = new List<ProductItemTemp>();
saveList.Add(new ProductItemTemp { Writer_Id = writerID, Product_Id = proId, Item_Stock = 10, Item_Alarm = 1 });
_productItemTempMgr.SaveByVendor(saveList);
}
else
{
List<ProductItemTemp> itemQuery = _productItemTempMgr.QueryByVendor(new ProductItemTemp { Writer_Id = writerID, Product_Id = proId });
if (itemQuery.Count() <= 0)
{
List<ProductItemTemp> saveList = new List<ProductItemTemp>();
saveList.Add(new ProductItemTemp { Writer_Id = writerID, Product_Id = proId, Item_Stock = 10, Item_Alarm = 1 });
_productItemTempMgr.SaveByVendor(saveList);
}
}
#endregion
}
}
else
{
result = false;
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", "VendorProductCountroller.cs", "specTempSave()", Resources.VendorProduct.NOTFOUNTKEY);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
resultStr = "{success:false}";
}
#endregion
}
catch (Exception ex)
{
result = false;
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
if (!result)
{
resultStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(resultStr);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetProItems()
{
string json = string.Empty;
uint productID = 0;
try
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerID = (int)vendorModel.vendor_id;
if (!string.IsNullOrEmpty(Request.Form["ProductId"]))
{
if (uint.TryParse(Request.Form["ProductId"].ToString(), out productID))
{//商品列表中正式表商品的詳細資料
//product_item
_productItemMgr = new ProductItemMgr(connectionString);
List<ProductItem> proItem = _productItemMgr.QueryPrice(new ProductItem { Product_Id = Convert.ToUInt32(Request.Form["ProductId"]) });
json = JsonConvert.SerializeObject(proItem);
}
else
{
//product_item
ProductItemTemp query = new ProductItemTemp();
query.Product_Id = Request.Form["ProductId"].ToString();
query.Writer_Id = writerID;
_productItemTempMgr = new ProductItemTempMgr(connectionString);
List<ProductItemTemp> proItemTemp = _productItemTempMgr.QueryByVendor(query);
json = JsonConvert.SerializeObject(proItemTemp);
}
}
}
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;
}
public HttpResponseBase UpdateItemPrice()
{
string json = string.Empty;
try
{
BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"];
int writerID = (int)vendorModel.vendor_id;
JavaScriptSerializer jsSer = new JavaScriptSerializer();
uint priceMasterId = uint.Parse(Request.Form["price_master_id"] ?? "0");
int same_price = (Request.Form["same_price"] ?? "") == "on" ? 1 : 0;
string start = Request.Form["event_start"] ?? "";
string end = Request.Form["event_end"] ?? "";
string valid_start = Request.Form["valid_start"];
string valid_end = Request.Form["valid_end"];
string items = Request.Form["Items"];
List<ItemPrice> newPrices = jsSer.Deserialize<List<ItemPrice>>(items);
_priceMasterTempMgr = new PriceMasterTempMgr(connectionString);
PriceMasterCustom PriceMasterTemp = _priceMasterTempMgr.QueryProdSiteByVendor(new PriceMasterTemp { price_master_id = priceMasterId }).FirstOrDefault();
if (PriceMasterTemp != null)
{
#region 處理PriceMasterTemp
PriceMasterTemp.product_name = Request.Form["product_name"] ?? "";
PriceMasterTemp.same_price = same_price;
PriceMasterTemp.user_level = 1;//会员等级默认为 1：普通会员
PriceMasterTemp.user_id = 0;
PriceMasterTemp.site_id = 1;//默认站台为吉甲地
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));
}
PriceMasterTemp.price = Convert.ToInt32(newPrices.Min(m => m.item_money));
PriceMasterTemp.event_price = Convert.ToInt32(newPrices.Min(m => m.event_money));
if (same_price == 0)
{
PriceMasterTemp.max_price = Convert.ToInt32(newPrices.Max(m => m.item_money));
PriceMasterTemp.max_event_price = Convert.ToInt32(newPrices.Max(m => m.event_money));
}
PriceMasterTemp.cost = Convert.ToInt32(newPrices.Min(m => m.item_cost));
PriceMasterTemp.event_cost = Convert.ToInt32(newPrices.Min(m => m.event_cost));
#endregion
bool isExist = false;
List<PriceMasterCustom> masterList = _priceMasterTempMgr.QueryProdSiteByVendor(new PriceMasterTemp { site_id = PriceMasterTemp.site_id, user_id = PriceMasterTemp.user_id, user_level = PriceMasterTemp.user_level, product_id = Convert.ToString(PriceMasterTemp.vendor_product_id) });
List<PriceMasterCustom> resultList = masterList.Where(p => p.price_master_id != PriceMasterTemp.price_master_id).ToList();
if (resultList != null && resultList.Count() > 0)
{
if (PriceMasterTemp.user_id != 0 || (PriceMasterTemp.user_id == 0 && resultList.Where(p => p.user_id == 0).Count() > 0))
{
json = "{success:false,msg:'" + Resources.VendorProduct.SITE_EXIST + "'}";
isExist = true;
}
}
if (!isExist)
{
ArrayList excuteSql = new ArrayList();
// ProductTemp productTemp = null;
if (PriceMasterTemp.site_id == 1 && PriceMasterTemp.user_level == 1 && PriceMasterTemp.user_id == 0)
{
//没有购物金。所以不处理product_temp
//#region 處理productTemp
//_productTempMgr = new ProductTempMgr(connectionString);
//productTemp = _productTempMgr.GetProTempByVendor(new ProductTemp { product_id = PriceMasterTemp.vendor_product_id, Create_Channel = 2 }).FirstOrDefault();
//excuteSql.Add(_productTempMgr.Update(productTemp));
//#endregion
#region 處理ProductItem
_productItemTempMgr = new ProductItemTempMgr(connectionString);
List<ProductItemTemp> productItems = _productItemTempMgr.QueryByVendor(new ProductItemTemp { Product_Id = Convert.ToString(PriceMasterTemp.vendor_product_id), Writer_Id = writerID });
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 => productItems.Find(n => n.Item_Id == m.item_id).Item_Money = m.item_money);
newPrices.ForEach(m => productItems.Find(n => n.Item_Id == m.item_id).Item_Cost = m.item_cost);
newPrices.ForEach(m => productItems.Find(n => n.Item_Id == m.item_id).Event_Item_Money = m.event_money);
newPrices.ForEach(m => productItems.Find(n => n.Item_Id == m.item_id).Event_Item_Cost = m.event_cost);
productItems.ForEach(m => excuteSql.Add(_productItemTempMgr.UpdateByVendor(m)));
}
#endregion
}
bool result = true;
//处理PriceMasterTemp
excuteSql.Add(_priceMasterTempMgr.UpdateTs(PriceMasterTemp));
_itemPriceTempMgr = new ItemPriceTempMgr(connectionString);
if (!_itemPriceTempMgr.UpdateByVendor(excuteSql))//执行sql语句
{
result = false;
}
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.VendorProduct.SAVE_FAIL + "'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetProItems()
{
string json = string.Empty;
string productID = string.Empty;
try
{
ProductItemTemp query = new ProductItemTemp();
if (!string.IsNullOrEmpty(Request.Form["ProductId"]))
{ //product_item
productID = Request.Form["ProductId"].ToString();
}
//if (!string.IsNullOrEmpty(Request.Form["OldProductId"]))
//{
// productID = Request.Form["OldProductId"].ToString();
//}
query.Product_Id = productID;
//query.Writer_Id = (Session["caller"] as Caller).user_id;
_productItemTempMgr = new ProductItemTempMgr(connectionString);
List<ProductItemTemp> proItemTemp = _productItemTempMgr.QueryByVendor(query);
json = JsonConvert.SerializeObject(proItemTemp);
}
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;
}
