//获取结构员工人员 public ActionResult GetPersonListJG() { var temp = User_Person_sltService.LoadEntities(x => x.UserInfo.BuMenID == 43).GroupBy(x => x.UserID).Select(x => x.FirstOrDefault()); List <serchMsgLong> lsm = new List <serchMsgLong>(); foreach (var a in temp) { serchMsgLong sm = new serchMsgLong(); sm.ID = a.ID; sm.Name = a.UserInfo.PerSonName; lsm.Add(sm); } return(Json(lsm, JsonRequestBehavior.AllowGet)); }
//修改信息前获取信息 public ActionResult GetPersonInfo() { long id = Convert.ToInt64(Request["id"]); var temp = User_Person_sltService.LoadEntities(x => x.ID == id).FirstOrDefault(); User_Person_slt ups = new User_Person_slt(); ups.ID = temp.ID; ups.AddTime = temp.AddTime; ups.Job_Name = temp.Job_Name; ups.UserID = temp.UserID; ups.Wage_slt = temp.Wage_slt; ups.HoursWage = temp.HoursWage; return(Json(new { ret = ups }, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { var UserName = User_Person_sltService.LoadEntities(x => x.UserInfo.BuMenID == 26).GroupBy(x => x.UserID).Select(x => x.FirstOrDefault()); //人员名称表 ViewBag.sltUser = UserName.ToList(); var UserNameJG = User_Person_sltService.LoadEntities(x => x.UserInfo.BuMenID == 43).GroupBy(x => x.UserID).Select(x => x.FirstOrDefault()); //人员名称表 ViewBag.sltUserJG = UserNameJG.ToList(); //零件名称表 var LingjianName = Seb_NumberService.LoadEntities(x => x.Items == 1).DefaultIfEmpty(); ViewBag.ljname = LingjianName.ToList(); //设备编号名称 var NumberName = Seb_NumberService.LoadEntities(x => x.Items == 0).DefaultIfEmpty(); ViewBag.ljname = NumberName.ToList(); return(View()); }
//添加生产员工信息 public ActionResult AddeditSltPer(User_Person_slt ups) { if (ups.ID > 0) { var isthis = User_Person_sltService.LoadEntities(x => x.ID == ups.ID).FirstOrDefault(); isthis.HoursWage = ups.HoursWage; isthis.Job_Name = ups.Job_Name; isthis.UserID = ups.UserID; isthis.Wage_slt = ups.Wage_slt; isthis.AddTime = DateTime.Now; //ups.UserInfo = isthis.UserInfo; //ups.AddTime = DateTime.Now; User_Person_sltService.EditEntity(isthis); } else { ups.AddTime = DateTime.Now; User_Person_sltService.AddEntity(ups); } return(Json(new { ret = "ok" }, JsonRequestBehavior.AllowGet)); }
//获取生产人员信息 public ActionResult sltperson() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 25; int TotalCount = 0; IQueryable <User_Person_slt> ups = User_Person_sltService.LoadPageEntities(pageIndex, pageSize, out TotalCount, x => x.ID > 0, m => m.ID, false).DefaultIfEmpty(); var temp = from a in ups select new { ID = a.ID, BuMen = a.UserInfo.BumenInfoSet.Name, Name = a.UserInfo.PerSonName, Job_Name = a.Job_Name, HoursWage = a.HoursWage, Wage_slt = a.Wage_slt, AddTime = a.AddTime }; return(Json(new { rows = temp, total = TotalCount }, JsonRequestBehavior.AllowGet)); }