DAL/Login.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DAL
{
    public    class Login
    {
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="UserName">用戶名</param>
        /// <param name="UserPwd">密码</param>
        /// <returns>Datatable</returns>
        public DataTable GetLogin(string UserName, string UserPwd) 
        {
            string sql = "SELECT * FROM y_caller WHERE Callid=@UserName AND pwd=@UserPwd AND workstate=@Workstate";
            SqlParameter[] sqlpa = 
            { 
            new SqlParameter("@UserName",UserName),
            new SqlParameter("@UserPwd",UserPwd),
            new SqlParameter("@Workstate",1)
            };
            return DBhelp.Gettable(sql, sqlpa);
        }
        /// <summary>
        /// 获取用戶名
        /// </summary>
        /// <param name="UserName">用戶名</param>
        /// <returns></returns>
        public string GetUserName(string UserName)
        {
            string sql = "SELECT Callid FROM y_caller WHERE Callid=@UserName";
            SqlParameter[] sqlpa = 
            { 
            new SqlParameter("@UserName",UserName)
            };
            return DBhelp.Gettable(sql, sqlpa).Rows[0][0].ToString();
        }
    }
}