bmsx.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;

namespace ais.App.jcda.hpsx
{
	/// <summary>
	/// bmsx 的摘要说明。
	/// </summary>
	public class bmsx : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dg;

		private void BindGrid()
		{
			DAL.BianMSXDAL bmsxDAL = new ais.DAL.BianMSXDAL();
			dg.DataSource=bmsxDAL.GetAllBMSX();
			dg.DataBind();	
		}

	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(IsPostBack==false)
			{
				BindGrid();
			}
		}

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

		}
		#endregion

		private void dg_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem)
			{
				LinkButton lb = (LinkButton)e.Item.Cells[4].FindControl("lbDelete");
				lb.Attributes.Add("onClick","javascript:return window.confirm('是否要删除？');");
			}
		}

		private void dg_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			dg.EditItemIndex=e.Item.ItemIndex;
			dg.ShowFooter=false;

			BindGrid();
		}

		private void dg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string csStr=string.Empty;
			string item=dg.DataKeys[e.Item.ItemIndex] as string;

			DAL.BianMSXDAL bmsxDAL=new ais.DAL.BianMSXDAL();
			try
			{
				bmsxDAL.DeleteBMSX(item);
				csStr=@"<script language='javascript'>alert('删除成功["+item+"]');</script>";
			}
			catch(ObjectHasBeenUsedException)
			{
				csStr=@"<script language='javascript'>alert('已被使用不能删除["+item+"]');</script>";
			}
			
			BindGrid();

			
			Page.RegisterStartupScript("delete",csStr);
		}

		private void dg_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="addnew")
			{
				string item = ((TextBox)e.Item.Cells[0].FindControl("item")).Text;
				string name = ((TextBox)e.Item.Cells[1].FindControl("name")).Text;
				string sort = ((TextBox)e.Item.Cells[2].FindControl("sort")).Text;
				string msg=string.Empty;
				try
				{
					if(item.Trim().Length!=1) throw new ApplicationException("编码只能是一位");
					if(name.Trim().Length<=0) throw new ApplicationException("必须填息名称");
					if(sort.Trim().Length!=1) throw new ApplicationException("排序只能是一位");

					DAL.BianMSXDAL bmsxDAL=new ais.DAL.BianMSXDAL();
				
					bmsxDAL.InsertBMSX(item,name,sort);
					msg="保存成功";
				}
				catch(KeyHasExistException)
				{
					msg="编码已经存在";
				}
				catch(ApplicationException ex)
				{
					msg=ex.Message;
				}
				
				BindGrid();
				
				Page.RegisterStartupScript("addnew",@"<script language='javascript'>alert('"+msg+"');</script>");
			}
		}

		private void showCommand(string msg,DataGridCommandEventArgs e)
		{
			Response.Write(msg+"<br/>");
			Response.Write(e.Item.ItemIndex.ToString()+"<br/>");
			Response.Write(e.CommandSource.GetType().FullName+"<br/>");
			Response.Write(e.CommandName+"<br/>");
			Response.Write(e.CommandArgument+"<br/>");
		}

		private void dg_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			dg.EditItemIndex = - 1;
			dg.ShowFooter=true;

			BindGrid();
		}

		private void dg_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string item = ((Label)e.Item.Cells[0].FindControl("item")).Text;
			string name = ((TextBox)e.Item.Cells[1].FindControl("name")).Text;
			string sort = ((TextBox)e.Item.Cells[2].FindControl("sort")).Text;
			
			DAL.BianMSXDAL bmsxDAL=new ais.DAL.BianMSXDAL();
			bmsxDAL.UpdateBMSX(item,name,sort);
			
			dg.EditItemIndex=-1;
			dg.ShowFooter=true;

			BindGrid();

			string csStr=@"<script language='javascript'>alert('更新成功');</script>";
			Page.RegisterStartupScript("update",csStr);
		}
	}
}