Exemple #1
0
        List <Mod_TMO_ORDER> lst   = new List <Mod_TMO_ORDER>();//订单列表
        /// <summary>
        /// 查询订单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_query_order_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 = "";

            string strOrderNOlist = "";

            if (txt_order_no.Text.Trim() != "")
            {
                string[] OrderNo = txt_order_no.Text.Trim().Split(new string[] { "\r\n" }, StringSplitOptions.None);
                OrderNo = OrderNo.Where(s => !string.IsNullOrEmpty(s)).ToArray();
                if (OrderNo.Length > 0)
                {
                    for (int i = 0; i < OrderNo.Length; i++)
                    {
                        if (i == 0)
                        {
                            strOrderNOlist = "'" + OrderNo[i] + "'";
                        }
                        else
                        {
                            strOrderNOlist = strOrderNOlist + ",'" + OrderNo[i] + "'";
                        }
                    }
                }
            }
            // string aaa=   strOrderNOlist;

            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;              //是否完成

            int    gzlb      = this.rbtn_type.SelectedIndex; //0全部,1碳钢,2不锈钢,3钢坯
            string c_line_no = "";

            if (icbo_line.SelectedIndex >= 0)
            {
                c_line_no = icbo_line.Properties.Items[icbo_line.SelectedIndex].Value.ToString();
            }
            lst = bll_order.GetOrderListByWhere(gzlb, C_SFPJ, sfwc, n_sfqr, strOrderNOlist, "", this.txt_gz1.Text.Trim(), this.txt_zxbz1.Text.Trim(), txt_Spec.Text, "", strJQMin, strJQMax, strDDMin, strDDMax, c_line_no);

            this.modTMOORDERBindingSource.DataSource       = lst;
            this.gv_tmo_order.OptionsView.ColumnAutoWidth  = false;
            this.gv_tmo_order.OptionsSelection.MultiSelect = true;
            SetGridViewRowNum.SetRowNum(gv_tmo_order);
            this.gv_tmo_order.BestFitColumns();
            WaitingFrom.CloseWait();
        }