protected void comDetectItem_Callback(object sender, CallbackEventArgsBase e) { string workUnit = e.Parameter; List <DetectDataEntity> stations = DetectDataFactory.GetByWorkunit(theCompanyCode, workUnit); ASPxComboBox detectItem = (ASPxComboBox)sender; detectItem.DataSource = stations; detectItem.TextField = "DETECT_ITEM_NAME"; detectItem.ValueField = "DETECT_ITEM_CODE"; detectItem.DataBind(); }
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 <DetectDataEntity> entities = DetectDataFactory.GetByUser(theUserId, theProgramCode); string sql = "select t.*,a.pline_code plinecode1 from code_detect t left join code_product_line a on t.pline_code=a.rmes_id where t.pline_code in (select pline_id from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "' ) and (t.temp01 is null or t.temp01='Y') order by t.INPUT_TIME desc nulls last"; DataTable dt1 = dc.GetTable(sql); ASPxGridView1.DataSource = dt1; //GridViewDataComboBoxColumn colPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; //List<ProductLineEntity> plineEntities = ProductLineFactory.GetByUserID(theUserId,theProgramCode); //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"; GridViewDataComboBoxColumn colDetectType = ASPxGridView1.Columns["DETECT_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("文件", "F"); colDetectType.PropertiesComboBox.DataSource = dt; colDetectType.PropertiesComboBox.ValueField = "Value"; colDetectType.PropertiesComboBox.TextField = "Text"; ASPxGridView1.DataBind(); }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox; ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox; ASPxComboBox detectItem = ASPxGridView1.FindEditFormTemplateControl("comDetectItem") as ASPxComboBox; pline.TextField = "PLINE_NAME"; pline.ValueField = "PLINE_CODE"; string plineCode = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "PLINE_CODE").ToString(); string workUnitCode = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "WORKUNIT_CODE").ToString(); List <StationEntity> stations = StationFactory.GetByProductLine(plineCode); workUnit.DataSource = stations; workUnit.TextField = "STATION_NAME"; workUnit.ValueField = "WORKUNIT_CODE"; List <DetectDataEntity> detectItems = DetectDataFactory.GetByWorkunit(theCompanyCode, workUnitCode); detectItem.DataSource = detectItems; detectItem.TextField = "DETECT_ITEM_NAME"; detectItem.ValueField = "DETECT_ITEM_CODE"; if (ASPxGridView1.IsEditing) { //string _workUnit = ASPxGridView1.GetRowValues(ASPxGridView1.EditingRowVisibleIndex, "WORKUNIT_CODE").ToString(); //for (int i = 0; i < workUnit.Items.Count; i++) //{ // if (_workUnit == workUnit.Items[i].Value.ToString()) // workUnit.Items[i].Selected = true; //} } }