From c47dadf9b621c36d84c6f0f2cac1fc5e08221858 Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期日, 08 十二月 2024 18:28:47 +0800
Subject: [PATCH] 1

---
 DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs |  633 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 578 insertions(+), 55 deletions(-)

diff --git a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
index 3a46885..a7fb76b 100644
--- a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
+++ b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs
@@ -5,6 +5,7 @@
 using System.Drawing;
 using System.IO;
 using System.Net;
+using System.Net.Cache;
 using System.Net.Http;
 using System.Reflection;
 using System.Resources;
@@ -12,7 +13,8 @@
 using System.Text.RegularExpressions;
 using System.Threading.Tasks;
 using System.Windows.Forms;
-using DevExpress.Office.Model;
+using DevExpress.RichEdit.Export;
+using DevExpress.XtraBars.Customization;
 using DevExpress.XtraEditors;
 using DevExpress.XtraEditors.Controls;
 using DevExpress.XtraGrid;
@@ -20,11 +22,13 @@
 using DevExpress.XtraGrid.Views.Grid;
 using DevExpress.XtraTab;
 using DevExpress.XtraTreeList;
+using DevExpress.XtraWaitForm;
 using Gs.DevApp.Entity;
 using Gs.DevApp.UserControl;
 using Newtonsoft.Json;
 using Newtonsoft.Json.Linq;
 using static System.Windows.Forms.Control;
