快速过滤方案

yusijie

2024-01-10 206e3f37f68a22e523969982c5ec83f7089678db

 WebAPI/ListModels.cs

@@ -6,6 +6,7 @@
using System.IO;
using System.Text;
using WebAPI.Code;
using Model;

namespace WebAPI
{
@@ -38,6 +39,20 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ICMOReportBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ICMOReportBillMain>>(jsonString);
            return list;
        }



        /// <summary>
        /// 收料通知单反序列化
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsCg_POInStockBillMain> getPOInStockBillMainByJson(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsCg_POInStockBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsCg_POInStockBillMain>>(jsonString);
            return list;
        }
        /// <summary>
@@ -108,6 +123,8 @@
            List<Model.ClsKf_MateOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_MateOutBillMain>>(jsonString);
            return list;
        }


        /// <summary>
        /// 生产补料反序列化
        /// </summary>
@@ -152,6 +169,44 @@
            List<Model.ClsKf_SellOutBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsKf_SellOutBillMain>>(jsonString);
            return list;
        }

        /// <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>
        /// 销售退库反序列化
@@ -478,6 +533,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
@@ -493,7 +559,7 @@


        /// <summary>
        /// 处理新增模具维修子表的json
        /// 处理新增模具维修子表保养信息的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
@@ -501,6 +567,18 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_MouldRepairWorkBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillSub>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增模具维修子表配件信息的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSb_MouldRepairWorkBillSub_Item> getObjectByJson_Gy_MouldRepairWorkBillSub_Item(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_MouldRepairWorkBillSub_Item> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillSub_Item>>(jsonString);
            return list;
        }

@@ -640,6 +718,163 @@
        }

        /// <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>
        /// 处理新增检测值表的json
        /// </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>
        /// 处理新增检测方法表的json
        /// </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>
        /// 处理新增检测仪器表的json   
        /// </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>
        /// 处理新增检验依据表的json   
        /// </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>
        /// 处理新增岗位技能表的json
        /// </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_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;
        }

        /// <summary>
        /// 处理新增故障原因表的json
        /// </summary>
        /// <param name="jsonString"></param>
@@ -708,6 +943,42 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldMaintainRuleBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldMaintainRuleBillMain>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增器具点检规程项目的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_MouldDotCheckRuleBillMain> getObjectByJson_Sc_MouldDotCheckRuleBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckRuleBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckRuleBillMain>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增器具点检规程 子表点检项目的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_MouldDotCheckRuleBillSub> getObjectByJson_Sc_MouldDotCheckRuleBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckRuleBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckRuleBillSub>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增器具点检规程 子表 配件的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_MouldDotCheckRuleBillSub_Item> getObjectByJson_Sc_MouldDotCheckRuleBillSub_Item(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckRuleBillSub_Item> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckRuleBillSub_Item>>(jsonString);
            return list;
        }

@@ -809,7 +1080,7 @@
        }

        /// <summary>
        /// 处理新增模具点检记录表子表的json
        /// 处理新增模具点检记录表子表 点检项目 的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
@@ -817,6 +1088,18 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckBillSub>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增模具点检记录表子表 配件信息 的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_MouldDotCheckBillSub_Item> getObjectByJson_Sc_MouldDotCheckBillSub_Item(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckBillSub_Item> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckBillSub_Item>>(jsonString);
            return list;
        }

@@ -847,6 +1130,19 @@
        }

        /// <summary>
        /// 处理新增模具点检计划表 配件子表的json
        /// ClsSc_MouldDotCheckPlanBillSub
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsSc_MouldDotCheckPlanBillSub_Item> getObjectByJson_Sc_MouldDotCheckPlanBillSub_Item(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_MouldDotCheckPlanBillSub_Item> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldDotCheckPlanBillSub_Item>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增职员表的json
        /// </summary>
        /// <param name="jsonString"></param>
@@ -868,6 +1164,18 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.ClsGy_Material_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_Material_Model>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理新增条码拆码的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsGy_BarCodeEdit_Model> getObjectByJson_Gy_SplitBarCode(string jsonString)
        {
            //jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsGy_BarCodeEdit_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_BarCodeEdit_Model>>(jsonString);
            return list;
        }

@@ -1016,6 +1324,30 @@
        }

        /// <summary>
        /// 处理器具状态表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsGy_MouldStatus_Model> getObjectByJson_Gy_MouldStatus(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsGy_MouldStatus_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_MouldStatus_Model>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理设备状态表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsGy_EquipStatus_Model> getObjectByJson_Gy_EquipStatus(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsGy_EquipStatus_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_EquipStatus_Model>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理单据类型表的json
        /// </summary>
        /// <param name="jsonString"></param>
