汇总表检验状态筛选

ouyangqing

2021-01-19 7a1c5d244dc5b6f6fa62b3d8e3322b5a555948be

 SCM/µ¥¾Ý×ÊÁÏ/Gy_BarCodeMain.cs

@@ -16,6 +16,7 @@
            InitializeComponent();
            dateTimePicker1.Text = DateTime.Now.AddDays(-7).ToString();
            dateTimePicker2.Text = DateTime.Now.ToString();
            comboBox1.SelectedItem = "全部";
            oWeb.Url = SCM.ClsPub1.WEBSURL;
        }
        public frmBillQueryCondition_Base frmCondition;
@@ -49,6 +50,10 @@
                whereBuilder.Append(" and e.FNUMBER like ''%"+textBox1.Text+"%''");
            if (!string.IsNullOrEmpty(textBox2.Text))
                whereBuilder.Append(" and c.HMaterName like ''%"+textBox2.Text+"%''");
            if (comboBox1.Text == "已检验")
                whereBuilder.Append(" and c.HMaterName is not null");
            else if(comboBox1.Text=="未检验")
                whereBuilder.Append(" and c.HMaterName is null");
            var execSql = "exec "+ViewName+" '"+whereBuilder+"'";
            DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题