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