RentHouseDAL/UserService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using RentHouseModel;
using System.Data.SqlClient;
using System.Data;

namespace RentHouseDAL
{
    public static class UserService
    {
        public static int AddUser(User user)
        {
            string sql = "insert into Users values(@UserName,@Password,@RealName,@Sex,@Phone,@Email,@Photo,@Mark,@Rank,@Question,@Answer,@RegDate,@Status)";
            SqlParameter[] para = new SqlParameter[] {
                new SqlParameter("@UserName",user.UserName),
                new SqlParameter("@Password",user.Password),
                new SqlParameter("@RealName",user.RealName),
                new SqlParameter("@Sex",user.Sex),
                new SqlParameter("@Phone",user.Phone),
                new SqlParameter("@Email",user.Email),
                new SqlParameter("@Photo",user.Photo),
                new SqlParameter("@Mark",user.Mark),
                new SqlParameter("@Rank",user.Rank),
                new SqlParameter("@Question",user.Question),
                new SqlParameter("@Answer",user.Answer),
                new SqlParameter("@RegDate",user.RegDate),
                new SqlParameter("@Status",user.Status)
            };
            return DBHelper.ExecuteCommand(sql, CommandType.Text, para);
        }

        public static int DeleteUserByUserName(string username)
        {
            string sql = "delete from Users where UserName=@UserName";
            SqlParameter[] para = new SqlParameter[] {
                new SqlParameter("@UserName",username)
            };
            return DBHelper.ExecuteCommand(sql, CommandType.Text, para);
        }

        #region Select
        #region GetCount
        public static int GetAllCount()
        {
            string sql = "select count(*) from Users";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }
        public static int GetFangCount()
        {
            string sql = "select count(*) from Users where Rank=N'房东'";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }
        public static int GetJingCount()
        {
            string sql = "select count(*) from Users where Rank=N'经纪人'";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }
        #endregion