MyNewsDAL/UserService.cs

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

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

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

namespace MyNewsDAL
{
   public  class UserService
    {

       //public int AddUser(User user)
       //{
       //    string sql = "";
       //    DBHelper.ExecuteCommand(sql);
       //}
       /// <summary>
        /// 根据用户名和密码查询对应的用户信息
       /// </summary>
       /// <param name="userName"></param>
       /// <param name="password"></param>
       /// <returns></returns>
       public int GetCountByUserNamePassword(string userName, string password)
       {
           try
           {
               string sql = string.Format("select count(*) from [user] where username='{0}' and password='{1}'", userName, password);
              return Convert .ToInt32( DBHelper.GetSchalar(sql));
             // return count;

           }
           catch(Exception ex)
           {
               throw ex;
           }
       }
       /// <summary>
       /// 根据用户名称查询相应的用户对象
       /// </summary>
       /// <param name="userName"></param>
       /// <returns></returns>
       public User GetUserByName(string userName)
       {
           string sql = string.Format("select * from [user] where username='{0}'",userName );
           SqlDataReader reader = DBHelper.GetReader(sql);

           if (reader.Read())
           {
               User user = new User();
               user.UserId = Convert.ToInt32(reader["UserId"]);
               user.UserName = reader["UserName"].ToString();
               user.Password = reader["Password"].ToString();
               user.Remark = reader["Remark"].ToString();
               reader.Close();
               return user;
           }
           else
           {
               reader.Close();