修改了成品分切检验明细报表产品类型过滤

ch

2021-03-11 3a6cdf317b885f0e569a5ba6e110930e5a6f0e1f

修改了成品分切检验明细报表产品类型过滤

 NETSCM/NETSCM.csproj

@@ -82,12 +82,6 @@
  </ItemGroup>

  <ItemGroup>

    <Compile Include="ClsShowMod.cs" />

    <Compile Include="Form2.cs">

      <SubType>Form</SubType>

    </Compile>

    <Compile Include="Form2.Designer.cs">

      <DependentUpon>Form2.cs</DependentUpon>

    </Compile>

    <Compile Include="Frm_Show.cs">

      <SubType>Form</SubType>

    </Compile>

@@ -102,9 +96,6 @@
    </Compile>

    <Compile Include="Program.cs" />

    <Compile Include="Properties\AssemblyInfo.cs" />

    <EmbeddedResource Include="Form2.resx">

      <DependentUpon>Form2.cs</DependentUpon>

    </EmbeddedResource>

    <EmbeddedResource Include="Frm_Show.resx">

      <DependentUpon>Frm_Show.cs</DependentUpon>

      <SubType>Designer</SubType>


 SCM/µ¥¾Ý×ÊÁÏ/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))


 SCM/Éú²ú¹ÜÀí/Sc_BZBillList.cs

@@ -80,6 +80,8 @@
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            dtpHBDate.Value = DBUtility.ClsPub.isDate(DateTime.Now.Date.ToShortDateString());
            dtpHEDate.Value = DBUtility.ClsPub.isDate(DateTime.Now.AddDays(1).ToShortDateString());
            if (Fun_AllowQuery())
            {
                initGrid();