public ActionResult StaffJobDetail(string staffid) { try { V_HR_StaffJobWithName sj = (from o in entities.V_HR_StaffJobWithName where o.StaffID == staffid select o).First(); var textstaffid = X.GetCmp <TextField>("StaffID"); textstaffid.Text = sj.StaffID; //var textdep = X.GetCmp<TextField>("SDepartMentName"); //textdep.Text = sj.SDepartMentName; var textstafftype = X.GetCmp <TextField>("StaffType"); textstafftype.Text = sj.StaffType; var textname = X.GetCmp <TextField>("Name"); textname.Text = sj.Name; var textentrytime = X.GetCmp <TextField>("EntryTime"); textentrytime.Text = Convert.ToDateTime(sj.EntryTime.ToString()).ToString("yyyy-MM-dd"); var list = (from o in entities.V_HR_StaffJobWithName where o.StaffID == staffid select o).ToList(); return(View(list)); } catch (Exception e) { X.Msg.Alert("警告", "数据库查询失败!<br /> note:" + e.Message).Show(); return(this.Direct()); } }
public ActionResult AddStaffJob(string staffJobid) //在修改时传递的为contractid { if (staffJobid == "-1") //-1为添加 { //var s = X.GetCmp<TextField>("StaffID"); //s.Text = "qwerqwreq"; return(View()); } else//否则为修改 { V_HR_StaffJobWithName item = (from o in entities.V_HR_StaffJobWithName where o.StaffJobID == staffJobid select o).First(); return(View(item)); } }
public ActionResult AddOrEditStaffJob(V_HR_StaffJobWithName staffJob)//AddstaffJob保存相应 { DirectResult r = new DirectResult(); T_HR_StaffJob staffJobupdate = entities.T_HR_StaffJob.Find(staffJob.StaffJobID); if (staffJobupdate == null)//为空为添加 { T_HR_StaffJob staffJobadd = new T_HR_StaffJob(); staffJobadd.StaffJobID = Tool.ProduceSed64(); staffJobadd.StaffID = staffJob.StaffID; staffJobadd.JobID = staffJob.JobID; if (staffJob.ValidTime <= DateTime.Now.Date)//添加保存时可能存在两个有效职位,但是没有用到添加,员工职位的添加是在入职时设置的,那时还不存在该员工职位记录 { staffJobadd.IsValid = true; } else { staffJobadd.IsValid = false; } staffJobadd.ValidTime = staffJob.ValidTime; staffJobadd.Remark = staffJob.Remark; staffJobadd.CreaterName = "admin";//后期改为用户名 staffJobadd.CreateTime = DateTime.Now; entities.T_HR_StaffJob.Add(staffJobadd); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "保存成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } } else//否则为修改 { T_HR_Staff s = entities.T_HR_Staff.Find(staffJob.StaffID); s.StaffType = staffJob.StaffType; T_HR_StaffJob staffJobadd = new T_HR_StaffJob(); staffJobadd.StaffJobID = Tool.ProduceSed64(); staffJobadd.StaffID = staffJob.StaffID; staffJobadd.JobID = staffJob.JobID; if (staffJob.ValidTime <= DateTime.Now.Date) { staffJobupdate.IsValid = false; staffJobadd.IsValid = true; } else { staffJobupdate.IsValid = true; staffJobadd.IsValid = false; } staffJobadd.ValidTime = staffJob.ValidTime; staffJobadd.ChangeType = staffJob.ChangeType; staffJobadd.Remark = staffJob.Remark; staffJobadd.CreaterName = "admin";//后期改为用户名 staffJobadd.CreateTime = DateTime.Now; entities.T_HR_StaffJob.Add(staffJobadd); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "保存成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } } return(r); }