From 3cf7cd4d37f38a60a65f2a066f6403db9d24e6e0 Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期二, 24 十二月 2024 08:50:41 +0800 Subject: [PATCH] 细节 --- DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs | 957 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 883 insertions(+), 74 deletions(-) diff --git a/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs b/DevApp/Gs.DevApp/ToolBox/UtilityHelper.cs index 299df99..2657a09 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,6 @@ using System.Text.RegularExpressions; using System.Threading.Tasks; using System.Windows.Forms; -using DevExpress.Office.Model; using DevExpress.XtraEditors; using DevExpress.XtraEditors.Controls; using DevExpress.XtraGrid; @@ -24,7 +24,9 @@ using Gs.DevApp.UserControl; using Newtonsoft.Json; using Newtonsoft.Json.Linq; +using UserControls.Data; using static System.Windows.Forms.Control; + namespace Gs.DevApp.ToolBox { @@ -57,79 +59,55 @@ } } } - /// <summary> - /// httpPost璁块棶鏈嶅姟 - /// </summary> - /// <param name="url">鏈嶅姟鍦板潃</param> - /// <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); - } - using (WebResponse response = await request.GetResponseAsync()) - { - using (StreamReader reader = new StreamReader(response.GetResponseStream())) - { - return await reader.ReadToEndAsync(); - } - } - } - - /// <summary> - /// httpPost璁块棶鏈嶅姟 - /// </summary> - /// <param name="url">鏈嶅姟鍦板潃</param> - /// <param name="meth">鏂规硶鍚嶇О</param> - /// <param name="param">鍙傛暟</param> - /// <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 +117,8 @@ requestStream = null; response = null; } - + wdf.SetCaption(_caption + "锛�90/100锛�"); + wdf.Close(); return responseStr; } @@ -187,7 +166,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(); @@ -283,15 +269,42 @@ { 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) + { + colmn.OptionsColumn.AllowEdit = true; + if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui")) + { + colmn.Visible = !isEdt; + } + else + { + if (isEdt == false) { + if (colmn.Tag != null && colmn.Tag.ToString().EndsWith("edit")) + colmn.OptionsColumn.ReadOnly = isEdt; + else + colmn.OptionsColumn.ReadOnly = !isEdt; + } + else + colmn.OptionsColumn.ReadOnly = 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; @@ -369,6 +382,14 @@ txt.ReadOnly = isEdt; continue; } + if (colType is MemoEdit) + { + var txt = colType as MemoEdit; + if (txt != null) + txt.Text = strVal; + txt.ReadOnly = isEdt; + continue; + } //鏁板瓧鍗� if (colType is NumericUpDown) @@ -437,9 +458,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 @@ -451,8 +472,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; } //鑷畾涔変緵搴斿晢 @@ -460,7 +484,143 @@ { var txt = colType as UcLookSupplier; txt.SetIdOrCode(strVal); - txt.Enabled = !isEdt; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾涔夌墿鏂� + if (colType is UcLookItems) + { + var txt = colType as UcLookItems; + txt.SetIdOrCode(strVal); + 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 UcLookUser) + { + var txt = colType as UcLookUser; + txt.SetIdOrCode(strVal); + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾鎵撳嵃鏈� + if (colType is UcLookPrint) + { + var txt = colType as UcLookPrint; + txt.SetIdOrCode(strVal); + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾缂洪櫡绫诲埆 + if (colType is UcLookDefectType) + { + var txt = colType as UcLookDefectType; + txt.SetIdOrCode(strVal); + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾閮ㄩ棬 + if (colType is UcLookDepartment) + { + var txt = colType as UcLookDepartment; + txt.SetIdOrCode(strVal); + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾daa + if (colType is UcLookDaa) + { + var txt = colType as UcLookDaa; + txt.SetIdOrCode(strVal); + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; continue; } if (colType is SimpleButton) @@ -489,8 +649,31 @@ { isEdt = !isEdt; if (gridViews != null) + { foreach (var gv in gridViews) - gv.OptionsBehavior.Editable = !isEdt; + { + foreach (GridColumn colmn in gv.Columns) + { + colmn.OptionsColumn.AllowEdit = true; + if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui")) + { + colmn.Visible = !isEdt; + } + else + { + if (isEdt == false) + { + if (colmn.Tag != null && colmn.Tag.ToString().EndsWith("edit")) + colmn.OptionsColumn.ReadOnly = isEdt; + else + colmn.OptionsColumn.ReadOnly = !isEdt; + } + else + colmn.OptionsColumn.ReadOnly = isEdt; + } + } + } + } foreach (Control ctrl in controls) { //澶氳鏂囨湰 @@ -528,11 +711,23 @@ if (ctrl is TextEdit) { var txt = ctrl as TextEdit; - txt.Text = ""; + if (txt.Tag != null && txt.Tag.ToString().Length > 0 && txt.Tag.ToString().StartsWith("moren")) + { + txt.Text = txt.Tag.ToString().Replace("moren.", ""); + } + else + txt.Text = ""; txt.ReadOnly = isEdt; continue; } - + if (ctrl is MemoEdit) + { + var txt = ctrl as MemoEdit; + if (txt != null) + txt.Text = ""; + txt.ReadOnly = isEdt; + continue; + } //鏃堕棿 if (ctrl is DateTimePicker) { @@ -544,7 +739,7 @@ if (ctrl is CheckBox) { var txt = ctrl as CheckBox; - txt.Checked = false; + //txt.Checked = false; txt.Enabled = !isEdt; } if (ctrl is CheckEdit) @@ -570,6 +765,102 @@ txt.Enabled = !isEdt; continue; } + //鑷畾涔夌墿鏂� + if (ctrl is UcLookItems) + { + var txt = ctrl as UcLookItems; + txt.SetIdOrCode("-1"); + 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 UcLookUser) + { + var txt = ctrl as UcLookUser; + txt.SetIdOrCode("-1"); + txt.Enabled = !isEdt; + continue; + } + //鑷畾鎵撳嵃鏈� + if (ctrl is UcLookPrint) + { + var txt = ctrl as UcLookPrint; + txt.SetIdOrCode("-1"); + txt.Enabled = !isEdt; + continue; + } + //鑷畾缂洪櫡绫诲埆 + if (ctrl is UcLookDefectType) + { + var txt = ctrl as UcLookDefectType; + txt.SetIdOrCode("-1"); + txt.Enabled = !isEdt; + continue; + } + //鑷畾閮ㄩ棬 + if (ctrl is UcLookDepartment) + { + var txt = ctrl as UcLookDepartment; + txt.SetIdOrCode("-1"); + txt.Enabled = !isEdt; + continue; + } + //鑷畾daa + if (ctrl is UcLookDaa) + { + var txt = ctrl as UcLookDaa; + txt.SetIdOrCode("-1"); + txt.Enabled = !isEdt; + continue; + } if (ctrl is SimpleButton) { var txt = ctrl as SimpleButton; @@ -591,8 +882,26 @@ { isEdt = !isEdt; if (gridViews != null) + { foreach (var gv in gridViews) - gv.OptionsBehavior.Editable = !isEdt; + { + foreach (GridColumn colmn in gv.Columns) + { + colmn.OptionsColumn.AllowEdit = true; + if (colmn.Name.ToString().Contains("gvMxDel") || colmn.Name.ToString().Contains("gvMxTui")) + { + colmn.Visible = !isEdt; + } + else + { + if (colmn.Tag!=null && colmn.Tag.ToString().EndsWith("edit")) + colmn.OptionsColumn.ReadOnly = isEdt; + else + colmn.OptionsColumn.ReadOnly = !isEdt; + } + } + } + } foreach (Control ctrl in controls) { //鏂囨湰 @@ -602,7 +911,12 @@ txt.ReadOnly = isEdt; continue; } - + if (ctrl is MemoEdit) + { + var txt = ctrl as MemoEdit; + txt.ReadOnly = isEdt; + continue; + } //鏁板瓧鍗� if (ctrl is NumericUpDown) { @@ -610,7 +924,6 @@ txt.ReadOnly = isEdt; continue; } - //涓嬫媺 if (ctrl is UcComBox) { @@ -628,15 +941,163 @@ } //鍗曢�� - 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; + } + //鑷畾鐢ㄦ埛 + if (ctrl is UcLookUser) + { + var txt = ctrl as UcLookUser; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾鎵撳嵃 + if (ctrl is UcLookPrint) + { + var txt = ctrl as UcLookPrint; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾缂洪櫡绫诲埆 + if (ctrl is UcLookDefectType) + { + var txt = ctrl as UcLookDefectType; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾閮ㄩ棬 + if (ctrl is UcLookDepartment) + { + var txt = ctrl as UcLookDepartment; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + //鑷畾daa + if (ctrl is UcLookDaa) + { + var txt = ctrl as UcLookDaa; + if (txt.IsReadly == false) + txt.Enabled = !isEdt; + else + txt.Enabled = false; + continue; + } + + if (ctrl is SimpleButton) + { + var txt = ctrl as SimpleButton; + txt.Enabled = !isEdt; continue; } } @@ -661,6 +1122,59 @@ tabControl.TabPages[i].PageEnabled = false; tabControl.TabPages[idx].PageEnabled = true; tabControl.SelectedTabPageIndex = idx; + } + + + /// <summary> + /// tab璺宠浆锛�0鏌ョ湅锛�1閫�鍑猴紝2鍒犻櫎锛�3淇敼锛�4鏂板鍔� + /// </summary> + /// <param name="tabControl"></param> + /// <param name="idx">0鏌ョ湅锛�1閫�鍑猴紝2鍒犻櫎锛�3淇敼锛�4鏂板鍔�</param> + public static void JumpTab(XtraTabControl tabControl, int action) + { + + if (action == 0) + { + tabControl.TabPages[0].PageEnabled = true; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 1; + return; + } + if (action == 1) + { + tabControl.TabPages[0].PageEnabled = true; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 0; + return; + } + if (action == 2) + { + tabControl.TabPages[0].PageEnabled = true; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 0; + return; + } + if (action == 3) + { + tabControl.TabPages[0].PageEnabled = false; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 1; + return; + } + if (action == 4) + { + tabControl.TabPages[0].PageEnabled = false; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 1; + return; + } + if (action == 5) + { + tabControl.TabPages[0].PageEnabled = true; + tabControl.TabPages[1].PageEnabled = true; + tabControl.SelectedTabPageIndex = 1; + return; + } } /// <summary> @@ -741,6 +1255,45 @@ 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; + } + + public string GetIsNullOrEmpty(string str) + { + if (string.IsNullOrEmpty(str.Trim())) + return "{>"; + return str.Trim(); + } + /// <summary> /// 璇诲彇grid鐨勫綋鍓嶈 /// </summary> @@ -755,6 +1308,7 @@ , Label lbGuid , TextEdit txtName , GridView gridView1 + , string fileName = "" , int SelectedTabPageIndex = 1) { var _strGuid = ""; @@ -774,7 +1328,10 @@ else { _strGuid = dr["guid"].ToString(); - _strName = dr[1].ToString(); + if (string.IsNullOrEmpty(fileName)) + _strName = dr[1].ToString(); + else + _strName = dr[fileName].ToString(); } } @@ -876,7 +1433,6 @@ } } } - return ""; } @@ -905,6 +1461,258 @@ 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(); + } + + + public delegate void DelegateGetModel(string guid); + public delegate void DelegateGetList(int currentPage); + /// <summary> + /// + /// </summary> + /// <param name="gridView1">gridview</param> + /// <param name="picCheckBox">鍥炬爣鎸夐挳</param> + /// <param name="fm"></param> + /// <param name="fileName">瀛楁</param> + /// <param name="icoName">鍥炬爣璺緞</param> + /// <param name="action"></param> + public static void SetGridViewParameter(GridView gridView1, PictureBox picCheckBox = null, Form fm = null, string fileName = "checkStatus", string icoName = "", DelegateGetModel action = null) + { + gridView1.OptionsView.ColumnAutoWidth = false;//鑷姩璋冩暣鍒楀 + foreach (GridColumn column in gridView1.Columns) + { + column.OptionsFilter.AutoFilterCondition = AutoFilterCondition.Contains; + column.OptionsFilter.ImmediateUpdateAutoFilter = false; + column.OptionsColumn.AllowEdit = true; + 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.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 (picCheckBox != null) + { + gridView1.FocusedRowChanged += (s, e) => + { + UtilityHelper.SetCheckIco(s, picCheckBox, fm, fileName, icoName); + }; + } + if (action != null) + { + gridView1.ShownEditor += (sender, e) => + { + DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView; + view.ActiveEditor.DoubleClick += (ssssss, eeeeeee) => + { + int _handle = gridView1.FocusedRowHandle; + if (_handle == -1) + return; + DataRow row = gridView1.GetDataRow(_handle); + if (row == null) + return; + string _guid = row["guid"].ToString(); + if (string.IsNullOrEmpty(_guid)) + return; + action(_guid); + }; + if (view.ActiveEditor is TextEdit) + view.ActiveEditor.MouseUp += ActiveEditor_MouseUp; + }; + } + + } + private static void ActiveEditor_MouseUp(object sender, MouseEventArgs e) + { + BaseEdit edit = sender as BaseEdit; + edit.MouseUp -= ActiveEditor_MouseUp; + edit.SelectAll(); + } + + public static void SetTabParameter(GridView gridView1, DevExpress.XtraTab.XtraTabControl xtraTabControl1, UcPageBar pageBar1, DelegateGetModel action = null, DelegateGetList page = null) + { + xtraTabControl1.SelectedPageChanged += (s, e) => + { + if (xtraTabControl1.SelectedTabPageIndex == 1) + { + int _handle = gridView1.FocusedRowHandle; + if (_handle == -1) + return; + DataRow row = gridView1.GetDataRow(_handle); + if (row == null) + return; + string _guid = row["guid"].ToString(); + if (string.IsNullOrEmpty(_guid)) + return; + action(_guid); + } + if (xtraTabControl1.SelectedTabPageIndex == 0) + { + page(pageBar1.CurrentPage); + } + }; + } + + /// <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 SetGridViewParameterMx(GridView gridView1) + { + gridView1.OptionsView.ColumnAutoWidth = false;//鑷姩璋冩暣鍒楀 + 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> @@ -936,6 +1744,7 @@ { return Text.ToString(); } + } /// <summary> -- Gitblit v1.9.3