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);
}
}
