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>
/// 1. 获取营业数据.
/// </summary>
/// <param name="user_id">The user_id<see cref="int"/>.</param>
/// <returns>.</returns>
public JsonResult GetUserTradeData(int user_id)
{
try
{
using (ERPDBEntities db = new ERPDBEntities())
{
Staff_Auth staff_auth = db.Staff_Auth.FirstOrDefault(a => a.staff_id == user_id);
if (staff_auth == null)
{
return(Json("员工不存在", JsonRequestBehavior.AllowGet));
}
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 = Commons.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(list, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
}
return(Json(null, JsonRequestBehavior.AllowGet));
}
