using System; using System.Collections; using System.ComponentModel; using System.Drawing; using System.Data; using System.Windows.Forms; using Core.XgMes.Client.StorageBase; using Core.XgMes.Client.TurnoffReport.Dialog; namespace Core.XgMes.Client.JGKC.SteelPlateManager { /// /// 中板厂成品库存综合查询查询条件控件 /// public class ctlKCJListQuery : System.Windows.Forms.UserControl { private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_RollNum; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_RollTop; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_RollNumBegin; private Infragistics.Win.Misc.UltraLabel ultraLabel1; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_RollNumEnd; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_Ply; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_PlyBegin; private Infragistics.Win.Misc.UltraLabel ultraLabel2; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_PlyEnd; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_WidthEnd; private Infragistics.Win.Misc.UltraLabel ultraLabel3; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_WidthBegin; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_Width; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_LengthEnd; private Infragistics.Win.Misc.UltraLabel ultraLabel4; private Infragistics.Win.UltraWinEditors.UltraNumericEditor txt_LenghtBegin; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_Length; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_InStorageTime; private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor Dte_Begin; private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor Dte_End; private Infragistics.Win.Misc.UltraLabel ultraLabel5; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_NPlanOrder; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_NPlanOrder; private Infragistics.Win.UltraWinEditors.UltraCheckEditor Chk_PrdTime; private Infragistics.Win.Misc.UltraLabel ultraLabel6; private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor Dte_PrdEnd; private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor Dte_PrdBegin; private Infragistics.Win.UltraWinEditors.UltraCheckEditor Chk_Condole; private Infragistics.Win.UltraWinEditors.UltraTextEditor Txt_Condole; private Infragistics.Win.UltraWinEditors.UltraCheckEditor Chk_ButtressRemark; private Infragistics.Win.UltraWinEditors.UltraTextEditor Txt_BRemark; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_PlanNO; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_PlanNO; private Infragistics.Win.UltraWinGrid.UltraCombo cmb_Buttress; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_Buttress; private Infragistics.Win.UltraWinGrid.UltraCombo cmb_SteelName; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_SteelName; private Infragistics.Win.UltraWinEditors.UltraTextEditor txt_PactNO; private Infragistics.Win.UltraWinEditors.UltraCheckEditor chk_PactNO; /// /// 必需的设计器变量。 /// private System.ComponentModel.Container components = null; public ctlKCJListQuery() { // 该调用是 Windows.Forms 窗体设计器所必需的。 InitializeComponent(); txt_RollTop.Text = "H"+System.DateTime.Now.ToString("yy").Substring(1,1); // TODO: 在 InitializeComponent 调用后添加任何初始化 } /// /// 清理所有正在使用的资源。 /// protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region 组件设计器生成的代码 /// /// 设计器支持所需的方法 - 不要使用代码编辑器 /// 修改此方法的内容。 /// private void InitializeComponent() { Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance4 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance6 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance7 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance8 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance9 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance10 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance11 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance12 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance13 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance14 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance15 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance16 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance17 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance18 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance19 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance20 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance21 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance22 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance23 = new Infragistics.Win.Appearance(); Infragistics.Win.Appearance appearance24 = new Infragistics.Win.Appearance(); this.chk_RollNum = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_RollTop = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.txt_RollNumBegin = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.ultraLabel1 = new Infragistics.Win.Misc.UltraLabel(); this.txt_RollNumEnd = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.chk_Ply = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_PlyBegin = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.ultraLabel2 = new Infragistics.Win.Misc.UltraLabel(); this.txt_PlyEnd = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.txt_WidthEnd = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.ultraLabel3 = new Infragistics.Win.Misc.UltraLabel(); this.txt_WidthBegin = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.chk_Width = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_LengthEnd = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.ultraLabel4 = new Infragistics.Win.Misc.UltraLabel(); this.txt_LenghtBegin = new Infragistics.Win.UltraWinEditors.UltraNumericEditor(); this.chk_Length = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.chk_InStorageTime = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.Dte_Begin = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor(); this.Dte_End = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor(); this.ultraLabel5 = new Infragistics.Win.Misc.UltraLabel(); this.chk_NPlanOrder = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_NPlanOrder = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.Chk_PrdTime = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.ultraLabel6 = new Infragistics.Win.Misc.UltraLabel(); this.Dte_PrdEnd = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor(); this.Dte_PrdBegin = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor(); this.Chk_Condole = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.Txt_Condole = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.Chk_ButtressRemark = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.Txt_BRemark = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.chk_PlanNO = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_PlanNO = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.cmb_Buttress = new Infragistics.Win.UltraWinGrid.UltraCombo(); this.chk_Buttress = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.cmb_SteelName = new Infragistics.Win.UltraWinGrid.UltraCombo(); this.chk_SteelName = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); this.txt_PactNO = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.chk_PactNO = new Infragistics.Win.UltraWinEditors.UltraCheckEditor(); ((System.ComponentModel.ISupportInitialize)(this.txt_RollTop)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_RollNumBegin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_RollNumEnd)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlyBegin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlyEnd)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_WidthEnd)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_WidthBegin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_LengthEnd)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_LenghtBegin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_Begin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_End)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_NPlanOrder)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_PrdEnd)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_PrdBegin)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Txt_Condole)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.Txt_BRemark)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlanNO)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.cmb_Buttress)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.cmb_SteelName)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PactNO)).BeginInit(); this.SuspendLayout(); // // chk_RollNum // this.chk_RollNum.FlatMode = true; this.chk_RollNum.Location = new System.Drawing.Point(3, 10); this.chk_RollNum.Name = "chk_RollNum"; this.chk_RollNum.Size = new System.Drawing.Size(80, 20); this.chk_RollNum.TabIndex = 9; this.chk_RollNum.Text = "轧批号从"; // // txt_RollTop // this.txt_RollTop.AutoSize = true; this.txt_RollTop.FlatMode = true; this.txt_RollTop.Location = new System.Drawing.Point(77, 6); this.txt_RollTop.Name = "txt_RollTop"; this.txt_RollTop.Size = new System.Drawing.Size(26, 19); this.txt_RollTop.TabIndex = 10; this.txt_RollTop.Text = "H7"; // // txt_RollNumBegin // this.txt_RollNumBegin.AutoSize = true; this.txt_RollNumBegin.FlatMode = true; this.txt_RollNumBegin.Location = new System.Drawing.Point(103, 6); this.txt_RollNumBegin.MaxLength = 5; this.txt_RollNumBegin.Name = "txt_RollNumBegin"; this.txt_RollNumBegin.Size = new System.Drawing.Size(57, 19); this.txt_RollNumBegin.TabIndex = 11; // // ultraLabel1 // this.ultraLabel1.Location = new System.Drawing.Point(160, 10); this.ultraLabel1.Name = "ultraLabel1"; this.ultraLabel1.Size = new System.Drawing.Size(17, 16); this.ultraLabel1.TabIndex = 12; this.ultraLabel1.Text = "到"; // // txt_RollNumEnd // this.txt_RollNumEnd.AutoSize = true; this.txt_RollNumEnd.FlatMode = true; this.txt_RollNumEnd.Location = new System.Drawing.Point(178, 6); this.txt_RollNumEnd.MaxLength = 5; this.txt_RollNumEnd.Name = "txt_RollNumEnd"; this.txt_RollNumEnd.Size = new System.Drawing.Size(58, 19); this.txt_RollNumEnd.TabIndex = 13; // // chk_Ply // this.chk_Ply.FlatMode = true; this.chk_Ply.Location = new System.Drawing.Point(3, 34); this.chk_Ply.Name = "chk_Ply"; this.chk_Ply.Size = new System.Drawing.Size(80, 20); this.chk_Ply.TabIndex = 14; this.chk_Ply.Text = "厚度从"; // // txt_PlyBegin // this.txt_PlyBegin.FlatMode = true; this.txt_PlyBegin.Location = new System.Drawing.Point(77, 30); this.txt_PlyBegin.MaskInput = "nnn.nnn"; this.txt_PlyBegin.Name = "txt_PlyBegin"; this.txt_PlyBegin.NumericType = Infragistics.Win.UltraWinEditors.NumericType.Double; this.txt_PlyBegin.PromptChar = ' '; this.txt_PlyBegin.Size = new System.Drawing.Size(83, 19); this.txt_PlyBegin.TabIndex = 15; // // ultraLabel2 // this.ultraLabel2.Location = new System.Drawing.Point(160, 34); this.ultraLabel2.Name = "ultraLabel2"; this.ultraLabel2.Size = new System.Drawing.Size(17, 16); this.ultraLabel2.TabIndex = 16; this.ultraLabel2.Text = "到"; // // txt_PlyEnd // this.txt_PlyEnd.FlatMode = true; this.txt_PlyEnd.Location = new System.Drawing.Point(178, 30); this.txt_PlyEnd.MaskInput = "nnn.nnn"; this.txt_PlyEnd.Name = "txt_PlyEnd"; this.txt_PlyEnd.NumericType = Infragistics.Win.UltraWinEditors.NumericType.Double; this.txt_PlyEnd.PromptChar = ' '; this.txt_PlyEnd.Size = new System.Drawing.Size(58, 19); this.txt_PlyEnd.TabIndex = 17; // // txt_WidthEnd // this.txt_WidthEnd.FlatMode = true; this.txt_WidthEnd.Location = new System.Drawing.Point(178, 54); this.txt_WidthEnd.MaskInput = "nnnn"; this.txt_WidthEnd.Name = "txt_WidthEnd"; this.txt_WidthEnd.PromptChar = ' '; this.txt_WidthEnd.Size = new System.Drawing.Size(58, 19); this.txt_WidthEnd.TabIndex = 21; // // ultraLabel3 // this.ultraLabel3.Location = new System.Drawing.Point(160, 56); this.ultraLabel3.Name = "ultraLabel3"; this.ultraLabel3.Size = new System.Drawing.Size(17, 16); this.ultraLabel3.TabIndex = 20; this.ultraLabel3.Text = "到"; // // txt_WidthBegin // this.txt_WidthBegin.FlatMode = true; this.txt_WidthBegin.Location = new System.Drawing.Point(77, 54); this.txt_WidthBegin.MaskInput = "nnnn"; this.txt_WidthBegin.Name = "txt_WidthBegin"; this.txt_WidthBegin.NumericType = Infragistics.Win.UltraWinEditors.NumericType.Double; this.txt_WidthBegin.PromptChar = ' '; this.txt_WidthBegin.Size = new System.Drawing.Size(83, 19); this.txt_WidthBegin.TabIndex = 19; // // chk_Width // this.chk_Width.FlatMode = true; this.chk_Width.Location = new System.Drawing.Point(3, 58); this.chk_Width.Name = "chk_Width"; this.chk_Width.Size = new System.Drawing.Size(80, 20); this.chk_Width.TabIndex = 18; this.chk_Width.Text = "宽度从"; // // txt_LengthEnd // this.txt_LengthEnd.FlatMode = true; this.txt_LengthEnd.Location = new System.Drawing.Point(178, 78); this.txt_LengthEnd.MaskInput = "nnnnn"; this.txt_LengthEnd.Name = "txt_LengthEnd"; this.txt_LengthEnd.PromptChar = ' '; this.txt_LengthEnd.Size = new System.Drawing.Size(58, 19); this.txt_LengthEnd.TabIndex = 25; // // ultraLabel4 // this.ultraLabel4.Location = new System.Drawing.Point(160, 80); this.ultraLabel4.Name = "ultraLabel4"; this.ultraLabel4.Size = new System.Drawing.Size(17, 16); this.ultraLabel4.TabIndex = 24; this.ultraLabel4.Text = "到"; // // txt_LenghtBegin // this.txt_LenghtBegin.FlatMode = true; this.txt_LenghtBegin.Location = new System.Drawing.Point(77, 78); this.txt_LenghtBegin.MaskInput = "nnnnn"; this.txt_LenghtBegin.Name = "txt_LenghtBegin"; this.txt_LenghtBegin.PromptChar = ' '; this.txt_LenghtBegin.Size = new System.Drawing.Size(83, 19); this.txt_LenghtBegin.TabIndex = 23; // // chk_Length // this.chk_Length.FlatMode = true; this.chk_Length.Location = new System.Drawing.Point(3, 80); this.chk_Length.Name = "chk_Length"; this.chk_Length.Size = new System.Drawing.Size(80, 20); this.chk_Length.TabIndex = 22; this.chk_Length.Text = "长度从"; // // chk_InStorageTime // this.chk_InStorageTime.FlatMode = true; this.chk_InStorageTime.Location = new System.Drawing.Point(242, 5); this.chk_InStorageTime.Name = "chk_InStorageTime"; this.chk_InStorageTime.Size = new System.Drawing.Size(80, 20); this.chk_InStorageTime.TabIndex = 47; this.chk_InStorageTime.Text = "入库时间"; // // Dte_Begin // this.Dte_Begin.FlatMode = true; this.Dte_Begin.Location = new System.Drawing.Point(319, 5); this.Dte_Begin.Name = "Dte_Begin"; this.Dte_Begin.Size = new System.Drawing.Size(100, 19); this.Dte_Begin.TabIndex = 48; // // Dte_End // this.Dte_End.FlatMode = true; this.Dte_End.Location = new System.Drawing.Point(449, 4); this.Dte_End.Name = "Dte_End"; this.Dte_End.Size = new System.Drawing.Size(100, 19); this.Dte_End.TabIndex = 49; // // ultraLabel5 // this.ultraLabel5.Location = new System.Drawing.Point(426, 9); this.ultraLabel5.Name = "ultraLabel5"; this.ultraLabel5.Size = new System.Drawing.Size(17, 16); this.ultraLabel5.TabIndex = 50; this.ultraLabel5.Text = "到"; // // chk_NPlanOrder // this.chk_NPlanOrder.FlatMode = true; this.chk_NPlanOrder.Location = new System.Drawing.Point(242, 74); this.chk_NPlanOrder.Name = "chk_NPlanOrder"; this.chk_NPlanOrder.Size = new System.Drawing.Size(80, 20); this.chk_NPlanOrder.TabIndex = 53; this.chk_NPlanOrder.Text = "现在订单"; // // txt_NPlanOrder // this.txt_NPlanOrder.AutoSize = true; this.txt_NPlanOrder.FlatMode = true; this.txt_NPlanOrder.Location = new System.Drawing.Point(319, 74); this.txt_NPlanOrder.Name = "txt_NPlanOrder"; this.txt_NPlanOrder.Size = new System.Drawing.Size(74, 19); this.txt_NPlanOrder.TabIndex = 54; // // Chk_PrdTime // this.Chk_PrdTime.FlatMode = true; this.Chk_PrdTime.Location = new System.Drawing.Point(242, 27); this.Chk_PrdTime.Name = "Chk_PrdTime"; this.Chk_PrdTime.Size = new System.Drawing.Size(80, 20); this.Chk_PrdTime.TabIndex = 66; this.Chk_PrdTime.Text = "生产时间"; // // ultraLabel6 // this.ultraLabel6.Location = new System.Drawing.Point(425, 31); this.ultraLabel6.Name = "ultraLabel6"; this.ultraLabel6.Size = new System.Drawing.Size(17, 16); this.ultraLabel6.TabIndex = 69; this.ultraLabel6.Text = "到"; // // Dte_PrdEnd // this.Dte_PrdEnd.FlatMode = true; this.Dte_PrdEnd.Location = new System.Drawing.Point(449, 26); this.Dte_PrdEnd.Name = "Dte_PrdEnd"; this.Dte_PrdEnd.Size = new System.Drawing.Size(100, 19); this.Dte_PrdEnd.TabIndex = 68; // // Dte_PrdBegin // this.Dte_PrdBegin.FlatMode = true; this.Dte_PrdBegin.Location = new System.Drawing.Point(319, 27); this.Dte_PrdBegin.Name = "Dte_PrdBegin"; this.Dte_PrdBegin.Size = new System.Drawing.Size(100, 19); this.Dte_PrdBegin.TabIndex = 67; // // Chk_Condole // this.Chk_Condole.FlatMode = true; this.Chk_Condole.Location = new System.Drawing.Point(398, 51); this.Chk_Condole.Name = "Chk_Condole"; this.Chk_Condole.Size = new System.Drawing.Size(80, 20); this.Chk_Condole.TabIndex = 71; this.Chk_Condole.Text = "板块吊号"; // // Txt_Condole // this.Txt_Condole.AutoSize = true; this.Txt_Condole.FlatMode = true; this.Txt_Condole.Location = new System.Drawing.Point(474, 51); this.Txt_Condole.Name = "Txt_Condole"; this.Txt_Condole.Size = new System.Drawing.Size(74, 19); this.Txt_Condole.TabIndex = 72; // // Chk_ButtressRemark // this.Chk_ButtressRemark.FlatMode = true; this.Chk_ButtressRemark.Location = new System.Drawing.Point(398, 75); this.Chk_ButtressRemark.Name = "Chk_ButtressRemark"; this.Chk_ButtressRemark.Size = new System.Drawing.Size(80, 20); this.Chk_ButtressRemark.TabIndex = 73; this.Chk_ButtressRemark.Text = "堆放备注"; // // Txt_BRemark // this.Txt_BRemark.AutoSize = true; this.Txt_BRemark.FlatMode = true; this.Txt_BRemark.Location = new System.Drawing.Point(474, 75); this.Txt_BRemark.Name = "Txt_BRemark"; this.Txt_BRemark.Size = new System.Drawing.Size(74, 19); this.Txt_BRemark.TabIndex = 74; // // chk_PlanNO // this.chk_PlanNO.FlatMode = true; this.chk_PlanNO.Location = new System.Drawing.Point(242, 52); this.chk_PlanNO.Name = "chk_PlanNO"; this.chk_PlanNO.Size = new System.Drawing.Size(80, 20); this.chk_PlanNO.TabIndex = 26; this.chk_PlanNO.Text = "现计划号"; // // txt_PlanNO // this.txt_PlanNO.AutoSize = true; this.txt_PlanNO.FlatMode = true; this.txt_PlanNO.Location = new System.Drawing.Point(319, 52); this.txt_PlanNO.Name = "txt_PlanNO"; this.txt_PlanNO.Size = new System.Drawing.Size(74, 19); this.txt_PlanNO.TabIndex = 27; // // cmb_Buttress // this.cmb_Buttress.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal; appearance1.BackColor = System.Drawing.SystemColors.Window; appearance1.BorderColor = System.Drawing.SystemColors.InactiveCaption; this.cmb_Buttress.DisplayLayout.Appearance = appearance1; this.cmb_Buttress.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid; this.cmb_Buttress.DisplayLayout.CaptionVisible = Infragistics.Win.DefaultableBoolean.False; appearance2.BackColor = System.Drawing.SystemColors.ActiveBorder; appearance2.BackColor2 = System.Drawing.SystemColors.ControlDark; appearance2.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical; appearance2.BorderColor = System.Drawing.SystemColors.Window; this.cmb_Buttress.DisplayLayout.GroupByBox.Appearance = appearance2; appearance3.ForeColor = System.Drawing.SystemColors.GrayText; this.cmb_Buttress.DisplayLayout.GroupByBox.BandLabelAppearance = appearance3; this.cmb_Buttress.DisplayLayout.GroupByBox.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid; appearance4.BackColor = System.Drawing.SystemColors.ControlLightLight; appearance4.BackColor2 = System.Drawing.SystemColors.Control; appearance4.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal; appearance4.ForeColor = System.Drawing.SystemColors.GrayText; this.cmb_Buttress.DisplayLayout.GroupByBox.PromptAppearance = appearance4; this.cmb_Buttress.DisplayLayout.MaxColScrollRegions = 1; this.cmb_Buttress.DisplayLayout.MaxRowScrollRegions = 1; appearance5.BackColor = System.Drawing.SystemColors.Window; appearance5.ForeColor = System.Drawing.SystemColors.ControlText; this.cmb_Buttress.DisplayLayout.Override.ActiveCellAppearance = appearance5; appearance6.BackColor = System.Drawing.SystemColors.Highlight; appearance6.ForeColor = System.Drawing.SystemColors.HighlightText; this.cmb_Buttress.DisplayLayout.Override.ActiveRowAppearance = appearance6; this.cmb_Buttress.DisplayLayout.Override.BorderStyleCell = Infragistics.Win.UIElementBorderStyle.Dotted; this.cmb_Buttress.DisplayLayout.Override.BorderStyleRow = Infragistics.Win.UIElementBorderStyle.Dotted; appearance7.BackColor = System.Drawing.SystemColors.Window; this.cmb_Buttress.DisplayLayout.Override.CardAreaAppearance = appearance7; appearance8.BorderColor = System.Drawing.Color.Silver; appearance8.TextTrimming = Infragistics.Win.TextTrimming.EllipsisCharacter; this.cmb_Buttress.DisplayLayout.Override.CellAppearance = appearance8; this.cmb_Buttress.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.EditAndSelectText; this.cmb_Buttress.DisplayLayout.Override.CellPadding = 0; appearance9.BackColor = System.Drawing.SystemColors.Control; appearance9.BackColor2 = System.Drawing.SystemColors.ControlDark; appearance9.BackGradientAlignment = Infragistics.Win.GradientAlignment.Element; appearance9.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal; appearance9.BorderColor = System.Drawing.SystemColors.Window; this.cmb_Buttress.DisplayLayout.Override.GroupByRowAppearance = appearance9; appearance10.TextHAlign = Infragistics.Win.HAlign.Left; this.cmb_Buttress.DisplayLayout.Override.HeaderAppearance = appearance10; this.cmb_Buttress.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortMulti; this.cmb_Buttress.DisplayLayout.Override.HeaderStyle = Infragistics.Win.HeaderStyle.WindowsXPCommand; appearance11.BackColor = System.Drawing.SystemColors.Window; appearance11.BorderColor = System.Drawing.Color.Silver; this.cmb_Buttress.DisplayLayout.Override.RowAppearance = appearance11; this.cmb_Buttress.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False; appearance12.BackColor = System.Drawing.SystemColors.ControlLight; this.cmb_Buttress.DisplayLayout.Override.TemplateAddRowAppearance = appearance12; this.cmb_Buttress.DisplayLayout.ScrollBounds = Infragistics.Win.UltraWinGrid.ScrollBounds.ScrollToFill; this.cmb_Buttress.DisplayLayout.ScrollStyle = Infragistics.Win.UltraWinGrid.ScrollStyle.Immediate; this.cmb_Buttress.DisplayLayout.ViewStyleBand = Infragistics.Win.UltraWinGrid.ViewStyleBand.OutlookGroupBy; this.cmb_Buttress.DisplayMember = ""; this.cmb_Buttress.FlatMode = true; this.cmb_Buttress.Location = new System.Drawing.Point(474, 98); this.cmb_Buttress.Name = "cmb_Buttress"; this.cmb_Buttress.Size = new System.Drawing.Size(75, 19); this.cmb_Buttress.TabIndex = 76; this.cmb_Buttress.ValueMember = ""; // // chk_Buttress // this.chk_Buttress.FlatMode = true; this.chk_Buttress.Location = new System.Drawing.Point(398, 98); this.chk_Buttress.Name = "chk_Buttress"; this.chk_Buttress.Size = new System.Drawing.Size(52, 20); this.chk_Buttress.TabIndex = 75; this.chk_Buttress.Text = "堆位"; // // cmb_SteelName // this.cmb_SteelName.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal; appearance13.BackColor = System.Drawing.SystemColors.Window; appearance13.BorderColor = System.Drawing.SystemColors.InactiveCaption; this.cmb_SteelName.DisplayLayout.Appearance = appearance13; this.cmb_SteelName.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid; this.cmb_SteelName.DisplayLayout.CaptionVisible = Infragistics.Win.DefaultableBoolean.False; appearance14.BackColor = System.Drawing.SystemColors.ActiveBorder; appearance14.BackColor2 = System.Drawing.SystemColors.ControlDark; appearance14.BackGradientStyle = Infragistics.Win.GradientStyle.Vertical; appearance14.BorderColor = System.Drawing.SystemColors.Window; this.cmb_SteelName.DisplayLayout.GroupByBox.Appearance = appearance14; appearance15.ForeColor = System.Drawing.SystemColors.GrayText; this.cmb_SteelName.DisplayLayout.GroupByBox.BandLabelAppearance = appearance15; this.cmb_SteelName.DisplayLayout.GroupByBox.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid; appearance16.BackColor = System.Drawing.SystemColors.ControlLightLight; appearance16.BackColor2 = System.Drawing.SystemColors.Control; appearance16.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal; appearance16.ForeColor = System.Drawing.SystemColors.GrayText; this.cmb_SteelName.DisplayLayout.GroupByBox.PromptAppearance = appearance16; this.cmb_SteelName.DisplayLayout.MaxColScrollRegions = 1; this.cmb_SteelName.DisplayLayout.MaxRowScrollRegions = 1; appearance17.BackColor = System.Drawing.SystemColors.Window; appearance17.ForeColor = System.Drawing.SystemColors.ControlText; this.cmb_SteelName.DisplayLayout.Override.ActiveCellAppearance = appearance17; appearance18.BackColor = System.Drawing.SystemColors.Highlight; appearance18.ForeColor = System.Drawing.SystemColors.HighlightText; this.cmb_SteelName.DisplayLayout.Override.ActiveRowAppearance = appearance18; this.cmb_SteelName.DisplayLayout.Override.BorderStyleCell = Infragistics.Win.UIElementBorderStyle.Dotted; this.cmb_SteelName.DisplayLayout.Override.BorderStyleRow = Infragistics.Win.UIElementBorderStyle.Dotted; appearance19.BackColor = System.Drawing.SystemColors.Window; this.cmb_SteelName.DisplayLayout.Override.CardAreaAppearance = appearance19; appearance20.BorderColor = System.Drawing.Color.Silver; appearance20.TextTrimming = Infragistics.Win.TextTrimming.EllipsisCharacter; this.cmb_SteelName.DisplayLayout.Override.CellAppearance = appearance20; this.cmb_SteelName.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.EditAndSelectText; this.cmb_SteelName.DisplayLayout.Override.CellPadding = 0; appearance21.BackColor = System.Drawing.SystemColors.Control; appearance21.BackColor2 = System.Drawing.SystemColors.ControlDark; appearance21.BackGradientAlignment = Infragistics.Win.GradientAlignment.Element; appearance21.BackGradientStyle = Infragistics.Win.GradientStyle.Horizontal; appearance21.BorderColor = System.Drawing.SystemColors.Window; this.cmb_SteelName.DisplayLayout.Override.GroupByRowAppearance = appearance21; appearance22.TextHAlign = Infragistics.Win.HAlign.Left; this.cmb_SteelName.DisplayLayout.Override.HeaderAppearance = appearance22; this.cmb_SteelName.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortMulti; this.cmb_SteelName.DisplayLayout.Override.HeaderStyle = Infragistics.Win.HeaderStyle.WindowsXPCommand; appearance23.BackColor = System.Drawing.SystemColors.Window; appearance23.BorderColor = System.Drawing.Color.Silver; this.cmb_SteelName.DisplayLayout.Override.RowAppearance = appearance23; this.cmb_SteelName.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False; appearance24.BackColor = System.Drawing.SystemColors.ControlLight; this.cmb_SteelName.DisplayLayout.Override.TemplateAddRowAppearance = appearance24; this.cmb_SteelName.DisplayLayout.ScrollBounds = Infragistics.Win.UltraWinGrid.ScrollBounds.ScrollToFill; this.cmb_SteelName.DisplayLayout.ScrollStyle = Infragistics.Win.UltraWinGrid.ScrollStyle.Immediate; this.cmb_SteelName.DisplayLayout.ViewStyleBand = Infragistics.Win.UltraWinGrid.ViewStyleBand.OutlookGroupBy; this.cmb_SteelName.DisplayMember = ""; this.cmb_SteelName.FlatMode = true; this.cmb_SteelName.Location = new System.Drawing.Point(319, 98); this.cmb_SteelName.Name = "cmb_SteelName"; this.cmb_SteelName.Size = new System.Drawing.Size(72, 19); this.cmb_SteelName.TabIndex = 78; this.cmb_SteelName.ValueMember = ""; // // chk_SteelName // this.chk_SteelName.FlatMode = true; this.chk_SteelName.Location = new System.Drawing.Point(242, 98); this.chk_SteelName.Name = "chk_SteelName"; this.chk_SteelName.Size = new System.Drawing.Size(55, 20); this.chk_SteelName.TabIndex = 77; this.chk_SteelName.Text = "牌号"; // // txt_PactNO // this.txt_PactNO.AutoSize = true; this.txt_PactNO.FlatMode = true; this.txt_PactNO.Location = new System.Drawing.Point(77, 103); this.txt_PactNO.Name = "txt_PactNO"; this.txt_PactNO.Size = new System.Drawing.Size(159, 19); this.txt_PactNO.TabIndex = 80; // // chk_PactNO // this.chk_PactNO.FlatMode = true; this.chk_PactNO.Location = new System.Drawing.Point(3, 103); this.chk_PactNO.Name = "chk_PactNO"; this.chk_PactNO.Size = new System.Drawing.Size(59, 20); this.chk_PactNO.TabIndex = 79; this.chk_PactNO.Text = "合同"; // // ctlKCJListQuery // this.AutoSize = true; this.Controls.Add(this.txt_PactNO); this.Controls.Add(this.chk_PactNO); this.Controls.Add(this.cmb_SteelName); this.Controls.Add(this.chk_SteelName); this.Controls.Add(this.cmb_Buttress); this.Controls.Add(this.chk_Buttress); this.Controls.Add(this.Txt_BRemark); this.Controls.Add(this.Txt_Condole); this.Controls.Add(this.Dte_PrdEnd); this.Controls.Add(this.txt_NPlanOrder); this.Controls.Add(this.Dte_End); this.Controls.Add(this.txt_PlanNO); this.Controls.Add(this.Dte_PrdBegin); this.Controls.Add(this.Dte_Begin); this.Controls.Add(this.txt_LenghtBegin); this.Controls.Add(this.txt_WidthBegin); this.Controls.Add(this.txt_PlyBegin); this.Controls.Add(this.txt_RollNumBegin); this.Controls.Add(this.Chk_ButtressRemark); this.Controls.Add(this.Chk_Condole); this.Controls.Add(this.ultraLabel6); this.Controls.Add(this.Chk_PrdTime); this.Controls.Add(this.chk_NPlanOrder); this.Controls.Add(this.ultraLabel5); this.Controls.Add(this.chk_InStorageTime); this.Controls.Add(this.chk_PlanNO); this.Controls.Add(this.txt_LengthEnd); this.Controls.Add(this.ultraLabel4); this.Controls.Add(this.chk_Length); this.Controls.Add(this.txt_WidthEnd); this.Controls.Add(this.ultraLabel3); this.Controls.Add(this.chk_Width); this.Controls.Add(this.txt_PlyEnd); this.Controls.Add(this.ultraLabel2); this.Controls.Add(this.chk_Ply); this.Controls.Add(this.txt_RollNumEnd); this.Controls.Add(this.ultraLabel1); this.Controls.Add(this.txt_RollTop); this.Controls.Add(this.chk_RollNum); this.Name = "ctlKCJListQuery"; this.Size = new System.Drawing.Size(562, 138); ((System.ComponentModel.ISupportInitialize)(this.txt_RollTop)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_RollNumBegin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_RollNumEnd)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlyBegin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlyEnd)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_WidthEnd)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_WidthBegin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_LengthEnd)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_LenghtBegin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_Begin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_End)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_NPlanOrder)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_PrdEnd)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Dte_PrdBegin)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Txt_Condole)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.Txt_BRemark)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PlanNO)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cmb_Buttress)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.cmb_SteelName)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_PactNO)).EndInit(); this.ResumeLayout(false); } #endregion #region "Preporty" private System.Data.DataSet _MyDataSet = null; public System.Data.DataSet MyDataSet { set { _MyDataSet = value; StorageBaseClass.Init_ComboControl(this.cmb_SteelName,"XT_PH|PHMC|PHMC",ref this._MyDataSet); StorageBaseClass.Init_ComboControl(this.cmb_Buttress,"XT_DW|BUTTRESSCODE|BUTTRESS",ref this._MyDataSet); } } private string _WhereStr = ""; public string WhereStr { get { _WhereStr = GetSteelCondition(); _WhereStr = _WhereStr + GetButtressCondition(); _WhereStr = _WhereStr + GetPactNOCondition(); _WhereStr = _WhereStr + GetRollNOCondition(); _WhereStr = _WhereStr + GetPlyCondition(); _WhereStr = _WhereStr + GetWidthCondition(); _WhereStr = _WhereStr + GetLengthCondition(); _WhereStr = _WhereStr + GetPlanNOCondition(); _WhereStr = _WhereStr + GetNPlanOrder(); _WhereStr = _WhereStr + GetPrdStorageDate(); _WhereStr = _WhereStr + GetCondoleCondition(); _WhereStr = _WhereStr + GetButtressRemarkCondition(); return _WhereStr; } } private string _SendWhereStr = ""; public string SendWhereStr { get { _SendWhereStr = GetSteelCondition(); _SendWhereStr = _SendWhereStr + " AND B.ORDERFORMNUMBER=C.ORDERNO "; _SendWhereStr = _SendWhereStr + GetPactNOCondition(); _SendWhereStr = _SendWhereStr + GetRollNOCondition(); _SendWhereStr = _SendWhereStr + GetPlyCondition(); _SendWhereStr = _SendWhereStr + GetWidthCondition(); _SendWhereStr = _SendWhereStr + GetLengthCondition(); _SendWhereStr = _SendWhereStr + GetPlanNOCondition(); //_WhereStr = _WhereStr + GetDummyButtressCondition(); _SendWhereStr = _SendWhereStr + GetInStorageDate(); _SendWhereStr = _SendWhereStr + GetNPlanOrder(); _SendWhereStr = _SendWhereStr + GetPrdStorageDate(); //_SendWhereStr = _SendWhereStr + GetBeforeSendCondition(); //_SendWhereStr = _SendWhereStr + GetNotInButtress(); _SendWhereStr = _SendWhereStr + GetCondoleCondition(); if(_SendWhereStr==" AND B.ORDERFORMNUMBER=C.ORDERNO ") { _SendWhereStr=_SendWhereStr + " AND B.ID='1' "; } return _SendWhereStr; } } private string _CSendWhereStr = ""; public string CSendWhereStr { get { _CSendWhereStr = GetSteelCondition(); _CSendWhereStr = _CSendWhereStr + " AND B.ORDERFORMNUMBER=C.ORDERNO "; _CSendWhereStr = _CSendWhereStr + GetPactNOCondition(); _CSendWhereStr = _CSendWhereStr + GetRollNOCondition(); _CSendWhereStr = _CSendWhereStr + GetPlyCondition(); _CSendWhereStr = _CSendWhereStr + GetWidthCondition(); _CSendWhereStr = _CSendWhereStr + GetLengthCondition(); _CSendWhereStr = _CSendWhereStr + GetPlanNOCondition(); _CSendWhereStr = _CSendWhereStr + GetInStorageDate(); _CSendWhereStr = _CSendWhereStr + GetNPlanOrder(); _CSendWhereStr = _CSendWhereStr + GetPrdStorageDate(); //_CSendWhereStr = _CSendWhereStr + GetBeforeSendCondition(); //_CSendWhereStr = _CSendWhereStr + GetNotInButtress(); _CSendWhereStr = _CSendWhereStr + GetCondoleCondition(); if(_CSendWhereStr==" AND B.ORDERFORMNUMBER=C.ORDERNO ") { _CSendWhereStr=_CSendWhereStr + " AND B.ID='1' "; } return _CSendWhereStr; } } #endregion #region "Method" //牌号 private string GetSteelCondition() { try { string rtnStr = ""; if(this.chk_SteelName.Checked) { if(this.cmb_SteelName.Text.Trim().Length>0) { rtnStr = " A.DETERMINANTCARDNUMBER='"+this.cmb_SteelName.Text.Trim()+"' "; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //垛位 private string GetButtressCondition() { try { if(this.chk_Buttress.Checked) { string rtnStr = ""; rtnStr = " AND B.BUTTRESS='"+StorageBaseClass.CheckNullStr(this.cmb_Buttress.Value)+"' "; return rtnStr; } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //堆放备注 private string GetButtressRemarkCondition() { try { string rtnStr = ""; if(this.Chk_ButtressRemark.Checked) { if(this.Txt_BRemark.Text.Trim().Length>0) { rtnStr = " AND B.HANDREMARK LIKE '%" + this.Txt_BRemark.Text.Trim() + "%' "; } } return rtnStr; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //合同号 private string GetPactNOCondition() { try { if(this.chk_PactNO.Checked) { string rtnStr = ""; rtnStr = " AND C.PACTNO='"+this.txt_PactNO.Text.Trim()+"' "; return rtnStr; } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //轧批号 private string GetRollNOCondition() { try { if(this.chk_RollNum.Checked) { string rtnStr = " AND SUBSTR(A.ROLLNUMBER,1,INSTR(A.ROLLNUMBER,'-')-1)='"+this.txt_RollTop.Text.Trim()+"' "; if(this.txt_RollNumBegin.Text.Trim().Length==5 && this.txt_RollNumEnd.Text.Trim().Length<5) { rtnStr = rtnStr + " AND SUBSTR(A.ROLLNUMBER,INSTR(A.ROLLNUMBER,'-')+1,5)='"+this.txt_RollNumBegin.Text.Trim()+"'"; return rtnStr; } if(this.txt_RollNumBegin.Text.Trim().Length<5 && this.txt_RollNumEnd.Text.Trim().Length==5) { rtnStr = rtnStr + " AND SUBSTR(A.ROLLNUMBER,INSTR(A.ROLLNUMBER,'-')+1,5)<='"+this.txt_RollNumEnd.Text.Trim()+"'"; return rtnStr; } if(this.txt_RollNumBegin.Text.Trim().Length==5 && this.txt_RollNumEnd.Text.Trim().Length==5) { rtnStr = rtnStr + " AND SUBSTR(A.ROLLNUMBER,INSTR(A.ROLLNUMBER,'-')+1,5)<='"+this.txt_RollNumEnd.Text.Trim()+"'" + " AND SUBSTR(A.ROLLNUMBER,INSTR(A.ROLLNUMBER,'-')+1,5)>='"+this.txt_RollNumBegin.Text.Trim()+"'"; return rtnStr; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //厚度 private string GetPlyCondition() { try { if(this.chk_Ply.Checked) { string rtnStr = ""; if(StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value)==0) { rtnStr = " AND A.PLY="+StorageBaseClass.CheckNullStr(this.txt_PlyBegin.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value)==0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value)>0) { rtnStr = " AND A.PLY<="+StorageBaseClass.CheckNullStr(this.txt_PlyEnd.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_PlyBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_PlyEnd.Value)>0) { rtnStr = " AND A.PLY>="+StorageBaseClass.CheckNullStr(this.txt_PlyBegin.Value) +" AND A.PLY<="+StorageBaseClass.CheckNullStr(this.txt_PlyEnd.Value); return rtnStr; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //宽度 private string GetWidthCondition() { try { if(this.chk_Width.Checked) { string rtnStr = ""; if(StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value)==0) { rtnStr = " AND A.WIDTH="+StorageBaseClass.CheckNullStr(this.txt_WidthBegin.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value)==0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value)>0) { rtnStr = " AND A.WIDTH<="+StorageBaseClass.CheckNullStr(this.txt_WidthEnd.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_WidthBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_WidthEnd.Value)>0) { rtnStr = " AND A.WIDTH>="+StorageBaseClass.CheckNullStr(this.txt_WidthBegin.Value) +" AND A.WIDTH<="+StorageBaseClass.CheckNullStr(this.txt_WidthEnd.Value); return rtnStr; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //长度 private string GetLengthCondition() { try { if(this.chk_Length.Checked) { string rtnStr = ""; if(StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value)==0) { rtnStr = " AND A.LENGTH="+StorageBaseClass.CheckNullStr(this.txt_LenghtBegin.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value)==0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value)>0) { rtnStr = " AND A.LENGTH<="+StorageBaseClass.CheckNullStr(this.txt_LengthEnd.Value); return rtnStr; } if(StorageBaseClass.CheckDecimal(this.txt_LenghtBegin.Value)>0 && StorageBaseClass.CheckDecimal(this.txt_LengthEnd.Value)>0) { rtnStr = " AND A.LENGTH>="+StorageBaseClass.CheckNullStr(this.txt_LenghtBegin.Value) +" AND A.LENGTH<="+StorageBaseClass.CheckNullStr(this.txt_LengthEnd.Value); return rtnStr; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //计划号 private string GetPlanNOCondition() { try { if(this.chk_PlanNO.Checked) { string rtnStr = ""; if(this.txt_PlanNO.Text.Trim().Length>0) { rtnStr = " AND C.PACTINDEX LIKE '%"+this.txt_PlanNO.Text.Trim()+"%' "; return rtnStr; } } return ""; } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); return ""; } } //入库时间 private string GetInStorageDate() { string rtnStr = ""; if(this.chk_InStorageTime.Checked) { rtnStr = " AND TO_CHAR(A.INTIME,'YYYYMMDD')>='" + Convert.ToDateTime(this.Dte_Begin.Value).ToString("yyyyMMdd") + "' " + " AND TO_CHAR(A.INTIME,'YYYYMMDD')<='" + Convert.ToDateTime(this.Dte_End.Value).ToString("yyyyMMdd") + "' "; } return rtnStr; } //分配订单 private string GetNPlanOrder() { string rtnStr = ""; if(this.chk_NPlanOrder.Checked && this.txt_NPlanOrder.Text.Length>0) { rtnStr = " AND A.ORDERNO LIKE '"+this.txt_NPlanOrder.Text+"%' "; } return rtnStr; } //生产时间 private string GetPrdStorageDate() { string rtnStr = ""; if(this.Chk_PrdTime.Checked) { rtnStr = " AND TO_CHAR(A.PTIME,'YYYYMMDD')>='" + Convert.ToDateTime(this.Dte_PrdBegin.Value).ToString("yyyyMMdd") + "' " + " AND TO_CHAR(A.PTIME,'YYYYMMDD')<='" + Convert.ToDateTime(this.Dte_PrdEnd.Value).ToString("yyyyMMdd") + "' "; } return rtnStr; } //吊号 private string GetCondoleCondition() { string rtnStr = ""; if(this.Chk_Condole.Checked) { rtnStr = " AND B.CONDOLENUMBER LIKE '%" + this.Txt_Condole.Text + "%' "; return rtnStr; } return ""; } #endregion #region "Button Event" private void btn_ButtressManager_Click(object sender, System.EventArgs e) { try { if (Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "付志刚" & Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "刘裕" & Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "邱蓉" & Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "管理员") { MessageBox.Show("您的权限不能操作!"); return; } Core.XgMes.Client.TurnoffReport.Dialog.FrmDummyButtressDialog frm = new Core.XgMes.Client.TurnoffReport.Dialog.FrmDummyButtressDialog(); frm.Plid = "4001ZB1"; frm.Ops_Area.Visible = false; frm.ops_PactNO.Visible = false; frm.ops_PactNO1.Visible = false; frm.Ops_Area1.Visible = true; frm.Ops_Area6.Visible = false; frm.CustomSetName = "BUTTRESS"; frm.ShowDialog(); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void btn_CustomPactNO_Click(object sender, System.EventArgs e) { try { // Dialog.FrmDummyButtressDialog frm = new Core.XgMes.Client.TurnoffReport.Dialog.FrmDummyButtressDialog(); // frm.CustomSetName = "PACT"; // frm.ShowDialog(); } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } #endregion #region "OpSet Event" private void btn_CustomPactNO_Click_1(object sender, EventArgs e) { try { if (Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "付志刚" & Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "刘裕" & Core.Mes.ClientFrameWork.ClientCommon._UserInfo.UserName != "邱蓉") { MessageBox.Show("您的权限不能操作!"); return; } Core.XgMes.Client.TurnoffReport.Dialog.FrmDummyButtressDialog frm = new Core.XgMes.Client.TurnoffReport.Dialog.FrmDummyButtressDialog(); frm.Plid = "4001ZB1"; frm.CustomSetName = "PACT"; frm.Ops_Area.Visible = false; frm.Ops_Area1.Visible = false; frm.ops_PactNO.Visible = false; frm.ops_PactNO1.Visible = true; frm.ShowDialog(); } catch(System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } #endregion } }