viewallorders.aspx.cs

ASP.net+sql server2000编写的完整鲜花在线销售系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace flower.back.order
{
	/// <summary>
	/// viewallorders 的摘要说明。
	/// </summary>
	public class viewallorders : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.WebControls.LinkButton LinkButton4;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Repeater Repeater1;
		private int PageSize=10;
	
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			
			//查看用户是否已经登录
				if(Session["adminlogined"]==null || (string)Session["adminlogined"]!="true")
				{
					Response.Write("<script>alert('您还没有登录，请先登录！');history.back();</script>");
					return;                  
				}


			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
				BindGrid(1);
		}

		private void BindGrid(int RsCount) //参数RsCount表示页数，如：第一页时，其值为1。
		{
			int TotalPage;
		    
			Order myOrder=new Order();
			int TotalRecord=myOrder.GetAllOrderCount();
			
			if ((TotalRecord % PageSize)>0)
			{
				TotalPage=TotalRecord/PageSize +1;
			}
			else
			{
				TotalPage=TotalRecord/PageSize;
			}
			
			DataSet myDS;
			myDS=myOrder.GetAllOrderDS(RsCount,PageSize);
			Repeater1.DataSource=myDS.Tables["myTable"];//DBOP中的重载方法mySelect用的名称是myTable。
			Repeater1.DataBind();


			Label1.Text="当前是第"+RsCount.ToString()+"页";
			Label3.Text=RsCount.ToString();
			Label2.Text="总共"+TotalPage.ToString()+"页";
			Label4.Text=TotalPage.ToString();
			
		}


		private void PageCut_Click(object sender, System.EventArgs e)
		{
			LinkButton lb = (LinkButton)sender;
			String commangArg = lb.CommandArgument.ToString();

			switch(commangArg)
			{    
				case "First":
				{
					//首页
					BindGrid(1);
					break;
				}     
				case "Prev":
				{
					//上一页
					if(int.Parse(Label3.Text)>1)
						BindGrid(int.Parse(Label3.Text)-1);
					break;
				}     
				case "Next":
				{ 
					//下一页
					if(int.Parse(Label3.Text)<int.Parse(Label4.Text))
						BindGrid(int.Parse(Label3.Text)+1);
					break;
				}     
				case "Last":
				{
					//末页
					BindGrid(int.Parse(Label4.Text));
					break;
				}
				default:
				{
					break;
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.LinkButton1.Click += new System.EventHandler(this.PageCut_Click);
			this.LinkButton2.Click += new System.EventHandler(this.PageCut_Click);
			this.LinkButton3.Click += new System.EventHandler(this.PageCut_Click);
			this.LinkButton4.Click += new System.EventHandler(this.PageCut_Click);
			this.Repeater1.ItemCommand += new System.Web.UI.WebControls.RepeaterCommandEventHandler(this.Repeater1_ItemCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Repeater1_ItemCommand(object source, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
		{
			if(e.CommandName=="detail")
			{
				Response.Redirect("orderdetail.aspx?id="+ e.CommandArgument +"&mode=");
			}
			if(e.CommandName=="delete")
			{
				Order myOrder=new Order();
				if(myOrder.DeleteOrderDetail(Convert.ToInt32(e.CommandArgument)))
				{
					//计算现有页数
					int TotalPage;
					int TotalRecord=myOrder.GetAllOrderCount();
			
					if ((TotalRecord % PageSize)>0)
					{
						TotalPage=TotalRecord/PageSize +1;
					}
					else
					{
						TotalPage=TotalRecord/PageSize;
					}
					//以上是计算现有页数

					if(int.Parse(Label3.Text.ToString().Trim())>TotalPage)
					{
						BindGrid(TotalPage);
					}
					else
					{
						BindGrid(int.Parse(Label3.Text.ToString().Trim()));
					}
				}
				myOrder.DeleteOrderItemsDetail(Convert.ToInt32(e.CommandArgument));
			}	
		}
	}
}