//查询通过审批的所有申请单
public static DataTable getAllOtPass()
{
Query q = OverTime.Query();
q.AddWhere(OverTime.Columns.IsSubmit, "通过");
return(q.ExecuteDataSet().Tables[0]);
}
public static DataTable getOverTime(string emName)
{
Query q = OverTime.Query();
q.AddWhere(OverTime.Columns.ApplyEmName, emName);
return(q.ExecuteDataSet().Tables[0]);
}
public static DataTable getAllApproveOvertime()
{
Query q = OverTime.Query();
q.AddWhere(OverTime.Columns.IsSubmit, "待审");
q.OR(OverTime.Columns.IsSubmit, "通过");
q.OR(OverTime.Columns.IsSubmit, "未通过");
return(q.ExecuteDataSet().Tables[0]);
}