public IHttpActionResult EditSchedule(int word_time_id, string week, string on_work, string off_work)
{
try
{
if (string.IsNullOrEmpty(week) || string.IsNullOrEmpty(on_work) || string.IsNullOrEmpty(off_work))
{
return(Json(new { result = "请求参数错误" }));
}
using (ERPDBEntities db = new ERPDBEntities())
{
var work_time = db.WorkTime.FirstOrDefault(a => a.id == word_time_id);
if (work_time == null)
{
return(Json(new { result = "排班信息异常" }));
}
work_time.week = week;
work_time.on_work = on_work;
work_time.off_work = off_work;
work_time.update_time = DateTime.Now;
db.Entry(work_time).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() < 0)
{
return(Json(new { result = "修改失败" }));
}
return(Json(new { result = "修改成功" }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
public IHttpActionResult ChangeStaffLeader(int user_id, int leader_id)
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
var staff = db.Staff.FirstOrDefault(a => a.id == user_id);
if (staff == null)
{
return(Json(new { result = "员工信息不存在" }));
}
var leader = db.Staff.FirstOrDefault(a => a.id == leader_id);
if (leader == null)
{
return(Json(new { result = "主管信息不存在" }));
}
staff.leader_id = leader.id;
staff.update_time = DateTime.Now;
db.Entry(staff).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() > 0)
{
return(Json(new { result = "操作成功" }));
}
}
}
catch (Exception ex)
{
}
return(Json(new { result = "操作失败" }));
}
/// <summary>
/// 3.4 鲜度检查
/// </summary>
/// <returns></returns>
public IHttpActionResult CheckProductShelfLife()
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
var query = db.Product.AsQueryable();
//日配过期时间提前一小时
var ripei = query.Where(a => a.product_category == (int)Product_Category_Enum.RiPei && (a.production_date - DateTime.Now).TotalMilliseconds <= 60).ToList();
//非日配过期时间提前一月推送
var noripei = query.Where(a => a.product_category == (int)Product_Category_Enum.NoRiPei && (a.production_date - DateTime.Now).TotalDays <= 30).ToList();
List <Product> list = new List <Product>();
list.AddRange(ripei);
list.AddRange(noripei);
var data = list.Select(a => new { a.product_id, a.product_name });
return(Json(new { result = data }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
public IHttpActionResult ChangeStaffProductType(int user_id, List <int> product_type)
{
try
{
if (product_type == null || !product_type.Any())
{
return(Json(new { result = "请求参数错误" }));
}
using (ERPDBEntities db = new ERPDBEntities())
{
var staff = db.Staff.FirstOrDefault(a => a.id == user_id);
if (staff == null)
{
return(Json(new { result = "员工信息异常" }));
}
staff.sell_product_type = string.Join(",", product_type);
db.Entry(staff).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() > 0)
{
return(Json(new { result = "操作成功" }));
}
}
}
catch (Exception ex)
{
}
return(Json(new { result = "操作失败" }));
}
/// <summary>
/// The GetProductExpendRate.
/// </summary>
/// <param name="category">The category<see cref="int?"/>.</param>
/// <param name="time">The time<see cref="DateTime?"/>.</param>
/// <returns>The <see cref="List{ProductExpendModel}"/>.</returns>
private static List <ProductExpendModel> GetProductExpendRate(int?category = null, DateTime?time = null)
{
List <ProductExpendModel> list = new List <ProductExpendModel>();
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
if (category.HasValue)
{
var query = (from a in db.Product join b in db.Sell_Record on a.product_id equals b.product_id where a.product_category == category.Value select new { a.product_id, a.product_name, a.stock_count, b.sell_count, b.create_time }).ToList();
if (time.HasValue)
{
query = query.Where(a => a.create_time.ToString("yyyy-MM-dd") == time.Value.ToString("yyyy-MM-dd")).Select(a => a).ToList();
}
foreach (var item in query)
{
ProductExpendModel pro = new ProductExpendModel();
pro.product_id = item.product_id;
pro.product_name = item.product_name;
pro.stock_count = item.stock_count;
pro.sell_count = item.sell_count;
pro.expend_rate = (((double)item.sell_count / (double)item.stock_count) * 100).ToString("f2") + "%";
list.Add(pro);
}
List <ProductExpendModel> temp = new List <ProductExpendModel>();
temp.AddRange(list.OrderBy(a => a.sell_count).Take(5));
temp.AddRange(list.OrderByDescending(a => a.sell_count).Take(5));
return(temp.OrderBy(a => a.sell_count).ToList());
}
else
{
var query = (from a in db.Product join b in db.Sell_Record on a.product_id equals b.product_id select new { a.product_id, a.product_name, a.stock_count, b.sell_count, b.create_time }).ToList();
if (time.HasValue)
{
query = query.Where(a => a.create_time.ToString("yyyy-MM-dd") == time.Value.ToString("yyyy-MM-dd")).Select(a => a).ToList();
}
//var query = (from a in db.Product join b in db.Sell_Record on a.product_id equals b.product_id select new { a.product_id, a.product_name, a.stock_count, b.sell_count }).ToList();
foreach (var item in query)
{
ProductExpendModel pro = new ProductExpendModel();
pro.product_id = item.product_id;
pro.product_name = item.product_name;
pro.stock_count = item.stock_count;
pro.sell_count = item.sell_count;
pro.expend_rate = (((double)item.sell_count / (double)item.stock_count) * 100).ToString("f2") + "%";
list.Add(pro);
}
return(list.OrderBy(a => a.sell_count).ToList());
}
}
}
catch (Exception ex)
{
}
return(null);;
}
/// <summary>
/// 获取消耗率.
/// </summary>
/// <param name="product_id">.</param>
/// <param name="product_category">.</param>
/// <param name="expend_rate_type">.</param>
/// <returns>.</returns>
public static double GetExpendRate(string product_id, int product_category, int expend_rate_type)
{
double expend_rate = 0;
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
var rate_config = db.Product_Expend_Rate_Config.FirstOrDefault(a => a.product_id == product_id);
if (rate_config != null)
{
if (product_category == (int)Product_Category_Enum.NoRiPei)
{
if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.High_Expend_Rate)
{
expend_rate = SystemCommon.No_Ri_Pei_High_Expend_Rate - 5; //非日配商品消化率过高，消化率30 %，上下五个点
}
else if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.Low_Expend_Rate)
{
expend_rate = SystemCommon.No_Ri_Pei_Low_Expend_Rate;
}
}
else if (product_category == (int)Product_Category_Enum.RiPei)
{
if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.High_Expend_Rate)
{
expend_rate = SystemCommon.Ri_Pei_High_Expend_Rate - 2; //日配商品消化率过高，消化率90%，上下两个点
}
else if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.Low_Expend_Rate)
{
expend_rate = SystemCommon.Ri_Pei_Low_Expend_Rate;
}
}
}
else
{
if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.High_Expend_Rate)
{
expend_rate = rate_config.high_expend_rate;
}
else if (expend_rate_type == (int)Enum_Product_Expend_Rate_Type.Low_Expend_Rate)
{
expend_rate = rate_config.low_expend_rate;
}
}
}
}
catch (Exception ex)
{
}
return(expend_rate);
}
/// <summary>
/// 默认根据最近7天的销售情况，用标准差公式计算消化率稳定产品.
/// </summary>
/// <returns>.</returns>
private static List <ProductExpendRateStandardDeviationModel> GetStableExpendRate()
{
try
{
List <ProductExpendRateStandardDeviationModel> list = new List <ProductExpendRateStandardDeviationModel>();
using (ERPDBEntities db = new ERPDBEntities())
{
DateTime start_time = DateTime.Now; DateTime end_time = start_time.AddDays(7);
var query = (from a in db.Product
join b in db.Sell_Record on a.product_id equals b.product_id
where b.create_time >= start_time && b.create_time <= end_time
select new
{ a.product_id, a.product_name, a.stock_count, b.sell_count, b.create_time, a.product_category }).ToList();
if (query.Any())
{
var product = query.GroupBy(a => new { a.product_id, a.product_name });
if (product.Any())
{
foreach (var item in product)
{
List <double> expend_rate = new List <double>();
foreach (var info in item)
{
double rate = ((double)info.sell_count / (double)info.stock_count) * 100;
expend_rate.Add(rate);
}
ProductExpendRateStandardDeviationModel model = new ProductExpendRateStandardDeviationModel();
model.product_id = item.Key.product_id;
model.product_name = item.Key.product_name;
model.expend_rate_sd = SystemCommon.GetStdDev(expend_rate, false);
list.Add(model);
}
}
}
if (list.Any())
{
list = list.OrderBy(a => a.expend_rate_sd).Take(5).ToList();
}
}
return(list);
}
catch (Exception ex)
{
}
return(null);
}
public IHttpActionResult CheckHighProductPrice()
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
var data = db.Product.Where(a => a.price > 50).OrderByDescending(a => a.price).Take(20).ToList();
return(Json(new { result = data }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
/// <summary>
/// The GetProductExpendRate.
/// </summary>
/// <param name="time">The time<see cref="DateTime?"/>.</param>
/// <returns>The <see cref="List{ProductExpendModel}"/>.</returns>
private static List <ProductExpendModel> GetProductExpendRate(DateTime?time = null)
{
List <ProductExpendModel> list = new List <ProductExpendModel>();
try
{
DateTime start_time = time.HasValue ? time.Value.Date : DateTime.Now.Date;
DateTime end_time = start_time.AddDays(1);
using (ERPDBEntities db = new ERPDBEntities())
{
var query = (from a in db.Product
join b in db.Sell_Record on a.product_id equals b.product_id
where b.create_time >= start_time && b.create_time < end_time
select new { a.product_id, a.product_name, a.stock_count, b.sell_count, b.create_time }).AsQueryable();
if (query.Any())
{
var product = query.GroupBy(a => new { a.product_id, a.product_name });
foreach (var item in product)
{
List <double> expend_rate = new List <double>();
foreach (var info in item)
{
double rate = ((double)info.sell_count / (double)info.stock_count) * 100;
expend_rate.Add(rate);
}
double average_expend_rate = expend_rate.Average();
ProductExpendModel pro = new ProductExpendModel();
pro.product_id = item.Key.product_id;
pro.product_name = item.Key.product_name;
pro.average_expend_rate = average_expend_rate;
pro.expend_rate = average_expend_rate.ToString("f2") + "%";
list.Add(pro);
}
}
return(list.OrderBy(a => a.average_expend_rate).ToList());
}
}
catch (Exception ex)
{
}
return(null);;
}
public IHttpActionResult GetSchedule()
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
string week = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek);
List <WorkTime> work = db.WorkTime.Where(a => a.week == week).ToList();
return(Json(new { result = work }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
/// <summary>
/// 初始化数据.
/// </summary>
/// <returns>.</returns>
public void InitDB()
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
if (!db.Product.Any())
{
DBInit.InitProduct();
}
if (!db.Staff.Any())
{
DBInit.InitStaff();
}
if (!db.WorkTime.Any())
{
DBInit.InitWorkTime();
}
if (!db.Sell_Record.Any())
{
DBInit.InitSellRecord();
}
if (!db.Inventory.Any())
{
DBInit.InitInventory();
}
if (!db.Product_Expend_Rate_Config.Any())
{
DBInit.InitProductExpendRateConfig();
}
}
Response.Write("ok");
return;
}
catch (Exception ex)
{
}
Response.Write("error");
}
public IHttpActionResult UserLogin(string name, string password)
{
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(password))
{
return(Json(new { result = "用户名或密码错误" }));
}
using (ERPDBEntities db = new ERPDBEntities())
{
var encode_pass = SystemCommon.GetMD5Str(password);
var user = db.Staff.FirstOrDefault(a => a.name == name && a.password == encode_pass);
if (user == null)
{
return(Json(new { result = "用户不存在" }));
}
return(Json(new { result = "登陆成功", data = user.id }));
}
}
public IHttpActionResult AddUser(string name, string password, int leader_id, string user_type, decimal salary, string sell_product_type)
{
try
{
if (string.IsNullOrEmpty(name))
{
return(Json(new { result = "用户名不能为空" }));
}
Enum_User_Type userType;
bool convertResult = Enum.TryParse(user_type, out userType);
if (convertResult == false)
{
return(Json(new { result = "用户类型异常" }));
}
Staff user = new Staff();
user.name = name;
user.password = string.IsNullOrEmpty(password) ? SystemCommon.GetMD5Str(SystemCommon.Default_Password) : SystemCommon.GetMD5Str(password);
user.leader_id = leader_id;
user.user_type = user_type;
user.salary = salary;
user.sell_product_type = sell_product_type;
user.create_time = DateTime.Now;
user.update_time = DateTime.Now;
using (ERPDBEntities db = new ERPDBEntities())
{
db.Entry(user).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() < 0)
{
return(Json(new { result = "用户添加失败" }));
}
}
return(Json(new { result = "用户添加成功" }));
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
public JsonResult ChangeStaffLeader(int user_id, int leader_id)
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
var staff = db.Staff.FirstOrDefault(a => a.id == user_id);
if (staff == null)
{
return(Json("员工不存在", JsonRequestBehavior.AllowGet));
}
var leader = (from a in db.Staff
join b in db.Staff_Auth on a.id equals b.staff_id
select new { a.id, b.sell_product_type }).FirstOrDefault();
if (leader == null)
{
return(Json("主管不存在", JsonRequestBehavior.AllowGet));
}
Staff_Auth auth = new Staff_Auth();
auth.leader_id = leader.id;
auth.staff_id = staff.id;
auth.sell_product_type = leader.sell_product_type.Split(',').FirstOrDefault();
auth.create_time = DateTime.Now;
auth.update_time = DateTime.Now;
db.Entry(auth).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() > 0)
{
return(Json("操作成功", JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
}
return(Json("操作失败", JsonRequestBehavior.AllowGet));
}
/// <summary>
/// The Index.
/// </summary>
/// <returns>The <see cref="ActionResult"/>.</returns>
public ActionResult Index()
{
using (ERPDBEntities db = new ERPDBEntities())
{
if (!db.Product.Any())
{
InitDB.InitProduct();
}
if (!db.Staff.Any())
{
InitDB.InitStaff();
}
if (!db.schedule.Any())
{
InitDB.InitSchedule();
}
if (!db.WorkTime.Any())
{
InitDB.InitWorkTime();
}
if (!db.Sell_Record.Any())
{
InitDB.InitSellRecord();
}
if (!db.Inventory.Any())
{
InitDB.InitInventory();
}
if (!db.Staff_Auth.Any())
{
InitDB.InitStaffAuth();
}
}
return(View());
}
public IHttpActionResult AddSchedule(int user_id, string week, string on_work, string off_work)
{
try
{
if (string.IsNullOrEmpty(week) || string.IsNullOrEmpty(on_work) || string.IsNullOrEmpty(off_work))
{
return(Json(new { result = "请求参数错误" }));
}
using (ERPDBEntities db = new ERPDBEntities())
{
var staff = db.Staff.FirstOrDefault(a => a.id == user_id);
if (staff == null)
{
return(Json(new { result = "员工信息异常" }));
}
WorkTime work_time = new WorkTime();
work_time.staff_id = staff.id;
work_time.staff_name = staff.name;
work_time.week = week;
work_time.on_work = on_work;
work_time.off_work = off_work;
work_time.create_time = DateTime.Now;
work_time.update_time = DateTime.Now;
db.Entry(work_time).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() < 0)
{
return(Json(new { result = "添加失败" }));
}
return(Json(new { result = "添加成功" }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
public IHttpActionResult GetHomeInfo()
{
try
{
HomeInfoData model = new HomeInfoData();
using (ERPDBEntities db = new ERPDBEntities())
{
DateTime now = DateTime.Now;
string week = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(now.DayOfWeek);
List <WorkTime> work = db.WorkTime.Where(a => a.week == week).ToList();
model.staff = work.Select(a => a.staff_name).ToList();
model.ri_pei_count = db.Product.Where(a => a.product_category == (int)Product_Category_Enum.RiPei).Sum(a => a.stock_count);
model.ri_pei_count = db.Product.Where(a => a.product_category == (int)Product_Category_Enum.NoRiPei).Sum(a => a.stock_count);
model.current_date = now.ToString("yyyy.MM.dd") + "(" + week + ")";
model.sell_target = SystemCommon.Default_Sell_Target;
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
/// <summary>
/// 获取商品消耗率过高和过低的5个产品.
/// </summary>
/// <param name="category">.</param>
/// <param name="time">.</param>
/// <returns>.</returns>
private static ExpendModel GetProductExpendRate(int category, DateTime?time = null)
{
ExpendModel model = new ExpendModel();
try
{
DateTime start_time = time.HasValue ? time.Value.Date : DateTime.Now.Date;
DateTime end_time = start_time.AddDays(1);
using (ERPDBEntities db = new ERPDBEntities())
{
var query = (from a in db.Product
join b in db.Sell_Record on a.product_id equals b.product_id
where a.product_category == category && b.create_time >= start_time && b.create_time < end_time
select new { a.product_id, a.product_name, a.stock_count, b.sell_count, b.create_time }).AsQueryable();
if (query.Any())
{
var product = query.GroupBy(a => new { a.product_id, a.product_name });
foreach (var item in product)
{
List <double> expend_rate = new List <double>();
foreach (var info in item)
{
double rate = ((double)info.sell_count / (double)info.stock_count) * 100;
expend_rate.Add(rate);
}
double average_expend_rate = expend_rate.Average();
if (category == (int)Product_Category_Enum.RiPei)
{
//日配商品消化率过高，消化率90%，上下两个点
if (average_expend_rate >= SystemCommon.GetExpendRate(item.Key.product_id, (int)Product_Category_Enum.RiPei, (int)Enum_Product_Expend_Rate_Type.High_Expend_Rate))
{
ProductExpendModel high_model = new ProductExpendModel();
high_model.product_id = item.Key.product_id;
high_model.product_name = item.Key.product_name;
high_model.average_expend_rate = average_expend_rate;
high_model.expend_rate = average_expend_rate.ToString("f2") + "%";
model.High_Rate.Add(high_model);
}
//日配商品消化率过低，消化率50%
if (average_expend_rate < SystemCommon.GetExpendRate(item.Key.product_id, (int)Product_Category_Enum.RiPei, (int)Enum_Product_Expend_Rate_Type.Low_Expend_Rate))
{
ProductExpendModel high_model = new ProductExpendModel();
high_model.product_id = item.Key.product_id;
high_model.product_name = item.Key.product_name;
high_model.average_expend_rate = average_expend_rate;
high_model.expend_rate = average_expend_rate.ToString("f2") + "%";
model.Low_Rate.Add(high_model);
}
}
else if (category == (int)Product_Category_Enum.NoRiPei)
{
//非日配商品消化率过高，消化率30%，上下五个点
if (average_expend_rate >= SystemCommon.GetExpendRate(item.Key.product_id, (int)Product_Category_Enum.NoRiPei, (int)Enum_Product_Expend_Rate_Type.High_Expend_Rate))
{
ProductExpendModel high_model = new ProductExpendModel();
high_model.product_id = item.Key.product_id;
high_model.product_name = item.Key.product_name;
high_model.average_expend_rate = average_expend_rate;
high_model.expend_rate = average_expend_rate.ToString("f2") + "%";
model.High_Rate.Add(high_model);
}
//非日配商品消化率过低，消化率10%
if (average_expend_rate < SystemCommon.GetExpendRate(item.Key.product_id, (int)Product_Category_Enum.NoRiPei, (int)Enum_Product_Expend_Rate_Type.Low_Expend_Rate))
{
ProductExpendModel high_model = new ProductExpendModel();
high_model.product_id = item.Key.product_id;
high_model.product_name = item.Key.product_name;
high_model.average_expend_rate = average_expend_rate;
high_model.expend_rate = average_expend_rate.ToString("f2") + "%";
model.Low_Rate.Add(high_model);
}
}
}
if (model.High_Rate.Any() && model.High_Rate.Count > 5)
{
model.High_Rate = model.High_Rate.OrderByDescending(a => a.average_expend_rate).Take(5).ToList();
}
if (model.Low_Rate.Any() && model.Low_Rate.Count > 5)
{
model.Low_Rate = model.Low_Rate.OrderByDescending(a => a.average_expend_rate).Take(5).ToList();
}
}
return(model);
}
}
catch (Exception ex)
{
}
return(null);
}
public IHttpActionResult GetUserTradeData(int user_id)
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
Staff staff_auth = db.Staff.FirstOrDefault(a => a.id == user_id);
if (staff_auth == null)
{
return(Json(new { result = "员工不存在" }));
}
DateTime start_time = DateTime.Now.Date;
DateTime end_time = start_time.AddDays(1);
List <int> product_type = staff_auth.sell_product_type.Split(',').Select(a => int.Parse(a)).ToList();
var query = (from a in db.Sell_Record
join b in db.Product on a.product_id equals b.product_id
where a.create_time >= start_time && a.create_time < end_time && product_type.Contains(b.product_type)
select new
{
a.product_id,
a.product_name,
a.sell_count,
a.delivery_count,
a.trash_count,
b.product_type,
b.stock_count,
b.price
}).ToList();
List <UserTradeDataModel> list = new List <UserTradeDataModel>();
var group_data = query.GroupBy(a => a.product_type);
foreach (var item in group_data)
{
UserTradeDataModel model = new UserTradeDataModel();
model.product_type = SystemCommon.GetDescription((Product_Type_Enum)Enum.ToObject(typeof(Product_Type_Enum), item.Key));
foreach (var pro in item)
{
ProductSellModel sell_model = new ProductSellModel();
sell_model.product_id = pro.product_id;
sell_model.product_name = pro.product_name;
sell_model.delivery_count = pro.delivery_count; //交货
sell_model.sell_count = pro.sell_count;
sell_model.product_price = pro.price;
sell_model.sell_amount = pro.sell_count * pro.price;
model.sell_info.Add(sell_model);
}
model.total_sell_amount = model.sell_info.Sum(a => a.sell_amount);
model.total_sell_count = model.sell_info.Sum(a => a.sell_count);
model.total_delivery_count = model.sell_info.Sum(a => a.delivery_count);
list.Add(model);
}
return(Json(new { result = list }));
}
}
catch (Exception ex)
{
}
return(NotFound());
}
public IHttpActionResult GetLowExpendRateProduct()
{
try
{
List <ProductExpendRateStandardDeviationModel> list = new List <ProductExpendRateStandardDeviationModel>();
using (ERPDBEntities db = new ERPDBEntities())
{
var query = (from a in db.Product join b in db.Sell_Record on a.product_id equals b.product_id select new { a.product_id, a.product_name, a.stock_count, b.sell_count, a.product_category }).ToList();
if (query.Any())
{
var ri_pei = query.Where(a => a.product_category == (int)Product_Category_Enum.RiPei).GroupBy(a => new { a.product_id, a.product_name });
var no_ri_pei = query.Where(a => a.product_category == (int)Product_Category_Enum.NoRiPei).GroupBy(a => new { a.product_id, a.product_name });
if (ri_pei.Any())
{
foreach (var item in ri_pei)
{
List <double> expend_rate = new List <double>();
foreach (var info in item)
{
double rate = ((double)info.sell_count / (double)info.stock_count) * 100;
expend_rate.Add(rate);
}
double expent_rate_sd = SystemCommon.GetStdDev(expend_rate, false);
if (expent_rate_sd < 50) //日配商品消化率低于50%
{
ProductExpendRateStandardDeviationModel model = new ProductExpendRateStandardDeviationModel();
model.product_id = item.Key.product_id;
model.product_name = item.Key.product_name;
model.expend_rate_sd = SystemCommon.GetStdDev(expend_rate, false);
list.Add(model);
}
}
}
if (no_ri_pei.Any())
{
foreach (var item in ri_pei)
{
List <double> expend_rate = new List <double>();
foreach (var info in item)
{
double rate = ((double)info.sell_count / (double)info.stock_count) * 100;
expend_rate.Add(rate);
}
double expent_rate_sd = SystemCommon.GetStdDev(expend_rate, false);
if (expent_rate_sd < 10) //非日配商品消化率低于10%
{
ProductExpendRateStandardDeviationModel model = new ProductExpendRateStandardDeviationModel();
model.product_id = item.Key.product_id;
model.product_name = item.Key.product_name;
model.expend_rate_sd = SystemCommon.GetStdDev(expend_rate, false);
list.Add(model);
}
}
}
}
return(Json(new { result = list }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
public IHttpActionResult ChangeProductExpendRate(string product_id, double rate)
{
try
{
if (string.IsNullOrEmpty(product_id))
{
return(Json(new { result = "参数错误" }));
}
using (ERPDBEntities db = new ERPDBEntities())
{
var expend_rate = db.Product_Expend_Rate_Config.FirstOrDefault(a => a.product_id == product_id);
if (expend_rate == null)
{
var product_info = db.Product.FirstOrDefault(a => a.product_id == product_id);
if (product_info == null)
{
return(Json(new { result = "商品信息异常" }));
}
expend_rate = new Product_Expend_Rate_Config();
expend_rate.product_id = product_info.product_id;
expend_rate.product_name = product_info.product_name;
expend_rate.product_type = product_info.product_type;
expend_rate.product_category = product_info.product_category;
expend_rate.high_expend_rate = product_info.product_category == (int)Product_Category_Enum.RiPei ? SystemCommon.Ri_Pei_High_Expend_Rate : SystemCommon.No_Ri_Pei_High_Expend_Rate;
if (rate > 0)
{
expend_rate.low_expend_rate = rate;
}
else
{
expend_rate.low_expend_rate = product_info.product_category == (int)Product_Category_Enum.RiPei ? SystemCommon.Ri_Pei_Low_Expend_Rate : SystemCommon.No_Ri_Pei_Low_Expend_Rate;
}
expend_rate.create_time = DateTime.Now;
expend_rate.update_time = DateTime.Now;
db.Entry(expend_rate).State = System.Data.Entity.EntityState.Added;
if (db.SaveChanges() < 0)
{
return(Json(new { result = "设置失败" }));
}
return(Json(new { result = "设置成功" }));
}
expend_rate.low_expend_rate = rate;
expend_rate.update_time = DateTime.Now;
db.Entry(expend_rate).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() < 0)
{
return(Json(new { result = "设置失败" }));
}
return(Json(new { result = "设置成功" }));
}
}
catch (Exception ex)
{
}
return(Json(new { result = "系统异常" }));
}
