yl
2022-12-02 14d02d9f9df720a568d8f08f2921e023642fc260
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;
        }
 
    }
}