nothing

ouyangqing

2021-01-12 3788f6e62cf43864d165bb4f04bbf3b4cd5e54e4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
using 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 分切检验明细表 : Form
    {
        //[h_c_barcodedetail]
        //h_c_barcodemain
        public 分切检验明细表()
        {
            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)
        {
 
        }
    }
}