Пример #1
0
 private void txtCartonNo_KeyPress(object sender, KeyPressEventArgs e)
 {
     this.dataGrid1.DataSource = MaterialOnShelvesService.GetDataGrid(this.txtCartonNo.Text, this.txtLocationCode.Text);
     this.lblPlanQTY.Text      = MaterialOnShelvesService.GetPlanOnShelvesQTY(this.txtCartonNo.Text);
     this.lblActQTY.Text       = MaterialOnShelvesService.GetActOnShelvesQTY(this.txtCartonNo.Text);
     this.lblDQMcodeEdite.Text = MaterialOnShelvesService.GetCUSMcode(this.txtCartonNo.Text);
 }
Пример #2
0
        public void QueryGrid()
        {
            DataTable dt1 = new DataTable();

            dt1  = MaterialOnShelvesService.GetDataGrid(this.txtCartonNo.Text, this.txtLocationNo.Text);
            rows = dt1.Rows.Count;
            //this.dataGrid1.DataSource = dt1;
            if (dt1.Rows.Count > 0)
            {
                DataGridTableStyle ts = new DataGridTableStyle();
                ts.MappingName = dt1.TableName;

                DataGridColumnStyle ColStyle1 = new DataGridTextBoxColumn();
                ColStyle1.MappingName = dt1.Columns[0].ColumnName.ToString();
                ColStyle1.HeaderText  = "选择";
                ColStyle1.Width       = 20;
                ts.GridColumnStyles.Add(ColStyle1);

                DataGridColumnStyle ColStyle3 = new DataGridTextBoxColumn();
                ColStyle3.MappingName = dt1.Columns[1].ColumnName.ToString();
                ColStyle3.HeaderText  = "入库指令号";
                ts.GridColumnStyles.Add(ColStyle3);

                DataGridColumnStyle ColStyle4 = new DataGridTextBoxColumn();
                ColStyle4.MappingName = dt1.Columns[2].ColumnName.ToString();
                ColStyle4.HeaderText  = "箱号";
                ts.GridColumnStyles.Add(ColStyle4);

                DataGridColumnStyle ColStyle5 = new DataGridTextBoxColumn();
                ColStyle5.MappingName = dt1.Columns[3].ColumnName.ToString();
                ColStyle5.HeaderText  = "推荐货位";
                ts.GridColumnStyles.Add(ColStyle5);


                DataGridColumnStyle ColStyle6 = new DataGridTextBoxColumn();
                ColStyle6.MappingName = dt1.Columns[4].ColumnName.ToString();
                ColStyle6.HeaderText  = "货位";
                ts.GridColumnStyles.Add(ColStyle6);

                DataGridColumnStyle ColStyle7 = new DataGridTextBoxColumn();
                ColStyle7.MappingName = dt1.Columns[5].ColumnName.ToString();
                ColStyle7.HeaderText  = "鼎桥物料号";
                ts.GridColumnStyles.Add(ColStyle7);

                DataGridColumnStyle ColStyle8 = new DataGridTextBoxColumn();
                ColStyle8.MappingName = dt1.Columns[6].ColumnName.ToString();
                ColStyle8.HeaderText  = " ";
                ts.GridColumnStyles.Add(ColStyle8);

                this.dataGrid1.TableStyles.Clear();
                this.dataGrid1.TableStyles.Add(ts);
            }
            this.dataGrid1.DataSource = dt1;
            this.lblPlanQTY.Text      = MaterialOnShelvesService.GetPlanOnShelvesQTY(this.txtCartonNo.Text);
            this.lblActQTY.Text       = MaterialOnShelvesService.GetActOnShelvesQTY(this.txtCartonNo.Text);
            this.lblDQMcodeEdite.Text = MaterialOnShelvesService.GetCUSMcode(this.txtCartonNo.Text);
        }