userentity.cs

2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告

using System;
using System.Data;
namespace OnlineBookSell.SQLServerDAL
{
    public class UserEntity
    {
        /// <summary>
        /// 与用户有关的sql语句
        /// </summary>
        public struct SQL
        {
            //用户登陆
            public const string SQL_USER_LOGIN = @"select * from [user] where username=@UserName and password=@Password";
            //添加用户
            public const string SQL_INSERT_USER = @"insert into [user] username,password,truename,usertype,department values(@UserName,@Password,@TrueName,@UserType,@Department)";
        
        }

        /// <summary>
        /// 存储过程
        /// </summary>
        public struct PROCEDURE
        {
            
        }

       
    }
}