public DataTable ExecProcTable <T>(T entity, string procName, string appendSql) { Type type = entity.GetType(); appendSql += DatabaseCommon.GetQueryWhereString <T>(entity, "T", type, null, true).ToString(); return(db.ExecProcTable(procName, appendSql)); }
public DataTable FindView <T>(T entity, string querySql, string tablename, string orderField, bool isAsc, int pageSize, int pageIndex, out int total) { StringBuilder sb = new StringBuilder(querySql); sb.Append(" WHERE 1=1 "); return(FindTable(DatabaseCommon.GetQueryWhereString(entity, tablename, entity.GetType(), sb).ToString(), orderField, isAsc, pageSize, pageIndex, out total)); }
public DataTable FindView <T>(T entity, string querySql, string tablename) { StringBuilder sb = new StringBuilder(querySql); sb.Append(" WHERE 1=1 "); return(FindTable(DatabaseCommon.GetQueryWhereString(entity, tablename, entity.GetType(), sb).ToString())); }
public DataTable FindFormatView <T>(T entity, string queryFormatSql, string tablename) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(DatabaseCommon.GetQueryWhereString(entity, tablename, entity.GetType(), sb).ToString()); return(FindTable(string.Format(queryFormatSql, sb.ToString()))); }
public DataTable ExecProcTable <T>(T entity, string procName, Pagination pagination, string appendSql) { int total = pagination.records; Type type = entity.GetType(); appendSql += DatabaseCommon.GetQueryWhereString <T>(entity, "T", type, null, true).ToString(); var data = db.ExecProcTable(procName, pagination.sidx, pagination.sord.ToLower() == "asc" ? true : false, pagination.rows, pagination.page, out total, appendSql); pagination.records = total; return(data); }