private void jsgConditions_SelectionChanged(object sender, System.EventArgs e) { Janus.Windows.GridEX.GridEXRow currentRow = this.jsgConditions.GetRow(); if (currentRow != null) { ActiveCondition = (GridEXFormatCondition)currentRow.DataRow; if (currentRow.Position == 0) { this.btnMoveUp.Enabled = false; } else { this.btnMoveUp.Enabled = true; } if (currentRow.Position < this.jsgConditions.RowCount - 1) { this.btnMoveDown.Enabled = true; } else { this.btnMoveDown.Enabled = false; } } else { this.btnMoveDown.Enabled = false; this.btnMoveUp.Enabled = false; ActiveCondition = null; } }
private void AddConditionalFormatting() { //Adding a condition using Discontinued field GridEXFormatCondition fc; fc = new GridEXFormatCondition( GridEX1.RootTable.Columns["Discontinued"], ConditionOperator.Equal, true); //setting Format style properties to be applied to all the rows //that met this condition fc.FormatStyle.FontStrikeout = TriState.True; fc.FormatStyle.ForeColor = SystemColors.GrayText; GridEX1.RootTable.FormatConditions.Add(fc); //adding a format condition to use font bold when OnSale field is true fc = new GridEXFormatCondition( GridEX1.RootTable.Columns["OnSale"], ConditionOperator.Equal, true); fc.FormatStyle.FontBold = Janus.Windows.GridEX.TriState.True; fc.FormatStyle.ForeColor = Color.Red; GridEX1.RootTable.FormatConditions.Add(fc); }
protected override void FillGridBefore() { IList <string> colors = new List <string>(); foreach (XModelBase model in this.m_CurrentList) { XCodeEquipmentStateInfo stateInfo = model as XCodeEquipmentStateInfo; GridEXFormatCondition condition = new GridEXFormatCondition(); if (!colors.Contains(stateInfo.ColorRGB) && stateInfo.ColorRGB != "0,0,0") { try { Color color = XColorHelper.GetColorFormStringRgb(stateInfo.ColorRGB); condition.FormatStyle.BackColor = color; condition.Column = this.grdData.RootTable.Columns["ColorRGB"]; condition.Value1 = stateInfo.ColorRGB; this.grdData.RootTable.FormatConditions.Add(condition); colors.Add(stateInfo.ColorRGB); } catch (Exception ex) { XErrorLogTool.WriteLog(ex.ToString()); } } } }
private void jsgConditions_FormattingRow(object sender, Janus.Windows.GridEX.RowLoadEventArgs e) { if (e.Row.RowType == Janus.Windows.GridEX.RowType.Record) { GridEXFormatCondition formatCondition = (GridEXFormatCondition)e.Row.DataRow; e.Row.RowStyle = new GridEXFormatStyle(formatCondition.FormatStyle); } }
private void AddConditionalFormatting() { GridEXFormatCondition fc = new GridEXFormatCondition( this.grida.RootTable.Columns["colDiferenca"], ConditionOperator.LessThan, 0); fc.FormatStyle.ForeColor = Color.Red; this.grida.RootTable.FormatConditions.Add(fc); }
private void btnDelete_Click(object sender, System.EventArgs e) { this.jsgConditions.AllowDelete = Janus.Windows.GridEX.InheritableBoolean.True; mActiveCondition = null; OnActiveConditionChanged(); this.jsgConditions.Delete(); this.jsgConditions.AllowDelete = Janus.Windows.GridEX.InheritableBoolean.False; }
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 void AddConditionalFormatting() { GridEXFormatCondition fc = new GridEXFormatCondition( this.gridArtikujt.RootTable.Columns["colDisponibiliteti"], ConditionOperator.Equal, false); //fc.FormatStyle.FontBold = Janus.Windows.GridEX.TriState.True; //fc.FormatStyle.ForeColor = Color.Chocolate; fc.FormatStyle.FontStrikeout = TriState.True; this.gridArtikujt.RootTable.FormatConditions.Add(fc); }
private void btnNew_Click(object sender, System.EventArgs e) { if (this.GetConditionValues()) { GridEXFormatCondition condition = new GridEXFormatCondition(); condition.Key = "Untitled"; this.tempConditions.Add(condition); this.jsgConditions.Refetch(); this.jsgConditions.Row = this.jsgConditions.RecordCount - 1; this.jsgConditions.Focus(); } }
private void AddConditionalFormatting() { GridEXFormatCondition fc = new GridEXFormatCondition( this.gridEXSMS.RootTable.Columns["BOSH"], ConditionOperator.Equal, true); fc.FormatStyle.ForeColor = Color.Navy; this.gridEXSMS.RootTable.FormatConditions.Add(fc); fc = new GridEXFormatCondition( this.gridEXSMS.RootTable.Columns["TELEFON"], ConditionOperator.Equal, ""); fc.FormatStyle.ForeColor = Color.FromArgb(192, 0, 0); this.gridEXSMS.RootTable.FormatConditions.Add(fc); }
public void ShowDialog(Janus.Windows.GridEX.GridEX gridEx, System.Windows.Forms.Form parentForm) { mGridEX = gridEx; this.PopulateCombos(); tempConditions = new System.Collections.ArrayList(); foreach (GridEXFormatCondition cond in this.mGridEX.RootTable.FormatConditions) { GridEXFormatCondition cloneCond = cond.Clone(); tempConditions.Add(cloneCond); } this.jsgConditions.RootTable.Columns["clmName"].DataMember = "Key"; this.jsgConditions.RootTable.Columns["clmEnabled"].DataMember = "Enabled"; this.jsgConditions.SetDataBinding(tempConditions, ""); OnActiveConditionChanged(); this.ShowDialog(parentForm); }
public override void FormatGrid() { if (Memory.IsDesignMode) { return; } if (this.RootTable == null) { this.RootTable = new GridEXTable(); } this.RootTable.RowHeight = -1; this.VisualStyle = VisualStyle.Office2003; this.ColumnAutoResize = false; this.ScrollBars = Janus.Windows.GridEX.ScrollBars.Both; this.RootTable.Columns.Clear(); GridEXColumn col0 = this.RootTable.Columns.Add(GxConstants.NGUYEN_NHAN, ColumnType.Text); col0.Width = 220; col0.Caption = "Nguyên nhân"; col0.FilterEditType = FilterEditType.Combo; if (!choNhapMaRieng) { GridEXColumn col1 = this.RootTable.Columns.Add(GiaDinhConst.MaGiaDinh, ColumnType.Text); col1.Width = 50; col1.BoundMode = ColumnBoundMode.Bound; col1.DataMember = GiaDinhConst.MaGiaDinh; col1.Caption = "Mã gia đình"; col1.FilterEditType = FilterEditType.Combo; } else { GridEXColumn col1 = this.RootTable.Columns.Add(GiaDinhConst.MaGiaDinhRieng, ColumnType.Text); col1.Width = 50; col1.BoundMode = ColumnBoundMode.Bound; col1.DataMember = GiaDinhConst.MaGiaDinhRieng; col1.Caption = "Mã gia đình"; col1.FilterEditType = FilterEditType.Combo; } GridEXColumn col2 = this.RootTable.Columns.Add(GiaDinhConst.TenGiaDinh, ColumnType.Text); col2.Width = 100; col2.BoundMode = ColumnBoundMode.Bound; col2.DataMember = GiaDinhConst.TenGiaDinh; col2.Caption = "Tên gia đình"; col2.FilterEditType = FilterEditType.Combo; GridEXColumn col3 = this.RootTable.Columns.Add(GiaDinhConst.TenChong, ColumnType.Text); col3.Width = 200; col3.BoundMode = ColumnBoundMode.Bound; col3.DataMember = GiaDinhConst.TenChong; col3.Caption = "Bên nam"; col3.FilterEditType = FilterEditType.Combo; GridEXColumn col4 = this.RootTable.Columns.Add(GiaDinhConst.TenVo, ColumnType.Text); col4.Width = 200; col4.BoundMode = ColumnBoundMode.Bound; col4.DataMember = GiaDinhConst.TenVo; col4.Caption = "Bên nữ"; col4.FilterEditType = FilterEditType.Combo; //GridEXColumn col7 = this.RootTable.Columns.Add(GiaDinhConst.NgayHonPhoi, ColumnType.Text); //col7.Width = 80; //col7.BoundMode = ColumnBoundMode.Bound; //col7.DataMember = GiaDinhConst.NgayHonPhoi; //col7.TextAlignment = TextAlignment.Far; //col7.Caption = "Ngày HP"; //col7.FilterEditType = FilterEditType.Combo; //GridEXColumn col6 = this.RootTable.Columns.Add(GiaDinhConst.CachThucHonPhoi, ColumnType.Text); //col6.Width = 100; //col6.BoundMode = ColumnBoundMode.Bound; //col6.DataMember = GiaDinhConst.CachThucHonPhoi; //col6.Caption = "Tình trạng HP"; //col6.FilterEditType = FilterEditType.Combo; //col6.ValueList.Add("Hợp pháp", "Hợp pháp"); //col6.ValueList.Add("Hợp thức hóa", "Hợp thức hóa"); //col6.ValueList.Add("Chuẩn", "Chuẩn"); //col6.ValueList.Add("Không theo phép đạo", "Không theo phép đạo"); //col6.ValueList.Add("Không xác định", "Không xác định"); GridEXColumn col8 = this.RootTable.Columns.Add(GiaDinhConst.DienThoai, ColumnType.Text); col8.Width = 80; col8.BoundMode = ColumnBoundMode.Bound; col8.DataMember = GiaDinhConst.DienThoai; col8.Caption = "Điện thoại"; col8.FilterEditType = FilterEditType.Combo; GridEXColumn col9 = this.RootTable.Columns.Add(GiaDinhConst.DiaChi, ColumnType.Text); col9.Width = 100; col9.BoundMode = ColumnBoundMode.Bound; col9.DataMember = GiaDinhConst.DiaChi; col9.Caption = "Địa chỉ"; col9.FilterEditType = FilterEditType.Combo; GridEXColumn col10 = this.RootTable.Columns.Add(GiaDinhConst.GhiChu, ColumnType.Text); col10.Width = 200; col10.BoundMode = ColumnBoundMode.Bound; col10.DataMember = GiaDinhConst.GhiChu; col10.Caption = "Ghi chú"; col10.FilterEditType = FilterEditType.Combo; GridEXColumn col5 = this.RootTable.Columns.Add(GiaDinhConst.TenGiaoHo, ColumnType.Text); col5.Width = 80; col5.BoundMode = ColumnBoundMode.Bound; col5.DataMember = GiaDinhConst.TenGiaoHo; col5.Caption = "Giáo họ"; col5.FilterEditType = FilterEditType.Combo; GridEXColumn col16 = this.RootTable.Columns.Add(GxConstants.KETQUA_KIEMRA, ColumnType.Text); col16.Visible = false; GridEXColumn col17 = this.RootTable.Columns.Add(GiaDinhConst.GiaDinhAo, ColumnType.CheckBox); col17.Width = 50; col17.BoundMode = ColumnBoundMode.Bound; col17.DataMember = GiaDinhConst.GiaDinhAo; col17.Caption = "GĐ không thống kê"; col17.FilterEditType = FilterEditType.CheckBox; GridEXFormatCondition con1 = new GridEXFormatCondition(col16, ConditionOperator.Equal, (int)ReviewGiaDinhType.HonPhoiTruocTuoi); con1.FormatStyle = new GridEXFormatStyle(); con1.FormatStyle.BackColor = Color.Cyan; GridEXFormatCondition con2 = new GridEXFormatCondition(col16, ConditionOperator.Equal, (int)ReviewGiaDinhType.KhoangCachTuoiKhongHopLe); con2.FormatStyle = new GridEXFormatStyle(); con2.FormatStyle.BackColor = Color.Yellow; GridEXFormatCondition con3 = new GridEXFormatCondition(col16, ConditionOperator.Equal, (int)ReviewGiaDinhType.KhongCoNgayHonPhoi); con3.FormatStyle = new GridEXFormatStyle(); con3.FormatStyle.BackColor = Color.LightGray; GridEXFormatCondition con4 = new GridEXFormatCondition(col16, ConditionOperator.Equal, (int)ReviewGiaDinhType.NhieuVoChong); con4.FormatStyle = new GridEXFormatStyle(); con4.FormatStyle.BackColor = Color.LightCoral; this.RootTable.FormatConditions.Add(con1); this.RootTable.FormatConditions.Add(con2); this.RootTable.FormatConditions.Add(con3); this.RootTable.FormatConditions.Add(con4); this.RowHeaders = InheritableBoolean.True; col0.MaxLines = 100; col0.WordWrap = true; SetGridColumnWidth(); }
public override void FormatGrid() { try { if (Memory.IsDesignMode) { return; } if (this.RootTable == null) { this.RootTable = new GridEXTable(); } this.RootTable.RowHeight = -1; this.VisualStyle = VisualStyle.Office2003; this.ColumnAutoResize = false; this.ScrollBars = Janus.Windows.GridEX.ScrollBars.Both; this.RootTable.Columns.Clear(); GridEXColumn col0 = this.RootTable.Columns.Add(GxConstants.NGUYEN_NHAN, ColumnType.Text); col0.Width = 220; col0.Caption = "Nguyên nhân"; col0.FilterEditType = FilterEditType.Combo; GridEXColumn col1 = this.RootTable.Columns.Add(GiaoDanConst.MaGiaoDan, ColumnType.Text); col1.Width = 50; col1.BoundMode = ColumnBoundMode.Bound; col1.DataMember = GiaoDanConst.MaGiaoDan; col1.Caption = "Mã GD"; col1.FilterEditType = FilterEditType.Combo; GridEXColumn col2 = this.RootTable.Columns.Add(GiaoDanConst.TenThanh, ColumnType.Text); col2.Width = 80; col2.BoundMode = ColumnBoundMode.Bound; col2.DataMember = GiaoDanConst.TenThanh; col2.Caption = "Tên thánh"; col2.FilterEditType = FilterEditType.Combo; GridEXColumn col3 = this.RootTable.Columns.Add(GiaoDanConst.HoTen, ColumnType.Text); col3.Width = 150; col3.BoundMode = ColumnBoundMode.Bound; col3.DataMember = GiaoDanConst.HoTen; col3.Caption = "Họ tên"; col3.FilterEditType = FilterEditType.Combo; GridEXColumn col4 = this.RootTable.Columns.Add(GiaoDanConst.Phai, ColumnType.Text); col4.Width = 50; col4.BoundMode = ColumnBoundMode.Bound; col4.DataMember = GiaoDanConst.Phai; col4.Caption = "Phái"; col4.FilterEditType = FilterEditType.DropDownList; GridEXColumn col5 = this.RootTable.Columns.Add(GiaoDanConst.NgaySinh, ColumnType.Text); col5.Width = 80; col5.BoundMode = ColumnBoundMode.Bound; col5.DataMember = GiaoDanConst.NgaySinh; col5.TextAlignment = TextAlignment.Far; col5.Caption = "Ngày sinh"; col5.FilterEditType = FilterEditType.Combo; GridEXColumn col6 = this.RootTable.Columns.Add(GiaoDanConst.NgayRuaToi, ColumnType.Text); col6.Width = 80; col6.BoundMode = ColumnBoundMode.Bound; col6.DataMember = GiaoDanConst.NgayRuaToi; col6.TextAlignment = TextAlignment.Far; col6.Caption = "Ngày rửa tội"; col6.FilterEditType = FilterEditType.Combo; GridEXColumn col7 = this.RootTable.Columns.Add(GiaoDanConst.NgayRuocLe, ColumnType.Text); col7.Width = 80; col7.BoundMode = ColumnBoundMode.Bound; col7.DataMember = GiaoDanConst.NgayRuocLe; col7.TextAlignment = TextAlignment.Far; col7.Caption = "Ngày XTRL"; col7.FilterEditType = FilterEditType.Combo; GridEXColumn col8 = this.RootTable.Columns.Add(GiaoDanConst.NgayThemSuc, ColumnType.Text); col8.Width = 80; col8.BoundMode = ColumnBoundMode.Bound; col8.DataMember = GiaoDanConst.NgayThemSuc; col8.TextAlignment = TextAlignment.Far; col8.Caption = "Ngày Th.Sức"; col8.FilterEditType = FilterEditType.Combo; GridEXColumn col9 = this.RootTable.Columns.Add(GiaoDanConst.DaCoGiaDinh, ColumnType.CheckBox); col9.Width = 50; col9.BoundMode = ColumnBoundMode.Bound; col9.DataMember = GiaoDanConst.DaCoGiaDinh; col9.Caption = "Lập GĐ"; col9.FilterEditType = FilterEditType.CheckBox; GridEXColumn col12 = this.RootTable.Columns.Add(GiaoDanConst.GhiChu, ColumnType.Text); col12.Width = 200; col12.BoundMode = ColumnBoundMode.Bound; col12.DataMember = GiaoDanConst.GhiChu; col12.Caption = "Ghi chú"; col12.FilterEditType = FilterEditType.Combo; GridEXColumn col10 = this.RootTable.Columns.Add(GiaDinhConst.TenGiaoHo, ColumnType.Text); col10.Width = 80; col10.BoundMode = ColumnBoundMode.Bound; col10.DataMember = GiaDinhConst.TenGiaoHo; col10.Caption = "Giáo họ"; col10.FilterEditType = FilterEditType.Combo; GridEXColumn col13 = this.RootTable.Columns.Add(GiaoDanConst.GiaoDanAo, ColumnType.CheckBox); col13.Width = 50; col13.BoundMode = ColumnBoundMode.Bound; col13.DataMember = GiaoDanConst.GiaoDanAo; col13.Caption = "GD không thống kê"; col13.FilterEditType = FilterEditType.CheckBox; GridEXColumn col11 = this.RootTable.Columns.Add(GxConstants.KETQUA_KIEMRA, ColumnType.Text); col11.Visible = false; GridEXFormatCondition con1 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.SaiQuanHeNgayThang); con1.FormatStyle = new GridEXFormatStyle(); con1.FormatStyle.BackColor = Color.Cyan; GridEXFormatCondition con2 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.KhongCoDuLieuNgayThang); con2.FormatStyle = new GridEXFormatStyle(); con2.FormatStyle.BackColor = Color.Yellow; GridEXFormatCondition con3 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.RuocLeTruocTuoi); con3.FormatStyle = new GridEXFormatStyle(); con3.FormatStyle.BackColor = Color.LightGray; GridEXFormatCondition con4 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.ThuocNhieuGiaDinh); con4.FormatStyle = new GridEXFormatStyle(); con4.FormatStyle.BackColor = Color.AntiqueWhite; GridEXFormatCondition con5 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.KhongThuocGiaDinhNao); con5.FormatStyle = new GridEXFormatStyle(); con5.FormatStyle.BackColor = Color.WhiteSmoke; GridEXFormatCondition con6 = new GridEXFormatCondition(col11, ConditionOperator.Equal, (int)ReviewGiaoDanType.CoNhieuHonPhoi); con6.FormatStyle = new GridEXFormatStyle(); con6.FormatStyle.BackColor = Color.AliceBlue; this.RootTable.FormatConditions.Add(con1); this.RootTable.FormatConditions.Add(con2); this.RootTable.FormatConditions.Add(con3); this.RootTable.FormatConditions.Add(con4); this.RootTable.FormatConditions.Add(con5); this.RootTable.FormatConditions.Add(con6); this.RowHeaders = InheritableBoolean.True; col0.MaxLines = 100; col0.WordWrap = true; //foreach (GridEXColumn col in this.RootTable.Columns) //{ // col.MaxLines = 100; // col.WordWrap = true; //} SetGridColumnWidth(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi Exception (GxGiaoDanList, FormatGrid)", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void gridEX1_RowDoubleClick(object sender, RowActionEventArgs e) { try { uiPanel2.Closed = true; if (gridEX1.GetRow().RowType == RowType.Record) { string TblName; DataRow dr = (DataRow)((DataRowView)gridEX1.GetRow().DataRow).Row; TblName = (string)dr["TableName"]; uiPanel1.Text = TblName; for (int i = cGridEX.RootTable.Columns.Count - 1; i >= 0; i--) { cGridEX.RootTable.Columns.Remove(cGridEX.RootTable.Columns[i]); } obe = AtMng.GetCodeTableBE(TblName); obe.Load(); cGridEX.DataSource = obe.myDT; int y = 0; for (int i = 0; obe.myDT.Columns.Count > i; i++) { if ((obe.myDT.Columns[i].ColumnName == "entryUser") || (obe.myDT.Columns[i].ColumnName == "entryDate") || (obe.myDT.Columns[i].ColumnName == "updateUser") || (obe.myDT.Columns[i].ColumnName == "updateDate") || (obe.myDT.Columns[i].ColumnName == "ts")) { } else { if (cGridEX.RootTable.Columns.Count > i) { } else { cGridEX.RootTable.Columns.Add(); } cGridEX.RootTable.Columns[y].DataMember = obe.myDT.Columns[i].ColumnName; cGridEX.RootTable.Columns[y].Key = obe.myDT.Columns[i].ColumnName; cGridEX.RootTable.Columns[y].AutoSizeMode = ColumnAutoSizeMode.AllCellsAndHeader; if (obe.myDT.Columns[i].DataType == System.Type.GetType("System.Boolean")) { cGridEX.RootTable.Columns[y].ColumnType = ColumnType.CheckBox; cGridEX.RootTable.Columns[y].EditType = EditType.CheckBox; } if (TblName == "AccountType") { switch (i) { case 1: cGridEX.RootTable.Columns[y].Caption = "Code"; break; case 2: cGridEX.RootTable.Columns[y].Caption = "Desc Eng"; break; case 3: cGridEX.RootTable.Columns[y].Caption = "Desc Fre"; break; default: cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName; break; } } else { cGridEX.RootTable.Columns[y].Caption = obe.myDT.Columns[i].ColumnName; if (obe.myDT.Columns[i].ColumnName == "WFBGColor") { cGridEX.RootTable.Columns[y].Selectable = false; uiPanel2.Closed = false; cGridEX.RootTable.Columns.Add("BGColor"); } } y++; } } cGridEX.RootTable.SortKeys.Add(cGridEX.RootTable.Columns[0], Janus.Windows.GridEX.SortOrder.Ascending); if (cGridEX.RootTable.Columns.Contains("Obsolete")) { Janus.Windows.GridEX.GridEXFormatCondition gfc2 = new GridEXFormatCondition(cGridEX.RootTable.Columns["Obsolete"], ConditionOperator.Equal, true); Janus.Windows.GridEX.GridEXFormatStyle gfs2 = new GridEXFormatStyle(); gfs2.FontStrikeout = TriState.True; gfc2.FormatStyle = gfs2; cGridEX.RootTable.FormatConditions.Add(gfc2); } if (cGridEX.RootTable.Columns.Contains("ReadOnly")) { Janus.Windows.GridEX.GridEXFormatCondition gfc = new GridEXFormatCondition(cGridEX.RootTable.Columns["ReadOnly"], ConditionOperator.Equal, true); Janus.Windows.GridEX.GridEXFormatStyle gfs = new GridEXFormatStyle(); gfs.BackColor = Color.Gainsboro; gfs.ForeColor = SystemColors.ControlDarkDark; gfc.FormatStyle = gfs; cGridEX.RootTable.FormatConditions.Add(gfc); } cGridEX.AutoSizeColumns(); } } catch (Exception x) { UIHelper.HandleUIException(x); } }
private void CauHinh() { HisDuocProperties = Utility.HisDuocProperties; cmdHuyDonThuoc.Visible = HisDuocProperties.HuyXacNhan; cmdXoaChiTietThuoc.Visible = HisDuocProperties.Chophepxoachitiet; Janus.Windows.GridEX.GridEXColumn gridExColumn = grdPres.RootTable.Columns[TPrescription.Columns.PresId]; Janus.Windows.GridEX.GridEXSortKey gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdPres.RootTable.SortKeys.Add(gridExSortKey); if (HisDuocProperties.KieuDuyetDonThuoc == "DONTHUOC") { Utility.VisiableGridEx(grdPres, TPrescription.Columns.Status, true); Janus.Windows.GridEX.GridEXColumn gridExColumnFormat = grdPres.RootTable.Columns[TPrescription.Columns.Status]; Janus.Windows.GridEX.GridEXFormatCondition gridExFormatCondition = new GridEXFormatCondition(gridExColumnFormat, ConditionOperator.Equal, 1); gridExFormatCondition.FormatStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); grdPres.RootTable.FormatConditions.Add(gridExFormatCondition); } else { Utility.VisiableGridEx(grdPres, TPrescription.Columns.Status, false); } dtNgayPhatThuoc.Enabled = HisDuocProperties.ChoPhepChinhNgayDuyet; chkLocNgayKhiDuyet.Checked = HisDuocProperties.LocDonThuocKhiDuyet; //LoadLayout(); }
public override void Init() { GameService.DbContext.GameResultValueSet.Where(f => f.GameResult.Game.StageId == Stage.Id).Load(); Data = new Dictionary <CompetitionReferee, DataTable>(); var refereeIndex = 1; foreach (var referee in GameService.DbContext.CompetitionRefereeSet.Where(f => f.CompetitionId == Stage.CompetitionId)) { var page = new Janus.Windows.UI.Tab.UITabPage(referee.IsMainReferee ? "Гл. судья" : "Судья №" + refereeIndex.ToString()) { Tag = referee }; if (!referee.IsMainReferee) { refereeIndex++; } refereeTabs.TabPages.Add(page); var grid = new GridEX() { Dock = DockStyle.Fill, Name = "gridReferee" }; page.Controls.Add(grid); var dt = GetTable(Stage, referee); grid.DataSource = dt; grid.RetrieveStructure(); grid.RootTable.Columns["Команда"].EditType = EditType.NoEdit; if (grid.RootTable.Columns.Contains("Жеребьевка")) { grid.RootTable.Columns["Жеребьевка"].EditType = EditType.NoEdit; grid.RootTable.SortKeys.Add(grid.RootTable.Columns["Жеребьевка"], Janus.Windows.GridEX.SortOrder.Ascending); } else { grid.RootTable.SortKeys.Add(grid.RootTable.Columns["Команда"], Janus.Windows.GridEX.SortOrder.Ascending); } grid.GroupByBoxVisible = false; grid.ColumnAutoSizeMode = ColumnAutoSizeMode.ColumnHeader; grid.ColumnAutoResize = true; grid.RootTable.Columns.Cast <GridEXColumn>().ToList().ForEach(f => { if (dt.Columns[f.DataMember].DataType == typeof(int)) { var condition = new GridEXFormatCondition(); condition.Column = f; condition.ConditionOperator = ConditionOperator.IsEmpty; condition.FormatStyle.BackColor = Color.LightBlue; condition.TargetColumn = f; grid.RootTable.FormatConditions.Add(condition); } }); Data.Add(referee, dt); dt.RowChanged += dt_RowChanged; grid.RowHeaderContent = RowHeaderContent.RowPosition; grid.RowHeaders = InheritableBoolean.True; grid.EnsureVisible(1); } /* * var analizPage = new Janus.Windows.UI.Tab.UITabPage("Анализ") * { * * }; * * refereeTabs.TabPages.Add(analizPage); * var analiz = new StageResultCalculatorView() { Dock = DockStyle.Fill, Stage = Stage }; * analiz.Init(Stage.Competition); * analizPage.Controls.Add(analiz); */ }
private void FormatUserNhapChiDinh() { try { GridEXColumn gridExColumn = grdAssignDetail.RootTable.Columns[KcbChidinhclsChitiet.Columns.NguoiTao]; GridEXColumn gridExColumnTarget = grdAssignDetail.RootTable.Columns[DmucDichvuclsChitiet.Columns.TenChitietdichvu]; var gridExFormatCondition = new GridEXFormatCondition(gridExColumn, ConditionOperator.NotEqual, globalVariables.UserName); gridExFormatCondition.FormatStyle.BackColor = Color.Red; gridExFormatCondition.TargetColumn = gridExColumnTarget; grdAssignDetail.RootTable.FormatConditions.Add(gridExFormatCondition); } catch (Exception exception) { if (globalVariables.IsAdmin) { Utility.ShowMsg(exception.ToString()); } } }
public override void Init() { GameService.DbContext.GameResultValueSet.Where(f => f.GameResult.Game.StageId == Stage.Id).Load(); Data = new Dictionary <CompetitionReferee, DataTable>(); grid.RootTable = new GridEXTable(); var table = new DataTable(); var teamColumn = table.Columns.Add("Команда", typeof(string)); var teamZherColumn = table.Columns.Add("Жеребьевка", typeof(int)); var allReferee = GameService.DbContext.CompetitionRefereeSet.Where(f => f.CompetitionId == Stage.CompetitionId).ToList(); var mainReferee = allReferee.First(f => f.IsMainReferee); var referee = allReferee.Where(f => !f.IsMainReferee).ToList(); ColumnStructure = new Dictionary <DataColumn, ColumnInfo>(); var nonMainRefereeValues = GameService.GetValueTypes(Stage, referee.First()).ToList(); foreach (var valueType in nonMainRefereeValues) { for (int i = 0; i < referee.Count; i++) { var valColumn = table.Columns.Add(string.Format("{0}.{1}", (i + 1).ToString(), EnumHelper <GameValueType> .GetDisplayValue(valueType)), typeof(int)); ColumnStructure.Add(valColumn, new ColumnInfo() { Referee = referee[i], ValueType = valueType, Name = valColumn.Caption }); } } foreach (var valueType in GameService.GetValueTypes(Stage, mainReferee)) { var valColumn = table.Columns.Add(EnumHelper <GameValueType> .GetDisplayValue(valueType), typeof(int)); ColumnStructure.Add(valColumn, new ColumnInfo() { Referee = mainReferee, ValueType = valueType, Name = valColumn.Caption }); } var zhereb = GameService.DbContext.TeamCompetitionSet.Where(f => f.CompetitionId == GameService.Competition.Id).ToDictionary(f => f.TeamId, f => f.Order.Value); var refereeIds = allReferee.Select(f => f.Id).ToList(); foreach (var game in GameService.DbContext.GameSet.Where(f => f.StageId == Stage.Id)) { var row = table.NewRow(); row[teamColumn] = game.Team.Name; row[teamZherColumn] = zhereb[game.Team.Id]; foreach (var rs in GameService.DbContext.GameResultSet.Where(f => refereeIds.Contains(f.CompetitionRefereeId) && f.GameId == game.Id)) { foreach (var rsValue in rs.Values) { var col = ColumnStructure.First(f => f.Value.ValueType == rsValue.Type && f.Value.Referee.Id == rs.CompetitionRefereeId).Key; if (rsValue.Value.HasValue) { row[col] = rsValue.Value.Value; } } } table.Rows.Add(row); } grid.DataSource = table; grid.RetrieveStructure(); grid.RowHeaderContent = RowHeaderContent.RowPosition; grid.RowHeaders = InheritableBoolean.True; grid.EnsureVisible(1); grid.RootTable.Columns["Команда"].EditType = EditType.NoEdit; //grid.RootTable.SortKeys.Add(grid.RootTable.Columns["Команда"]).SortOrder = Janus.Windows.GridEX.SortOrder.Ascending; grid.RootTable.Columns["Жеребьевка"].EditType = EditType.NoEdit; grid.RootTable.SortKeys.Add(grid.RootTable.Columns["Жеребьевка"]).SortOrder = Janus.Windows.GridEX.SortOrder.Ascending; grid.RootTable.Columns["Жеребьевка"].TextAlignment = TextAlignment.Center; grid.Update(); grid.FrozenColumns = 1; grid.GroupByBoxVisible = false; foreach (var c in ColumnStructure) { var column = grid.RootTable.Columns.Cast <GridEXColumn>().First(f => f.DataMember == c.Value.Name); column.TextAlignment = TextAlignment.Center; var condition = new GridEXFormatCondition(); condition.Column = column; condition.ConditionOperator = ConditionOperator.IsEmpty; condition.FormatStyle.BackColor = Color.LightBlue; condition.TargetColumn = column; grid.RootTable.FormatConditions.Add(condition); } table.ColumnChanged += table_ColumnChanged; //foreach (var referee in GameService.DbContext.CompetitionRefereeSet.Where(f=>f.CompetitionId == content.CompetitionId)) //{ // var page = new Janus.Windows.UI.Tab.UITabPage(referee.IsMainReferee ? "Гл. судья" : "Судья №" + refereeIndex.ToString()) // { // Tag = referee // }; // if (!referee.IsMainReferee) refereeIndex++; // refereeTabs.TabPages.Add(page); // var grid = new GridEX() { Dock = DockStyle.Fill, Name = "gridReferee" }; // page.Controls.Add(grid); // var dt = GetTable(content, referee); // grid.DataSource = dt; // grid.RetrieveStructure(); // grid.RootTable.Columns["Команда"].EditType = EditType.NoEdit; // grid.RootTable.SortKeys.Add(grid.RootTable.Columns["Команда"]); // grid.GroupByBoxVisible = false; // grid.ColumnAutoSizeMode = ColumnAutoSizeMode.ColumnHeader; // grid.ColumnAutoResize = true; // Data.Add(referee, dt); // dt.RowChanged += dt_RowChanged; // grid.RowHeaderContent = RowHeaderContent.RowPosition; // grid.RowHeaders = InheritableBoolean.True; // grid.EnsureVisible(1); //} /* * var analizPage = new Janus.Windows.UI.Tab.UITabPage("Анализ") * { * * }; * * refereeTabs.TabPages.Add(analizPage); * var analiz = new StageResultCalculatorView() { Dock = DockStyle.Fill, Stage = Stage }; * analiz.Init(Stage.Competition); * analizPage.Controls.Add(analiz); */ }