public static DataSet GetUserList(string field, string where)
{
return(DataHelper.GetList("Usertable", field, where));
}
public static DataSet GetFieldList(string field, string where)
{
return(DataHelper.GetList("Field", field, where));
}
public static DataSet GetReadCaseUsersList(string field, string where)
{
return(DataHelper.GetList("ReadCaseUsers", field, where));
}
public static DataSet GetAlertList(string where)
{
return(DataHelper.GetList("Alerttable", where));
}
public DataSet GetTypeDataListByTypeID(string typeid)
{
return(DataHelper.GetList(this.TableName, "TypeID=" + typeid));
}
public static DataSet GetGroupList(string field, string where)
{
return(DataHelper.GetList("GroupTable", field, where));
}
public static DataSet GetLeaveList(string field, string where)
{
return(DataHelper.GetList("LeaveManagement", field, where));
}
public static DataSet GetNoteList(string field, string where)
{
return(DataHelper.GetList("NoteTable", field, where));
}
public static DataSet GetCaseTypeDataList(string where)
{
return(DataHelper.GetList("CaseTypeData", where));
}
public static DataSet GetReportMessageList(string where, string order)
{
string sql = "select sender, recipient,senton,title,body, id from Messagetable where {0} {1}";
return(DataHelper.GetList(string.Format(sql, where, order)));
}
public static DataSet GetOpenedCaseList(string field, string where)
{
return(DataHelper.GetList("OpenedCase", field, where));
}
public DataSet GetCaseList(string field, string where, string orderStr)
{
return(DataHelper.GetList(this.TableName, field, where, orderStr));
}
public DataSet GetCaseList(string where)
{
return(DataHelper.GetList(this.TableName, where));
}
public static DataSet GetLeadID(string userID, string CompanyID)
{
string where = "id in (select groupID from companyuser where companyID={0} and userID={1})";
where = string.Format(where, CompanyID, userID);
return(DataHelper.GetList("GroupTable", "LeadID", where));
}
public DataSet GetPaymentList(string field, string where)
{
return(DataHelper.GetList(this.TableName, field, where));
}
public static DataSet GetPatchList(string field, string where)
{
return(DataHelper.GetList("Patch", field, where));
}
public static DataSet GetCaseTypeList(string field, string where)
{
return(DataHelper.GetList("CaseType", field, where));
}
public static DataSet GetCompanyList(string field, string where)
{
return(DataHelper.GetList("Companytable", field, where));
}
