From 794e8cba6af8fc33146bf34caa6940fcaab5f42f Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期五, 04 四月 2025 17:35:12 +0800
Subject: [PATCH] 打印按钮

---
 DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs |  109 +++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 71 insertions(+), 38 deletions(-)

diff --git a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
index c610dde..11b86c0 100644
--- a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
+++ b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
@@ -22,6 +22,7 @@
 using DevExpress.XtraGrid.Views.Grid;
 using DevExpress.XtraTab;
 using DevExpress.XtraTreeList;
+using Gs.DevApp.DevFrm.Work;
 using Gs.DevApp.Entity;
 using Gs.DevApp.UserControl;
 using Newtonsoft.Json;
@@ -282,6 +283,8 @@
                         if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui"))
                         {
                             colmn.Visible = !isEdt;
+                            if (colmn.Visible == true)
+                                colmn.VisibleIndex = 99999;
                         }
                         else
                         {
@@ -664,6 +667,18 @@
                         {
                             var txt = colType as SimpleButton;
                             txt.Enabled = !isEdt;
+                            continue;
+                        }
+
+                        //鑷畾涓嶈壇
+                        if (colType is UcDictionary)
+                        {
+                            var txt = colType as UcDictionary;
+                            txt.TextTxt = (strVal);
+                            //if (txt.IsReadly == false)
+                            //    txt.Enabled = !isEdt;
+                            //else
+                            //    txt.Enabled = false;
                             continue;
                         }
                     }
@@ -1218,26 +1233,6 @@
             }
             return isEdt;
         }
-        /// <summary>
-        ///     鍒囨崲閫夐」鍗�
-        /// </summary>
-        /// <param name="tabControl">閫夐」鍗″鍣�</param>
-        /// <param name="idx">浠�0寮�濮嬶紝濡傛灉鏄�999锛屽垯鍏ㄩ儴鍙敤</param>
-        public static void JumpToTab(XtraTabControl tabControl, int idx)
-        {
-            if (idx == 999)
-            {
-                for (var i = 0; i < tabControl.TabPages.Count; i++)
-                    tabControl.TabPages[i].PageEnabled = true;
-                tabControl.SelectedTabPageIndex = tabControl.TabPages.Count - 1;
-                return;
-            }
-
-            for (var i = 0; i < tabControl.TabPages.Count; i++)
-                tabControl.TabPages[i].PageEnabled = false;
-            tabControl.TabPages[idx].PageEnabled = true;
-            tabControl.SelectedTabPageIndex = idx;
-        }
 
 
         /// <summary>
@@ -1288,6 +1283,13 @@
                 tabControl.TabPages[0].PageEnabled = true;
                 tabControl.TabPages[1].PageEnabled = true;
                 tabControl.SelectedTabPageIndex = 1;
+                return;
+            }
+
+            if (action == 6)
+            {
+                tabControl.TabPages[0].PageEnabled = true;
+                tabControl.TabPages[1].PageEnabled = true;
                 return;
             }
         }
@@ -1589,7 +1591,6 @@
                     return rowGuid;
                 }
             }
-
             return "";
         }
 
@@ -1645,6 +1646,23 @@
         /// <param name="icoName"></param>
         public static void SetCheckIco(GridView gridView1, string zdChk, string zdChkUser, string zdCkDate, PictureBox btnChkIco, Form fm, string fileName, string icoName = "")
         {
+            btnChkIco.Anchor = AnchorStyles.Top | AnchorStyles.Right; // 闈犲彸
+            btnChkIco.Location = new Point(fm.ClientSize.Width - btnChkIco.Width - 20, 80); // 璺濈椤堕儴10鍍忕礌
+            if (gridView1 == null)
+            {
+                btnChkIco.Visible = true;
+                if (fileName == "1")
+                {
+                    btnChkIco.Image = global::Gs.DevApp.Properties.Resources.ico_check;
+                    btnChkIco.Tag = "宸插鏍�";
+                }
+                else
+                {
+                    btnChkIco.Image = global::Gs.DevApp.Properties.Resources.ico_noCheck;
+                    btnChkIco.Tag = "鏈鏍�";
+                }
+                return;
+            }
             if (fileName == "1" || fileName.ToUpper() == true.ToString().ToUpper())
             {
                 btnChkIco.Image = global::Gs.DevApp.Properties.Resources.ico_check;
@@ -1667,17 +1685,14 @@
                 if (!string.IsNullOrEmpty(zdChk))
                     gridView1.SetFocusedRowCellValue(zdChk, false);
             }
-            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)
+
+        public static FilterEntity getFilterEntityWord(string id, string idDec, string val, string type)
         {
-            return str.ToUpper().Replace("query_".ToUpper(), "");
-        }
-        public static FilterEntity getFilterEntityWord(string id, string idDec, string val)
-        {
-            return new FilterEntity(getQueryWord(id), idDec + ")", " like ", "鍖呭惈)", "%" + val + "%");
+            return new FilterEntity(id, idDec + ")", " like ", "鍖呭惈)", "%" + val + "%", type);
         }
         public static List<FilterEntity> GetDilter(GridColumnCollection Columns, GridView gridView1 = null)
         {
@@ -1696,7 +1711,7 @@
                 //  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()));
+                fiList.Add(getFilterEntityWord(col.Tag.ToString(), col.Caption.Trim(), ddd[1].Trim(), col.UnboundExpression));
             }
             return fiList;
         }
