public static Model.UserInfoModel GetUserSession()
{
Model.UserInfoModel OrderUser = new Model.UserInfoModel();
if (HttpContext.Current.Session["UserSysSession"] == null)
{
return(null);
}
OrderUser = (Model.UserInfoModel)HttpContext.Current.Session["UserSysSession"];
if (System.Web.HttpUtility.UrlDecode(Common.Des.Decode(OrderUser.RealName)).Length <= 0)
{
return(null);
}
return(OrderUser);
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Login(Model.UserInfoModel model)
{
StringBuilder sql = new StringBuilder();
sql.Append(" select count(userId) from UserInfo where [username]='" + model.UserName + "' and [password]='" + model.PassWord + "' and statusId=1 ");
try
{
int obj = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql.ToString()));
return(obj);
}
catch
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.UserInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserInfo set ");
strSql.Append("PassWord=@PassWord,");
strSql.Append("Mob=@Mob,");
strSql.Append("Email=@Email,");
strSql.Append("GroupId=@GroupId,");
strSql.Append("LevelId=@LevelId,");
strSql.Append("PostId=@PostId,");
strSql.Append("RoleId=@RoleId,");
strSql.Append("StatusId=@StatusId ");
strSql.Append(" where UserId=@UserId");
SqlParameter[] parameters =
{
new SqlParameter("@RealName", SqlDbType.NVarChar, 50),
new SqlParameter("@Mob", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.NVarChar, 80),
new SqlParameter("@StatusId", SqlDbType.Int, 4),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@GroupId", SqlDbType.Int, 4),
new SqlParameter("@PostId", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@LevelId", SqlDbType.Int, 4),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RealName;
parameters[1].Value = model.Mob;
parameters[2].Value = model.Email;
parameters[3].Value = model.StatusId;
parameters[4].Value = model.UserId;
parameters[5].Value = model.GroupId;
parameters[6].Value = model.PostId;
parameters[7].Value = model.RoleId;
parameters[8].Value = model.LevelId;
parameters[9].Value = model.PassWord;
try
{
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
catch (Exception)
{
return(0);
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdatePwd(Model.UserInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UserInfo set ");
strSql.Append("password=@password");
strSql.Append(" where username=@UserName");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50),
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
int obj = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
return(obj);
}
/// <summary>
/// 增加一条会员数据
/// </summary>
public int Add(Model.UserInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UserInfo(");
strSql.Append("UserName,PassWord,RealName,Mob,Email,StatusId,GroupId,PostId,RoleId,LevelId)");
strSql.Append(" values (");
strSql.Append("@UserName,@PassWord,@RealName,@Mob,@Email,@StatusId,@GroupId,@PostId,@RoleId,@LevelId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50),
new SqlParameter("@RealName", SqlDbType.NVarChar, 50),
new SqlParameter("@Mob", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.NVarChar, 80),
new SqlParameter("@StatusId", SqlDbType.Int, 4),
new SqlParameter("@GroupId", SqlDbType.Int, 4),
new SqlParameter("@PostId", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@LevelId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.RealName;
parameters[3].Value = model.Mob;
parameters[4].Value = model.Email;
parameters[5].Value = model.StatusId;
parameters[6].Value = model.GroupId;
parameters[7].Value = model.PostId;
parameters[8].Value = model.RoleId;
parameters[9].Value = model.LevelId;
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public Model.UserInfoModel GetModel(string username)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top 1 a.*,b.groupName from UserInfo a left join UserInfo_Group b on a.groupId = b.groupId ");
strSql.Append(" where UserName='******'");
Model.UserInfoModel model = new Model.UserInfoModel();
DataSet ds = SqlHelper.ExecuteDataset(conn, CommandType.Text, strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "")
{
model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupName"] != null && ds.Tables[0].Rows[0]["GroupName"].ToString() != "")
{
model.GroupName = ds.Tables[0].Rows[0]["GroupName"].ToString();
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["PassWord"] != null && ds.Tables[0].Rows[0]["PassWord"].ToString() != "")
{
model.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString();
}
if (ds.Tables[0].Rows[0]["RealName"] != null && ds.Tables[0].Rows[0]["RealName"].ToString() != "")
{
model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString();
}
if (ds.Tables[0].Rows[0]["Mob"] != null && ds.Tables[0].Rows[0]["Mob"].ToString() != "")
{
model.Mob = ds.Tables[0].Rows[0]["Mob"].ToString();
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["StatusId"] != null && ds.Tables[0].Rows[0]["StatusId"].ToString() != "")
{
model.StatusId = int.Parse(ds.Tables[0].Rows[0]["StatusId"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupId"] != null && ds.Tables[0].Rows[0]["GroupId"].ToString() != "")
{
model.GroupId = int.Parse(ds.Tables[0].Rows[0]["GroupId"].ToString());
}
if (ds.Tables[0].Rows[0]["LevelId"] != null && ds.Tables[0].Rows[0]["LevelId"].ToString() != "")
{
model.LevelId = int.Parse(ds.Tables[0].Rows[0]["LevelId"].ToString());
}
if (ds.Tables[0].Rows[0]["LoginCount"] != null && ds.Tables[0].Rows[0]["LoginCount"].ToString() != "")
{
model.LoginCount = int.Parse(ds.Tables[0].Rows[0]["LoginCount"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLoginTime"] != null && ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["PostId"] != null && ds.Tables[0].Rows[0]["PostId"].ToString() != "")
{
model.PostId = int.Parse(ds.Tables[0].Rows[0]["PostId"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleId"] != null && ds.Tables[0].Rows[0]["RoleId"].ToString() != "")
{
model.RoleId = int.Parse(ds.Tables[0].Rows[0]["RoleId"].ToString());
}
return(model);
}
else
{
return(null);
}
}
