//显示岗位名称
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));
}