+
 
 namespace Gs.DevApp.ToolBox
 {
@@ -64,32 +68,35 @@
         /// <param name="meth">鏂规硶鍚嶇О</param>
         /// <param name="param">鍙傛暟</param>
         /// <returns></returns>
-        public static async Task<string> HttpPostAsync(string url, string meth, string param)
-        {
-            if (string.IsNullOrEmpty(url))
-                url = WebApiUrl;
-            url += meth;
-            var request = (HttpWebRequest)WebRequest.Create(url);
-            request.Method = "POST";
-            request.ContentType = "application/json";
-            request.Headers.Add("token", GetBasicAuthTicket());
-            request.Accept = "*/*";
-            request.Timeout = 15000;
-            request.AllowAutoRedirect = false;
-            using (Stream requestStream = await request.GetRequestStreamAsync())
-            {
-                byte[] dataBytes = Encoding.UTF8.GetBytes(param);
-                await requestStream.WriteAsync(dataBytes, 0, dataBytes.Length);
-            }
+        //public static async Task<string> HttpPostAsync(string url, string meth, string param)
+        //{
+        //    if (string.IsNullOrEmpty(url))
+        //        url = WebApiUrl;
+        //    url += meth;
+        //    var request = (HttpWebRequest)WebRequest.Create(url);
+        //    request.Method = "POST";
+        //    request.ContentType = "application/json";
+        //    request.Headers.Add("token", GetBasicAuthTicket());
+        //    request.Accept = "*/*";
+        //    request.Timeout = 15000;
+        //    request.AllowAutoRedirect = false;
+        //    request.ServicePoint.Expect100Continue = false;
+        //    HttpRequestCachePolicy noCachePolicy = new HttpRequestCachePolicy(HttpRequestCacheLevel.NoCacheNoStore);
+        //    request.CachePolicy = noCachePolicy;
+        //    using (Stream requestStream = await request.GetRequestStreamAsync())
+        //    {
+        //        byte[] dataBytes = Encoding.UTF8.GetBytes(param);
+        //        await requestStream.WriteAsync(dataBytes, 0, dataBytes.Length);
+        //    }
 
-            using (WebResponse response = await request.GetResponseAsync())
-            {
-                using (StreamReader reader = new StreamReader(response.GetResponseStream()))
-                {
-                    return await reader.ReadToEndAsync();
-                }
-            }
-        }
+        //    using (WebResponse response = await request.GetResponseAsync())
+        //    {
+        //        using (StreamReader reader = new StreamReader(response.GetResponseStream()))
+        //        {
+        //            return await reader.ReadToEndAsync();
+        //        }
+        //    }
+        //}
 
         /// <summary>
         ///     httpPost璁块棶鏈嶅姟
@@ -100,36 +107,52 @@
         /// <returns></returns>
         public static string HttpPost(string url, string meth, string param)
         {
-            if (string.IsNullOrEmpty(url))
-                url = WebApiUrl;
-            url += meth;
-            var request = (HttpWebRequest)WebRequest.Create(url);
-            request.Method = "POST";
-            request.ContentType = "application/json";
-            request.Headers.Add("token", GetBasicAuthTicket());
-            request.Accept = "*/*";
-            request.Timeout = 15000;
-            request.AllowAutoRedirect = false;
+            string _caption = "鎷煎懡鍔犺浇涓紝璇风◢鍚�...";
+            DevExpress.Utils.WaitDialogForm wdf = new DevExpress.Utils.WaitDialogForm(_caption + meth, "鍙嬫儏鎻愮ず");
+            wdf.BackColor = System.Drawing.Color.LightSkyBlue;
+            wdf.Padding = new Padding(15);
+            HttpWebRequest request = null;
             StreamWriter requestStream = null;
             WebResponse response = null;
             string responseStr = null;
             try
             {
+                if (string.IsNullOrEmpty(url))
+                    url = WebApiUrl;
+                url += meth;
+                request = (HttpWebRequest)WebRequest.Create(url);
+                request.Method = "POST";
+                request.ContentType = "application/json";
+                request.Headers.Add("token", GetBasicAuthTicket());
+                request.Accept = "*/*";
+                request.Timeout = 15000;
+                request.AllowAutoRedirect = false;
+                request.ServicePoint.Expect100Continue = false;
+                wdf.SetCaption(_caption+"锛�10/100锛�" + meth);
+                HttpRequestCachePolicy noCachePolicy = new HttpRequestCachePolicy(HttpRequestCacheLevel.NoCacheNoStore);
+                request.CachePolicy = noCachePolicy;
+                wdf.SetCaption(_caption + "锛�20/100锛�" + meth);
                 requestStream = new StreamWriter(request.GetRequestStream());
                 requestStream.Write(param);
                 requestStream.Close();
+                wdf.SetCaption(_caption + "30/100锛�" + meth);
                 response = request.GetResponse();
+                wdf.SetCaption(_caption + "锛�40/100锛�");
                 if (response != null)
                 {
+                    wdf.SetCaption(_caption + "锛�50/100锛�" + meth);
                     var reader = new StreamReader(response.GetResponseStream(),
                         Encoding.UTF8);
                     responseStr = reader.ReadToEnd();
                     //File.WriteAllText(Server.MapPath("~/") + @"\test.txt", responseStr); 
                     reader.Close();
+                    wdf.SetCaption(_caption + "锛�60/100锛�" + meth);
                 }
+                wdf.SetCaption(_caption + "锛�80/100锛�" + meth);
             }
             catch (Exception ex)
             {
+                wdf.Close();
                 LogHelper.Debug(url, param + ":" + ex.Message);
                 throw ex;
             }
@@ -139,7 +162,8 @@
                 requestStream = null;
                 response = null;
             }
-
+            wdf.SetCaption(_caption + "锛�90/100锛�");
+            wdf.Close();
             return responseStr;
         }
 
