From 1413158ae9f0fc5ac7eb39deeab7d5cc09950ad1 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 01 二月 2024 10:57:51 +0800 Subject: [PATCH] 工序流转卡派工单删除方法,增加调用删除 前控制h_p_Sc_ProcExchSendWorkBill_BeforeDelCtrl 和删除 后控制h_p_Sc_ProcExchSendWorkBill_AfterDelCtrl 的存储过程。 工序委外派工单删除方法,增加 调用删除前控制h_p_WW_EntrustWorkOrderBill_BeforeDelCtrl 和删除后控制h_p_WW_EntrustWorkOrderBill_AfterDelCtrl 的存储过程。 工序进站接收单删除方法,增加调用删除前控制h_p_Sc_StationInBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationInBill_AfterDelCtrl 的存储过程。 工序出站汇报单删除方法,增加调用删除前控制h_p_Sc_StationOutBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationOutBill_AfterDelCtrl 的存储过程 --- WebAPI/ListModels.cs | 281 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 281 insertions(+), 0 deletions(-) diff --git a/WebAPI/ListModels.cs b/WebAPI/ListModels.cs index 9c3fc63..5573e28 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -158,6 +158,36 @@ List<Model.ClsKf_EntrustOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_EntrustOutBillMain>>(jsonString); return list; } + + + #region 閿�鍞��璐у弽搴忓垪鍖� + /// <summary> + /// 閿�鍞��璐у弽搴忓垪鍖� + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_ICStockBackBillMain> getICStockBackBillMainByJson(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_ICStockBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_ICStockBackBillMain>>(jsonString); + return list; + } + #endregion + #region 閿�鍞��璐у瓙琛ㄥ弽搴忓垪鍖� + /// <summary> + /// 閿�鍞��璐у瓙琛ㄥ弽搴忓垪鍖� + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsKf_ICStockBackBillSub> getICStockBackBillSubByJson(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsKf_ICStockBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_ICStockBackBillSub>>(jsonString); + return list; + } + #endregion + + /// <summary> /// 閿�鍞嚭搴撳弽搴忓垪鍖� /// </summary> @@ -742,6 +772,54 @@ } /// <summary> + /// 澶勭悊鏂板妫�娴嬫柟娉曡〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_InspectMethod_Model> getObjectByJson_Gy_InspectMethod(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_InspectMethod_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_InspectMethod_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板璐ㄩ噺鏍囧噯琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_QualityStd_Model> getObjectByJson_Gy_QualityStd(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_QualityStd_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_QualityStd_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板妫�娴嬩华鍣ㄨ〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_InspectInstruMent_Model> getObjectByJson_Gy_InspectInstruMent(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_InspectInstruMent_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_InspectInstruMent_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板妫�楠屼緷鎹〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_InspectBasis_Model> getObjectByJson_Gy_InspectBasis(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_InspectBasis_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_InspectBasis_Model>>(jsonString); + return list; + } + + /// <summary> /// 澶勭悊鏂板涓嶈壇绫诲瀷琛ㄧ殑json /// </summary> /// <param name="jsonString"></param> @@ -750,6 +828,151 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsGy_BadType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_BadType_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板宀椾綅鎶�鑳借〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PostSkill_Model> getObjectByJson_Gy_PostSkill(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PostSkill_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PostSkill_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板宀椾綅琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_Post_Model> getObjectByJson_Gy_Post(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_Post_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_Post_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板璋冩嫧绫诲瀷琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_StockMoveStyle_Model> getObjectByJson_Gy_StockMoveStyle(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_StockMoveStyle_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_StockMoveStyle_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鍏ュ簱绫诲瀷琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_StockInStyle_Model> getObjectByJson_Gy_StockInStyle(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_StockInStyle_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_StockInStyle_Model>>(jsonString); + return list; + } + + + /// <summary> + /// 澶勭悊鏂板鍑哄簱绫诲瀷琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_StockOutStyle_Model> getObjectByJson_Gy_StockOutStyle(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_StockOutStyle_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_StockOutStyle_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鍦板尯琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_AreaSet_Model> getObjectByJson_Gy_AreaSet(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_AreaSet_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_AreaSet_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板閿�鍞柟寮忚〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_SellStyle_Model> getObjectByJson_Gy_SellStyle(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_SellStyle_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SellStyle_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板閲囪喘鏂瑰紡琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_PoStockStyle_Model> getObjectByJson_Gy_PoStockStyle(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_PoStockStyle_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_PoStockStyle_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板鐩樼偣鏂规琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns>s + public List<Model.ClsGy_StockCheckItem_Model> getObjectByJson_Gy_StockCheckItems(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_StockCheckItem_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_StockCheckItem_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板瀹㈡埛鍒嗙被琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_CusType_Model> getObjectByJson_Gy_CusType(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_CusType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_CusType_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板渚涘簲鍟嗗垎绫昏〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_SupType_Model> getObjectByJson_Gy_SupType(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_SupType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SupType_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板寮傚父绫诲瀷琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_ErrType_Model> getObjectByJson_Gy_ErrType(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_ErrType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_ErrType_Model>>(jsonString); return list; } @@ -774,6 +997,39 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsGy_StockCheckItemBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_StockCheckItemBill>>(jsonString); + return list; + } + /// <summary> + /// 澶勭悊鏂板鍛ㄦ�荤粨琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsPM_WorkReportWeekBillMain> getObjectByJson_PM_WorkReportWeekBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsPM_WorkReportWeekBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPM_WorkReportWeekBillMain>>(jsonString); + return list; + } + /// <summary> + /// 澶勭悊鏂板鏈堝害闃舵璁″垝琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsPM_WorkPlanMonthBillMain> getObjectByJson_PM_WorkPlanMonthBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsPM_WorkPlanMonthBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPM_WorkPlanMonthBillMain>>(jsonString); + return list; + } + /// <summary> + /// 澶勭悊鏂板鏈堝害闃舵璁″垝瀛愯〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsPM_WorkPlanMonthBillSub> getObjectByJson_PM_WorkPlanMonthBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsPM_WorkPlanMonthBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPM_WorkPlanMonthBillSub>>(jsonString); return list; } @@ -3073,5 +3329,30 @@ return list; } + /// <summary> + /// 澶勭悊蹇�熻繃婊ゆ柟妗堜富琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsXt_FastICSchemeMain_Model> getObjectByJson_Xt_FastICSchemeMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXt_FastICSchemeMain_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXt_FastICSchemeMain_Model>>(jsonString); + return list; + } + + + /// <summary> + /// 澶勭悊鏂板蹇�熻繃婊ゆ柟妗堝瓙琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsXt_FastICSchemeSub_Model> getObjectByJson_Xt_FastICSchemeSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXt_FastICSchemeSub_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXt_FastICSchemeSub_Model>>(jsonString); + return list; + } + } } \ No newline at end of file -- Gitblit v1.9.1