/// <summary> /// 根据抽检点设置变化变更车间和设备,车间的设备和这个抽检点的设备 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void luePoint_EditValueChanged(object sender, EventArgs e) { //1.按照车间绑定所有设备,group_Key ,equipment_key //2.如果,equipment_key有值则直接用需加车间,没有就根据group_key和车间 string strFactoryRoom = PropertyService.Get(PROPERTY_FIELDS.FACTORY_CODE); //strFactoryRoom = "C3C1"; EdcQuery edcQuery = new EdcQuery(); string equipmentKey = this.luePoint.GetColumnValue("EQUIPMENT_KEY").ToString(); string groupKey = this.luePoint.GetColumnValue("GROUP_KEY").ToString(); DataSet dsEMS = edcQuery.SearchEMS(strFactoryRoom, groupKey, equipmentKey); lueEqp.Properties.DataSource = dsEMS.Tables[0]; lueEqp.Properties.ValueMember = "EQUIPMENT_KEY"; lueEqp.Properties.DisplayMember = "EQUIPMENT_NAME"; // 3.根据选择的DEC_key获取 string edcKey = this.luePoint.GetColumnValue("EDC_KEY").ToString(); DataSet dsParma = edcQuery.SearchParam(edcKey); lueParam.Properties.DataSource = dsParma.Tables[0]; lueParam.Properties.ValueMember = "PARAM_KEY"; lueParam.Properties.DisplayMember = "PARAM_NAME"; }
/// <summary> /// 按照车间绑定所有设备 /// </summary> private void BingEdcEMS() { //车间 string strFactoryRoom = PropertyService.Get(PROPERTY_FIELDS.FACTORY_CODE); //strFactoryRoom="C3C1"; DataSet ds = new DataSet(); EdcQuery edcQuery = new EdcQuery(); ds = edcQuery.SearchEMS(strFactoryRoom); lueEqp.Properties.DataSource = ds.Tables[0]; lueEqp.Properties.ValueMember = "EQUIPMENT_KEY"; lueEqp.Properties.DisplayMember = "EQUIPMENT_NAME"; }