public ActionResult CreateSellerReport(int id)
{
var seller = _offlineDB.Off_Seller.SingleOrDefault(m => m.Id == id);
DateTime apply_date = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
var item = _offlineDB.Off_SellerTask.SingleOrDefault(m => m.SellerId == id && m.ApplyDate == apply_date);
if (item != null)
{
return(View("TaskError"));
}
else
{
item = new Off_SellerTask()
{
SellerId = id,
StoreId = seller.StoreId,
ApplyDate = apply_date
};
return(View(item));
}
}
public ActionResult EditSellerTask(int id, FormCollection form)
{
if (ModelState.IsValid)
{
// 确认添加或者修改
var seller = _offlineDB.Off_Seller.SingleOrDefault(m => m.Id == id);
DateTime apply_date = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
Off_SellerTask task = new Off_SellerTask();
if (TryUpdateModel(task))
{
// 获取模板产品列表
List <int> plist = new List <int>();
//var Template = offlineDB.Off_Checkin_Schedule.SingleOrDefault(m => m.Id == checkin.Off_Schedule_Id).Off_Sales_Template;
var user = UserManager.FindById(User.Identity.GetUserId());
//var Template = offlineDB.Off_Checkin_Schedule.SingleOrDefault(m => m.Id == checkin.Off_Schedule_Id).Off_Sales_Template;
var _p = _offlineDB.Off_System_Setting.SingleOrDefault(m => m.SettingName == "TMEPPRODUCTLIST" && m.Off_System_Id == user.DefaultSystemId);
string parray = "";
if (_p != null)
{
parray = _p.SettingValue;
}
foreach (var i in parray.Split(','))
{
plist.Add(Convert.ToInt32(i));
}
var productlist = from m in _offlineDB.Off_Product
where plist.Contains(m.Id)
select m;
// 添加或修改销售列表
foreach (var item in productlist)
{
// 获取单品数据
int?sales = null;
if (form["sales_" + item.Id] != "")
{
sales = Convert.ToInt32(form["sales_" + item.Id]);
}
int?storage = null;
if (form["storage_" + item.Id] != "")
{
storage = Convert.ToInt32(form["storage_" + item.Id]);
}
decimal?amount = null;
if (form["amount_" + item.Id] != "")
{
amount = Convert.ToDecimal(form["amount_" + item.Id]);
}
// 判断是否已有数据
var taskproductlist = _offlineDB.Off_SellerTaskProduct.Where(m => m.SellerTaskId == task.Id);
var existdata = taskproductlist.SingleOrDefault(m => m.ProductId == item.Id);
if (existdata != null)
{
if (sales == null && storage == null && amount == null)
{
// 无数据则删除
_offlineDB.Off_SellerTaskProduct.Remove(existdata);
}
else
{
// 修改数据
existdata.SalesAmount = amount;
existdata.SalesCount = sales;
existdata.StorageCount = storage;
}
}
else
{
// 添加数据
// 如果三项数据不为空，则添加
if (sales == null && storage == null && amount == null)
{
}
else
{
Off_SellerTaskProduct data = new Off_SellerTaskProduct()
{
Off_SellerTask = task,
ItemCode = item.ItemCode,
ProductId = item.Id,
SalesAmount = amount,
SalesCount = sales,
StorageCount = storage
};
_offlineDB.Off_SellerTaskProduct.Add(data);
}
}
}
task.LastUpdateTime = DateTime.Now;
task.LastUpdateUser = User.Identity.Name;
_offlineDB.Entry(task).State = System.Data.Entity.EntityState.Modified;
_offlineDB.SaveChanges();
return(Content("SUCCESS"));
}
return(Content("FAIL"));
}
else
{
return(Content("FAIL"));
}
}
