Dev中GridView、RepositoryItemGridLookUpEdit、LookUpEdit等扩展方法

最新推荐文章于 2024-09-10 16:24:10 发布
最新推荐文章于 2024-09-10 16:24:10 发布
阅读量3.5k 收藏 3
点赞数 1
分类专栏： C# DEV Winform GridView LookUpEdit GridLookUpEdit 文章标签： DEV Winform GridView GridLookUpEdit
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011695973/article/details/90399468
版权
C# 同时被 3 个专栏收录
9 篇文章 0 订阅
订阅专栏
DEV
4 篇文章 0 订阅
订阅专栏
Winform
2 篇文章 0 订阅
订阅专栏 

    /// <summary>
    /// GridView列属性设置类
    /// </summary>
    public class BaseColumnSet
    {
        /// <summary>
        /// 列名（可不设置）
        /// </summary>
        public string Name { get; set; }
        /// <summary>
        /// 绑定字段
        /// </summary>
        public string FieldName { get; set; }
        /// <summary>
        /// 列名（显示）
        /// </summary>
        public string Caption { get; set; }
        /// <summary>
        /// 列宽（默认100）
        /// </summary>
        public int Width { get; set; } = 100;
        /// <summary>
        /// 是否显示（默认显示）
        /// </summary>
        public bool Visible { get; set; } = true;
        /// <summary>
        /// 显示位置（默认按照列表添加顺序）
        /// </summary>
        public int? VisibleIndex { get; set; }
        /// <summary>
        /// 设置列是否可编辑（默认可编辑）
        /// </summary>
        public bool AllowEdit { get; set; } = true;
        /// <summary>
        /// 格式化类型
        /// </summary>
        public FormatType formatType { get; set; } = FormatType.None;
        /// <summary>
        /// 格式化类型名称 
        /// </summary>
        public string FormatString { get; set; }
        /// <summary>
        /// 分组
        /// </summary>
        public int GroupIndex { get; set; } = -1;
        /// <summary>
        /// 排序
        /// </summary>
        public ColumnSortOrder sortOrder { get; set; } = ColumnSortOrder.None;
        /// <summary>
        /// 设置可编辑列
        /// 例：RepositoryItemCheckEdit RepositoryItemImageEdit RepositoryItemGridLookUpEdit RepositoryItemComboBox
        /// </summary>
        public RepositoryItem ColumnEdit { get; set; }

        /// <summary>
        /// 设置列内容是否可合并
        /// </summary>
        public DefaultBoolean AllowMerge { get; set; } = DefaultBoolean.Default;
    }


    /// <summary>
    /// 控件设置公共类
    /// </summary>
    public static class CtrlSetCommon
    {
        /// <summary>
        /// 设置GridView显示列属性
        /// </summary>
        /// <param name="gv">GridView</param>
        /// <param name="list">列属性集合</param>
        /// <param name="indicatorShow">显示行号：默认True</param>
        public static void SetColumns(this GridView gv, List<BaseColumnSet> list, bool indicatorShow = true, int indicatorWidth = 30)
        {
            string fieldName = string.Empty;
            for (int i = 0; i < list.Count; i++)
            {
                fieldName = list[i].FieldName;
                gv.Columns.AddField(fieldName);

                if (!string.IsNullOrWhiteSpace(list[i].Name))
                    gv.Columns[fieldName].Name = list[i].Name;

                gv.Columns[fieldName].Caption = list[i].Caption;
                gv.Columns[fieldName].Width = list[i].Width;
                gv.Columns[fieldName].VisibleIndex = list[i].VisibleIndex ?? i;
                gv.Columns[fieldName].Visible = list[i].Visible;
                gv.Columns[fieldName].OptionsColumn.AllowEdit = list[i].AllowEdit;

                if (list[i].formatType != FormatType.None)
                {
                    gv.Columns[fieldName].DisplayFormat.FormatType = list[i].formatType;
                    gv.Columns[fieldName].DisplayFormat.FormatString = list[i].FormatString;
                }

                gv.Columns[fieldName].GroupIndex = list[i].GroupIndex;
                gv.Columns[fieldName].SortOrder = list[i].sortOrder;

                if (list[i].ColumnEdit != null)
                    gv.Columns[fieldName].ColumnEdit = list[i].ColumnEdit;//可编辑列

                if (list[i].AllowMerge != DefaultBoolean.Default)
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = list[i].AllowMerge;//设置合并列
                else
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = DefaultBoolean.False;//设置合并列
            }

            if (indicatorShow)
            {
                gv.IndicatorWidth = indicatorWidth;

                gv.CustomDrawRowIndicator += Gv_CustomDrawRowIndicator;
            }
        }

        /// <summary>
        /// 显示行号
        /// </summary>
        private static void Gv_CustomDrawRowIndicator(object sender, RowIndicatorCustomDrawEventArgs e)
        {
            if (e.Info.IsRowIndicator && e.RowHandle >= 0)
            {
                e.Info.DisplayText = (e.RowHandle + 1).ToString().PadLeft(3, ' ');
            }
        }

        #region RepositoryItemGridLookUpEdit

        //private static System.Windows.Forms.UserControl userCtrl = null;
        //private static List<string> strList = null;

        /// <summary>
        /// 行内编辑（弹出RepositoryItemGridLookUpEdit）
        /// 设置GridView显示列属性
        /// </summary>
        /// <param name="gridLookUpEdit">行内编辑弹出控件</param>
        /// <param name="list">列属性集合</param>
        /// <param name="dt">数据源</param>
        /// <param name="valueMember">绑定值成员</param>
        /// <param name="displayMember">绑定显示成员</param>
        /// <param name="nullText">空值显示：默认为空字符串</param>
        public static void SetColumns(this RepositoryItemGridLookUpEdit gridLookUpEdit, List<BaseColumnSet> list, DataTable dt = null, string valueMember = "", string displayMember = "", string nullText = "")
        {
            GridView gv = gridLookUpEdit.View;//获取当前控件的GridView
            //DevExpress.XtraGrid.GridControl gridCtrl = gridLookUpEdit.View.GridControl;

            string fieldName = string.Empty;
            for (int i = 0; i < list.Count; i++)
            {
                fieldName = list[i].FieldName;
                gv.Columns.AddField(fieldName);

                if (!string.IsNullOrWhiteSpace(list[i].Name))
                    gv.Columns[fieldName].Name = list[i].Name;

                gv.Columns[fieldName].Caption = list[i].Caption;
                gv.Columns[fieldName].Width = list[i].Width;
                gv.Columns[fieldName].VisibleIndex = list[i].VisibleIndex ?? i;
                gv.Columns[fieldName].Visible = list[i].Visible;
                gv.Columns[fieldName].OptionsColumn.AllowEdit = list[i].AllowEdit;

                if (list[i].formatType != FormatType.None)
                {
                    gv.Columns[fieldName].DisplayFormat.FormatType = list[i].formatType;
                    gv.Columns[fieldName].DisplayFormat.FormatString = list[i].FormatString;
                }

                gv.Columns[fieldName].GroupIndex = list[i].GroupIndex;
                gv.Columns[fieldName].SortOrder = list[i].sortOrder;

                if (list[i].ColumnEdit != null)
                    gv.Columns[fieldName].ColumnEdit = list[i].ColumnEdit;//可编辑列

                if (list[i].AllowMerge != DefaultBoolean.Default)
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = list[i].AllowMerge;//设置合并列
                else
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = DefaultBoolean.False;//设置合并列
            }

            gridLookUpEdit.ValueMember = valueMember;//设置值成员
            gridLookUpEdit.DisplayMember = displayMember;//设置显示成员
            gridLookUpEdit.NullText = nullText;//设置空值显示
            gridLookUpEdit.DataSource = dt;//设置数据源
        }

        /// <summary>
        /// 设置匹配的列
        /// </summary>
        /// <param name="sender">sender</param>
        /// <param name="strList">Filter列名</param>
        public static void FilterLookup(object sender, List<string> strList)
        {
            //Text += " ! ";
            GridLookUpEdit edit = sender as GridLookUpEdit;
            GridView gridView = edit.Properties.View as GridView;
            FieldInfo fi = gridView.GetType().GetField("extraFilter", BindingFlags.NonPublic | BindingFlags.Instance);
            //Text = edit.AutoSearchText;

            List<BinaryOperator> operators = new List<BinaryOperator>();
            foreach (string strColumnName in strList)
            {
                operators.Add(new BinaryOperator(strColumnName, "%" + edit.AutoSearchText + "%", BinaryOperatorType.Like));
            }
            string filterCondition = new GroupOperator(GroupOperatorType.Or, operators.ToArray()).ToString();
            fi.SetValue(gridView, filterCondition);

            MethodInfo mi = gridView.GetType().GetMethod("ApplyColumnsFilterEx", BindingFlags.NonPublic | BindingFlags.Instance);
            mi.Invoke(gridView, null);
        }

        /// <summary>
        /// 设置匹配的列
        /// </summary>
        /// <param name="lookupEditYPDM">RepositoryItemGridLookUpEdit控件</param>
        /// <param name="list">Filter列名</param>
        /// <param name="searchText">当前输入值</param>
        public static void FilterLookup(RepositoryItemGridLookUpEdit lookupEditYPDM, List<string> list, string searchText)
        {
            //GridLookUpEdit edit = sender as GridLookUpEdit;
            GridView gridView = lookupEditYPDM.View as GridView;
            FieldInfo fi = gridView.GetType().GetField("extraFilter", BindingFlags.NonPublic | BindingFlags.Instance);

            List<BinaryOperator> operators = new List<BinaryOperator>();
            foreach (string strColumnName in list)
            {
                operators.Add(new BinaryOperator(strColumnName, "%" + searchText + "%", BinaryOperatorType.Like));
            }
            string filterCondition = new GroupOperator(GroupOperatorType.Or, operators.ToArray()).ToString();
            fi.SetValue(gridView, filterCondition);

            MethodInfo mi = gridView.GetType().GetMethod("ApplyColumnsFilterEx", BindingFlags.NonPublic | BindingFlags.Instance);
            mi.Invoke(gridView, null);
        }
        
        #endregion

        /// <summary>
        /// 行内编辑（弹出RepositoryItemSearchLookUpEdit）
        /// 设置GridView显示列属性
        /// </summary>
        /// <param name="searchLookUpEdit">行内编辑弹出控件</param>
        /// <param name="list">列属性集合</param>
        /// <param name="dt">数据源</param>
        /// <param name="valueMember">绑定值成员</param>
        /// <param name="displayMember">绑定显示成员</param>
        /// <param name="nullText">空值显示：默认为空字符串</param>
        public static void SetColumns(this RepositoryItemSearchLookUpEdit searchLookUpEdit, List<BaseColumnSet> list, DataTable dt = null, string valueMember = "", string displayMember = "", string nullText = "")
        {
            GridView gv = searchLookUpEdit.View;//获取当前控件的GridView

            string fieldName = string.Empty;
            for (int i = 0; i < list.Count; i++)
            {
                fieldName = list[i].FieldName;
                gv.Columns.AddField(fieldName);

                if (!string.IsNullOrWhiteSpace(list[i].Name))
                    gv.Columns[fieldName].Name = list[i].Name;

                gv.Columns[fieldName].Caption = list[i].Caption;
                gv.Columns[fieldName].Width = list[i].Width;
                gv.Columns[fieldName].VisibleIndex = list[i].VisibleIndex ?? i;
                gv.Columns[fieldName].Visible = list[i].Visible;
                gv.Columns[fieldName].OptionsColumn.AllowEdit = list[i].AllowEdit;

                if (list[i].formatType != FormatType.None)
                {
                    gv.Columns[fieldName].DisplayFormat.FormatType = list[i].formatType;
                    gv.Columns[fieldName].DisplayFormat.FormatString = list[i].FormatString;
                }

                gv.Columns[fieldName].GroupIndex = list[i].GroupIndex;
                gv.Columns[fieldName].SortOrder = list[i].sortOrder;

                if (list[i].ColumnEdit != null)
                    gv.Columns[fieldName].ColumnEdit = list[i].ColumnEdit;//可编辑列

                if (list[i].AllowMerge != DefaultBoolean.Default)
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = list[i].AllowMerge;//设置合并列
                else
                    gv.Columns[fieldName].OptionsColumn.AllowMerge = DefaultBoolean.False;//设置合并列
            }

            searchLookUpEdit.ValueMember = valueMember;//设置值成员
            searchLookUpEdit.DisplayMember = displayMember;//设置显示成员
            searchLookUpEdit.NullText = nullText;//设置空值显示
            searchLookUpEdit.DataSource = dt;//设置数据源
        }

        /// <summary>
        /// LookUpEdit扩展方法
        /// 设置LookUpEdit数据源、ValueMember、DiaplayMember
        /// </summary>
        /// <param name="cmb">LookUpEdit控件</param>
        /// <param name="dt">数据源</param>
        /// <param name="valueMember">绑定值成员</param>
        /// <param name="displayMember">绑定显示成员</param>
        public static void LookUpEditExtend(this LookUpEdit cmb, DataTable dt, string valueMember, string displayMember, int widthPopup = 100, int heightPopup = 150, bool showHeader = false, bool showFooter = false)
        {
            cmb.Properties.ValueMember = valueMember;
            cmb.Properties.DisplayMember = displayMember;
            cmb.Properties.DataSource = dt;

            cmb.Properties.PopupSizeable = true;
            cmb.Properties.PopupFormMinSize = new Size(widthPopup, heightPopup);
            cmb.Properties.ShowHeader = showHeader;
            cmb.Properties.ShowFooter = showFooter;
        }

        /// <summary>
        /// 设置LookUpEdit显示列属性
        /// </summary>
        /// <param name="lookupEdit">LookUpEdit</param>
        /// <param name="list">列属性集合</param>
        public static void SetColumns(this LookUpEdit lookupEdit, List<BaseColumnSet> list)
        {
            //string fieldName = string.Empty;
            for (int i = 0; i < list.Count; i++)
            {
                //fieldName = list[i].FieldName;

                DevExpress.XtraEditors.Controls.LookUpColumnInfo lookUpColumn = new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
                {
                    FieldName = list[i].FieldName,
                    Caption = list[i].Caption,
                    Width = list[i].Width,
                    Visible = list[i].Visible,
                    SortOrder = list[i].sortOrder
                };
                if (list[i].formatType != FormatType.None)
                {
                    lookUpColumn.FormatType = list[i].formatType;
                    lookUpColumn.FormatString = list[i].FormatString;
                }

                lookupEdit.Properties.Columns.Add(lookUpColumn);
            }
        }

        /// <summary>
        /// 设置GridLookUpEdit显示列属性
        /// </summary>
        /// <param name="lookupEdit">LookUpEdit</param>
        /// <param name="list">列属性集合</param>
        public static void SetColumns(this GridLookUpEdit lookupEdit, List<BaseColumnSet> list)
        {
            for (int i = 0; i < list.Count; i++)
            {
                DevExpress.XtraGrid.Columns.GridColumn lookUpColumn = new DevExpress.XtraGrid.Columns.GridColumn()
                {
                    FieldName = list[i].FieldName,
                    Caption = list[i].Caption,
                    Width = list[i].Width,
                    Visible = list[i].Visible,
                    SortOrder = list[i].sortOrder
                };

                lookupEdit.Properties.View.Columns.Add(lookUpColumn);
            }
        }

        /// <summary>
        /// GridLookUpEdit扩展方法
        /// 设置GridLookUpEdit数据源、ValueMember、DiaplayMember
        /// </summary>
        /// <param name="cmb">LookUpEdit控件</param>
        /// <param name="dt">数据源</param>
        /// <param name="valueMember">绑定值成员</param>
        /// <param name="displayMember">绑定显示成员</param>
        public static void LookUpEditExtend(this GridLookUpEdit cmb, DataTable dt, string valueMember, string displayMember, int widthPopup = 110, int heightPopup = 150, bool showFooter = false)
        {
            cmb.Properties.ValueMember = valueMember;
            cmb.Properties.DisplayMember = displayMember;
            cmb.Properties.DataSource = dt;

            cmb.Properties.PopupSizeable = true;
            cmb.Properties.PopupFormMinSize = new Size(widthPopup, heightPopup);
            cmb.Properties.PopupFormSize = new Size(widthPopup, heightPopup);
            cmb.Properties.ShowFooter = showFooter;
            
            cmb.Properties.NullValuePrompt = "请选择";
            cmb.Properties.NullValuePromptShowForEmptyValue = true;
            cmb.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
            cmb.Properties.ImmediatePopup = true;
        }

    }

 

简单调用样例

1、


            DataTable dtQYYF = clientCommon.GetMZYF();

            cmbQYYF.Properties.Columns.Clear();
            List<BaseColumnSet> listQYYF = new List<BaseColumnSet>();
            listQYYF.Add(new BaseColumnSet() { FieldName = "YFDM", Caption = "代码", Visible = false });
            listQYYF.Add(new BaseColumnSet() { FieldName = "YFMC", Caption = "名称", Visible = true });
            cmbQYYF.SetColumns(listQYYF);

            cmbQYYF.LookUpEditExtend(dtQYYF, "YFDM", "YFMC");
            if (dtQYYF.Rows.Count > 0)
                cmbQYYF.EditValue = dtQYYF.Rows[0]["YFDM"];

2、
 


            dtGYFS = clientCommon.GetGYFS();//获取给药方式数据
            RepositoryItemGridLookUpEdit lookupEditGYFS = new RepositoryItemGridLookUpEdit();
            List<BaseColumnSet> listGYFS = new List<BaseColumnSet>();
            listGYFS.Add(new BaseColumnSet() { FieldName = "YPYFMC", Caption = "**方式", Width = 100, AllowEdit = false });

            lookupEditGYFS.SetColumns(listGYFS, dtGYFS, "YPYFDM", "YPYFMC", "请选择");
            lookupEditGYFS.TextEditStyle = TextEditStyles.Standard;
            lookupEditGYFS.PopupFormSize = new Size(100, 200);
            lookupEditGYFS.ImmediatePopup = true;
            //lookupEditGYFS.PopupFilterMode = PopupFilterMode.Contains;
            //lookupEditGYFS.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            lookupEditGYFS.EditValueChanging += LookupEditGYFS_EditValueChanging;
            listWestPrescription.Add(new BaseColumnSet() { FieldName = "GYFS", Caption = "**方式", Width = 80, ColumnEdit = lookupEditGYFS, VisibleIndex = 7 });

3、
 


            RepositoryItemGridLookUpEdit lookupEditYPDM = new RepositoryItemGridLookUpEdit();
            #region 弹出设置列
            List<BaseColumnSet> listPopup = new List<BaseColumnSet>();
            listPopup.Add(new BaseColumnSet() { FieldName = "YPMC", Caption = "名称", Width = 200, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "PYDM", Caption = "拼音码", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "GG", Caption = "规格", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "LSJ", Caption = "***", Width = 80, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "SL", Caption = "**", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "PC", Caption = "**", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "PH", Caption = "**", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "CDMC", Caption = "****", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "YBBZ", Caption = "****", Width = 60, AllowEdit = false });

            listPopup.Add(new BaseColumnSet() { FieldName = "YPLX", Caption = "***", Width = 60, AllowEdit = false });
            listPopup.Add(new BaseColumnSet() { FieldName = "BXBZ", Caption = "****", Width = 60, AllowEdit = false });
            #endregion

            lookupEditYPDM.SetColumns(listPopup, dtYPDM, "YPDM", "YPMC", "");
            lookupEditYPDM.TextEditStyle = TextEditStyles.Standard;
            lookupEditYPDM.PopupFormSize = new Size(500, 200);
            lookupEditYPDM.ImmediatePopup = true;
            //lookupEditYPDM.PopupFilterMode = PopupFilterMode.Contains;
            //lookupEditYPDM.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            lookupEditYPDM.CustomDisplayText += LookupEditYPDM_CustomDisplayText;//因为列表中只有部分药品数据，故需修改显示内容
            lookupEditYPDM.EditValueChanging += LookupEditYPDM_EditValueChanging;

            listWestPrescription.Add(new BaseColumnSet() { FieldName = "YPDM", Caption = "名称", Width = 200, ColumnEdit = lookupEditYPDM, VisibleIndex = 3 });

 

事件


            gv_West.OptionsMenu.EnableColumnMenu = false;
            //gv_WestPrescription.OptionsView.AllowCellMerge = false;//合并单元格（AllowCellMerge）和复选框（MultiSelectMode）不能同时用
            gv_West.OptionsSelection.MultiSelect = true;
            gv_West.OptionsSelection.ShowCheckBoxSelectorInColumnHeader = DevExpress.Utils.DefaultBoolean.True;
            gv_West.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CheckBoxRowSelect;
            gv_West.OptionsSelection.CheckBoxSelectorColumnWidth = 45;//设置宽度
            gv_West.CellValueChanging += Gv_West_CellValueChanging;
            gv_West.FocusedRowChanged += Gv_West_FocusedRowChanged;

            gv_West.OptionsCustomization.AllowColumnMoving = false;//设置列不可移动
            gv_West.OptionsView.ColumnAutoWidth = false;//取消列自适应宽度
            gv_West.ShowingEditor += Gv_West_ShowingEditor;

        /// <summary>
        /// 设置LookUpEditYPDM显示内容
        /// </summary>
        private void LookupEditYPDM_CustomDisplayText(object sender, CustomDisplayTextEventArgs e)
        {
            if (string.IsNullOrWhiteSpace(e.DisplayText))
            {
                foreach (DataRow dr in dtWestDataSource.Rows)
                {
                    if (dr["YPDM"].ToString() == e.Value.ToString())
                        e.DisplayText = dr["YPMC"].ToString();
                }
            }
        }

        /// <summary>
        /// 设置行数据，不可修改
        /// </summary>
        private void Gv_West_ShowingEditor(object sender, CancelEventArgs e)
        {
            DataRow dr = gv_West.GetDataRow(gv_West.FocusedRowHandle);

            if (dr != null)
            {
                if (dr["CFZTMC"].ToString() == "提交")
                    e.Cancel = true;
            }
        }

        #region 行内编辑事件及设置数据源
        /// <summary>
        /// 单元格值改变事件
        /// </summary>
        private void Gv_West_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            switch (e.Column.FieldName)
            {
                case "YPDM": RepositoryItem_SelectYPXX(e); break;
                //case "GYFS": RepositoryItem_SelectGYFS(e); break;
                //case "GYPL": RepositoryItem_SelectGYPL(e); break;
                //case "YSZT": RepositoryItem_SelectYSZT(e); break;
                case "SL": JudgeKCL("SL", sender, e); break;
                case "TS": JudgeKCL("TS", sender, e); break;
                default: break;
            }
        }

        /// <summary>
        /// 选择**
        /// </summary>
        /// <param name="e"></param>
        private void RepositoryItem_SelectYPXX(DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            RepositoryItemGridLookUpEdit lookupEditYPDM = gv_West.Columns["YPDM"].ColumnEdit as RepositoryItemGridLookUpEdit;

            if (lookupEditYPDM.GetRowByKeyValue(e.Value) != null)//选中项不为空，设置当前行的值；选中项为空，重新根据输入值加载下拉面板的值；
            {
                DataRow dr = ((DataRowView)lookupEditYPDM.GetRowByKeyValue(e.Value)).Row;
                #region 设置当前行数据
                gv_West.SetRowCellValue(e.RowHandle, "YPDM", dr["YPDM"]);
                gv_West.SetRowCellValue(e.RowHandle, "YPMC", dr["YPMC"]);
                gv_West.SetRowCellValue(e.RowHandle, "JL", dr["DEFAULT_JL"]);
                gv_West.SetRowCellValue(e.RowHandle, "JLDW", dr["JLDW"]);
                gv_West.SetRowCellValue(e.RowHandle, "GG", dr["GG"]);
                gv_West.SetRowCellValue(e.RowHandle, "SL", 0);
                string zybzStr = GetZYBZ();
                gv_West.SetRowCellValue(e.RowHandle, "ZYBZ", zybzStr);
                gv_West.SetRowCellValue(e.RowHandle, "SXH", "1");
                gv_West.SetRowCellValue(e.RowHandle, "LSJ", dr["LSJ"]);//***
                gv_West.SetRowCellValue(e.RowHandle, "KCL", dr["SL"]);//***
                gv_West.SetRowCellValue(e.RowHandle, "DW", dr["DW"].ToString());
                gv_West.SetRowCellValue(e.RowHandle, "YPYF", dr["DEFAULT_YF"]);//**

                string ts = txtTS.EditValue.ToString();
                gv_West.SetRowCellValue(e.RowHandle, "TS", ts);

                gv_West.SetRowCellValue(e.RowHandle, "MZDW", dr["MZDW"].ToString());
                gv_West.SetRowCellValue(e.RowHandle, "MZDJ", dr["MZDJ"]);
                gv_West.SetRowCellValue(e.RowHandle, "CDDM", dr["CDDM"]);
                gv_West.SetRowCellValue(e.RowHandle, "PC", dr["PC"]);
                gv_West.SetRowCellValue(e.RowHandle, "PH", dr["PH"]);
                gv_West.SetRowCellValue(e.RowHandle, "PS", dr["SFPS"]);
                gv_West.SetRowCellValue(e.RowHandle, "SYZ", "1");
                gv_West.SetRowCellValue(e.RowHandle, "BXBZ", dr["BXBZ"]);
                gv_West.SetRowCellValue(e.RowHandle, "SFBL", dr["SFBL"]); //****
                gv_West.SetRowCellValue(e.RowHandle, "MZBL", dr["MZBL"]);

                #endregion
            }
            else if (e.Value != null && !string.IsNullOrWhiteSpace(e.Value.ToString()))
            {
                //根据当前输入内容，重新获取药品数据源，需去掉当前控件的查询功能，让当前控件的面板弹出
                //DataTable dtYPXX = GetYPXX(e.Value.ToString());
                //lookupEditYPDM.DataSource = dtYPXX;

                //此处数据源设置完，lookupEditYPDM.View.DataSource依然为空，故显示结果为空
            }
        }

        /// <summary>
        /// 焦点行改变事件
        /// </summary>
        private void Gv_West_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
        {
            ShowCFInfo();
        }

        /// <summary>
        /// 获取****
        /// </summary>
        /// <returns>1**；0***</returns>
        private string GetZYBZ()
        {
            string result = "1";//1**；0***
            DataTable dt = gridCtrlWest.DataSource as DataTable;

            if (dt == null)
            {
                return result;
            }

            foreach (DataRow dr in dt.Rows)
            {
                if (dr["CFZTMC"].ToString() == "开单")
                {
                    return "0";//1**；0***
                }
                else if (string.IsNullOrWhiteSpace(dr["CFZTMC"].ToString()) && dr["ZYBZ"].ToString() == "1")
                {
                    return "0";//1**；0***
                }
            }

            return result;
        }

        private void LookupEditYPDM_EditValueChanging(object sender, ChangingEventArgs e)
        {
            this.BeginInvoke(new System.Windows.Forms.MethodInvoker(delegate
            {
                CtrlSetCommon.FilterLookup(sender, new List<string>() { "PYDM", "YPMC", "YPDM" });
            }));
        }

        private void LookupEditGYFS_EditValueChanging(object sender, ChangingEventArgs e)
        {
            this.BeginInvoke(new System.Windows.Forms.MethodInvoker(delegate
            {
                CtrlSetCommon.FilterLookup(sender, new List<string>() { "PYDM", "YPYFDM", "YPYFMC" });
            }));
        }

        private void LookupEditGYPL_EditValueChanging(object sender, ChangingEventArgs e)
        {
            this.BeginInvoke(new System.Windows.Forms.MethodInvoker(delegate
            {
                CtrlSetCommon.FilterLookup(sender, new List<string>() { "PYDM", "BDDM", "BDMC" });
            }));
        }

        /// <summary>
        /// 判断***
        /// </summary>
        private void JudgeKCL(string columnName, object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            DataRow dr = (gv_West.GetRow(e.RowHandle) as DataRowView).Row;
            string strSL = dr["SL"] == null ? "0" : dr["SL"].ToString();//**
            string strTS = dr["TS"] == null ? "0" : dr["TS"].ToString();//**
            string strKCL = dr["KCL"] == null ? "0" : dr["KCL"].ToString();//***
            string currentValue = (e.Value == null || string.IsNullOrEmpty(e.Value.ToString())) ? "0" : e.Value.ToString();

            int slInt = 0, tsInt = 0, kclInt = 0;
            int.TryParse(strSL, out slInt);
            int.TryParse(strTS, out tsInt);
            int.TryParse(strKCL, out kclInt);


            if (columnName == "SL")
                slInt = int.Parse(currentValue);
            else if (columnName == "TS")
                tsInt = int.Parse(currentValue);

            if (slInt * tsInt > kclInt)
            {
                XtraMessageBox.Show("当前**下的****不能大于***" + strKCL + " ,请修改此行" + (columnName == "TS" ? "**" : "**") + "!", "提醒", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

            ShowCFInfo();
        }

        #endregion

 

//Annotation
关注
专栏目录
Devexpress:在GridControl中使用RepositoryItemGridLookUpEdit
07-27 6797
RepositoryItemGridLookUpEdit 用于在GridControl中指定一列为多列数据下拉框，选择的之后只显示指定的列。 定义名为TestModel类： public class TestModel { public int Id { get; set; } public string Name { get; set; }
devexpress gridview RepositoryItem
weixin_30666401的博客
07-25 379
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit edit = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit(); 该列设置 col.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButt...
(自学日记)DevExpress GridView单元格输入值时弹出筛选列表，RepositoryItemGridLookUpEdit修改查询的列标题名
最新发布
qq_40055116的博客
09-10 347
绑定的表显示英文，将表头名改成中文。
gridLookUpEdit字典控件 模糊查询
Nemo的笔记本
11-27 399
this.gridLookUpEdit1.Properties.DataSource = dt; this.gridLookUpEdit1.Properties.DisplayMember = dt.Columns[2].ColumnName; this.gridLookUpEdit1.Properties.ValueMember = dt.Columns[0].ColumnName;
dev gridcontrol使用 repositoryItemGridLookUpEdit 实现多列模糊搜索
weixin_41566437的博客
04-12 470
步骤1，设置repositoryItemGridLookUpEdit的控件。效果如图：实现按药品名称和检索码搜索。
DEV RepositoryItem控件绑定 CheckedComboBoxEdit
weixin_30640291的博客
05-21 308
尝试在Treelist中绑定RepositoryItemCheckedComboBoxEdit控件，结果会绑定数据，却不知道如何返回数据了，反复了几天。 因为本需求比较奇葩(下拉框值都不一样，显示值与真实值不一样)，最后使用动态绑定控件的办法解决的。 也可以不动态绑定控件，但是如果那样的话，CheckedComboBoxEdit控件的下拉框的所有选项都是一样的。 而这里要求每一行的...
dev repositoryItem 手工定义
weixin_34044273的博客
09-03 258
一、打开设计界面 二、定义Repository 事件定义 三、把repositoryItemTextEdit1邦定存在的列 转载于:https://www.cnblogs.com/lhyqzx/p/5836302.html
dev_GridView多表头合并.rar
04-17
在.NET开发领域，GridView控件是ASP.NET Web Forms中常用的一种数据展示组件，它能够方便地将数据库中的数据以表格的形式展示出来。本教程重点讨论如何实现“dev_GridView”多表头合并，以创建更复杂的二维表头，...
Android中ScrollView嵌套GridView显示不全解决方法
08-30
以上就是解决Android中ScrollView嵌套GridView显示不全的一些常见方法。实际开发中，开发者需要根据项目需求和性能要求选择合适的方法。记得在实现解决方案时，考虑到用户体验和性能优化，避免无谓的数据加载和计算...
C#中GridView动态添加列的实现方法
01-20
本文实例讲述了C#中GridView动态添加列的实现方法。分享给大家供大家参考。具体如下： protected void Page_Load(object sender, EventArgs e) { TemplateField mycustomField = new TemplateField(); //创建列...
DevExpress中的repositoryItemComboBox控件得到索引值和选项值
11-21
DevExpress中的repositoryItemComboBox控件得到索引值和选项值
DevExpress ,XtraGrid,GridControl,Gridview 使用点滴
weixin_34345560的博客
09-18 219
1.在单元里显示日历控件、下拉框等 Imports DevExpress.XtraEditors.Repository Dim irdata As New RepositoryItemCalcEdit GridView1.Columns(1).ColumnEdit = irdata 2.格式化数字 ###,###.00 GridView1.Columns(...
DEV动态显示RepositoryItemButtonEdit的显示值
liuruxi622的专栏
05-06 2977
最近项目中遇到一个需求，需要根据GridView不同行的状态显示不同的操作，也就是要动态设置不同的按钮，最后找到如下方法： private void gvHome_CustomRowCellEdit(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e) ...
Dev LookUpEdit RepositoryItemLookUpEdit 下拉框数据过滤(或智能提示)
weixin_43253848的博客
11-30 1455
LookUpEdit.DisplayMember //这是设置绑定数列,要过滤的数据 LookUpEdit.ValueMember //这是绑定的数据 LookUpEdit.DataSource //绑定的数据源 lookUpEdit.Columns //显示的绑定数据源,要显示的列 LookUpEdit.ImmediatePopup //设置输入数据后是否立即显示下拉框 LookUpEdit.PopupFiliterMode
DevExpress的GridView，为每行动态绑定不同的RepositoryItemLookUpEdit
dhf70263的博客
09-08 1352
有时需要动态为RepositoryItemLookUpEdit绑定数据源，比如联动选择的场景或者我们仅仅是需要一个下拉选择框而并不想要GridView的列与RepositoryItemLookUpEdit的数据源有强绑定关系。但是GridView的列在绑定事先定义RepositoryItemLookUpEdit后是针对所有行生效的。基于以上原因，使得在中途如果再为RepositoryIt...
repositoryItemGridLookUpEdit编辑绑定
qq_22965011的博客
11-26 1513
/// <summary> /// 初始化其他原因下拉菜单 /// </summary> private void InitRepositoryItemQtyy() { DataTable dt = WebServiceHelp.Instance.selectDict("{\"TABLE_NO\":\"266\"}");...
关于获取Gridcontrol中repositoryItemLookUpEdit的使用
u011871201的博客
09-07 9482
//直接上源码 private void lupUser_EditValueChanged ( object sender ,System . EventArgs e ) { DevExpress . XtraEditors . BaseEdit edit = gridView1 . ActiveEditor; switch ( g
RepositoryItemLookUpEdit
weixin_33811539的博客
03-11 1191
在GridControl使用RepositoryItemLookUpEdit控件,发现选择没有得到值,要注意对应的ValueMember绑定的字段信息,应该于数据库字段大小写一致. 转载于:https://blog.51cto.com/lybing/1372499...
ASP.NET GridView中实现RadioButton单选的三种方法
"ASP.NET GridView中使用RadioButton单选按钮的方法" 在ASP.NET开发中，GridView是一个非常常用的数据展示控件，它可以方便地显示和操作数据。在某些场景下，我们可能需要在GridView的每一行中添加单选按钮，让用户...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值