protected void Page_Load(object sender, EventArgs e)
{
//先判断是POST还是GET
if (IsPostBack)
{
string userName = Request.Form["txtName"];
string userPwd = Request.Form["txtPwd"];
string msg = string.Empty;
DataTable dt = new DataTable();
customerBll customerBll = new customerBll();
if (customerBll.CheckUserInfo(userName, userPwd, out msg, out dt))
{
Session["userName"] = userName;
Response.Redirect("LoginSuccess.aspx");
}
else
{
Msg = msg;
}
Response.Cookies["userName"].Value = userName;
Response.Cookies["userName"].Expires = DateTime.Now.AddDays(3);
}
else
{
if (Session["userName"] != null)
{
Response.Redirect("LoginSuccess.aspx");
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int pageIndex;
if (!int.TryParse(context.Request["pageIndex"], out pageIndex))
{
pageIndex = 1;
}
customerBll customerBll = new customerBll();
int pageCount = customerBll.GetPageCount(10);
pageIndex = pageIndex < 1 ? 1 : pageIndex;
pageIndex = pageIndex > pageCount ? pageCount : pageIndex;
DataTable dt = customerBll.GetPageList(pageIndex, 10);
string str = JsonConvert.SerializeObject(dt);
context.Response.Write(str);
}
protected void AddcustomerInfo()
{
customer customer = new customer();
customer.Name = Context.Request.Form["Name"];
customer.Age = Context.Request.Form["Age"];
customerBll customerBll = new customerBll();
customerBll.AddCustomer(customer);
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
int pageSize = 10;
int pageIndex;
int pageCount;
DataTable dt = new DataTable();
if (!int.TryParse(Context.Request.QueryString["pageIndex"], out pageIndex))
{
pageIndex = 1;
}
customerBll customerBll = new customerBll();
pageCount = customerBll.GetPageCount(pageSize);
pageIndex = pageIndex < 1 ? 1 : pageIndex;
pageIndex = pageIndex > pageCount ? pageCount : pageIndex;
CurrentPageIndex = pageIndex;
PageCount = pageCount;
dt = customerBll.GetPageList(pageIndex, pageSize);
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.AppendFormat("<li>{0}</li>", dt.Rows[i]["Name"]);
}
strHtml = sb.ToString();
sb.Clear();
int startPage = CurrentPageIndex - 5 < 1 ? 1 : CurrentPageIndex - 5;
int endPage = startPage + 9 > pageCount ? pageCount : startPage + 9;
for (int i = startPage; i < endPage; i++)
{
if (i == CurrentPageIndex)
{
sb.AppendFormat("{0}, ", i + 1);
}
else if (i < pageCount - 1)
{
sb.AppendFormat("<a href=customerList.aspx?pageIndex={0}>{0}</a>, ", i + 1);
}
else
{
sb.AppendFormat("<a href=customerList.aspx?pageIndex={0}>{0}</a>", i + 1);
}
}
PageNum = sb.ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string userName = context.Request["name"];
customerBll customerBll = new customerBll();
if (customerBll.GetSingleCustomer(userName).Rows.Count == 0)
{
context.Response.Write("此用户名可以使用！");
}
else
{
context.Response.Write("此用户名已使用,请更换！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Cache["customerInfo"] == null)
{
customerBll customerBll = new customerBll();
Cache.Insert("customerInfo", customerBll.GetAllCustomerInfo(), null, DateTime.Now.AddSeconds(3), TimeSpan.Zero, CacheItemPriority.Normal, RemoveCacheItem);
Response.Write("来自数据库的数据");
}
else
{
Response.Write("来缓存");
//DataTable dt = (DataTable) Cache["customerInfo"];
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ShowEditCustomer();
}
else
{
customer customer = new customer();
customerBll customerBll = new customerBll();
customer.ID = Convert.ToInt32(Context.Request.Form["ID"]);
customer.Name = Context.Request.Form["Name"];
customer.Age = Context.Request.Form["Age"];
customerBll.EditCustomer(customer);
Context.Response.Redirect("customerInfo.aspx");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int id;
if (int.TryParse(context.Request.QueryString["id"], out id))
{
customerBll customerBll = new customerBll();
if (customerBll.DeleteCustomer(id) > 0)
{
context.Response.Redirect("customerInfo.aspx");
}
}
else
{
context.Response.Write("参数错误~！");
}
}
protected void ShowEditCustomer()
{
int id;
if (int.TryParse(Context.Request.QueryString["id"], out id))
{
customerBll customerBll = new customerBll();
dt = customerBll.GetSingleCustomer(id);
if (dt.Rows.Count == 0)
{
Context.Response.Redirect("参数错误！！");
}
}
else
{
Context.Response.Write("参数错误！！");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
customer customer = new customer();
customer.ID = int.Parse(context.Request["txtID"]);
customer.Name = context.Request["txtName"];
customer.Age = context.Request["txtAge"];
customerBll customerBll = new customerBll();
if (customerBll.EditCustomer(customer) > 0)
{
context.Response.Write("YES");
}
else
{
context.Response.Write("NO");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int id = 0;
if (int.TryParse(context.Request["id"], out id))
{
customerBll customerBll = new customerBll();
if (customerBll.DeleteCustomer(id) > 0)
{
context.Response.Write("YES");
}
else
{
context.Response.Write("NO");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
customerBll customerBll = new customerBll();
DataTable dt = customerBll.GetAllCustomerInfo();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.AppendFormat("<tr><td>{0}</td>" +
"<td>{1}</td>" +
"<td>{2}</td>" +
"<td><a href = \"DeleteCustomer.ashx?id={3}\" class = \"delete\">删除</a></td>" +
"<td><a href = EditCustomer.aspx?id={4} class = edit>修改</a></td>" +
"</tr></br>",
dt.Rows[i]["ID"], dt.Rows[i]["Name"], dt.Rows[i]["Age"], dt.Rows[i]["ID"], dt.Rows[i]["ID"]);
}
strHtml = sb.ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int id = 0;
if (int.TryParse(context.Request["id"], out id))
{
customerBll customerBll = new customerBll();
DataTable dt = customerBll.GetSingleCustomer(id);
if (dt.Rows.Count > 0)
{
string str = JsonConvert.SerializeObject(dt);
context.Response.Write(str);
}
else
{
context.Response.Write("NO");
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
customerBll customerBll = new customerBll();
string userName = context.Request["name"];
string userPwd = context.Request["pwd"];
DataTable dt = customerBll.GetSingleCustomer(userName);
if (dt.Rows.Count == 0)
{
context.Response.Write("NO:" + "登录失败");
}
else if (dt.Rows[0]["Age"].ToString() != userPwd)
{
context.Response.Write("NO:" + "用户名或密码错误");
}
else
{
context.Session["userInfo"] = userName;
context.Response.Write("YES:" + "登录成功~~~~");
}
}
//========================================
// Constructor for this class
//========================================
public CustomerView()
{
dataBll = new customerBll();
}