@@ -1721,8 +1736,20 @@
                     }
                 }
                 else
-                    _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" +
-                                      itm.fileValue + "'");
+                {
+                    switch (itm.fileType)
+                    {
+                        case "鏃堕棿绫诲瀷":
+                            _sbSqlWhere.Append(" and CONVERT(nvarchar(30)," + itm.fileId + ",23)" + itm.fileOper + "'" + itm.fileValue + "'");
+                            break;
+                        //case "鏁板�肩被鍨�":
+                        //    _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
+                        //    break;
+                        default:
+                            _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
+                            break;
+                    }
+                }
             }
             return _sbSqlWhere.ToString();
         }
@@ -1762,8 +1789,7 @@
             };
             gridView1.OptionsView.ShowGroupPanel = false;
             gridView1.OptionsCustomization.AllowGroup = false;
-
-            gridView1.Appearance.HeaderPanel.ForeColor = DevExpress.LookAndFeel.DXSkinColors.ForeColors.ControlText;
+            // gridView1.Appearance.HeaderPanel.ForeColor = DevExpress.LookAndFeel.DXSkinColors.ForeColors.ControlText;
             gridView1.OptionsView.ColumnAutoWidth = false;//鑷姩璋冩暣鍒楀
             foreach (GridColumn column in gridView1.Columns)
             {
@@ -1778,7 +1804,6 @@
                     column.OptionsColumn.ReadOnly = true;
                 if (column.Tag == null || column.Tag.ToString().Length <= 0)
                     column.OptionsFilter.AllowAutoFilter = false;
-                
             }
             gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False;
             gridView1.OptionsView.ShowAutoFilterRow = true;
@@ -1926,7 +1951,9 @@
                 }
                 if (xtraTabControl1.SelectedTabPageIndex == 0)
                 {
-                    //  page(pageBar1.CurrentPage);
+                    //int _handle = gridView1.FocusedRowHandle;
+                    //page(pageBar1.CurrentPage);
+                    //gridView1.FocusedRowHandle= _handle;
                 }
             };
         }
@@ -2097,10 +2124,11 @@
         {
         }
 
-        public CboItemEntity(string val, string text)
+        public CboItemEntity(string val, string text, string fType = "")
         {
             Text = text;
             Value = val;
+            FType = fType;
         }
 
         /// <summary>
@@ -2112,6 +2140,8 @@
         ///     瀵硅薄鍊�
         /// </summary>
         public object Value { get; set; } = "";
+
+        public object FType { get; set; } = "";
 
         public override string ToString()
         {
@@ -2133,13 +2163,14 @@
         /// <param name="operDec">鎿嶄綔绗﹀娉�</param>
         /// <param name="val"></param>
         public FilterEntity(string id, string idDec, string oper,
-            string operDec, string val)
+            string operDec, string val, string type)
         {
             fileId = id;
             fileIdDec = idDec;
             fileOper = oper;
             fileOperDec = operDec;
             fileValue = val;
+            fileType = type;
         }
 
         public string fileId { get; set; }
@@ -2151,5 +2182,7 @@
         public string fileOperDec { get; set; }
 
         public string fileValue { get; set; }
+
+        public string fileType { get; set; }
     }
 }
\ No newline at end of file

--
Gitblit v1.9.3