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 "貨號(hào)": return new HuoHao.DropDownList();
			case "原材料號(hào)": return new HuoHao.DropDownList();
			default: return base.GetEditControl (dc);
			}
		}
		public class DropDownList : GsDropDownList {
			public DropDownList() : base("SELECT DISTINCT TextField=成品貨號(hào)+' '+(SELECT 名稱 FROM 貨號(hào)表 WHERE 編號(hào)=成品貨號(hào)), "+
				"ValueField=成品貨號(hào) FROM 用料比例表 ORDER BY TextField",180) {
			}
		}

		#endregion

		public override void CreateControlsForAppend(BaseAppendPage page) {
			page.CreateTitle("登記用料比例"); Dt["比例"].DefaultValue=1.0;
			page.CreateControls("成品貨號(hào)","用料貨號(hào)","序號(hào)","比例");
			page.CreateAppendButton();
			page.CreateBrowseButton();
		}
		public override void CreateControlsForBrowse(BaseBrowsePage page) {
			page.CreateTitle("用料比例咨詢頁(yè)面");
			page.CreateControl1("成品貨號(hào)",5); page.CreateControl1("用料貨號(hào)",250); page.CreateControl1("序號(hào)",460);
			page.CreateQueryButton();
		}
	}
}