From e7ce5805983cac708c2feb2d60dbf90eedfa123d Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期一, 22 九月 2025 17:20:57 +0800
Subject: [PATCH] 齐套报表字体变红，库存差异表增加导出
---
DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs | 191 ++++++++++++++++++++++++++++++++++++-----------
1 files changed, 146 insertions(+), 45 deletions(-)
diff --git a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
index 07e1a34..0eb75a3 100644
--- a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
+++ b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
@@ -1238,6 +1238,10 @@
{
tabControl.TabPages[0].PageEnabled = true;
tabControl.TabPages[1].PageEnabled = true;
+ if (tabControl.TabPages.Count > 2)
+ {
+ tabControl.TabPages[2].PageEnabled = true;
+ }
tabControl.SelectedTabPageIndex = 0;
return;
}
@@ -1252,6 +1256,10 @@
{
tabControl.TabPages[0].PageEnabled = false;
tabControl.TabPages[1].PageEnabled = true;
+ if (tabControl.TabPages.Count > 2)
+ {
+ tabControl.TabPages[2].PageEnabled = false;
+ }
tabControl.SelectedTabPageIndex = 1;
return;
}
@@ -1259,6 +1267,10 @@
{
tabControl.TabPages[0].PageEnabled = false;
tabControl.TabPages[1].PageEnabled = true;
+ if (tabControl.TabPages.Count >2)
+ {
+ tabControl.TabPages[2].PageEnabled = false;
+ }
tabControl.SelectedTabPageIndex = 1;
return;
}
@@ -1274,7 +1286,10 @@
{
tabControl.TabPages[0].PageEnabled = true;
tabControl.TabPages[1].PageEnabled = true;
-
+ if (tabControl.TabPages.Count > 2)
+ {
+ tabControl.TabPages[2].PageEnabled = true;
+ }
return;
}
}
@@ -1710,7 +1725,7 @@
}
public delegate void DelegateGetModel(string guid);
public delegate void DelegateGetList(int currentPage);
-
+ public delegate void DelegateGetUserControlList();
/// <summary>
///
/// </summary>
@@ -1772,8 +1787,10 @@
// column.OptionsFilter.AutoFilterCondition = AutoFilterCondition.Contains;
column.OptionsFilter.AutoFilterCondition = DevExpress.XtraGrid.Columns.AutoFilterCondition.Contains;
column.OptionsFilter.ImmediateUpdateAutoFilter = false;
- if (column.Tag == null || column.Tag.ToString().EndsWith("edit"))
+ if (column.Tag == null || column.Tag.ToString().EndsWith("edit") || column.Name== "colChkInt")
+ {
column.OptionsColumn.ReadOnly = false;
+ }
else
column.OptionsColumn.ReadOnly = true;
@@ -1845,6 +1862,28 @@
action2(_guid);
};
}
+ gridView1.RowCellStyle += (s, e) =>
+ {
+ GridView view = s as GridView;
+ if (view != null && e.Column != null && e.CellValue != null)
+ {
+ if (e.Column.FieldName.EndsWith("Color"))
+ {
+ int rowHandle = e.RowHandle;
+ if (rowHandle >= 0) {
+ DataRow row = gridView1.GetDataRow(e.RowHandle);
+ string _bgColor = row[e.Column.FieldName + "Rgb"].ToString();
+ if (!string.IsNullOrEmpty(_bgColor))
+ {
+ Color bgColor = ColorTranslator.FromHtml(_bgColor);
+ e.Appearance.BackColor = bgColor;
+ //e.Appearance.BackColor2 = Color.LightSkyBlue;
+ //e.Appearance.ForeColor = ColorTranslator.FromHtml("#ffffff") ;
+ }
+ }
+ }
+ }
+ };
gridView1.RowStyle += (s, e) =>
{
//榛樿閫変腑琛屼笉鍙樿壊
@@ -1854,40 +1893,12 @@
if (e.RowHandle >= 0)
{
DataRow row = gridView1.GetDataRow(e.RowHandle);
- if (row == null)
- return;
- //杩欐槸danger鑹�
- bool columnExists = row.Table.Columns.Contains("isRed");
- if (columnExists == true)
- {
- string _isRed = row["isRed"].ToString();
- if (_isRed == "1")
- {
- e.Appearance.ForeColor = Color.Tomato;
- }
- }
- //杩欐槸success鑹�
- columnExists = row.Table.Columns.Contains("isSuccess");
- if (columnExists == true)
- {
- string _isRed = row["isSuccess"].ToString();
- if (_isRed == "1")
- {
- e.Appearance.ForeColor = Color.FromArgb(128, 255, 128);
- }
- }
// 璁剧疆鐒︾偣琛岀殑鑳屾櫙鑹�
if (gridView1.GetRow(e.RowHandle) == gridView1.GetFocusedRow())
{
e.Appearance.BackColor = Color.Azure;
e.Appearance.BackColor2 = Color.LightSkyBlue;
}
- //else if (gridView1.IsRowHotTracked(e.RowHandle))
- //{
- // // 璁剧疆榧犳爣鎮仠琛岀殑鑳屾櫙鑹�
- // e.Appearance.BackColor = Color.LightBlue;
- // e.Appearance.BackColor2 = Color.LightBlue;
- //}
}
};
if (tips != null)
@@ -1937,12 +1948,12 @@
edit.SelectAll();
}
- public static void SetGridLayout(GridView gridView1)
+ public static void SetGridLayout(GridView gridView1, int maxWidth = 500)
{
foreach (GridColumn column in gridView1.Columns)
{
- if (column.Width > 500)
- column.Width = 500;
+ if (column.Width > maxWidth)
+ column.Width = maxWidth;
}
}
@@ -1952,12 +1963,29 @@
/// <param name="gridView1"></param>
/// <param name="xtraTabControl1"></param>
/// <param name="pageBar1"></param>
- /// <param name="action"></param>
- /// <param name="page"></param>
- public static void SetTabParameter(GridView gridView1, DevExpress.XtraTab.XtraTabControl xtraTabControl1, UcPageBar pageBar1, DelegateGetModel action = null, DelegateGetList page = null, Label lbGuid = null)
+ /// <param name="action">璇诲彇瀹炰綋</param>
+ /// <param name="page">璇诲彇鍒楄〃</param>
+ /// <param name="lbGuid"></param>
+ /// <param name="barMenu"></param>
+ /// <param name="ucLst">璇诲彇鎶ヨ〃</param>
+ public static void SetTabParameter(GridView gridView1, DevExpress.XtraTab.XtraTabControl xtraTabControl1, UcPageBar pageBar1, DelegateGetModel action = null, DelegateGetList page = null, Label lbGuid = null, UcToolBarMenu barMenu = null, DelegateGetUserControlList ucLst = null)
{
xtraTabControl1.SelectedPageChanged += (s, e) =>
{
+ if (pageBar1 != null && xtraTabControl1.SelectedTabPageIndex == 0)
+ {
+ if (barMenu != null)
+ barMenu.SetAllButton(0);
+
+ page(pageBar1.CurrentPage);
+ int rowHandle = 0;
+ rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], lbGuid.Text);
+ if (rowHandle < 0)
+ rowHandle = 0;
+ gridView1.FocusedRowHandle = rowHandle;
+ return;
+ }
+
if (xtraTabControl1.SelectedTabPageIndex == 1)
{
int _handle = gridView1.FocusedRowHandle;
@@ -1985,18 +2013,18 @@
return;
}
action(_guid);
+ return;
}
- if (pageBar1 != null && xtraTabControl1.SelectedTabPageIndex == 0)
+
+ if (barMenu != null && xtraTabControl1.SelectedTabPageIndex == 2)
{
- page(pageBar1.CurrentPage);
- int rowHandle = 0;
- rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], lbGuid.Text);
- if (rowHandle < 0)
- rowHandle = 0;
- gridView1.FocusedRowHandle = rowHandle;
+ barMenu.SetAllButton(2);
+ ucLst();
+ return;
}
};
}
+
/// <summary>
/// 璁剧疆鏄庣粏grid鏍峰紡
@@ -2128,6 +2156,77 @@
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(" (select aboutGuid as fid from SYS_USER_BIND where userGuid='" + LoginInfoModel.CurrentUser.LoginUserGuid + "' and ftype='缁勭粐')");
return sb.ToString();
+ }
+
+ /// <summary>
+ /// 鐢ㄦ埛鎺т欢璇诲彇xml閰嶇疆
+ /// </summary>
+ /// <param name="_formNamespace"></param>
+ /// <param name="gvList"></param>
+ /// <param name="gcMain"></param>
+ public static void GetUcXmlConfig(string _formNamespace, List<DevExpress.XtraGrid.Views.Grid.GridView> gvList, GridControl gcMain)
+ {
+ JArray array = new JArray();
+ var _obj = new
+ {
+ formPath = _formNamespace,
+ };
+ try
+ {
+ string strJson = UtilityHelper.HttpPost("", "Fm/GetModel", JsonConvert.SerializeObject(_obj));
+ ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
+ if (_rtn.rtnCode > 0)
+ {
+ JObject _job = JObject.Parse(strJson);
+ foreach (var a in _job["rtnData"]["list"])
+ {
+ array.Add(a);
+ }
+ foreach (GridView gv in gvList)
+ {
+ JToken john = array.FirstOrDefault(t => t["controlId"].ToString().ToUpper() == gv.Name.ToString().Trim().ToUpper());
+ if (john != null)
+ {
+ string controlId = john["controlId"].ToString();
+ string controlXml = john["controlXml"].ToString();
+ byte[] byteArray = Encoding.UTF8.GetBytes(controlXml);
+ using (var stream = new MemoryStream(byteArray))
+ {
+ gv.RestoreLayoutFromStream(stream);
+ }
+ }
+ }
+
+ //璁剧疆鏌ヨ鏉′欢beg
+ if (gcMain != null)
+ {
+ GridView gv1 = gcMain.MainView as GridView;
+ if (gv1 != null)
+ {
+ foreach (var a in _job["rtnData"]["list2"])
+ {
+ string _gvColName = a["gvColName"].ToString();
+ string _sqlField = a["sqlField"].ToString();
+ string _sqlFieldType = a["sqlFieldType"].ToString();
+ var column = gv1.Columns.Cast<DevExpress.XtraGrid.Columns.GridColumn>()
+ .FirstOrDefault(c => c.Name == _gvColName);
+ if (column != null)
+ {
+ column.Tag = _sqlField;
+ column.UnboundExpression = _sqlFieldType;
+ }
+ }
+ }
+ }
+ //璁剧疆鏌ヨ鏉′欢end
+ }
+ else
+ ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg);
+ }
+ catch (Exception ex)
+ {
+ ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ }
}
#endregion
@@ -2527,7 +2626,9 @@
public enum OrderType
{
- 鍏跺畠鍏ュ簱
+ 鍏跺畠鍏ュ簱,
+ 鐗╂枡璋冩嫧,
+ 鍏跺畠鍑哄簱
}
--
Gitblit v1.9.3