//显示岗位名称 public static string JobJName(Entity.Person pr) { string sqlstr = "select JName from Job,Department,Person where Job.DepID=Department.DepID and Person.JID=Job.JID and PID='" + pr.pID + "'"; string name = DBHelper.GetScalar(sqlstr).ToString(); return(name); }
//修改信息 public static bool JobUPDATE(Entity.Person pr) { string sqlstr = "update Person set JID='" + pr.jID + "' where PID='" + pr.pID + "'"; int i = DBHelper.GetLine(sqlstr); if (i > 0) { return(true); } else { return(false); } }
/// <summary> /// 加载请假记录 /// </summary> /// <param name="p"></param> /// <returns></returns> public static DataTable LoadLeave(Entity.Person p) { return(EDAL.WorkDAL.LoadLeave(p)); }
//修改信息 public static bool JobUPDATE(Entity.Person pr) { return(DAL.JobChangeDAL.JobUPDATE(pr)); }
//显示岗位名称 public static string JobJName(Entity.Person pr) { return(DAL.JobChangeDAL.JobJName(pr)); }