public async Task <ActionResult> CreateSalesDailyPartial(Off_SalesInfo_Daily model, FormCollection form)
{
if (ModelState.IsValid)
{
Off_SalesInfo_Daily item = new Off_SalesInfo_Daily();
if (TryUpdateModel(item))
{
List <int> plist = new List <int>();
var user = UserManager.FindById(User.Identity.GetUserId());
var productlist = from m in _offlineDB.Off_Product
where m.Off_System_Id == user.DefaultSystemId &&
m.status >= 0
select m;
// 添加或修改销售列表
foreach (var product in productlist)
{
// 获取单品数据
int?sales = null;
if (form["sales_" + product.Id] != "")
{
sales = Convert.ToInt32(form["sales_" + product.Id]);
}
int?storage = null;
if (form["storage_" + product.Id] != "")
{
storage = Convert.ToInt32(form["storage_" + product.Id]);
}
decimal?amount = null;
if (form["amount_" + product.Id] != "")
{
amount = Convert.ToDecimal(form["amount_" + product.Id]);
}
// 判断是否已有数据
// 添加数据
// 如果三项数据不为空，则添加
if ((sales == null || sales == 0) && storage == null && amount == null)
{
}
else
{
Off_Daily_Product existdata = new Off_Daily_Product()
{
Off_SalesInfo_Daily = item,
ItemCode = product.ItemCode,
ProductId = product.Id,
SalesAmount = amount,
SalesCount = sales,
StorageCount = storage
};
_offlineDB.Off_Daily_Product.Add(existdata);
//offlineDB.SaveChanges();
}
}
item.UploadTime = DateTime.Now;
item.UploadUser = User.Identity.Name;
_offlineDB.Off_SalesInfo_Daily.Add(item);
var result = await _offlineDB.SaveChangesAsync();
OfflineSalesUtilities util = new OfflineSalesUtilities();
var result2 = await util.UpdateDailySalesAvg(item.StoreId, (int)item.Date.DayOfWeek + 1);
return(Content("SUCCESS"));
}
return(Content("FAIL"));
}
else
{
ModelState.AddModelError("", "发生错误");
var storelist = from m in _offlineDB.Off_Store
orderby m.StoreName
select new { Key = m.Id, Value = m.StoreName };
ViewBag.StoreDropDown = new SelectList(storelist, "Key", "Value");
return(PartialView(model));
}
}
public async Task <ActionResult> EditDailySalesPartial(int id, FormCollection form)
{
if (ModelState.IsValid)
{
var item = new Off_SalesInfo_Daily();
if (TryUpdateModel(item))
{
List <int> plist = new List <int>();
var user = UserManager.FindById(User.Identity.GetUserId());
var productlist = from m in _offlineDB.Off_Product
where m.Off_System_Id == user.DefaultSystemId &&
m.status >= 0
select m;
// 添加或修改销售列表
foreach (var product in productlist)
{
// 获取单品数据
int?sales = null;
if (form["sales_" + product.Id] != "")
{
sales = Convert.ToInt32(form["sales_" + product.Id]);
}
int?storage = null;
if (form["storage_" + product.Id] != "")
{
storage = Convert.ToInt32(form["storage_" + product.Id]);
}
decimal?amount = null;
if (form["amount_" + product.Id] != "")
{
amount = Convert.ToDecimal(form["amount_" + product.Id]);
}
// 判断是否已有数据
var checkinproductlist = _offlineDB.Off_Daily_Product.Where(m => m.DailyId == id);
var existdata = checkinproductlist.SingleOrDefault(m => m.ProductId == product.Id);
if (existdata != null)
{
if (sales == null && storage == null && amount == null)
{
// 无数据则删除
_offlineDB.Off_Daily_Product.Remove(existdata);
}
else if (sales == 0 && storage == 0 && amount == 0)
{
_offlineDB.Off_Daily_Product.Remove(existdata);
}
else
{
// 修改数据
existdata.SalesAmount = amount;
existdata.SalesCount = sales;
existdata.StorageCount = storage;
}
}
else
{
// 添加数据
// 如果三项数据不为空，则添加
if (sales == null && storage == null && amount == null)
{
}
else if (sales == 0 && storage == 0 && amount == 0)
{
}
else
{
existdata = new Off_Daily_Product()
{
DailyId = id,
ItemCode = product.ItemCode,
ProductId = product.Id,
SalesAmount = amount,
SalesCount = sales,
StorageCount = storage
};
_offlineDB.Off_Daily_Product.Add(existdata);
//offlineDB.SaveChanges();
}
}
}
item.UploadTime = DateTime.Now;
item.UploadUser = User.Identity.Name;
_offlineDB.Entry(item).State = System.Data.Entity.EntityState.Modified;
var result = await _offlineDB.SaveChangesAsync();
// 该代码需要重写
OfflineSalesUtilities util = new OfflineSalesUtilities();
var result2 = await util.UpdateDailySalesAvg(item.StoreId, (int)item.Date.DayOfWeek + 1);
//update_Sales_AVGINfo(item.StoreId, (int)item.Date.DayOfWeek + 1);
return(Content("SUCCESS"));
}
else
{
return(PartialView("AuthorizeErrorPartial"));
}
}
else
{
return(PartialView("ErrorPartial"));
}
}
