public void storeCode_Callback(object sender, CallbackEventArgsBase e) { ASPxComboBox cBox = sender as ASPxComboBox; cBox.Items.Clear(); cBox.Items.Add("全部", "All"); string pline = plineCode.SelectedItem.Value.ToString(); if (pline.Equals("All")) { List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll(); foreach (var s in stores) { cBox.Items.Add(s.STORE_NAME, s.STORE_CODE); } } else { List <LineSideStoreEntity> stores = LinesideStoreFactory.GetByPline(pline); foreach (var s in stores) { cBox.Items.Add(s.STORE_NAME, s.STORE_CODE); } } cBox.SelectedIndex = 0; }
private void SetDataBind(List <ItemLineSideStore2LineEntity> ds)//绑定数据源 { DataSource = ds; List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll(); for (int i = 0; i < ds.Count; i++) { string ws = ds[i].WORKSHOP; string tl = ds[i].T_LINESIDESTORE; List <string> storeNames = new List <string>(); storeNames = (from s in stores where s.STORE_CODE.Equals(tl) select s.STORE_CODE).ToList <string>(); if (storeNames.Count > 0) { ds[i].T_LINESIDESTORE = storeNames[0]; } if (ws == "8101") { ds[i].WORKSHOP = "园区"; } else { ds[i].WORKSHOP = "基地"; } } this.xrTableCell7.DataBindings.Add("Text", DataSource, "ITEM_CODE"); this.xrTableCell8.DataBindings.Add("Text", DataSource, "ITEM_QTY"); this.xrTableCell9.DataBindings.Add("Text", DataSource, "S_LINESIDESTORE"); this.xrTableCell10.DataBindings.Add("Text", DataSource, "T_LINESIDESTORE"); this.xrTableCell11.DataBindings.Add("Text", DataSource, "ITEM_NAME"); this.xrTableCell12.DataBindings.Add("Text", DataSource, "CREATE_TIME"); }
public void comResourceStore_DataBinding(object sender, EventArgs e) { ASPxComboBox comStock = sender as ASPxComboBox; List <LineSideStoreEntity> all = LinesideStoreFactory.GetMaterialStore(); comStock.DataSource = all; comStock.TextField = "STORE_NAME"; comStock.ValueField = "STORE_CODE"; }
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(); }
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(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; string theCompanyCode = theUserManager.getCompanyCode(); string theUserID = theUserManager.getUserId(); if (!IsPostBack) { List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll(); List <PlanEntity> dataSource = PlanFactory.GetByUserID(theUserID); PlanCode.DataSource = dataSource; PlanCode.ValueField = "ORDER_CODE"; PlanCode.TextField = "ORDER_CODE"; PlanCode.DataBind(); } setCondition(); }
public ctrlBomItemMng(string pPlanCode, string pSn, List <SNBomTempEntity> pDS) { InitializeComponent(); stationCode = LoginInfo.StationInfo.RMES_ID; plineCode = LoginInfo.ProductLineInfo.RMES_ID; companyCode = LoginInfo.CompanyInfo.COMPANY_CODE; SN = pDS.First().SN; StationEntity ent1 = StationFactory.GetByKey(stationCode); WorkunitCode = ""; LineSideStoreEntity ent2 = LinesideStoreFactory.GetByWKUnit(companyCode, WorkunitCode); LinesideStock = ent2.STORE_CODE; dgvBom.AutoGenerateColumns = false; dgvBom.RowHeadersVisible = false; dgvBom.DataSource = pDS; }
public void BindData() { List <LinesideAutoIssueEntity> allEntity = LinesideAutoIssueFactory.GetAll(); ASPxGridView1.DataSource = allEntity; GridViewDataComboBoxColumn comStock = ASPxGridView1.Columns["LINESIDE_STORE_CODE"] as GridViewDataComboBoxColumn; List <LineSideStoreEntity> all = LinesideStoreFactory.GetLineSideStore(); comStock.PropertiesComboBox.DataSource = all; comStock.PropertiesComboBox.TextField = "STORE_NAME"; comStock.PropertiesComboBox.ValueField = "STORE_CODE"; GridViewDataComboBoxColumn comResourceStore = ASPxGridView1.Columns["RESOURCE_STORE"] as GridViewDataComboBoxColumn; List <LineSideStoreEntity> _all = LinesideStoreFactory.GetMaterialStore(); comResourceStore.PropertiesComboBox.DataSource = _all; comResourceStore.PropertiesComboBox.TextField = "STORE_NAME"; comResourceStore.PropertiesComboBox.ValueField = "STORE_CODE"; GridViewDataComboBoxColumn comType = ASPxGridView1.Columns["BATCH_TYPE"] as GridViewDataComboBoxColumn; DataTable dt = new DataTable(); dt.Columns.Add("text"); dt.Columns.Add("value"); dt.Rows.Add("天", 0); dt.Rows.Add("周", 1); dt.Rows.Add("旬", 2); dt.Rows.Add("月", 3); dt.Rows.Add("季度", 4); comType.PropertiesComboBox.DataSource = dt; comType.PropertiesComboBox.TextField = "text"; comType.PropertiesComboBox.ValueField = "value"; ASPxGridView1.DataBind(); }
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(); }