testweb.aspx.cs

三层框架结构

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 BusinessLogic;

namespace TestWeb
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class TestWeb : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dgList;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if( !Page.IsPostBack )
			{
				this.DataListBind();
			}
		}

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

		}
		#endregion

		// 绑定函数
		private void DataListBind()
		{
			DataSet ds = new DataSet();
			ds.Tables.Add(new DataTable());
			TestBL testBL = new TestBL();
			testBL.select(null,ds);
			this.dgList.DataSource = ds;
			this.dgList.DataBind();
		}

		private void dgList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if( e.Item.ItemType == ListItemType.Item ||  e.Item.ItemType == ListItemType.AlternatingItem )
			{
				//((Label)e.Item.Cells[0].Controls[1]).Text = Convert.ToInt32(e.Item.ItemIndex+1).ToString();
			}
		}

		private void dgList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if( e.CommandName == "Delete")
			{
				string strSQL = null;
				DataSet ds = new DataSet();
				ds.Tables.Add(new DataTable());
				strSQL = " Likeid = '"+((Label)e.Item.Cells[2].Controls[1]).Text+"'";
				TestBL testBL = new TestBL();
				testBL.SelectForUpdate(strSQL,ds);
				if( ds.Tables.Count > 0)
				{
					if( ds.Tables[0].Rows.Count > 0 )
					{
						for( int i=0;i<ds.Tables[0].Rows.Count;i++)
						{
							ds.Tables[0].Rows[i].Delete();
						}
					
					}
					testBL.Update(ds);
					this.DataListBind();				
				}
			}
			else if( e.CommandName == "Update")
			{
				string strSQL = null;
				DataSet ds = new DataSet();
				ds.Tables.Add(new DataTable());
				strSQL = " Likeid = '"+((Label)e.Item.Cells[2].Controls[1]).Text+"'";
				TestBL testBL = new TestBL();
				testBL.SelectForUpdate(strSQL,ds);
				if( ds.Tables.Count > 0)
				{
					if( ds.Tables[0].Rows.Count > 0 )
					{
						for( int i=0;i<ds.Tables[0].Rows.Count;i++)
						{
							if( ds.Tables[0].Rows[i]["likeid"].ToString() == ((Label)e.Item.Cells[2].Controls[1]).Text)
							{
								ds.Tables[0].Rows[i]["likename"] = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
							}
						}
					}
				}

				testBL.Update(ds);
				this.dgList.EditItemIndex = -1;
				this.DataListBind();	
			}
			else if( e.CommandName == "Cancel")
			{
				
				this.dgList.EditItemIndex = -1;
				this.DataListBind();
			}
			else if( e.CommandName == "Edit")
			{
				this.dgList.EditItemIndex = e.Item.ItemIndex;
				this.DataListBind();
			}
			else if( e.CommandName == "Add")
			{
				string strSQL = null;
				DataSet ds = new DataSet();
				ds.Tables.Add(new DataTable());
				strSQL = " 1 = 2 ";

				TestBL testBL = new TestBL();
				testBL.SelectForUpdate(strSQL,ds);

				DataRow row = ds.Tables[0].NewRow();

				row[0] = testBL.GetPrimaryKey();
				row[1] = "New";
				ds.Tables[0].Rows.Add(row);
				
				testBL.Update(ds);
				this.DataListBind();
			}
		}

		private void dgList_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if( e.Item.ItemType == ListItemType.Item ||  e.Item.ItemType == ListItemType.AlternatingItem )
			{
				//((Label)e.Item.Cells[0].Controls[1]).Text = Convert.ToInt32(e.Item.ItemIndex+1).ToString();
			}
		}
	}
}