/// <summary> /// ACCESS高效分页 /// </summary> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">分页容量</param> /// <param name="strKey">主键</param> /// <param name="showString">显示的字段</param> /// <param name="queryString">查询字符串,支持联合查询</param> /// <param name="whereString">查询条件,若有条件限制则必须以where 开头</param> /// <param name="orderString">排序规则</param> /// <param name="pageCount">传出参数:总页数统计</param> /// <param name="recordCount">传出参数:总记录统计</param> /// <returns>装载记录的DataTable</returns> public static DataTable ExecutePager(int pageIndex, int pageSize, string strKey, string showString, string queryString, string whereString, string orderString, out int pageCount, out int recordCount) { if (pageIndex < 1) { pageIndex = 1; } if (pageSize < 1) { pageSize = 10; } if (string.IsNullOrEmpty(showString)) { showString = "*"; } if (string.IsNullOrEmpty(orderString)) { orderString = strKey + " asc "; } using ( CDBAccess cn = new CDBAccess(System.Configuration.ConfigurationSettings.AppSettings["OledbStr"])) { string myVw = string.Format(" ( {0} ) tempVw ", queryString); string sql111 = string.Format(" select count(*) as recordCount from {0} {1}", myVw, whereString); recordCount = Convert.ToInt32(cn.ExecScalar(sql111)); if ((recordCount % pageSize) > 0) { pageCount = recordCount / pageSize + 1; } else { pageCount = recordCount / pageSize; } string sql; if (pageIndex == 1)//第一页 { sql = string.Format("select top {0} {1} from {2} {3} order by {4} ", pageSize, showString, myVw, whereString, orderString); } else if (pageIndex > pageCount)//超出总页数 { sql = string.Format("select top {0} {1} from {2} {3} order by {4} ", pageSize, showString, myVw, "where 1=2", orderString); } else { int pageLowerBound = pageSize * pageIndex; int pageUpperBound = pageLowerBound - pageSize; string recordIDs = recordID(string.Format("select top {0} {1} from {2} {3} order by {4} ", pageLowerBound, strKey, myVw, whereString, orderString), pageUpperBound); sql = string.Format("select {0} from {1} where {2} in ({3}) order by {4} ", showString, myVw, strKey, recordIDs, orderString); } using (DataTable dt = cn.ExecQuery(sql)) { return(dt); } } }
/// <summary> /// 动漫app由9miao社团研发,如有问题请登陆http://www.9miao.com/官网 /// </summary> /// public void ProcessRequest(HttpContext context) { CallBackJson json = new CallBackJson(); jsonClass jclass = new jsonClass(); jclass.Status = "Error"; jclass.Msg = "服务器异常"; try { string _id = context.Request.Form["id"]; //小分类id string _name = context.Request.Form["name"]; //小分类名称 string _type = context.Request.Form["type"]; //类型 0修改 1添加 if (string.IsNullOrEmpty(_name.Trim())) { throw new Exception("信息参数未空"); } using ( CDBAccess cn = new CDBAccess(System.Configuration.ConfigurationSettings.AppSettings["OledbStr"])) { if (_type == "0") { cn.ExecSQL(@"UPDATE T0001 SET C00006=? WHERE C00004=?", new OleDbParameter[] { new OleDbParameter("@C00003", _name), new OleDbParameter("@C00001", _id) }); jclass.Msg = "恭喜你!修改分类成功"; } else { string systemid = cn.ExecScalar(@"select max(Val(C00004))+1 from T0001 where C00101 <> 6 ").ToString(); if (string.IsNullOrEmpty(systemid)) { systemid = "1"; } cn.ExecSQL(@"INSERT INTO T0001 (C00004,C00005,C00006,C00101) VALUES (?,?,?,?)", new OleDbParameter[] { new OleDbParameter("@C00004", systemid), new OleDbParameter("@C00005", ""), new OleDbParameter("@C00006", _name), new OleDbParameter("@C00101", _id) }); jclass.Msg = "恭喜你!添加分类成功"; } jclass.Status = "Success"; } } catch (Exception ex) { jclass.Msg = ex.Message; } context.Response.Write(json.Serializer(jclass)); }