private void lueControlCode_EditValueChanged(object sender, EventArgs e) { DataRow dr = dtControlPlan.Select(string.Format(@"CONTROLPLANID='{0}'", lueControlCode.EditValue.ToString()))[0]; if (dr == null) { return; } betEquipment.Text = string.Empty; equipmentKeys = string.Empty; string locationKey = string.Empty, stepKey = string.Empty; chartType = dr[SPC_CONTROL_PLAN_FIELD.FIELD_CONTROLTYPE].ToString(); string strAnormalIDs = dr[SPC_CONTROL_PLAN_FIELD.FIELD_ABNORMALIDS].ToString(); locationKey = dr[SPC_CONTROL_PLAN_FIELD.FIELD_WERKS].ToString(); stepKey = dr[SPC_CONTROL_PLAN_FIELD.FIELD_STEP_KEY].ToString(); this.layoutControlItem12.Visibility = LayoutVisibility.Never; this.layoutControlItem7.Visibility = LayoutVisibility.Never; string s = string.Empty; if (strAnormalIDs.Length > 0) { foreach (string str in strAnormalIDs.Split(',')) { s += "'" + str + "',"; } if (string.IsNullOrEmpty(s)) { return; } s = s.TrimEnd(','); } try { DataTable dt01 = spcEntity.GetAbnormalRule().Tables[EDC_ABNORMAL_FIELDS.DATABASE_TABLE_NAME]; string s01 = string.Format(EDC_ABNORMAL_FIELDS.FIELD_ARULECODE + " IN ({0})", s); DataView dv = dt01.DefaultView; dv.RowFilter = s01; DataTable dt02 = dv.ToTable(); cklRules.DataSource = dt02; cklRules.DisplayMember = EDC_ABNORMAL_FIELDS.FIELD_ARULECODE; cklRules.ValueMember = EDC_ABNORMAL_FIELDS.FIELD_ABNORMALID; cklRules.Enabled = true; for (int i = 0; i < cklRules.Items.Count; i++) { cklRules.Items[i].CheckState = CheckState.Checked; } cklRules.CheckAll(); } catch //(Exception ex) { } }
private void InitialData() { try { DataSet dataSet = spcEntity.GetAbnormalRule(); if (spcEntity.ErrorMsg.Length > 0) { MessageService.ShowError("get spc AbnormalRule error:" + spcEntity.ErrorMsg); } else { DataTable dtMain = dataSet.Tables[EDC_ABNORMAL_FIELDS.DATABASE_TABLE_NAME]; dtMain.Columns.Add("isSelected", typeof(bool)); gridView1.Columns[EDC_ABNORMAL_FIELDS.FIELD_ABNORMALCOLOR].Visible = false; if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables.Contains(EDC_ABNORMAL_FIELDS.DATABASE_TABLE_NAME)) { this.gcMainAbnormal.DataSource = null; this.gcMainAbnormal.DataSource = dataSet.Relations[0].ParentTable; for (int i = 0; i < gridView1.DataRowCount; i++) { string _code = gridView1.GetRowCellValue(i, EDC_ABNORMAL_FIELDS.FIELD_ARULECODE).ToString(); if (lst.Contains(_code)) { gridView1.SetRowCellValue(i, "isSelected", true); } } if (!isAddColorField) { GridColumn unboundColumn = gridView1.Columns.AddField("Color"); unboundColumn.VisibleIndex = gridView1.Columns.Count; unboundColumn.UnboundType = DevExpress.Data.UnboundColumnType.Object; RepositoryItemColorEdit ce = new RepositoryItemColorEdit(); ce.ShowCustomColors = false; unboundColumn.ColumnEdit = ce; isAddColorField = true; } } } } catch (Exception ex) { MessageService.ShowMessage(ex.Message); } }
private void BindGv() { DataSet dataSet = spcEntity.GetAbnormalRule(); InitialData(dataSet); }