/// <summary>
/// 新增商品销售区域
/// </summary>
/// <returns></returns>
public JsonResult AjaxSaveProductSalesAreaInfo()
{
string dataString = Request.Form["Data"];
dataString = HttpUtility.UrlDecode(dataString);
if (string.IsNullOrEmpty(dataString))
{
return(Json(new { Error = true, Message = LanguageHelper.GetText("Excel没有数据") }));
}
else
{
var user = UserAuthHelper.GetCurrentUser();
string ProductSysNo = Request.QueryString["ProductSysNo"];
ProductQueryInfo productInfo = ProductMaintainService.GetProductTitleByProductSysNo(Int32.Parse(ProductSysNo));
List <AreaInfo> data = ECommerce.Utility.SerializationUtility.JsonDeserialize2 <List <AreaInfo> >(dataString);
List <ProductSalesAreaInfo> SalesAreaList = new List <ProductSalesAreaInfo>();
foreach (var item in data)
{
if (!string.IsNullOrEmpty(item.CityName) && item.CitySysNo.HasValue && !string.IsNullOrEmpty(item.ProvinceName) && item.ProvinceSysNo.HasValue)
{
ProductSalesAreaInfo productSalesAreaInfo = new ProductSalesAreaInfo();
UserInfo userInfo = new UserInfo();
//仓库信息
StockInfo stock = new StockInfo();
stock.Status = StockStatus.Actived;
stock.StockName = item.StockName;
stock.SysNo = item.SysNo;
stock.StockType = TradeType.DirectMail;
stock.MerchantSysNo = 0;
//销售区域
productSalesAreaInfo.Stock = stock;
productSalesAreaInfo.Province = item;
//商家信息
productSalesAreaInfo.CompanyCode = user.CompanyCode;
productSalesAreaInfo.LanguageCode = user.LanguageCode;
userInfo.UserName = user.UserDisplayName;
productSalesAreaInfo.OperationUser = userInfo;
SalesAreaList.Add(productSalesAreaInfo);
}
}
ProductMaintainService.InsertProductSalesArea(productInfo, SalesAreaList);
return(new JsonResult()
{
Data = true
});
}
}
/// <summary>
/// 新增商品销售区域列表
/// </summary>
/// <param name="productInfo"></param>
/// <param name="productSalesAreaInfo"></param>
public static void InsertProductSalesArea(ProductQueryInfo productInfo, ProductSalesAreaInfo productSalesAreaInfo)
{
DataCommand dc = DataCommandManager.GetDataCommand("InsertProductSalesArea");
dc.SetParameterValue("@ProductSysNo", productInfo.SysNo);
dc.SetParameterValue("@ProductID", productInfo.ProductID);
dc.SetParameterValue("@ProductName", productInfo.ProductTitle);
dc.SetParameterValue("@StockSysNo", productSalesAreaInfo.Stock.SysNo);
dc.SetParameterValue("@StockName", productSalesAreaInfo.Stock.StockName);
dc.SetParameterValue("@ProvinceSysNo", productSalesAreaInfo.Province.ProvinceSysNo);
dc.SetParameterValue("@ProvinceName", productSalesAreaInfo.Province.ProvinceName);
dc.SetParameterValue("@CitySysNo", productSalesAreaInfo.Province.CitySysNo);
dc.SetParameterValue("@CityName", productSalesAreaInfo.Province.CityName);
dc.SetParameterValue("@InUser", productSalesAreaInfo.OperationUser.UserName);
dc.SetParameterValue("@CompanyCode", productSalesAreaInfo.CompanyCode);
dc.SetParameterValue("@LanguageCode", productSalesAreaInfo.LanguageCode);
dc.ExecuteNonQuery();
}
