Excel 角色清单导入，工序检验扫码

yl

2022-07-20 14a48ba934fabee90b5d52471ca47883f6007732

 VueWebApi/DLL/DAL/ErpSyncMesDAL.cs

@@ -11,8 +11,45 @@
    {
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象

        #region[制造模型：单位同步]
        public static ToMessage SeaveSearchUnit(string username)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPUnit";
                dynamicParams.Add("@username", username);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "同步单位成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "同步单位失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[制造模型：存货分类同步]
        public static ToMessage SeaveSearchInventoryClass(string username)
        public static ToMessage SeaveSearchInventoryClass()
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
@@ -20,7 +57,7 @@
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPInventory_Class";
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                bool a = DapperHelper.IsProcedureNo(sql);
                if (a)
                {
                    mes.code = "200";
@@ -159,7 +196,7 @@
        #endregion

        #region[生产管理：生产订单同步]
        public static ToMessage SeaveSearchErpOrder(string username)
        public static ToMessage SeaveSearchErpOrder()
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
@@ -167,8 +204,7 @@
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPMO";
                dynamicParams.Add("@username", username);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                bool a = DapperHelper.IsProcedureNo(sql);
                if (a)
                {
                    mes.code = "200";