From ffbcbb6ac13d3e700e51ea37063c9a5f4a8a3455 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期二, 16 一月 2024 16:15:17 +0800 Subject: [PATCH] 1.收料通知单编辑功能完善, 保存方法中,增加 反写关联数量至 采购订单的 存储过程增加超过关闭,反关闭 2.首件检验单保存方法,增加 调用 保存前控制 h_p_QC_FirstPieceCheckBill_BeforeSaveCtrl 和保存后控制 h_p_QC_FirstPieceCheckBill_AfterSaveCtrl的 存储过程。 巡检单保存方法,增加 调用 保存前控制 h_p_QC_PatrolProcCheckBill_BeforeSaveCtrl 和保存后控制 h_p_QC_PatrolProcCheckBill_AfterSaveCtrl的 存储过程。 工序检验单保存方法,增加 调用 保存前控制 h_p_QC_ProcessCheckBill_BeforeSaveCtrl 和保存后控制 h_p_QC_ProcessCheckBill_AfterSaveCtrl的 存储过程。设备保养记录单保存方法,增加 调用 保存前控制 h_p_Sb_EquipMaintainBill_BeforeSaveCtrl 和保存后控制 h_p_Sb_EquipMaintainBill_AfterSaveCtrl的 存储过程。 设备点检记录单保存方法,增加 调用 保存前控制 h_p_Sb_EquipDotCheckBill_BeforeSaveCtrl 和保存后控制 h_p_Sb_EquipDotCheckBill_AfterSaveCtrl的 存储过程。 设备故障登记单保存方法,增加 调用 保存前控制 h_p_Sb_EquipConkBookBill_BeforeSaveCtrl 和保存后控制 h_p_Sb_EquipConkBookBill_AfterSaveCtrl的 存储过程。 设备维修记录单保存方法,增加 调用 保存前控制 h_p_Sb_EquipRepairWorkBill_BeforeSaveCtrl 和保存后控制 h_p_Sb_EquipRepairWorkBill_AfterSaveCtrl的 存储过程。 --- WebAPI/ListModels.cs | 320 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 320 insertions(+), 0 deletions(-) diff --git a/WebAPI/ListModels.cs b/WebAPI/ListModels.cs index ddb2ff5..e518643 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -6,6 +6,7 @@ using System.IO; using System.Text; using WebAPI.Code; +using Model; namespace WebAPI { @@ -122,6 +123,8 @@ List<Model.ClsKf_MateOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_MateOutBillMain>>(jsonString); return list; } + + /// <summary> /// 鐢熶骇琛ユ枡鍙嶅簭鍒楀寲 /// </summary> @@ -202,6 +205,8 @@ List<Model.ClsXs_SeOutStockBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOutStockBackBillSub>>(jsonString); return list; } + + /// <summary> /// 閿�鍞��搴撳弽搴忓垪鍖� @@ -709,6 +714,235 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsGy_BadReason_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_BadReason_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板涓嶈壇鍚庢灉琛ㄧ殑json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_BadResult_Model> getObjectByJson_Gy_BadResult(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_BadResult_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_BadResult_Model>>(jsonString); + return list; + } + + /// <summary> + /// 澶勭悊鏂板妫�娴嬪�艰〃鐨刯son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsGy_InspectValue_Model> getObjectByJson_Gy_InspectValue(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsGy_InspectValue_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_InspectValue_Model>>(jsonString); + return list; + } + + /// <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> + /// <returns></returns> + public List<Model.ClsGy_BadType_Model> getObjectByJson_Gy_BadType(string jsonString) + { + 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; } @@ -2627,6 +2861,18 @@ return list; } + /// <summary> + /// 寮傚父鍙嶉鍗曞洖澶嶅垪琛ㄥ瓙琛╦son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Models.ClsOA_ErrMsgBackBillSub> getObjectByJson_Gy_MESTransFerWorkBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Models.ClsOA_ErrMsgBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsOA_ErrMsgBackBillSub>>(jsonString); + return list; + } + #region 瀹㈣瘔澶勭悊鍗� /// <summary> /// 瀹㈣瘔澶勭悊鍗曚富琛╦son @@ -2704,6 +2950,30 @@ } #endregion + #region 浠樻鍗� + /// <summary> + /// 浠樻鍗曚富琛╦son + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYF_PayMentBillMain> getObjectByJson_YF_PayMentBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYF_PayMentBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentBillMain>>(jsonString); + return list; + } + /// <summary> + /// 浠樻鍗曞瓙琛╦son2 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYF_PayMentBillSub> getObjectByJson_YF_PayMentBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYF_PayMentBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentBillSub>>(jsonString); + return list; + } + #endregion #region 淇$敤棰濆害鐢宠鍗� /// <summary> /// 淇$敤棰濆害鐢宠鍗曚富琛╦son @@ -2825,6 +3095,31 @@ { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsYS_ReceiveBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveBackBillSub>>(jsonString); + return list; + } + #endregion + + #region 搴斾粯閫�娆惧崟 + /// <summary> + /// 搴旀敹閫�娆惧崟涓昏〃json + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYF_PayMentBackBillMain> getObjectByJson_YF_PayMentBackBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYF_PayMentBackBillMain > list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentBackBillMain>>(jsonString); + return list; + } + /// <summary> + /// 搴旀敹閫�娆惧崟瀛愯〃json2 + /// </summary> + /// <param name="jsonString"></param> + /// <returns></returns> + public List<Model.ClsYF_PayMentBackBillSub> getObjectByJson_YF_PayMentBackBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsYF_PayMentBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYF_PayMentBackBillSub>>(jsonString); return list; } #endregion @@ -2971,5 +3266,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