Пример #1
0
 public DataTable GetPayListUser(string Condition)
 {
     try
     {
         return(SqlMapClient.QueryForDataTable("PatiPayListMap.GetPayListUser", Condition));
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
Пример #2
0
 public DataTable GetScheDateListByDateAndType(string Condition)
 {
     try
     {
         IDictionary ht = new Hashtable();
         ht["Condition"] = Condition;
         return(SqlMapClient.QueryForDataTable("ScheItemDateMap.GetScheDateListByDateAndType", ht));
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
Пример #3
0
        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));
        }
Пример #4
0
 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);
     }
 }
Пример #5
0
 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);
     }
 }
Пример #6
0
 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);
     }
 }