/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void cargarCombos() { using (var conexion = new DataModelFE()) { /* PRODUCTO */ string emisor = Session["emisor"].ToString(); GridViewDataComboBoxColumn comboProducto = this.ASPxGridView1.Columns["codigo.codigo"] as GridViewDataComboBoxColumn; comboProducto.PropertiesComboBox.Items.Clear(); foreach (var item in conexion.Producto.Where(x => x.emisor == emisor).ToList()) { comboProducto.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); } comboProducto.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; /* TIPO DOCUMENTO */ foreach (var item in conexion.TipoDocumento.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { this.cmbTipoDocumento.Items.Add(item.descripcion, item.codigo); } this.cmbTipoDocumento.IncrementalFilteringMode = IncrementalFilteringMode.Contains; /* CODIGO REFERENCIA */ foreach (var item in conexion.CodigoReferencia.Where(x => x.estado == Estado.ACTIVO.ToString() && x.aplicaNotas == Confirmacion.SI.ToString()).ToList()) { this.cmbCodigoReferencia.Items.Add(item.descripcion, item.codigo); } this.cmbCodigoReferencia.IncrementalFilteringMode = IncrementalFilteringMode.Contains; } }
private void DataBindGridview() { //绑定表数据 List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserID); string sql = "select * from vw_data_sn_process_union t where exists(select * from data_project a where t.PROJECT_CODE=a.project_code and a.workshop_id='" + workShop[0].RMES_ID + "')"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; //ASPxGridView1.DataSource = db.Fetch<SNProcessEntity>("where company_code=@0 order by pline_code", theCompanyCode); GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; col.PropertiesComboBox.DataSource = ProductLineFactory.GetByWorkShopID(workShop[0].RMES_ID); col.PropertiesComboBox.ValueField = "RMES_ID"; col.PropertiesComboBox.TextField = "PLINE_NAME"; //GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn; //col1.PropertiesComboBox.DataSource = db.Fetch<LocationEntity>(""); //col1.PropertiesComboBox.ValueField = "RMES_ID"; //col1.PropertiesComboBox.TextField = "LOCATION_NAME"; ASPxGridView1.DataBind(); }
/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void cargarCombos() { // Cargar valores de combo para estado GridViewDataComboBoxColumn comboEstado = this.ASPxGridView1.Columns["indEstado"] as GridViewDataComboBoxColumn; comboEstado.PropertiesComboBox.Items.Clear(); comboEstado.PropertiesComboBox.Items.AddRange(EstadoMensajeHaciendaClass.values()); /* TIPO DOCUMENTO */ GridViewDataComboBoxColumn comboTipoDocumento = this.ASPxGridView1.Columns["tipoDocumento"] as GridViewDataComboBoxColumn; using (var conexion = new DataModelFE()) { foreach (var item in conexion.TipoDocumento.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { comboTipoDocumento.PropertiesComboBox.Items.Add(item.descripcion.Replace("ELECTRÓNICA", ""), item.codigo); } comboTipoDocumento.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; } /* TIPO MONEDA */ GridViewDataComboBoxColumn comboTipoMoneda = this.ASPxGridView1.Columns["moneda"] as GridViewDataComboBoxColumn; using (var conexion = new DataModelFE()) { foreach (var item in conexion.TipoMoneda.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { comboTipoMoneda.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); } comboTipoMoneda.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; } }
public void BindData() { string planSO = txtPlanSO.Text; string _b = cdate1.Date.ToString("yyyyMMdd") + "000000"; string _e = cdate2.Date.ToString("yyyyMMdd") + "235959"; List <IMESCompleteInstoreEntity> entity = db.Fetch <IMESCompleteInstoreEntity>("where SERIAL between @0 and @1 order by AUFNR", _b, _e); if (!string.IsNullOrEmpty(planSO)) { entity = (from s in entity where s.MATNR == planSO select s).ToList <IMESCompleteInstoreEntity>(); } ASPxGridView1.DataSource = entity; DataTable dt = new DataTable(); dt.Columns.Add("Text"); dt.Columns.Add("Value"); dt.Rows.Add("初始状态", "0"); dt.Rows.Add("传送中", "1"); dt.Rows.Add("已传送", "2"); GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn; colPrind.PropertiesComboBox.DataSource = dt; colPrind.PropertiesComboBox.TextField = "Text"; colPrind.PropertiesComboBox.ValueField = "Value"; ASPxGridView1.DataBind(); }
private DataTable fillGridCol() { int noOfLec = new StdClass().getNoOfLec(int.Parse(ddlClasses.SelectedValue.ToString())); DataTable dt = new StdClass().GetCourses(int.Parse(ddlClasses.SelectedValue.ToString())); DataTable table = new DataTable(); if (grid.Columns.Count != noOfLec) { GridViewDataComboBoxColumn x; GridViewDataComboBoxColumn ThisBool = new GridViewDataComboBoxColumn(); for (int i = 1; i <= noOfLec; i++) { table.Columns.Add("Lecture" + i.ToString(), typeof(String)); x = grid.Columns["Lecture" + i.ToString()] as GridViewDataComboBoxColumn; if (x == null) { ThisBool = new GridViewDataComboBoxColumn(); ThisBool.Caption = "Lecture" + i.ToString(); ThisBool.FieldName = "Lecture" + i.ToString(); ThisBool.Name = "Lecture" + i.ToString(); ThisBool.VisibleIndex = i + 3; ThisBool.PropertiesComboBox.DataSource = dt; ThisBool.PropertiesComboBox.TextField = "Name"; ThisBool.PropertiesComboBox.ValueField = "ID"; ThisBool.Visible = true; grid.Columns.Add(ThisBool); } } } return(table); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !Page.IsCallback) { trMsg.Visible = false; trAbm.Visible = false; gvABM.SettingsBehavior.AllowSelectByRowClick = true; gvABM.SettingsBehavior.AllowSelectSingleRowOnly = true; FormsHelper.InicializarPropsGrilla(gv); GridViewDataComboBoxColumn c = (GridViewDataComboBoxColumn)gvABM.Columns["DiaSemana"]; FormsHelper.FillDias(c.PropertiesComboBox.Items); } gvABM.KeyFieldName = "RecId"; ASPxMenu1.ItemClick += new DevExpress.Web.ASPxMenu.MenuItemEventHandler(ASPxMenu1_ItemClick); rbSemMes.AutoPostBack = true; rbSemMes.SelectedIndexChanged += new EventHandler(rbSemMes_SelectedIndexChanged); RefreshGrid(gv); RefreshAbmGrid(gvABM); lblError.Text = string.Empty; lblErrorDia.Text = string.Empty; }
protected void ASPxGridView2_DataSelect(object sender, EventArgs e) { ASPxGridView grid = (ASPxGridView)sender; string id = grid.GetMasterRowFieldValues("PLAN_CODE").ToString(); //string id = (sender as ASPxGridView).GetMasterRowKeyValue().ToString(); //string sql = "select * from data_plan_standard_bom where plan_code='"+id+"'"; //DataTable dt = dc.GetTable(sql); //List<PlanStandardBOMEntity> allEntity = db.Fetch<PlanStandardBOMEntity>("where plan_code=@0",id); DataTable dataSource = dc.GetTable("select t.*,p.process_name,p.standard_machine_worktime,p.standard_man_worktime,p.machine_worktime_unit,p.man_worktime_unit from DATA_PLAN_BOM t left join DATA_PLAN_PROCESS p on t.process_code=p.process_code and t.plan_code=p.plan_code where t.plan_code='" + id + "'"); List <PlanBomEntity> allEntity = db.Fetch <PlanBomEntity>("where plan_code=@0 order by flag,item_code", id); grid.DataSource = dataSource; GridViewDataComboBoxColumn comboCol = grid.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; comboCol.PropertiesComboBox.DataSource = ProductLineFactory.GetAll(); comboCol.PropertiesComboBox.ValueField = "RMES_ID"; comboCol.PropertiesComboBox.TextField = "PLINE_NAME"; DataTable dt = new DataTable(); dt.Columns.Add("VIEW"); dt.Columns.Add("VALUE"); dt.Rows.Add("新建", "N"); dt.Rows.Add("已发料单", "B"); dt.Rows.Add("部分收料", "R"); dt.Rows.Add("已收料", "Y"); GridViewDataComboBoxColumn colFlag = grid.Columns["FLAG"] as GridViewDataComboBoxColumn; colFlag.PropertiesComboBox.DataSource = dt; colFlag.PropertiesComboBox.ValueField = "VALUE"; colFlag.PropertiesComboBox.TextField = "VIEW"; }
public void BindData() { string orderCode = txtOrderCode.Text; if (string.IsNullOrWhiteSpace(orderCode)) { return; } List <SAPBOMEntity> entity = SAPBOMFactory.GetByOrderCode(orderCode); ASPxGridView1.DataSource = entity; DataTable dt = new DataTable(); dt.Columns.Add("Text"); dt.Columns.Add("Value"); dt.Rows.Add("初始状态", "0"); dt.Rows.Add("导入中", "1"); dt.Rows.Add("已导入", "2"); GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn; colPrind.PropertiesComboBox.DataSource = dt; colPrind.PropertiesComboBox.TextField = "Text"; colPrind.PropertiesComboBox.ValueField = "Value"; ASPxGridView1.DataBind(); }
/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void loadComboBox() { using (var conexion = new DataModelFE()) { /* ESTADO */ GridViewDataComboBoxColumn comboEstado = this.ASPxGridView1.Columns["estado"] as GridViewDataComboBoxColumn; comboEstado.PropertiesComboBox.Items.Clear(); comboEstado.PropertiesComboBox.Items.AddRange(Enum.GetValues(typeof(Estado))); /* IDENTIFICACION TIPO */ GridViewDataComboBoxColumn comboIdentificacionTipo = this.ASPxGridView1.Columns["identificacionTipo"] as GridViewDataComboBoxColumn; comboIdentificacionTipo.PropertiesComboBox.Items.Clear(); foreach (var item in conexion.TipoIdentificacion.ToList()) { comboIdentificacionTipo.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); } /* CODIGO PAIS */ GridViewDataComboBoxColumn cmbEmisorTelefonoCod = this.ASPxGridView1.Columns["telefonoCodigoPais"] as GridViewDataComboBoxColumn; GridViewDataComboBoxColumn cmbEmisorFaxCod = this.ASPxGridView1.Columns["faxCodigoPais"] as GridViewDataComboBoxColumn; cmbEmisorTelefonoCod.PropertiesComboBox.Items.Clear(); cmbEmisorFaxCod.PropertiesComboBox.Items.Clear(); foreach (var item in conexion.CodigoPais.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { cmbEmisorTelefonoCod.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); cmbEmisorFaxCod.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); } cmbEmisorTelefonoCod.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; cmbEmisorFaxCod.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; } }
/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void cargarCombos() { /* ESTADO */ GridViewDataComboBoxColumn comboEstado = this.ASPxGridView1.Columns["estado"] as GridViewDataComboBoxColumn; comboEstado.PropertiesComboBox.Items.Clear(); comboEstado.PropertiesComboBox.Items.AddRange(Enum.GetValues(typeof(Estado))); /* PRODUCTO */ GridViewDataComboBoxColumn comboProducto = this.ASPxGridView1.Columns["idProducto"] as GridViewDataComboBoxColumn; comboProducto.PropertiesComboBox.Items.Clear(); using (var conexion = new DataModelFE()) { string emisor = Session["emisor"].ToString(); foreach (var item in conexion.Producto.Where(x => x.emisor == emisor).Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { comboProducto.PropertiesComboBox.Items.Add(item.descripcion, item.id); } } comboProducto.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; /* TIPO IMPUESTO */ GridViewDataComboBoxColumn comboTipoImpuesto = this.ASPxGridView1.Columns["tipoImpuesto"] as GridViewDataComboBoxColumn; comboTipoImpuesto.PropertiesComboBox.Items.Clear(); using (var conexion = new DataModelFE()) { foreach (var item in conexion.TipoImpuesto.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { comboTipoImpuesto.PropertiesComboBox.Items.Add(item.descripcion, item.codigo); } } comboProducto.PropertiesComboBox.IncrementalFilteringMode = IncrementalFilteringMode.Contains; }
public void BindData() { string projectCode = txtProjectCode.Text; if (string.IsNullOrEmpty(projectCode)) { return; } List <SAPPlanEntity> entity = new List <SAPPlanEntity>(); //SAPPlanFactory.GetByOrderCode(orderCode); entity.AddRange(SAPPlanFactory.GetByProjectCode(projectCode)); ASPxGridView1.DataSource = entity; DataTable dt = new DataTable(); dt.Columns.Add("Text"); dt.Columns.Add("Value"); dt.Rows.Add("初始状态", "0"); dt.Rows.Add("导入中", "1"); dt.Rows.Add("已导入", "2"); GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn; colPrind.PropertiesComboBox.DataSource = dt; colPrind.PropertiesComboBox.TextField = "Text"; colPrind.PropertiesComboBox.ValueField = "Value"; ASPxGridView1.DataBind(); }
protected void detailGrid_DataSelect(object sender, EventArgs e) { _wbill_id = Convert.ToInt32((sender as ASPxGridView).GetMasterRowKeyValue()); var wbd = _db.WaybillList.Find(_wbill_id); if (wbd != null) { if (wbd.Checked != 0) { (sender as ASPxGridView).Columns["CommandCol"].Visible = false; (sender as ASPxGridView).SettingsDataSecurity.AllowDelete = false; (sender as ASPxGridView).SettingsDataSecurity.AllowEdit = false; (sender as ASPxGridView).SettingsDataSecurity.AllowInsert = false; } } GridViewDataComboBoxColumn column = (sender as ASPxGridView).Columns["MatNameCol"] as GridViewDataComboBoxColumn; column.PropertiesComboBox.DataSource = _db.PriceList.Where(w => w.Kagent.Any(a => a.KaId == _ka_id)).SelectMany(sm => sm.PriceListDet).Select(s => new { s.MatId, Name = _db.Materials.FirstOrDefault(w => w.MatId == s.MatId).Name }).ToList(); }
private void setCondition() { //绑定表数据 userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); string theUserId = theUserManager.getUserId(); List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserId); ASPxGridView1.DataSource = LineSideStockFactory.GetByWorkShopID(workShop[0].RMES_ID); GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; col.PropertiesComboBox.DataSource = ProductLineFactory.GetAll(); col.PropertiesComboBox.ValueField = "RMES_ID"; col.PropertiesComboBox.TextField = "PLINE_NAME"; GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn; col1.PropertiesComboBox.DataSource = db.Fetch <LocationEntity>(""); col1.PropertiesComboBox.ValueField = "RMES_ID"; col1.PropertiesComboBox.TextField = "LOCATION_NAME"; ASPxGridView1.DataBind(); }
protected void BindGrid() { var urun = db.S_Urunler().ToList(); if (urun.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["UrunID"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = urun; } var tip = db.S_Tip(6).ToList(); if (tip.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["Onay"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = tip; } ProfileBase curProfile = ProfileBase.Create(Membership.GetUser().UserName); string bayiid = curProfile.GetPropertyValue("BayiID").ToString(); var list = db.S_Siparislerim(Convert.ToInt32(bayiid)).ToList(); if (list.Count > 0) { EmployeesGrid.DataSource = list; EmployeesGrid.DataBind(); } }
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(); }
//end row command #endregion #region databinding /// <summary> /// populates combo box column(s) in datagrid /// </summary> protected void bind_target_combos() { //**************** //priority codes 0 to 5 //280113 changed to string and added new codes //bind combo in cell editor initialise event //WP – working prospect. KP – Key prospect PP – pending prospect A – account D – disregard //**************** //for (int _ix = 0; _ix <= 5; _ix++) //{ // _combo.PropertiesComboBox.Items.Add(_ix.ToString(), _ix); //} string _path = AppDomain.CurrentDomain.BaseDirectory; _path += "xml\\ddl_items.xml"; // pass _qryFilter to have keyword-filter RSS Feed // i.e. _qryFilter = XML -> entries with XML will be returned DataSet _ds = new DataSet(); _ds.ReadXml(_path); DataView _dv = _ds.Tables[0].DefaultView; _dv.RowFilter = "ddls ='prioritycode'"; //Run time population of GridViewDataComboBoxColumn column with data GridViewDataComboBoxColumn _combo = this.dxgrdTarget.Columns["colPriorityCode"] as GridViewDataComboBoxColumn; _combo.PropertiesComboBox.DataSource = _dv; _combo.PropertiesComboBox.ValueType = typeof(int); _combo.PropertiesComboBox.TextField = "name"; _combo.PropertiesComboBox.ValueField = "value"; }
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(); }
protected void BindGrid() { var urun = db.S_Urunler().ToList(); if (urun.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["UrunID"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = urun; } var bayi = db.S_Bayi(-1).ToList(); if (bayi.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["BayiID"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = bayi; } var tip = db.S_Tip(6).ToList(); if (tip.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["Onay"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = tip; } var list = db.S_Siparisler(-1).ToList(); if (list.Count > 0) { EmployeesGrid.DataSource = list; EmployeesGrid.DataBind(); } }
/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void cargarCombos() { // Cargar valores de combo para estado GridViewDataComboBoxColumn comboEstado = this.ASPxGridView1.Columns["estado"] as GridViewDataComboBoxColumn; comboEstado.PropertiesComboBox.Items.Clear(); comboEstado.PropertiesComboBox.Items.AddRange(Enum.GetValues(typeof(Estado))); }
protected void Page_Load(object sender, EventArgs e) { if (isLoggedIn()) { //check comapnyid if not publiship useer redirect to restricted version of this page Int32 _companyid = Page.Session["user"] != null ? (Int32)((UserClass)Page.Session["user"]).CompanyId : 0; if (_companyid != -1) //internal users are always companyid = -1 { //new linq databinding //this method of using linq does not run in server mode, you MUST use a LinqServerModeDataSource //bind_linq_datasource(); //running in server mode if (!Page.ClientScript.IsClientScriptBlockRegistered("lg_key")) { register_client_scripts(); } //bind gridview countries on page load GridViewDataComboBoxColumn _cbo = this.dxgrdorders.Columns["DestinationCountry"] as GridViewDataComboBoxColumn; if (_cbo != null) { string _path = AppDomain.CurrentDomain.BaseDirectory; _path += "xml\\country_iso.xml"; // pass _qryFilter to have keyword-filter RSS Feed // i.e. _qryFilter = XML -> entries with XML will be returned DataSet _ds = new DataSet(); _ds.ReadXml(_path); DataView _dv = _ds.Tables[0].DefaultView; //_dv.RowFilter = "ddls ='pallet'"; _cbo.PropertiesComboBox.DataSource = _dv; _cbo.PropertiesComboBox.TextField = "name"; _cbo.PropertiesComboBox.ValueField = "name"; } this.dxgrdorders.DataBind(); //show details by default? //this.dxgrdorders.DetailRows.ExpandAllRows(); } else { if (!Page.IsCallback) { Response.Redirect("~/publiship_advance/advance_audit.aspx", true); } } //using objectdatasource //this.LinqServerModePricer.Selecting += new EventHandler<DevExpress.Data.Linq.LinqServerModeDataSourceSelectEventArgs>(LinqServerModePricer_Selecting); } else { if (!Page.IsPostBack) { Response.Redirect("../user_accounts/signin.aspx?" + "rp=" + wwi_security.EncryptString("publiship_advance/advance_history", "publiship")); } } }
private void BindData() { List <SNBomEntity> entity = SNBomFactory.GetAll(); if (orderCode.SelectedItem != null && !orderCode.SelectedItem.Value.ToString().Equals("All")) { entity = (from s in entity where s.ORDER_CODE.Equals(orderCode.SelectedItem.Value.ToString()) select s).ToList <SNBomEntity>(); } if (planCode.SelectedItem != null && !planCode.SelectedItem.Value.ToString().Equals("All")) { entity = (from s in entity where s.PLAN_CODE.Equals(planCode.SelectedItem.Value.ToString()) select s).ToList <SNBomEntity>(); } if (plineCode.SelectedItem != null && !plineCode.SelectedItem.Value.ToString().Equals("All")) { entity = (from s in entity where s.PLINE_CODE.Equals(plineCode.SelectedItem.Value.ToString()) select s).ToList <SNBomEntity>(); } ASPxGridView1.DataSource = entity; List <string> orders = new List <string>(); List <string> plans = new List <string>(); List <string> plines = new List <string>(); foreach (var e in entity) { if ((!string.IsNullOrWhiteSpace(e.ORDER_CODE)) && (!orders.Contains(e.ORDER_CODE))) { orders.Add(e.ORDER_CODE); } if ((!string.IsNullOrWhiteSpace(e.PLAN_CODE)) && (!plans.Contains(e.PLAN_CODE))) { plans.Add(e.PLAN_CODE); } if ((!plines.Contains(e.PLINE_CODE)) && (!string.IsNullOrWhiteSpace(e.PLINE_CODE))) { plines.Add(e.PLINE_CODE); } } GridViewDataComboBoxColumn colOrder = ASPxGridView1.Columns["ORDER_CODE"] as GridViewDataComboBoxColumn; colOrder.PropertiesComboBox.DataSource = orders; GridViewDataComboBoxColumn colPlan = ASPxGridView1.Columns["PLAN_CODE"] as GridViewDataComboBoxColumn; colPlan.PropertiesComboBox.DataSource = plans; 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 grvModunManager_DataBinding(object sender, EventArgs e) { GridViewDataComboBoxColumn column = ((GridViewDataComboBoxColumn)(sender as ASPxGridView).Columns["Manager"]); SYS_UserService _UserService = new SYS_UserService(); column.PropertiesComboBox.DataSource = _UserService.SelectAllSYS_User_IsActive(); column.PropertiesComboBox.TextField = "UserName"; column.PropertiesComboBox.ValueField = "ID"; }
public void BindData() { string _b = cdate1.Date.ToString("yyyyMMdd") + "000000"; string _e = cdate2.Date.ToString("yyyyMMdd") + "235959"; List <IMESPlanProcessEntity> entity = db.Fetch <IMESPlanProcessEntity>("where SERIAL between @0 and @1 order by AUFNR", _b, _e); string planSO = txtPlanSO.Text; string orderCode = ""; if (!string.IsNullOrEmpty(planSO)) { List <PlanEntity> plan = PlanFactory.GetByPlanSO(planSO); if (plan != null && plan.Count > 0) { orderCode = plan[0].ORDER_CODE; } if (!string.IsNullOrEmpty(orderCode)) { entity = (from s in entity where s.AUFNR == orderCode select s).ToList <IMESPlanProcessEntity>(); } } ASPxGridView1.DataSource = entity; DataTable dt = new DataTable(); dt.Columns.Add("Text"); dt.Columns.Add("Value"); dt.Rows.Add("初始状态", "0"); dt.Rows.Add("传送中", "1"); dt.Rows.Add("已传送", "2"); GridViewDataComboBoxColumn colPrind = ASPxGridView1.Columns["PRIND"] as GridViewDataComboBoxColumn; colPrind.PropertiesComboBox.DataSource = dt; colPrind.PropertiesComboBox.TextField = "Text"; colPrind.PropertiesComboBox.ValueField = "Value"; DataTable dt1 = new DataTable(); dt1.Columns.Add("Text"); dt1.Columns.Add("Value"); dt1.Rows.Add("完成", "X"); GridViewDataComboBoxColumn colPrind1 = ASPxGridView1.Columns["OPFLG"] as GridViewDataComboBoxColumn; colPrind1.PropertiesComboBox.DataSource = dt1; colPrind1.PropertiesComboBox.TextField = "Text"; colPrind1.PropertiesComboBox.ValueField = "Value"; ASPxGridView1.DataBind(); }
protected void ASPxGridView1_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) { string sql = "select ID as TeacherID,Name as TeacherName from Std_Teacher inner join Std_TeacherCourses on TeacherID = ID where CourseID=" + e.EditingKeyValue.ToString(); DataTable dt = DataAccess.ExecuteSQLQuery(sql); GridViewDataComboBoxColumn regioncolumn = (ASPxGridView1.Columns["clTeacher"] as GridViewDataComboBoxColumn); regioncolumn.PropertiesComboBox.DataSource = dt; regioncolumn.PropertiesComboBox.ValueField = "TeacherID"; regioncolumn.PropertiesComboBox.TextField = "TeacherName"; }
private void RefreshGrid(ASPxGridView gv) { GridViewDataComboBoxColumn c = (GridViewDataComboBoxColumn)gv.Columns["IdentifTecno"]; c.PropertiesComboBox.TextField = "Name"; c.PropertiesComboBox.ValueField = "IdentifTecno"; c.PropertiesComboBox.DataSource = Business.TecnologiaSoporte.ReadAll(""); gv.DataSource = Business.MediosPublicitarios.ReadAllTipo(""); gv.DataBind(); }
protected void BindGrid() { var list = db.S_Kullanici().ToList(); if (list.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["UserID"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(Guid); combo.PropertiesComboBox.DataSource = list; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.AddClass, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/StudentAfair/UnAuthorized.aspx"); } } if (!IsPostBack) { if (Request.QueryString["id"].ToString() != null) { if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0) { StdClass sttclass = new StdClass(); sttclass.get(Convert.ToInt32(Request.QueryString["id"].ToString())); //txtNoOfStudent.Text=sttclass. txtClassName.Text = sttclass.Name; ddlEdtYear.SelectedValue = sttclass.EdID.ToString(); if (sttclass.SupID != 0) { ddlSup.SelectedValue = sttclass.SupID.ToString(); } ASPxGridView1.DataSource = sttclass.CoursesTeachers; ASPxGridView1.DataBind(); string sql = "select ID as TeacherID,Name as TeacherName from Std_Teacher "; DataTable dt = DataAccess.ExecuteSQLQuery(sql); GridViewDataComboBoxColumn regioncolumn = (ASPxGridView1.Columns["clTeacher"] as GridViewDataComboBoxColumn); regioncolumn.PropertiesComboBox.DataSource = dt; regioncolumn.PropertiesComboBox.ValueField = "TeacherID"; regioncolumn.PropertiesComboBox.TextField = "TeacherName"; Session["table"] = sttclass.CoursesTeachers; btnSave.Visible = false; btnEdit.Visible = true; } else { btnSave.Visible = true; btnEdit.Visible = false; } } } if (IsPostBack) { ASPxGridView1.DataSource = Session["table"]; ASPxGridView1.DataBind(); } }
protected void BindGrid() { var tip = db.S_Tip(5).ToList(); if (tip.Count > 0) { GridViewDataComboBoxColumn combo = EmployeesGrid.Columns["DokumanTipi_TipID5"] as GridViewDataComboBoxColumn; combo.PropertiesComboBox.ValueType = typeof(int); combo.PropertiesComboBox.DataSource = tip; } }
protected void gvMain_RowInserted(object sender, DevExpress.Web.Data.ASPxDataInsertedEventArgs e) { //get priority GridViewDataComboBoxColumn column = gvMain.Columns["PriorityID"] as GridViewDataComboBoxColumn; string priority = column.PropertiesComboBox.Items.FindByValue(e.NewValues["PriorityID"]).Text; //get last id string sql = "SELECT MAX(ID) FROM base_ticket"; string MAXID = DataBase.GetDT(sql).Rows[0][0].ToString(); //update when and who created sql = "UPDATE base_ticket SET DateOpen = @DateOpen, OpenBy = @OpenBy WHERE (ID = @ID)"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@DateOpen", SqlDbType = SqlDbType.Date, Value = DateTime.Today.ToShortDateString() }, new SqlParameter() { ParameterName = "@OpenBy", SqlDbType = SqlDbType.NVarChar, Value = User.Identity.Name }, new SqlParameter() { ParameterName = "@ID", SqlDbType = SqlDbType.Int, Value = MAXID } }; DataBase.UpdateDB(sp, sql); //send email to executive team gvMain.JSProperties["cpMessage"] = "Email sent to Amerinode Support at [email protected] for immediate processing."; Notifications.add("Q Ticket has been created", "<b>Q Ticket # " + MAXID + "</b> has just been created in Q by " + User.Identity.Name + ".<br/>" + "Login into Q and change its Status to PROCEED as an authorization for IT to proceed with implementation.<br/>" + "Description: " + e.NewValues["Description"].ToString() + "<br/>" + "Priority: " + priority + "<br/>" + "Customer Impacting: " + e.NewValues["CustomerImpacting"].ToString() , "*****@*****.**", "*****@*****.**", -1); //re-enable columns gvMain.Columns["StatusID"].Visible = true; gvMain.Columns["DateOpen"].Visible = true; gvMain.Columns["DateClose"].Visible = true; gvMain.Columns["OpenBy"].Visible = true; gvMain.Columns["CloseBy"].Visible = true; gvMain.Columns["ApprovedBy"].Visible = true; gvMain.Columns["QVersion"].Visible = true; gvMain.Columns["Resolution"].Visible = true; gvMain.Columns["CloseApproved"].Visible = true; gvMain.Columns["Files"].Visible = true; if (Session["tempDir"] != null) { changePath(MAXID); } }
/// <summary> /// carga solo una vez para ahorar tiempo /// </summary> private void loadComboBox() { using (var conexion = new DataModelFE()) { /* TIPO DOCUMENTO */ GridViewDataComboBoxColumn comboTipoDocumento = this.ASPxGridView1.Columns["tipoDocumento"] as GridViewDataComboBoxColumn; foreach (var item in conexion.TipoDocumento.Where(x => x.estado == Estado.ACTIVO.ToString()).ToList()) { comboTipoDocumento.PropertiesComboBox.Items.Add(item.descripcion.Replace("FACTURA ELECTRÓNICA", "PROFORMA"), item.codigo); } } }
internal static GridViewDataComboBoxColumn BuildComboColumn(string caption, string fieldName, BusinessMapper.eEntities entity) { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = fieldName; gvc.Caption = caption; gvc.FieldName = fieldName; var mapInfo = BusinessMapper.GetMapInfo(entity.ToString()); gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField; gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField; gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll(""); return gvc; }
internal static GridViewDataComboBoxColumn BuildComboColumn(string caption, string fieldName, params string[] items) { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = fieldName; gvc.Caption = caption; gvc.FieldName = fieldName; gvc.PropertiesComboBox.Items.Clear(); for (int i = 0; i < items.Length; i+=2) { gvc.PropertiesComboBox.Items.Add(items[i], items[i+1]); } return gvc; }
internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv) { if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty) throw new Exception("Path del archivo AbmConfig.xml sin definir."); XmlDocument xDoc = new XmlDocument(); xDoc.Load(BusinessMapper.AbmConfigXmlPath); gv.Columns.Clear(); if (xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null) throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString()); foreach (XmlNode nodeControl in xDoc.SelectSingleNode( "Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes) { if (nodeControl.Attributes["ControlType"].Value == "ComboBox") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value); gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField; gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField; gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll(""); gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList") { GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gvc.PropertiesComboBox.Items.Clear(); foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes) { gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value); } gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "TextBox" || nodeControl.Attributes["ControlType"].Value == "SpinEdit" || nodeControl.Attributes["ControlType"].Value == "TimeEdit") { GridViewDataTextColumn gvc = new GridViewDataTextColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "DateEdit") { GridViewDataDateColumn gvc = new GridViewDataDateColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } else if (nodeControl.Attributes["ControlType"].Value == "CheckBox") { GridViewDataCheckColumn gvc = new GridViewDataCheckColumn(); gvc.Name = nodeControl.Attributes["FieldName"].Value; gvc.Caption = nodeControl.Attributes["Title"].Value; gvc.FieldName = nodeControl.Attributes["FieldName"].Value; gv.Columns.Add(gvc); } } }