public int blogCount = 0; //用户的博客数 protected void Page_Load(object sender, EventArgs e) { string pre = Request.QueryString["pre"] != "" ? Request.QueryString["pre"] : "0"; //string next = Request.QueryString["next"] != "" ? Request.QueryString["next"] : "2"; curuser = (starweibo.Model.userInfo)Session["user"]; if (Session["username"] == null || Session["username"].ToString() == "") { Response.Redirect("login.aspx"); } //查询个人信息 focusCountd = relation.GetRecordCount("userId=" + Session["userid"].ToString()); fansCount = relation.GetRecordCount("friendId=" + Session["userid"].ToString()); blogCount = blog.GetRecordCount("blogAuthorId=" + Session["userid"].ToString()); //分页显示微博 List <starweibo.Model.fullblogInfoV> bloginfo = new List <starweibo.Model.fullblogInfoV>(); int count = bll.GetRecordCount("blogAuthorId in (select friendId from relationInfo where userId=" + Convert.ToInt32(Session["userid"]) + ") or blogAuthorId=" + Convert.ToInt32(Session["userid"])); int countyushu = count % 40; pages = count / 40; if (countyushu > 0) { pages++; } pages = (pages <= 10) ? pages : 10; curpre = Convert.ToInt32(pre); int startindex = curpre * 40 + 1; int endindex = curpre * 40 + 40; string sql = "T.blogAuthorId in (select friendId from relationInfo where userId=" + Convert.ToInt32(Session["userid"]) + ")"; sql += " or T.blogAuthorId=" + Convert.ToInt32(Session["userid"]) + ""; this.wbList.DataSource = bll.GetListByPage(sql, "blogPubTime desc", startindex, endindex); this.wbList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userid"] == null || Session["userid"].ToString() == "") { Response.Redirect("login.aspx"); } curuser = (starweibo.Model.userInfo)Session["user"]; sendname = Request.QueryString["sendname"].ToString(); sendid = Request.QueryString["sendid"].ToString(); curid = Convert.ToInt32(Session["userid"]); starweibo.BLL.chatV bllchatv = new starweibo.BLL.chatV(); starweibo.BLL.chatInfo bllchatInfo = new starweibo.BLL.chatInfo(); List <starweibo.Model.chatV> modchatV = new List <starweibo.Model.chatV>(); modchatV = bllchatv.GetModelList("(senderId=" + curid + " and receiverId=" + sendid + ") or (senderId=" + sendid + " and receiverId=" + curid + ") order by pubTime desc"); this.msgdialogue.DataSource = modchatV; this.msgdialogue.DataBind(); //starweibo.BLL.chatInfo foreach (starweibo.Model.chatV onechatV in modchatV) { bllchatInfo.myUpdate("read", onechatV.shortMsgId.ToString()); } }
//更新用户联系信息 public string updateUserCominfo(string id, string userMail, string QQnumber, string userTell) { curUser = user.GetModel(Convert.ToInt32(id)); curUser.userMail = userMail; curUser.QQnumber = QQnumber; curUser.userTell = userTell; return(user.Update(curUser).ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(starweibo.Model.userInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into userInfo("); strSql.Append("userName,userPwd,userMail,userHeadimage,userSex,userBirthday,registTime,lastLoginTime,userAddress,userEdu,userTell,QQnumber,userDes,userMarry,userCss,yanzhengma,jihuostate)"); strSql.Append(" values ("); strSql.Append("@userName,@userPwd,@userMail,@userHeadimage,@userSex,@userBirthday,@registTime,@lastLoginTime,@userAddress,@userEdu,@userTell,@QQnumber,@userDes,@userMarry,@userCss,@yanzhengma,@jihuostate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userName", SqlDbType.NVarChar, 20), new SqlParameter("@userPwd", SqlDbType.VarChar, 20), new SqlParameter("@userMail", SqlDbType.VarChar, 50), new SqlParameter("@userHeadimage", SqlDbType.NVarChar, 150), new SqlParameter("@userSex", SqlDbType.NChar, 1), new SqlParameter("@userBirthday", SqlDbType.VarChar, 20), new SqlParameter("@registTime", SqlDbType.Date, 3), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@userAddress", SqlDbType.NVarChar, 150), new SqlParameter("@userEdu", SqlDbType.NVarChar, 250), new SqlParameter("@userTell", SqlDbType.NChar, 11), new SqlParameter("@QQnumber", SqlDbType.VarChar, 20), new SqlParameter("@userDes", SqlDbType.NVarChar, 150), new SqlParameter("@userMarry", SqlDbType.NVarChar, 10), new SqlParameter("@userCss", SqlDbType.VarChar, 300), new SqlParameter("@yanzhengma", SqlDbType.Char, 6), new SqlParameter("@jihuostate", SqlDbType.Char, 1) }; parameters[0].Value = model.userName; parameters[1].Value = model.userPwd; parameters[2].Value = model.userMail; parameters[3].Value = model.userHeadimage; parameters[4].Value = model.userSex; parameters[5].Value = model.userBirthday; parameters[6].Value = model.registTime; parameters[7].Value = model.lastLoginTime; parameters[8].Value = model.userAddress; parameters[9].Value = model.userEdu; parameters[10].Value = model.userTell; parameters[11].Value = model.QQnumber; parameters[12].Value = model.userDes; parameters[13].Value = model.userMarry; parameters[14].Value = model.userCss; parameters[15].Value = model.yanzhengma; parameters[16].Value = model.jihuostate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public string shenqing(string userName, string userPwd, string userMail) { starweibo.Model.userInfo shengqing = new starweibo.Model.userInfo(); starweibo.BLL.userInfo oneshenqing = new starweibo.BLL.userInfo(); shengqing.userName = userName; shengqing.userPwd = userPwd; shengqing.userMail = userMail; shengqing.userHeadimage = "css/images/personalCenterimages/headimage.jpg"; return(oneshenqing.Add(shengqing).ToString()); }
//更新用户基本信息 public string updateUserBaseinfo(string id, string userName, string userAddress, string userSex, string userMarry, string userBirthday, string userDes) { curUser = user.GetModel(Convert.ToInt32(id)); curUser.userName = userName; curUser.userAddress = userAddress; curUser.userSex = userSex; curUser.userMarry = userMarry; curUser.userBirthday = userBirthday; curUser.userDes = userDes; return(user.Update(curUser).ToString()); }
//验证用户密码 public string checkUserPwd(string id, string inputPwd) { curUser = user.GetModel(Convert.ToInt32(id)); if (curUser.userPwd == inputPwd) { return("true"); } else { return("false"); } }
public string[] userAddress = new string[3]; //用户所在地 protected void Page_Load(object sender, EventArgs e) { if (Session["userid"] == null || Session["userid"].ToString() == "") { Response.Redirect("login.aspx"); } loginUserid = Session["userid"].ToString(); qsUserid = Request.QueryString["Userid"]; curUser = user.GetModel(Convert.ToInt32(qsUserid));//获得当前用户对象 if (curUser.userAddress != null && curUser.userAddress != "") { userAddress = curUser.userAddress.Split('-'); } else { userAddress = new string[] { "未设置", "未设置", "未设置" }; } focusCountd = relation.GetRecordCount("userId=" + curUser.id.ToString()); fansCount = relation.GetRecordCount("friendId=" + curUser.id.ToString()); blogCount = blog.GetRecordCount("blogAuthorId=" + curUser.id.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public starweibo.Model.userInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,userName,userPwd,userMail,userHeadimage,userSex,userBirthday,registTime,lastLoginTime,userAddress,userEdu,userTell,QQnumber,userDes,userMarry,userCss,yanzhengma,jihuostate from userInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; starweibo.Model.userInfo model = new starweibo.Model.userInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
//修改用户密码 public string updateUserPwd(string id, string newpwd) { curUser = user.GetModel(Convert.ToInt32(id)); curUser.userPwd = newpwd; return(user.Update(curUser).ToString()); }
//更新用户头像 public string updateUserHeadImg(string id, string headImg) { curUser = user.GetModel(Convert.ToInt32(id)); curUser.userHeadimage = headImg; return(user.Update(curUser).ToString()); }
//更新用户教育信息 public string updateUserEduinfo(string id, string userEdu) { curUser = user.GetModel(Convert.ToInt32(id)); curUser.userEdu = userEdu; return(user.Update(curUser).ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public starweibo.Model.userInfo DataRowToModel(DataRow row) { starweibo.Model.userInfo model = new starweibo.Model.userInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["userName"] != null) { model.userName = row["userName"].ToString(); } if (row["userPwd"] != null) { model.userPwd = row["userPwd"].ToString(); } if (row["userMail"] != null) { model.userMail = row["userMail"].ToString(); } if (row["userHeadimage"] != null) { model.userHeadimage = row["userHeadimage"].ToString(); } if (row["userSex"] != null) { model.userSex = row["userSex"].ToString(); } if (row["userBirthday"] != null) { model.userBirthday = row["userBirthday"].ToString(); } if (row["registTime"] != null && row["registTime"].ToString() != "") { model.registTime = DateTime.Parse(row["registTime"].ToString()); } if (row["lastLoginTime"] != null && row["lastLoginTime"].ToString() != "") { model.lastLoginTime = DateTime.Parse(row["lastLoginTime"].ToString()); } if (row["userAddress"] != null) { model.userAddress = row["userAddress"].ToString(); } if (row["userEdu"] != null) { model.userEdu = row["userEdu"].ToString(); } if (row["userTell"] != null) { model.userTell = row["userTell"].ToString(); } if (row["QQnumber"] != null) { model.QQnumber = row["QQnumber"].ToString(); } if (row["userDes"] != null) { model.userDes = row["userDes"].ToString(); } if (row["userMarry"] != null) { model.userMarry = row["userMarry"].ToString(); } if (row["userCss"] != null) { model.userCss = row["userCss"].ToString(); } if (row["yanzhengma"] != null) { model.yanzhengma = row["yanzhengma"].ToString(); } if (row["jihuostate"] != null) { model.jihuostate = row["jihuostate"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(starweibo.Model.userInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update userInfo set "); strSql.Append("userName=@userName,"); strSql.Append("userPwd=@userPwd,"); strSql.Append("userMail=@userMail,"); strSql.Append("userHeadimage=@userHeadimage,"); strSql.Append("userSex=@userSex,"); strSql.Append("userBirthday=@userBirthday,"); strSql.Append("registTime=@registTime,"); strSql.Append("lastLoginTime=@lastLoginTime,"); strSql.Append("userAddress=@userAddress,"); strSql.Append("userEdu=@userEdu,"); strSql.Append("userTell=@userTell,"); strSql.Append("QQnumber=@QQnumber,"); strSql.Append("userDes=@userDes,"); strSql.Append("userMarry=@userMarry,"); strSql.Append("userCss=@userCss,"); strSql.Append("yanzhengma=@yanzhengma,"); strSql.Append("jihuostate=@jihuostate"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@userName", SqlDbType.NVarChar, 20), new SqlParameter("@userPwd", SqlDbType.VarChar, 20), new SqlParameter("@userMail", SqlDbType.VarChar, 50), new SqlParameter("@userHeadimage", SqlDbType.NVarChar, 150), new SqlParameter("@userSex", SqlDbType.NChar, 1), new SqlParameter("@userBirthday", SqlDbType.VarChar, 20), new SqlParameter("@registTime", SqlDbType.Date, 3), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@userAddress", SqlDbType.NVarChar, 150), new SqlParameter("@userEdu", SqlDbType.NVarChar, 250), new SqlParameter("@userTell", SqlDbType.NChar, 11), new SqlParameter("@QQnumber", SqlDbType.VarChar, 20), new SqlParameter("@userDes", SqlDbType.NVarChar, 150), new SqlParameter("@userMarry", SqlDbType.NVarChar, 10), new SqlParameter("@userCss", SqlDbType.VarChar, 300), new SqlParameter("@yanzhengma", SqlDbType.Char, 6), new SqlParameter("@jihuostate", SqlDbType.Char, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.userName; parameters[1].Value = model.userPwd; parameters[2].Value = model.userMail; parameters[3].Value = model.userHeadimage; parameters[4].Value = model.userSex; parameters[5].Value = model.userBirthday; parameters[6].Value = model.registTime; parameters[7].Value = model.lastLoginTime; parameters[8].Value = model.userAddress; parameters[9].Value = model.userEdu; parameters[10].Value = model.userTell; parameters[11].Value = model.QQnumber; parameters[12].Value = model.userDes; parameters[13].Value = model.userMarry; parameters[14].Value = model.userCss; parameters[15].Value = model.yanzhengma; parameters[16].Value = model.jihuostate; parameters[17].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }