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