SOP文件下拉列表排序

yl

2022-12-06 10efbcfce9f0f17982f4714e76e8cad24fb8f982

 VueWebApi/DLL/DAL/ErpSyncMesDAL.cs

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

        #region[制造模型：存货分类同步]
        public static ToMessage SeaveSearchInventoryClass(string username)
        #region[制造模型：单位同步]
        public static ToMessage SeaveSearchUnit(string username)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPInventory_Class";
                sql = @"h_p_IFCLD_T8ERPUnit";
                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()
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_T8ERPInventory_Class";
                bool a = DapperHelper.IsProcedureNo(sql);
                if (a)
                {
                    mes.code = "200";
@@ -55,7 +92,7 @@
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPInventory";
                sql = @"h_p_IFCLD_T8ERPInventory";
                dynamicParams.Add("@username", username);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -92,7 +129,7 @@
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPWhareHousesLocation";
                sql = @"h_p_IFCLD_T8ERPWhareHousesLocation";
                dynamicParams.Add("@username", username);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -129,7 +166,7 @@
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_ERPPartner";
                sql = @"h_p_IFCLD_T8ERPPartner";
                dynamicParams.Add("@username", username);
                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
                if (a)
@@ -157,5 +194,41 @@
            return mes;
        }
        #endregion

        #region[生产管理：生产订单同步]
        public static ToMessage SeaveSearchErpOrder()
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_T8ERPMO";
                bool a = DapperHelper.IsProcedureNo(sql);
                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
    }
}