private void setCondition() { //绑定表数据 List <StationSubEntity> allEntity = StationSubFactory.GetAll(); List <string> plines = new List <string>(); foreach (var p in allEntity) { if ((!plines.Contains(p.PLINE_CODE)) && (!string.IsNullOrWhiteSpace(p.PLINE_CODE))) { plines.Add(p.PLINE_CODE); } } ASPxGridView1.DataSource = allEntity; GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; List <ProductLineEntity> plineEntities = ProductLineFactory.GetByIDs(plines.ToArray()); colPline.PropertiesComboBox.DataSource = plineEntities; colPline.PropertiesComboBox.ValueField = "RMES_ID"; colPline.PropertiesComboBox.TextField = "PLINE_NAME"; ASPxGridView1.DataBind(); }
protected void WorkUnit_DataBinding(object sender, EventArgs e) { ASPxComboBox workUnit = sender as ASPxComboBox; DataTable dt = new DataTable(); dt.Columns.Add("DISPLAY"); dt.Columns.Add("VALUE"); userManager theUserManager = (userManager)Session["theUserManager"]; List <LocationEntity> locations = LocationFactory.GetAll(); List <ProductLineEntity> PLines = ProductLineFactory.GetAll(); foreach (ProductLineEntity p in PLines) { dt.Rows.Add(p.PLINE_NAME, p.RMES_ID); } foreach (LocationEntity l in locations) { dt.Rows.Add(l.LOCATION_NAME, l.RMES_ID); } workUnit.DataSource = dt; workUnit.ValueField = "VALUE"; workUnit.TextField = "DISPLAY"; //workUnit.DataBind(); }
protected void ComboBoxPline_DataBinding(object sender, EventArgs e) { ASPxComboBox colPline = sender as ASPxComboBox; List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll(); colPline.DataSource = plineEntities; colPline.ValueField = "RMES_ID"; colPline.TextField = "PLINE_NAME"; }
private void setCondition() { //绑定表数据 userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); string theUserId = theUserManager.getUserId(); List <LineSideStockEntity> dataSource = LineSideStockFactory.GetAll(); if (!plineCode.SelectedItem.Value.ToString().Equals("All")) { dataSource = (from s in dataSource where s.PLINE_CODE == (plineCode.SelectedItem.Value.ToString()) select s).ToList <LineSideStockEntity>(); } if (storeCode.SelectedItem != null && !storeCode.SelectedItem.Value.ToString().Equals("All")) { dataSource = (from s in dataSource where s.STORE_CODE == (storeCode.SelectedItem.Value.ToString()) select s).ToList <LineSideStockEntity>(); } ASPxGridView1.DataSource = dataSource; GridViewDataComboBoxColumn comFactory = ASPxGridView1.Columns["FACTORY_CODE"] as GridViewDataComboBoxColumn; DataTable dt_factory = new DataTable(); dt_factory.Columns.Add("text"); dt_factory.Columns.Add("value"); dt_factory.Rows.Add("园区", "8101"); dt_factory.Rows.Add("基地", "8102"); comFactory.PropertiesComboBox.TextField = "text"; comFactory.PropertiesComboBox.ValueField = "value"; GridViewDataComboBoxColumn comStore = ASPxGridView1.Columns["STORE_CODE"] as GridViewDataComboBoxColumn; List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll(); comStore.PropertiesComboBox.DataSource = stores; comStore.PropertiesComboBox.TextField = "STORE_NAME"; comStore.PropertiesComboBox.ValueField = "STORE_CODE"; GridViewDataComboBoxColumn comPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; List <ProductLineEntity> plines = ProductLineFactory.GetAll(); comPline.PropertiesComboBox.DataSource = plines; comPline.PropertiesComboBox.TextField = "PLINE_NAME"; comPline.PropertiesComboBox.ValueField = "RMES_ID"; GridViewDataComboBoxColumn comLocation = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn; ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { cdate1.Value = DateTime.Today.AddDays(-3); cdate2.Value = DateTime.Today.AddDays(1); List <ProductLineEntity> plines = ProductLineFactory.GetAll(); foreach (var p in plines) { ComPline.Items.Add(p.PLINE_NAME, p.RMES_ID); } } BindData(); }
private void setCondition() { List <ProcessEntity> allEntity = ProcessFactory.GetAll(); ASPxGridView1.DataSource = allEntity; DataTable dt = new DataTable(); dt.Columns.Add("DISPLAY"); dt.Columns.Add("VALUE"); List <LocationEntity> locations = LocationFactory.GetAll(); List <ProductLineEntity> PLines = ProductLineFactory.GetAll(); foreach (ProductLineEntity p in PLines) { dt.Rows.Add(p.PLINE_NAME, p.RMES_ID); } foreach (LocationEntity l in locations) { dt.Rows.Add(l.LOCATION_NAME, l.RMES_ID); } GridViewDataComboBoxColumn col = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn; col.PropertiesComboBox.DataSource = dt; col.PropertiesComboBox.ValueField = "VALUE"; col.PropertiesComboBox.TextField = "DISPLAY"; DataTable dt1 = new DataTable(); dt1.Columns.Add("DISPLAY"); dt1.Columns.Add("WORKSHOP_CODE"); dt1.Rows.Add("园区", "8101"); dt1.Rows.Add("基地", "8102"); GridViewDataComboBoxColumn com = ASPxGridView1.Columns["WORKSHOP_CODE"] as GridViewDataComboBoxColumn; com.PropertiesComboBox.DataSource = dt1; com.PropertiesComboBox.ValueField = "WORKSHOP_CODE"; com.PropertiesComboBox.TextField = "DISPLAY"; ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); theProgramCode = "ssd1200"; if (!IsPostBack) { ASPxDateEdit1.Date = DateTime.Now; ASPxDateEdit2.Date = DateTime.Now; List <ProductLineEntity> user_plines = ProductLineFactory.GetByUserID(theUserManager.getUserId(), theProgramCode); ASPxComboBoxPline.DataSource = user_plines; ASPxComboBoxPline.TextField = "PLINE_NAME"; ASPxComboBoxPline.ValueField = "PLINE_CODE"; ASPxComboBoxPline.DataBind(); } setCondition(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); if (!IsPostBack) { List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll(); List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll(); foreach (var s in stores) { storeCode.Items.Add(s.STORE_NAME, s.STORE_CODE); } foreach (var p in plineEntities) { plineCode.Items.Add(p.PLINE_NAME, p.PLINE_CODE); } } setCondition(); }