From 5501d3eb49d5670f8c409dbbd2f5a30890e5245b Mon Sep 17 00:00:00 2001
From: ouyangqing <ouyangqing@DESKTOP-B85SG1D>
Date: 星期三, 13 一月 2021 11:01:29 +0800
Subject: [PATCH] nothing
---
SCM/单据资料/Gy_BarCodeDetailList.cs | 234 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 117 insertions(+), 117 deletions(-)
diff --git "a/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeDetailList.cs" "b/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeDetailList.cs"
index 3e6cb02..57deb6f 100644
--- "a/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeDetailList.cs"
+++ "b/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeDetailList.cs"
@@ -1,118 +1,118 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.ComponentModel;
-using System.Data;
-using System.Drawing;
-using System.Text;
-using System.Windows.Forms;
-
-namespace SCM
-{
- public partial class Gy_BarCodeDetailList : Form
- {
- //[h_c_barcodedetail]
+锘縰sing System;
+using System.Collections.Generic;
+using System.ComponentModel;
+using System.Data;
+using System.Drawing;
+using System.Text;
+using System.Windows.Forms;
+
+namespace SCM
+{
+ public partial class Gy_BarCodeDetailList : Form
+ {
+ //[h_c_barcodedetail]
//h_c_barcodemain
- public Gy_BarCodeDetailList()
- {
- InitializeComponent();
- dateTimePicker1.Text = DateTime.Now.AddDays(-7).ToString();
- dateTimePicker2.Text = DateTime.Now.ToString();
- comboBox1.SelectedItem = "鍏ㄩ儴";
- comboBox2.SelectedItem = "榛樿鎺掑簭";
- oWeb.Url = SCM.ClsPub1.WEBSURL;
- }
- public frmBillQueryCondition_Base frmCondition;
- public string ViewName = "h_c_barcodedetail";
- public string ModCaption = "鎴愬搧鍒嗗垏妫�楠屾槑缁嗚〃";
- public const string ModName = "1250";
- public string sDlgWhere = ""; //澶栫獥浣撻�掑叆
- public int selectRow = 0;
- SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
- /// <summary>
- /// 鏌ヨ
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void cx_Click(object sender, EventArgs e)
- {
- Display();
- }
- public void SetCondition(frmBillQueryCondition_Base frmCondition, string ViewName, string Name)
- {
- frmCondition.Tag = "";
- frmCondition.ViewName = ViewName;
- frmCondition.ModName = Name;
- }
- private void Display()
- {
- StringBuilder whereBuilder = new StringBuilder();
- if (string.IsNullOrEmpty(dateTimePicker1.Text) || string.IsNullOrEmpty(dateTimePicker2.Text))
- {
- MessageBox.Show("杈撳叆鏃堕棿涓嶈兘涓虹┖");
- return;
- }
- if(DateTime.Parse(dateTimePicker1.Text)> DateTime.Parse(dateTimePicker2.Text))
- {
- MessageBox.Show("寮�濮嬫椂闂翠笉鑳藉ぇ浜庢埅鑷虫椂闂�");
- return;
- }
- whereBuilder.Append(" and a.HMakeDate>''"+dateTimePicker1.Text+"'' and a.HMakeDate<''"+dateTimePicker2.Text+"''");
- if (!string.IsNullOrEmpty(txtHBillNo.Text))
- whereBuilder.Append(" and a.HMaterName like ''"+txtHBillNo.Text+"''");
- if(!string.IsNullOrEmpty(textBox1.Text))
- whereBuilder.Append(" and b.FNUMBER like ''%"+textBox1.Text+"%'");
- if (!string.IsNullOrEmpty(textBox2.Text))
- whereBuilder.Append(" and c.FLOT_TEXT like ''%"+textBox2.Text+"%''");
- if(comboBox1.Text!="鍏ㄩ儴")
- whereBuilder.Append(" and a.HRemark=''"+comboBox1.Text+"''");
- if (!string.IsNullOrEmpty(textBox4.Text))
- whereBuilder.Append(" and d.HName like ''%"+textBox4.Text+"%''");
- if (!string.IsNullOrEmpty(textBox5.Text))
- whereBuilder.Append(" and e.HName like ''%"+textBox5.Text+"%''");
- if (!string.IsNullOrEmpty(textBox6.Text))
- whereBuilder.Append(" and a.HWorkLineName like ''%"+textBox6.Text+"%''");
- string orderBy = " order by a.HMakeDate desc ";
- if(comboBox2.Text=="浜у搧鍚嶇О")
- {
- orderBy = " order by a.HMaterName desc ";
- }
- if(comboBox2.Text=="鎵规鎺掑簭")
- {
- orderBy = " order by a.HBatchNo desc";
- }
- string execSql = "exec "+ViewName+" '"+whereBuilder+"','"+orderBy+"'";
- DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
- //鐢熸垚棣栬鏍囬
- if (DSet == null)
- {
- MessageBox.Show("娌℃湁杩斿洖浠讳綍缁撴灉,璇峰湪杩囨护妗嗕腑鐐瑰嚮銆愭仮澶嶃�戞寜閽�,灏濊瘯鍐嶆鏌ヨ锛�" + DBUtility.ClsPub.sExeReturnInfo);
- return;
- }
- //
- grdMain.DataSource = DSet.Tables[0].DefaultView;
- //鍐荤粨
- //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
- //string s = frmCondition.cmbHComplete.Text;
- //ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);
- }
- /// <summary>
- /// 閫�鍑�
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tc_Click(object sender, EventArgs e)
- {
- this.Close();
- }
-
- private void groupBox1_Enter(object sender, EventArgs e)
- {
-
- }
-
- private void label9_Click(object sender, EventArgs e)
- {
-
- }
- }
-}
+ public Gy_BarCodeDetailList()
+ {
+ InitializeComponent();
+ dateTimePicker1.Text = DateTime.Now.AddDays(-7).ToString();
+ dateTimePicker2.Text = DateTime.Now.ToString();
+ comboBox1.SelectedItem = "鍏ㄩ儴";
+ comboBox2.SelectedItem = "榛樿鎺掑簭";
+ oWeb.Url = SCM.ClsPub1.WEBSURL;
+ }
+ public frmBillQueryCondition_Base frmCondition;
+ public string ViewName = "h_c_barcodedetail";
+ public string ModCaption = "鎴愬搧鍒嗗垏妫�楠屾槑缁嗚〃";
+ public const string ModName = "1250";
+ public string sDlgWhere = ""; //澶栫獥浣撻�掑叆
+ public int selectRow = 0;
+ SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
+ /// <summary>
+ /// 鏌ヨ
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
+ private void cx_Click(object sender, EventArgs e)
+ {
+ Display();
+ }
+ public void SetCondition(frmBillQueryCondition_Base frmCondition, string ViewName, string Name)
+ {
+ frmCondition.Tag = "";
+ frmCondition.ViewName = ViewName;
+ frmCondition.ModName = Name;
+ }
+ private void Display()
+ {
+ StringBuilder whereBuilder = new StringBuilder();
+ if (string.IsNullOrEmpty(dateTimePicker1.Text) || string.IsNullOrEmpty(dateTimePicker2.Text))
+ {
+ MessageBox.Show("杈撳叆鏃堕棿涓嶈兘涓虹┖");
+ return;
+ }
+ if(DateTime.Parse(dateTimePicker1.Text)> DateTime.Parse(dateTimePicker2.Text))
+ {
+ MessageBox.Show("寮�濮嬫椂闂翠笉鑳藉ぇ浜庢埅鑷虫椂闂�");
+ return;
+ }
+ whereBuilder.Append(" and a.HMakeDate>''"+dateTimePicker1.Text+"'' and a.HMakeDate<''"+dateTimePicker2.Text+"''");
+ if (!string.IsNullOrEmpty(txtHBillNo.Text))
+ whereBuilder.Append(" and a.HMaterName like ''%"+txtHBillNo.Text+"%''");
+ if(!string.IsNullOrEmpty(textBox1.Text))
+ whereBuilder.Append(" and b.FNUMBER like ''%"+textBox1.Text+"%'");
+ if (!string.IsNullOrEmpty(textBox2.Text))
+ whereBuilder.Append(" and c.FLOT_TEXT like ''%"+textBox2.Text+"%''");
+ if(comboBox1.Text!="鍏ㄩ儴")
+ whereBuilder.Append(" and a.HRemark=''"+comboBox1.Text+"''");
+ if (!string.IsNullOrEmpty(textBox4.Text))
+ whereBuilder.Append(" and d.HName like ''%"+textBox4.Text+"%''");
+ if (!string.IsNullOrEmpty(textBox5.Text))
+ whereBuilder.Append(" and e.HName like ''%"+textBox5.Text+"%''");
+ if (!string.IsNullOrEmpty(textBox6.Text))
+ whereBuilder.Append(" and a.HWorkLineName like ''%"+textBox6.Text+"%''");
+ string orderBy = " order by a.HMakeDate desc ";
+ if(comboBox2.Text=="浜у搧鍚嶇О")
+ {
+ orderBy = " order by a.HMaterName desc ";
+ }
+ if(comboBox2.Text=="鎵规鎺掑簭")
+ {
+ orderBy = " order by a.HBatchNo desc";
+ }
+ string execSql = "exec "+ViewName+" '"+whereBuilder+"','"+orderBy+"'";
+ DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
+ //鐢熸垚棣栬鏍囬
+ if (DSet == null)
+ {
+ MessageBox.Show("娌℃湁杩斿洖浠讳綍缁撴灉,璇峰湪杩囨护妗嗕腑鐐瑰嚮銆愭仮澶嶃�戞寜閽�,灏濊瘯鍐嶆鏌ヨ锛�" + DBUtility.ClsPub.sExeReturnInfo);
+ return;
+ }
+ //
+ grdMain.DataSource = DSet.Tables[0].DefaultView;
+ //鍐荤粨
+ //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
+ //string s = frmCondition.cmbHComplete.Text;
+ //ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);
+ }
+ /// <summary>
+ /// 閫�鍑�
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
+ private void tc_Click(object sender, EventArgs e)
+ {
+ this.Close();
+ }
+
+ private void groupBox1_Enter(object sender, EventArgs e)
+ {
+
+ }
+
+ private void label9_Click(object sender, EventArgs e)
+ {
+
+ }
+ }
+}
--
Gitblit v1.9.1