From 0bab28c7959335969f6d07c3cb33acbeffed1de5 Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期五, 29 十一月 2024 17:34:52 +0800
Subject: [PATCH] 1
---
DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs | 209 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 207 insertions(+), 2 deletions(-)
diff --git a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
index a02baec..46e8be7 100644
--- a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
+++ b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
@@ -509,6 +509,29 @@
txt.Enabled = false;
continue;
}
+ //鑷畾杞﹂棿
+ if (colType is UcLookWorkshop)
+ {
+ var txt = colType as UcLookWorkshop;
+ txt.SetIdOrCode(strVal);
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+ //鑷畾浜х嚎
+ if (colType is UcLookWorkline)
+ {
+ var txt = colType as UcLookWorkline;
+ txt.SetIdOrCode(strVal);
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+
if (colType is SimpleButton)
{
var txt = colType as SimpleButton;
@@ -641,6 +664,22 @@
txt.Enabled = !isEdt;
continue;
}
+ //鑷畾杞﹂棿
+ if (ctrl is UcLookWorkshop)
+ {
+ var txt = ctrl as UcLookWorkshop;
+ txt.SetIdOrCode("-1");
+ txt.Enabled = !isEdt;
+ continue;
+ }
+ //鑷畾浜х嚎
+ if (ctrl is UcLookWorkline)
+ {
+ var txt = ctrl as UcLookWorkline;
+ txt.SetIdOrCode("-1");
+ txt.Enabled = !isEdt;
+ continue;
+ }
if (ctrl is SimpleButton)
{
var txt = ctrl as SimpleButton;
@@ -718,11 +757,61 @@
ctrl.Enabled = !isEdt;
continue;
}
-
+ //
if (ctrl is CheckEdit)
{
var txt = ctrl as CheckEdit;
txt.ReadOnly = isEdt;
+ continue;
+ }
+ //鑷畾涔変粨搴�
+ if (ctrl is UcLookCk)
+ {
+ var txt = ctrl as UcLookCk;
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+ //鑷畾涔変緵搴斿晢
+ if (ctrl is UcLookSupplier)
+ {
+ var txt = ctrl as UcLookSupplier;
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+ //鑷畾涔夌墿鏂�
+ if (ctrl is UcLookItems)
+ {
+ var txt = ctrl as UcLookItems;
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+ //鑷畾涔夎溅闂�
+ if (ctrl is UcLookWorkshop)
+ {
+ var txt = ctrl as UcLookWorkshop;
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
+ continue;
+ }
+ //鑷畾涔変骇绾�
+ if (ctrl is UcLookWorkline)
+ {
+ var txt = ctrl as UcLookWorkline;
+ if (txt.IsReadly == false)
+ txt.Enabled = !isEdt;
+ else
+ txt.Enabled = false;
continue;
}
}
@@ -865,6 +954,7 @@
, Label lbGuid
, TextEdit txtName
, GridView gridView1
+ , string fileName = ""
, int SelectedTabPageIndex = 1)
{
var _strGuid = "";
@@ -884,7 +974,10 @@
else
{
_strGuid = dr["guid"].ToString();
- _strName = dr[1].ToString();
+ if (string.IsNullOrEmpty(fileName))
+ _strName = dr[1].ToString();
+ else
+ _strName = dr[fileName].ToString();
}
}
@@ -1015,6 +1108,117 @@
return "";
}
+
+
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="s"></param>
+ /// <param name="btnChkIco"></param>
+ /// <param name="fm"></param>
+ /// <param name="fileName">瀵瑰簲鐨勫鏍稿瓧娈靛悕绉�</param>
+ /// <param name="icoName"></param>
+ public static void SetCheckIco(object s, PictureBox btnChkIco, Form fm, string fileName = "checkStatus", string icoName = "")
+ {
+ GridView dgv = s as GridView;
+ if (dgv != null)
+ {
+ if (dgv.GetSelectedRows() != null)
+ {
+ var selectedRow = dgv.GetSelectedRows()[0]; // 鑾峰彇绗竴涓�変腑琛岀殑绱㈠紩
+ if (selectedRow >= 0)
+ {
+ var checkStatus = dgv.GetRowCellValue(selectedRow, fileName).ToString(); // 鑾峰彇鎸囧畾鍒楃殑鍊�
+ btnChkIco.Text = checkStatus;
+ btnChkIco.Visible = true;
+ if (checkStatus == "1" || checkStatus.ToUpper() == true.ToString().ToUpper())
+ btnChkIco.Image = global::Gs.DevApp.Properties.Resources.ico_check;
+ else
+ btnChkIco.Image = global::Gs.DevApp.Properties.Resources.ico_noCheck;
+ btnChkIco.Anchor = AnchorStyles.Top | AnchorStyles.Right; // 闈犲彸
+ btnChkIco.Location = new Point(fm.ClientSize.Width - btnChkIco.Width - 20, 80); // 璺濈椤堕儴10鍍忕礌
+ }
+ }
+ }
+ }
+
+
+ #region 璁剧疆鎼滅储
+ public static string getQueryWord(string str)
+ {
+ return str.ToUpper().Replace("query_".ToUpper(), "");
+ }
+ public static FilterEntity getFilterEntityWord(string id, string idDec, string val)
+ {
+ return new FilterEntity(getQueryWord(id), idDec + ")", " like ", "鍖呭惈)", "%" + val + "%");
+ }
+ public static List<FilterEntity> GetDilter(GridColumnCollection Columns)
+ {
+ List<FilterEntity> fiList = new List<FilterEntity>();
+ foreach (DevExpress.XtraGrid.Columns.GridColumn col in Columns)
+ {
+ ColumnFilterInfo filter = col.FilterInfo;
+ if (string.IsNullOrEmpty(filter.FilterString))
+ continue;
+ // fiList.Add(new FilterEntity("b.FNumber", "浣跨敤缁勭粐", " like ", "鍖呭惈", "%" + filter.Value + "%"));
+ string[] ddd = filter.FilterString.Replace("Contains","").Replace("(","").Replace(")","").Replace("'", "").Replace("'", "").Split(',');
+ //Contains([fSubsidiary], '005')
+ fiList.Add(getFilterEntityWord(col.Tag.ToString(), col.Caption.Trim(), ddd[1].Trim()));
+ }
+ return fiList;
+ }
+
+ /// <summary>
+ /// 鏍规嵁杩囨护鍣紝璇诲彇鏌ヨ鏉′欢,org琛ㄤ负缁勭粐
+ /// </summary>
+ /// <param name="_filterList"></param>
+ /// <returns></returns>
+ public static string GetSearchWhere(List<FilterEntity> _filterList)
+ {
+ var _sbSqlWhere = new StringBuilder();
+ foreach (var itm in _filterList)
+ {
+ if (itm.fileId.ToUpper().Contains("org".ToUpper()))
+ {
+ if (IsNumeric(itm.fileValue.Replace("%", "")))
+ _sbSqlWhere.Append(" and org.FNumber " + itm.fileOper + "'" + itm.fileValue + "'");
+ else
+ {
+ _sbSqlWhere.Append(" and org.NAME " + itm.fileOper + "'" + itm.fileValue.Trim() + "'");
+ }
+ }
+ else
+ _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" +
+ itm.fileValue + "'");
+ }
+ return _sbSqlWhere.ToString();
+ }
+ /// <summary>
+ /// 鍒濆鍖杇ridview
+ /// </summary>
+ /// <param name="gridView1"></param>
+ public static void SetGridSear(GridView gridView1)
+ {
+ foreach (GridColumn column in gridView1.Columns)
+ {
+ column.OptionsFilter.AutoFilterCondition = AutoFilterCondition.Contains;
+ column.OptionsFilter.ImmediateUpdateAutoFilter = false;
+ column.OptionsColumn.AllowEdit = false;
+ if (column.Tag==null || column.Tag.ToString().Length <= 0)
+ column.OptionsFilter.AllowAutoFilter = false;
+ }
+ gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False;
+ gridView1.OptionsFilter.AllowFilterEditor = false;
+ gridView1.OptionsFilter.ShowCustomFunctions = DevExpress.Utils.DefaultBoolean.False;
+ }
+ #endregion
+
+
+ public static bool IsNumeric(string str)
+ {
+ Regex regex = new Regex("^[0-9]+$");
+ return regex.IsMatch(str);
+ }
}
/// <summary>
@@ -1046,6 +1250,7 @@
{
return Text.ToString();
}
+
}
/// <summary>
--
Gitblit v1.9.3