@@ -187,7 +211,14 @@
         {
             var dt = new DataTable();
             foreach (GridColumn col in gv.Columns)
-                dt.Columns.Add(col.FieldName, typeof(string));
+            {
+                if (col.UnboundDataType == typeof(System.Boolean))
+                    dt.Columns.Add(col.FieldName, typeof(System.Boolean));
+                else
+                {
+                    dt.Columns.Add(col.FieldName, typeof(string));
+                }
+            }
             gc.BindingContext = new BindingContext();
             gc.DataSource = dt;
             gc.ForceInitialize();
@@ -284,14 +315,32 @@
             isEdt = !isEdt;
             if (gridViews != null)
                 foreach (var gv in gridViews)
-                    gv.OptionsBehavior.Editable = !isEdt;
-
-           var _btnAry=  controls.Find("btnSelect", false);
-            if (_btnAry.Length > 0) {
+                {
+                    foreach (GridColumn colmn in gv.Columns)
+                    {
+                        if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui"))
+                        {
+                            //  colmn.Visible = !isEdt;
+                            //  break;
+                            colmn.OptionsColumn.AllowEdit = true;
+                        }
+                        else
+                            colmn.OptionsColumn.AllowEdit = !isEdt;
+                    }
+                    //gv.OptionsBehavior.Editable = !isEdt;
+                }
+            var _btnAry = controls.Find("btnSelect", false);
+            if (_btnAry.Length > 0)
+            {
                 var _btnType = _btnAry[0];
                 _btnType.Enabled = !isEdt;
             }
-
+            var _btnAry2 = controls.Find("btnTui", false);
+            if (_btnAry2.Length > 0)
+            {
+                var _btnType = _btnAry2[0];
+                _btnType.Enabled = !isEdt;
+            }
             foreach (JProperty property in dynamicObject.Properties())
             {
                 var strName = property.Name;
@@ -377,7 +426,7 @@
                             txt.ReadOnly = isEdt;
                             continue;
                         }
-                        
+
                         //鏁板瓧鍗�
                         if (colType is NumericUpDown)
                         {
@@ -445,9 +494,9 @@
                             var txt = colType as Label;
                             if (_dddddd == "txt_checkStatus")
                             {
-                                if (strVal == "True" || strVal=="1")
+                                if (strVal == "True" || strVal == "1")
                                     txt.Text = "宸插鏍�";
-                                if (strVal == "False" || strVal=="0" || strVal=="")
+                                if (strVal == "False" || strVal == "0" || strVal == "")
                                     txt.Text = "鏈鏍�";
                             }
                             else
@@ -459,8 +508,11 @@
                         if (colType is UcLookCk)
                         {
                             var txt = colType as UcLookCk;
-                            txt.SetIdOrCode( strVal);
-                            txt.Enabled = !isEdt;
+                            txt.SetIdOrCode(strVal);
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
                             continue;
                         }
                         //鑷畾涔変緵搴斿晢
@@ -468,7 +520,10 @@
                         {
                             var txt = colType as UcLookSupplier;
                             txt.SetIdOrCode(strVal);
-                            txt.Enabled = !isEdt;
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
                             continue;
                         }
                         //鑷畾涔夌墿鏂�
@@ -476,9 +531,80 @@
                         {
                             var txt = colType as UcLookItems;
                             txt.SetIdOrCode(strVal);
-                            txt.Enabled = !isEdt;
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                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 UcLookUnit)
+                        {
+                            var txt = colType as UcLookUnit;
+                            txt.SetIdOrCode(strVal);
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
+                            continue;
+                        }
+
+                        //鑷畾瀹㈡埛
+                        if (colType is UcLookCustomer)
+                        {
+                            var txt = colType as UcLookCustomer;
+                            txt.SetIdOrCode(strVal);
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
+                            continue;
+                        }
+                        //鑷畾鍛樺伐
+                        if (colType is UcLookStaff)
+                        {
+                            var txt = colType as UcLookStaff;
+                            txt.SetIdOrCode(strVal);
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
+                            continue;
+                        }
+                        //鑷畾缁勭粐
+                        if (colType is UcLookOrg)
+                        {
+                            var txt = colType as UcLookOrg;
+                            txt.SetIdOrCode(strVal);
+                            if (txt.IsReadly == false)
+                                txt.Enabled = !isEdt;
+                            else
+                                txt.Enabled = false;
+                            continue;
+                        }
+
                         if (colType is SimpleButton)
                         {
                             var txt = colType as SimpleButton;
@@ -506,7 +632,20 @@
             isEdt = !isEdt;
             if (gridViews != null)
                 foreach (var gv in gridViews)
-                    gv.OptionsBehavior.Editable = !isEdt;
+                {
+                    foreach (GridColumn colmn in gv.Columns)
+                    {
+                        if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui"))
+                        {
+                            //  colmn.Visible = !isEdt;
+                            //  break;
+                            colmn.OptionsColumn.AllowEdit = true;
+                        }
+                        else
+                            colmn.OptionsColumn.AllowEdit = !isEdt;
+                    }
+                    //gv.OptionsBehavior.Editable = !isEdt;
+                }
             foreach (Control ctrl in controls)
             {
                 //澶氳鏂囨湰
@@ -601,6 +740,54 @@
                     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 UcLookUnit)
+                {
+                    var txt = ctrl as UcLookUnit;
+                    txt.SetIdOrCode("-1");
+                    txt.Enabled = !isEdt;
+                    continue;
+                }
+                //鑷畾瀹㈡埛
+                if (ctrl is UcLookCustomer)
+                {
+                    var txt = ctrl as UcLookCustomer;
+                    txt.SetIdOrCode("-1");
+                    txt.Enabled = !isEdt;
+                    continue;
+                }
+                //鑷畾瀹㈡埛
+                if (ctrl is UcLookStaff)
+                {
+                    var txt = ctrl as UcLookStaff;
+                    txt.SetIdOrCode("-1");
+                    txt.Enabled = !isEdt;
+                    continue;
+                }
+                //鑷畾缁勭粐
+                if (ctrl is UcLookOrg)
+                {
+                    var txt = ctrl as UcLookOrg;
+                    txt.SetIdOrCode("-1");
+                    txt.Enabled = !isEdt;
+                    continue;
+                }
                 if (ctrl is SimpleButton)
                 {
                     var txt = ctrl as SimpleButton;
@@ -623,7 +810,20 @@
             isEdt = !isEdt;
             if (gridViews != null)
                 foreach (var gv in gridViews)
-                    gv.OptionsBehavior.Editable = !isEdt;
+                {
+                    foreach (GridColumn colmn in gv.Columns)
+                    {
+                        if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui"))
+                        {
+                            //  colmn.Visible = !isEdt;
+                            //  break;
+                            colmn.OptionsColumn.AllowEdit = true;
+                        }
+                        else
+                            colmn.OptionsColumn.AllowEdit = !isEdt;
+                    }
+                    //gv.OptionsBehavior.Editable = !isEdt;
+                }
             foreach (Control ctrl in controls)
             {
                 //鏂囨湰
@@ -663,15 +863,106 @@
                 }
 
                 //鍗曢��
-                if (ctrl is CheckBox) {
+                if (ctrl is CheckBox)
+                {
                     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;
+                }
+                //鑷畾涔夊崟浣�
+                if (ctrl is UcLookUnit)
+                {
+                    var txt = ctrl as UcLookUnit;
+                    if (txt.IsReadly == false)
+                        txt.Enabled = !isEdt;
+                    else
+                        txt.Enabled = false;
+                    continue;
+                }
+                //鑷畾涔夊鎴�
+                if (ctrl is UcLookCustomer)
+                {
+                    var txt = ctrl as UcLookCustomer;
+                    if (txt.IsReadly == false)
+                        txt.Enabled = !isEdt;
+                    else
+                        txt.Enabled = false;
+                    continue;
+                }
+                //鑷畾涔夊憳宸�
+                if (ctrl is UcLookStaff)
+                {
+                    var txt = ctrl as UcLookStaff;
+                    if (txt.IsReadly == false)
+                        txt.Enabled = !isEdt;
+                    else
+                        txt.Enabled = false;
+                    continue;
+                }
+                //鑷畾缁勭粐
+                if (ctrl is UcLookOrg)
+                {
+                    var txt = ctrl as UcLookOrg;
+                    if (txt.IsReadly == false)
+                        txt.Enabled = !isEdt;
+                    else
+                        txt.Enabled = false;
                     continue;
                 }
             }
@@ -776,6 +1067,38 @@
             return Guid.Parse(str);
         }
 
+        public static int ToInt(string str)
+        {
+            try
+            {
+                return int.Parse(str);
+            }
+            catch (Exception)
+            {
+
+                return 0;
+            }
+        }
+        public static long ToLong(string str)
+        {
+            try
+            {
+                return long.Parse(str);
+            }
+            catch (Exception)
+            {
+
+                return 0;
+            }
+        }
+
+        public static int ToBit(string str)
+        {
+            if (str.ToUpper() == "true".ToUpper())
+                return 1;
+            return 0;
+        }
+
         /// <summary>
         /// 璇诲彇grid鐨勫綋鍓嶈
         /// </summary>
@@ -790,6 +1113,7 @@
             , Label lbGuid
             , TextEdit txtName
             , GridView gridView1
+            , string fileName = ""
             , int SelectedTabPageIndex = 1)
         {
             var _strGuid = "";
@@ -809,7 +1133,10 @@
                 else
                 {
                     _strGuid = dr["guid"].ToString();
-                      _strName = dr[1].ToString();
+                    if (string.IsNullOrEmpty(fileName))
+                        _strName = dr[1].ToString();
+                    else
+                        _strName = dr[fileName].ToString();
                 }
             }
 
@@ -940,6 +1267,201 @@
 
             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>
+        /// 
+        /// </summary>
+        /// <param name="gridView1">gridview</param>
+        /// <param name="btnChkIco">鍥炬爣鎸夐挳</param>
+        /// <param name="fm">褰撳墠绐椾綋</param>
+        /// <param name="fileName">瀛楁</param>
+        /// <param name="icoName">鍥炬爣璺緞</param>
+        public static void SetGridSear(GridView gridView1, PictureBox btnChkIco = null, Form fm = null, string fileName = "checkStatus", string icoName = "")
+        {
+         //   gridView1.OptionsView.ColumnAutoWidth = false;鑷姩璋冩暣鍒楀
+
+            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;
+            gridView1.OptionsCustomization.AllowFilter = false;
+            gridView1.OptionsFind.ShowSearchNavButtons = false;
+            gridView1.OptionsView.ShowAutoFilterRow = true;
+            gridView1.OptionsView.ShowGroupPanel = false;
+            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) =>
+            {
+                var str = "鏆傛湭鏌ユ壘鍒板尮閰嶇殑鏁版嵁!";
+                var f = new Font("寰蒋闆呴粦", 16);
+                var 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);
+            };
+            if (btnChkIco != null)
+            {
+                gridView1.FocusedRowChanged += (s, e) =>
+                {
+                    UtilityHelper.SetCheckIco(s, btnChkIco, fm, fileName, icoName);
+                };
+            }
+        }
+
+        /// <summary>
+        /// 璁剧疆鏄庣粏grid鏍峰紡
+        /// </summary>
+        /// <param name="gridView1"></param>
+        /// <param name="btnChkIco"></param>
+        /// <param name="fm"></param>
+        /// <param name="fileName"></param>
+        /// <param name="icoName"></param>
+        public static void SetGridSearMx(GridView gridView1)
+        {
+            gridView1.OptionsFilter.AllowFilterEditor = false;
+            gridView1.OptionsFilter.ShowCustomFunctions = DevExpress.Utils.DefaultBoolean.False;
+            gridView1.OptionsCustomization.AllowFilter = false;
+            gridView1.OptionsFind.ShowSearchNavButtons = false;
+            gridView1.OptionsView.ShowAutoFilterRow = false;
+            gridView1.OptionsView.ShowGroupPanel = false;
+            gridView1.IndicatorWidth = 40;
+            gridView1.CustomDrawRowIndicator += (s, e) =>
+            {
+                if (e.Info.IsRowIndicator && e.RowHandle >= 0)
+                    e.Info.DisplayText = (e.RowHandle + 1).ToString();
+            };
+            gridView1.CustomDrawEmptyForeground += (s, e) =>
+            {
+                var str = "鏆傛棤鏄庣粏鏁版嵁!";
+                var f = new Font("寰蒋闆呴粦", 16);
+                var 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);
+            };
+            gridView1.ValidatingEditor += (sender, e) =>
+            {
+                //yz_quantity_0
+                GridView view = sender as GridView;
+                if (view.FocusedColumn.Tag != null && view.FocusedColumn.Tag.ToString().StartsWith("yz_"))
+                {
+                    string[] _ary = view.FocusedColumn.Tag.ToString().Split('_');
+                    if (_ary.Length > 2)
+                    {
+                        if (_ary[2] == "0")
+                        {
+                            double price = 0; if (!Double.TryParse(e.Value as String, out price))
+                            { e.Valid = false; e.ErrorText = "璇疯緭鍏ユ纭殑鏁板瓧."; }
+                            return;
+                        }
+                    }
+                }
+            };
+        }
+
+        #endregion
+
+        public static bool IsNumeric(string str)
+        {
+            Regex regex = new Regex("^[0-9]+$");
+            return regex.IsMatch(str);
+        }
+
+      
+
     }
 
     /// <summary>
@@ -971,6 +1493,7 @@
         {
             return Text.ToString();
         }
+
     }
 
     /// <summary>

--
Gitblit v1.9.3