yl
2023-01-06 db8ff228ea3060ab41626074b98e9227b21a35d3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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;
        }
 
    }
}