From c49474b5c61b8c915bbaf7048fd3e507cebda41f Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 18 六月 2025 10:17:59 +0800 Subject: [PATCH] 职员列表取消后端排序排序由前端设置 --- WebAPI/ListModels.cs | 360 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 358 insertions(+), 2 deletions(-) diff --git a/WebAPI/ListModels.cs b/WebAPI/ListModels.cs index 87001b8..ba58962 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -8,6 +8,7 @@ using WebAPI.Code; using Model; using System.Data; +using System.Text.RegularExpressions; namespace WebAPI { @@ -223,6 +224,30 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsKf_SellOutBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_SellOutBillSub>>(jsonString); + return list; + } + + /// <summary> + /// 瀹㈡埛鏍囩鍙嶅簭鍒楀寲 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSc_CustomerTagInfoMain> getCustomerTagInfoMainByJson(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_CustomerTagInfoMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_CustomerTagInfoMain>>(jsonString); + return list; + } + + /// <summary> + /// 瀹㈡埛鏍囩鍙嶅簭鍒楀寲瀛愯〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSc_CustomerTagInfoSub> getCustomerTagInfoSubByJson(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_CustomerTagInfoSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_CustomerTagInfoSub>>(jsonString); return list; } @@ -1160,7 +1185,55 @@ List<Model.ClsGy_ProjectMoney_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ProjectMoney_Model>>(jsonString); return list; } - + + /// <summary> + /// 澶勭悊鏂板椤圭洰璐圭敤鍒嗙被琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_ProjectMoneyClass_Model> getObjectByJson_Gy_ProjectMoneyClass(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_ProjectMoneyClass_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ProjectMoneyClass_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板璁惧鑺傛媿琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsEqiupMaterWorkTimes_Model> getObjectByJson_EqiupMaterWorkTimes(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsEqiupMaterWorkTimes_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsEqiupMaterWorkTimes_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板绠″緞琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PiPe_Model> getObjectByJson_Gy_PiPe(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PiPe_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PiPe_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板绠″緞鏉愯川琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PiPeMaterial_Model> getObjectByJson_Gy_PiPeMaterial(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PiPeMaterial_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PiPeMaterial_Model>>(jsonString); + return list; + } + /// <summary> /// 澶勭悊鏂板闃查敊瑁呯疆琛ㄧ殑json /// </summary> @@ -1313,6 +1386,55 @@ List<Model.ClsGy_ErrMsgBackType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ErrMsgBackType_Model>>(jsonString); return list; } + + /// <summary> + /// 澶勭悊鏂板宸ヨ壓璺嚎澶х被琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_RoutingGroup_Model> getObjectByJson_Gy_RoutingGroup(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_RoutingGroup_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_RoutingGroup_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板 缁翠慨楠屾敹椤圭洰鍒嗙被 琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_RepairCheckClass_Model> getObjectByJson_Gy_RepairCheckClass(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_RepairCheckClass_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_RepairCheckClass_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板 缁翠慨椤圭洰鍒嗙被 琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_RepairClass_Model> getObjectByJson_Gy_RepairClass(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_RepairClass_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_RepairClass_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板 淇濆吇椤圭洰鍒嗙被 琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_MaintainClass_Model> getObjectByJson_Gy_MaintainClass(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_MaintainClass_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_MaintainClass_Model>>(jsonString); + return list; + } + /// <summary> /// 澶勭悊鏂板寮傚父绫诲瀷琛ㄧ殑json @@ -1637,6 +1759,30 @@ } /// <summary> + /// 澶勭悊鏂板浜х嚎鍣ㄥ叿娓呭崟琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_SourceMouldBillMain> getObjectByJson_Gy_SourceMouldBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_SourceMouldBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SourceMouldBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板浜х嚎鍣ㄥ叿娓呭崟瀛愯〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_SourceMouldBillSub> getObjectByJson_Gy_SourceMouldBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_SourceMouldBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SourceMouldBillSub>>(jsonString); + return list; + } + + /// <summary> /// 澶勭悊鏂板浜у搧宸ヨ壓鍙傛暟娓呭崟琛ㄧ殑json /// </summary> /// <param name="jsonString"></param> @@ -1683,6 +1829,55 @@ List<Model.ClsYS_ReceiveOtherBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveOtherBillSub>>(jsonString); return list; } + + /// <summary> + /// 澶勭悊鏂板閿�鍞姤浠峰崟琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsXs_SeQuotationBillMain> getObjectByJson_Xs_SeQuotationBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXs_SeQuotationBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeQuotationBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板閿�鍞姤浠峰瓙鍗曡〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsXs_SeQuotationBillSub> getObjectByJson_Xs_SeQuotationBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXs_SeQuotationBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeQuotationBillSub>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板瀹㈡埛鎷滆璁板綍鍗曡〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsCrm_ComplainVisitBillMain> getObjectByJson_Crm_ComplainVisitBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsCrm_ComplainVisitBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsCrm_ComplainVisitBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板瀹㈡埛鎷滆璁板綍鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsCrm_ComplainVisitBillSub> getObjectByJson_Crm_ComplainVisitBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsCrm_ComplainVisitBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsCrm_ComplainVisitBillSub>>(jsonString); + return list; + } + /// <summary> /// 澶勭悊鏂板鍏朵粬搴斾粯鍗曡〃鐨刯son @@ -1972,7 +2167,10 @@ /// <returns></returns> public List<Models.ClsGy_Material_Model> getObjectByJson_Gy_Material(string jsonString) { - jsonString = "[" + jsonString.ToString() + "]"; + if (Regex.IsMatch(jsonString, @"^\[.*\]$") == false) + { + jsonString = "[" + jsonString.ToString() + "]"; + } List<Models.ClsGy_Material_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_Material_Model>>(jsonString); return list; } @@ -1990,6 +2188,18 @@ } /// <summary> + /// 澶勭悊鏂板宸℃椤圭洰鍒嗙被琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PatrolCheckItemClass_Model> getObjectByJson_Gy_PatrolCheckItemClass(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PatrolCheckItemClass_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PatrolCheckItemClass_Model>>(jsonString); + return list; + } + + /// <summary> /// 澶勭悊鏂板鐐规鏂规硶琛ㄧ殑json /// </summary> /// <param name="jsonString"></param> @@ -1998,6 +2208,18 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsGy_DotCheckItemMethod_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DotCheckItemMethod_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板宸℃鏂规硶琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PatrolCheckItemMethod_Model> getObjectByJson_Gy_PatrolCheckItemMethod(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PatrolCheckItemMethod_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PatrolCheckItemMethod_Model>>(jsonString); return list; } @@ -2367,6 +2589,28 @@ return list; } + /// <summary> + /// 璁惧宸℃璁″垝鍗� 涓昏〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSb_EquipPatrolCheckPlanBillMain> getObjectByJson_Sb_EquipPatrolCheckPlanBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSb_EquipPatrolCheckPlanBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipPatrolCheckPlanBillMain>>(jsonString); + return list; + } + /// <summary> + /// 璁惧宸℃璁″垝鍗� 瀛愯〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSb_EquipPatrolCheckPlanBillSub> getObjectByJson_Sb_EquipPatrolCheckPlanBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSb_EquipPatrolCheckPlanBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipPatrolCheckPlanBillSub>>(jsonString); + return list; + } /// <summary> @@ -2518,6 +2762,56 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipDotCheckRuleBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckRuleBillSub>>(jsonString); + return list; + } + + /// <summary> + /// 璁惧宸℃瑙勭▼琛� 涓昏〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Models.ClsSb_EquipPatrolCheckRuleBillMain> getObjectByJson_Sb_EquipPatrolCheckRuleBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Models.ClsSb_EquipPatrolCheckRuleBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipPatrolCheckRuleBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 璁惧宸℃瑙勭▼琛� 瀛愯〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Models.ClsSb_EquipPatrolCheckRuleBillSub> getObjectByJson_Sb_EquipPatrolCheckRuleBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Models.ClsSb_EquipPatrolCheckRuleBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipPatrolCheckRuleBillSub>>(jsonString); + return list; + } + + + + /// <summary> + /// 璁惧宸℃璁板綍琛� 涓昏〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSb_EquipPatrolCheckBillMain> getObjectByJson_Sb_EquipPatrolCheckBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSb_EquipPatrolCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipPatrolCheckBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 璁惧宸℃璁板綍琛� 瀛愯〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSb_EquipPatrolCheckBillSub> getObjectByJson_Sb_EquipPatrolCheckBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSb_EquipPatrolCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipPatrolCheckBillSub>>(jsonString); return list; } @@ -3178,6 +3472,30 @@ return list; } + /// <summary> + /// 澶勭悊鏂板妯″叿瀵垮懡鑰楃敤鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSc_MouldLifeUseBillMain> getObjectByJson_Gy_MouldLifeUseBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_MouldLifeUseBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldLifeUseBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板妯″叿瀵垮懡鑰楃敤鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsSc_MouldLifeUseBillSub> getObjectByJson_Gy_MouldLifeUseBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_MouldLifeUseBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldLifeUseBillSub>>(jsonString); + return list; + } + /// <summary> /// 澶勭悊鏂板鐢熶骇姹囨姤鍗曞崟涓昏〃鐨刯son @@ -3357,6 +3675,17 @@ return list; } + /// <summary> + /// PDA澶勭悊鏂板璁惧宸℃璁板綍鍗曚富琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Models.ClsSb_EquipPatrolCheckBillMain> getObjectByJson_Sb_EquipPatrolCheckBillMainPDA(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Models.ClsSb_EquipPatrolCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipPatrolCheckBillMain>>(jsonString); + return list; + } /// <summary> /// PDA澶勭悊鏂板璁惧鐐规璁板綍鍗曞瓙琛ㄧ殑json @@ -3367,6 +3696,18 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipDotCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckBillSub>>(jsonString); + return list; + } + + /// <summary> + /// PDA澶勭悊鏂板璁惧宸℃璁板綍鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Models.ClsSb_EquipPatrolCheckBillSub> getObjectByJson_Sb_EquipPatrolCheckBillSubPDA(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Models.ClsSb_EquipPatrolCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipPatrolCheckBillSub>>(jsonString); return list; } @@ -4341,6 +4682,21 @@ } #endregion + #region 鐢熶骇棰嗘枡鍗� + public List<Model.ClsKf_ProductReceiveMaterialBillMain> getObjectByJson_Kf_ProductReceiveMaterialBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_ProductReceiveMaterialBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_ProductReceiveMaterialBillMain>>(jsonString); + return list; + } + public List<Model.ClsKf_ProductReceiveMaterialBillSub> getObjectByJson_Kf_ProductReceiveMaterialBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_ProductReceiveMaterialBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_ProductReceiveMaterialBillSub>>(jsonString); + return list; + } + #endregion + #region 搴旀敹閫�娆惧崟 /// <summary> /// 搴旀敹閫�娆惧崟涓昏〃json -- Gitblit v1.9.1