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); }
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); }