jiagong.cs

这是自己曾经参与开发的轻纺管理系统B/S版,有一定的研究价值!

using System;
using WebBase;
using System.Data;
using System.Web.UI.WebControls;

namespace TextileManager {
	/// <summary>管理[加工表]</summary>
	public class JiaGong : TableDefinition {
		#region TableDefinition
		public override string TableName { get{return "加工表";} }
		public override WebControl GetEditControl(System.Data.DataColumn dc) {
			switch (dc.ColumnName) {
				case "加工厂": return new KeShang.DropDownList("加工厂");
				case "货号": return new YongLiaoBiLi.DropDownList();
				case "经手人": return new YuanGong.DropDownList();
				case "收货仓库": return new KeShang.DropDownList("仓库");
				default: return base.GetEditControl (dc);
			}
		}
		public override DataGridColumn GetDataGridColumn(System.Data.DataColumn dc) {
			switch (dc.ColumnName) {
				case "经手人": return base.GetDataGridColumn(dc,new GsDropDownListColumn(new YuanGong.DropDownList()));
				default: return base.GetDataGridColumn (dc);
			}
		}
		#endregion

		#region class zhibu 管理加工表
		/// <summary>管理加工表</summary>
		public class ZhiBu : JiaGong	{	
				
			public override string TableName { get{return "加工表";}}
			public override WebControl GetEditControl(System.Data.DataColumn dc){
				switch (dc.ColumnName){
				//case "货号": return new HuoHao.DropDownList();
				default: return base.GetEditControl (dc);
				}
			}
			public override void CreateControlsForAppend(BaseAppendPage page) {
				page.CreateTitle("织布记录"); 
				page.CreateControls("日期","加工厂","货号");
				page.CreateAppendButton();
				page.CreateBrowseButton();
			}
			public override void CreateControlsForBrowse(BaseBrowsePage page){
				page.CreateTitle("浏览织布记录");
				page.CreateAppendButton();
				page.CreateQueryButton();
			}
			
		}
		#endregion

		#region class Ranse 管理加工染色表
		/// <summary>管理加工染色表</summary>
		public class RanSe1 : TableDefinition	{	
				
			public override string TableName { get{return "加工染色表";}}
			public override WebControl GetEditControl(System.Data.DataColumn dc){
				switch (dc.ColumnName){
				case "货号": return new HuoHao.DropDownList("胚布");
				default: return base.GetEditControl (dc);
				}
			}
			public override void CreateControlsForAppend(BaseAppendPage page) {
				page.CreateTitle("加工染色");Dt["色卡号"].DefaultValue=0;
				Dt["FID"].DefaultValue=(int)Sql.GetFieldValue("SELECT MAX(ID) FROM 加工表",0);
				page.CreateControls("染厂","色号","缸号");
				page.CreateAppendButton();
				page.CreateBrowseButton();	
			}
			public override void CreateControlsForBrowse(BaseBrowsePage page){
				page.CreateTitle("浏览加工染色记录");
				page.CreateControl1("染厂",5);
				page.CreateAppendButton();
				page.CreateQueryButton();
			}
		}
		#endregion

		#region class ZhiBuYongLiao(织布记录织布用料记录登记)
		public class ZhiBuYongLiao : JiaGong {
			public override string TableName { get{return "加工用料表";} }
			public override WebControl GetEditControl(System.Data.DataColumn dc) {
				switch (dc.ColumnName) {
					
					default: return base.GetEditControl (dc);
				}
			}
			public override string GetDispFieldName(string fldName) {
				switch (fldName) {
					case "货号": return "用料货号";
					case "重量": return "用料重量";
					default: return base.GetDispFieldName (fldName);
				}
			}
			GsDataGrid Dg;
			public override void CreateControlsForAppend(BaseAppendPage page) {
				page.CreateTitle("织布记录"); 
				page.yb+=page.yLine; page.CreateControl("日期","日期",new GsDateTimeSelect(),page.xb,page.yb);
				page.yb+=page.yLine; page.CreateControl("加工厂","加工厂",new KeShang.DropDownList(),page.xb,page.yb);
				page.yb+=page.yLine; page.CreateControl("货号 ","货号",new HuoHao.DropDownList("胚布"),page.xb,page.yb);
				page.yb+=page.yLine; page.CreateControl("收货仓库","收货仓库",new KeShang.DropDownList("仓库"),page.xb,page.yb);
				page.yb+=page.yLine; page.CreateControl("数量","数量",new IntTextBox() ,page.xb,page.yb);
				page.CreateControl("重量 ","重量",new DoubleTextBox() ,page.xb+200,page.yb);
				page.yb+=page.yLine; page.CreateControl("单价","单价",new DecimalTextBox(),page.xb,page.yb);
				page.yb+=page.yLine; page.CreateControl("签收司机","签收司机",new TextBoxImeOn(5),page.xb,page.yb);
				page.CreateControl("经手人","经手人",new YuanGong.DropDownList(),page.xb+255,page.yb);
				page.yb+=page.yLine; page.CreateControl("备注","备注",new TextBoxImeOn(30),page.xb,page.yb);
				page.yb+=page.yLine;
				page.yb+=page.yLine; page.CreateControl("Label","请输入用料货号和重量：",new Label(),page.xb,page.yb);
				page.CreateControls("货号","重量");
				Dg=new GsDataGrid(Dt);Dg.HideExcept("加工ID","用料货号","用料重量");
				Yb+=yLine; Dg.Height=200; page.AdjustDataPanelHeight(Yb+Math.Max((int)Dg.Height.Value,200));
				page.CreateControl("DataGrid",Dg,Xb,Yb);
				page.CreateAppendButton();
				page.CreateButton("全部保存",new EventHandler(SaveAll)).CausesValidation=false;
				page.CreateBrowseButton();
				//page.CreateButton("修改用料记录",new EventHandler(XiuGaiYongLiaoJiLu)).CausesValidation=false;
				//page.CreateButton("修改记录",new EventHandler(XiuGaiJiLu)).CausesValidation=false;
				}
			public override void CreateControlsForBrowse(BaseBrowsePage page) {
				page.CreateTitle("织布用料咨询页面");
				
				page.CreateQueryButton();
				
			}
			
