コード例 #1
0
        public static StyleFormatCondition CreateStyleFormatCondition(FormatCondition conditionSetting)
        {
            StyleFormatCondition condition = new StyleFormatCondition();
            var fontStyle = FontStyle.Regular;

            if (conditionSetting.Underline)
            {
                fontStyle |= FontStyle.Underline;
            }
            if (conditionSetting.Italic)
            {
                fontStyle |= FontStyle.Italic;
            }
            if (conditionSetting.Bold)
            {
                fontStyle |= FontStyle.Bold;
            }
            FontFamily fontFamily = new FontFamily(conditionSetting.FontName);

            System.Drawing.Font font = new Font(fontFamily, float.Parse(conditionSetting.Size), fontStyle);
            condition.Appearance.Font                 = font;
            condition.Condition                       = FormatConditionEnum.Expression;
            condition.Expression                      = conditionSetting.Conditions;
            condition.Appearance.BackColor            = conditionSetting.Backcolor;
            condition.Appearance.ForeColor            = conditionSetting.Forecolor;
            condition.Appearance.Options.UseFont      = true;
            condition.Appearance.Options.UseForeColor = true;
            condition.Appearance.Options.UseBackColor = true;
            return(condition);
        }
コード例 #2
0
ファイル: FrmPathWay.cs プロジェクト: Wooyme/HIS-1
        /// <summary>
        /// 加入显示颜色等效果
        /// </summary>
        private void ConditionsAdjustment()
        {
            StyleFormatCondition cn;


            cn                 = new StyleFormatCondition(FormatConditionEnum.Equal, gridView1.Columns["PATHWAY_STATUS"], null, 0);
            cn.ApplyToRow      = true;
            cn.Appearance.Font = new Font(AppearanceObject.DefaultFont, FontStyle.Strikeout);
            //cn.Appearance.Font = new Font(AppearanceObject.DefaultFont, FontStyle.Bold);
            cn.Appearance.ForeColor = SystemColors.ButtonFace;//删除
            gridView1.FormatConditions.Add(cn);

            cn                      = new StyleFormatCondition(FormatConditionEnum.Equal, gridView1.Columns["isInvalid"], null, 31);
            cn.ApplyToRow           = true;
            cn.Appearance.Font      = new Font(AppearanceObject.DefaultFont, FontStyle.Strikeout);
            cn.Appearance.ForeColor = SystemColors.ControlDarkDark;//作废
            gridView1.FormatConditions.Add(cn);


            cn                      = new StyleFormatCondition(FormatConditionEnum.Equal, gridView1.Columns["isInvalid"], null, 21);
            cn.ApplyToRow           = true;
            cn.Appearance.Font      = new Font(AppearanceObject.DefaultFont, FontStyle.Bold);
            cn.Appearance.ForeColor = SystemColors.WindowText;//发布
            gridView1.FormatConditions.Add(cn);

            cn                      = new StyleFormatCondition(FormatConditionEnum.Equal, gridView1.Columns["isInvalid"], null, 1);
            cn.ApplyToRow           = true;
            cn.Appearance.Font      = new Font(AppearanceObject.DefaultFont, FontStyle.Regular);
            cn.Appearance.ForeColor = Color.Blue;//未审核
            gridView1.FormatConditions.Add(cn);



            //gridView1.BestFitColumns();
        }
コード例 #3
0
        private void ConditionsColumnView(GridControl grd)
        {
            try
            {
                StyleFormatCondition[] cnArr = new StyleFormatCondition[2];

                cnArr[0]                                 = new StyleFormatCondition(FormatConditionEnum.Expression);
                cnArr[0].Column                          = ((ColumnView)grd.MainView).Columns["PENDING_QTY"];
                cnArr[0].Expression                      = @"[PENDING_QTY] > 0";
                cnArr[0].Appearance.ForeColor            = Color.Red;
                cnArr[0].Appearance.Options.UseBackColor = true;
                cnArr[0].Appearance.Options.UseForeColor = true;
                cnArr[0].ApplyToRow                      = false;

                cnArr[1]                      = new StyleFormatCondition(FormatConditionEnum.Expression);
                cnArr[1].Column               = ((ColumnView)grd.MainView).Columns["PENDING_BOX"];
                cnArr[1].Expression           = @"[PENDING_BOX] > 0";
                cnArr[1].Appearance.ForeColor = Color.Red;
                cnArr[1].ApplyToRow           = false;

                ((ColumnView)grd.MainView).FormatConditions.AddRange(cnArr);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
            }
        }
コード例 #4
0
ファイル: ToMauBKLSX.cs プロジェクト: nccong207/ACHAU
        public void Execute()
        {
            gvMain = (_data.FrmMain.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView;

            StyleFormatCondition h1 = new StyleFormatCondition();

            gvMain.FormatConditions.Add(h1);
            h1.Column               = gvMain.Columns["TinhTrangNP"];
            h1.Condition            = FormatConditionEnum.Equal;
            h1.Value1               = "Chưa đủ";
            h1.Appearance.BackColor = Color.Yellow;
            h1.ApplyToRow           = true;

            StyleFormatCondition h2 = new StyleFormatCondition();

            gvMain.FormatConditions.Add(h2);
            h2.Column               = gvMain.Columns["TinhTrangNP"];
            h2.Condition            = FormatConditionEnum.Equal;
            h2.Value1               = "Nhập đủ";
            h2.Appearance.BackColor = Color.LightGreen;
            h2.ApplyToRow           = true;

            StyleFormatCondition h = new StyleFormatCondition();

            gvMain.FormatConditions.Add(h);
            h.Column               = gvMain.Columns["DaSX"];
            h.Condition            = FormatConditionEnum.Equal;
            h.Value1               = true;
            h.Appearance.BackColor = Color.Gainsboro;
            h.ApplyToRow           = true;
        }
コード例 #5
0
        void btnChon_Click(object sender, EventArgs e)
        {
            drCur = (_data.BsMain.Current as DataRowView).Row;
            if (!gvMain.Editable)
            {
                XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu",
                                    Config.GetValue("PackageName").ToString());
                return;
            }
            //dùng report 1514 trong sysReport
            frmDS = FormFactory.FormFactory.Create(FormType.Report, "1514") as ReportPreview;
            //định dạng thêm cho grid của report
            gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView;
            StyleFormatCondition hh = new StyleFormatCondition();

            gvDS.FormatConditions.Add(hh);
            hh.Column               = gvDS.Columns["SL đã SX"];
            hh.Condition            = FormatConditionEnum.NotEqual;
            hh.Value1               = 0;
            hh.Appearance.BackColor = Color.LightCyan;
            hh.ApplyToRow           = true;
            gvDS.DataSourceChanged += new EventHandler(gvDS_DataSourceChanged);
            FormatGrid();
            //viết xử lý cho nút F4-Xử lý trong report
            SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton);

            btnXuLy.Text      = "Chọn LSX";
            btnXuLy.Click    += new EventHandler(btnXuLy_Click);
            frmDS.WindowState = FormWindowState.Maximized;
            frmDS.ShowDialog();
        }
コード例 #6
0
 public override void InitColumnMaster()
 {
     XtraGridSupportExt.TextLeftColumn(Cotloai_cv, "TEN_CV");
     XtraGridSupportExt.TextLeftColumn(CotCTCCV_ID, "CTCCV_ID");
     XtraGridSupportExt.TextLeftColumn(Cotmota, "MO_TA");
     HelpGridColumn.CotPLTimeEdit(Cotthoigian, "THOI_GIAN_THUC_HIEN", PLConst.FORMAT_TIME_HH_MM);
     HelpGridColumn.CotPLTimeEdit(cotngaylamviec, "NGAY_LAM_VIEC", "ddd, dd/MM/yyyy");
     HelpGridColumn.CotReadOnlyDate(CotNgaycapnhat, "NGAY_CAP_NHAT", PLConst.FORMAT_DATETIME_STRING);
     XtraGridSupportExt.TextLeftColumn(cotnhanvien, "NHANVIEN");
     GridColumn column = new GridColumn();
     //XtraGridSupportExt.CreateDuyetGridColumn(column);
     this.gridViewMaster.Columns.Add(column);
     this.cotnhanvien.Visible = false;
     this.cotngaylamviec.Visible = false;
     gridViewMaster.OptionsView.ShowGroupPanel = false;
     //Nếu ngày cập nhật > ngày làm việc 1 ngày -> Đỏ
     StyleFormatCondition condition = new StyleFormatCondition();
     condition.Appearance.Options.UseForeColor = true;
     condition.Appearance.ForeColor = Color.Red;
     condition.Condition = FormatConditionEnum.Expression;
     condition.Expression = string.Format(@"(AddDays(AddTimeSpan([NGAY_LAM_VIEC],#{0}#),1) <= [NGAY_CAP_NHAT])", new TimeSpan(0, 0, 1));
     condition.ApplyToRow = true;
     gridViewMaster.FormatConditions.Add(condition);
     //-----------------------------
 }
コード例 #7
0
        private void ConditionsColumnView(GridControl grd)
        {
            int index = 0;

            try
            {
                StyleFormatCondition[] cnArr = new StyleFormatCondition[2];

                cnArr[index]                      = new StyleFormatCondition(FormatConditionEnum.Expression);
                cnArr[index].Column               = ((ColumnView)grd.MainView).Columns["PICKED_QTY"];
                cnArr[index].Expression           = @"[PICKED_QTY] > 0 AND [QTY] > [PICKED_QTY]";
                cnArr[index].Appearance.ForeColor = Color.Red;
                cnArr[index].ApplyToRow           = false;

                //next column Condition;
                index++;


                cnArr[index]                      = new StyleFormatCondition(FormatConditionEnum.Expression);
                cnArr[index].Column               = ((ColumnView)grd.MainView).Columns["LOADED_QTY"];
                cnArr[index].Expression           = @"[PICKED_QTY] > 0 AND [PICKED_QTY] <> [LOADED_QTY]";
                cnArr[index].Appearance.ForeColor = Color.Red;
                cnArr[index].ApplyToRow           = false;

                ((ColumnView)grd.MainView).FormatConditions.AddRange(cnArr);
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
            }
        }
コード例 #8
0
        protected void AddItemToListBox(StyleFormatCondition newItem)
        {
            ItemCondition newItemCondition = new ItemCondition(newItem);

            listBoxConditions.Items.Add(newItemCondition);
            listBoxConditions.SelectedItem = newItemCondition;
        }
コード例 #9
0
        /// <summary>
        /// 生成条件样式
        /// </summary>
        /// <param name="info">XtraStyleConditionInfo</param>
        /// <param name="gridView">GridView</param>
        /// <returns></returns>
        public static StyleFormatCondition CreateFormatCondition(XtraStyleConditionInfo info, GridView gridView)
        {
            var col = gridView.Columns.ColumnByFieldName(info.ColumnName);

            if (col == null)
            {
                MB.Util.TraceEx.Write("Style Format condition 列名称的配置,在数据源中找不到对应的列,请检查。", MB.Util.APPMessageType.SysWarning);
                return null;
            }

            col.AppearanceCell.Options.UseTextOptions = true;
            DevExpress.XtraGrid.StyleFormatCondition formatCondition = new StyleFormatCondition(info.Condition,
            col, info.StyleName, info.Value, info.Value2, info.ApplyToRow);

            if (!string.IsNullOrEmpty(info.Expression))
            {
                formatCondition.Condition = FormatConditionEnum.Expression;
                formatCondition.Expression = info.Expression;
            }
            formatCondition.Tag = info.Name;
            formatCondition.Appearance.Font = info.ForeFont;
            formatCondition.Appearance.ForeColor = info.ForeColor;
            formatCondition.Appearance.BackColor = info.BackColor;
            
            return formatCondition;
        }
コード例 #10
0
        /// <summary>
        /// Define uma coluna CheckBox com padrão de seleção de linhas
        /// </summary>
        /// <param name="pView">View da Grid</param>
        /// <param name="pColumnName">Nome da coluna</param>
        /// <param name="pColumnCaption">Título da coluna</param>
        public static void SetSelectColumn(this GridView pView, string pColumnName, string pColumnCaption)
        {
            pView.Appearance.Reset();

            var myCol = new GridColumn();

            myCol.FieldName   = pColumnName;
            myCol.Name        = pColumnName;
            myCol.Caption     = pColumnCaption;
            myCol.UnboundType = DevExpress.Data.UnboundColumnType.Boolean;

            pView.Columns.Add(myCol);

            myCol.Visible = true;

            var myCondition = new StyleFormatCondition(
                FormatConditionEnum.Equal,
                myCol,
                true,
                true,
                true,
                true);

            myCondition.Appearance.BackColor = Color.FromArgb(240, 204, 77);
            myCondition.Appearance.ForeColor = Color.Black;

            pView.FormatConditions.Add(myCondition);
        }
コード例 #11
0
        /// <summary>
        /// Dinh dang field voi dieu kien kem theo
        /// </summary>
        /// <param name="grid"></param>
        /// <param name="fieldName"></param>
        /// <param name="condition"></param>
        /// <param name="color"></param>
        /// <param name="value"></param>
        public static void ConditionsAdjustment(GridView grid, string fieldName, FormatConditionEnum condition, Color color, object value)
        {
            StyleFormatCondition cn = new StyleFormatCondition(condition, grid.Columns[fieldName], null, value);

            cn.Appearance.BackColor = color;
            grid.FormatConditions.Add(cn);
        }
コード例 #12
0
        /// <summary>
        /// 把汇总条件绑定到网格上,让用户能自由操作
        /// 每次动态聚组窗口加载是调用
        /// </summary>
        public void BindDynamicGroupColumnsToGrid()
        {
            //用到的全局变量
            DynamicGroupCfgInfo  dyConfigInfo     = _DynamicCfgInfo;
            GridControlEx        grid             = _GirdControl;
            IClientRuleQueryBase clientRuleObject = _ClientRuleObject;

            XmlDocument xmlDoc = new XmlDocument();

            xmlDoc.LoadXml(DynamicGroupUIHelper.DYNAMIC_CONDITION_UI_XML_CONTENT);
            var cols               = _UIXmlHelper.GetColumnPropertys(xmlDoc);
            var colEdits           = _UIXmlHelper.GetColumnEdits(cols, xmlDoc);
            var gridViewLayoutInfo = _UIXmlHelper.GetGridColumnLayoutInfo(xmlDoc, string.Empty);

            #region 准备数据源
            //先从缓存的地方恢复设置,如果没有
            List <DynamicGroupUIColumns> columns = RestoreDynamicGroupSetting();
            if (columns == null)
            {
                //从配置重初始化
                columns = GetDynamicGroupColumnsFromConfig();
            }
            BindingList <DynamicGroupUIColumns> bindingList = new BindingList <DynamicGroupUIColumns>(columns);
            bindingList.AllowNew    = false;
            bindingList.AllowRemove = false;
            #endregion

            var detailBindingParams = new MB.XWinLib.GridDataBindingParam(grid, bindingList);

            MB.XWinLib.XtraGrid.XtraGridEditHelper gridEditHelper = MB.XWinLib.XtraGrid.XtraGridEditHelper.Instance;
            gridEditHelper.CreateEditXtraGrid(detailBindingParams, cols, colEdits, gridViewLayoutInfo);
            gridEditHelper.AppendEditSelectedColumn(grid, "选择", DynamicGroupUIHelper.DYMANIC_GROUP_COL_SELECTED);


            GridView mainView = grid.MainView as GridView;
            if (mainView != null)
            {
                mainView.OptionsView.NewItemRowPosition  = NewItemRowPosition.None;
                mainView.OptionsSelection.MultiSelect    = true;
                mainView.OptionsBehavior.AllowAddRows    = DevExpress.Utils.DefaultBoolean.False;
                mainView.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
            }

            #region 对聚合的字段加载样式,前景色蓝色
            var aggTypeCol = mainView.Columns.ColumnByFieldName(DynamicGroupUIHelper.DYMANIC_GROUP_AGG_TYPE);
            if (aggTypeCol != null)
            {
                StyleFormatCondition formatCondition = new StyleFormatCondition(
                    DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
                    aggTypeCol, "列类型", string.Empty, null, true);

                formatCondition.Appearance.ForeColor = Color.Blue;
                if (formatCondition != null)
                {
                    mainView.FormatConditions.Add(formatCondition);
                }
            }
            #endregion
        }
コード例 #13
0
        private void CreateNewFormatCondition()
        {
            StyleFormatCondition item = new StyleFormatCondition();

            item.Column = SourceGridColumn;
            SourceGridView.FormatConditions.Add(item);
            AddItemToListBox(item);
        }
コード例 #14
0
        private void SetGridControlColor()
        {
            StyleFormatCondition styleFormatCondition = new StyleFormatCondition(FormatConditionEnum.Equal, this.gridViewTemplatePerson.Columns["Used"], null, "否");

            styleFormatCondition.Appearance.BackColor = Color.Red;
            styleFormatCondition.Appearance.ForeColor = Color.White;
            this.gridViewTemplatePerson.FormatConditions.Add(styleFormatCondition);
        }
コード例 #15
0
        private void ConditionsAdjustment()
        {
            StyleFormatCondition cn;

            cn = new StyleFormatCondition(FormatConditionEnum.LessOrEqual, gridView1.Columns["Balance_T空闲信道"], null, 0);
            cn.Appearance.BackColor = Color.Red;
            cn.Appearance.ForeColor = Color.White;
            gridView1.FormatConditions.Add(cn);
        }
コード例 #16
0
        private void ConditionsAdjustment_equal(string col, int thr)
        {
            StyleFormatCondition cn;

            cn = new StyleFormatCondition(FormatConditionEnum.Equal, gridView2.Columns[col], null, thr);
            cn.Appearance.BackColor = Color.Red;
            cn.Appearance.ForeColor = Color.White;
            gridView2.FormatConditions.Add(cn);
        }
コード例 #17
0
ファイル: xucSymbol.cs プロジェクト: chuxuantinh/CHBK2014-N9
        private void PreviewData()
        {
            StyleFormatCondition styleFormatCondition = new StyleFormatCondition(FormatConditionEnum.Equal, this.gbList.Columns["IsEdit"], null, true);

            styleFormatCondition.Appearance.BackColor = Color.White;
            this.gbList.FormatConditions.Add(styleFormatCondition);
            styleFormatCondition = new StyleFormatCondition(FormatConditionEnum.Equal, this.gbList.Columns["IsEdit"], null, false);
            styleFormatCondition.Appearance.BackColor = Color.WhiteSmoke;
            this.gbList.FormatConditions.Add(styleFormatCondition);
        }
コード例 #18
0
 public void CopyToStyleFormats(StyleFormatConditionCollection styles)
 {
     styles.Clear();
     foreach (SerializableFormatCondition serializableFormat in this)
     {
         StyleFormatCondition style = new StyleFormatCondition();
         styles.Add(style);
         serializableFormat.CopyToStyleFormat(style);
     }
 }
コード例 #19
0
        private static StyleFormatCondition CreateStyleFormatCondition(FilterCondition conditionSetting)
        {
            StyleFormatCondition condition = new StyleFormatCondition();

            condition.Condition  = FormatConditionEnum.Expression;
            condition.Expression = conditionSetting.Conditions;
            condition.Appearance.Options.UseFont      = true;
            condition.Appearance.Options.UseForeColor = true;
            condition.Appearance.Options.UseBackColor = true;
            return(condition);
        }
コード例 #20
0
        private void ConditionsAdjustment_thr(string col, int min_thr, int max_thr)
        {
            StyleFormatCondition cn;

            cn = new StyleFormatCondition(FormatConditionEnum.Less, gridView2.Columns[col], null, min_thr);
            cn.Appearance.BackColor = Color.Red;
            cn.Appearance.ForeColor = Color.White;
            gridView2.FormatConditions.Add(cn);
            cn = new StyleFormatCondition(FormatConditionEnum.Greater, gridView2.Columns[col], null, max_thr);
            cn.Appearance.BackColor = Color.Green;
            gridView2.FormatConditions.Add(cn);
        }
コード例 #21
0
        private void Form1_Load(object sender, EventArgs e)
        {
            StyleFormatCondition condition1 = new StyleFormatCondition();

            condition1.Appearance.BackColor            = Color.Navy;
            condition1.Appearance.Options.UseBackColor = true;
            condition1.Condition  = FormatConditionEnum.Expression;
            condition1.ApplyToRow = false;
            condition1.Expression = "[Value1] > 2";
            condition1.Column     = gridColumn3;
            myGridView1.FormatConditions.Add(condition1);
        }
コード例 #22
0
        /// <summary>
        /// 添加对应的数据列
        /// </summary>
        private void InitialFormControls()
        {
            GridViewHelper.SetGridView(grvDataList);
            //grvDataList.IndicatorWidth = 60;
            grvDataList.OptionsView.ShowIndicator = false;
            DataTable  dataTable;
            DataColumn dc;
            GridColumn gridColumn;

            dataTable = new DataTable(BASE_ATTRIBUTE_CATEGORY_FIELDS.DATABASE_TABLE_NAME);

            dc          = dataTable.Columns.Add(COMMON_FIELDS.FIELD_COMMON_CHECKED, typeof(bool));
            dc.Caption  = "选择";
            dc.ReadOnly = false;

            dc          = dataTable.Columns.Add(BASE_ATTRIBUTE_CATEGORY_FIELDS.FIELDS_CATEGORY_KEY);
            dc.Caption  = "基础数据表主键";
            dc.ReadOnly = true;

            dc          = dataTable.Columns.Add(BASE_ATTRIBUTE_CATEGORY_FIELDS.FIELDS_CATEGORY_NAME);
            dc.Caption  = "基础数据表类型";
            dc.ReadOnly = true;

            ControlUtils.InitialGridView(this.grvDataList, dataTable);

            this.grvDataList.Columns[COMMON_FIELDS.FIELD_COMMON_CHECKED].Width = 35;
            this.grvDataList.Columns[COMMON_FIELDS.FIELD_COMMON_CHECKED].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
            this.grvDataList.Columns[BASE_ATTRIBUTE_CATEGORY_FIELDS.FIELDS_CATEGORY_KEY].Visible = false;

            gridColumn = this.grvDataList.Columns.ColumnByFieldName(COMMON_FIELDS.FIELD_COMMON_CHECKED);

            if (gridColumn != null)
            {
                RepositoryItemCheckEdit checkEdit = new RepositoryItemCheckEdit();

                checkEdit.QueryCheckStateByValue += new QueryCheckStateByValueEventHandler(ControlUtils.QueryCheckStateByValue);
                checkEdit.CheckedChanged         += new EventHandler(checkEdit_CheckedChanged);

                gridColumn.ColumnEdit = checkEdit;

                StyleFormatCondition checkCondition = new StyleFormatCondition();

                checkCondition.Appearance.BackColor            = Color.Green;
                checkCondition.Appearance.Options.UseBackColor = true;
                checkCondition.ApplyToRow = true;
                checkCondition.Condition  = DevExpress.XtraGrid.FormatConditionEnum.Equal;
                checkCondition.Value1     = true;
                checkCondition.Column     = gridColumn;

                this.grvDataList.FormatConditions.Add(checkCondition);
            }
        }
コード例 #23
0
 private void AbrirEditor(StyleFormatCondition styleFormatCondition)
 {
     using (ExpressionEditorForm expressionEditorForm = new ConditionExpressionEditorForm(styleFormatCondition, null))
     {
         expressionEditorForm.Text          = "Editor de expressão";
         expressionEditorForm.StartPosition = FormStartPosition.CenterScreen;
         //form.Icon = BitmapFrame.Create(new Uri("pack://application:,,,/Icone_Globus_2008.ico", UriKind.RelativeOrAbsolute));
         if (expressionEditorForm.ShowDialog(this) == DialogResult.OK)
         {
             styleFormatCondition.Expression = expressionEditorForm.Expression;
         }
     }
 }
コード例 #24
0
        public void FormatRows()
        {
            // --- style mri
            StyleFormatCondition style = new StyleFormatCondition();

            style.Column                          = gridview.Columns["Flag_mri"];
            style.ApplyToRow                      = true;
            style.Value1                          = 1;
            style.Condition                       = FormatConditionEnum.Equal;
            style.Appearance.BackColor            = Color.Orange;
            style.Appearance.Options.UseBackColor = true;
            gridview.FormatConditions.Add(style);
        }
コード例 #25
0
ファイル: FrmStrList.cs プロジェクト: khanhnguyen18/tvqlLib
        private void FrmStrList_Load(object sender, EventArgs e)
        {
            this.Text = "Danh s\x00e1ch giao dịch kho h\x00e0ng";
            base.Tag  = "tblTransaction";
            this.method_0();
            this.method_1();
            StyleFormatCondition condition = null;

            condition = new StyleFormatCondition(FormatConditionEnum.Equal, this.gridView1.Columns["status"], null, "False");
            condition.Appearance.BackColor = Color.Red;
            this.gridView1.FormatConditions.Add(condition);
            condition.ApplyToRow    = true;
            this.Lbl_duaration.Text = "Từ ng\x00e0y " + string.Format("{0:dd/MM/yyyy}", Class7.dateTimeFrom) + " đến ng\x00e0y " + string.Format("{0:dd/MM/yyyy}", Class7.dateTimeTo);
        }
コード例 #26
0
        private void ConditionsAdjustment()
        {
            StyleFormatCondition cn;

            cn = new StyleFormatCondition(FormatConditionEnum.Less, gridView1.Columns["订货单价"], null, gridView1.Columns["数量"]);
            cn.Appearance.BackColor = Color.Yellow;
            gridView1.FormatConditions.Add(cn);
            cn = new StyleFormatCondition(FormatConditionEnum.Greater, gridView1.Columns["订货单价"], null, gridView1.Columns["数量"]);
            cn.Appearance.BackColor = Color.Red;
            cn.Appearance.ForeColor = Color.White;
            gridView1.FormatConditions.Add(cn);
            //..
            gridView1.BestFitColumns();
        }
コード例 #27
0
        private void btnNew_Click(object sender, EventArgs e)
        {
            StyleFormatCondition condition = new StyleFormatCondition();

            condition.Condition = FormatConditionEnum.Expression;
            TargetGrid.View.FormatConditions.Add(condition);
            ShowEditor(condition);
            if (string.IsNullOrEmpty(condition.Expression))
            {
                TargetGrid.View.FormatConditions.Remove(condition);
            }
            Grid.RefreshData();
            Grid.View.MoveLastVisible();
        }
コード例 #28
0
 public void Init(ItemCondition item)
 {
     if (item != null)
     {
         currentFormatCondition = item.Condition;
         CreateValues(item.Condition.Column.ColumnType);
     }
     else
     {
         currentFormatCondition = null;
     }
     RefreshEditorsValues(item);
     UpdateEditors(item);
 }
コード例 #29
0
        private void SetGridControlConsultationColor()
        {
            StyleFormatCondition cn1;

            cn1 = new StyleFormatCondition(FormatConditionEnum.Equal, gridViewCardList.Columns[m_App.PublicMethod.ConvertProperty("REPORTTYPENAME")], null, "订正报告");
            cn1.Appearance.BackColor = Color.LightGreen;
            cn1.Appearance.ForeColor = Color.DarkGreen;
            gridViewCardList.FormatConditions.Add(cn1);
            StyleFormatCondition cn2;

            cn2 = new StyleFormatCondition(FormatConditionEnum.Equal, gridViewCardList.Columns[m_App.PublicMethod.ConvertProperty("REPORTTYPENAME")], null, "初步报告");
            cn2.Appearance.BackColor = Color.LightBlue;
            cn2.Appearance.ForeColor = Color.DarkBlue;
            gridViewCardList.FormatConditions.Add(cn2);
        }
コード例 #30
0
        //private void GvMain_RowStyle(object sender, RowStyleEventArgs e)
        //{
        //    GridView View = sender as GridView;
        //    if (e.RowHandle >= 0)
        //    {
        //        bool duyet = (bool) View.GetRowCellValue(e.RowHandle, View.Columns["Duyet"]);

        //        if (duyet)
        //        {
        //            //green
        //            e.Appearance.BackColor = Color.LightGreen;
        //            e.Appearance.BackColor2 = Color.LightGreen;
        //        }
        //    }
        //}

        void FrmMain_Load(object sender, EventArgs e)
        {
            if ((_data.BsMain.DataSource as DataSet).Tables[0].Columns.Contains("Duyet"))
            {
                //dung class StyleFormatCondition cho Duyet
                StyleFormatCondition d = new StyleFormatCondition();
                gvMain.FormatConditions.Add(d);
                //thiet lap dieu kien
                d.Column    = gvMain.Columns["Duyet"];
                d.Condition = FormatConditionEnum.Equal;
                d.Value1    = true;
                //thiet lap dinh dang
                d.Appearance.BackColor = Color.LightGreen;
                d.ApplyToRow           = true;
            }
        }
コード例 #31
0
        private void frmUretimEmri_Load(object sender, EventArgs e)
        {
            try
            {
                using (daUretim.SelectCommand = new SqlCommand(@"SELECT dbo.UretimEmri.UretimEmriID, dbo.UretimEmri.PartiNo, dbo.UretimEmri.UretimTarihi, dbo.UretimEmri.OzelKod1, dbo.UretimEmri.OzelKod2, 
                      dbo.UretimEmri.CariID, dbo.UretimEmri.SarfAmbarID, dbo.UretimEmri.UretimdenGirisAmbarID, dbo.UretimEmri.ReceteMasterID, dbo.UretimEmri.UretimMiktari, 
                      dbo.UretimEmri.BaslangicTarihi, dbo.UretimEmri.BitisTarihi, dbo.UretimEmri.TeslimTarihi, dbo.UretimEmri.UretimAciklama, dbo.UretimEmri.Durum, 
                      CASE WHEN Durum = 0 THEN 'Kaydedildi' ELSE 'Üretildi' END AS UretimDurum, dbo.UretimEmri.KaydedenID, dbo.UretimEmri.KayitTarihi, 
                      dbo.UretimEmri.GuncelleyenID, dbo.UretimEmri.GuncellemeTarihi, SarfAmbar.DepoAdi AS SarfAmbar, UretimAmbar.DepoAdi AS UretimdenGiris
FROM         dbo.UretimEmri LEFT OUTER JOIN
                      dbo.Depo AS UretimAmbar ON dbo.UretimEmri.UretimdenGirisAmbarID = UretimAmbar.DepoID LEFT OUTER JOIN
                      dbo.Depo AS SarfAmbar ON dbo.UretimEmri.SarfAmbarID = SarfAmbar.DepoID
ORDER BY dbo.UretimEmri.UretimEmriID DESC", SqlConnections.GetBaglanti()))
                {
                    dt.Clear();
                    daUretim.Fill(dt);
                    gcUretimEmri.DataSource = dt;
                }

                GridArayuzIslemleri(enGridArayuzIslemleri.Get);

                #region GRİD SATIR RENKLERİ AYARLANIYOR
                StyleFormatCondition cTamamlandi = new StyleFormatCondition(FormatConditionEnum.Equal, gvUretimEmri.Columns["UretimDurum"], "cTamamlandi", "Üretildi");
                //cTamamlandi.Appearance.BackColor = Color.LightGreen;
                cTamamlandi.Appearance.ForeColor = System.Drawing.Color.Green;                 //Color.FromName(Sirada);
                //cTamamlandi.Appearance.Options.UseBackColor = true;
                cTamamlandi.Appearance.Options.UseForeColor = true;
                cTamamlandi.ApplyToRow = true;
                gvUretimEmri.FormatConditions.Add(cTamamlandi);

                //*****************
                StyleFormatCondition cKaydedildi = new StyleFormatCondition(FormatConditionEnum.Equal, gvUretimEmri.Columns["UretimDurum"], "cKaydedildi", "Kaydedildi");
                //cTamamlandi.Appearance.BackColor = Color.LightGreen;
                cKaydedildi.Appearance.ForeColor = System.Drawing.Color.Red;                 //Color.FromName(Sirada);
                //cTamamlandi.Appearance.Options.UseBackColor = true;
                cKaydedildi.Appearance.Options.UseForeColor = true;
                cKaydedildi.ApplyToRow = true;
                gvUretimEmri.FormatConditions.Add(cKaydedildi);
                #endregion
            }
            catch (Exception hata)
            {
                frmHataBildir frmHataBildir = new frmHataBildir(hata.Message, hata.StackTrace);
                frmHataBildir.ShowDialog();
            }
        }
コード例 #32
0
        public UCTreeListDataPermission()
        {
            InitializeComponent();

            HelpTreeList.CotCheckEdit(ColIsCreate_Bit, "ISCREATE_BIT");
            HelpTreeList.CotCheckEdit(ColIsRead_Bit, "ISREAD_BIT");
            HelpTreeList.CotCheckEdit(ColIsUpdate_Bit, "ISUPDATE_BIT");
            HelpTreeList.CotCheckEdit(ColIsDelete_Bit, "ISDELETE_BIT");
            HelpTreeList.CotCheckEdit(ColFull_Bit, "ISFULL_BIT");
            HelpTreeList.CotCheckEdit(ColISUseCreate, "USE_CREATE");
            HelpTreeList.CotTextLeft(ColName, "NAME");
            this.TreePermission.ParentFieldName = "PARENT_ID";
            this.TreePermission.KeyFieldName = "RESOURCE_ID";

            StyleFormatCondition style = new StyleFormatCondition();
            style.Column = ColIsCreate_Bit;
            style.Expression = "[USE_CREATE]=='N'";
            style.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
            style.Appearance.BackColor = Color.DarkGray;
            style.Appearance.Options.UseBackColor = true;
            TreePermission.FormatConditions.Add(style);
        }
コード例 #33
0
 public override void InitColumDetail()
 {
     //Format dòng không phải là thời gian làm việc.
     StyleFormatCondition conditionNotWork = new StyleFormatCondition(FormatConditionEnum.NotEqual, CotLoai, null,((Int32)TimeInOutType.GhiThoiGian).ToString());
     conditionNotWork.Appearance.ForeColor = Color.Red;
     conditionNotWork.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular);
     conditionNotWork.Column = CotLoai;
     conditionNotWork.ApplyToRow = true;
     //Format cột thời gian bắt đầu
     /* Nếu giờ bắt đầu > thời gian bắt đầu sáng 1 giây
      * hoặc chỉ làm 1 buối trong ngày và ngày đó không phải là thứ 7 ==> tô màu
      * GetDayOfWeek([NGAY_LAM_VIEC] != '6') ==> không phải thứ 7
      */
     StyleFormatCondition conditionGBD = new StyleFormatCondition();
     conditionGBD.Appearance.Options.UseForeColor = true;
     conditionGBD.Appearance.ForeColor = Color.Red;
     conditionGBD.Condition = FormatConditionEnum.Expression;
     //            conditionGBD.Expression = string.Format(@"
     //            (GetTimeOfDay(AddTimeSpan(Today(),[GIO_BAT_DAU])) >= GetTimeOfDay(AddTimeSpan(Today(), #{0}#))
     //               OR (GetTimeOfDay(AddTimeSpan(Today(),[THOI_GIAN_LAM_VIEC])) <=  GetTimeOfDay(AddTimeSpan(Today(), #{1}#))
     //                AND GetDayOfWeek([NGAY_LAM_VIEC]) != '6'))  AND [THOI_GIAN_LAM_VIEC] != ?"
     //                , AppGetSysParam.GetGIO_BAT_DAU_SANG.Add(new TimeSpan(0, 0, 0, 1)),AppGetSysParam.GetGIO_KET_THUC_SANG - AppGetSysParam.GetGIO_BAT_DAU_SANG);
     conditionGBD.Expression = string.Format(@"
     (GetTimeOfDay(AddTimeSpan(Today(),[GIO_BAT_DAU])) >= GetTimeOfDay(AddTimeSpan(Today(), #{0}#)))"//  AND [THOI_GIAN_LAM_VIEC] != ?"
         , AppGetSysParam.GetGIO_BAT_DAU_SANG.Add(new TimeSpan(0, 0, 0, 1)));
     conditionGBD.Column = Cot_GioBatDau;
     //Format cột thời gian kết thúc
     StyleFormatCondition conditionGKT = new StyleFormatCondition();
     conditionGKT.Appearance.Options.UseForeColor = true;
     conditionGKT.Appearance.ForeColor = Color.Red;
     conditionGKT.Condition = FormatConditionEnum.Expression;
     /* Nếu giờ kết thúc trong khoảng từ lúc bắt đầu sáng cho tới trước khi kết
      * hoặc chỉ làm 1 buối trong ngày và ngày đó không phải là thứ 7 ==> tô màu
      * GetDayOfWeek([NGAY_LAM_VIEC] != '6') ==> không phải thứ 7
      */
     conditionGKT.Expression = string.Format(@"
     (GetTimeOfDay(AddTimeSpan(Today(),[GIO_KET_THUC])) > GetTimeOfDay(AddTimeSpan(Today(), #{0}#))
         AND (GetTimeOfDay(AddTimeSpan(Today(),[GIO_KET_THUC])) < GetTimeOfDay(AddTimeSpan(Today(), #{1}#)) AND GetDayOfWeek([NGAY_LAM_VIEC]) != '6'))"
         , AppGetSysParam.GetGIO_BAT_DAU_SANG, AppGetSysParam.GetGIO_KET_THUC_CHIEU);
     conditionGKT.Column = Cot_GioKetThuc;
     /* Nếu giờ kết thúc trong > giờ kết thúc buổi trưa và là ngày thứ 7 ==> tô lại màu đen
      * vì thứ 7 chỉ làm buổi sáng
      * GetDayOfWeek([NGAY_LAM_VIEC] == '6') ==> thứ 7
      */
     //            StyleFormatCondition conditionNLV = new StyleFormatCondition();
     //            conditionNLV.Appearance.ForeColor = Color.Black;
     //            conditionNLV.Appearance.Options.UseForeColor = true;
     //            conditionNLV.Condition = FormatConditionEnum.Expression;
     //            conditionNLV.Expression = string.Format(@"
     //            GetTimeOfDay(AddTimeSpan(Today(),[GIO_KET_THUC])) > GetTimeOfDay(AddTimeSpan(Today(), #{0}#))
     //                AND GetDayOfWeek([NGAY_LAM_VIEC]) == '6'"
     //                                        , AppGetSysParam.GetGIO_KET_THUC_SANG);
     //            conditionNLV.Column = Cot_GioKetThuc;
     //
     gridViewMaster.FormatConditions.AddRange(new StyleFormatCondition[] { conditionNotWork, conditionGBD, conditionGKT });
 }
コード例 #34
0
ファイル: FrmPol_UserRole.cs プロジェクト: enrio/skg-pro
        /// <summary>
        /// Định dạng in đậm, màu dòng cấp cha
        /// </summary>
        void FormatRows()
        {
            var sfc = new StyleFormatCondition(DevExpress.XtraGrid.FormatConditionEnum.Equal,
                trlMain.Columns["Format"], null, true, true, true);

            sfc.Appearance.BackColor = Color.Orange;
            sfc.Appearance.BackColor2 = Color.Yellow;
            sfc.Appearance.GradientMode = LinearGradientMode.BackwardDiagonal;

            var f = new Font(Font, FontStyle.Bold);
            sfc.Appearance.Font = f;
            sfc.Appearance.ForeColor = Color.Blue;

            trlMain.FormatConditions.Add(sfc);
        }
コード例 #35
0
ファイル: FormEPESSUBJ.cs プロジェクト: sunpander/VSDT
        private void FormESSUBJ_Load(object sender, EventArgs e)
        {
            this.InitDevGridCustomButtons();

            this.fgDevGridGroupInfo.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(GroupInfoEmbeddedNavigator_ButtonClick);
            this.fgDevGridUserInfo.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(UserInfoEmbeddedNavigator_ButtonClick);
            this.fgDevGridDeptInfo.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(DeptInfoEmbeddedNavigator_ButtonClick);

            //查询用户管辖范围内的部门信息
            getUserDept();

            //获取当前系统中所有的APPNAME信息
            RepositoryItemComboBox repstryItemGroupComboBoxApp = new RepositoryItemComboBox();

            EI.EIInfo inBlockAPP = new EI.EIInfo();
            EI.EIInfo outBlockAPP = new EI.EIInfo();

            inBlockAPP.SetColName(1, "ename");
            inBlockAPP.SetColVal(1, "ename", "");
            outBlockAPP = EI.EITuxedo.CallService("epesappinfo", inBlockAPP);
            if (outBlockAPP.sys_info.flag != 0)
            {
                MessageBox.Show(string.Format(EP.EPES.EPESC0000061/*获取APPNAME信息错误:{0}*/, outBlockAPP.sys_info.msg), EP.EPES.EPESC0000024, MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            String stemp = "";
            //fgComboBoxApp.Items.Clear();

            for (int i = 0; i < outBlockAPP.blk_info[0].Row; i++)
            {
                stemp = outBlockAPP.GetColVal(1, i + 1, "ename") + ": " + outBlockAPP.GetColVal(1, i + 1, "cname");
                //fgComboBoxApp.Items.Add(stemp);
                fgDevComboBoxEditApp.Properties.Items.Add(stemp);
                repstryItemGroupComboBoxApp.Items.Add(outBlockAPP.GetColVal(1, i + 1, "ename"));
            }

            gridViewGroupInfo.Columns["APPNAME"].ColumnEdit = repstryItemGroupComboBoxApp;

            //群组信息的子系统列只允许从下拉列表中选择
            repstryItemGroupComboBoxApp.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            if (outBlockAPP.blk_info[0].Row > 0)
            {
                //fgComboBoxApp.SelectedIndex = 0;
                fgDevComboBoxEditApp.SelectedIndex = 0;
            }

            //获取帐套信息
            InitComboBoxCompany();

            //用户信息的是否有效列只允许从下拉列表中选择
            repstryItemComboBoxUserIsEnable.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            //用户信息的部门号列只允许从下拉列表中选择
            repstryItemComboBoxUserDeptName.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            //设置checkbox选中行样式
            DevExpress.Skins.Skin currentSkin;
            currentSkin = DevExpress.Skins.CommonSkins.GetSkin(DevExpress.LookAndFeel.UserLookAndFeel.Dfgault);
            Color textColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.WindowText);
            Color highlightTextColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.HighligthText);
            Color selectColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.Highlight);

            StyleFormatCondition cnGroup;
            cnGroup = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridGroupInfo.SelectionColumn, null, false);
            cnGroup.ApplyToRow = true;
            cnGroup.Appearance.BackColor = Color.Empty;
            cnGroup.Appearance.ForeColor = textColor;
            gridViewGroupInfo.FormatConditions.Add(cnGroup);

            cnGroup = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridGroupInfo.SelectionColumn, null, true);
            cnGroup.ApplyToRow = true;
            cnGroup.Appearance.BackColor = selectColor;
            cnGroup.Appearance.ForeColor = highlightTextColor;
            gridViewGroupInfo.FormatConditions.Add(cnGroup);

            StyleFormatCondition cnUser;
            cnUser = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridUserInfo.SelectionColumn, null, false);
            cnUser.ApplyToRow = true;
            cnUser.Appearance.BackColor = Color.Empty;
            cnUser.Appearance.ForeColor = textColor;
            gridViewUserInfo.FormatConditions.Add(cnUser);

            cnUser = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridUserInfo.SelectionColumn, null, true);
            cnUser.ApplyToRow = true;
            cnUser.Appearance.BackColor = selectColor;
            cnUser.Appearance.ForeColor = highlightTextColor;
            gridViewUserInfo.FormatConditions.Add(cnUser);

            StyleFormatCondition cnDept;
            cnDept = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridDeptInfo.SelectionColumn, null, false);
            cnDept.ApplyToRow = true;
            cnDept.Appearance.BackColor = Color.Empty;
            cnDept.Appearance.ForeColor = textColor;
            gridViewDeptInfo.FormatConditions.Add(cnDept);

            cnDept = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridDeptInfo.SelectionColumn, null, true);
            cnDept.ApplyToRow = true;
            cnDept.Appearance.BackColor = selectColor;
            cnDept.Appearance.ForeColor = highlightTextColor;
            gridViewDeptInfo.FormatConditions.Add(cnDept);

            fgDevGridGroupInfo.ShowAddRowButton = false;
            fgDevGridGroupInfo.ShowAddCopyRowButton = false;
            fgDevGridGroupInfo.ShowDeleteRowButton = false;
            fgDevGridGroupInfo.SetAllColumnEditable(false);

            fgDevGridUserInfo.ShowAddRowButton = false;
            fgDevGridUserInfo.ShowAddCopyRowButton = false;
            fgDevGridUserInfo.ShowDeleteRowButton = false;
            fgDevGridUserInfo.SetAllColumnEditable(false);

            fgDevGridDeptInfo.ShowAddRowButton = false;
            fgDevGridDeptInfo.ShowAddCopyRowButton = false;
            fgDevGridDeptInfo.ShowDeleteRowButton = false;
            fgDevGridDeptInfo.SetAllColumnEditable(false);

            fgDevGridUserInfo.SelectionColumn.OptionsColumn.AllowEdit = true;
        }
コード例 #36
0
 public override void InitColumDetail()
 {
     ////Format 1 dòng lưới
     StyleFormatCondition cn = new StyleFormatCondition(FormatConditionEnum.NotEqual, CotLoai, null, "1");
     cn.Appearance.ForeColor = Color.Red;
     cn.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold);
     cn.Column = CotLoai;
     cn.ApplyToRow = true;
     gridViewMaster.FormatConditions.Add(cn);
 }
コード例 #37
0
        public override void InitColumnMaster()
        {
            HelpGridColumn.CotTextLeft(colTen_DA, "NAME");
            HelpGridColumn.CotTextLeft(colLoaiDA, "TEN_DA");
            HelpGridColumn.CotTextLeft(colTenKhachHang, "TEN_KHACH_HANG");
            HelpGridColumn.CotTextLeft(colNguoi_QL, "TEN_NGUOI_QL");
            HelpGridColumn.CotTextLeft(colT_trang, "TEN_TT");
            HelpGridColumn.CotTextLeft(colMuc_UT, "TEN_MUC");
            XtraGridSupportExt.DateTimeGridColumn(colNgay_BD_DA, "NGAY_BAT_DAU");
            XtraGridSupportExt.DateTimeGridColumn(colNgayKT_DA_DuKien, "NGAY_KET_THUC");
            XtraGridSupportExt.DateTimeGridColumn(cotNgayKetThucTT, "NGAY_KET_THUC_THUC_TE");
            HelpGridColumn.CotTextCenter(codT_do_DA, "TIEN_DO_PT");
            //////////////////////////////////////////////
            StyleFormatCondition conditionBlue = new StyleFormatCondition();
            conditionBlue.Appearance.Options.UseForeColor = true;
            conditionBlue.Appearance.ForeColor = Color.Blue;
            conditionBlue.Condition = FormatConditionEnum.Expression;
            conditionBlue.Expression = "([NGAY_KET_THUC] >= [NGAY_KET_THUC_THUC_TE] and not(IsNull([NGAY_KET_THUC_THUC_TE]))) or(IsNull([NGAY_KET_THUC]) and not(IsNull([NGAY_KET_THUC_THUC_TE]))) ";
            conditionBlue.ApplyToRow = true;

            StyleFormatCondition conditionRed = new StyleFormatCondition();
            conditionRed.Appearance.Options.UseForeColor = true;
            conditionRed.Appearance.ForeColor = Color.Red;
            conditionRed.Condition = FormatConditionEnum.Expression;
            conditionRed.Expression = "[NGAY_KET_THUC] < [NGAY_KET_THUC_THUC_TE] and not(IsNull([NGAY_KET_THUC]))";
            conditionRed.ApplyToRow = true;

            gridViewMaster.FormatConditions.AddRange(new StyleFormatCondition[] { conditionBlue, conditionRed });
        }
コード例 #38
0
ファイル: FormEPESOBJ.cs プロジェクト: sunpander/VSDT
        private void FormESOBJ_Load(object sender, EventArgs e)
        {
            InitCompany();

            InitDevGridCustomButtons();

            InitOthType(this.GetResType());

            if (EPESCommon.AuthMode == AUTHMODE.MODE_CLASSIC)
            {
                this.xtraTabPageResGroup.PageVisible = false;
                this.chkAuth.Visible = false;
                this.chkOth.Visible = false;
            }

            //按钮操作模式
            DataTable dt = new DataTable();
            dt.Columns.Add("value").Caption = " ";
            dt.Columns.Add("desc").Caption = EP.EPES.EPESC0000030/*操作模式*/;
            dt.Rows.Add("A", EP.EPES.EPESC0000058/*单步操作*/);
            dt.Rows.Add("B", EP.EPES.EPESC0000032/*多步操作*/);
            RepositoryItemLookUpEdit repositoryItemLookUpEdit = new RepositoryItemLookUpEdit();
            //RepositoryItemComboBox repositoryItemComboBox = new RepositoryItemComboBox();
            if (repositoryItemLookUpEdit != null)
            {
                repositoryItemLookUpEdit.DataSource = dt;
                repositoryItemLookUpEdit.DisplayMember = "desc";
                repositoryItemLookUpEdit.ValueMember = "value";
                gridViewButtInfo.Columns["OPTYPE"].ColumnEdit = repositoryItemLookUpEdit;
            }

            this.fgDevGridFormInfo.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(FormInfoEmbeddedNavigator_ButtonClick);
            this.fgDevGridButtInfo.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(ButtInfoEmbeddedNavigator_ButtonClick);
            this.fgDevGridOth.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(OthEmbeddedNavigator_ButtonClick);

            //获取当前系统中所有的APPNAME信息
            EI.EIInfo inBlockAPP = new EI.EIInfo();
            EI.EIInfo outBlockAPP = new EI.EIInfo();
            RepositoryItemComboBox repositoryItemComboBox = new RepositoryItemComboBox();

            inBlockAPP.SetColName(1, "ename");
            inBlockAPP.SetColVal(1, "ename", "");
            outBlockAPP = EI.EITuxedo.CallService("epesappinfo", inBlockAPP);
            if (outBlockAPP.sys_info.flag != 0)
            {
                MessageBox.Show(string.Format(EP.EPES.EPESC0000061/*获取APPNAME信息错误:{0}*/, outBlockAPP.sys_info.msg));
                return;
            }
            string stemp = "";

            for (int i = 0; i < outBlockAPP.blk_info[0].Row; i++)
            {
                stemp = outBlockAPP.GetColVal(1, i + 1, "ename") + ": " + outBlockAPP.GetColVal(1, i + 1, "cname");
                comboApp.Properties.Items.Add(stemp);
                repositoryItemComboBox.Items.Add(outBlockAPP.GetColVal(1, i + 1, "ename"));
            }

            gridViewFormInfo.Columns["APPNAME"].ColumnEdit = repositoryItemComboBox;
            repositoryItemComboBox.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
            if (outBlockAPP.blk_info[0].Row > 0)
            {
                comboApp.SelectedIndex = 0;
            }

            //设置checkbox选中行样式
            DevExpress.Skins.Skin currentSkin;
            currentSkin = DevExpress.Skins.CommonSkins.GetSkin(DevExpress.LookAndFeel.UserLookAndFeel.Dfgault);
            Color textColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.WindowText);
            Color highlightTextColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.HighligthText);
            Color selectColor = currentSkin.Colors.GetColor(DevExpress.Skins.CommonColors.Highlight);

            StyleFormatCondition cnForm;
            cnForm = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridFormInfo.SelectionColumn, null, false);
            cnForm.ApplyToRow = true;
            cnForm.Appearance.BackColor = Color.Empty;
            cnForm.Appearance.ForeColor = textColor;
            gridViewFormInfo.FormatConditions.Add(cnForm);

            cnForm = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridFormInfo.SelectionColumn, null, true);
            cnForm.ApplyToRow = true;
            cnForm.Appearance.BackColor = selectColor;
            cnForm.Appearance.ForeColor = highlightTextColor;
            gridViewFormInfo.FormatConditions.Add(cnForm);

            StyleFormatCondition cnBtn;
            cnBtn = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridButtInfo.SelectionColumn, null, false);
            cnBtn.ApplyToRow = true;
            cnBtn.Appearance.BackColor = Color.Empty;
            cnBtn.Appearance.ForeColor = textColor;
            gridViewButtInfo.FormatConditions.Add(cnBtn);

            cnBtn = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridButtInfo.SelectionColumn, null, true);
            cnBtn.ApplyToRow = true;
            cnBtn.Appearance.BackColor = selectColor;
            cnBtn.Appearance.ForeColor = highlightTextColor;
            gridViewButtInfo.FormatConditions.Add(cnBtn);

            StyleFormatCondition cnOth;
            cnOth = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridOth.SelectionColumn, null, false);
            cnOth.ApplyToRow = true;
            cnOth.Appearance.BackColor = Color.Empty;
            cnOth.Appearance.ForeColor = textColor;
            gridViewOthInfo.FormatConditions.Add(cnOth);

            cnOth = new StyleFormatCondition(FormatConditionEnum.Equal, fgDevGridOth.SelectionColumn, null, true);
            cnOth.ApplyToRow = true;
            cnOth.Appearance.BackColor = selectColor;
            cnOth.Appearance.ForeColor = highlightTextColor;
            gridViewOthInfo.FormatConditions.Add(cnOth);

            fgDevGridButtInfo.SetAllColumnEditable(false);
            fgDevGridFormInfo.SetAllColumnEditable(false);
            fgDevGridOth.SetAllColumnEditable(false);

            fgDevGridFormInfo.SelectionColumn.OptionsColumn.AllowEdit = true;
            fgDevGridButtInfo.SelectionColumn.OptionsColumn.AllowEdit = true;
            fgDevGridOth.SelectionColumn.OptionsColumn.AllowEdit = true;
        }
コード例 #39
0
 public override void InitColumDetail()
 {
     //Format dòng trên lưới
     StyleFormatCondition condition = new StyleFormatCondition();
     condition.Appearance.Options.UseForeColor = true;
     condition.Appearance.ForeColor = Color.Red;
     condition.Condition = FormatConditionEnum.Expression;
     condition.Expression = string.Format(@"(AddDays(AddTimeSpan([NGAY_LAM_VIEC],#{0}#),1) <= [THOI_GIAN_GHI_NHAN])
     AND [DUYET] == '1'", new TimeSpan(0, 0, 1));
     condition.ApplyToRow = true;
     gridViewMaster.FormatConditions.Add(condition);
 }
コード例 #40
0
        private void InitGrid()
        {
            gridViewDetail._SetPermissionElement(BtnPrint, BtnExport);
            HelpPhieu.InitGrid(gridViewDetail, _isAdd);
            var edit = HelpGridColumn.CotSpinEdit(ColTapSo, QL_LICH_PHAT_SONG_CT.TAP_SO, 0);
            edit.MinValue = 1;
            edit.MaxValue = int.MaxValue;
            edit.AllowNullInput = DefaultBoolean.False;

            HelpGridColumn.CotTextLeft(ColMaBang, QL_LICH_PHAT_SONG_CT.MA_BANG);
            HelpGridColumn.CotDateEdit(ColGioPhat, QL_LICH_PHAT_SONG_CT.GIO_PHAT_SONG, "HH:mm");
            HelpGridColumn.CotDateEdit(ColNgayPhat, QL_LICH_PHAT_SONG_CT.NGAY_PHAT_SONG, "dddd , " + FrameworkParams.option.dateFormat);
            ColNgayPhat.GroupFormat.FormatString = "dddd," + FrameworkParams.option.dateFormat;
            ColNgayPhat.GroupFormat.FormatType = FormatType.DateTime;
            AppCtrl.InitCotTimecode(ColThoiLuong, QL_LICH_PHAT_SONG_CT.THOI_LUONG, QL_LICH_PHAT_SONG_CT.THOI_LUONG_NUM);
            AppCtrl.InitCotThuTrongTuan(ColThuTrongTuan, QL_LICH_PHAT_SONG_CT.THU_TRONG_TUAN, true);
            HelpGridColumn.CotSpinEdit(ColSoTap, QL_LICH_PHAT_SONG_CT.SO_TAP_NGAY, 0);
            gridViewDetail.OptionsView.NewItemRowPosition = NewItemRowPosition.None;

            HelpGridColumn.CotTextLeft(ColTenTap, QL_LICH_PHAT_SONG_CT.TEN_TAP);
            HelpGridColumn.CotTextLeft(ColCodeBM, QL_LICH_PHAT_SONG_CT.CODE_BM);
            ColStart.Caption = " Dòng bắt đầu thay đổi thứ\nhoặc tập số/ngày(nếu có)";
            gridViewDetail.ColumnPanelRowHeight = 70;
            ColStart.Width = 100;

            ColGioPhat.Caption = "Giờ\nphát sóng";
            ColSoTap.Caption = "Số tập\n/ngày";
            ColTapSo.Caption = "Tập\nsố";

            foreach (GridColumn c in gridViewDetail.Columns)
            {
                c.AppearanceHeader.TextOptions.WordWrap = WordWrap.Wrap;
                c.AppearanceHeader.Options.UseTextOptions = true;
            }
            _itemCheck = HelpGridColumn.CotCheckEdit(ColStart, QL_LICH_PHAT_SONG_CT.IS_START);
            _itemCheck.CheckStyle = DevExpress.XtraEditors.Controls.CheckStyles.Radio;
            var fDelete = new StyleFormatCondition
                              {
                                  Condition = FormatConditionEnum.Expression,
                                  ApplyToRow = true,
                                  Expression = "[STATE]='DEL'"
                              };
            fDelete.Appearance.BackColor = Color.Silver;
            fDelete.Appearance.ForeColor = Color.Gainsboro;
            fDelete.Appearance.Options.UseBackColor = true;
            fDelete.Appearance.Options.UseForeColor = true;
            gridViewDetail.FormatConditions.Add(fDelete);

            var fAdd = new StyleFormatCondition
                           {
                               Condition = FormatConditionEnum.Expression,
                               ApplyToRow = true,
                               Expression = "[STATE]='ADD'"
                           };
            fAdd.Appearance.BackColor = Color.PaleGreen;
            fAdd.Appearance.Options.UseBackColor = true;
            gridViewDetail.FormatConditions.Add(fAdd);

            if (_isAdd != null)
            {
                var fStart = new StyleFormatCondition
                                 {
                                     Condition = FormatConditionEnum.Expression,
                                     ApplyToRow = true,
                                     Expression = "[" + QL_LICH_PHAT_SONG_CT.IS_START + "]='Y'"
                                 };
                fStart.Appearance.BackColor = Color.DarkOrange;
                fStart.Appearance.Options.UseBackColor = true;
                gridViewDetail.FormatConditions.Add(fStart);
                lblStart.BackColor = fStart.Appearance.BackColor;
            }
            lblDel.BackColor = fDelete.Appearance.BackColor;
            lblAdd.BackColor = fAdd.Appearance.BackColor;

            gridViewDetail.FocusedRowChanged += GridViewDetailFocusedRowChanged;
            gridViewDetail.RowCellClick += gridViewDetail_RowCellClick;
            gridViewDetail.FocusedColumnChanged += gridViewDetail_FocusedColumnChanged;
        }
コード例 #41
0
ファイル: Form1.cs プロジェクト: rupeshkumar399/seemapcell
 private void ConditionsAdjustment_not_equal(string col, int thr)
 {
     StyleFormatCondition cn;
     cn = new StyleFormatCondition(FormatConditionEnum.NotEqual, gridView2.Columns[col], null, thr);
     cn.Appearance.BackColor = Color.Red;
     cn.Appearance.ForeColor = Color.White;
     gridView2.FormatConditions.Add(cn);
 }
コード例 #42
0
        public override void InitColumnMaster()
        {
            this.gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            gridViewMaster.OptionsView.ColumnAutoWidth = true;
            gridViewThongTinLienHe.OptionsView.ColumnAutoWidth = true;

            gridViewMaster.OptionsSelection.MultiSelect = false;
            HelpGridColumn.CotTextLeft(CotCongViec, "CONG_VIEC");
            HelpGridExt1.colMultiline(CotNguoiThucHien, "NV_THAM_GIA");
            HelpGridColumn.CotTextLeft(CotTenDuAn, "TEN_DU_AN");
            HelpGridColumn.CotTextLeft(CotKhachHang, "TEN_KHACH_HANG");
            CotTenDuAn.Visible = false;
            CotKhachHang.Visible = false;
            CotNgayKetThucDuKien.Visible = false;
            HelpGridColumn.CotTextLeft(CotLoaiCongViec, "TEN_LCV");
            HelpGridColumn.CotTextCenter(CotDouutien, "TEN_MUC_UU_TIEN");
            HelpGridColumn.CotCombobox(CotTinhtrang,HelpDB.getDBService().LoadTable("DM_TINH_TRANG"),"ID","NAME","TINH_TRANG_ID");
            HelpGridColumn.CotTextRight(CotTienDo, "TONG_TIEN_DO");
            HelpGridColumn.CotTextLeft(Cotnguoigiao, "TEN_NGUOI_GIAO");
            XtraGridSupportExt.DateTimeGridColumn(Cotbatdau, "TU_NGAY");
            XtraGridSupportExt.DateTimeGridColumn(CotNgayKetThucDuKien, "DEN_NGAY");//ngay kt du kien
            XtraGridSupportExt.DateTimeGridColumn(Cotngayketthuc, "NGAY_KET_THUC");
            XtraGridSupportExt.TextCenterColumn(CotTGdutinh, "THOI_GIAN_DU_KIEN");
            gridViewMaster.OptionsView.ShowGroupPanel = false;
            //////////////////////////////////////
            StyleFormatCondition conditionBlue = new StyleFormatCondition();
            conditionBlue.Appearance.Options.UseForeColor = true;
            conditionBlue.Appearance.ForeColor = Color.Blue;
            conditionBlue.Condition = FormatConditionEnum.Expression;
            conditionBlue.Expression = "([DEN_NGAY] >= [NGAY_KET_THUC] and not(IsNull([NGAY_KET_THUC]))) or(IsNull([DEN_NGAY]) and not(IsNull([NGAY_KET_THUC]))) ";
            conditionBlue.ApplyToRow = true;

            StyleFormatCondition conditionRed = new StyleFormatCondition();
            conditionRed.Appearance.Options.UseForeColor = true;
            conditionRed.Appearance.ForeColor = Color.Red;
            conditionRed.Condition = FormatConditionEnum.Expression;
            conditionRed.Expression = "[DEN_NGAY] < [NGAY_KET_THUC] and not(IsNull([DEN_NGAY]))";
            conditionRed.ApplyToRow = true;

            gridViewMaster.FormatConditions.AddRange(new StyleFormatCondition[] { conditionBlue, conditionRed  });
        }
コード例 #43
0
 public override void InitColumDetail()
 {
     #region column phản hồi
     XtraGridSupportExt.TextLeftColumn(colNguoi_gui_PH, "N_GUI");
     XtraGridSupportExt.TextLeftColumn(colNguoi_nhan_PH, "N_NHAN");
     HelpGridColumn.CotReadOnlyDate(colTG_Gui_PH, "NGAY_GUI", PLConst.FORMAT_DATETIME_STRING);
     #endregion
     #region column layout tài liệu
     layoutView1.Appearance.CardCaption.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
     layoutView1.OptionsBehavior.AllowSwitchViewModes = true;
     layoutView1.OptionsBehavior.AllowExpandCollapse = true;
     lvGhi_chu.OptionsColumn.ReadOnly = true;
     layoutView1.OptionsView.ShowCardCaption = true;
     layoutView1.OptionsHeaderPanel.EnableCustomizeButton = false;
     layoutView1.OptionsCustomization.AllowSort = false;
     layoutView1.OptionsCustomization.AllowFilter = false;
     XtraGridSupportExt.TextLeftColumn(lvTieuDe, "TIEU_DE");
     XtraGridSupportExt.TextLeftColumn(lvFile_dinh_kem, "TEN_FILE");
     XtraGridSupportExt.TextLeftColumn(lvNguoiCapNhat, "TEN_NGUOI_CN");
     XtraGridSupportExt.TextLeftColumn(lvNgayCapNhat, "NGAY_CAP_NHAT");
     HelpGridColumn.CotCalcEditDec(lvSize, "SIZE", 3, true);
     HelpGridColumn.CotMemoExEdit(lvGhi_chu, "GHI_CHU");
     XtraGridSupportExt.TextLeftColumn(cot_luufile, "luu_file");
     XtraGridSupportExt.TextLeftColumn(cot_mofile, "mo_file");
     repositoryItemMemoExEdit1.ReadOnly = true;
     repositoryItemMemoExEdit1.ScrollBars = ScrollBars.Both;
     StyleFormatCondition conditionRed = new StyleFormatCondition();
     conditionRed.Appearance.Options.UseForeColor = true;
     conditionRed.Appearance.ForeColor = Color.Red;
     conditionRed.Condition = FormatConditionEnum.Expression;
     conditionRed.Expression = "[TYPE_ID] == 10";
     conditionRed.Column = lvFile_dinh_kem;
     layoutView1.FormatConditions.Add(conditionRed);
     #endregion
 }
コード例 #44
0
ファイル: UCResult.cs プロジェクト: hy1314200/HyDM
        /// <summary>
        /// /// <summary>
        /// ����ijһ�е�ֵ����gridview�и��е���ɫ,����ȱ�ݵȼ����Ƿ����������ֶ�
        /// ʹ���ֳɵķ���
        /// </summary>
        /// </summary>
        /// <param name="gcErrType"></param>
        private void SetRowColor(GridColumn gcErrType, GridColumn gcIsException)
        {
            StyleFormatCondition styleFormatCondition1 = new StyleFormatCondition();
            styleFormatCondition1.Appearance.ForeColor = Color.Red;
            styleFormatCondition1.Appearance.Options.UseBackColor = true;
            styleFormatCondition1.Appearance.Options.UseForeColor = true;
            styleFormatCondition1.ApplyToRow = true;
            styleFormatCondition1.Column = gcErrType;
            styleFormatCondition1.Condition = FormatConditionEnum.Equal;
            styleFormatCondition1.Value1 = "����ȱ��";

            StyleFormatCondition styleFormatCondition2 = new StyleFormatCondition();
            //styleFormatCondition2.Appearance.BackColor = System.Drawing.Color.Red;
            styleFormatCondition2.Appearance.ForeColor = Color.Orange;
            styleFormatCondition2.Appearance.Options.UseBackColor = true;
            styleFormatCondition2.Appearance.Options.UseForeColor = true;
            styleFormatCondition2.ApplyToRow = true;
            styleFormatCondition2.Column = gcErrType;
            styleFormatCondition2.Condition = FormatConditionEnum.Equal;
            styleFormatCondition2.Value1 = "��ȱ��";

            StyleFormatCondition styleFormatCondition3 = new StyleFormatCondition();
            styleFormatCondition3.Appearance.ForeColor = Color.YellowGreen;
            styleFormatCondition3.Appearance.Options.UseBackColor = true;
            styleFormatCondition3.Appearance.Options.UseForeColor = true;
            styleFormatCondition3.ApplyToRow = true;
            styleFormatCondition3.Column = gcErrType;
            styleFormatCondition3.Condition = FormatConditionEnum.Equal;
            styleFormatCondition3.Value1 = "��ȱ��";

            if (gcIsException.Visible)
            {
                StyleFormatCondition styleFormatCondition4 = new StyleFormatCondition();
                styleFormatCondition4.Appearance.Font = new Font("Tahoma", 8.25F, FontStyle.Strikeout);
                styleFormatCondition4.Appearance.ForeColor = SystemColors.ControlDark;
                styleFormatCondition4.Appearance.Options.UseFont = true;
                styleFormatCondition4.Appearance.Options.UseForeColor = true;
                styleFormatCondition4.ApplyToRow = true;
                styleFormatCondition4.Column = gcIsException;
                styleFormatCondition4.Condition = FormatConditionEnum.Equal;
                styleFormatCondition4.Value1 = true;

                gvResult.FormatConditions.AddRange(new StyleFormatCondition[]
                                                           {
                                                               styleFormatCondition1,
                                                               styleFormatCondition2,
                                                               styleFormatCondition3,
                                                               styleFormatCondition4
                                                           });
            }
            else
            {
                gvResult.FormatConditions.AddRange(new StyleFormatCondition[]
                                                           {
                                                               styleFormatCondition1,
                                                               styleFormatCondition2,
                                                               styleFormatCondition3
                                                           });
            }
        }
コード例 #45
0
ファイル: Form1.cs プロジェクト: rupeshkumar399/seemapcell
 private void ConditionsAdjustment_thr(string col, int min_thr, int max_thr)
 {
     StyleFormatCondition cn;
     cn = new StyleFormatCondition(FormatConditionEnum.Less, gridView2.Columns[col], null, min_thr);
     cn.Appearance.BackColor = Color.Red;
     cn.Appearance.ForeColor = Color.White;
     gridView2.FormatConditions.Add(cn);
     cn = new StyleFormatCondition(FormatConditionEnum.Greater, gridView2.Columns[col], null, max_thr);
     cn.Appearance.BackColor = Color.Green;
     gridView2.FormatConditions.Add(cn);
 }
コード例 #46
0
        private void Init()
        {
            barButtonItemView.Glyph = FWImageDic.VIEW_IMAGE20;
            barButtonItemExport.Glyph = HelpImage.getImage2020("ExportToExcel.png");
            barButtonItemClose.Glyph = FWImageDic.CLOSE_IMAGE20;
            TNSHelper.InitCtrlKenhPhatCpp(KenhPhat);
            TNSHelper.InitCtrlTargetCpp(Target);
            TNSHelper.InitCtrlThiTruongCpp(ThiTruong);
            HelpGrid.SetReadOnly(GridViewDetail);

            var date = DateTime.Today;
            TuThang.Value = 1;
            TuNam.Value = date.Year;
            DenThang.Value = 12;
            DenNam.Value = date.Year;

            var st = new StyleFormatCondition
                         {
                             ApplyToRow = true,
                             Condition = FormatConditionEnum.Expression,
                             Expression = GroupTypeEqualExpression(SummaryRow)
                         };
            st.Appearance.Options.UseFont = true;
            st.Appearance.Font = new Font(st.Appearance.Font, FontStyle.Bold);
            GridViewDetail.FormatConditions.Add(st);
        }
コード例 #47
0
ファイル: UCResult.cs プロジェクト: hy1314200/HyDM
        //public event FeatureChangedHandler SelectedReferFeatureChanged;
        //private void SendFeatureChangedEvent(IFeature selErrorFeature)
        //{
        //    if (this.SelectedErrorFeatureChanged != null)
        //        this.SelectedErrorFeatureChanged.Invoke(selErrorFeature);
        //}
        /// <summary>
        /// ����ijһ�е�ֵ����gridview�и��е���ɫ
        /// ʹ���ֳɵķ���
        /// </summary>
        private void SetExceptionColor(GridColumn gc)
        {
            StyleFormatCondition styleFormatCondition4 = new StyleFormatCondition();
            styleFormatCondition4.Appearance.Font = new Font("Tahoma", 8.25F, FontStyle.Strikeout);
            styleFormatCondition4.Appearance.ForeColor = SystemColors.ControlDark;
            styleFormatCondition4.Appearance.Options.UseFont = true;
            styleFormatCondition4.Appearance.Options.UseForeColor = true;
            styleFormatCondition4.ApplyToRow = true;
            styleFormatCondition4.Column = gc;
            styleFormatCondition4.Condition = FormatConditionEnum.Equal;
            styleFormatCondition4.Value1 = true;

            gvResult.FormatConditions.AddRange(new StyleFormatCondition[]
                                                           {
                                                               styleFormatCondition4
                                                           });
        }
コード例 #48
0
        public void InitGridCongViec_QLKH()
        {
            #region grid Công việc
            HelpGridColumn.CotTextLeft(CotLoaiCongViec, "LCV_ID");
            HelpGridColumn.CotTextLeft(Congviec, "CONG_VIEC");
            HelpGridColumn.CotTextLeft(Cotnguoigiao, "NGUOI_GIAO");
            HelpGridExt1.colMultiline(CotNguoiThucHien, "NV_THAM_GIA");
            HelpGridColumn.CotTextCenter(CotTienDo, "TONG_TIEN_DO");
            HelpGridColumn.CotDateEdit(Cotbatdau, "NGAY_BAT_DAU");
            HelpGridColumn.CotDateEdit(Cotngayketthuc, "NGAY_KET_THUC");
            HelpGridColumn.CotDateEdit(cotNgayKTTT, "NGAY_KTTT");
            HelpGridColumn.CotDateEdit(CotTGdutinh, "THOI_GIAN_DU_KIEN");
            XtraGridSupportExt.TextLeftColumn(CotDouutien, "TEN_MUC_UU_TIEN");
            XtraGridSupportExt.TextLeftColumn(CotTinhtrang, "TINH_TRANG");
            /////////////////////////////
            StyleFormatCondition conditionBlue = new StyleFormatCondition();
            conditionBlue.Appearance.Options.UseForeColor = true;
            conditionBlue.Appearance.ForeColor = Color.Blue;
            conditionBlue.Condition = FormatConditionEnum.Expression;
            conditionBlue.Expression = "([NGAY_KET_THUC] >= [NGAY_KTTT] and not(IsNull([NGAY_KTTT]))) or(IsNull([NGAY_KET_THUC]) and not(IsNull([NGAY_KTTT]))) ";
            conditionBlue.ApplyToRow = true;

            StyleFormatCondition conditionRed = new StyleFormatCondition();
            conditionRed.Appearance.Options.UseForeColor = true;
            conditionRed.Appearance.ForeColor = Color.Red;
            conditionRed.Condition = FormatConditionEnum.Expression;
            conditionRed.Expression = "[NGAY_KET_THUC] < [NGAY_KTTT] and not(IsNull([NGAY_KET_THUC]))";
            conditionRed.ApplyToRow = true;
            gridViewCongviec.FormatConditions.AddRange(new StyleFormatCondition[] { conditionBlue, conditionRed });

            #endregion

            #region layout Dự án

            XtraGridSupportExt.TextLeftColumn(colTen_DA, "NAME");
            XtraGridSupportExt.TextLeftColumn(colLoaiDA, "TEN_DA");
            XtraGridSupportExt.TextLeftColumn(colNguoi_QL, "TEN_NGUOI_QL");
            XtraGridSupportExt.TextLeftColumn(colT_trang, "TINH_TRANG");
            XtraGridSupportExt.TextLeftColumn(colNgay_BD_DA, "NGAY_BAT_DAU");
            XtraGridSupportExt.TextLeftColumn(colNgayKT, "NGAY_KET_THUC_THUC_TE");
            XtraGridSupportExt.TextLeftColumn(codT_do_DA, "TIEN_DO");
            XtraGridSupportExt.TextLeftColumn(colXem_DA, "XEM_DA");
            XtraGridSupportExt.TextLeftColumn(colTao_CV, "TAO_CV");
            XtraGridSupportExt.TextLeftColumn(colXoa_DA, "XOA_DA");
            XtraGridSupportExt.TextLeftColumn(colSua_DA, "SUA_DA");
            layoutViewDuAn.OptionsHeaderPanel.EnableCustomizeButton = false;
            layoutViewDuAn.OptionsCustomization.AllowSort = false;
            layoutViewDuAn.OptionsCustomization.AllowFilter = false;
            layoutViewDuAn.OptionsBehavior.AllowSwitchViewModes = true;
            layoutViewDuAn.OptionsBehavior.AllowExpandCollapse = true;
            layoutViewDuAn.OptionsView.ShowCardCaption = true;
            layoutViewDuAn.Appearance.CardCaption.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;

            #endregion

            #region layout tài liệu

            XtraGridSupportExt.TextLeftColumn(lvTieuDe, "TIEU_DE");
            XtraGridSupportExt.TextLeftColumn(lvFile_dinh_kem, "TEN_FILE");
            XtraGridSupportExt.TextLeftColumn(lvNguoiCapNhat, "TEN_NGUOI_CN");
            XtraGridSupportExt.TextLeftColumn(lvNgayCapNhat, "NGAY_CAP_NHAT");
            HelpGridColumn.CotMemoExEdit(lvGhi_chu, "GHI_CHU");
            XtraGridSupportExt.TextLeftColumn(cotID, "ID");
            HelpGridColumn.CotTextLeft(lvSize, "SIZE");
            XtraGridSupportExt.TextLeftColumn(cot_xoa, "xoa_file");
            XtraGridSupportExt.TextLeftColumn(cot_luufile, "luu_file");
            XtraGridSupportExt.TextLeftColumn(cot_mofile, "mo_file");
            XtraGridSupportExt.TextLeftColumn(cot_suafile, "sua_file");

            lvGhi_chu.OptionsColumn.ReadOnly = true;
            layoutView1.OptionsCustomization.AllowSort = false;
            layoutView1.OptionsCustomization.AllowFilter = false;
            layoutView1.OptionsBehavior.AllowSwitchViewModes = true;
            layoutView1.OptionsBehavior.AllowExpandCollapse = true;
            layoutView1.OptionsView.ShowCardCaption = true;
            layoutView1.Appearance.CardCaption.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;

            #endregion

            #region grid GhiNhatKy
            HelpGridColumn.CotReadOnlyDate(colTGCapNhat, "THOI_GIAN_CAP_NHAT", PLConst.FORMAT_DATETIME_STRING);
            HelpGridColumn.CotTextLeft(colNguoiCapNhat, "NGUOI_THUC_HIEN");
            HelpGridColumn.CotMemoExEdit(colNoiDung, "GHI_CHU");
            gridViewNhatKy.OptionsBehavior.Editable = true;
            colNoiDung.OptionsColumn.AllowEdit = true;
            colNoiDung.OptionsColumn.ReadOnly = true;

            #endregion
        }
コード例 #49
0
 public void FormatRows()
 {
     // --- style mri
     StyleFormatCondition style = new StyleFormatCondition();
     style.Column = gridview.Columns["Flag_mri"];
     style.ApplyToRow = true;
     style.Value1 = 1;
     style.Condition = FormatConditionEnum.Equal;
     style.Appearance.BackColor = Color.Orange;
     style.Appearance.Options.UseBackColor = true;
     gridview.FormatConditions.Add(style);
 }
コード例 #50
0
ファイル: RBTonKho.cs プロジェクト: khanhdtn/my-fw-devopen
        /// <summary>
        /// Khởi tạo định dạng lỗi trên Grid 
        /// </summary>
        /// <param name="grid">Grid cần khởi tạo định dạng lỗi</param>
        public void AddFormatCond(PLGridView grid)
        {
            DataSet ds = ((DataTable)grid.GridControl.DataSource).DataSet;

            //Khởi tạo cột Check
            GridColumn colCheck = new GridColumn();
            colCheck.FieldName = "CHECK";
            colCheck.Visible = false;
            if (!ds.Tables[0].Columns.Contains("CHECK"))
                ds.Tables[0].Columns.Add("CHECK");
            if (!grid.Columns.Contains(colCheck))
                grid.Columns.Add(colCheck);

            //Khởi tạo cột thông báo vi phạm
            GridColumn colVipham = new GridColumn();
            colVipham.FieldName = "VI_PHAM";
            colVipham.Visible = false;
            if (!ds.Tables[0].Columns.Contains("VI_PHAM"))
                ds.Tables[0].Columns.Add("VI_PHAM");
            if (!grid.Columns.Contains(colVipham))
                grid.Columns.Add(colVipham);

            StyleFormatCondition styleFormatCond = new StyleFormatCondition();
            styleFormatCond.Appearance.BackColor = System.Drawing.Color.Red;
            styleFormatCond.Appearance.Options.UseBackColor = true;
            styleFormatCond.ApplyToRow = true;
            styleFormatCond.Column = colCheck;
            styleFormatCond.Condition = DevExpress.XtraGrid.FormatConditionEnum.Equal;
            styleFormatCond.Value1 = 0;
            grid.FormatConditions.AddRange(new StyleFormatCondition[] { styleFormatCond });
        }
コード例 #51
0
ファイル: HelpGrid.cs プロジェクト: khanhdtn/my-fw-win
        /// <summary>
        /// Đặt màu sắc của cột tùy vào điều kiện được đặt ở dưới lưới
        /// </summary>
        public static void SetCondition(
            GridView xtraGridView, string columnName,
            FormatConditionEnum[] formatConditionEnum,
            object[] Value1s, object[] Value2s, Object[] formatAppearance)
        {
            StyleFormatCondition temp = new StyleFormatCondition();
            //Chọn cột định dạng
            temp.Column = xtraGridView.Columns[columnName];
            //Đặt điều kiện
            for (int i = 0; i < formatConditionEnum.Length; i++)
            {
                Object TmpformatAppearance = null;
                if (formatAppearance.Length == 1)
                    TmpformatAppearance = formatAppearance[0];
                else
                    TmpformatAppearance = formatAppearance[i];
                //Chọn kiểu định dạng
                if (TmpformatAppearance is DevExpress.Utils.AppearanceObject)
                {
                    temp.Appearance.Assign((DevExpress.Utils.AppearanceObject)TmpformatAppearance);
                }
                else
                {
                    temp.Appearance.BackColor = ((System.Drawing.Color)TmpformatAppearance);
                    temp.Appearance.Options.UseBackColor = true;
                }
                temp.Condition = formatConditionEnum[i];
                temp.Value1 = Value1s[i];
                if(Value2s[i] != null) temp.Value2 = Value2s[i];

                xtraGridView.FormatConditions.Add(temp);
            }
        }
コード例 #52
0
 public override void InitColumDetail()
 {
     StyleFormatCondition cn = new StyleFormatCondition(FormatConditionEnum.Equal, CotPrior, null, "Y");
     cn.Appearance.ForeColor = Color.Red;
     cn.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular);
     cn.ApplyToRow = true;
     gridViewMaster.FormatConditions.Add(cn);
 }
コード例 #53
0
ファイル: Form1.cs プロジェクト: rupeshkumar399/seemapcell
 private void ConditionsAdjustment()
 {
     StyleFormatCondition cn;
     cn = new StyleFormatCondition(FormatConditionEnum.LessOrEqual, gridView1.Columns["Balance_T空闲信道"], null, 0);
     cn.Appearance.BackColor = Color.Red;
     cn.Appearance.ForeColor = Color.White;
     gridView1.FormatConditions.Add(cn);
 }
コード例 #54
0
        public override void InitColumDetail()
        {
            #region column gridViewCongViec
            gridViewThongTinLienHe.OptionsBehavior.AutoExpandAllGroups = true;
            gridViewThongTinLienHe.OptionsView.ShowAutoFilterRow = false;
            gridViewThongTinLienHe.OptionsView.ColumnAutoWidth = true;
            gridViewCongviec.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
            gridViewThongTinLienHe.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
            HelpGridColumn.CotTextLeft(colCong_viec, "CONG_VIEC");
            HelpGridExt1.colMultiline(colNguoi_TH, "NV_THAM_GIA");
            HelpGridColumn.CotTextLeft(colLoaiCV, "TEN_LCV");
            HelpGridColumn.CotTextLeft(colDo_UT, "TEN_MUC_UU_TIEN");
            HelpGridColumn.CotTextLeft(colTinh_trang, "TINH_TRANG");
            HelpGridColumn.CotTextCenter(ColTien_Do, "TONG_TIEN_DO");
            HelpGridColumn.CotTextLeft(colNguoi_giao, "TEN_NGUOI_GIAO");
            XtraGridSupportExt.DateTimeGridColumn(colNgay_bat_dau, "TU_NGAY");
            XtraGridSupportExt.DateTimeGridColumn(colNgay_ket_thucDuKien, "DEN_NGAY");
            XtraGridSupportExt.DateTimeGridColumn(cotNgayKT, "NGAY_KET_THUC");
            XtraGridSupportExt.TextCenterColumn(colTG_DT, "THOI_GIAN_DU_KIEN");
            ////////////////////////////////////////////////
            StyleFormatCondition conditionBlue = new StyleFormatCondition();
            conditionBlue.Appearance.Options.UseForeColor = true;
            conditionBlue.Appearance.ForeColor = Color.Blue;
            conditionBlue.Condition = FormatConditionEnum.Expression;
            conditionBlue.Expression = "([DEN_NGAY] >= [NGAY_KET_THUC] and not(IsNull([NGAY_KET_THUC]))) or(IsNull([DEN_NGAY]) and not(IsNull([NGAY_KET_THUC]))) ";
            conditionBlue.ApplyToRow = true;

            StyleFormatCondition conditionRed = new StyleFormatCondition();
            conditionRed.Appearance.Options.UseForeColor = true;
            conditionRed.Appearance.ForeColor = Color.Red;
            conditionRed.Condition = FormatConditionEnum.Expression;
            conditionRed.Expression = "[DEN_NGAY] < [NGAY_KET_THUC] and not(IsNull([DEN_NGAY]))";
            conditionRed.ApplyToRow = true;
            gridViewThongTinLienHe.FormatConditions.AddRange(new StyleFormatCondition[] { conditionBlue, conditionRed });
            #endregion
            #region column layoutViewTaiLieu
            XtraGridSupportExt.TextLeftColumn(lvTieuDe, "TIEU_DE");
            XtraGridSupportExt.TextLeftColumn(lvFile_dinh_kem, "TEN_FILE");
            XtraGridSupportExt.TextLeftColumn(lvNguoiCapNhat, "TEN_NGUOI_CN");
            XtraGridSupportExt.TextLeftColumn(lvNgayCapNhat, "NGAY_CAP_NHAT");
            HelpGridColumn.CotTextLeft(lvSize, "SIZE");
            HelpGridColumn.CotMemoExEdit(lvGhi_chu, "GHI_CHU");
            lvGhi_chu.OptionsColumn.ReadOnly = true;
            XtraGridSupportExt.TextLeftColumn(cot_luufile, "luu_file");
            XtraGridSupportExt.TextLeftColumn(cot_mofile, "mo_file");
            layoutView1.OptionsHeaderPanel.EnableCustomizeButton = false;
            layoutView1.OptionsCustomization.AllowSort = false;
            layoutView1.OptionsCustomization.AllowFilter = false;
            layoutView1.OptionsBehavior.AllowSwitchViewModes = true;
            layoutView1.OptionsBehavior.AllowExpandCollapse = true;
            layoutView1.OptionsView.ShowCardCaption = true;
            layoutView1.Appearance.CardCaption.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            #endregion
            #region Column gridGhiNhatKy
            HelpGridColumn.CotReadOnlyDate(colTGCapNhat, "THOI_GIAN_CAP_NHAT", PLConst.FORMAT_DATETIME_STRING);
            HelpGridColumn.CotTextLeft(colNguoiCapNhat, "NGUOI_THUC_HIEN");
            HelpGridColumn.CotMemoExEdit(colNoiDung, "GHI_CHU");
            HelpGrid.SetReadOnlyHaveMemoCtrl(gridViewNhatKyDA);
            #endregion
        }
コード例 #55
0
        void frmListCanhBaoQL_Load(object sender, EventArgs e)
        {
            this.PLBuildQueryFilter();

            StyleFormatCondition sMT1 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sMT1.Appearance.BackColor = Color.DodgerBlue;
            sMT1.Appearance.Options.UseBackColor = true;
            sMT1.Value1 = 1;
            sMT1.ApplyToRow = true;
            sMT1.Column = Col_MT_LoaiCB;
            StyleFormatCondition sMT2 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sMT2.Appearance.BackColor = Color.Yellow;
            sMT2.Appearance.Options.UseBackColor = true;
            sMT2.Value1 = 2;
            sMT2.ApplyToRow = true;
            sMT2.Column = Col_MT_LoaiCB;
            StyleFormatCondition sMT3 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sMT3.Appearance.BackColor = Color.Tomato;
            sMT3.Appearance.Options.UseBackColor = true;
            sMT3.Value1 = 3;
            sMT3.ApplyToRow = true;
            sMT3.Column = Col_MT_LoaiCB;
            gridViewMuonTra.FormatConditions.Add(sMT1);
            gridViewMuonTra.FormatConditions.Add(sMT2);
            gridViewMuonTra.FormatConditions.Add(sMT3);

            StyleFormatCondition sRUN1 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sRUN1.Appearance.BackColor = Color.DodgerBlue;
            sRUN1.Appearance.Options.UseBackColor = true;
            sRUN1.Value1 = 1;
            sRUN1.ApplyToRow = true;
            sRUN1.Column = Col_RUN_LoaiCB;
            StyleFormatCondition sRUN2 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sRUN2.Appearance.BackColor = Color.Yellow;
            sRUN2.Appearance.Options.UseBackColor = true;
            sRUN2.Value1 = 2;
            sRUN2.ApplyToRow = true;
            sRUN2.Column = Col_RUN_LoaiCB;
            StyleFormatCondition sRUN3 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sRUN3.Appearance.BackColor = Color.Tomato;
            sRUN3.Appearance.Options.UseBackColor = true;
            sRUN3.Value1 = 3;
            sRUN3.ApplyToRow = true;
            sRUN3.Column = Col_RUN_LoaiCB;
            gridViewSoRun.FormatConditions.Add(sRUN1);
            gridViewSoRun.FormatConditions.Add(sRUN2);
            gridViewSoRun.FormatConditions.Add(sRUN3);

            StyleFormatCondition sBQ1 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sBQ1.Appearance.BackColor = Color.Tomato;
            sBQ1.Appearance.Options.UseBackColor = true;
            sBQ1.Value1 = 1;
            sBQ1.ApplyToRow = true;
            sBQ1.Column = Col_CT_LoaiCB;
            StyleFormatCondition sBQ2 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sBQ2.Appearance.BackColor = Color.Yellow;
            sBQ2.Appearance.Options.UseBackColor = true;
            sBQ2.Value1 = 2;
            sBQ2.ApplyToRow = true;
            sBQ2.Column = Col_CT_LoaiCB;
            StyleFormatCondition sBQ3 = new StyleFormatCondition(FormatConditionEnum.Equal);
            sBQ3.Appearance.BackColor = Color.DodgerBlue;
            sBQ3.Appearance.Options.UseBackColor = true;
            sBQ3.Value1 = 3;
            sBQ3.ApplyToRow = true;
            sBQ3.Column = Col_CT_LoaiCB;
            gridViewMaster.FormatConditions.Add(sBQ1);
            gridViewMaster.FormatConditions.Add(sBQ2);
            gridViewMaster.FormatConditions.Add(sBQ3);
        }
