public async Task <JsonResult> DeleteSalesDailyAjax(int id) { var item = _offlineDB.Off_SalesInfo_Daily.SingleOrDefault(m => m.Id == id); if (item != null) { var user = UserManager.FindById(User.Identity.GetUserId()); if (item.Off_Store.Off_System_Id == user.DefaultSystemId) { try { _offlineDB.Off_SalesInfo_Daily.Remove(item); var result = await _offlineDB.SaveChangesAsync(); OfflineSalesUtilities util = new OfflineSalesUtilities(); var result2 = await util.UpdateDailySalesAvg(item.StoreId, (int)(item.Date.DayOfWeek) + 1); return(Json(new { result = "SUCCESS" })); } catch { return(Json(new { result = "FAIL" })); } } else { return(Json(new { result = "UNAUTHORIZED" })); } } else { return(Json(new { result = "FAIL" })); } }
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")); } }