			public override bool AppendRecord() {
				WebControl jg=Page.GetControl("加工厂");
				if (jg.Enabled==true){
					string sql="INSERT INTO 加工表 (日期,项目,加工厂,货号,收货仓库,数量,重量,单价,"+
						"签收司机,经手人,备注,操作员) VALUES("+Sql.Text(Page.GetControl("日期"))+",'织布',"+Sql.Text(Page.GetControl("加工厂"))+
						","+Sql.Text(Page.GetControl("货号"))+","+Sql.Text(Page.GetControl("收货仓库"))+
						","+Sql.Text(Page.GetControl("数量"))+","+Sql.Text(Page.GetControl("重量"))+
						","+Sql.Text(Page.GetControl("单价"))+","+Sql.Text(Page.GetControl("签收司机"))+
						","+Sql.Text(Page.GetControl("经手人"))+","+Sql.Text(Page.GetControl("备注"))+",'"+Db.CaoZuoYuan+"')";
					Sql.Run(sql);
				}
				Dt["加工ID"].DefaultValue=(int)Sql.GetFieldValue("SELECT MAX(ID) FROM 加工表",0);
				base.AppendDataFromPage((BaseAppendPage)Page);
				Dg.UpdateDatabases();
				jg.Enabled=false;
				return true;
				}
		
			public void SaveAll(object sender,EventArgs e) {
				//Dg.UpdateDatabases();
				WebControl jg=Page.GetControl("加工厂");jg.Enabled=true;Db.SetValue(jg,DBNull.Value);
				WebControl hh=Page.GetControl("货号 ");Db.SetValue(hh,DBNull.Value);
				WebControl ck=Page.GetControl("收货仓库");Db.SetValue(ck,DBNull.Value);
				WebControl zl=Page.GetControl("重量 ");Db.SetValue(zl,DBNull.Value);
				WebControl dj=Page.GetControl("单价");Db.SetValue(dj,DBNull.Value);
				WebControl sj=Page.GetControl("签收司机");Db.SetValue(sj,DBNull.Value);
				WebControl jsr=Page.GetControl("经手人");Db.SetValue(jsr,DBNull.Value);
				WebControl bz=Page.GetControl("备注");Db.SetValue(bz,DBNull.Value);
				
				}
			}
		#endregion
	

		#region class RanSe(染色登记)
		public class RanSe : JiaGong {
			public override string GetDispFieldName(string fldName) {
				switch (fldName) {
					case "加工厂": return "染厂";
					default: return base.GetDispFieldName (fldName);
				}
			}
			public override WebControl GetEditControl(System.Data.DataColumn dc) {
				switch (dc.ColumnName) {
					case "加工厂": return new KeShang.DropDownList("染厂");
					case "货号": return new HuoHao.DropDownList("色布");
					case "经手人": return new YuanGong.DropDownList();
					case "收货仓库": return new KeShang.DropDownList("仓库");
					default: return base.GetEditControl (dc);
				}
			}
			public override void CreateControlsForAppend(BaseAppendPage page) {
				page.CreateTitle("染色记录"); Dt["项目"].DefaultValue="染色"; Dt["加工厂"].Caption="染厂";
				page.CreateControls("日期","加工厂","货号");
				//page.yb+=page.yLine; page.CreateControl("缸号","缸号",new TextBoxImeOff(6),page.xb,page.yb);
				//page.CreateControl("色号","色号",new SeHao.ComboBox(),page.xb2,page.yb);
				page.CreateControls("数量","-重量","单价","收货仓库","签收司机","-经手人","备注");
				page.CreateAppendButton();
				page.CreateBrowseButton();
			}
			public override void CreateControlsForBrowse(BaseBrowsePage page) {
				page.CreateTitle("染色记录咨询页面"); Dt["加工厂"].Caption="染厂";
				page.CreateControl1("日期",5); page.CreateControl1("加工厂",250); page.CreateControl1("货号",460);
				page.CreateControl2("收货仓库",5); page.CreateControl2("经手人",250);
				page.CreateQueryButton();
			}
			
		}
		#endregion

		#region class QiTaJiaGong(其它加工记录)
		public class QiTaJiaGong : JiaGong{
			public override WebControl GetEditControl(System.Data.DataColumn dc) {
				switch (dc.ColumnName) {
					case "加工厂": return new KeShang.DropDownList();
					case "货号": return new YongLiaoBiLi.DropDownList();
					case "经手人": return new YuanGong.DropDownList();
					case "收货仓库": return new KeShang.DropDownList("仓库");
					default: return base.GetEditControl (dc);
				}
			}
			public override void CreateControlsForAppend(BaseAppendPage page) {
				page.CreateTitle("添加其它加工记录"); Dt["项目"].DefaultValue="加工"; 
				page.CreateControls("日期","加工厂","货号","数量","-重量","单价","签收司机","-经手人","备注");
				page.CreateAppendButton();
				page.CreateBrowseButton();
			}
			public override void CreateControlsForBrowse(BaseBrowsePage page) {
				page.CreateTitle("其它加工咨询页面"); 
				page.CreateControl1("日期",5); page.CreateControl1("加工厂",250); page.CreateControl1("货号",460);
				page.CreateControl2("收货仓库",5); page.CreateControl2("经手人",250);
				page.CreateQueryButton();
			}

		}

		#endregion
	}
}