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);
}
}