bommodweb.aspx.cs

可供共享学习.net环境下生产管理的实现

		//		private void grid_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		//		{
		//			this.grid.SelectedIndex=-1;
		//			Common.SortGrid(grid,e.SortExpression.ToString());		
		//			this.BindGrid();
		//		}
		//
		//		private void grid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		//		{
		//			grid.CurrentPageIndex=e.NewPageIndex;
		//			BindGrid();
		//		}
		//
		//		private void grid_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		//		{
		//			grid.SelectedIndex = e.Item.ItemIndex;
		//			string id = grid.DataKeys[e.Item.ItemIndex].ToString();
		//			if(id!="")
		//			{
		//				Custom custom=new Custom();
		//				custom.Id=id;
		//				custom.Retrieve();
		//				this.SetFormBy (custom);
		//				this.InitButton(false);
		//			}
		//		}

		private void SetFormBy(Custom c)
		{
			this.txtId.Text = c.Id;
			this.txtCode.Text = c.Code;
			this.txtCodeHide.Text =c.Code;
			
		
			this.lblInsertDate.Text = c.InsertDate.ToString();
			this.lblInsertOperater.Text = c.InsertOperater.ToString();
			
			//Common.SelectFlg (this.cboQuality ,aProvider.Quality.ToString ());
		}

			public void DeleteRecord(BOM b)
		{
				try
				{
					BOMSystem.DeleteBOM(b.Id);
				}
				catch(LeaseException exp)
				{
					if(exp.ErrorType==LeaseExceptionType.RestrictException)
					{
						this.lblMessage.Text="失败：删除记录遇到错误,记录已经不存在";
						this.lblMessage.Visible=true;
					}
					else
					{
						throw exp;
					}
				
			}

			this.lblMessage.Text ="成功：删除记录成功";
			this.lblMessage.Visible=true;
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			string id=this.txtId.Text.Trim();
			if(id!="")
			{

				BOM b=new BOM();
				b.Id=id;
				this.DeleteRecord(b);
				//				this.InitAdd();
				//				this.BindGrid ();
			}
		}

		private void btnUpdate_Click(object sender, System.EventArgs e)
		{
			if(!Common.CheckMultTextBox(this.txtRemark,this.lblMessage,"失败：BOM备注只允许100个字符之内",100)) return;
			BOM b=new BOM();
			b.IsPersistent=true;
			BindAttribute(b);
			
			if(!BOMSystem.CheckBOMIsUnique(b) && this.txtCodeHide.Text.Trim()!=this.txtCode.Text.Trim())
			{
				this.lblMessage.Text ="失败：成品编号已经存在,请确保唯一";
				this.lblMessage.Visible=true;
			}
			else
			{
				DataTable dt=(DataTable)this.ViewState["BOMLine"];
				dt.AcceptChanges();
				BOMSystem.SaveBOM(b,dt);
				this.lblMessage.Text="成功：更新记录成功";
				this.lblMessage.Visible=true;
			}
		
		}

		private void ListBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.BindAttribute(this.lstMateriel.SelectedItem.Value);

		}

		private void BindAttribute(string id)
		{
			Materiel m=new Materiel();
			m.Id=id;
			m.Retrieve();
			if(m.IsPersistent)
			{
				this.txtMId.Text = id;
				this.txtMCode.Text = m.Code;
				Common.SelectFlg(this.ddlUnit,m.Unit);
				
			}
            
			
		}

		private void ddlMaterielCat_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataTable dtMater=MaterielSystem.AllMateriel(this.ddlMaterielCat.SelectedItem.Value,"","Y");
			ListBox lc=this.lstMateriel;
			lc.Items.Clear();
			foreach(DataRow myRow in dtMater.Rows)
			{
				lc.Items.Add(new ListItem("["+myRow[Materiel.CODE].ToString()+"]"+Common.GetLeftString(myRow[Materiel.DESCRIPTION].ToString(),20),myRow[Materiel.ID].ToString()));
			}
			lc.DataBind();
			//Common.BindDrop(this.lstMateriel,dtMater,Materiel.CODE,Materiel.ID);
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if(this.txtMId.Text.Trim()=="")
			{
				this.lblMessage.Text ="请选择要添加的物料";
				this.lblMessage.Visible=true;
				return;
			}
			if(this.txtMQ.Text=="")
			{
				this.lblMessage.Text ="请输入所需物料的数量";
				this.lblMessage.Visible=true;
				return;
			}
			string Mid=this.txtMId.Text.Trim();
			if(Mid!="")
			{
				bool haveit=false;
				DataTable dtBOMLine=(DataTable)this.ViewState["BOMLine"];
				dtBOMLine.AcceptChanges();
				foreach(DataRow d in dtBOMLine.Rows)
				{
					if(d[BOMLine.MATERIELID].ToString()==Mid)
					{
						d[BOMLine.QUANTITY]=double.Parse(this.txtMQ.Text.Trim());
						d[BOMLine.UNITID]=this.ddlUnit.SelectedItem.Value;
						d[BOMLine.PERCENT]=this.ddlPercent.SelectedItem.Value;
						d[BOMLine.DEFAULTUSE]=this.chkUse.Checked?"Y":"N";
						haveit=true;
					}
				}
				if(!haveit)
				{
					DataRow dr=dtBOMLine.NewRow();
					dr[BOMLine.BOMID]=Mid;
					dr[BOMLine.FLAG]="Y";
					dr[BOMLine.ID]=LoginSystem.GetTableId("BOMLine");
					dr[BOMLine.LINE]=dtBOMLine.Rows.Count+1;
					dr[BOMLine.MATERIELID]=this.txtMId.Text;
					dr[BOMLine.PERCENT]=this.ddlPercent.SelectedItem.Value;
					dr[BOMLine.QUANTITY]=double.Parse(this.txtMQ.Text.Trim());
					dr[BOMLine.UNITID]=this.ddlUnit.SelectedItem.Value;
					dr[BOMLine.DEFAULTUSE]=this.chkUse.Checked?"Y":"N";
					dtBOMLine.Rows.Add(dr);
				}

				this.BindBOMLine(dtBOMLine);

//				this.ViewState["BOMLine"]=dtBOMLine;
//				Common.ReSet(this.grid,dtBOMLine.DefaultView);
//				grid.DataSource=dtBOMLine.DefaultView;
//				grid.DataBind();
				
//				ListItem li = new ListItem ();
//				li.Text=this.txtMCode.Text.Trim() + " " + this.txtMQ.Text.Trim() + " " +this.ddlUnit.SelectedItem.Text.Trim() +" "+ this.ddlPercent.SelectedItem.Text.Trim() ;
//				li.Value =  Mid + " " + this.txtMQ.Text.Trim() + " " +this.ddlUnit.SelectedItem.Value.Trim() +" "+ this.ddlPercent.SelectedItem.Value.Trim() ;
//				this.lstBOMLine.Items.Add(li);
			}
		}

		private void BindBOMLine(DataTable dtBOMLine)
		{
			this.ViewState["BOMLine"]=dtBOMLine;
			Common.ReSet(this.grid,dtBOMLine.DefaultView);
			grid.DataSource=dtBOMLine.DefaultView;
			grid.DataBind();
		}

		private void lstBOMLine_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.BindAttribute(this.lstMateriel.SelectedItem.Value);
		}

		private void grid_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			
			string id = grid.DataKeys[this.grid.SelectedIndex].ToString();
			if(id!="")
			{
				DataTable dt=(DataTable)this.ViewState["BOMLine"];
				dt.AcceptChanges();
				DataRow dr=dt.Rows[this.grid.SelectedIndex];
                this.txtMId.Text = dr[BOMLine.MATERIELID].ToString();
				this.txtMQ.Text = dr[BOMLine.QUANTITY].ToString();
				Common.SelectFlg(this.ddlUnit,dr[BOMLine.UNITID].ToString());
				Common.SelectFlg(this.ddlPercent,dr[BOMLine.PERCENT].ToString());
				Materiel m=new Materiel();
				m.Id=this.txtMId.Text;
				m.Retrieve();
				this.txtMCode.Text =m.Code;
				this.chkUse.Checked=true;
				this.chkUse.Checked=dr[BOMLine.DEFAULTUSE].ToString()=="Y"?true:false;
				
			}
		}

		private void grid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem)
			{
				e.Item.Cells[1].Text = MaterielSystem.GetMaterielCode(e.Item.Cells[1].Text.Trim());
				e.Item.Cells[3].Text = UnitSystem.GetUnitCode(e.Item.Cells[3].Text.Trim());
				e.Item.Cells[4].Text +="%";
			}
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			if(this.grid.SelectedIndex!=-1)
			{
				DataTable dt=(DataTable)this.ViewState["BOMLine"];
                dt.AcceptChanges();
				dt.Rows[this.grid.SelectedIndex].Delete();
				this.clearLine();
				this.BindBOMLine(dt);
			}
			else
			{
				this.lblMessage.Text ="请选择要取消的物料";
				this.lblMessage.Visible=true;
			}
		}

		private void clearLine()
		{
			this.txtMId.Text="";
			this.txtMCode.Text="";
			this.txtMQ.Text="";
			this.ddlUnit.SelectedIndex=0;
			this.ddlPercent.SelectedIndex=0;
			this.chkUse.Checked=true;
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			DataTable dt=(DataTable)this.ViewState["BOMLine"];
			dt.AcceptChanges();
			dt.Rows.Clear();
			this.clearLine();
			this.BindBOMLine(dt);
		}

		private void btnGoBack_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("BOMWeb.aspx",true);
		}

		private void txtBOMCode_TextChanged(object sender, System.EventArgs e)
		{
			string code=this.txtBOMCode.Text;
			if(code!="")
			{
				Materiel m=MaterielSystem.GetMaterielByCode(code);
				if(m==null)
				{
					clearLine();
					this.lblMessage.Text ="你输入的物料编号存在";
					this.lblMessage.Visible=true;
					return;

				}
				else
				{
					this.BindAttribute(m.Id);
				}
			}
			

		}

	

	
	}
}