修改了报表设计器

lu

2024-10-23 bd06bb837fa0c7edeeae56cb0fe4fb844f53fb2f

 DevApp/Gs.DevApp/DevFrm/User/Role.cs

@@ -1,20 +1,19 @@
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Windows.Forms;

namespace Gs.DevApp.DevFrm.User
{
    //https://www.cnblogs.com/mkmkbj/p/16771297.html
    //https://blog.csdn.net/m0_54035969/article/details/140716675
    public partial class Role : DevExpress.XtraEditors.XtraForm
    {
        System.Text.StringBuilder actionLst = new System.Text.StringBuilder();
        System.Text.StringBuilder _actionLst = new System.Text.StringBuilder();
        List<FilterEntity> _filterList = new List<FilterEntity>();
        public Role()
        {
            InitializeComponent();
@@ -25,11 +24,27 @@
            this.toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick1;
            this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick;
            this.toolBarMenu1.btnRoleClick += ToolBarMenu1_btnRoleClick;
            this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
            gcMain.MouseDoubleClick += GcMain_MouseDoubleClick;
            gridView1.FocusedRowChanged += GridView1_FocusedRowChanged;
            pageBar1.PagerEvent += PageBar1_PagerEvent;
            getPageList(1, UtilityHelper.GetPageSize());
            pageBar1.PagerEvent += PageBar1_PagerEvent;
            trv.AfterCheck += Trv_AfterCheck;
            gridView1.IndicatorWidth = 50;
            gridView1.CustomDrawRowIndicator += (s, e) =>
            {
                if (e.Info.IsRowIndicator && e.RowHandle >= 0)
                {
                    e.Info.DisplayText = (e.RowHandle + 1).ToString();
                }
            };
            gridView1.CustomDrawEmptyForeground += (s, e) =>
            {
                string str = "暂未查找到匹配的数据!";
                Font f = new Font("微软雅黑", 16);
                Rectangle r = new Rectangle(gridView1.GridControl.Width / 2 - 100, e.Bounds.Top + 45, e.Bounds.Right - 5, e.Bounds.Height - 5);
                e.Graphics.DrawString(str, f, Brushes.Gray, r);
            };
        }
        /// <summary>
        /// 换切换事件
@@ -40,6 +55,7 @@
        {
            string rowGuid = "";
            DataRow myDataRow = gridView1.GetDataRow(e.FocusedRowHandle);
            if (myDataRow == null) return;
            rowGuid = myDataRow["guid"].ToString();
            getTree(rowGuid);
            groupBox1.Text = "请勾选【" + myDataRow["roleName"].ToString() + "】的权限";
@@ -51,20 +67,10 @@
        /// <param name="e"></param>
        private void GcMain_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            GridHitInfo info = gridView1.CalcHitInfo(e.Location);
            if (info.InRow)
            {
                GridView view = info.View as GridView;
                if (view != null)
                {
                    DataRow row = view.GetDataRow(info.RowHandle);
                    if (row != null)
                    {
                        string rowGuid = (row["guid"].ToString());
                        getModel(rowGuid, false, 999);
                    }
                }
            }
            string rowGuid = Gs.DevApp.ToolBox.UtilityHelper.GetCurrentDoubleRow(gridView1, e, "guid");
            if (!string.IsNullOrEmpty(rowGuid))
                getModel(rowGuid, false, 999);

        }
        /// <summary>
        /// 分页事件
@@ -76,13 +82,35 @@
            getPageList(curPage, pageSize);
        }
        /// <summary>
        /// 查询事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
        {
            Gs.DevApp.UserControl.ShowFilter frm = new Gs.DevApp.UserControl.ShowFilter(gridView1.Columns, _filterList);
            frm.UpdateParent += Frm_UpdateParent;
            frm.ShowDialog();
        }
        /// <summary>
        /// 查询回调
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
        {
            _filterList = e.FilterList;
            getPageList(1, pageBar1.RowsCount);
        }

        /// <summary>
        /// 取消事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ToolBarMenu1_btnEscClick(object sender, EventArgs e)
        {
            UtilityHelper.ChangeTab(xtraTabControl1, 0);
            UtilityHelper.JumpToTab(xtraTabControl1, 0);
        }
        /// <summary>
        /// 删除事件
@@ -91,26 +119,25 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e)
        {
            DataRow dr = gridView1.GetFocusedDataRow();
            if (dr == null || string.IsNullOrEmpty(dr["guid"].ToString()))
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_roleName, gridView1, 2);
            if (string.IsNullOrEmpty(rowGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
                return;
            }
            if (!MsgHelper.AskQuestion("你选择了【" + dr["roleName"].ToString() + "】，确定删除吗？\n该操作将会清空相应的用户权限"))
            if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定删除吗？\n该操作将会清空相应的用户权限"))
                return;
            var _obj = new
            {
                guid = dr["guid"].ToString(),//主建
            };
            string strJson = "";
            List<string> lst = new List<string>();
            lst.Add(rowGuid);
            var _obj = lst;
            try
            {
                strJson = UtilityHelper.HttpPost("", "Role/DeleteModel", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
                string strJson = UtilityHelper.HttpPost("", "Role/DeleteModel", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                if (_rtn.rtnCode > 0)
                {
                    UtilityHelper.ChangeTab(xtraTabControl1, 0);
                    UtilityHelper.JumpToTab(xtraTabControl1, 0);
                    getPageList(1, UtilityHelper.GetPageSize());
                }
                ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
@@ -127,7 +154,7 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
        {
            UtilityHelper.ChangeTab(xtraTabControl1, 0);
            UtilityHelper.JumpToTab(xtraTabControl1, 0);
            getPageList(1, UtilityHelper.GetPageSize());
        }
        /// <summary>
@@ -137,14 +164,14 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e)
        {
            DataRow dr = gridView1.GetFocusedDataRow();
            if (dr == null || string.IsNullOrEmpty(dr["guid"].ToString()))
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_roleName, gridView1);
            if (string.IsNullOrEmpty(rowGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
                return;
            }
            getModel(dr["guid"].ToString(), true, 1);

            getModel(rowGuid, true, 1);
        }
        /// <summary>
        /// 新增事件
@@ -153,9 +180,9 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnAddClick(object sender, EventArgs e)
        {
            UtilityHelper.ChangeTab(xtraTabControl1, 1);
            UtilityHelper.JumpToTab(xtraTabControl1, 1);
            lbGuid.Text = "";
            UtilityHelper.CleanValue(this.panel1.Controls, true);
            UtilityHelper.CleanValueByControl(this.panel1.Controls, true);
        }
        /// <summary>
        /// 保存事件
@@ -171,35 +198,30 @@
                txt_roleName.Focus();
                return;
            }
            if (string.IsNullOrEmpty(txt_rolRemark.Text.Trim()))
            if (string.IsNullOrEmpty(txt_roleRemark.Text.Trim()))
            {
                Gs.DevApp.ToolBox.MsgHelper.Warning("角色备注不能为空！");
                txt_rolRemark.Focus();
                return;
            }
            if (txt_status.SelectedIndex <= 0)
            {
                Gs.DevApp.ToolBox.MsgHelper.Warning("角色状态不能为空！");
                txt_status.Focus();
                txt_roleRemark.Focus();
                return;
            }
            var _obj = new
            {
                guid = lbGuid.Text.Trim(),
                roleName = txt_roleName.Text.Trim(),
                rolRemark = txt_rolRemark.Text.Trim(),
                status = txt_status.SelectedIndex,//状态
                roleRemark = txt_roleRemark.Text.Trim(),
                isStatus = txt_isStatus.Checked,//状态
            };
            try
            {
                string strJson = UtilityHelper.HttpPost("", "Role/EditModel", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
                if (_rtn.rtnCode > 0)
                {
                    lbGuid.Text = _rtn.rtnData;
                    toolBarMenu1.isSetBtn = true;
                    UtilityHelper.ChangeEnable(this.panel1.Controls, false);
                    UtilityHelper.ChangeEnableByControl(this.panel1.Controls, false);

                }
            }
            catch (Exception ex)
@@ -215,25 +237,26 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnRoleClick(object sender, EventArgs e)
        {
            DataRow dr = gridView1.GetFocusedDataRow();
            if (dr == null || string.IsNullOrEmpty(dr["guid"].ToString()))
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_roleName, gridView1);
            if (string.IsNullOrEmpty(rowGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
                return;
            }
            if (!MsgHelper.AskQuestion("你选择了【" + dr["roleName"].ToString() + "】，确定设置权限吗？"))
            if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定设置权限吗？"))
                return;
            actionLst = new System.Text.StringBuilder();
            _actionLst = new System.Text.StringBuilder();
            TraverseTreeViewNodes(trv.Nodes);
            var _obj = new
            {
                roleGuid = dr["guid"].ToString(),
                actionLst = actionLst.ToString(),
                roleGuid = rowGuid,
                actionLst = _actionLst.ToString(),
            };
            try
            {
                string strJson = UtilityHelper.HttpPost("", "MenuAction/SetMenuActionByRole", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
                string strJson = UtilityHelper.HttpPost("", "Role/SetRoleMenuAction", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnData.outMsg);
            }
            catch (Exception ex)
@@ -249,12 +272,17 @@
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage, int pageSize)
        {
            PageQueryModel pgq = new PageQueryModel(curPage, pageSize, "createDate", "asc", "", "");
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            foreach (FilterEntity itm in _filterList)
            {
                _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
            }
            PageQueryModel pgq = new PageQueryModel(curPage, pageSize, "CREATE_TIME", "desc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try
            {
                string strReturn = UtilityHelper.HttpPost("", "Role/GetListPage", json);
                ReturnModel<PageListModel> dd = UtilityHelper.GetTableByJson(strReturn);
                ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn);
                DataTable dt = dd.rtnData.list;
                gcMain.BindingContext = new BindingContext();
                gcMain.DataSource = dt;
@@ -278,7 +306,7 @@
                ToolBox.MsgHelper.Warning("请先选择你要操作的行！");
                return;
            }
            UtilityHelper.ChangeTab(xtraTabControl1, tabIdx);
            UtilityHelper.JumpToTab(xtraTabControl1, tabIdx);
            var _obj = new
            {
                guid = strGuid,//主建
@@ -287,7 +315,7 @@
            try
            {
                strJson = UtilityHelper.HttpPost("", "Role/GetModel", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                if (_rtn.rtnCode > 0)
                {
                    dynamic dy = _rtn.rtnData;
@@ -315,11 +343,10 @@
            {
                roleGuid = roleGuid,//主建
            };
            string strReturn = "";
            try
            {
                strReturn = UtilityHelper.HttpPost("", "MenuAction/GetListByRole", JsonConvert.SerializeObject(_obj));
                ReturnModel<PageListModel> dd = UtilityHelper.GetTableByJson(strReturn);
                string strReturn = UtilityHelper.HttpPost("", "Role/GetListByRole", JsonConvert.SerializeObject(_obj));
                ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn);
                DataTable dt = dd.rtnData.list;
                DataRow[] drGrp = dt.Select("upGuid='' or upGuid is null");
                foreach (DataRow _dy in drGrp)
@@ -374,7 +401,9 @@
        {
            try
            {
                trv.AfterCheck -= Trv_AfterCheck;
                UtilityHelper.TreeViewCheck(e);
                trv.AfterCheck += Trv_AfterCheck;
            }
            catch (Exception ex)
            {
@@ -387,7 +416,7 @@
            foreach (TreeNode node in nodes)
            {
                if (node.Checked)
                    actionLst.Append(node.Name + "~");
                    _actionLst.Append(node.Name + "~");
                // 递归遍历子节点
                if (node.Nodes.Count > 0)
                {