From bd06bb837fa0c7edeeae56cb0fe4fb844f53fb2f Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期三, 23 十月 2024 16:42:34 +0800
Subject: [PATCH] 修改了报表设计器
---
DevApp/Gs.DevApp/DevFrm/User/Role.cs | 208 ++++++++++++++++++++++++++++++---------------------
1 files changed, 123 insertions(+), 85 deletions(-)
diff --git a/DevApp/Gs.DevApp/DevFrm/User/Role.cs b/DevApp/Gs.DevApp/DevFrm/User/Role.cs
index 1d4fe54..b663200 100644
--- a/DevApp/Gs.DevApp/DevFrm/User/Role.cs
+++ b/DevApp/Gs.DevApp/DevFrm/User/Role.cs
@@ -1,18 +1,19 @@
锘縰sing DevExpress.XtraGrid.Views.Base;
-using DevExpress.XtraTreeList.Nodes;
-using Gs.DevApp.Models;
+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://blog.csdn.net/m0_54035969/article/details/140716675
public partial class Role : DevExpress.XtraEditors.XtraForm
{
- System.Text.StringBuilder sbRolist = new System.Text.StringBuilder();
+ System.Text.StringBuilder _actionLst = new System.Text.StringBuilder();
+ List<FilterEntity> _filterList = new List<FilterEntity>();
public Role()
{
InitializeComponent();
@@ -23,21 +24,40 @@
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());
+ 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>
+ /// 鎹㈠垏鎹簨浠�
+ /// </summary>
+ /// <param name="sender"></param>
+ /// <param name="e"></param>
private void GridView1_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e)
{
string rowGuid = "";
DataRow myDataRow = gridView1.GetDataRow(e.FocusedRowHandle);
+ if (myDataRow == null) return;
rowGuid = myDataRow["guid"].ToString();
- GetTree(rowGuid);
+ getTree(rowGuid);
groupBox1.Text = "璇峰嬀閫夈��" + myDataRow["roleName"].ToString() + "銆戠殑鏉冮檺";
}
/// <summary>
@@ -47,12 +67,10 @@
/// <param name="e"></param>
private void GcMain_MouseDoubleClick(object sender, MouseEventArgs e)
{
- string rowGuid = "";
- ColumnView cv = (ColumnView)gcMain.FocusedView;
- object rowIdObj = gridView1.GetRowCellValue(cv.FocusedRowHandle, "guid");
- DataRow myDataRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
- rowGuid = myDataRow["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>
/// 鍒嗛〉浜嬩欢
@@ -61,8 +79,30 @@
/// <param name="pageSize"></param>
private void PageBar1_PagerEvent(int curPage, int pageSize)
{
- GetPageList(curPage, pageSize);
+ 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>
@@ -70,7 +110,7 @@
/// <param name="e"></param>
private void ToolBarMenu1_btnEscClick(object sender, EventArgs e)
{
- UtilityHelper.ChangeTab(xtraTabControl1, 0);
+ UtilityHelper.JumpToTab(xtraTabControl1, 0);
}
/// <summary>
/// 鍒犻櫎浜嬩欢
@@ -79,27 +119,26 @@
/// <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() + "銆戯紝纭畾鍒犻櫎鍚楋紵"))
+ if (!MsgHelper.AskQuestion("浣犻�夋嫨浜嗐��" + rowName + "銆戯紝纭畾鍒犻櫎鍚楋紵\n璇ユ搷浣滃皢浼氭竻绌虹浉搴旂殑鐢ㄦ埛鏉冮檺"))
return;
- var _obj = new
- {
- guidList = 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);
- GetPageList(1, UtilityHelper.GetPageSize());
+ UtilityHelper.JumpToTab(xtraTabControl1, 0);
+ getPageList(1, UtilityHelper.GetPageSize());
}
ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
}
@@ -115,8 +154,8 @@
/// <param name="e"></param>
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
{
- UtilityHelper.ChangeTab(xtraTabControl1, 0);
- GetPageList(1, UtilityHelper.GetPageSize());
+ UtilityHelper.JumpToTab(xtraTabControl1, 0);
+ getPageList(1, UtilityHelper.GetPageSize());
}
/// <summary>
/// 淇敼浜嬩欢
@@ -125,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>
/// 鏂板浜嬩欢
@@ -141,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>
/// 淇濆瓨浜嬩欢
@@ -159,36 +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 (string.IsNullOrEmpty(txt_status.Text.Trim()))
- {
- Gs.DevApp.ToolBox.MsgHelper.Warning("瑙掕壊鐘舵�佷笉鑳戒负绌猴紒");
- txt_rolRemark.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,//鐘舵��
};
- string strJson = "";
try
{
- strJson = UtilityHelper.HttpPost("", "Role/EditModel", JsonConvert.SerializeObject(_obj));
- ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
+ string strJson = UtilityHelper.HttpPost("", "Role/EditModel", JsonConvert.SerializeObject(_obj));
+ 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)
@@ -204,31 +237,27 @@
/// <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;
- sbRolist = new System.Text.StringBuilder();
+ _actionLst = new System.Text.StringBuilder();
TraverseTreeViewNodes(trv.Nodes);
var _obj = new
{
- roleGuid = dr["guid"].ToString(),
- roleLst = sbRolist.ToString(),
+ roleGuid = rowGuid,
+ actionLst = _actionLst.ToString(),
};
- string strJson = "";
try
{
- strJson = UtilityHelper.HttpPost("", "MenuAction/SetRoleByRolueGuid", JsonConvert.SerializeObject(_obj));
- ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.GetDataByJson(strJson);
- if (_rtn.rtnCode > 0)
- {
-
- }
- ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ 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)
{
@@ -241,39 +270,43 @@
/// </summary>
/// <param name="curPage">绗嚑椤�</param>
/// <param name="pageSize">姣忛〉鍑犳潯</param>
- private void GetPageList(int curPage, int pageSize)
+ private void getPageList(int curPage, int pageSize)
{
- Models.PageQueryModel pgq = new Models.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);
- string strReturn = "";
try
{
- strReturn = UtilityHelper.HttpPost("", "Role/GetListPage", json);
- ReturnModel<PageListModel> dd = UtilityHelper.GetTableByJson(strReturn);
+ string strReturn = UtilityHelper.HttpPost("", "Role/GetListPage", json);
+ ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn);
DataTable dt = dd.rtnData.list;
gcMain.BindingContext = new BindingContext();
gcMain.DataSource = dt;
gcMain.ForceInitialize();
int dddd = dd.rtnData.pages;//鎬婚〉
- PageBar1.TotalPages = dddd;
- PageBar1.RecordCount = dd.rtnData.total;//璁板綍鎬绘暟
- PageBar1.CurrentPage = curPage;//褰撳墠椤�
- PageBar1.RowsCount = pageSize;//姣忛〉鏄剧ず
- PageBar1.setTxt();
+ pageBar1.TotalPages = dddd;
+ pageBar1.RecordCount = dd.rtnData.total;//璁板綍鎬绘暟
+ pageBar1.CurrentPage = curPage;//褰撳墠椤�
+ pageBar1.RowsCount = pageSize;//姣忛〉鏄剧ず
+ pageBar1.setTxt();
}
catch (Exception ex)
{
ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
}
}
- private void GetModel(string strGuid, bool isEdit, int tabIdx)
+ private void getModel(string strGuid, bool isEdit, int tabIdx)
{
if (string.IsNullOrEmpty(strGuid))
{
ToolBox.MsgHelper.Warning("璇峰厛閫夋嫨浣犺鎿嶄綔鐨勮锛�");
return;
}
- UtilityHelper.ChangeTab(xtraTabControl1, tabIdx);
+ UtilityHelper.JumpToTab(xtraTabControl1, tabIdx);
var _obj = new
{
guid = strGuid,//涓诲缓
@@ -282,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;
@@ -297,7 +330,7 @@
ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
}
}
- private void GetTree(string rolueGuid)
+ private void getTree(string roleGuid)
{
trv.Nodes.Clear();
ImageList imageList = new ImageList();
@@ -308,13 +341,12 @@
trv.ImageList = imageList;
var _obj = new
{
- rolueGuid = rolueGuid,//涓诲缓
+ roleGuid = roleGuid,//涓诲缓
};
- string strReturn = "";
try
{
- strReturn = UtilityHelper.HttpPost("", "MenuAction/GetListPageByOrg", 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)
@@ -324,6 +356,7 @@
node.Text = _dy["name"].ToString();//涓虹粨鐐硅祴鍊�
node.Name = _dy["guid"].ToString();
node.ImageIndex = 0;
+ node.Checked = (_dy["isCk"].ToString() == "1" ? true : false);
DataRow[] drItem = dt.Select("upGuid='" + _dy["guid"].ToString() + "' and orgGuid='" + _dy["guid"].ToString() + "'");
foreach (DataRow _dy2 in drItem)
{
@@ -331,6 +364,7 @@
node22.Text = _dy2["name"].ToString();//涓虹粨鐐硅祴鍊�
node22.Name = _orgGuid + _dy2["guid"].ToString();
node22.ImageIndex = 1;
+ node22.Checked = (_dy2["isCk"].ToString() == "1" ? true : false);
DataRow[] drItem33 = dt.Select("upGuid='" + _dy2["guid"].ToString() + "' and orgGuid='" + _dy["guid"].ToString() + "'");
foreach (DataRow _dy3 in drItem33)
{
@@ -338,6 +372,7 @@
node33.Text = _dy3["name"].ToString();//涓虹粨鐐硅祴鍊�
node33.Name = _orgGuid + _dy3["guid"].ToString();
node33.ImageIndex = 2;
+ node33.Checked = (_dy3["isCk"].ToString() == "1" ? true : false);
DataRow[] drItem44 = dt.Select("upGuid='" + _dy3["guid"].ToString() + "' and orgGuid='" + _dy["guid"].ToString() + "'");
foreach (DataRow _dy4 in drItem44)
{
@@ -345,6 +380,7 @@
node44.Text = _dy4["name"].ToString();//涓虹粨鐐硅祴鍊�
node44.Name = _orgGuid + _dy4["guid"].ToString();
node44.ImageIndex = 3;
+ node44.Checked = (_dy4["isCk"].ToString() == "1" ? true : false);
node33.Nodes.Add(node44);
}
node22.Nodes.Add(node33);
@@ -365,7 +401,9 @@
{
try
{
+ trv.AfterCheck -= Trv_AfterCheck;
UtilityHelper.TreeViewCheck(e);
+ trv.AfterCheck += Trv_AfterCheck;
}
catch (Exception ex)
{
@@ -378,7 +416,7 @@
foreach (TreeNode node in nodes)
{
if (node.Checked)
- sbRolist.Append(node.Name + "~");
+ _actionLst.Append(node.Name + "~");
// 閫掑綊閬嶅巻瀛愯妭鐐�
if (node.Nodes.Count > 0)
{
--
Gitblit v1.9.3