//按部门查询
public static DataTable Work2(Entity.Department dp)
{
string sqlstr = "select WID,PName,Work.PID,Wtime,WState,DepName from Work,Person,Department,Job where Person.PID=Work.PID and Person.JID=Job.JID and Job.DepID=Department.DepID and Department.DepID='" + dp.depID + "' ";
DataTable dt1 = DBHelper.GetDT(sqlstr);
return(dt1);
}
//按部门查询
public static DataTable LeaveDep(Entity.Department dp)
{
string sqlstr = "select LID,Leave.PID,PName,LWhy,LStart,LStop,LBoss,Lstate from Leave,Person,Department,Job where Person.PID=Leave.PID and Person.JID=Job.JID and Job.DepID=Department.DepID and Department.DepID='" + dp.depID + "' ";
DataTable dt1 = DBHelper.GetDT(sqlstr);
return(dt1);
}
/// <summary>
/// 删除部门的方法
/// </summary>
/// <param name="DDPL"></param>
/// <returns></returns>
public static bool DDPL(Entity.Department DDPL)
{
string sql = string.Format("delete from Department where DepID='{0}'", DDPL.depID);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加部门的方法
/// </summary>
/// <param name="DPL"></param>
/// <returns></returns>
public static bool ADPL(Entity.Department DPL)
{
string sql = string.Format("insert into Department values('{0}')", DPL.depName);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改部门的方法
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static bool DPL(Entity.Department DPL)
{
string sql = string.Format("update Department set DepName='{0}'where DepID='{1}'", DPL.depName, DPL.depID);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}