From 319d80c37022dd5847e1f9243d6137a479a2f5af Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 21 三月 2024 10:26:12 +0800 Subject: [PATCH] excel导入工序工价 --- WebAPI/ListModels.cs | 136 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 136 insertions(+), 0 deletions(-) diff --git a/WebAPI/ListModels.cs b/WebAPI/ListModels.cs index 51bcc6c..0e8695a 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -637,6 +637,7 @@ return list; } + /// <summary> /// 澶勭悊鏂板妯″叿缁翠慨楠屾敹鍗曞瓙琛ㄧ殑json @@ -649,6 +650,80 @@ List<Model.ClsSc_MouldRepairCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldRepairCheckBillSub>>(jsonString); return list; } + + /// <summary> + /// 澶勭悊鏂板鍏朵粬鍏ュ簱鍗曚富琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_OtherInBillMain> getObjectByJson_Kf_OtherInBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_OtherInBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_OtherInBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鍏跺畠鍏ュ簱鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_OtherInBillSub> getObjectByJson_Kf_OtherInBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_OtherInBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_OtherInBillSub>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鐩存帴璋冩嫧鍗曚富琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_MoveStockBillMain> getObjectByJson_Kf_MoveStockBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_MoveStockBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_MoveStockBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鐩存帴璋冩嫧鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_MoveStockBillSub> getObjectByJson_Kf_MoveStockBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_MoveStockBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_MoveStockBillSub>>(jsonString); + return list; + } + + + /// <summary> + /// 澶勭悊鏂板鍏朵粬鍑哄簱鍗曚富琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_OtherOutBillMain> getObjectByJson_Kf_OtherOutBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_OtherOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_OtherOutBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鍏跺畠鍑哄簱鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_OtherOutBillSub> getObjectByJson_Kf_OtherOutBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_OtherOutBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_OtherOutBillSub>>(jsonString); + return list; + } + /// <summary> /// 澶勭悊鏂板妯″叿鏁呴殰鐧昏鍗曚富琛ㄧ殑json @@ -1175,6 +1250,18 @@ } /// <summary> + /// 澶勭悊鏂板鍏朵粬搴旀敹鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYS_ReceiveOtherBillSub> getObjectByJson_YS_ReceiveOtherBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYS_ReceiveOtherBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveOtherBillSub>>(jsonString); + return list; + } + + /// <summary> /// 澶勭悊鏂板鍏朵粬搴斾粯鍗曡〃鐨刯son /// </summary> /// <param name="jsonString"></param> @@ -1183,6 +1270,18 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsYF_PayMentOtherBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentOtherBillMain>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鍏朵粬搴旀敹鍗曞瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYF_PayMentOtherBillSub> getObjectByJson_YF_PayMentOtherBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYF_PayMentOtherBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentOtherBillSub>>(jsonString); return list; } @@ -3102,6 +3201,31 @@ return list; } + /// <summary> + /// 鍥哄畾璧勪骇鍗$墖 涓昏〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + // ClsGy_FixCardBillMain + public List<Model.ClsGy_FixCardBillMain> getObjectByJson_Gy_FixCardBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_FixCardBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_FixCardBillMain>>(jsonString); + return list; + } + /// <summary> + /// 鍥哄畾璧勪骇鍗$墖 瀛愯〃 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + // ClsGy_FixCardBillSub_Emp + public List<Model.ClsGy_FixCardBillSub_Emp> getObjectByJson_Gy_FixCardBillSub_Emp(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_FixCardBillSub_Emp> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_FixCardBillSub_Emp>>(jsonString); + return list; + } + #region 瀹㈣瘔澶勭悊鍗� /// <summary> /// 瀹㈣瘔澶勭悊鍗曚富琛╦son @@ -3595,5 +3719,17 @@ return list; } + /// <summary> + /// 鍑洪棬纭鍗曞弽搴忓垪鍖� + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsXs_OutDoorCheckBillMain> getOutDoorCheckBillMainByJson(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXs_OutDoorCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_OutDoorCheckBillMain>>(jsonString); + return list; + } + } } \ No newline at end of file -- Gitblit v1.9.1