yongliaobili.cs

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

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

namespace TextileManager
{
	/// <summary>管理[用料比例表]</summary>
	public class YongLiaoBiLi : TableDefinition {
		#region TableDefinition & DropDownList
		public override string TableName { get{return "用料比例表";} }
		public override WebControl GetEditControl(System.Data.DataColumn dc) {
			switch (dc.ColumnName) {
			case "货号": return new HuoHao.DropDownList();
			case "原材料号": return new HuoHao.DropDownList();
			default: return base.GetEditControl (dc);
			}
		}
		public class DropDownList : GsDropDownList {
			public DropDownList() : base("SELECT DISTINCT TextField=成品货号+' '+(SELECT 名称 FROM 货号表 WHERE 编号=成品货号), "+
				"ValueField=成品货号 FROM 用料比例表 ORDER BY TextField",180) {
			}
		}

		#endregion

		public override void CreateControlsForAppend(BaseAppendPage page) {
			page.CreateTitle("登记用料比例"); Dt["比例"].DefaultValue=1.0;
			page.CreateControls("成品货号","用料货号","序号","比例");
			page.CreateAppendButton();
			page.CreateBrowseButton();
		}
		public override void CreateControlsForBrowse(BaseBrowsePage page) {
			page.CreateTitle("用料比例咨询页面");
			page.CreateControl1("成品货号",5); page.CreateControl1("用料货号",250); page.CreateControl1("序号",460);
			page.CreateQueryButton();
		}
	}
}