/// <summary> /// 增加一条数据 /// </summary> public void Add(HYTCWeiBo.Model.User model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into User("); strSql.Append("userId,userName,pwd,email,sex,colloge,personalwords,inCollogeYear,registerTime"); strSql.Append(") values ("); strSql.Append("@userId,@userName,@pwd,@email,@sex,@colloge,@personalwords,@inCollogeYear,@registerTime"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int,4) , new SqlParameter("@userName", SqlDbType.VarChar,20) , new SqlParameter("@pwd", SqlDbType.VarChar,12) , new SqlParameter("@email", SqlDbType.VarChar,1) , new SqlParameter("@sex", SqlDbType.VarChar,2) , new SqlParameter("@colloge", SqlDbType.VarChar,60) , new SqlParameter("@personalwords", SqlDbType.VarChar,50) , new SqlParameter("@inCollogeYear", SqlDbType.Int,4) , new SqlParameter("@registerTime", SqlDbType.DateTime) }; parameters[0].Value = model.userId; parameters[1].Value = model.userName; parameters[2].Value = model.pwd; parameters[3].Value = model.email; parameters[4].Value = model.sex; parameters[5].Value = model.colloge; parameters[6].Value = model.personalwords; parameters[7].Value = model.inCollogeYear; parameters[8].Value = model.registerTime; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(HYTCWeiBo.Model.Favorites model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Favorites("); strSql.Append("favoriteId,weiboId,authorName"); strSql.Append(") values ("); strSql.Append("@favoriteId,@weiboId,@authorName"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@favoriteId", SqlDbType.Int,4) , new SqlParameter("@weiboId", SqlDbType.Int,4) , new SqlParameter("@authorName", SqlDbType.VarChar,20) }; parameters[0].Value = model.favoriteId; parameters[1].Value = model.weiboId; parameters[2].Value = model.authorName; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(HYTCWeiBo.Model.FansMarks model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into FansMarks("); strSql.Append("markId,onselfName,otherName,createTime"); strSql.Append(") values ("); strSql.Append("@markId,@onselfName,@otherName,@createTime"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@markId", SqlDbType.Int,4) , new SqlParameter("@onselfName", SqlDbType.VarChar,20) , new SqlParameter("@otherName", SqlDbType.VarChar,20) , new SqlParameter("@createTime", SqlDbType.DateTime) }; parameters[0].Value = model.markId; parameters[1].Value = model.onselfName; parameters[2].Value = model.otherName; parameters[3].Value = model.createTime; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(HYTCWeiBo.Model.LoginMarks model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into LoginMarks("); strSql.Append("markId,userId,loginTime,userName"); strSql.Append(") values ("); strSql.Append("@markId,@userId,@loginTime,@userName"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@markId", SqlDbType.Int,4) , new SqlParameter("@userId", SqlDbType.Int,4) , new SqlParameter("@loginTime", SqlDbType.DateTime) , new SqlParameter("@userName", SqlDbType.VarChar,20) }; parameters[0].Value = model.markId; parameters[1].Value = model.userId; parameters[2].Value = model.loginTime; parameters[3].Value = model.userName; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HYTCWeiBo.Model.Favorites model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update Favorites set "); strSql.Append(" favoriteId = @favoriteId , "); strSql.Append(" weiboId = @weiboId , "); strSql.Append(" authorName = @authorName "); strSql.Append(" where favoriteId=@favoriteId "); SqlParameter[] parameters = { new SqlParameter("@favoriteId", SqlDbType.Int,4) , new SqlParameter("@weiboId", SqlDbType.Int,4) , new SqlParameter("@authorName", SqlDbType.VarChar,20) }; parameters[0].Value = model.favoriteId; parameters[1].Value = model.weiboId; parameters[2].Value = model.authorName; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HYTCWeiBo.Model.User model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update User set "); strSql.Append(" userId = @userId , "); strSql.Append(" userName = @userName , "); strSql.Append(" pwd = @pwd , "); strSql.Append(" email = @email , "); strSql.Append(" sex = @sex , "); strSql.Append(" colloge = @colloge , "); strSql.Append(" personalwords = @personalwords , "); strSql.Append(" inCollogeYear = @inCollogeYear , "); strSql.Append(" registerTime = @registerTime "); strSql.Append(" where userId=@userId "); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int,4) , new SqlParameter("@userName", SqlDbType.VarChar,20) , new SqlParameter("@pwd", SqlDbType.VarChar,12) , new SqlParameter("@email", SqlDbType.VarChar,1) , new SqlParameter("@sex", SqlDbType.VarChar,2) , new SqlParameter("@colloge", SqlDbType.VarChar,60) , new SqlParameter("@personalwords", SqlDbType.VarChar,50) , new SqlParameter("@inCollogeYear", SqlDbType.Int,4) , new SqlParameter("@registerTime", SqlDbType.DateTime) }; parameters[0].Value = model.userId; parameters[1].Value = model.userName; parameters[2].Value = model.pwd; parameters[3].Value = model.email; parameters[4].Value = model.sex; parameters[5].Value = model.colloge; parameters[6].Value = model.personalwords; parameters[7].Value = model.inCollogeYear; parameters[8].Value = model.registerTime; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HYTCWeiBo.Model.FansMarks model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update FansMarks set "); strSql.Append(" markId = @markId , "); strSql.Append(" onselfName = @onselfName , "); strSql.Append(" otherName = @otherName , "); strSql.Append(" createTime = @createTime "); strSql.Append(" where markId=@markId "); SqlParameter[] parameters = { new SqlParameter("@markId", SqlDbType.Int,4) , new SqlParameter("@onselfName", SqlDbType.VarChar,20) , new SqlParameter("@otherName", SqlDbType.VarChar,20) , new SqlParameter("@createTime", SqlDbType.DateTime) }; parameters[0].Value = model.markId; parameters[1].Value = model.onselfName; parameters[2].Value = model.otherName; parameters[3].Value = model.createTime; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }