Smokewinetea.DAL/LogDAL.cs

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

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

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


namespace Smokewinetea.DAL
{
   public class LogDAL
    {
      
      
        /// <summary>
        /// Boos登录
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="userPwd"></param>
        /// <returns></returns>
        /// 
       public static bool Log(string userId, string userPwd)
       {
          
           string strSql = "select Count(*) from UserBoos where BoosId=@userId and BoosPwd=@userPwd";
               SqlParameter[] log ={
                                   new SqlParameter ("userId",SqlDbType.VarChar,20),
                                   new SqlParameter("userPwd",SqlDbType.VarChar,20)
                               };
               log[0].Value = userId;
               log[1].Value = userPwd;
               
            int var = DbHelper.ExrcuteScalar(strSql, log);
            if (var == 0)
            return false;
            return true; 
        
       }

       /// <summary>
       /// 加载BOOS个人信息
       /// </summary>
       /// <param name="userId"></param>
       public static List<LogModels> booslist(string tj)
       {
           StringBuilder sql = new StringBuilder();
           sql.AppendFormat("select * from UserBoos where BoosId ='{0}'",tj);
           SqlDataReader dr = DbHelper.ExecuteReader(sql.ToString());
           List<LogModels> list = new List<LogModels>();
           LogModels logM;
           while(dr.Read())
           {

               logM = new LogModels();
               logM.Boosumber = Convert.ToInt32(dr[0]);
               logM.BoosId=dr[1].ToString();
               logM.BoosPwd=dr[2].ToString();
               logM.BoosName=dr[3].ToString();
               logM.BoosSex=dr[4].ToString();