예제 #1
0
        private void btn_query_Click(object sender, EventArgs e)
        {
            if (this.dtp_form1.Text.Trim() == "" || this.dtp_end1.Text == "")
            {
                MessageBox.Show("请输入查询日期!");
                return;
            }
            WaitingFrom.ShowWait("订单正在加载,请稍后...");
            double?gg_min = null; //规格最小值

            if (this.txt_gg_min.Text.Trim() != "")
            {
                gg_min = Convert.ToDouble(this.txt_gg_min.Text.Trim());
            }
            double?gg_max = null; //规格最大值

            if (this.txt_gg_max.Text.Trim() != "" && Convert.ToDouble(this.txt_gg_max.Text.Trim()) > 0)
            {
                gg_max = Convert.ToDouble(this.txt_gg_max.Text.Trim());
            }
            string strJQMin = "";
            string strJQMax = "";
            string strDDMin = "";
            string strDDMax = "";

            if (cbo_date_type.Text == "计划日期")
            {
                strJQMin = Convert.ToDateTime(this.dtp_form1.Text).ToShortDateString() + " 00:00:00";
                strJQMax = Convert.ToDateTime(this.dtp_end1.Text).ToShortDateString() + " 23:59:59";
                strDDMin = "";
                strDDMax = "";
            }
            else
            {
                strJQMin = "";
                strJQMax = "";
                strDDMin = Convert.ToDateTime(this.dtp_form1.Text).ToShortDateString() + " 00:00:00";
                strDDMax = Convert.ToDateTime(this.dtp_end1.Text).ToShortDateString() + " 23:59:59";
            }
            string C_SFPJ = "";

            if (rbtn_sfpj.SelectedIndex == 0)
            {
                C_SFPJ = "";
            }
            else if (rbtn_sfpj.SelectedIndex == 1)
            {
                C_SFPJ = "N";
            }
            else
            {
                C_SFPJ = "Y";
            }

            int n_sfqr = rbtn_sfqr.SelectedIndex; //是否确认

            int sfwc = rbtn_sfwc.SelectedIndex;   //是否完成

            DataTable dt = bll_order.GetPlanZX(C_SFPJ, sfwc, n_sfqr, this.txt_order_no.Text.Trim(), "", this.txt_gz1.Text.Trim(), this.txt_zxbz1.Text.Trim(), gg_min, gg_max, txt_wlmc.Text.Trim(), strJQMin, strJQMax, strDDMin, strDDMax, "all");

            this.gridControl1.DataSource = dt;
            this.gridView1.OptionsView.ColumnAutoWidth  = false;
            this.gridView1.OptionsSelection.MultiSelect = true;
            SetGridViewRowNum.SetRowNum(gridView1);
            this.gridView1.BestFitColumns();
            WaitingFrom.CloseWait();
        }