?? jiagong.cs
字號:
using System;
using WebBase;
using System.Data;
using System.Web.UI.WebControls;
namespace TextileManager {
/// <summary>管理[加工表]</summary>
public class JiaGong : TableDefinition {
#region 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 YongLiaoBiLi.DropDownList();
case "經手人": return new YuanGong.DropDownList();
case "收貨倉庫": return new KeShang.DropDownList("倉庫");
default: return base.GetEditControl (dc);
}
}
public override DataGridColumn GetDataGridColumn(System.Data.DataColumn dc) {
switch (dc.ColumnName) {
case "經手人": return base.GetDataGridColumn(dc,new GsDropDownListColumn(new YuanGong.DropDownList()));
default: return base.GetDataGridColumn (dc);
}
}
#endregion
#region class zhibu 管理加工表
/// <summary>管理加工表</summary>
public class ZhiBu : JiaGong {
public override string TableName { get{return "加工表";}}
public override WebControl GetEditControl(System.Data.DataColumn dc){
switch (dc.ColumnName){
//case "貨號": return new HuoHao.DropDownList();
default: return base.GetEditControl (dc);
}
}
public override void CreateControlsForAppend(BaseAppendPage page) {
page.CreateTitle("織布記錄");
page.CreateControls("日期","加工廠","貨號");
page.CreateAppendButton();
page.CreateBrowseButton();
}
public override void CreateControlsForBrowse(BaseBrowsePage page){
page.CreateTitle("瀏覽織布記錄");
page.CreateAppendButton();
page.CreateQueryButton();
}
}
#endregion
#region class Ranse 管理加工染色表
/// <summary>管理加工染色表</summary>
public class RanSe1 : TableDefinition {
public override string TableName { get{return "加工染色表";}}
public override WebControl GetEditControl(System.Data.DataColumn dc){
switch (dc.ColumnName){
case "貨號": return new HuoHao.DropDownList("胚布");
default: return base.GetEditControl (dc);
}
}
public override void CreateControlsForAppend(BaseAppendPage page) {
page.CreateTitle("加工染色");Dt["色卡號"].DefaultValue=0;
Dt["FID"].DefaultValue=(int)Sql.GetFieldValue("SELECT MAX(ID) FROM 加工表",0);
page.CreateControls("染廠","色號","缸號");
page.CreateAppendButton();
page.CreateBrowseButton();
}
public override void CreateControlsForBrowse(BaseBrowsePage page){
page.CreateTitle("瀏覽加工染色記錄");
page.CreateControl1("染廠",5);
page.CreateAppendButton();
page.CreateQueryButton();
}
}
#endregion
#region class ZhiBuYongLiao(織布記錄織布用料記錄登記)
public class ZhiBuYongLiao : JiaGong {
public override string TableName { get{return "加工用料表";} }
public override WebControl GetEditControl(System.Data.DataColumn dc) {
switch (dc.ColumnName) {
default: return base.GetEditControl (dc);
}
}
public override string GetDispFieldName(string fldName) {
switch (fldName) {
case "貨號": return "用料貨號";
case "重量": return "用料重量";
default: return base.GetDispFieldName (fldName);
}
}
GsDataGrid Dg;
public override void CreateControlsForAppend(BaseAppendPage page) {
page.CreateTitle("織布記錄");
page.yb+=page.yLine; page.CreateControl("日期","日期",new GsDateTimeSelect(),page.xb,page.yb);
page.yb+=page.yLine; page.CreateControl("加工廠","加工廠",new KeShang.DropDownList(),page.xb,page.yb);
page.yb+=page.yLine; page.CreateControl("貨號 ","貨號",new HuoHao.DropDownList("胚布"),page.xb,page.yb);
page.yb+=page.yLine; page.CreateControl("收貨倉庫","收貨倉庫",new KeShang.DropDownList("倉庫"),page.xb,page.yb);
page.yb+=page.yLine; page.CreateControl("數量","數量",new IntTextBox() ,page.xb,page.yb);
page.CreateControl("重量 ","重量",new DoubleTextBox() ,page.xb+200,page.yb);
page.yb+=page.yLine; page.CreateControl("單價","單價",new DecimalTextBox(),page.xb,page.yb);
page.yb+=page.yLine; page.CreateControl("簽收司機","簽收司機",new TextBoxImeOn(5),page.xb,page.yb);
page.CreateControl("經手人","經手人",new YuanGong.DropDownList(),page.xb+255,page.yb);
page.yb+=page.yLine; page.CreateControl("備注","備注",new TextBoxImeOn(30),page.xb,page.yb);
page.yb+=page.yLine;
page.yb+=page.yLine; page.CreateControl("Label","請輸入用料貨號和重量：",new Label(),page.xb,page.yb);
page.CreateControls("貨號","重量");
Dg=new GsDataGrid(Dt);Dg.HideExcept("加工ID","用料貨號","用料重量");
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();
//page.CreateButton("修改用料記錄",new EventHandler(XiuGaiYongLiaoJiLu)).CausesValidation=false;
//page.CreateButton("修改記錄",new EventHandler(XiuGaiJiLu)).CausesValidation=false;
}
public override void CreateControlsForBrowse(BaseBrowsePage page) {
page.CreateTitle("織布用料咨詢頁面");
page.CreateQueryButton();
}
public override bool AppendRecord() {
WebControl jg=Page.GetControl("加工廠");
if (jg.Enabled==true){
string sql="INSERT INTO 加工表 (日期,項目,加工廠,貨號,收貨倉庫,數量,重量,單價,"+
"簽收司機,經手人,備注,操作員) VALUES("+Sql.Text(Page.GetControl("日期"))+",'織布',"+Sql.Text(Page.GetControl("加工廠"))+
","+Sql.Text(Page.GetControl("貨號"))+","+Sql.Text(Page.GetControl("收貨倉庫"))+
","+Sql.Text(Page.GetControl("數量"))+","+Sql.Text(Page.GetControl("重量"))+
","+Sql.Text(Page.GetControl("單價"))+","+Sql.Text(Page.GetControl("簽收司機"))+
","+Sql.Text(Page.GetControl("經手人"))+","+Sql.Text(Page.GetControl("備注"))+",'"+Db.CaoZuoYuan+"')";
Sql.Run(sql);
}
Dt["加工ID"].DefaultValue=(int)Sql.GetFieldValue("SELECT MAX(ID) FROM 加工表",0);
base.AppendDataFromPage((BaseAppendPage)Page);
Dg.UpdateDatabases();
jg.Enabled=false;
return true;
}
public void SaveAll(object sender,EventArgs e) {
//Dg.UpdateDatabases();
WebControl jg=Page.GetControl("加工廠");jg.Enabled=true;Db.SetValue(jg,DBNull.Value);
WebControl hh=Page.GetControl("貨號 ");Db.SetValue(hh,DBNull.Value);
WebControl ck=Page.GetControl("收貨倉庫");Db.SetValue(ck,DBNull.Value);
WebControl zl=Page.GetControl("重量 ");Db.SetValue(zl,DBNull.Value);
WebControl dj=Page.GetControl("單價");Db.SetValue(dj,DBNull.Value);
WebControl sj=Page.GetControl("簽收司機");Db.SetValue(sj,DBNull.Value);
WebControl jsr=Page.GetControl("經手人");Db.SetValue(jsr,DBNull.Value);
WebControl bz=Page.GetControl("備注");Db.SetValue(bz,DBNull.Value);
}
}
#endregion
#region class RanSe(染色登記)
public class RanSe : JiaGong {
public override string GetDispFieldName(string fldName) {
switch (fldName) {
case "加工廠": return "染廠";
default: return base.GetDispFieldName (fldName);
}
}
public override WebControl GetEditControl(System.Data.DataColumn dc) {
switch (dc.ColumnName) {
case "加工廠": return new KeShang.DropDownList("染廠");
case "貨號": return new HuoHao.DropDownList("色布");
case "經手人": return new YuanGong.DropDownList();
case "收貨倉庫": return new KeShang.DropDownList("倉庫");
default: return base.GetEditControl (dc);
}
}
public override void CreateControlsForAppend(BaseAppendPage page) {
page.CreateTitle("染色記錄"); Dt["項目"].DefaultValue="染色"; Dt["加工廠"].Caption="染廠";
page.CreateControls("日期","加工廠","貨號");
//page.yb+=page.yLine; page.CreateControl("缸號","缸號",new TextBoxImeOff(6),page.xb,page.yb);
//page.CreateControl("色號","色號",new SeHao.ComboBox(),page.xb2,page.yb);
page.CreateControls("數量","-重量","單價","收貨倉庫","簽收司機","-經手人","備注");
page.CreateAppendButton();
page.CreateBrowseButton();
}
public override void CreateControlsForBrowse(BaseBrowsePage page) {
page.CreateTitle("染色記錄咨詢頁面"); Dt["加工廠"].Caption="染廠";
page.CreateControl1("日期",5); page.CreateControl1("加工廠",250); page.CreateControl1("貨號",460);
page.CreateControl2("收貨倉庫",5); page.CreateControl2("經手人",250);
page.CreateQueryButton();
}
}
#endregion
#region class QiTaJiaGong(其它加工記錄)
public class QiTaJiaGong : JiaGong{
public override WebControl GetEditControl(System.Data.DataColumn dc) {
switch (dc.ColumnName) {
case "加工廠": return new KeShang.DropDownList();
case "貨號": return new YongLiaoBiLi.DropDownList();
case "經手人": return new YuanGong.DropDownList();
case "收貨倉庫": return new KeShang.DropDownList("倉庫");
default: return base.GetEditControl (dc);
}
}
public override void CreateControlsForAppend(BaseAppendPage page) {
page.CreateTitle("添加其它加工記錄"); Dt["項目"].DefaultValue="加工";
page.CreateControls("日期","加工廠","貨號","數量","-重量","單價","簽收司機","-經手人","備注");
page.CreateAppendButton();
page.CreateBrowseButton();
}
public override void CreateControlsForBrowse(BaseBrowsePage page) {
page.CreateTitle("其它加工咨詢頁面");
page.CreateControl1("日期",5); page.CreateControl1("加工廠",250); page.CreateControl1("貨號",460);
page.CreateControl2("收貨倉庫",5); page.CreateControl2("經手人",250);
page.CreateQueryButton();
}
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -