c# 列显示设置

c# MES

private void button3_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)gridControl1.DataSource;
    if (dt == null)
    {
        MessageBox.Show("请先获取数据！", "系统提示");
        return;
    }
    string strPage = "MES_BR_" + strFuncNumber2;
    DataTable dtStyle = new DataTable();
    dtStyle.Columns.Add("序号", typeof(int));
    dtStyle.Columns.Add("列名", typeof(string));
    dtStyle.Columns.Add("列宽", typeof(decimal));
    dtStyle.Columns.Add("显示", typeof(bool));
    dtStyle.Columns.Add("显示名称", typeof(string));
    dtStyle.Columns.Add("是否固定列", typeof(bool));
    DynWebService BHWS = new DynWebService();
    DataTable dtPF = BHWS.GetPageSet(MyHelper.strVerify, MyHelper.strIP, "B-LPrint", "MES", strPage);
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        DataRow dr = dtStyle.NewRow();
        dr[0] = gridView1.Columns[dt.Columns[i].ColumnName].VisibleIndex;
        dr[1] = dt.Columns[i].ColumnName;
        dr[2] = gridView1.Columns[dt.Columns[i].ColumnName].Width;
        dr[3] = gridView1.Columns[dt.Columns[i].ColumnName].Visible;
        dr[4] = gridView1.Columns[dt.Columns[i].ColumnName].Caption == "" ? dt.Columns[i].ColumnName : gridView1.Columns[dt.Columns[i].ColumnName].Caption;
        dr[5] = gridView1.Columns[dt.Columns[i].ColumnName].Fixed == DevExpress.XtraGrid.Columns.FixedStyle.None ? false : true;
        dtStyle.Rows.Add(dr);
    }
    frmPageSet PS = new frmPageSet(strPage, dtStyle);
    PS.ShowDialog();
}

c# BMS
方法

private void toolStripMenuItem20_Click(object sender, EventArgs e)
{
    DataTable dt = (DataTable)gridControl1.DataSource;
    if (dt == null)
    {
        MessageBox.Show("请先获取数据！", "系统提示");
        return;
    }
    string strPage = "BR_QS";
    DataTable dtStyle = new DataTable();
    dtStyle.Columns.Add("序号", typeof(int));
    dtStyle.Columns.Add("列名", typeof(string));
    dtStyle.Columns.Add("列宽", typeof(decimal));
    dtStyle.Columns.Add("显示", typeof(bool));
    dtStyle.Columns.Add("显示名称", typeof(string));
    dtStyle.Columns.Add("是否固定列", typeof(bool));
    DynWebService BHWS = new DynWebService();
    DataTable dtPF = BHWS.GetPageSet(MyHelper.strVerify, MyHelper.strIP, "B-LPrint", MyHelper.strUser, strPage);
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        DataRow dr = dtStyle.NewRow();
        dr[0] = gridView1.Columns[dt.Columns[i].ColumnName].VisibleIndex;
        dr[1] = dt.Columns[i].ColumnName;
        dr[2] = gridView1.Columns[dt.Columns[i].ColumnName].Width;
        dr[3] = gridView1.Columns[dt.Columns[i].ColumnName].Visible;
        dr[4] = gridView1.Columns[dt.Columns[i].ColumnName].Caption == "" ? dt.Columns[i].ColumnName : gridView1.Columns[dt.Columns[i].ColumnName].Caption;
        dr[5] = gridView1.Columns[dt.Columns[i].ColumnName].Fixed == DevExpress.XtraGrid.Columns.FixedStyle.None ? false : true;
        dtStyle.Rows.Add(dr);
    }
    frmPageSet PS = new frmPageSet(strPage, dtStyle);
    PS.ShowDialog();
}

查询中调用列显示设置（设置界面）

                    for (int i = 0; i < gridView1.Columns.Count; i++)
                    {
                        gridView1.Columns[i].OptionsColumn.AllowEdit = false;
                    }
                    if (gridView1.Columns.Contains(gridView1.Columns["选择"])) gridView1.Columns["选择"].OptionsColumn.AllowEdit = true;
                    if (gridView1.Columns.Contains(gridView1.Columns["选择"])) gridView1.Columns["选择"].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
                    //获取页面设置
                    DataTable dtPF = BHWS.GetPageSet(MyHelper.strVerify, MyHelper.strIP, "B-LPrint", MyHelper.strUser, "BR_QS");
                    if (dtPF.Rows.Count > 0)
                    {
                        for (int i = 0; i < dtPF.Rows.Count; i++)
                        {
                            string strcol = dtPF.Rows[i]["列名"].ToString();
                            if (gridView1.Columns.Contains(gridView1.Columns[strcol]))
                            {
                                gridView1.Columns[strcol].VisibleIndex = Convert.ToInt32(dtPF.Rows[i]["序号"]);
                                gridView1.Columns[strcol].Width = Convert.ToInt32(dtPF.Rows[i]["列宽"]);
                                gridView1.Columns[strcol].Visible = Convert.ToBoolean(dtPF.Rows[i]["显示"]);
                                gridView1.Columns[strcol].Caption = Convert.ToString(dtPF.Rows[i]["显示名称"]);
                                if (Convert.ToString(dtPF.Rows[i]["是否固定列"]) == "True") gridView1.Columns[strcol].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
                            }
                        }
                    }
                    else
                    {
                        gridView1.BestFitColumns();
                    }
                    if (dt.Rows.Count < 1000)
                        gridView1.IndicatorWidth = 35;
                    if (dt.Rows.Count >= 1000)
                        gridView1.IndicatorWidth = 40;
                    if (dt.Rows.Count >= 10000)
                        gridView1.IndicatorWidth = 50;
                    if (dt.Rows.Count >= 100000)
                        gridView1.IndicatorWidth = 60;

跳转列设置窗口c#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace BHBMS
{
    public partial class frmPageSet : Form
    {
        private string strPage2 = "";
        public frmPageSet(string strPage,DataTable dtStyle)
        {
            InitializeComponent();
            strPage2 = strPage;
            gridControl1.DataSource = dtStyle;
            gridView1.Columns["列名"].OptionsColumn.AllowEdit = false;
            gridView1.Columns["是否固定列"].BestFit();
        }
        //保存
        private void toolStripMenuItem3_Click(object sender, EventArgs e)
        {
            gridView1.CloseEditor();
            gridView1.UpdateCurrentRow();
            try
            {
                DataTable dt = (DataTable)gridControl1.DataSource;
                dt.TableName = "Page";
                DynWebService BHWS = new DynWebService();
                string[] strReturn = BHWS.SavePageSet(MyHelper.strVerify, MyHelper.strIP, "BMS", MyHelper.strUser, strPage2, dt);
                if (strReturn[0] != "成功")
                {
                    MessageBox.Show("保存失败！" + strReturn[1] + "", "系统提示");
                    return;
                }
                else
                {
                    MessageBox.Show("保存成功，请重新打开页面！", "系统提示");
                    this.DialogResult = DialogResult.OK;
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("程序发生错误：" + ex.Message + "，请重新操作！", "系统提示");
                return;
            }
        }
        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;
            this.Close();
        }
    }
}