private void girdView2DataLoading(DataTable dt) { gridControl2.DataSource = dt; gridView2.BestFitColumns(); //MessageBox.Show(gridView2.Columns.Count.ToString()); for (int i = 1; i < gridView2.Columns.Count; i++) { gridView2.Columns[i].OptionsColumn.ReadOnly = true; //设置成只读状态 } GridCheckMarksSelection selection = new GridCheckMarksSelection(gridView2); // 增加CHECKBOX selection.CheckMarkColumn.VisibleIndex = 0; selection.SelectionChanged += selection_SelectionChanged; }
/// <summary> /// 添加数据到GridView /// 某些列ReadOnly /// </summary> private void add() { DataTable table = gridControl1.DataSource as DataTable; if (table == null) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Fct Code", typeof(string))); dt.Columns.Add(new DataColumn("Plant", typeof(string))); dt.Columns.Add(new DataColumn("材料", typeof(string))); dt.Columns.Add(new DataColumn("条形码", typeof(string))); dt.Columns.Add(new DataColumn("申请数", typeof(string))); dt.Columns.Add(new DataColumn("生产计划数", typeof(string))); dt.Columns.Add(new DataColumn("厂家在库", typeof(string))); dt.Columns.Add(new DataColumn("材料描述", typeof(string))); dt.Columns.Add(new DataColumn("创建日期", typeof(string))); dt.Columns.Add(new DataColumn("创建时间", typeof(string))); dt.Columns.Add(new DataColumn("创建人", typeof(string))); dt.Columns.Add(new DataColumn("创建IP", typeof(string))); dt.Rows.Add(getField()); gridControl1.DataSource = dt; GridCheckMarksSelection selection = new GridCheckMarksSelection(gridView1); selection.CheckMarkColumn.VisibleIndex = 0; selection.SelectionChanged += grdCheckSelect_SelectionChanged; gridView1.Columns["Fct Code"].OptionsColumn.ReadOnly = true; gridView1.Columns["Plant"].OptionsColumn.ReadOnly = true; gridView1.Columns["条形码"].OptionsColumn.ReadOnly = true; gridView1.Columns["材料"].OptionsColumn.ReadOnly = true; gridView1.Columns["申请数"].OptionsColumn.ReadOnly = true; gridView1.Columns["生产计划数"].OptionsColumn.ReadOnly = true; gridView1.Columns["厂家在库"].OptionsColumn.ReadOnly = true; gridView1.Columns["材料描述"].OptionsColumn.ReadOnly = true; gridView1.Columns["创建日期"].OptionsColumn.ReadOnly = true; gridView1.Columns["创建时间"].OptionsColumn.ReadOnly = true; gridView1.Columns["创建人"].OptionsColumn.ReadOnly = true; gridView1.Columns["创建IP"].OptionsColumn.ReadOnly = true; } else { table.Rows.Add(getField()); gridControl1.DataSource = table; } }
/// <summary> /// 后台查询数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { this.Invoke((MethodInvoker) delegate { getVariable(); //获取变量信息 if (vend4.Equals("")) { SecuGlobal.showNG(panelStatus, lblStatus, "vendor code 4 为空"); return; } SecuGlobal.GridViewInitial(gridView1, gridControl1); DataTable dt = OracleHelper.ExecuteDataTable(getSql(ls_plant, vend4, ls_sdate, ls_edate)); //ls_plant - % if (dt == null) { SecuGlobal.showOK(panelStatus, lblStatus, "没有查询到符合条件的数据"); return; } dt = setDtHeader(dt); //更改标题栏和显示顺序 gridControl1.DataSource = dt; gridView1.BestFitColumns(); gridView1.Columns["申请单号"].SummaryItem.SummaryType = SummaryItemType.Count; gridView1.Columns["申请单号"].SummaryItem.DisplayFormat = "All:{0:f0} "; GridCheckMarksSelection selection = new GridCheckMarksSelection(gridView1); // 增加CHECKBOX selection.CheckMarkColumn.VisibleIndex = 0; selection.SelectionChanged += selection_SelectionChanged; SecuGlobal.showOK(panelStatus, lblStatus, "OK"); }); } catch (Exception err) { SecuGlobal.showNG(panelStatus, lblStatus, err.Message); } }
/// <summary> /// 报废未返回序列号 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker4_DoWork(object sender, DoWorkEventArgs e) { try { this.Invoke((MethodInvoker) delegate { btnQuery.Enabled = false; DataTable dt = null; dt = OracleHelper.ExecuteDataTable(getSql4(vendorCode)); dt = setDtHeader4(dt); gridControl4.DataSource = dt; grdSN.BestFitColumns(); GridCheckMarksSelection grdCheckSelect = new GridCheckMarksSelection(grdSN); grdCheckSelect.CheckMarkColumn.VisibleIndex = 0; grdCheckSelect.SelectionChanged += grdCheckSelect_SelectionChanged; for (int i = 1; i < grdSN.Columns.Count; i++) { grdSN.Columns[i].OptionsColumn.ReadOnly = true; } grdSN.Columns["Serial No"].SummaryItem.SummaryType = SummaryItemType.Count; grdSN.Columns["Serial No"].SummaryItem.DisplayFormat = "All: {0:f0} "; btnQuery.Enabled = true; SecuGlobal.showOK(panelStatus, lblStatus, "OK"); }); } catch (Exception err) { //XtraMessageBox.Show(this, "System error[ShowData]: " + err.Message); SecuGlobal.showNG(panelStatus, lblStatus, err.Message); } }