luose.cs

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

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

namespace TextileManager
{
	public class LuoSe:	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 HuoHao.ComboBox("色布");
				case "色号": return new SeHao.DropDownList();
				default: return base.GetEditControl (dc);
			}
		}
		GsDataGrid Dg;
		public override void CreateControlsForAppend(BaseAppendPage page) {
			page.CreateTitle("添加落色记录");Dt["项目"].DefaultValue="落色";
			Dt["已出货数量"].DefaultValue=0;
			page.CreateControls("日期","单号","染厂","货号","数量","色号","幅宽","克重","经手人","备注");
			//dtNewRecord=new GsDataTable(Dt.Td);
			Dg=new GsDataGrid(Dt); Dg.HideExcept("日期","单号","染厂","货号","数量","色号","幅宽","克重","经手人","备注");
			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();
		}
		public override bool AppendRecord() {
			string rc=Sql.Text(Page.GetControl("染厂")), sh=Sql.Text(Page.GetControl("色号"));
			if (Sql.GetFieldValue("SELECT 编号 FROM 色号表 WHERE 染厂="+rc+" AND 编号="+sh)==null) {
				Gbl.ShowErrorMsg("色号 "+sh+" 不属于染厂 "+rc+"，请重新输入"); return false;
			}
			if (!AppendDataFromPage((BaseAppendPage)Page)) return false;
			return true;
		}
		public void SaveAll(object sender,EventArgs e) {
			Dg.UpdateDatabases();
		}

		public override void CreateControlsForBrowse(BaseBrowsePage page) {
			page.CreateTitle("浏览落色记录");
			page.CreateControl1("货号",5);
			page.CreateControl2("色号",5);
			page.CreateControl2("染厂",240);
			page.CreateAppendButton();
			page.CreateQueryButton();
			page.Dg.DataBinding+=new EventHandler(BrowsePage_DataGrid_DataBinding);
		}
		private void BrowsePage_DataGrid_DataBinding(object sender, EventArgs e) {
			GsDataGrid dg=(GsDataGrid)sender;
			dg.Hide("ID","项目","操作员","时间");
		}
	}
}