public override void FormatGrid() { try { if (Memory.IsDesignMode) { return; } base.FormatGrid(); GridEXColumn col = null; col = new GridEXColumn(MergeData.MaGiaoDanMoi, Janus.Windows.GridEX.ColumnType.Text); col.Width = 60; col.BoundMode = ColumnBoundMode.Bound; col.DataMember = MergeData.MaGiaoDanMoi; col.Caption = "Mã giáo dân mới"; col.FilterEditType = FilterEditType.Combo; this.RootTable.Columns.Insert(0, col); col = new GridEXColumn(MergeData.KetQua, Janus.Windows.GridEX.ColumnType.Text); col.Width = 200; col.BoundMode = ColumnBoundMode.Bound; col.DataMember = MergeData.KetQua; col.Caption = "Kết quả"; col.FilterEditType = FilterEditType.Combo; this.RootTable.Columns.Insert(0, col); SetGridColumnWidth(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi Exception (GxGiaoDanList, FormatGrid)", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void UpdateGroup() { if (!Utility.isValidGrid(grdLuotkham)) { return; } var counts = ((DataView)grdLuotkham.DataSource).Table.AsEnumerable() .GroupBy(x => x.Field <string>("ma_doituong_kcb")) .Select(g => new { g.Key, Count = g.Count() }); if (counts.Count() >= 2) { if (grdLuotkham.RootTable.Groups.Count <= 0) { GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"]; var gridExGroup = new GridEXGroup(gridExColumn) { GroupPrefix = "Nhóm đối tượng KCB: " }; grdLuotkham.RootTable.Groups.Add(gridExGroup); } } else { GridEXColumn gridExColumn = grdLuotkham.RootTable.Columns["ma_doituong_kcb"]; var gridExGroup = new GridEXGroup(gridExColumn); grdLuotkham.RootTable.Groups.Clear(); } grdLuotkham.UpdateData(); grdLuotkham.Refresh(); }
void UpdateGroup() { try { if (m_dtReport == null || m_dtReport.Columns.Count <= 0) { return; } var counts = m_dtReport.AsEnumerable().GroupBy(x => x.Field <string>("tennhom")) .Select(g => new { g.Key, Count = g.Count() }); if (chkTheoNhomThuoc.Checked) { if (grdList.RootTable.Groups.Count <= 0) { GridEXColumn gridExColumn = grdList.RootTable.Columns["tennhom"]; var gridExGroup = new GridEXGroup(gridExColumn); grdList.RootTable.Groups.Add(gridExGroup); } } else { GridEXColumn gridExColumn = grdList.RootTable.Columns["tennhom"]; var gridExGroup = new GridEXGroup(gridExColumn); grdList.RootTable.Groups.Clear(); } grdList.UpdateData(); grdList.Refresh(); } catch { } }
void UpdateGroup() { try { var counts = m_dtData.AsEnumerable().GroupBy(x => x.Field <string>("ten_loainhom")) .Select(g => new { g.Key, Count = g.Count() }); if (counts.Count() >= 2) { if (grdList.RootTable.Groups.Count <= 0) { GridEXColumn gridExColumn = grdList.RootTable.Columns["ten_loainhom"]; var gridExGroup = new GridEXGroup(gridExColumn); gridExGroup.GroupPrefix = ""; grdList.RootTable.Groups.Add(gridExGroup); } } else { GridEXColumn gridExColumn = grdList.RootTable.Columns["ten_loainhom"]; var gridExGroup = new GridEXGroup(gridExColumn); grdList.RootTable.Groups.Clear(); } grdList.UpdateData(); grdList.Refresh(); } catch { } }
private void UpdateSumOfChiDinh() { GridEXColumn gridExColumn = grdDetail.RootTable.Columns["TT"]; GridEXColumn gridExColumnPhuThu = grdDetail.RootTable.Columns[KcbChidinhclsChitiet.Columns.PhuThu]; decimal Thanhtien = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumn, AggregateFunction.Sum)); decimal phuthu = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); }
private void btnExportExcel_Click(object sender, EventArgs e) { string pFromBarcode = dtpDatePrintFrom.Value.ToString("yyMMdd") + txtFromBarcode.Text.Trim().PadLeft(4, '0') + ".NB"; string pToDate = dtpDatePrintFrom.Value.ToString("yyMMdd") + txtToBarcode.Text.Trim().PadLeft(4, '0') + ".NB"; int testTypeID = Utility.Int32Dbnull(Utility.GetPropertyValue(cboTestType, "SelectedValue"), -1); dtRawResult = SPs.GtvtBaoCaoLuuNoBarCode(Utility.sDbnull(pFromBarcode), Utility.sDbnull(pToDate), testTypeID). GetDataSet().Tables[0]; var dataTable = new DataTable(); dataTable = lablinkhelper.Utilities.GetInversedDataTable(dtRawResult, "Para_Name", "Barcode", "Test_Result", "", false); if (dataTable.Rows.Count <= 0) { Utility.ShowMsg("Không tìm thấy kết quả !"); return; } for (int i = 0; i < dataTable.Columns.Count; i++) { GridEXColumn grdCol = new GridEXColumn(dataTable.Columns[i].ColumnName); grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol); //grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.Count; } // grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false; //SetPropertiesCol("Barcode", "Barcode"); // SetPropertiesCol("Test_Date", "Ngày Xét Nghiệm"); // SetPropertiesCol("TestType_Name", "Loại XN"); grdAllPatientInfoAndResult.DataSource = dataTable; grdAllPatientInfoAndResult.AutoSizeColumns(); ExcelReport.ExportGridEx(grdAllPatientInfoAndResult); }
/// <summary> /// tạo grid janus /// </summary> private void CreateGrid() { gridEX1.RootTable.Columns.Clear(); GridEXColumn col1 = new GridEXColumn(); col1.DataMember = "SoHieuXe"; col1.Key = "SoHieuXe"; col1.Caption = " Số hiệu xe"; col1.TextAlignment = TextAlignment.Center; col1.Width = 90; gridEX1.RootTable.Columns.Add(col1); for (int iGio = 0; iGio <= 23; iGio++) { GridEXColumn col = new GridEXColumn(); col.DataMember = "Gio_" + iGio.ToString(); col.Key = "Gio_" + iGio.ToString(); col.Caption = " " + iGio.ToString() + " h"; col.TextAlignment = TextAlignment.Center; col.Width = 50; GridEXFormatStyle headerStyle = new GridEXFormatStyle(); headerStyle.TextAlignment = TextAlignment.Center; col.HeaderStyle = headerStyle; gridEX1.RootTable.Columns.Add(col); } GridEXColumn col2 = new GridEXColumn(); col2.DataMember = "Tong"; col2.Key = "Tong"; col2.Caption = " Tổng "; col2.TextAlignment = TextAlignment.Center; col2.Width = 90; gridEX1.RootTable.Columns.Add(col2); }
private void InitializeItemContextMenu() { RowContextMenu = new ContextMenuStrip(); ToolStripMenuItem copyMenu = (ToolStripMenuItem)RowContextMenu.Items.Add("Copy to clipboard"); ToolStripMenuItem displayTextMenu = (ToolStripMenuItem)RowContextMenu.Items.Add("Display text..."); for (int index = 0; index < RootTable.Columns.Count; index++) { GridEXColumn columnHeader = RootTable.Columns[index]; ToolStripItem copyChildMenu = copyMenu.DropDownItems.Add(columnHeader.Caption); copyChildMenu.Click += new EventHandler(copyMenu_Click); copyChildMenu.Tag = columnHeader; ToolStripItem displayTextChildMenu = displayTextMenu.DropDownItems.Add(columnHeader.Caption); displayTextChildMenu.Click += new EventHandler(displayTextMenu_Click); displayTextChildMenu.Tag = columnHeader; } if (RootTable.Columns.Count > 1) { copyMenu.DropDownItems.Add("-"); displayTextMenu.DropDownItems.Add("-"); ToolStripItem copyFullRowMenu = copyMenu.DropDownItems.Add("Full row"); copyFullRowMenu.Click += new EventHandler(copyMenu_Click); ToolStripItem displayTextFullRowMenu = displayTextMenu.DropDownItems.Add("Full row"); displayTextFullRowMenu.Click += new EventHandler(displayTextMenu_Click); } }
private void GetDataPresDetail() { int stock_id = -1; stock_id = Utility.Int32Dbnull(id_khoXuat); m_dtDataPresDetail = SPs.DuocLaythongtinDonthuocLinhthuoc(Pres_ID, stock_id).GetDataSet().Tables[0]; if (!m_dtDataPresDetail.Columns.Contains("CHON")) { m_dtDataPresDetail.Columns.Add("CHON", typeof(int)); } foreach (DataRow dr in m_dtDataPresDetail.Rows) { dr["CHON"] = 0; } m_dtDataPresDetail.AcceptChanges(); string _rowFilter = string.Format("Pres_ID={0}", Pres_ID); Utility.SetDataSourceForDataGridEx(grdPresDetail, m_dtDataPresDetail, false, true, "1=1", KcbDonthuocChitiet.Columns.ThuTuIn); GridEXColumn gridExColumn = grdPresDetail.RootTable.Columns[KcbDonthuocChitiet.Columns.ThuTuIn]; var gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdPresDetail.RootTable.SortKeys.Add(gridExSortKey); // grdPresDetail.DataSource = p_dtPresDetail.DefaultView; ///thực hiện việc thay đổi khi load thông tin của thành tiền UpdateDataWhenChanged(); //ModifyCommnad(); }
void UpdateGroup() { try { var counts = m_dtPatient.AsEnumerable().GroupBy(x => x.Field <string>("ma_doituong_kcb")) .Select(g => new { g.Key, Count = g.Count() }); if (counts.Count() >= 2) { if (grdList.RootTable.Groups.Count <= 0) { GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"]; var gridExGroup = new GridEXGroup(gridExColumn); gridExGroup.GroupPrefix = "Nhóm đối tượng KCB: "; grdList.RootTable.Groups.Add(gridExGroup); } } else { GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"]; var gridExGroup = new GridEXGroup(gridExColumn); grdList.RootTable.Groups.Clear(); } grdList.UpdateData(); grdList.Refresh(); } catch { } }
public DialogResult ShowDialog(Janus.Windows.GridEX.GridEX grid, Form parent) { GridEXColumn column = null; int i = 0; this.lbAvail.DisplayMember = "Caption"; this.lbVisible.DisplayMember = "Caption"; for (i = 0; i < grid.RootTable.Columns.Count; i++) { column = grid.RootTable.Columns.GetColumnInPosition(i); if (column.ShowInFieldChooser) { if (column.Visible) { AddVisibleField(column, false); } else { AddAvailableField(column, false); } } } FillAvailableList(); FillVisibleList(); return this.ShowDialog(parent); }
public override void FormatGrid() { if (Memory.IsDesignMode) { return; } if (this.RootTable == null) { this.RootTable = new GridEXTable(); } base.FormatGrid(); this.RootTable.Columns.Clear(); this.ColumnAutoResize = false; //this.AllowEdit = InheritableBoolean.True; GridEXColumn col1 = this.RootTable.Columns.Add("MaLop", ColumnType.Text); col1.Width = 50; col1.BoundMode = ColumnBoundMode.Bound; col1.DataMember = "MaLop"; col1.Caption = "Mã Lớp"; col1.FilterEditType = FilterEditType.Combo; GridEXColumn col2 = this.RootTable.Columns.Add("TenLop", ColumnType.Text); col2.Width = 200; col2.BoundMode = ColumnBoundMode.Bound; col2.DataMember = "TenLop"; col2.Caption = "Tên lớp"; col2.FilterEditType = FilterEditType.Combo; //Khoan add start col2 = this.RootTable.Columns.Add("PhongHoc", ColumnType.Text); col2.Width = 80; col2.BoundMode = ColumnBoundMode.Bound; col2.DataMember = "PhongHoc"; col2.Caption = "Phòng học"; col2.FilterEditType = FilterEditType.Combo; //Khoan add end GridEXColumn col3 = this.RootTable.Columns.Add("GiaoLyVien", ColumnType.Text); col3.Width = 250; col3.BoundMode = ColumnBoundMode.Bound; col3.DataMember = "GiaoLyVien"; col3.Caption = "Giáo lý viên"; col3.FilterEditType = FilterEditType.Combo; GridEXColumn col4 = this.RootTable.Columns.Add("GhiChu", ColumnType.Text); col4.Width = 200; col4.BoundMode = ColumnBoundMode.Bound; col4.DataMember = "GhiChu"; col4.Caption = "Ghi chú"; col4.FilterEditType = FilterEditType.Combo; }
private void CreateGridsTable() { this.grdColumnList.BoundMode = BoundMode.Unbound; this.grdColumnList.RootTable = new GridEXTable(); GridEXColumn textColumn = new GridEXColumn(); textColumn.Selectable = false; textColumn.DataMember = "Text"; textColumn.Key = "Text"; GridEXColumn valueColumn = new GridEXColumn(); valueColumn.DataMember = "Value"; valueColumn.Key = "Value"; valueColumn.Visible = false; this.grdColumnList.RootTable.Columns.Add(textColumn); this.grdColumnList.RootTable.Columns.Add(valueColumn); this.grdCompositeColumns.BoundMode = BoundMode.Unbound; this.grdCompositeColumns.RootTable = new GridEXTable(); textColumn = new GridEXColumn(); textColumn.DataMember = "Text"; textColumn.Key = "Text"; textColumn.Selectable = false; valueColumn = new GridEXColumn(); valueColumn.DataMember = "Value"; valueColumn.Key = "Value"; valueColumn.Visible = false; this.grdCompositeColumns.RootTable.Columns.Add(textColumn); this.grdCompositeColumns.RootTable.Columns.Add(valueColumn); this.grdColumnList.ColumnAutoResize = true; this.grdCompositeColumns.ColumnAutoResize = true; }
private void ApplyFilters() { GridEXFilterCondition condition = new GridEXFilterCondition(); GridEXColumn column = new GridEXColumn(); gridExAgreementsListGrouped.RemoveFilters(); if (rdbKTM.Checked) { column = gridExAgreementsListGrouped.RootTable.Columns["KTM"]; condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["KTM"].Text); } else if (rdbDescriptor.Checked) { column = gridExAgreementsListGrouped.RootTable.Columns["Deskryptor"]; condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["Deskryptor"].Text); } else if (rdbTitle.Checked) { column = gridExAgreementsListGrouped.RootTable.Columns["Tytul"]; condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["Tytuł"].Text); } gridExAgreementsListGrouped.RootTable.ApplyFilter(condition); }
public override void FormatGrid() { if (Memory.IsDesignMode) { return; } base.FormatGrid(); GridEXColumn col = null; col = new GridEXColumn(MergeData.MaGiaDinhMoi, Janus.Windows.GridEX.ColumnType.Text); col.Width = 60; col.BoundMode = ColumnBoundMode.Bound; col.DataMember = MergeData.MaGiaDinhMoi; col.Caption = "Mã gia đình mới"; col.FilterEditType = FilterEditType.Combo; this.RootTable.Columns.Insert(0, col); col = new GridEXColumn(MergeData.KetQua, Janus.Windows.GridEX.ColumnType.Text); col.Width = 200; col.BoundMode = ColumnBoundMode.Bound; col.DataMember = MergeData.KetQua; col.Caption = "Kết quả"; col.FilterEditType = FilterEditType.Combo; this.RootTable.Columns.Insert(0, col); SetGridColumnWidth(); }
private void SetSortKey(GridEXColumn column, bool ascending, ComboBox combo, RadioButton optAscending, RadioButton optDescending) { if (column == null) { combo.SelectedIndex = 0; } else { foreach (object item in combo.Items) { object[] a = item as object[]; if (a.Length == 2) if (a[1] == column)//item._Value { combo.SelectedItem = item; break; } } } if (ascending) { optAscending.Checked = true; } else { optDescending.Checked = true; } }
void cboHoadon_SelectedIndexChanged(object sender, EventArgs e) { if (Utility.Int32Dbnull(cboHoadon.SelectedValue, -1) == 0) { grdList.RootTable.Groups.Clear(); chkMaQuyen.Enabled = false; pnlQuyen.Enabled = false; } else { chkMaQuyen.Enabled = true; chkMaQuyen_CheckedChanged(chkMaQuyen, e); grdList.RootTable.Groups.Clear(); GridEXColumn gridExColumn = grdList.RootTable.Columns["mau_hoadon"]; var gridExGroup = new GridEXGroup(gridExColumn); gridExGroup.GroupPrefix = "Mẫu hóa đơn: "; grdList.RootTable.Groups.Add(gridExGroup); gridExColumn = grdList.RootTable.Columns["ma_quyen"]; gridExGroup = new GridEXGroup(gridExColumn); gridExGroup.GroupPrefix = "Mã quyển: "; grdList.RootTable.Groups.Add(gridExGroup); } }
public void filterapply(GridEX grid, string filtername, CreateFilterForm hiddeninstanceinitialized) { foreach (string item in hiddeninstanceinitialized.comboBox7.Items) { if (item == filtername) { hiddeninstanceinitialized.comboBox7.SelectedItem = filtername; hiddeninstanceinitialized.comboBox7_SelectedIndexChanged(this, new EventArgs()); List <string> stacknames = new List <string>(); hiddeninstanceinitialized.processList(ref grid, false, 1, stacknames); } } foreach (string item in hiddeninstanceinitialized.comboBox1.Items) { if (item == filtername) { hiddeninstanceinitialized.comboBox1.SelectedItem = filtername; //hiddeninstanceinitialized.comboBox1_SelectedIndexChanged(this, new EventArgs()); GridEXColumn column = grid.RootTable.Columns[hiddeninstanceinitialized.comboBox5.SelectedValue.ToString()]; GridEXFilterCondition singlefiltercondtion = hiddenInstance.CreateSinglefilter(hiddenInstance.textBox6.Text, hiddenInstance.textBox7.Text, hiddenInstance.comboBox6.SelectedValue.ToString(), column); grid.RootTable.FilterCondition = singlefiltercondtion; grid.RootTable.ApplyFilter(singlefiltercondtion); break; } } grid.Refetch(); grid.Select(); }
private void SetGridSettings() { this.gridEX1.SetDataBinding(dataSet, "Contacts"); this.gridEX1.RetrieveStructure(); this.gridEX1.VisualStyle = VisualStyle.Office2003; //Create multiplevalues column //When using a many-to-manyn relation, the DataMember of the MultipleValues //column must be the name of the relation between the parent table and the //relation table. GridEXColumn col = new GridEXColumn(); col.Key = "Categories"; col.MultipleValues = true; col.DataMember = "Contacts_ContactCategories"; col.EditType = EditType.Combo; col.Caption = "Categories"; col.Width = 200; //Since the column will be bound to a list containing DataRowView objects, we must specify which //field in the DataRowView will be used as value col.MultipleValueDataMember = "CategoryId"; //Fill the ValueList with the categories table col.HasValueList = true; col.ValueList.PopulateValueList(dataSet.Tables["Categories"].DefaultView, "CategoryId", "CategoryName"); col.DefaultGroupInterval = GroupInterval.Text; col.CompareTarget = ColumnCompareTarget.Text; gridEX1.RootTable.Columns.Add(col); }
public override void FormatGrid() { if (Memory.IsDesignMode) { return; } if (this.RootTable == null) { this.RootTable = new GridEXTable(); } base.FormatGrid(); this.RootTable.Columns.Clear(); //GridEXColumn col1 = this.RootTable.Columns.Add(GiaoHoConst.MaGiaoHo, ColumnType.Text); //col1.Width = 80; //col1.BoundMode = ColumnBoundMode.Bound; //col1.DataMember = GiaoHoConst.MaGiaoHo; //col1.Caption = "Mã giáo họ"; GridEXColumn col2 = this.RootTable.Columns.Add(GiaoHoConst.TenGiaoHo, ColumnType.Text); col2.Width = 200; col2.BoundMode = ColumnBoundMode.Bound; col2.DataMember = GiaoHoConst.TenGiaoHo; col2.FilterEditType = FilterEditType.Combo; col2.Caption = "Tên giáo họ"; RootTable.RowHeight = 20; this.ColumnHeaders = InheritableBoolean.True; this.RowHeaderContent = RowHeaderContent.RowHeaderText; this.RowHeaders = InheritableBoolean.True; this.FilterMode = FilterMode.None; }
private void CreateExceptionGrid(TableLayoutPanel panel) { ExceptionsGrid = new NuGenCustomDataGridView(); ExceptionsGrid.GroupByBoxVisible = false; ExceptionsGrid.VisualStyle = VisualStyle.Office2007; ExceptionsGrid.Dock = DockStyle.Fill; ExceptionsGrid.RootTable = new GridEXTable(); GridEXColumn skipColumn = new GridEXColumn(); skipColumn.ColumnType = ColumnType.CheckBox; skipColumn.DataMember = "Skip"; skipColumn.Caption = "Skip"; ExceptionsGrid.RootTable.Columns.Add(skipColumn); GridEXColumn assemblyPathColumn = new GridEXColumn(); assemblyPathColumn.DataMember = "AssemblyPath"; assemblyPathColumn.Caption = "Assembly"; ExceptionsGrid.RootTable.Columns.Add(assemblyPathColumn); GridEXColumn tokenColumn = new GridEXColumn(); tokenColumn.DataMember = "ExceptionClassTokenString"; tokenColumn.Caption = "Exception Token"; ExceptionsGrid.RootTable.Columns.Add(tokenColumn); GridEXColumn classNameColumn = new GridEXColumn(); classNameColumn.DataMember = "ExceptionClassName"; classNameColumn.Caption = "Exception Class"; ExceptionsGrid.RootTable.Columns.Add(classNameColumn); GridEXColumn methodTokenColumn = new GridEXColumn(); methodTokenColumn.DataMember = "ThrowingMethodTokenString"; ExceptionsGrid.RootTable.Columns.Add(methodTokenColumn); GridEXColumn methodNameColumn = new GridEXColumn(); methodNameColumn.DataMember = "ThrowingMethodName"; methodNameColumn.Caption = "Method Name"; ExceptionsGrid.RootTable.Columns.Add(methodNameColumn); GridEXColumn ipColumn = new GridEXColumn(); ipColumn.DataMember = "IPAsString"; ipColumn.Caption = "IP"; ExceptionsGrid.RootTable.Columns.Add(ipColumn); BindingSource bindingSource = new BindingSource(NuGenProject.Instance.Exceptions, string.Empty); ExceptionsGrid.DataSource = bindingSource; panel.Controls.Add(ExceptionsGrid); ExceptionsGrid.Initialize(); }
private bool GetConditionValues() { if (mActiveCondition != null) { if (this.cboFields.SelectedItem == null) { MessageBox.Show("Select the field for the condition", MainQD.MessageCaption); this.cboFields.Focus(); return false; } GridEXColumn column = ((ComboboxItem)this.cboFields.SelectedItem).Value; try { object value1 = Convert.ChangeType(txtValue1.Text, column.Type); mActiveCondition.Value1 = value1; } catch { MessageBox.Show("Value 1 is not valid", MainQD.MessageCaption); txtValue1.Focus(); txtValue1.SelectionStart = txtValue1.Text.Length; return false; } if (mTwoValues) { try { object value2 = Convert.ChangeType(txtValue2.Text, column.Type); mActiveCondition.Value2 = value2; } catch { MessageBox.Show("Value 2 is not valid", MainQD.MessageCaption); txtValue2.SelectionStart = 0; return false; } } else { mActiveCondition.Value2 = null; } mActiveCondition.Key = txtConditionName.Text; mActiveCondition.Column = column; mActiveCondition.ConditionOperator = ((ComboboxConditionItem)this.cboCondition.SelectedItem).Value; mActiveCondition.FormatStyle.BackColor = this.btnBackColor.BackColor; mActiveCondition.FormatStyle.ForeColor = this.btnForeColor.BackColor; mActiveCondition.FormatStyle.FontBold = this.chkBold.Checked ? TriState.True : TriState.False; mActiveCondition.FormatStyle.FontItalic = this.chkItalic.Checked ? TriState.True : TriState.False; mActiveCondition.FormatStyle.FontUnderline = this.chkUnderline.Checked ? TriState.True : TriState.False; mActiveCondition.FormatStyle.FontStrikeout = this.chkStrikeout.Checked ? TriState.True : TriState.False; } return true; }
/// <summary> /// /// </summary> /// <param name="column"></param> /// <param name="text"></param> /// <param name="width"></param> public static void SetToButtonColumn(this GridEXColumn column, string text, int width) { column.Width = width; column.AllowSize = false; column.ButtonDisplayMode = Janus.Windows.GridEX.CellButtonDisplayMode.Always; column.ButtonStyle = Janus.Windows.GridEX.ButtonStyle.TextButton; column.ButtonText = text; }
private VillageFields GetVillageColumnType(GridEXColumn column) { VillageFields type; if (Enum.TryParse(column.Key, out type)) { return type; } throw new Exception("Column should be in VillageFields enum!"); }
private GridEXSortKey CreateSortKey(GridEXColumn column, bool ascending) { GridEXSortKey sortKey = new GridEXSortKey(); sortKey.Column = column; if (!ascending) { sortKey.SortOrder = Janus.Windows.GridEX.SortOrder.Descending; } return sortKey; }
public static void GridFormatConditionSetting(GridEX jg, GridEXColumn gcName, object gcValue, ConditionOperator co) { GridEXFormatCondition fc = new GridEXFormatCondition(); fc.Column = gcName; fc.ConditionOperator = co; fc.Value1 = gcValue; fc.FormatStyle.BackColor = Color.GreenYellow; jg.RootTable.FormatConditions.Add(fc); }
private VillageFields GetVillageColumnType(GridEXColumn column) { VillageFields type; if (Enum.TryParse(column.Key, out type)) { return(type); } throw new Exception("Column should be in VillageFields enum!"); }
private void btnDown_Click(object sender, System.EventArgs e) { GridEXColumn column = null; int selIndex = lbVisible.SelectedIndex; column = (GridEXColumn)(this.mVisibleFields[selIndex]); mVisibleFields.Remove(column); mVisibleFields.Insert(selIndex + 1, column); FillVisibleList(); lbVisible.SelectedIndex = selIndex + 1; }
private void InitializeGridColumns() { GridEXColumn newColumn = null; this.grdColumns.DataSource = grid.RootTable.Columns; this.grdColumns.RetrieveStructure(); this.grdColumns.RootTable.Columns.Clear(); newColumn = this.grdColumns.RootTable.Columns.Add("Caption", ColumnType.Text); newColumn.EditType = EditType.NoEdit; newColumn = this.grdColumns.RootTable.Columns.Add("Visible", ColumnType.CheckBox); newColumn.EditType = EditType.CheckBox; }
private void button2_Click_1(object sender, EventArgs e) { //FilterLog.WriteToLog("Debug Level 1:applying filter (saved filters)"); this.pushedonce = true; if (this.listBox1.Text == "") { return; } myFilter = "Επιλογη βάση φίλτρου:" + this.listBox1.Text; prefix = ""; string simpleoscomposite = (this.listBox1.SelectedIndex > lastsimpleidx) ? "ΣΥΝΘΕΤΟ" : "ΑΠΛΟ"; if (simpleoscomposite == "ΣΥΝΘΕΤΟ") { hiddenInstance.comboBox7.Text = this.listBox1.Text; //hiddenInstance.updatecombos(); // Dictionary<string, double> overridepercssstoreit = new Dictionary<string, double>(); hiddenInstance.comboBox7.SelectedItem = this.listBox1.SelectedItem; hiddenInstance.comboBox7_SelectedIndexChanged(this, new EventArgs()); List <string> stacknames = new List <string>(); hiddenInstance.processList(ref this.gridEX2, false, 1, stacknames); this.textBox1.Text = gridEX2.RowCount.ToString() + " εγγραφές"; } if (simpleoscomposite == "ΑΠΛΟ") { hiddenInstance.comboBox1.SelectedItem = this.listBox1.SelectedItem; GridEXColumn column = this.gridEX2.RootTable.Columns[this.arrayofcolumns[hiddenInstance.comboBox5.SelectedIndex].ToString()]; GridEXFilterCondition singlefiltercondtion = hiddenInstance.CreateSinglefilter(hiddenInstance.textBox6.Text, hiddenInstance.textBox7.Text, hiddenInstance.comboBox6.SelectedValue.ToString(), column); this.gridEX2.RootTable.FilterCondition = singlefiltercondtion; this.gridEX2.RootTable.ApplyFilter(singlefiltercondtion); } this.gridEX2.Refetch(); this.gridEX2.Select(); selectfiltered(this.gridEX2); }
private void PreparePermissionsGrid() { GridEXColumn colLevel = gridExUserPermissions.RootTable.Columns["Poziom"]; colLevel.HasValueList = true; GridEXValueListItemCollection valuesCboLevel = colLevel.ValueList; valuesCboLevel.Add(0, "Brak"); valuesCboLevel.Add(1, "Tylko odczyt"); valuesCboLevel.Add(2, "Pełne"); }
private void btnMoveDown_Click(object sender, System.EventArgs e) { int index = this.grdCompositeColumns.Row; GridEXColumn col = this.CompositeColumns[index]; this.mCompositeColumns.RemoveAt(index); this.mCompositeColumns.Insert(index + 1, col); this.FillControls(false, true); this.grdCompositeColumns.MoveTo(index + 1); }
private void cmdINPHIEU_Click(object sender, EventArgs e) { try { grdAllPatientInfoAndResult.RootTable.Columns.Clear(); dtResult = SPs.SpRptAllPatientInfoAndResultXayDung(dtpFromDate.Value.Date, dtpToDate.Value.Date.AddDays(1).AddMilliseconds(-5), Utility.Int32Dbnull(cboTestType.SelectedValue), Utility.Int16Dbnull(cboObjectType.SelectedValue), Utility.Int16Dbnull(cboDepartment.SelectedValue), Utility.sDbnull(cboAddress.Text), Utility.Int16Dbnull(cboDevices.SelectedValue)). GetDataSet().Tables[0]; if (dtResult.Rows.Count <= 0 | dtResult.Columns.Count <= 1) { Utility.ShowMsg("Không tìm thấy kết quả !"); return; } for (int i = 0; i < dtResult.Columns.Count; i++) { GridEXColumn grdCol = new GridEXColumn(dtResult.Columns[i].ColumnName); grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol); grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.ValueCount; } grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false; SetPropertiesCol("Barcode", "Barcode"); SetPropertiesCol("Patient_Name", "Tên BN"); SetPropertiesCol("SexName", "Giới Tính"); SetPropertiesCol("Year_Birth", "Năm Sinh"); SetPropertiesCol("PID", "PID"); SetPropertiesCol("Address", "Địa Chỉ"); SetPropertiesCol("Year_Birth", "Năm sinh"); SetPropertiesCol("Insurance_Num", "Số thẻ BHYT"); SetPropertiesCol("Baroce", "Barcode"); SetPropertiesCol("ObjectType_Name", "Đối tượng"); SetPropertiesCol("Department_Name", "Khoa"); SetPropertiesCol("Age", "Tuổi"); grdAllPatientInfoAndResult.DataSource = dtResult; grdAllPatientInfoAndResult.AutoSizeColumns(); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void cmdExportExcel_Click(object sender, EventArgs e) { var ds = SPs.SpBaoCaoXoaKetQua(dtpFromDate.Value.ToString("yyyy/MM/dd"), dtpToDate.Value.ToString("yyyy/MM/dd"), Utility.Int32Dbnull(cboTestType.SelectedValue, -1), Utility.sDbnull(cboUserName.SelectedValue, "")).GetDataSet(); var dataTable = new DataTable(); //Tổng hợp if (cboReportType.SelectedIndex == 1) { dt = ds.Tables[0]; //dataTable = Utilities.GetInversedDataTable(dt, "Para_Name", "Barcode", "Test_Result", "", false); } //Chi tiết else { dt = ds.Tables[1]; dataTable = Utilities.GetInversedDataTable(dt, "TestType_Name", "Barcode", "Delete_Date", "", false); } if (dataTable.Rows.Count <= 0) { Utility.ShowMsg("Không có dữ liệu để báo cáo"); return; } for (int i = 0; i < dataTable.Columns.Count; i++) { GridEXColumn grdCol = new GridEXColumn(dataTable.Columns[i].ColumnName); grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol); //grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.Count; } // grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false; //SetPropertiesCol("Barcode", "Barcode"); // SetPropertiesCol("Test_Date", "Ngày Xét Nghiệm"); // SetPropertiesCol("TestType_Name", "Loại XN"); grdAllPatientInfoAndResult.DataSource = dataTable; grdAllPatientInfoAndResult.AutoSizeColumns(); ExcelReport.ExportGridEx(grdAllPatientInfoAndResult); }