From 3a6cdf317b885f0e569a5ba6e110930e5a6f0e1f Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期四, 11 三月 2021 14:40:45 +0800
Subject: [PATCH] 修改了成品分切检验明细报表产品类型过滤
---
SCM/单据资料/Gy_BarCodeDetailList.cs | 11 +++++++++--
1 files changed, 9 insertions(+), 2 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 cab7521..7d141d2 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"
@@ -64,8 +64,15 @@
whereBuilder.Append(" and d.FNUMBER like ''%"+textBox1.Text+"%''");
if (!string.IsNullOrEmpty(textBox2.Text))
whereBuilder.Append(" and b.FLOT_TEXT like ''%"+textBox2.Text+"%''");
- if(comboBox1.Text!="鍏ㄩ儴")
- whereBuilder.Append(" and case when c.HProdLev='''' then ''鍚堟牸鍝�'' else c.HProdLev end =''" + comboBox1.Text+"''");
+ if (comboBox1.Text != "鍏ㄩ儴")
+ if (comboBox1.Text == "鍚堟牸鍝�")
+ {
+ whereBuilder.Append(" and c.HProdLev =''''");
+ }
+ else
+ {
+ whereBuilder.Append(" and c.HProdLev =''" + comboBox1.Text + "''");
+ }
if (!string.IsNullOrEmpty(textBox4.Text))
whereBuilder.Append(" and g.HName like ''%"+textBox4.Text+"%''");
if (!string.IsNullOrEmpty(textBox5.Text))
--
Gitblit v1.9.1