@@ -1026,7 +1358,19 @@
            List<Model.ClsXt_BillType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXt_BillType_Model>>(jsonString);
            return list;
        }
        

        /// <summary>
        /// 处理单据子类型表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsXt_BillSubType_Model> getObjectByJson_Xt_BillSubType(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsXt_BillSubType_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXt_BillSubType_Model>>(jsonString);
            return list;
        }

        /// <summary>
        /// 处理收款条件表的json
        /// </summary>
@@ -1373,6 +1717,171 @@
            List<Model.ClsSb_EquipDotCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipDotCheckBillSub>>(jsonString);
            return list;
        }

        ///设备入库检验验收单 子表
        ///ClsSb_EquipStockInCheckBillSub
        public List<Model.ClsSb_EquipStockInCheckBillSub> getObjectByJson_ClsSb_EquipStockInCheckBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_EquipStockInCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipStockInCheckBillSub>>(jsonString);
            return list;
        }


        ///设备入库检验验收单 主表
        ///ClsSb_EquipStockInCheckBillMain
        public List<Model.ClsSb_EquipStockInCheckBillMain> getObjectByJson_ClsSb_EquipStockInCheckBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_EquipStockInCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipStockInCheckBillMain>>(jsonString);
            return list;
        }

        ///工序返工申请单 主表
        ///ClsSc_ProcExchWorkBackBillMain
        public List<Model.ClsSc_ProcExchWorkBackBillMain> getObjectByJson_ClsSc_ProcExchWorkBackBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcExchWorkBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchWorkBackBillMain>>(jsonString);
            return list;
        }

        ///工序返工申请单 子表
        ///ClsSb_EquipStockInCheckBillSub
        public List<Model.ClsSc_ProcExchWorkBackBillSub> getObjectByJson_ClsSc_ProcExchWorkBackBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcExchWorkBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchWorkBackBillSub>>(jsonString);
            return list;
        }

        ///工序返工记录单 主表
        ///ClsSc_ProcExchRecordBackBillMain
        public List<Model.ClsSc_ProcExchRecordBackBillMain> getObjectByJson_ClsSc_ProcExchRecordBackBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcExchRecordBackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchRecordBackBillMain>>(jsonString);
            return list;
        }

        ///工序返工记录单 子表
        ///ClsSc_ProcExchRecordBackBillSub
        public List<Model.ClsSc_ProcExchRecordBackBillSub> getObjectByJson_ClsSc_ProcExchRecordBackBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcExchRecordBackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchRecordBackBillSub>>(jsonString);
            return list;
        }

        ///工序派工单 主表
        ///ClsSc_ProcExchWorkBackBillMain
        public List<Model.ClsSc_ProcessSendWorkMain> getObjectByJson_ClsSc_ProcessSendWorkMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcessSendWorkMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcessSendWorkMain>>(jsonString);
            return list;
        }

        ///工序派工单 子表
        ///ClsSc_ProcExchWorkBackBillMain
        public List<Model.ClsSc_ProcessSendWorkSub> getObjectByJson_ClsSc_ProcessSendWorkSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcessSendWorkSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcessSendWorkSub>>(jsonString);
            return list;
        }

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

        ///流转卡工序派工单 子表
        ///ClsSc_ProcExchWorkBackBillMain
        public List<Model.ClsSc_ProcExchSendWorkBillSub> getObjectByJson_ClsSc_ProcExchSendWorkBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSc_ProcExchSendWorkBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchSendWorkBillSub>>(jsonString);
            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)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_EquipWorkBeforeCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipWorkBeforeCheckBillSub>>(jsonString);
            return list;
        }


        ///设备投产检验验收单 主表
        ///ClsSb_EquipWorkBeforeCheckBillMain
        public List<Model.ClsSb_EquipWorkBeforeCheckBillMain> getObjectByJson_ClsSb_EquipWorkBeforeCheckBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSb_EquipWorkBeforeCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSb_EquipWorkBeforeCheckBillMain>>(jsonString);
            return list;
        }


        /// <summary>
        /// 设备保养计划 主表
@@ -2032,6 +2541,18 @@
        }

        /// <summary>
        /// 用户工序关系信息表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Models.Gy_UserProcess> getObjectByJson_Gy_UserProcess(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.Gy_UserProcess> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.Gy_UserProcess>>(jsonString);
            return list;
        }

        /// <summary>
        /// 用户-用户关系信息表的json
        /// </summary>
        /// <param name="jsonString"></param>
@@ -2112,6 +2633,18 @@
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.Department>>(jsonString);
            return list;
        }

        /// <summary>
        /// 用户工作中心关系信息表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Models.WorkCenter> getObjectByJson_WorkCenter(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.WorkCenter> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.WorkCenter>>(jsonString);
            return list;
        }

@@ -2256,6 +2789,295 @@
            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.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>
        /// 付款单子表json2
        /// </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>
        /// 信用额度申请单主表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.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 

        #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)
        {
@@ -2354,5 +3176,48 @@
            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;
        }

        /// <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;
        }

    }
}