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);
}
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);
}
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);
*/
}
