dp_check1.aspx.cs

b to b 模式 电子商务系统

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;
using System.Configuration;
using System.Data.SqlClient;
namespace B2Bsite
{
	/// <summary>
	/// 仓库里的商品
	/// </summary>
	public class DP_Check1 : System.Web.UI.Page
	{
        protected System.Web.UI.HtmlControls.HtmlForm Form2;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Label1;

		protected System.Web.UI.WebControls.Label lblCurPage;
		protected System.Web.UI.WebControls.Label lblEachPage;
		protected System.Web.UI.WebControls.Label lblTnum;
		protected System.Web.UI.WebControls.HyperLink lnkFirst;
		protected System.Web.UI.WebControls.HyperLink lnkPrev;
		protected System.Web.UI.WebControls.HyperLink lnkNext;
		protected System.Web.UI.WebControls.HyperLink lnkLast;
		protected System.Web.UI.WebControls.TextBox txtPage;
		protected System.Web.UI.WebControls.Button btnPage;
	
		public static int TotalPage;//定义变量来保存总页数
		public int CurPage;//定义变量来保存当前页索引
		public int Tnum;//总条数;
		public int EachPage;//每页总条数	
		
		public string username;
		public string fangshi;
		public string n;
		public string productstore;

		private void Page_Load(object sender, System.EventArgs e)
		{
            if( Session["username"] == null )
            {
                Response.Write ("<script language='JavaScript'>");
                Response.Write ("alert('请先登录！')");
                Response.Write ("</script>");
                Response.End();
                return;
            }

			n="1";
			if(!Page.IsPostBack)
			{
				productstore=Session["username"].ToString();
				SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
				string sql="select * from Products where ProductState="+n+" And UserName='"+productstore+"'";
				/*
				SqlCommand command=new SqlCommand(sql,connection);
				connection.Open();
				SqlDataReader dr=command.ExecuteReader();
				*/

				SqlDataAdapter da=new SqlDataAdapter(sql,connection);
				DataSet ds=new DataSet();
				da.Fill(ds,"Table");
				
				PagedDataSource objPage=new PagedDataSource();//创建分页类
				objPage.DataSource=ds.Tables["Table"].DefaultView;//设置数据源

				objPage.AllowPaging=true;
				objPage.PageSize=10;

				if(Request.QueryString["Page"]!=null)
				{
					CurPage=Convert.ToInt32(Request.QueryString["Page"]);
					CurPage=Math.Min(CurPage,objPage.PageCount);
					CurPage=Math.Max(CurPage,1);
				}
				else
					CurPage=1;
				objPage.CurrentPageIndex=CurPage-1;
				TotalPage=objPage.PageCount;
				Tnum=objPage.DataSourceCount;
				EachPage=objPage.Count;
				lblCurPage.Text="第 "+CurPage.ToString()+" / "+TotalPage.ToString()+" 页";
				lblTnum.Text="共: " +Tnum+" 条记录";
				lblEachPage.Text="每页有: "+EachPage.ToString()+" 条记录";
			
				if(objPage.CurrentPageIndex!=0)
					lnkFirst.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(1);
				if(objPage.CurrentPageIndex!=TotalPage-1)
					lnkLast.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(TotalPage);
			
				if(!objPage.IsFirstPage)
					lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(CurPage-1);
				if(!objPage.IsLastPage)
					lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(CurPage+1);

				DataGrid1.DataSource=objPage;
				DataGrid1.DataBind();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			this.btnPage.Click += new System.EventHandler(this.btnPage_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		public void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		public void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string id=e.Item.Cells[0].Text;
			productstore=Session["username"].ToString();
			string sql="delete from Products where ProductId="+id;
			SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
			SqlCommand command=new SqlCommand(sql,connection);
			connection.Open();
			command.ExecuteNonQuery();

			sql="select * from Products where ProductState="+n+" And UserName='"+productstore+"'";
			command=new SqlCommand(sql,connection);
			SqlDataReader dr=command.ExecuteReader();
			DataGrid1.DataSource=dr;
			DataGrid1.DataBind();
		}
		
		public void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string id=e.Item.Cells[0].Text;
			productstore=Session["username"].ToString();
			string sql="update Products set ProductState=0 where ProductId="+id;
			SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
			SqlCommand command=new SqlCommand(sql,connection);
			connection.Open();
			command.ExecuteNonQuery();

			sql="select * from Products where ProductState="+n+" And UserName='"+productstore+"'";
			command=new SqlCommand(sql,connection);
			SqlDataReader dr=command.ExecuteReader();
			DataGrid1.DataSource=dr;
			DataGrid1.DataBind();
		}

		public void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string id=e.Item.Cells[0].Text;
			productstore=Session["username"].ToString();
			string sql="select * from Products where ProductId="+id;
			SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
			SqlCommand command=new SqlCommand(sql,connection);
			connection.Open();
			DataGrid1.EditItemIndex=e.Item.ItemIndex;
			sql="select * from Products where ProductState="+n+" And UserName='"+productstore+"'";
			command=new SqlCommand(sql,connection);
			SqlDataReader dr=command.ExecuteReader();
			DataGrid1.DataSource=dr;
			DataGrid1.DataBind();
		}
		public void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string id=e.Item.Cells[0].Text;
			string sql="select * from Products where ProductId="+id;
			SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
			SqlCommand command=new SqlCommand(sql,connection);
			connection.Open();
			SqlDataReader dr=command.ExecuteReader();
			if(dr.Read())
			{
                Response.Redirect("product_modify.aspx?id="+id+"&msg="+Server.UrlEncode("DP_Check1.aspx"));
                //string strScrip="<script>";
				//strScrip += "windows.open('product_modify.aspx?id="+id+"')";
                //strScrip +="open('index.htm','NewWindow','toolbar=no,location=no,";
                //strScrip +="directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=yes,width=400,height=260')";
                //strScrip += "</scrip>";
                //Response.Write(strScrip);
                
			}

		}
		private void Button1_Click(object sender, System.EventArgs e)
		{
			username=TextBox1.Text;
			if(username.Equals(""))
			{
				Response.Write("<script	language='JavaScript'>");
				Response.Write("alert('请输入关键字')");
				Response.Write("</script>");
			
			}
			else
			{
				productstore=Session["username"].ToString();
				SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
				string sql="Select * From Products Where ProductName Like '%" + username + "%' And ProductState="+n+" And ProductStore='"+productstore+"'";
				SqlCommand command=new SqlCommand(sql,connection);
				connection.Open();
				SqlDataReader dr=command.ExecuteReader();
		
				if(!dr.Read())
				{
					Response.Write("<script	language='JavaScript'>");
					Response.Write("alert('！！该记录不存在！！')");
					Response.Write("</script>");
					return;
				}
				dr.Close();
				sql="Select * From Products Where ProductName Like '%" + username + "%' And ProductState="+n+" And ProductStore='"+productstore+"'";
				command=new SqlCommand(sql,connection);
				dr=command.ExecuteReader();
				DataGrid1.DataSource=dr;
				DataGrid1.DataBind();
                dr.Close();
                connection.Close();
			}
		}

		private void btnPage_Click(object sender, System.EventArgs e)
		{
			int PageNum=0;
			if( !Request.Form["txtPage"].Equals("") )
				PageNum=Convert.ToInt32(Request.Form["txtPage"]);
			if(PageNum<=0 || PageNum>TotalPage)
				Response.Redirect(Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(1));
			else
				Response.Redirect(Request.CurrentExecutionFilePath+"?Page="+Convert.ToString(PageNum));
		}
	}
}