From 60600714709204a02b3ffd476af96fd35fb67370 Mon Sep 17 00:00:00 2001
From: zgq <519541279@qq.com>
Date: 星期三, 13 一月 2021 10:34:23 +0800
Subject: [PATCH] 增加裁切报表
---
SCM/单据资料/Gy_BarCodeMain.cs | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git "a/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeMain.cs" "b/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeMain.cs"
index 4b153db..07ec3e1 100644
--- "a/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeMain.cs"
+++ "b/SCM/\345\215\225\346\215\256\350\265\204\346\226\231/Gy_BarCodeMain.cs"
@@ -6,7 +6,7 @@
using System.Text;
using System.Windows.Forms;
-namespace SCM.鍗曟嵁璧勬枡
+namespace SCM
{
public partial class Gy_BarCodeMain : Form
{
@@ -19,7 +19,7 @@
}
public frmBillQueryCondition_Base frmCondition;
public string ViewName = "h_c_barcodemain";
- public string ModCaption = "鎴愬垎鍒嗗垏妫�楠屾槑缁嗚〃";
+ public string ModCaption = "鎴愬搧鍒嗗垏妫�楠屾眹鎶ヨ〃";
public const string ModName = "1250";
public string sDlgWhere = ""; //澶栫獥浣撻�掑叆
public int selectRow = 0;
@@ -41,14 +41,14 @@
MessageBox.Show("寮�濮嬫椂闂翠笉鑳藉ぇ浜庢埅鑷虫椂闂�");
return;
}
- whereBuilder.Append($" and a.HMakeDate>''{dateTimePicker1.Text}'' and a.HMakeDate<''{dateTimePicker2.Text}''");
+ whereBuilder.Append(" and a.HMakeDate>''"+dateTimePicker1.Text+"'' and a.HMakeDate<''"+dateTimePicker2.Text+"''");
if (!string.IsNullOrEmpty(txtHBillNo.Text))
- whereBuilder.Append($" and a.HSourceBillNo like ''%{txtHBillNo.Text}%''");
+ whereBuilder.Append(" and a.HSourceBillNo like ''%"+txtHBillNo.Text+"%''");
if (!string.IsNullOrEmpty(textBox1.Text))
- whereBuilder.Append($" and a.b.FNUMBER like ''%{textBox1.Text}%''");
+ whereBuilder.Append(" and a.b.FNUMBER like ''%"+textBox1.Text+"''");
if (!string.IsNullOrEmpty(textBox2.Text))
- whereBuilder.Append($" and a.HMaterName like ''%{textBox2.Text}%''");
- var execSql = $"exec {ViewName} '{whereBuilder}'";
+ whereBuilder.Append(" and a.HMaterName like ''%"+textBox2.Text+"%''");
+ var execSql = "exec "+ViewName+" '"+whereBuilder+"'";
DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
//鐢熸垚棣栬鏍囬
if (DSet == null)
--
Gitblit v1.9.1