huohao.cs

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

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

namespace TextileManager
{
	public class HuoHao : TableDefinition {
		#region overrided function & DropDownList & ComboBox
		public override string TableName { get{return "货号表";} }
		public override WebControl GetEditControl(System.Data.DataColumn dc) {
			switch (dc.ColumnName) {
			case "编号": return new TextBoxImeOff(dc.MaxLength);
			case "类别": return new TongYong.DropDownList("货物类别");
			default: return base.GetEditControl (dc);
			}
		}
		public override DataGridColumn GetDataGridColumn(DataColumn dc) {
			switch (dc.ColumnName) {
			case "类别": return base.GetDataGridColumn(dc,new GsDropDownListColumn(new TongYong.DropDownList("货物类别",false)));
			default: return base.GetDataGridColumn (dc);
			}
		}

		public class DropDownList : GsDropDownList {
			public DropDownList() : base("SELECT TextField=编号+' '+名称, ValueField=编号 FROM 货号表 ORDER BY TextField",180) {
			}
			public DropDownList(string leiBie) : base("SELECT TextField=编号+' '+名称, ValueField=编号 FROM 货号表 WHERE 类别='"+leiBie+"' ORDER BY TextField",180) {
			}
		}
		public class ComboBox : GsComboBox {
			public ComboBox() : base("SELECT TextField=编号+' '+名称, ValueField=编号 FROM 货号表 ORDER BY TextField") {
			}
			public ComboBox(string leiBie) : base("SELECT TextField=编号+' '+名称, ValueField=编号 FROM 货号表 WHERE 类别='"+leiBie+"' ORDER BY TextField") {
			}
		}
		#endregion

		#region 判断货号类型的静态函数
		/// <summary>取得指定货号类别的编码(货号的第一位)</summary>
		public static string GetCode(string leiBie) {
			switch (leiBie) {
			case "原料": return "A";
			case "胚布": return "B";
			case "色布": return "C";
			}
			Gbl.Break(); return "";
		}
		public static bool IsYuanLiao(string huoHao) {return huoHao[0]=='A';}
		public static bool IsPeiBu(string huoHao) {return huoHao[0]=='B';}
		public static bool IsSeBu(string huoHao) {return huoHao[0]=='C';}
		public static bool IsQiTa(string huoHao) {return huoHao[0]!='A' && huoHao[0]!='B' && huoHao[0]!='C';}
		#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.CreateControl2("类别",5);
			page.CreateQueryButton();
			page.CreateAppendButton();
		}
	}
}