Esempio n. 1
0
        public SelectHelper(string table, string fields, WhereHelper whereHelper, int pageIndex, int pageSize,
            string orderBy)
        {
            string sqlBase = string.Format("select {0} from {1} where {2} ", fields, table, whereHelper.Where);
            const string sqlPageBase = @"select * from(
                            select *,ROW_NUMBER() OVER (ORDER BY {1}) as rank from ({0})a
                          )as t where t.rank between {2} and {3}";

            int startPageIndex = (pageIndex - 1)*pageSize + 1;
            int endPageIndex = pageIndex*pageSize;
            Sql = string.Format(sqlPageBase, sqlBase, orderBy, startPageIndex, endPageIndex);
            WhereHelper = whereHelper;
        }
Esempio n. 2
0
 public DeleteHelper(string table, WhereHelper whereHelper) {
     Table = table;
     this.WhereHelper = whereHelper;
 }
Esempio n. 3
0
 public SelectHelper(string table, int top, string fields, WhereHelper whereHelper)
 {
     Sql = string.Format(sqlTop, top, fields, table, whereHelper.Where);
     WhereHelper = whereHelper;
 }
Esempio n. 4
0
 public SelectHelper(string table, int top, string fields, WhereHelper whereHelper,string orderBy)
 {
     Sql = string.Format(sqlTopOrderBy, top, fields, table, whereHelper.Where, orderBy);
     WhereHelper = whereHelper;
 }
Esempio n. 5
0
 public UpdateHelper(string table, WhereHelper whereHelper, Dictionary<string, dynamic> dicKV)
     : this(table, whereHelper)
 {
     AddUpdateItem(dicKV);
 }