using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using VueWebApi.Tools; namespace VueWebApi.DLL.DAL { public class UserDataDAL { public static DataTable UserData() { //执行sql // 存储过程名称 string strProcName = "select * from [dbo].[TUser]"; //创建参数 //SqlParameter[] parameters = { new SqlParameter("@name", "张三"), new SqlParameter("@phone", "18888888888") }; //parameters[0].Direction = ParameterDirection.Output; DataTable dt = DBHelper.GetTable(strProcName); return dt; } } }