private void setCondition() { //绑定表数据 //string sql = "select t.RMES_ID,t.plineCODE,b.ROUTING_NAME,t.ITEMCODE,t.ITEMNAME,t.ITEMDESCRIPTION,t.MINVALUE,t.MAXVALUE,t.STANDARDVALUE,t.UNITNAME,decode(t.UNITTYPE,'N','数值','T','文字','B','判断','F','文件')UNITTYPE,t.ORDERING from qms_standard_item t " // + " left join data_pline_routing b on t.plineCODE=b.ROUTING_CODE order by t.plineCODE,t.ITEMCODE"; //DataTable dt = dc.GetTable(sql); List <DetectErrorItemEntity> entities = db.Fetch <DetectErrorItemEntity>(""); ASPxGridView1.DataSource = entities; GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll(); colPline.PropertiesComboBox.DataSource = plineEntities; colPline.PropertiesComboBox.ValueField = "PLINE_CODE"; colPline.PropertiesComboBox.TextField = "PLINE_NAME"; GridViewDataComboBoxColumn colworkUnit = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn; List <StationEntity> statinEntities = StationFactory.GetAll(); colworkUnit.PropertiesComboBox.DataSource = statinEntities; colworkUnit.PropertiesComboBox.ValueField = "WORKUNIT_CODE"; colworkUnit.PropertiesComboBox.TextField = "STATION_NAME"; ASPxGridView1.DataBind(); }
private void setCondition() { //初始化GRIDVIEW List <StationEntity> all = StationFactory.GetAll(); ASPxGridView1.DataSource = all; ASPxGridView1.DataBind(); }
public void BindData() { List <LineSideStoreEntity> allEntity = LinesideStoreFactory.GetAll(); ASPxGridView1.DataSource = allEntity; GridViewDataComboBoxColumn comPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; List <ProductLineEntity> allPline = ProductLineFactory.GetAll(); comPline.PropertiesComboBox.DataSource = allPline; comPline.PropertiesComboBox.TextField = "PLINE_NAME"; comPline.PropertiesComboBox.ValueField = "PLINE_CODE"; GridViewDataComboBoxColumn comWorkUnit = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn; List <StationEntity> allStation = StationFactory.GetAll(); comWorkUnit.PropertiesComboBox.DataSource = allStation; comWorkUnit.PropertiesComboBox.TextField = "STATION_NAME"; comWorkUnit.PropertiesComboBox.ValueField = "WORKUNIT_CODE"; GridViewDataComboBoxColumn comWorkShop = ASPxGridView1.Columns["WORKSHOP_CODE"] as GridViewDataComboBoxColumn; DataTable dt = new DataTable(); dt.Columns.Add("text"); dt.Columns.Add("value"); dt.Rows.Add("园区", 8101); dt.Rows.Add("基地", 8102); comWorkShop.PropertiesComboBox.DataSource = dt; comWorkShop.PropertiesComboBox.TextField = "text"; comWorkShop.PropertiesComboBox.ValueField = "value"; GridViewDataComboBoxColumn comStoreType = ASPxGridView1.Columns["STORE_TYPE"] as GridViewDataComboBoxColumn; DataTable dt1 = new DataTable(); dt1.Columns.Add("text"); dt1.Columns.Add("value"); dt1.Rows.Add("线边库", 0); dt1.Rows.Add("中心仓库", 1); comStoreType.PropertiesComboBox.DataSource = dt; comStoreType.PropertiesComboBox.TextField = "text"; comStoreType.PropertiesComboBox.ValueField = "value"; ASPxGridView1.DataBind(); }
private void initComboBoxByCompany() { initing = true; object val = null; val = comboBox1.SelectedValue; try { if (val != null) { comboBox2.DataSource = ProductLineFactory.GetByCompanyCode(val.ToString()); comboBox2.SelectedValue = DB.ReadConfigLocal("PRODUCTLINE_CODE"); setComboxBoxCurrent(comboBox2); val = comboBox2.SelectedValue; if (val != null) { comboBox3.DataSource = StationFactory.GetByProductLine(val.ToString()); } else { List <StationEntity> stas = StationFactory.GetAll(); var sta1 = from ss in stas where ss.COMPANY_CODE == LoginInfo.CompanyInfo.COMPANY_CODE select ss; comboBox3.DataSource = sta1.ToList <StationEntity>(); } comboBox6.SelectedValue = DB.ReadConfigLocal("WORKSHOP_CODE"); comboBox6.DataSource = WorkShopFactory.GetAll(); setComboxBoxCurrent(comboBox6); comboBox3.SelectedValue = DB.ReadConfigLocal("STATION_CODE"); setComboxBoxCurrent(comboBox3); comboBox4.DataSource = ShiftFactory.GetAll(); comboBox4.SelectedValue = DB.ReadConfigLocal("SHIFT_CODE"); setComboxBoxCurrent(comboBox4); comboBox5.DataSource = TeamFactory.GetByPlineCode(val.ToString()); comboBox5.SelectedValue = DB.ReadConfigLocal("TEAM_CODE"); setComboxBoxCurrent(comboBox5); } } catch { } initing = false; }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { if (initing) { return; } string plinermesid = comboBox2.SelectedValue.ToString(); DB.WriteConfigLocal("PRODUCTLINE_CODE", plinermesid); List <StationEntity> stations = StationFactory.GetAll(); var ss = from s in stations where s.PLINE_CODE == plinermesid && s.COMPANY_CODE == comboBox1.SelectedValue.ToString() select s; comboBox3.DataSource = ss.ToList <StationEntity>(); List <TeamEntity> teams = TeamFactory.GetByPlineCode(plinermesid); comboBox5.DataSource = teams; }