public DataTable GetPayListUser(string Condition) { try { return(SqlMapClient.QueryForDataTable("PatiPayListMap.GetPayListUser", Condition)); } catch (Exception ex) { return(null); } }
public DataTable GetScheDateListByDateAndType(string Condition) { try { IDictionary ht = new Hashtable(); ht["Condition"] = Condition; return(SqlMapClient.QueryForDataTable("ScheItemDateMap.GetScheDateListByDateAndType", ht)); } catch (Exception ex) { return(null); } }
public DataTable GetPayListDetailDay(string Condition, int pageSize, int startIndex, string sortField, string sortOrder) { IDictionary ht = new Hashtable(); int Prev = startIndex * pageSize; int Next = pageSize * (startIndex - 1) + 1; ht["Condition"] = Condition; ht["Prev"] = Prev; ht["Next"] = Next; ht["sortField"] = sortField; ht["sortOrder"] = sortOrder; return(SqlMapClient.QueryForDataTable("PatiPayListMap.GetPayListDetailDay", ht)); }
public DataTable GetPayListOneDay(string Condition, int pageSize, int startIndex) { try { IDictionary ht = new Hashtable(); int Prev = startIndex * pageSize; int Next = pageSize * (startIndex - 1) + 1; ht["Condition"] = Condition; ht["Prev"] = Prev; ht["Next"] = Next; return(SqlMapClient.QueryForDataTable("PatiPayListMap.GetPayListOneDay", ht)); } catch (Exception ex) { return(null); } }
public DataTable GetSatisfactGroupDate(string Condition, int pageSize, int startIndex, string sortField, string sortOrder) { try { IDictionary ht = new Hashtable(); int Prev = startIndex * pageSize; int Next = pageSize * (startIndex - 1) + 1; ht["Condition"] = Condition; ht["Prev"] = Prev; ht["Next"] = Next; ht["sortField"] = sortField; ht["sortOrder"] = sortOrder; return(SqlMapClient.QueryForDataTable("SatisfactionMap.GetSatisfactGroupDate", ht)); } catch (Exception ex) { return(null); } }
public DataTable GetPersonBillMonthAmount(string Condition, int pageSize, int startIndex, string sortField, string sortOrder) { try { IDictionary ht = new Hashtable(); int Prev = startIndex * pageSize; int Next = pageSize * (startIndex - 1) + 1; ht["Condition"] = Condition; ht["Prev"] = Prev; ht["Next"] = Next; ht["sortField"] = sortField; ht["sortOrder"] = sortOrder; return(SqlMapClient.QueryForDataTable("PatiInBillItemMap.GetPersonBillMonthCollect", ht)); } catch (Exception ex) { return(null); } }