private void Form1_Load(object sender, EventArgs e)
{
gridControl1.DataSource = DataHelper.GetData(10);
// The grid automatically creates columns for the public fields found in the data source.
// Calling the gridView1.PopulateColumns method is not required unless the gridView1.OptionsBehavior.AutoPopulateColumns is disabled
// Create a ComboBox editor that shows available companies in the Company column
RepositoryItemComboBox riComboBox = new RepositoryItemComboBox();
riComboBox.Items.AddRange(DataHelper.companies);
gridControl1.RepositoryItems.Add(riComboBox);
gridView1.Columns["CompanyName"].ColumnEdit = riComboBox;
// Specify a different null value text presentation for the Image column
gridView1.Columns["Image"].RealColumnEdit.NullText = "[load image]";
//Highlight the RequiredDate cells that match a certain condition.
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleValue formatConditionRuleValue = new FormatConditionRuleValue();
gridFormatRule.Column = gridView1.Columns["RequiredDate"];
formatConditionRuleValue.PredefinedName = "Red Bold Text";
formatConditionRuleValue.Condition = FormatCondition.Greater;
formatConditionRuleValue.Value1 = DateTime.Today;
gridFormatRule.Rule = formatConditionRuleValue;
gridFormatRule.ApplyToRow = false;
gridView1.FormatRules.Add(gridFormatRule);
gridView1.BestFitColumns();
}
private void ProjeXUC_Load(object sender, EventArgs e)
{
prtTableAdapter.Fill(opsDataSet.PRT, "PRTID > 0", Program.USR);
prtGridControl.ExternalRepository = Program.MF.mainPersistentRepository;
colDRM.ColumnEdit = Program.MF.prtDrmRepositoryItemLookUpEdit;
colTUR.ColumnEdit = Program.MF.prtTurRepositoryItemLookUpEdit;
colTAGS.ColumnEdit = Program.MF.TAGselPRTrepositoryItemCheckedComboBoxEdit;
colYONETICI.ColumnEdit = Program.MF.USRrepositoryItemCheckedComboBoxEdit;
colSORUMLU.ColumnEdit = Program.MF.USRrepositoryItemCheckedComboBoxEdit;
//colAMAC.ColumnEdit = Program.MF.MemoExtRepositoryItemMemoExEdit;
//colACIKLAMA.ColumnEdit = Program.MF.MemoExtRepositoryItemMemoExEdit;
colEDITABLE.ColumnEdit = Program.MF.TFrepositoryItemCheckEdit;
Program.MF.GridControlSettings(prtGridControl);
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression();
gridFormatRule.Column = colBKMS;
gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.PredefinedName = "Bold Text"; // "Red Fill, Red Text";
formatConditionRuleExpression.Expression = string.Format("Contains([BKMS], '{0}')", Program.USRtag);
gridFormatRule.Rule = formatConditionRuleExpression;
prtGridView.FormatRules.Add(gridFormatRule);
prtTableAdapter.ClearBeforeFill = false;
}
private void PhanTich_Load(object sender, EventArgs e)
{
LoadThongTinChiTiet();
LayoutControlGroup newGroup = dataLayoutControl1.Root.AddGroup();
LayoutControlItem item1 = newGroup.AddItem();
gridControl = new GridControl();
gridControl.Dock = DockStyle.Fill;
gridControl.DataSource = getMarkDataWithID(MaHocVien);
item1.Control = gridControl;
GridView gridView1 = gridControl.MainView as GridView;
GridColumn colHocKy = gridView1.Columns["HocKy"];
GridColumn colNam = gridView1.Columns["Nam"];
GridColumn colDiem = gridView1.Columns["Diem"];
colNam.GroupIndex = 0;
colHocKy.GroupIndex = 1;
gridView1.ExpandAllGroups();
//Change Format Rule
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet();
FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet();
FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon();
//Choose predefined icons.
icon1.PredefinedName = "Rating4_1.png";
icon2.PredefinedName = "Rating4_2.png";
icon3.PredefinedName = "Rating4_3.png";
icon4.PredefinedName = "Rating4_4.png";
//Specify the type of threshold values.
iconSet.ValueType = FormatConditionValueType.Number;
//Define ranges to which icons are applied by setting threshold values.
icon1.Value = 8; // target range: 8 <= value
icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon2.Value = 7; // target range: 7 <= value < 8
icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon3.Value = 5; // target range: 5 <= value < 7
icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon4.Value = 0; // target range: 0 <= value < 5
icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
//Add icons to the icon set.
iconSet.Icons.Add(icon1);
iconSet.Icons.Add(icon2);
iconSet.Icons.Add(icon3);
iconSet.Icons.Add(icon4);
//Specify the rule type.
gridFormatRule.Rule = formatConditionRuleIconSet;
//Specify the column to which formatting is applied.
gridFormatRule.Column = colDiem;
//Add the formatting rule to the GridView.
gridView1.FormatRules.Add(gridFormatRule);
}
protected void ClearCustomFormatRules(GridView view)
{
GridFormatRule[] rules = new GridFormatRule[view.FormatRules.Count];
view.FormatRules.CopyTo(rules, 0);
foreach (GridFormatRule rule in rules)
{
if (rule.Tag != null)
{
view.FormatRules.Remove(rule);
}
}
}
private GridFormatRule CreateRule(GridColumn column, double value, bool greater)
{
GridFormatRule rule = new GridFormatRule();
FormatConditionRuleValue cond = new FormatConditionRuleValue();
cond.PredefinedName = greater ? "Green Bold Text" : "Red Bold Text";
cond.Condition = greater ? FormatCondition.GreaterOrEqual : FormatCondition.Less;
cond.Value1 = value;
rule.Tag = new object();
rule.Name = column.FieldName + (greater ? "Greater" : "Less");
rule.Column = column;
rule.ColumnApplyTo = column;
rule.Rule = cond;
return(rule);
}
public void GenerateFormatRuleByValue(GridView gridView, GridColumn column, object value, FormatCondition condition, Color backColor, Color fontColor)
{
GridFormatRule gridFormatRule = new GridFormatRule();
gridFormatRule.Column = column;
gridFormatRule.ApplyToRow = true;
FormatConditionRuleValue formatConditionRuleValue = new FormatConditionRuleValue();
formatConditionRuleValue.PredefinedName = value.ToString();
formatConditionRuleValue.Condition = condition;
formatConditionRuleValue.Value1 = value.ToString();
formatConditionRuleValue.Appearance.BackColor = backColor;
formatConditionRuleValue.Appearance.ForeColor = fontColor;
formatConditionRuleValue.Appearance.Options.UseBackColor = true;
formatConditionRuleValue.Appearance.Options.UseForeColor = true;
gridFormatRule.Rule = formatConditionRuleValue;
gridView.FormatRules.Add(gridFormatRule);
}
private GridFormatRule CreateRule(GridColumn column, SocketConnectionState state, Color color)
{
GridFormatRule rule = new GridFormatRule();
FormatConditionRuleValue cond = new FormatConditionRuleValue();
cond.Appearance.FontStyleDelta = FontStyle.Bold;
cond.Appearance.ForeColor = color;
cond.Appearance.Font = this.gvConnections.Appearance.Row.Font;
cond.Condition = FormatCondition.Equal;
cond.Value1 = state;
rule.Tag = new object();
rule.Name = "fmt" + state.ToString();
rule.Column = column;
rule.ColumnApplyTo = column;
rule.Rule = cond;
return(rule);
}
private GridFormatRule CreateRule(GridColumn column, bool value, Color foreColor, Color backColor)
{
GridFormatRule rule = new GridFormatRule();
FormatConditionRuleValue cond = new FormatConditionRuleValue();
cond.Appearance.ForeColor = foreColor;
cond.Appearance.BackColor = backColor;
cond.Condition = FormatCondition.Equal;
cond.Value1 = value;
rule.Tag = new object();
rule.Name = column.FieldName + "Equal" + rule.GetHashCode();
rule.Column = column;
rule.ApplyToRow = true;
rule.ColumnApplyTo = column;
rule.Rule = cond;
return(rule);
}
/// <summary>
/// 设定列表显示效果
/// </summary>
private void SetGridViewAppearance()
{
GridFormatRule gFRule1 = new GridFormatRule();
FormatConditionRuleExpression fCondRuleExp1 = new FormatConditionRuleExpression();
//gFRule1.Column = colPlanDays;
gFRule1.ApplyToRow = true;
fCondRuleExp1.Appearance.ForeColor = ZeroBelow;
fCondRuleExp1.Expression = "[PlanDays] < 0";
gFRule1.Rule = fCondRuleExp1;
gridViewOrderList.FormatRules.Add(gFRule1);
GridFormatRule gFRule2 = new GridFormatRule();
FormatConditionRuleExpression fCondRuleExp2 = new FormatConditionRuleExpression();
//gFRule2.Column = colPlanDays;
gFRule2.ApplyToRow = true;
fCondRuleExp2.Appearance.ForeColor = NearZero;
fCondRuleExp2.Expression = string.Format("[PlanDays] <= {0} And [PlanDays] >= 0", SystemInfo.OrderNoWarehousing_Days);
gFRule2.Rule = fCondRuleExp2;
gridViewOrderList.FormatRules.Add(gFRule2);
}
private void InitializeGrid()
{
this.gridControl1.UseEmbeddedNavigator = true;
this.gridView1.OptionsView.ShowGroupPanel = false;
this.gridView1.OptionsView.NewItemRowPosition = NewItemRowPosition.Top;
this.gridView1.OptionsFilter.UseNewCustomFilterDialog = true;
this.gridView1.OptionsView.ShowAutoFilterRow = false;
//this.gridView1.OptionsFind.AlwaysVisible = true;
//this.gridView1.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.ShowAlways;
this.gridView1.OptionsMenu.ShowConditionalFormattingItem = true;
//this.gridView1.OptionsView.ShowPreview = true;
{
GridFormatRule gridFormatRule = new GridFormatRule( );
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression( );
gridFormatRule.Column = this._colStagePathDir;
//gridFormatRule.ColumnApplyTo = this._colStagePathDir;
gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.PredefinedName = "Yellow Fill, Yellow Text";
formatConditionRuleExpression.Expression = "[" + DataStore.StagePathDir_FldName + "] == '" + this.dsCfg.DefaultStgDirVal + "'";
gridFormatRule.Rule = formatConditionRuleExpression;
this.gridView1.FormatRules.Add(gridFormatRule);
}
this.Load += new System.EventHandler(this.XtraUserControl_Load);
}
private void dtfill(DataTable dt)
{
gridControl1.Refresh();
gridControl1.DataSource = datos;
gridView1.Columns[4].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[4].DisplayFormat.FormatString = "c2";
gridView1.Columns[5].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[5].DisplayFormat.FormatString = "c2";
gridView1.Columns[6].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[6].DisplayFormat.FormatString = "c2";
gridView1.Columns[7].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[7].DisplayFormat.FormatString = "c2";
gridView1.Columns[8].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[8].DisplayFormat.FormatString = "c2";
gridView1.Columns[9].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[9].DisplayFormat.FormatString = "c2";
gridView1.Columns[10].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[10].DisplayFormat.FormatString = "c2";
gridView1.Columns[11].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[11].DisplayFormat.FormatString = "c2";
gridView1.Columns[12].DisplayFormat.FormatType = FormatType.Numeric;
gridView1.Columns[12].DisplayFormat.FormatString = "c2";
gridView1.Columns[13].DisplayFormat.FormatType = FormatType.Numeric;
// gridView1.Columns[13].DisplayFormat.FormatString = "P";
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet();
FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet();
FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon5 = new FormatConditionIconSetIcon();
//Choose predefined icons.
icon1.PredefinedName = "Arrows5_1.png";
icon2.PredefinedName = "Arrows5_2.png";
icon3.PredefinedName = "Arrows5_3.png";
icon4.PredefinedName = "Arrows5_4.png";
icon5.PredefinedName = "Arrows5_5.png";
//Specify the type of threshold values.
iconSet.ValueType = FormatConditionValueType.Number;
//Define ranges to which icons are applied by setting threshold values.
icon1.Value = 90; // target range: 67% <= value
icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon2.Value = 70; // target range: 33% <= value < 67%
icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon3.Value = 50; // target range: 0% <= value < 33%
icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon4.Value = 25; // target range: 0% <= value < 33%
icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon5.Value = 0; // target range: 0% <= value < 33%
icon5.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
//Add icons to the icon set.
iconSet.Icons.Add(icon1);
iconSet.Icons.Add(icon2);
iconSet.Icons.Add(icon3);
iconSet.Icons.Add(icon4);
iconSet.Icons.Add(icon5);
//Specify the rule type.
gridFormatRule.Rule = formatConditionRuleIconSet;
//Specify the column to which formatting is applied.
gridFormatRule.Column = gridView1.Columns["ALCANCE"];
//Add the formatting rule to the GridView.
gridView1.FormatRules.Add(gridFormatRule);
groupBox3.Hide();
button2.Enabled = true;
}
private void FaturaXF_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
if (AFBid != 0)
{
sb.Append(string.Format("AFBid = {0}", AFBid));
}
else if (RefAfbID != 0)
{
sb.Append(string.Format("RefAfbID = {0}", RefAfbID));
}
else if (FRTid != 0)
{
sb.Append(string.Format("FRTid = {0}", FRTid));
}
else if (OPid != 0)
{
sb.Append(string.Format("OPid = {0}", OPid));
}
else
{
sb.Append(string.Format(" "));
}
this.afbTableAdapter.ClearBeforeFill = true;
this.afbTableAdapter.Fill(this.accountDataSet.AFB, sb.ToString(), Program.USR);
this.afbTableAdapter.ClearBeforeFill = false;
Program.MF.GridControlSettings(afbGridControl);
afbGridView.ShowingEditor += afbGridView_ShowingEditor;
afbGridControl.ExternalRepository = Program.MF.mainPersistentRepository;
colFRTID.ColumnEdit = Program.MF.FRTrepositoryItemLookUpEdit;
colDKNFRTID.ColumnEdit = Program.MF.FRTrepositoryItemLookUpEdit;
colDKNDVZ.ColumnEdit = Program.MF.DVTrepositoryItemLookUpEdit;
colBDVZ.ColumnEdit = Program.MF.DVTrepositoryItemLookUpEdit;
colTUR.ColumnEdit = Program.MF.afbTurRepositoryItemLookUpEdit;
colTUR2.ColumnEdit = Program.MF.afbTUR2repositoryItemImageComboBox;
colTUR3.ColumnEdit = Program.MF.afbTUR3repositoryItemImageComboBox;
colTAGS.ColumnEdit = Program.MF.TAGselAFBrepositoryItemCheckedComboBoxEdit;
colHSPNO.ColumnEdit = Program.MF.AHPHspAdNoRepositoryItemLookUpEdit;
colDRM.ColumnEdit = Program.MF.AFBdrmRepositoryItemImageComboBox;
colEDITABLE.ColumnEdit = Program.MF.TFrepositoryItemCheckEdit;
compBA.ColumnEdit = Program.MF.BArepositoryItemImageComboBox;
colEMLD.ColumnEdit = Program.MF.TFrepositoryItemCheckEdit;
Program.MF.DVTrepositoryItemLookUpEdit.Closed += DVTrepositoryItemLookUpEdit_Closed;
Qry.qsvAfbXUC frm = new Qry.qsvAfbXUC();
frm.AFB = accountDataSet.AFB;
frm.Dock = DockStyle.Fill;
qsDockPanel.Controls.Add(frm);
//afbGridView.FormatConditions[0].Expression = string.Format("Contains([BKMS], '{0}')", Program.USRtag);
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression();
gridFormatRule.Column = colBKMS;
gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.PredefinedName = "Bold Text"; // "Red Fill, Red Text";
formatConditionRuleExpression.Expression = string.Format("Contains([BKMS], '{0}')", Program.USRtag);
gridFormatRule.Rule = formatConditionRuleExpression;
afbGridView.FormatRules.Add(gridFormatRule);
Program.MF.XGLrestore(layoutName, 0, afbGridView);
afbGridView.OptionsBehavior.Editable = Program.MF.ModifyCheck("Account.FaturaXF", true);
}
void InitGridControlCadet(string maLop)
{
string query = "";
if (maLop == null)
{
query = "EXEC dbo.LayThongTinDiemCacKiCuaHocVien";
}
else
{
query = string.Format("EXECUTE dbo.LayThongTinDiemCacKiCuaHocVienTheoLop {0}", maLop);
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(query, connection);
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable table = new DataTable();
adapter.Fill(table);
gridControlCadet.DataSource = table;
GridColumn colID = gridViewCadet.Columns["HocVienID"];
GridColumn colName = gridViewCadet.Columns["TenHocVien"];
GridColumn colQue = gridViewCadet.Columns["QueQuan"];
GridColumn colNgaySinh = gridViewCadet.Columns["NgaySinh"];
GridColumn colTenLop = gridViewCadet.Columns["TenLop"];
GridColumn colHocKy = gridViewCadet.Columns["HocKy"];
GridColumn colHocKyId = gridViewCadet.Columns["HocKyID"];
GridColumn colNamHocId = gridViewCadet.Columns["NamHocID"];
GridColumn colTongKet = gridViewCadet.Columns["TongKet"];
GridColumn colNam = gridViewCadet.Columns["Nam"];
GridColumn colDuongDanAnh = gridViewCadet.Columns["DuongDanAnh"];
GridColumn colTangTruong = gridViewCadet.Columns["TangTruong"];
colID.Visible = false;
colHocKyId.Visible = false;
colNamHocId.Visible = false;
colDuongDanAnh.Visible = false;
colName.Caption = "Tên Học Viên";
colQue.Caption = "Quê Quán";
colNgaySinh.Caption = "Ngày Sinh";
colTenLop.Caption = "Lớp";
colHocKy.Caption = "Học Kì";
colTongKet.Caption = "Điểm Tổng Kết Kì";
colNam.Caption = "Năm Học";
colNam.GroupIndex = 0;
colHocKy.GroupIndex = 1;
colNgaySinh.Summary.Clear();
colNgaySinh.Summary.Add(SummaryItemType.Count, colNgaySinh.FieldName, "Tổng Số : {0}");
colNgaySinh.Summary.Add(SummaryItemType.Max, colNgaySinh.FieldName, "Độ Tuổi : <= {0:d}");
gridViewCadet.OptionsView.ShowFooter = true;
gridViewCadet.FindPanelVisible = true;
gridViewCadet.OptionsFind.HighlightFindResults = true;
//Change Format Rule
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet();
FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet();
FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon();
//Choose predefined icons.
icon1.PredefinedName = "Arrows3_1.png";
icon2.PredefinedName = "Arrows3_2.png";
icon3.PredefinedName = "Arrows3_3.png";
//Specify the type of threshold values.
iconSet.ValueType = FormatConditionValueType.Number;
//Define ranges to which icons are applied by setting threshold values.
icon1.Value = 30; // target range: 30% <= value
icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon2.Value = 10; // target range: 10% <= value < 30%
icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon3.Value = -100; // target range: -100% <= value < 10%
icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
//Add icons to the icon set.
iconSet.Icons.Add(icon1);
iconSet.Icons.Add(icon2);
iconSet.Icons.Add(icon3);
//Specify the rule type.
gridFormatRule.Rule = formatConditionRuleIconSet;
//Specify the column to which formatting is applied.
gridFormatRule.Column = colTangTruong;
//Add the formatting rule to the GridView.
gridViewCadet.FormatRules.Add(gridFormatRule);
gridViewCadet.ExpandAllGroups();
}
}
}
private void BindingData(string ARG_PROCESS, string ARG_LINE, string ARG_MLINE)
{
DataTable dt = SEL_MULTI_SKILL_V2("Q", ARG_PROCESS, ARG_LINE, ARG_MLINE);
gridView1.Columns.Clear();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
dt.Columns[i].ColumnName = dt.Columns[i].ColumnName.Replace("'", "").Replace("_", " ");
}
gridControl1.DataSource = dt;
//format Condition
for (int i = 2; i < gridView1.Columns.Count; i++)
{
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleIconSet formatConditionRuleIconSet = new FormatConditionRuleIconSet();
FormatConditionIconSet iconSet = formatConditionRuleIconSet.IconSet = new FormatConditionIconSet();
FormatConditionIconSetIcon icon1 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon2 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon3 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon4 = new FormatConditionIconSetIcon();
FormatConditionIconSetIcon icon5 = new FormatConditionIconSetIcon();
//Choose predefined icons.
icon1.PredefinedName = "Quarters5_1.png";
icon2.PredefinedName = "Quarters5_2.png";
icon3.PredefinedName = "Quarters5_3.png";
icon4.PredefinedName = "Quarters5_4.png";
icon5.PredefinedName = "Quarters5_5.png";
//Specify the type of threshold values.
iconSet.ValueType = FormatConditionValueType.Automatic;
//Define ranges to which icons are applied by setting threshold values.
icon1.Value = 100; // target range: 100% <= value
icon1.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon2.Value = 75; // target range: 50% <= value < 75%
icon2.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon3.Value = 50; // target range: 25% <= value < 50%
icon3.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon4.Value = 25; // target range: 0% <= value < 25%
icon4.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
icon5.Value = 0; // target range: 0% <= value < 33%
icon5.ValueComparison = FormatConditionComparisonType.GreaterOrEqual;
//Add icons to the icon set.
iconSet.Icons.Add(icon1);
iconSet.Icons.Add(icon2);
iconSet.Icons.Add(icon3);
iconSet.Icons.Add(icon4);
iconSet.Icons.Add(icon5);
//Specify the rule type.
gridFormatRule.Rule = formatConditionRuleIconSet;
//Specify the column to which formatting is applied.
gridFormatRule.Column = gridView1.Columns[i];
//Add the formatting rule to the GridView.
gridView1.FormatRules.Add(gridFormatRule);
gridView1.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridView1.Columns[i].AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
gridView1.Columns[i].OptionsColumn.AllowEdit = false;
}
gridView1.BestFitColumns();
gridView1.OptionsView.ColumnAutoWidth = false;
}
else
{
gridControl1.Hide();
}
// gridControl1.EndUpdate();
}
public static void LoadGridData(GridView viewTable, GridData data)
{
using (new UsingProcessor(() => viewTable.BeginUpdate(), () => viewTable.EndUpdate()))
{
viewTable.GridControl.ForceInitialize();
if (data.Parameters != null)
{
var gridProperties = new GridProperties((GridView)viewTable);
gridProperties.ApplyParameters(data.Parameters);
}
if (data.ColumnOrder != null && data.ColumnOrder.Count > 0)
{
var visibleColumns = new List <GridColumn>();
bool hasSummaries = false;
int i = 0;
foreach (var field in data.ColumnOrder)
{
if (string.IsNullOrWhiteSpace(field.ColumnName))
{
continue;
}
var column = viewTable.Columns.ColumnByFieldName(field.ColumnName);
if (column != null)
{
column.Visible = true;
column.VisibleIndex = i++;
visibleColumns.Add(column);
column.Summary.Clear();
if (!string.IsNullOrWhiteSpace(field.Summary))
{
var summaries = Utils.SplitString(field.Summary, ',');
foreach (var summary in summaries)
{
if (Enum.TryParse <SummaryItemType>(summary, out SummaryItemType summaryType))
{
column.Summary.Add(summaryType);
hasSummaries = true;
}
}
}
}
}
if (hasSummaries)
{
viewTable.OptionsView.ShowFooter = true;
}
}
using (new UsingProcessor(() => viewTable.BeginSort(), () => viewTable.EndSort()))
{
viewTable.ClearGrouping();
viewTable.ClearSorting();
var sortInfos = new List <GridColumnSortInfo>();
int groupColumnCount = 0;
if (data.GroupBy != null && data.GroupBy.Count > 0)
{
foreach (var group in data.GroupBy)
{
if (string.IsNullOrWhiteSpace(group.ColumnName))
{
continue;
}
var sortAscending = true;
var colName = group.ColumnName;
if (string.Compare(group.SortOrder, "desc", true) == 0)
{
sortAscending = false;
}
var column = viewTable.Columns.ColumnByFieldName(colName);
if (column != null)
{
var colSortInfo = new GridColumnSortInfo(column, sortAscending ? ColumnSortOrder.Ascending : ColumnSortOrder.Descending);
sortInfos.Add(colSortInfo);
groupColumnCount++;
}
}
}
if (data.OrderBy != null && data.OrderBy.Count > 0)
{
foreach (var orderBy in data.OrderBy)
{
if (string.IsNullOrWhiteSpace(orderBy.ColumnName))
{
continue;
}
var sortAscending = true;
var colName = orderBy.ColumnName;
if (string.Compare(orderBy.SortOrder, "desc", true) == 0)
{
sortAscending = false;
}
var column = viewTable.Columns.ColumnByFieldName(colName);
if (column != null)
{
var colSortInfo = new GridColumnSortInfo(column, sortAscending ? ColumnSortOrder.Ascending : ColumnSortOrder.Descending);
sortInfos.Add(colSortInfo);
}
}
}
viewTable.SortInfo.ClearAndAddRange(sortInfos.ToArray(), groupColumnCount);
}
if (data.FormatConditions != null && data.FormatConditions.Count > 0)
{
viewTable.FormatConditions.Clear();
foreach (var formatCondition in data.FormatConditions)
{
GridColumn column = null, targetColumn = null;
if (!string.IsNullOrWhiteSpace(formatCondition.ColumnName))
{
column = viewTable.Columns.ColumnByFieldName(formatCondition.ColumnName);
}
if (!string.IsNullOrWhiteSpace(formatCondition.TargetColumn))
{
targetColumn = viewTable.Columns.ColumnByFieldName(formatCondition.TargetColumn);
}
var formatRule = Utils.NonNullString(formatCondition.FormatRule).ToLower();
switch (formatRule)
{
case "expression":
var expression = formatCondition.Expression;
if (!string.IsNullOrWhiteSpace(expression))
{
var formatExpression = new FormatConditionRuleExpression()
{
Expression = expression
};
var ruleExpression = new GridFormatRule
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = (column == null) || formatCondition.ApplyToRow,
Rule = formatExpression
};
ApplyFormatting(formatExpression, formatCondition);
viewTable.FormatRules.Add(ruleExpression);
}
break;
case "databar":
if (column != null)
{
var ruleDataBar = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatDataBar = new FormatConditionRuleDataBar();
if (string.IsNullOrWhiteSpace(formatCondition.BackColor))
{
formatCondition.BackColor = formatCondition.DataBar;
}
if (!string.IsNullOrWhiteSpace(formatCondition.AppearanceName))
{
formatDataBar.PredefinedName = formatCondition.AppearanceName;
}
else
{
ApplyAppearance(formatDataBar.Appearance, formatCondition);
}
ruleDataBar.Rule = formatDataBar;
viewTable.FormatRules.Add(ruleDataBar);
}
break;
case "iconset":
if (column != null)
{
if (!Enum.TryParse(formatCondition.IconSet, out IconSetType iconSetType))
{
iconSetType = IconSetType.Arrows5;
}
var ruleIconSet = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatIconSet = new FormatConditionRuleIconSet()
{
IconSet = GetPredefinedIconSet(iconSetType)
};
ruleIconSet.Rule = formatIconSet;
viewTable.FormatRules.Add(ruleIconSet);
}
break;
case "colorscale":
if (column != null)
{
string colorScale = formatCondition.ColorScale;
if (string.IsNullOrWhiteSpace(colorScale))
{
colorScale = "White,Red";
}
if (!string.IsNullOrWhiteSpace(colorScale))
{
var scales = colorScale.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (scales != null && scales.Length == 2)
{
var ruleColorScale2 = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatColorScale2 = new FormatConditionRule2ColorScale
{
MinimumColor = ColorExtensions.FromHtmlColor(scales[0], Color.White),
MaximumColor = ColorExtensions.FromHtmlColor(scales[1], Color.Black)
};
ruleColorScale2.Rule = formatColorScale2;
viewTable.FormatRules.Add(ruleColorScale2);
}
else if (scales != null && scales.Length >= 3) //Use first 3 colors if more are specified
{
var ruleColorScale3 = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatColorScale3 = new FormatConditionRule3ColorScale
{
MinimumColor = ColorExtensions.FromHtmlColor(scales[0], Color.White),
MiddleColor = ColorExtensions.FromHtmlColor(scales[1], Color.Gray),
MaximumColor = ColorExtensions.FromHtmlColor(scales[2], Color.Black)
};
ruleColorScale3.Rule = formatColorScale3;
viewTable.FormatRules.Add(ruleColorScale3);
}
}
}
break;
case "aboveaverage":
if (column != null)
{
var ruleAboveAverage = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatAboveAverage = new FormatConditionRuleAboveBelowAverage()
{
AverageType = FormatConditionAboveBelowType.Above
};
ApplyFormatting(formatAboveAverage, formatCondition);
ruleAboveAverage.Rule = formatAboveAverage;
viewTable.FormatRules.Add(ruleAboveAverage);
}
break;
case "belowaverage":
if (column != null)
{
var ruleBelowAverage = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatBelowAverage = new FormatConditionRuleAboveBelowAverage()
{
AverageType = FormatConditionAboveBelowType.Below
};
ApplyFormatting(formatBelowAverage, formatCondition);
ruleBelowAverage.Rule = formatBelowAverage;
viewTable.FormatRules.Add(ruleBelowAverage);
}
break;
case "aboveorequalaverage":
if (column != null)
{
var ruleAboveAverage = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatAboveAverage = new FormatConditionRuleAboveBelowAverage()
{
AverageType = FormatConditionAboveBelowType.EqualOrAbove
};
ApplyFormatting(formatAboveAverage, formatCondition);
ruleAboveAverage.Rule = formatAboveAverage;
viewTable.FormatRules.Add(ruleAboveAverage);
}
break;
case "beloworequalaverage":
if (column != null)
{
var ruleBelowAverage = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatBelowAverage = new FormatConditionRuleAboveBelowAverage()
{
AverageType = FormatConditionAboveBelowType.EqualOrBelow
};
ApplyFormatting(formatBelowAverage, formatCondition);
ruleBelowAverage.Rule = formatBelowAverage;
viewTable.FormatRules.Add(ruleBelowAverage);
}
break;
case "unique":
if (column != null)
{
var ruleUnique = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatUnique = new FormatConditionRuleUniqueDuplicate()
{
FormatType = FormatConditionUniqueDuplicateType.Unique
};
ApplyFormatting(formatUnique, formatCondition);
ruleUnique.Rule = formatUnique;
viewTable.FormatRules.Add(ruleUnique);
}
break;
case "duplicate":
if (column != null)
{
var ruleDuplicate = new GridFormatRule()
{
Column = column,
ColumnApplyTo = targetColumn,
ApplyToRow = formatCondition.ApplyToRow
};
var formatDuplicate = new FormatConditionRuleUniqueDuplicate()
{
FormatType = FormatConditionUniqueDuplicateType.Unique
};
ApplyFormatting(formatDuplicate, formatCondition);
ruleDuplicate.Rule = formatDuplicate;
viewTable.FormatRules.Add(ruleDuplicate);
}
break;
case "top":
if (column != null)
{
var rankTop = formatCondition.Rank;
var isPercent = !string.IsNullOrWhiteSpace(rankTop) && rankTop.EndsWith("%");
var strRankTop = isPercent ? rankTop[0..^ 1].TrimEnd() : rankTop;
private void Init()
{
GridFormatRule gridFormatRule = new GridFormatRule();
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression();
gridFormatRule.Column = this.gridView1.Columns["cftype"];
// gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.Appearance.BackColor = Color.LightGreen;
formatConditionRuleExpression.Expression = "[cftype]='儿科'";
gridFormatRule.Rule = formatConditionRuleExpression;
gridView1.FormatRules.Add(gridFormatRule);
this.gridView1.CustomDrawCell += (a, b) =>
{
if (b.Column.FieldName == "cftype")
{
string val = b.CellValue.ToString();
if (val == "精二")
{
b.Appearance.BackColor = Color.DarkRed;
b.Appearance.ForeColor = Color.White;
b.Appearance.Font = new Font("宋体", 12, FontStyle.Bold);
}
else if (val == "儿科")
{
b.Appearance.BackColor = Color.Green;
b.Appearance.ForeColor = Color.White;
b.Appearance.Font = new Font("宋体", 12, FontStyle.Bold);
}
}
};
this.gridView3.FormatRules.AddDataBar(this.gridView3.Columns["TotalPrice"]);
this.gridView1.MasterRowGetRelationCount += (x, y) =>
{
y.RelationCount = 1;
};
this.gridView1.MasterRowGetChildList += (sender, e) =>
{
GridView gv = sender as GridView;
gv.DetailTabHeaderLocation = DevExpress.XtraTab.TabHeaderLocation.Top;
string opertime = (gv.GetRow(e.RowHandle) as Cfhead).opertime;
//string sqlstr = $"SELECT gid 组号,drug 药品名称,spci 规格,unitprice 单价,CONCAT('Sig：',yongliang,danwei,' ',yongfa,' ',cishu) 用法,Concat(round(quantity),unit) 数量 FROM cfdetail where opertime = '{opertime}'";
//e.ChildList = SqlHelper.ExecuteTable(sqlstr).DefaultView;
// DataTable dt = mvvmContext.GetViewModel<FyFormViewModel>().GetChild(opertime);
e.ChildList = mvvmContext.GetViewModel <FyFormViewModel>().GetChild(opertime);
};
this.gridView1.MasterRowGetRelationName += (x, y) =>
{
y.RelationName = "处方明细";
};
this.gridView1.MasterRowGetLevelDefaultView += (x, y) =>
{
y.DefaultView = this.gridView2;
};
gridView1.IndicatorWidth = gridView3.IndicatorWidth = 25;
this.gridView1.CustomDrawRowIndicator += (sender, e) =>
{
GridView view = (GridView)sender;
//Check whether the indicator cell belongs to a data row
if (e.Info.IsRowIndicator && e.RowHandle >= 0)
{
e.Info.DisplayText = (e.RowHandle + 1).ToString();
e.Info.Appearance.BackColor = Color.Azure;
e.Info.Appearance.ForeColor = Color.Silver;
e.Info.Appearance.Font = new Font("楷体", 12, FontStyle.Regular);
}
};
this.gridView3.CustomDrawRowIndicator += (sender, e) =>
{
GridView view = (GridView)sender;
//Check whether the indicator cell belongs to a data row
if (e.Info.IsRowIndicator && e.RowHandle >= 0)
{
e.Info.DisplayText = (e.RowHandle + 1).ToString();
e.Info.Appearance.BackColor = Color.Silver;
e.Info.Appearance.ForeColor = Color.Silver;
e.Info.Appearance.Font = new Font("楷体", 12, FontStyle.Regular);
}
};
}
public MessageXuc()
{
this.InitializeComponent( );
this.gridControl1.DataSource = this.ds;
this.gridControl1.DataMember = INFO_TABLENAME;
{
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit( );
{
{
GridColumn gc = this.gridView1.Columns[TIMESTAMP_COLUMNNAME];
gc.DisplayFormat.FormatString = "yyyy/MM/dd-HH:mm:ss,fffffffzzz";
gc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
gc.SortMode = DevExpress.XtraGrid.ColumnSortMode.Value;
gc.MaxWidth = gc.MinWidth = gc.Width = 220;
gc.SortMode = ColumnSortMode.DisplayText;
gc.SortOrder = DevExpress.Data.ColumnSortOrder.Descending;
}
{
GridColumn gc = this.gridView1.Columns[CODE_COLUMNNAME];
gc.MaxWidth = gc.MinWidth = gc.Width = 60;
}
{
GridColumn gc = this.gridView1.Columns[TYPE_COLUMNNAME];
gc.MaxWidth = gc.MinWidth = gc.Width = 50;
}
this.gridView1.BestFitColumns(true);
}
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit( );
}
{
this.gridControl1.UseEmbeddedNavigator = true;
this.gridView1.OptionsBehavior.ReadOnly = true;
this.gridView1.OptionsView.ShowGroupPanel = false;
this.gridView1.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
this.gridView1.OptionsFilter.UseNewCustomFilterDialog = true;
this.gridView1.OptionsView.ShowAutoFilterRow = false;
// this.gridView1.OptionsFind.AlwaysVisible = true;
// this.gridView1.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.ShowAlways;
this.gridView1.OptionsMenu.ShowConditionalFormattingItem = true;
//
this.typeGridCol = this.gridView1.Columns[TYPE_COLUMNNAME];
//
{
GridFormatRule gridFormatRule = new GridFormatRule( );
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression( );
gridFormatRule.Column = this.typeGridCol;
//gridFormatRule.ColumnApplyTo = this._colStagePathDir;
gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.PredefinedName = "Red Fill, Red Text";
formatConditionRuleExpression.Expression = $"[{CODE_COLUMNNAME}] <= " + (int)MessageCode.Error;
gridFormatRule.Rule = formatConditionRuleExpression;
this.gridView1.FormatRules.Add(gridFormatRule);
}
{
GridFormatRule gridFormatRule = new GridFormatRule( );
FormatConditionRuleExpression formatConditionRuleExpression = new FormatConditionRuleExpression( );
gridFormatRule.Column = this.typeGridCol;
//gridFormatRule.ColumnApplyTo = this._colStagePathDir;
gridFormatRule.ApplyToRow = true;
formatConditionRuleExpression.PredefinedName = "Yellow Fill, Yellow Text";
formatConditionRuleExpression.Expression = $"[{CODE_COLUMNNAME}] >= " + (int)MessageCode.Warn;
gridFormatRule.Rule = formatConditionRuleExpression;
this.gridView1.FormatRules.Add(gridFormatRule);
}
}
}
