From 7f4176da59120413f62a25f3db656e0e36788f99 Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期四, 17 四月 2025 11:15:49 +0800 Subject: [PATCH] 把采购订单明细更换为存储过程 --- DevApp/Gs.DevApp/DevFrm/WW/Frm_WwTbl.Designer.cs | 141 ++++++++++++++++++++++++++++++----------------- 1 files changed, 90 insertions(+), 51 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwTbl.Designer.cs b/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwTbl.Designer.cs index adb8965..a0b824b 100644 --- a/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwTbl.Designer.cs +++ b/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwTbl.Designer.cs @@ -121,16 +121,18 @@ this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn(); this.gvMxDel = new DevExpress.XtraGrid.Columns.GridColumn(); this.repositoryItemButtonEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit(); + this.gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn(); this.panelMx1 = new DevExpress.XtraEditors.PanelControl(); + this.radOut = new DevExpress.XtraEditors.RadioGroup(); this.ucBtnPrint1 = new Gs.DevApp.UserControl.UcBtnPrint(); this.lbMxGuid = new DevExpress.XtraEditors.LabelControl(); this.txt_iCount_1 = new DevExpress.XtraEditors.TextEdit(); this.labelControl14 = new DevExpress.XtraEditors.LabelControl(); this.txt_psnQty_1 = new DevExpress.XtraEditors.TextEdit(); this.labelControl12 = new DevExpress.XtraEditors.LabelControl(); - this.txtKdy = new DevExpress.XtraEditors.TextEdit(); + this.txt_kQty = new DevExpress.XtraEditors.TextEdit(); this.labelControl13 = new DevExpress.XtraEditors.LabelControl(); - this.txtYdy = new DevExpress.XtraEditors.TextEdit(); + this.txt_yQty = new DevExpress.XtraEditors.TextEdit(); this.labelControl1 = new DevExpress.XtraEditors.LabelControl(); this.txtQuantity = new DevExpress.XtraEditors.TextEdit(); this.labelControl10 = new DevExpress.XtraEditors.LabelControl(); @@ -211,10 +213,11 @@ ((System.ComponentModel.ISupportInitialize)(this.repositoryItemButtonEdit1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.panelMx1)).BeginInit(); this.panelMx1.SuspendLayout(); + ((System.ComponentModel.ISupportInitialize)(this.radOut.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_iCount_1.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_psnQty_1.Properties)).BeginInit(); - ((System.ComponentModel.ISupportInitialize)(this.txtKdy.Properties)).BeginInit(); - ((System.ComponentModel.ISupportInitialize)(this.txtYdy.Properties)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.txt_kQty.Properties)).BeginInit(); + ((System.ComponentModel.ISupportInitialize)(this.txt_yQty.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txtQuantity.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txtWlgg.Properties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.txtWlmc.Properties)).BeginInit(); @@ -264,6 +267,7 @@ // split1 // this.split1.Dock = System.Windows.Forms.DockStyle.Fill; + this.split1.FixedPanel = DevExpress.XtraEditors.SplitFixedPanel.Panel2; this.split1.Horizontal = false; this.split1.Location = new System.Drawing.Point(0, 0); this.split1.Name = "split1"; @@ -277,8 +281,9 @@ // split1.Panel2 // this.split1.Panel2.Text = "Panel2"; + this.split1.ShowSplitGlyph = DevExpress.Utils.DefaultBoolean.True; this.split1.Size = new System.Drawing.Size(1126, 592); - this.split1.SplitterPosition = 580; + this.split1.SplitterPosition = 0; this.split1.TabIndex = 0; // // gcMain1 @@ -530,6 +535,7 @@ // this.splitMx1.Panel2.Controls.Add(this.tabMx); this.splitMx1.Panel2.Text = "Panel2"; + this.splitMx1.ShowSplitGlyph = DevExpress.Utils.DefaultBoolean.True; this.splitMx1.Size = new System.Drawing.Size(1126, 592); this.splitMx1.SplitterPosition = 136; this.splitMx1.TabIndex = 0; @@ -976,7 +982,8 @@ this.gvMx1tld009, this.gridColumn1, this.gridColumn2, - this.gvMxDel}); + this.gvMxDel, + this.gridColumn5}); this.gvMx1.GridControl = this.gcMx1; this.gvMx1.Name = "gvMx1"; this.gvMx1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True; @@ -1074,7 +1081,7 @@ this.gvMx1tld006.Name = "gvMx1tld006"; this.gvMx1tld006.Tag = "query_a.tld006"; this.gvMx1tld006.Visible = true; - this.gvMx1tld006.VisibleIndex = 5; + this.gvMx1tld006.VisibleIndex = 6; this.gvMx1tld006.Width = 94; // // gvMx1tld007 @@ -1086,7 +1093,7 @@ this.gvMx1tld007.Name = "gvMx1tld007"; this.gvMx1tld007.Tag = "query_a.tld007"; this.gvMx1tld007.Visible = true; - this.gvMx1tld007.VisibleIndex = 6; + this.gvMx1tld007.VisibleIndex = 7; this.gvMx1tld007.Width = 94; // // gvMx1tld009 @@ -1098,7 +1105,7 @@ this.gvMx1tld009.Name = "gvMx1tld009"; this.gvMx1tld009.Tag = "query_a.tld009"; this.gvMx1tld009.Visible = true; - this.gvMx1tld009.VisibleIndex = 7; + this.gvMx1tld009.VisibleIndex = 8; this.gvMx1tld009.Width = 94; // // gridColumn1 @@ -1108,7 +1115,7 @@ this.gridColumn1.MinWidth = 25; this.gridColumn1.Name = "gridColumn1"; this.gridColumn1.Visible = true; - this.gridColumn1.VisibleIndex = 8; + this.gridColumn1.VisibleIndex = 9; this.gridColumn1.Width = 94; // // gridColumn2 @@ -1118,7 +1125,7 @@ this.gridColumn2.MinWidth = 25; this.gridColumn2.Name = "gridColumn2"; this.gridColumn2.Visible = true; - this.gridColumn2.VisibleIndex = 9; + this.gridColumn2.VisibleIndex = 10; this.gridColumn2.Width = 94; // // gvMxDel @@ -1128,7 +1135,7 @@ this.gvMxDel.MinWidth = 25; this.gvMxDel.Name = "gvMxDel"; this.gvMxDel.Visible = true; - this.gvMxDel.VisibleIndex = 10; + this.gvMxDel.VisibleIndex = 11; this.gvMxDel.Width = 94; // // repositoryItemButtonEdit1 @@ -1142,17 +1149,32 @@ this.repositoryItemButtonEdit1.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor; this.repositoryItemButtonEdit1.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.repositoryItemButtonEdit1_ButtonClick); // + // gridColumn5 + // + this.gridColumn5.AppearanceCell.ForeColor = System.Drawing.Color.Blue; + this.gridColumn5.AppearanceCell.Options.UseForeColor = true; + this.gridColumn5.AppearanceHeader.ForeColor = System.Drawing.Color.Blue; + this.gridColumn5.AppearanceHeader.Options.UseForeColor = true; + this.gridColumn5.Caption = "澶囨敞"; + this.gridColumn5.FieldName = "tld014"; + this.gridColumn5.MinWidth = 25; + this.gridColumn5.Name = "gridColumn5"; + this.gridColumn5.Visible = true; + this.gridColumn5.VisibleIndex = 5; + this.gridColumn5.Width = 94; + // // panelMx1 // + this.panelMx1.Controls.Add(this.radOut); this.panelMx1.Controls.Add(this.ucBtnPrint1); this.panelMx1.Controls.Add(this.lbMxGuid); this.panelMx1.Controls.Add(this.txt_iCount_1); this.panelMx1.Controls.Add(this.labelControl14); this.panelMx1.Controls.Add(this.txt_psnQty_1); this.panelMx1.Controls.Add(this.labelControl12); - this.panelMx1.Controls.Add(this.txtKdy); + this.panelMx1.Controls.Add(this.txt_kQty); this.panelMx1.Controls.Add(this.labelControl13); - this.panelMx1.Controls.Add(this.txtYdy); + this.panelMx1.Controls.Add(this.txt_yQty); this.panelMx1.Controls.Add(this.labelControl1); this.panelMx1.Controls.Add(this.txtQuantity); this.panelMx1.Controls.Add(this.labelControl10); @@ -1168,19 +1190,32 @@ this.panelMx1.Size = new System.Drawing.Size(1124, 98); this.panelMx1.TabIndex = 1; // + // radOut + // + this.radOut.Location = new System.Drawing.Point(772, 26); + this.radOut.Margin = new System.Windows.Forms.Padding(0); + this.radOut.Name = "radOut"; + this.radOut.Properties.ItemHorzAlignment = DevExpress.XtraEditors.RadioItemHorzAlignment.Near; + this.radOut.Properties.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] { + new DevExpress.XtraEditors.Controls.RadioGroupItem(null, "鍏ㄨ嚜鍔�"), + new DevExpress.XtraEditors.Controls.RadioGroupItem(null, "鍗婅嚜鍔�"), + new DevExpress.XtraEditors.Controls.RadioGroupItem(null, "鎵嬪姩")}); + this.radOut.Size = new System.Drawing.Size(248, 31); + this.radOut.TabIndex = 476; + // // ucBtnPrint1 // this.ucBtnPrint1.guidKey = null; - this.ucBtnPrint1.Location = new System.Drawing.Point(543, 68); + this.ucBtnPrint1.Location = new System.Drawing.Point(770, 60); this.ucBtnPrint1.Margin = new System.Windows.Forms.Padding(0); this.ucBtnPrint1.Name = "ucBtnPrint1"; this.ucBtnPrint1.rptParameter = null; - this.ucBtnPrint1.Size = new System.Drawing.Size(207, 25); + this.ucBtnPrint1.Size = new System.Drawing.Size(207, 32); this.ucBtnPrint1.TabIndex = 231; // // lbMxGuid // - this.lbMxGuid.Location = new System.Drawing.Point(821, 14); + this.lbMxGuid.Location = new System.Drawing.Point(770, 0); this.lbMxGuid.Name = "lbMxGuid"; this.lbMxGuid.Size = new System.Drawing.Size(58, 18); this.lbMxGuid.TabIndex = 229; @@ -1189,15 +1224,16 @@ // // txt_iCount_1 // - this.txt_iCount_1.Location = new System.Drawing.Point(654, 34); + this.txt_iCount_1.Location = new System.Drawing.Point(653, 64); this.txt_iCount_1.Name = "txt_iCount_1"; this.txt_iCount_1.Properties.Appearance.Options.UseFont = true; + this.txt_iCount_1.Properties.ReadOnly = true; this.txt_iCount_1.Size = new System.Drawing.Size(96, 24); this.txt_iCount_1.TabIndex = 228; // // labelControl14 // - this.labelControl14.Location = new System.Drawing.Point(543, 39); + this.labelControl14.Location = new System.Drawing.Point(542, 67); this.labelControl14.Name = "labelControl14"; this.labelControl14.Size = new System.Drawing.Size(105, 18); this.labelControl14.TabIndex = 227; @@ -1205,7 +1241,7 @@ // // txt_psnQty_1 // - this.txt_psnQty_1.Location = new System.Drawing.Point(654, 4); + this.txt_psnQty_1.Location = new System.Drawing.Point(653, 34); this.txt_psnQty_1.Name = "txt_psnQty_1"; this.txt_psnQty_1.Properties.Appearance.Options.UseFont = true; this.txt_psnQty_1.Size = new System.Drawing.Size(96, 24); @@ -1213,43 +1249,43 @@ // // labelControl12 // - this.labelControl12.Location = new System.Drawing.Point(543, 9); + this.labelControl12.Location = new System.Drawing.Point(542, 37); this.labelControl12.Name = "labelControl12"; this.labelControl12.Size = new System.Drawing.Size(105, 18); this.labelControl12.TabIndex = 225; this.labelControl12.Text = "姣忓紶鏉$爜鏁伴噺锛�"; // - // txtKdy + // txt_kQty // - this.txtKdy.Location = new System.Drawing.Point(430, 65); - this.txtKdy.Name = "txtKdy"; - this.txtKdy.Properties.Appearance.ForeColor = System.Drawing.Color.Blue; - this.txtKdy.Properties.Appearance.Options.UseFont = true; - this.txtKdy.Properties.Appearance.Options.UseForeColor = true; - this.txtKdy.Properties.ReadOnly = true; - this.txtKdy.Size = new System.Drawing.Size(96, 24); - this.txtKdy.TabIndex = 224; + this.txt_kQty.Location = new System.Drawing.Point(653, 6); + this.txt_kQty.Name = "txt_kQty"; + this.txt_kQty.Properties.Appearance.ForeColor = System.Drawing.Color.Blue; + this.txt_kQty.Properties.Appearance.Options.UseFont = true; + this.txt_kQty.Properties.Appearance.Options.UseForeColor = true; + this.txt_kQty.Properties.ReadOnly = true; + this.txt_kQty.Size = new System.Drawing.Size(96, 24); + this.txt_kQty.TabIndex = 224; // // labelControl13 // - this.labelControl13.Location = new System.Drawing.Point(332, 70); + this.labelControl13.Location = new System.Drawing.Point(557, 9); this.labelControl13.Name = "labelControl13"; this.labelControl13.Size = new System.Drawing.Size(90, 18); this.labelControl13.TabIndex = 223; this.labelControl13.Text = "鍙墦鍗版�绘暟锛�"; // - // txtYdy + // txt_yQty // - this.txtYdy.Location = new System.Drawing.Point(430, 34); - this.txtYdy.Name = "txtYdy"; - this.txtYdy.Properties.Appearance.Options.UseFont = true; - this.txtYdy.Properties.ReadOnly = true; - this.txtYdy.Size = new System.Drawing.Size(96, 24); - this.txtYdy.TabIndex = 222; + this.txt_yQty.Location = new System.Drawing.Point(430, 34); + this.txt_yQty.Name = "txt_yQty"; + this.txt_yQty.Properties.Appearance.Options.UseFont = true; + this.txt_yQty.Properties.ReadOnly = true; + this.txt_yQty.Size = new System.Drawing.Size(96, 24); + this.txt_yQty.TabIndex = 222; // // labelControl1 // - this.labelControl1.Location = new System.Drawing.Point(332, 39); + this.labelControl1.Location = new System.Drawing.Point(332, 37); this.labelControl1.Name = "labelControl1"; this.labelControl1.Size = new System.Drawing.Size(90, 18); this.labelControl1.TabIndex = 221; @@ -1257,7 +1293,7 @@ // // txtQuantity // - this.txtQuantity.Location = new System.Drawing.Point(430, 4); + this.txtQuantity.Location = new System.Drawing.Point(430, 6); this.txtQuantity.Name = "txtQuantity"; this.txtQuantity.Properties.Appearance.Options.UseFont = true; this.txtQuantity.Properties.ReadOnly = true; @@ -1270,20 +1306,20 @@ this.labelControl10.Name = "labelControl10"; this.labelControl10.Size = new System.Drawing.Size(105, 18); this.labelControl10.TabIndex = 219; - this.labelControl10.Text = "鏈鏀惰揣鎬婚噺锛�"; + this.labelControl10.Text = "鏈鐢宠鎬婚噺锛�"; // // txtWlgg // - this.txtWlgg.Location = new System.Drawing.Point(90, 65); + this.txtWlgg.Location = new System.Drawing.Point(90, 64); this.txtWlgg.Name = "txtWlgg"; this.txtWlgg.Properties.Appearance.Options.UseFont = true; this.txtWlgg.Properties.ReadOnly = true; - this.txtWlgg.Size = new System.Drawing.Size(215, 24); + this.txtWlgg.Size = new System.Drawing.Size(436, 24); this.txtWlgg.TabIndex = 218; // // labelControl9 // - this.labelControl9.Location = new System.Drawing.Point(11, 70); + this.labelControl9.Location = new System.Drawing.Point(11, 67); this.labelControl9.Name = "labelControl9"; this.labelControl9.Size = new System.Drawing.Size(75, 18); this.labelControl9.TabIndex = 217; @@ -1317,11 +1353,11 @@ // // labelControl7 // - this.labelControl7.Location = new System.Drawing.Point(25, 9); + this.labelControl7.Location = new System.Drawing.Point(11, 9); this.labelControl7.Name = "labelControl7"; - this.labelControl7.Size = new System.Drawing.Size(61, 18); + this.labelControl7.Size = new System.Drawing.Size(75, 18); this.labelControl7.TabIndex = 213; - this.labelControl7.Text = "鐗╂枡ID锛�"; + this.labelControl7.Text = "鐗╂枡缂栫爜锛�"; // // xtraTabPage3 // @@ -1558,10 +1594,11 @@ ((System.ComponentModel.ISupportInitialize)(this.panelMx1)).EndInit(); this.panelMx1.ResumeLayout(false); this.panelMx1.PerformLayout(); + ((System.ComponentModel.ISupportInitialize)(this.radOut.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_iCount_1.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txt_psnQty_1.Properties)).EndInit(); - ((System.ComponentModel.ISupportInitialize)(this.txtKdy.Properties)).EndInit(); - ((System.ComponentModel.ISupportInitialize)(this.txtYdy.Properties)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.txt_kQty.Properties)).EndInit(); + ((System.ComponentModel.ISupportInitialize)(this.txt_yQty.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txtQuantity.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txtWlgg.Properties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.txtWlmc.Properties)).EndInit(); @@ -1650,9 +1687,9 @@ private DevExpress.XtraEditors.LabelControl labelControl14; private DevExpress.XtraEditors.TextEdit txt_psnQty_1; private DevExpress.XtraEditors.LabelControl labelControl12; - private DevExpress.XtraEditors.TextEdit txtKdy; + private DevExpress.XtraEditors.TextEdit txt_kQty; private DevExpress.XtraEditors.LabelControl labelControl13; - private DevExpress.XtraEditors.TextEdit txtYdy; + private DevExpress.XtraEditors.TextEdit txt_yQty; private DevExpress.XtraEditors.LabelControl labelControl1; private DevExpress.XtraEditors.TextEdit txtQuantity; private DevExpress.XtraEditors.LabelControl labelControl10; @@ -1683,5 +1720,7 @@ private DevExpress.XtraLayout.LayoutControlItem layoutControlItem14; private DevExpress.XtraLayout.LayoutControlItem layoutControlItem12; private DevExpress.Utils.ToolTipController tips; + private DevExpress.XtraGrid.Columns.GridColumn gridColumn5; + private DevExpress.XtraEditors.RadioGroup radOut; } } \ No newline at end of file -- Gitblit v1.9.3