public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/html"; AdminHelper.CheckLogin(); int pageNum = 1; if (context.Request["PageNum"] != null) { pageNum = Convert.ToInt32(context.Request["PageNum"]); } DataTable productCategories = SqlHelper.ExecuteDataTable(@"select * from (select *,row_number() over (order by Id asc) as num from T_ProductCategories) as t where t.num between @Start and @End", new SqlParameter("@Start", (pageNum - 1) * 10 + 1), new SqlParameter("@End", pageNum * 10)); int totalCount = (int)SqlHelper.ExecuteScalar("select count(1) from T_ProductCategories"); int pageCount = (int)Math.Ceiling(totalCount / 10.0); object[] pageData = new object[pageCount]; for (int i = 0; i < pageCount; i++) { pageData[i] = new { Href = string.Format("ProductCategoryList.ashx&PageNum={0}", i + 1), Title = "第" + (i + 1) + "页" }; } var data = new { Title = "产品类别列表", ProductCategories = productCategories.Rows, PageData = pageData }; string html = CommonHelper.RenderHtml("Admin/ProductCategoryList.html", data); context.Response.Write(html); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/html"; AdminHelper.CheckLogin(); bool isPostback = !string.IsNullOrEmpty(context.Request["IsPostback"]); if (isPostback) { string siteName = context.Request["SiteName"]; string siteURL = context.Request["SiteURL"]; string address = context.Request["Address"]; string postCode = context.Request["PostCode"]; string contactPerson = context.Request["ContactPerson"]; string telPhone = context.Request["TelPhone"]; string fax = context.Request["Fax"]; string mobile = context.Request["Mobile"]; string email = context.Request["Email"]; CommonHelper.WriteSetting("SiteName", siteName); CommonHelper.WriteSetting("SiteURL", siteURL); CommonHelper.WriteSetting("Address", address); CommonHelper.WriteSetting("PostCode", postCode); CommonHelper.WriteSetting("ContactPerson", contactPerson); CommonHelper.WriteSetting("TelPhone", telPhone); CommonHelper.WriteSetting("Fax", fax); CommonHelper.WriteSetting("Mobile", mobile); CommonHelper.WriteSetting("Email", email); context.Response.Write("保存成功!"); } else { var data = new { Title = "系统配置", Settings = CommonHelper.GetSettings() }; string html = CommonHelper.RenderHtml("Admin/Settings.html", data); context.Response.Write(html); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/html"; AdminHelper.CheckLogin(); int pageNum = string.IsNullOrEmpty(context.Request["PageNum"]) ? 1 : Convert.ToInt32(context.Request["PageNum"]); DataTable sysUsers = SqlHelper.ExecuteDataTable(@"select * from (select *,ROW_NUMBER() over (order by Id asc) as num from T_SysUsers) t where t.num between @Start and @End", new SqlParameter("@Start", (pageNum - 1) * 5 + 1), new SqlParameter("@End", pageNum * 5)); int totalCount = (int)SqlHelper.ExecuteScalar("select count(1) from T_SysUsers"); int pageCount = (int)Math.Ceiling(totalCount / 5.0); object[] pageData = new object[pageCount]; for (int i = 0; i < pageCount; i++) { pageData[i] = new { Href = "SysUsersList.ashx?PageNum=" + (i + 1), Title = "第" + (i + 1) + "页" }; } var data = new { Title = "系统用户管理", SysUsers = sysUsers.Rows, PageData = pageData }; string html = CommonHelper.RenderHtml("Admin/SysUsersList.html", data); context.Response.Write(html); }