Lk.Shop.DAL/UserInfo.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.Web;
namespace LK.Shop.DAL
{
	/// <summary>
	/// 数据访问类:UserInfo
	/// </summary>
	public partial class UserInfo
	{
        public string sqlConnectionString = LK.Shop.SqlConn.SqlConn.SqlConnectionString();

		public UserInfo()
		{}
		#region  BasicMethod


        public DataTable GetList(string strWhere, int pageSize, int pageIndex, out int counts, out int pageCounts)
        {
            return LK.Shop.Common.PageView.GetPageView("LK_UserInfo", "*", pageSize, pageIndex, "UserID", true, strWhere, "UserID", out counts, out pageCounts).Tables[0];
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string UserName)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from LK_UserInfo");
            strSql.Append(" where UserName=@UserName");
            SqlParameter[] parameters = {
					new SqlParameter("@UserName", SqlDbType.NVarChar,50)
			};
            parameters[0].Value = UserName;

            object o = SqlHelper.ExecuteScalar(sqlConnectionString, CommandType.Text, strSql.ToString(), parameters);



            if (o != null)
            {
                if (Convert.ToInt32(o) > 0)
                {
                    return true;
                }
                return false;
            }
            else
            {
                return false;
            }
        }


        public bool ValidateCookiesUser()
        {
            string manageName = GetCookiesUser("51ShopName");