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)); }