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

namespace TextileManager
{
	public class TongYong : TableDefinition {
		#region overrided function & DropDownList
		public override string TableName { get{return "通用資料";} }

		public class DropDownList : GsDropDownList {
			public DropDownList(string XiangMu) : base("SELECT TextField=LTRIM(STR(序號))+'.'+文本,ValueField=文本 FROM 通用資料 WHERE 項目='" + XiangMu + "' ORDER BY TextField",120) {
			}
			public DropDownList(string XiangMu,bool allowNulls) : base("SELECT TextField=LTRIM(STR(序號))+'.'+文本,ValueField=文本 FROM 通用資料 WHERE 項目='" + XiangMu + "' ORDER BY TextField",120,allowNulls) {
			}
		}
		#endregion

		public override void CreateControlsForAppend(BaseAppendPage page) {
			page.CreateTitle("通用資料添加新項目");
			page.CreateControls("項目","序號","文本","數字");
			page.CreateAppendButton();
			page.CreateBrowseButton();
		}
		public override void CreateControlsForBrowse(BaseBrowsePage page) {
			page.CreateTitle("通用資料咨詢頁面");
			page.CreateControl1("項目",5); page.CreateControl1("文本",240);
			page.CreateQueryButton();
			page.CreateAppendButton();
			page.CreateOutputButton();
		}
	}
}