//获取结构员工人员
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));
}
