//查询通过审批的所有申请单 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]); }