销售订单：增加 判断单据是否存在的方法

duhe

2023-11-16 1f04dee5f7849d8c0506c9ace925bec768539ea3

 WebAPI/ListModels.cs

@@ -168,6 +168,42 @@
        }

        /// <summary>
        /// 销售出库反序列化子表
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsKf_SellOutBillSub> getSellOutBillSubByJson(string jsonString)
        {
            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.ClsXs_SeOutStockBackBillMain> getSeOutStockBackBillMainByJson(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOutStockBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOutStockBackBillMain>>(jsonString);
            return list;
        }

        /// <summary>
        /// 退货通知单反序列化子表
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_SeOutStockBackBillSub> getSeOutStockBackBillSubByJson(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOutStockBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOutStockBackBillSub>>(jsonString);
            return list;
        }

        /// <summary>
        /// 销售退库反序列化
        /// </summary>
        /// <param name="jsonString"></param>
@@ -492,6 +528,17 @@
            return list;
        }

        /// <summary>
        /// 处理新增巡检单子表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsQC_PatrolProcCheckBillSub_BadReason> getObjectByJson_ClsQC_PatrolProcCheckBillSub_BadReason(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsQC_PatrolProcCheckBillSub_BadReason> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_PatrolProcCheckBillSub_BadReason>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增模具维修主表的json
@@ -662,6 +709,18 @@
        {
            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_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;
        }

@@ -1600,6 +1659,60 @@
            return list;
        }

        ///流转卡工序委外派工单 主表
        ///ClsWW_EntrustWorkOrderBillMain
        public List<Model.ClsWW_EntrustWorkOrderBillMain> getObjectByJson_ClsWW_EntrustWorkOrderBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsWW_EntrustWorkOrderBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsWW_EntrustWorkOrderBillMain>>(jsonString);
            return list;
        }

        ///流转卡工序委外派工单 子表
        ///ClsWW_EntrustWorkOrderBillSub
        public List<Model.ClsWW_EntrustWorkOrderBillSub> getObjectByJson_ClsWW_EntrustWorkOrderBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsWW_EntrustWorkOrderBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsWW_EntrustWorkOrderBillSub>>(jsonString);
            return list;
        }

        ///供应商询价单 主表
        ///ClsSup_AskPriceBillMain
        public List<Model.ClsSup_AskPriceBillMain> getObjectByJson_ClsSup_AskPriceBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSup_AskPriceBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSup_AskPriceBillMain>>(jsonString);
            return list;
        }

        ///供应商询价单 子表
        ///ClsSup_AskPriceBillSub
        public List<Model.ClsSup_AskPriceBillSub> getObjectByJson_ClsClsSup_AskPriceBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSup_AskPriceBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSup_AskPriceBillSub>>(jsonString);
            return list;
        }

        ///供应商报价单 主表
        ///ClsSup_QuotePriceBillMain
        public List<Model.ClsSup_QuotePriceBillMain> getObjectByJson_ClsSup_QuotePriceBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSup_QuotePriceBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSup_QuotePriceBillMain>>(jsonString);
            return list;
        }

        ///供应商报价单 子表
        ///ClsSup_QuotePriceBillSub
        public List<Model.ClsSup_QuotePriceBillSub> getObjectByJson_ClsSup_QuotePriceBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSup_QuotePriceBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSup_QuotePriceBillSub>>(jsonString);
            return list;
        }

        ///设备投产检验验收单 子表
        ///ClsSb_EquipWorkBeforeCheckBillSub
        public List<Model.ClsSb_EquipWorkBeforeCheckBillSub> getObjectByJson_ClsSb_EquipWorkBeforeCheckBillSub(string jsonString)
@@ -2526,6 +2639,246 @@
            return list;
        }

        /// <summary>
        /// 异常反馈单回复列表子表json
        /// </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>
        /// 客诉处理单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsCrm_CustomerAppealBillMain> getObjectByJson_Crm_CustomerAppealBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsCrm_CustomerAppealBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsCrm_CustomerAppealBillMain>>(jsonString);
            return list;
        }

        /// <summary>
        /// 客诉处理单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsCrm_CustomerAppealBillSub> getObjectByJson_Crm_CustomerAppealBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsCrm_CustomerAppealBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsCrm_CustomerAppealBillSub>>(jsonString);
            return list;
        }
        #endregion


        #region 销售订单
        /// <summary>
        /// 销售订单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_SeOrderBillMain> getObjectByJson_Xs_SeOrderBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOrderBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOrderBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 销售订单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_SeOrderBillSub> getObjectByJson_Xs_SeOrderBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOrderBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOrderBillSub>>(jsonString);
            return list;
        }
        #endregion 

        #region 收款单
        /// <summary>
        /// 收款单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsYS_ReceiveBillMain> getObjectByJson_YS_ReceiveBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsYS_ReceiveBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 收款单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsYS_ReceiveBillSub> getObjectByJson_YS_ReceiveBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsYS_ReceiveBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveBillSub>>(jsonString);
            return list;
        }
        #endregion

        #region 信用额度申请单
        /// <summary>
        /// 信用额度申请单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_CusRatingChangeBillMain> getObjectByJson_Xs_CusRatingChangeBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_CusRatingChangeBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_CusRatingChangeBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 信用额度申请单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_CusRatingChangeBillSub> getObjectByJson_Xs_CusRatingChangeBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_CusRatingChangeBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_CusRatingChangeBillSub>>(jsonString);
            return list;
        }
        #endregion

        #region 特批申请单
        /// <summary>
        /// 特批申请单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_ExceptiveCheckRequestBillMain> getObjectByJson_Xs_ExceptiveCheckRequestBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_ExceptiveCheckRequestBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_ExceptiveCheckRequestBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 特批申请单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_ExceptiveCheckRequestBillSub> getObjectByJson_Xs_ExceptiveCheckRequestBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_ExceptiveCheckRequestBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_ExceptiveCheckRequestBillSub>>(jsonString);
            return list;
        }
        #endregion

        #region 销售订单变更单
        /// <summary>
        /// 销售订单变更单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_SeOrderChangeBillMain> getObjectByJson_Xs_SeOrderChangeBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOrderChangeBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOrderChangeBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 销售订单变更单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXs_SeOrderChangeBillSub> getObjectByJson_Xs_SeOrderChangeBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXs_SeOrderChangeBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_SeOrderChangeBillSub>>(jsonString);
            return list;
        }
        #endregion

        #region 生产订单变更单
        /// <summary>
        /// 生产订单变更单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_ICMOChangeBillMain> getObjectByJson_Sc_ICMOChangeBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ICMOChangeBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ICMOChangeBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 生产订单变更单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_ICMOChangeBillSub> getObjectByJson_Sc_ICMOChangeBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ICMOChangeBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ICMOChangeBillSub>>(jsonString);
            return list;
        }
        #endregion

        #region 应收退款单
        /// <summary>
        /// 应收退款单主表json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsYS_ReceiveBackBillMain> getObjectByJson_YS_ReceiveBackBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsYS_ReceiveBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveBackBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 应收退款单子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsYS_ReceiveBackBillSub> getObjectByJson_YS_ReceiveBackBillSub(string jsonString)
        {
            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.ClsPM_WorkTaskWeekBillMain> getObjectByJson_PM_WorkTaskWeekBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsPM_WorkTaskWeekBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPM_WorkTaskWeekBillMain>>(jsonString);
            return list;
        }
        /// <summary>
        /// 工作周计划子表json2
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsPM_WorkTaskWeekBillSub> getObjectByJson_PM_WorkTaskWeekBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsPM_WorkTaskWeekBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPM_WorkTaskWeekBillSub>>(jsonString);
            return list;
        }
        #endregion 


        #region 工资计算单 集体
        public List<Models.ClsPay_GroupBalBillMain> getObjectByJson_Pay_GroupBalBillMain(string jsonString)
        {
@@ -2624,5 +2977,23 @@
            return list;
        }

        ///首件检验单 孙表
        ///ClsQC_FirstPieceCheckBillSub_ValueGrid
        public List<Model.ClsQC_FirstPieceCheckBillSub_ValueGrid> getObjectByJson_ClsQC_FirstPieceCheckBillSub_ValueGrid(string jsonString)
        {
            //jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsQC_FirstPieceCheckBillSub_ValueGrid> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_FirstPieceCheckBillSub_ValueGrid>>(jsonString);
            return list;
        }

        ///工序检验单 孙表
        ///ClsQC_ProcessCheckBillSub_ValueGrid
        public List<Model.ClsQC_ProcessCheckBillSub_ValueGrid> getObjectByJson_ClsQC_ProcessCheckBillSub_ValueGrid(string jsonString)
        {
            //jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsQC_ProcessCheckBillSub_ValueGrid> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_ProcessCheckBillSub_ValueGrid>>(jsonString);
            return list;
        }

    }
}