1.入库记录删除 2.畅捷通T+反写产成品入库单(直接写表) 3.erp同步基础资料和订单改为根据配置取T+或者T8 4.通用基础资料仓库资料放出er...

yl

2024-11-08 cbeb997178132c5c71d57b5011847f7d6e21930a

 VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs

@@ -18,6 +18,7 @@
        public static string strProcName = ""; //定义全局sql变量
        public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
        public static SqlParameter[] parameters; //定义全局SqlParameter参数数组
        public static string ErpPath = AppSetting.GetAppSetting("ErpPath"); //获取ERP配置

        #region[物料管理：计量单位同步]
        public static ToMessage SaveSearchUnit(User us)
@@ -27,7 +28,17 @@
            try
            {
                //存储过程名
                switch (ErpPath)
                {
                    case "T+":
                        sql = @"h_p_IFCLD_TCloundERPUnit";
                        break;
                    case "T8":
                sql = @"h_p_IFCLD_T8ERPUnit";
                        break;
                    default:
                        break;
                }
                dynamicParams.Add("@username", us.usercode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -64,7 +75,17 @@
            try
            {
                //存储过程名
                switch (ErpPath)
                {
                    case "T+":
                        sql = @"h_p_IFCLD_TCloundERPInventory";
                        break;
                    case "T8":
                sql = @"h_p_IFCLD_T8ERPInventory";
                        break;
                    default:
                        break;
                }
                dynamicParams.Add("@username", us.usercode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -101,7 +122,17 @@
            try
            {
                //存储过程名
                switch (ErpPath)
                {
                    case "T+":
                        sql = @"h_p_IFCLD_TCloundERPWhareHousesLocation";
                        break;
                    case "T8":
                sql = @"h_p_IFCLD_T8ERPWhareHousesLocation";
                        break;
                    default:
                        break;
                }
                dynamicParams.Add("@username", us.usercode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -138,7 +169,17 @@
            try
            {
                //存储过程名
                switch (ErpPath)
                {
                    case "T+":
                        sql = @"h_p_IFCLD_TCloundERPPartner";
                        break;
                    case "T8":
                sql = @"h_p_IFCLD_T8ERPPartner";
                        break;
                    default:
                        break;
                }
                dynamicParams.Add("@username", us.usercode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -175,7 +216,17 @@
            try
            {
                //存储过程名
                switch (ErpPath)
                {
                    case "T+":
                        sql = @"h_p_IFCLD_TCloundERPMO";
                        break;
                    case "T8":
                sql = @"h_p_IFCLD_T8ERPMO";
                        break;
                    default:
                        break;
                }
                dynamicParams.Add("@username", us.usercode);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)