コード例 #56
0
        private void Init()
        {
            btnPrint = new SimpleButton();
            barButtonItemView.Glyph = FWImageDic.VIEW_IMAGE20;
            barButtonItemExport.Glyph = HelpImage.getImage2020("ExportToExcel.png");
            barButtonItemClose.Glyph = FWImageDic.CLOSE_IMAGE20;
            TNSHelper.InitCtrlKenhPhatRev(KenhPhat);
            TNSHelper.InitCtrlTargetRev(Target);
            TNSHelper.InitCtrlThiTruongRev(ThiTruong);

            TNSHelper.InitCtrlAdvertiserRev(Advertiser);
            TNSHelper.InitCtrlAgencyRev(Agency);
            TNSHelper.InitCtrlBrandRev(Brand);
            TNSHelper.InitCtrlGroupRev(Group);
            TNSHelper.InitCtrlSectorRev(Sector);

            HelpGrid.SetReadOnly(GridViewDetail);

            var date = DateTime.Today;
            TuThang.Value = 1;
            TuNam.Value = date.Year;
            DenThang.Value = 12;
            DenNam.Value = date.Year;

            InitColBase();

            var st = new StyleFormatCondition
                         {
                             ApplyToRow = true,
                             Condition = FormatConditionEnum.Expression,
                             Expression = "TIMEBAND like '%Grand Total%'"
                         };
            st.Appearance.Options.UseFont = true;
            st.Appearance.Font = new Font(st.Appearance.Font, FontStyle.Bold);
            GridViewDetail.FormatConditions.Add(st);
            GridViewDetail._SetPermissionElement(btnPrint, barButtonItemExport);
        }
コード例 #57
0
 private void AddFormat()
 {
     gridViewMaster.FormatConditions.Clear();
     StyleFormatCondition ff = new StyleFormatCondition();
     ff.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
     ff.ApplyToRow = true;
     ff.Expression = "[EMPTY]='N'";
     ff.Appearance.BackColor = System.Drawing.Color.Silver;
     // ff.Appearance.ForeColor = System.Drawing.Color.Gainsboro;
     ff.Appearance.Options.UseBackColor = true;
     ff.Appearance.Options.UseForeColor = true;
     gridViewMaster.FormatConditions.Add(ff);
 }