public void PrepareUserModel(SqlDataReader dr, List <MXUser> userList)
{
while (dr.Read())
{
MXUser item = new MXUser();
item.UserId = dr.GetInt32(0);
item.UserName = dr["UserName"].ToString();
item.UserPwd = dr["UserPwd"].ToString();
item.UserEmail = dr["UserEmail"].ToString();
item.UserSex = dr.GetInt32(4);
//item.Introduce = dr[5].ToString();
//item.Photo = dr[6].ToString();
item.UserMsn = dr["UserMsn"].ToString();
item.UserQQ = dr["UserQQ"].ToString();
item.UserTel = dr["UserTel"].ToString();
item.UserMobile = dr["UserMobile"].ToString();
//item.RegionID = dr[11].ToString();
item.UserAddress = dr["UserAddress"].ToString();
item.UserBirthday = dr["UserBirthday"].ToString();
//item.RegisterIP = dr[14].ToString();
item.RegDate = dr["RegDate"].ToString();
//item.LastLoginIP = dr[0x10].ToString();
item.LastLoginDate = DateTime.Parse(dr["LastLoginDate"].ToString());
//item.LoginTimes = dr.GetInt32(0x12);
//item.SafeCode = dr[0x13].ToString();
//item.FindDate = dr.GetDateTime(20);
item.State = int.Parse(dr["State"].ToString());
//item.OpenID = dr[0x16].ToString();
userList.Add(item);
}
}
/// <summary>
/// 返回数据
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MXUser GetModel(System.Data.DataRow row)
{
MXUser model = new MXUser();
if (row != null)
{
model.UserId = int.Parse(row["UserId"].ToString());
model.UserName = row["UserName"].ToString();
model.UserPwd = row["UserPwd"].ToString();
model.UserRealName = row["UserRealName"].ToString();
model.UserSex = int.Parse(row["UserSex"].ToString());
model.UserBirthday = row["UserBirthday"].ToString();
model.UserEmail = row["UserEmail"].ToString();
model.UserTel = row["UserTel"].ToString();
model.UserMobile = row["UserMobile"].ToString();
model.UserQQ = row["UserQQ"].ToString();
model.UserMsn = row["UserMsn"].ToString();
model.UserCompany = row["UserCompany"].ToString();
model.UserPosition = row["UserPosition"].ToString();
model.UserPost = row["UserPost"].ToString();
model.UserAddress = row["UserAddress"].ToString();
model.UserCompanyAddress = row["UserCompanyAddress"].ToString();
model.IsChecked = int.Parse(row["IsChecked"].ToString());
model.IsLocked = int.Parse(row["IsLocked"].ToString());
model.RegDate = row["RegDate"].ToString();
model.LastLoginDate = (DateTime)row["LastLoginDate"];
return(model);
}
else
{
return(null);
}
}
//注册会员
public int InsertUserInfor(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into MXUser ( UserName,UserPwd,UserRealName,UserSex,UserEmail,UserTel,UserMobile,UserQQ,UserMsn,UserBirthday,UserCompany,UserPosition,UserPost,UserAddress,UserCompanyAddress,IsChecked,IsLocked,State ) values(@UserName,@UserPwd,@UserRealName,@UserSex,@UserEmail,@UserTel,@Usermobile,@UserQQ,@UserMsn,@UserBirthday,@UserCompany,@UserPosition,@UserPost,@UserAddress,@UserCompanyAddress,@IsChecked,@IsLocked,@State)");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
public int InsertUserInfor(string UserEmail, string UserPwd)
{
MXUser Model = new MXUser();
Model.UserEmail = UserEmail;
Model.UserPwd = UserPwd;
return(dal.InsertUserInfor(Model));
}
public bool InsertUserInfor(MXUser Model)
{
if (dal.InsertUserInfor(Model) > 0)
{
return(true);
}
else
{
_ErrMessage = "数据录入异常，请再次录入！";
return(false);
}
}
public SqlDataReader GetUserInforByUserEmail(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from MXUser where UserEmail=@UserEmail");
SqlParameter[] par =
{
new SqlParameter("@UserEmail", SqlDbType.VarChar, 50)
};
par[0].Value = Model.UserEmail;
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
//判断该密码是否正确
public SqlDataReader CheckUserPwd(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from MXUser where UserPwd=@UserPwd and UserId=@UserId");
SqlParameter[] par =
{
new SqlParameter("@UserPwd", SqlDbType.VarChar, 50),
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
par[0].Value = Common.DESEncrypt.Encrypt(Model.UserPwd);
par[1].Value = Model.UserId;
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
//会员收藏夹
/*
* public int seleid(Models.User.MXUser aa)
* {
* StringBuilder sql = new StringBuilder();
* sql.Append("select * from collect where _userid=@id");
* SqlParameter[] par ={
* new SqlParameter("@id",SqlDbType.Int ,4)
* };
* par[0].Value = aa.userid;
* return Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);
* }
*/
//记住上次登入时间时间
public int UpdateLastLoginDate(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MXUser set LastLoginDate=@LastLoginDate where UserId=@UserId");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@LastLoginDate", SqlDbType.DateTime, 16)
};
par[0].Value = Model.UserId;
par[1].Value = Model.LastLoginDate;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//更改密码
public int UpdateUserPwd(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MXUser set UserPwd=@UserPwd where UserId=@UserId ");
SqlParameter[] par =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@UserPwd", SqlDbType.VarChar, 50)
};
par[0].Value = Model.UserId;
par[1].Value = Common.DESEncrypt.Encrypt(Model.UserPwd);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//更新会员信息
public int UpdateUserInfor(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MXUser set UserName=@UserName,UserPwd=@UserPwd,UserRealName=@UserRealName,UserSex=@UserSex,UserEmail=@UserEmail,UserTel=@UserTel,UserMobile=@UserMobile,UserQQ=@UserQQ,UserMsn=@UserMsn,UserBirthday=@UserBirthday,UserCompany=@UserCompany,UserPosition=@UserPosition,UserPost=@UserPost,UserAddress=@UserAddress,UserCompanyAddress=@UserCompanyAddress,IsChecked=@IsChecked,IsLocked=@IsLocked,,State=@State where MXUserId=@UserId");
SqlParameter[] par =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@UserPwd", SqlDbType.VarChar, 50),
new SqlParameter("@UserRealName", SqlDbType.VarChar, 50),
new SqlParameter("@UserSex", SqlDbType.VarChar, 50),
new SqlParameter("@UserEmail", SqlDbType.VarChar, 50),
new SqlParameter("@UserTel", SqlDbType.VarChar, 50),
new SqlParameter("@UserMobile", SqlDbType.VarChar, 50),
new SqlParameter("@UserQQ", SqlDbType.VarChar, 50),
new SqlParameter("@UserMsn", SqlDbType.VarChar, 50),
new SqlParameter("@UserBirthday", SqlDbType.VarChar, 50),
new SqlParameter("@UserCompany", SqlDbType.VarChar, 50),
new SqlParameter("@UserPosition", SqlDbType.VarChar, 50),
new SqlParameter("@UserPost", SqlDbType.VarChar, 50),
new SqlParameter("@UserAddress", SqlDbType.VarChar, 50),
new SqlParameter("@UserCompanyAddress", SqlDbType.VarChar, 50),
new SqlParameter("@IsChecked", SqlDbType.VarChar, 50),
new SqlParameter("@IsLocked", SqlDbType.VarChar, 50),
new SqlParameter("@State", SqlDbType.VarChar, 50)
};
par[0].Value = Model.UserName;
par[1].Value = Common.DESEncrypt.Encrypt(Model.UserPwd);
par[2].Value = Model.UserRealName;
par[3].Value = Model.UserSex;
par[4].Value = Model.UserEmail;
par[5].Value = Model.UserTel;
par[6].Value = Model.UserMobile;
par[7].Value = Model.UserQQ;
par[8].Value = Model.UserMsn;
par[9].Value = Model.UserBirthday;
par[10].Value = Model.UserCompany;
par[11].Value = Model.UserPosition;
par[12].Value = Model.UserPost;
par[13].Value = Model.UserAddress;
par[14].Value = Model.UserCompanyAddress;
par[15].Value = Model.IsChecked;
par[16].Value = Model.IsLocked;
par[17].Value = Model.State;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
protected IDbDataParameter[] ValueParas(MXUser Model)
{
SqlParameter[] par =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@UserPwd", SqlDbType.VarChar, 50),
new SqlParameter("@UserRealName", SqlDbType.VarChar, 50),
new SqlParameter("@UserSex", SqlDbType.VarChar, 50),
new SqlParameter("@UserEmail", SqlDbType.VarChar, 50),
new SqlParameter("@UserTel", SqlDbType.VarChar, 50),
new SqlParameter("@UserMobile", SqlDbType.VarChar, 50),
new SqlParameter("@UserQQ", SqlDbType.VarChar, 50),
new SqlParameter("@UserMsn", SqlDbType.VarChar, 50),
new SqlParameter("@UserBirthday", SqlDbType.VarChar, 50),
new SqlParameter("@UserCompany", SqlDbType.VarChar, 50),
new SqlParameter("@UserPosition", SqlDbType.VarChar, 50),
new SqlParameter("@UserPost", SqlDbType.VarChar, 50),
new SqlParameter("@UserAddress", SqlDbType.VarChar, 50),
new SqlParameter("@UserCompanyAddress", SqlDbType.VarChar, 50),
new SqlParameter("@IsChecked", SqlDbType.VarChar, 50),
new SqlParameter("@IsLocked", SqlDbType.VarChar, 50),
new SqlParameter("@State", SqlDbType.VarChar, 50)
};
par[0].Value = Model.UserName;
par[1].Value = Common.DESEncrypt.Encrypt(Model.UserPwd);
par[2].Value = Model.UserRealName;
par[3].Value = Model.UserSex;
par[4].Value = Model.UserEmail;
par[5].Value = Model.UserTel;
par[6].Value = Model.UserMobile;
par[7].Value = Model.UserQQ;
par[8].Value = Model.UserMsn;
par[9].Value = Model.UserBirthday;
par[10].Value = Model.UserCompany;
par[11].Value = Model.UserPosition;
par[12].Value = Model.UserPost;
par[13].Value = Model.UserAddress;
par[14].Value = Model.UserCompanyAddress;
par[15].Value = Model.IsChecked;
par[16].Value = Model.IsLocked;
par[17].Value = Model.State;
return(par);
}
//修改个人联系方法
public int UpdateUserContact(MXUser Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update MXUser set UserMsn=@UserMsn,UserQQ=@UserQQ,UserTel=@UserTel,UserMobile=@UserMobile where MXUserId=@UserId");
SqlParameter[] par =
{
new SqlParameter("@UserMsn", SqlDbType.VarChar, 50),
new SqlParameter("@UserQQ", SqlDbType.VarChar, 50),
new SqlParameter("@UserTel", SqlDbType.VarChar, 50),
new SqlParameter("@UserMobile", SqlDbType.VarChar, 50),
new SqlParameter("@UserId", SqlDbType.VarChar, 50)
};
par[0].Value = Model.UserMsn;
par[1].Value = Model.UserQQ;
par[2].Value = Model.UserTel;
par[3].Value = Model.UserMobile;
par[4].Value = Model.UserId;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
public bool UserLogin(string UserEmail, string UserPwd)
{
MXUser Model = new MXUser();
Model.UserEmail = UserEmail;
Model.UserPwd = UserPwd;
Model.LastLoginDate = DateTime.Now;
SqlDataReader dr = dal.UserLogin(Model);
if (dr.HasRows)
{
dr.Read();
if ((bool)dr["IsChecked"])
{
if (!(bool)dr["IsLocked"])
{
System.Web.HttpContext.Current.Session["UserName"] = dr["UserName"];
System.Web.HttpContext.Current.Session["UserId"] = dr["MXUserId"];
return(true);
}
else
{
_ErrMessage = "您好，帐号【" + dr["UserName"] + "】已被锁定，请联系管理员！";
return(false);
}
}
else
{
_ErrMessage = "您还没有通过审核，请等待管理员审核后登陆！";
return(false);
}
Model.UserId = (int)dr["MXUserId"];
dal.UpdateLastLoginDate(Model);
}
else
{
_ErrMessage = "用户名或密码错误，请重新登陆！";
return(false);
}
}
public SqlDataReader GetUserInfor(MXUser aa)
{
return(dal.GetUserInfor(aa));
}
public int UpdateUserPwd(MXUser aa)
{
return(dal.UpdateUserPwd(aa));
}
public int UpdateLastLoginDate(MXUser aa)
{
return(dal.UpdateLastLoginDate(aa));
}
public SqlDataReader CheckUserPwd(MXUser aa)
{
return(dal.CheckUserPwd(aa));
}
public int UpdateUserContact(MXUser aa)
{
return(dal.UpdateUserContact(aa));
}
public int UpdateUserInfor(MXUser aa)
{
return(dal.UpdateUserInfor(aa));
}
public SqlDataReader GetUserInforByUserEmail(MXUser aa)
{
return(dal.GetUserInforByUserEmail(aa));
}
