基础资料问题优化

yl

2022-06-21 f7fdf63c13241dfa7d66a3315fd54429670e24bf

 VueWebApi/Tools/DapperHelper.cs

@@ -214,6 +214,35 @@
        }

        /// <summary>
        /// Dapper执行存储过程返回datatable数据(带参数)
        /// </summary>
        /// <param name="sql">存储过程名</param>
        /// <param name="parm">参数</param>
        /// <returns></returns>
        public static DataTable selectProcedure(string sql, Object parm)
        {
            //sql语句
            try
            {
                using (IDbConnection conn = sqlConnection())
                {
                    DataTable table = new DataTable();
                    //var data = conn.ExecuteReader(sql, parm);
                    var res = conn.ExecuteReader(sql, parm, commandType: CommandType.StoredProcedure);//sql 存储过程 
                    table.Load(res);
                    return table;
                }
            }
            catch (Exception ex)
            {
                //创建日志记录组件实例
                LogHelper.WriteLog(ex);
                throw ex;
            }

        }

        /// <summary>
        /// Dapper查询返回数据条数
        /// </summary>
        /// <param name="sql"></param>