public bool SaveSpacePostCategory(SpacePostCategoryInfo spacepostcategories) { //try //{ IDataParameter[] prams = { DbHelper.MakeInParam("@id", (DbType)SqlDbType.Int, 4,spacepostcategories.ID), DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4,spacepostcategories.PostID), DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,spacepostcategories.CategoryID) }; string sqlstring = String.Format("UPDATE [" + BaseConfigs.GetTablePrefix + "spacepostcategories] SET [postid] = @postid, [categoryid] = @categoryid WHERE [id] = @id"); DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams); return true; //} //catch (Exception ex) //{ // errormsg = Globals.TransferSqlErrorInfo(ex.Message); // return false; //} }
public bool AddSpacePost(SpacePostInfo spaceposts) { //try //{ IDataParameter[] prams = { DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4,spaceposts.PostID), DbHelper.MakeInParam("@author", (DbType)SqlDbType.NVarChar, 20,spaceposts.Author), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spaceposts.Uid), DbHelper.MakeInParam("@postdatetime", (DbType)SqlDbType.DateTime, 8,spaceposts.PostDateTime), DbHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 0,spaceposts.Content), DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 150,spaceposts.Title), DbHelper.MakeInParam("@category", (DbType)SqlDbType.VarChar, 255,spaceposts.Category), DbHelper.MakeInParam("@poststatus", (DbType)SqlDbType.TinyInt, 1,spaceposts.PostStatus), DbHelper.MakeInParam("@commentstatus", (DbType)SqlDbType.TinyInt, 1,spaceposts.CommentStatus), DbHelper.MakeInParam("@postupdatetime", (DbType)SqlDbType.DateTime, 8,spaceposts.PostUpDateTime), DbHelper.MakeInParam("@commentcount", (DbType)SqlDbType.Int, 4,spaceposts.CommentCount) }; string sqlstring = String.Format("INSERT INTO [" + BaseConfigs.GetTablePrefix + "spaceposts] ([author], [uid], [postdatetime], [content], [title], [category], [poststatus], [commentstatus], [postupdatetime], [commentcount]) VALUES ( @author, @uid, @postdatetime, @content, @title, @category, @poststatus, @commentstatus, @postupdatetime, @commentcount);SELECT SCOPE_IDENTITY();"); //向关联表中插入相关数据 IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sqlstring, prams); sqlstring = "UPDATE [" + BaseConfigs.GetTablePrefix + "spaceconfigs] SET [updatedatetime]=@postupdatetime WHERE [userid]=@uid"; DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams); if (reader != null) { reader.Read(); foreach (string cateogryid in spaceposts.Category.Split(',')) { if (cateogryid != "") { SpacePostCategoryInfo spacepostCategoryInfo = new SpacePostCategoryInfo(); spacepostCategoryInfo.PostID = Convert.ToInt32(reader[0].ToString()); spacepostCategoryInfo.CategoryID = Convert.ToInt32(cateogryid); AddSpacePostCategory(spacepostCategoryInfo); } } } IDataParameter[] prams1 = { DbHelper.MakeInParam("@spacepostid", (DbType)SqlDbType.Int, 4,reader[0].ToString()), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spaceposts.Uid) }; reader.Close(); //更新与当前日志关联的附件表中的数据 DbHelper.ExecuteReader(CommandType.Text, "UPDATE [" + BaseConfigs.GetTablePrefix + "spaceattachments] SET [spacepostid] = @spacepostid WHERE [spacepostid] = 0 AND [uid] = @uid ", prams1); //对当前用户日志加1 CountUserSpacePostCountByUserID(spaceposts.Uid, 1); return true; //} //catch (Exception ex) //{ // errormsg = Globals.TransferSqlErrorInfo(ex.Message); // return false; //} }
public bool SaveSpacePost(SpacePostInfo spaceposts) { //try //{ IDataParameter[] prams = { DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4, spaceposts.PostID), DbHelper.MakeInParam("@author", (DbType)SqlDbType.NVarChar, 20, spaceposts.Author), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, spaceposts.Uid), DbHelper.MakeInParam("@postdatetime", (DbType)SqlDbType.DateTime, 8, spaceposts.PostDateTime), DbHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 0, spaceposts.Content), DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 150, spaceposts.Title), DbHelper.MakeInParam("@category", (DbType)SqlDbType.VarChar, 255, spaceposts.Category), DbHelper.MakeInParam("@poststatus", (DbType)SqlDbType.TinyInt, 1, spaceposts.PostStatus), DbHelper.MakeInParam("@commentstatus", (DbType)SqlDbType.TinyInt, 1, spaceposts.CommentStatus), DbHelper.MakeInParam("@postupdatetime", (DbType)SqlDbType.DateTime, 8, spaceposts.PostUpDateTime) }; string sqlstring = String.Format("UPDATE [" + BaseConfigs.GetTablePrefix + "spaceposts] SET [author] = @author, [uid] = @uid, [postdatetime] = @postdatetime, [content] = @content, [title] = @title, [category] = @category, [poststatus] = @poststatus, [commentstatus] = @commentstatus, [postupdatetime] = @postupdatetime WHERE [postid] = @postid"); DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams); sqlstring = "UPDATE [" + BaseConfigs.GetTablePrefix + "spaceconfigs] SET [updatedatetime]=@postupdatetime WHERE [userid]=@uid"; DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams); //先删除指定的日志关联数据再插入新数据 DeleteSpacePostCategoryByPostID(spaceposts.PostID); foreach (string cateogryid in spaceposts.Category.Split(',')) { if (cateogryid != "") { SpacePostCategoryInfo spacepostCategoryInfo = new SpacePostCategoryInfo(); spacepostCategoryInfo.PostID = spaceposts.PostID; spacepostCategoryInfo.CategoryID = Convert.ToInt32(cateogryid); AddSpacePostCategory(spacepostCategoryInfo); } } return true; //} //catch (Exception ex) //{ // errormsg = Globals.TransferSqlErrorInfo(ex.Message); // return false; //} }
public static SpacePostCategoryInfo[] GetSpacePostCategories (DataTable dt) { if(dt == null || dt.Rows.Count == 0) return null; SpacePostCategoryInfo[] spacepostcategoriesinfoarray = new SpacePostCategoryInfo[dt.Rows.Count]; for(int i = 0 ; i < dt.Rows.Count ; i++) { spacepostcategoriesinfoarray[i].ID = TypeConverter.ObjectToInt(dt.Rows[i]["id"]); spacepostcategoriesinfoarray[i].PostID = TypeConverter.ObjectToInt(dt.Rows[i]["postid"]); spacepostcategoriesinfoarray[i].CategoryID = TypeConverter.ObjectToInt(dt.Rows[i]["categoryid"]); } dt.Dispose(); return spacepostcategoriesinfoarray; }
public static SpacePostCategoryInfo GetSpacePostCategoryInfo (IDataReader idatareader) { if(idatareader == null) return null; if(idatareader.Read()) { SpacePostCategoryInfo spacepostcategoriesinfo = new SpacePostCategoryInfo(); spacepostcategoriesinfo.ID = TypeConverter.ObjectToInt(idatareader["id"]); spacepostcategoriesinfo.PostID = TypeConverter.ObjectToInt(idatareader["postid"]); spacepostcategoriesinfo.CategoryID = TypeConverter.ObjectToInt(idatareader["categoryid"]); idatareader.Close(); return spacepostcategoriesinfo; } else { idatareader.Close(); return null; } }
public bool AddSpacePostCategory(SpacePostCategoryInfo spacepostcategories) { DbParameter[] parms = { DbHelper.MakeInParam("@id", (DbType)SqlDbType.Int, 4,spacepostcategories.ID), DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4,spacepostcategories.PostID), DbHelper.MakeInParam("@categoryid", (DbType)SqlDbType.Int, 4,spacepostcategories.CategoryID) }; string commandText = String.Format("INSERT INTO [{0}spacepostcategories] ([postid], [categoryid]) VALUES ( @postid, @categoryid)", BaseConfigs.GetTablePrefix); DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); return true; }
public bool SaveSpacePost(SpacePostInfo spaceposts) { DbParameter[] parms = { DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4, spaceposts.Postid), DbHelper.MakeInParam("@author", (DbType)SqlDbType.NVarChar, 20, spaceposts.Author), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, spaceposts.Uid), DbHelper.MakeInParam("@postdatetime", (DbType)SqlDbType.DateTime, 8, spaceposts.Postdatetime), DbHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 0, spaceposts.Content), DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 150, spaceposts.Title), DbHelper.MakeInParam("@category", (DbType)SqlDbType.VarChar, 255, spaceposts.Category), DbHelper.MakeInParam("@poststatus", (DbType)SqlDbType.TinyInt, 1, spaceposts.PostStatus), DbHelper.MakeInParam("@commentstatus", (DbType)SqlDbType.TinyInt, 1, spaceposts.CommentStatus), DbHelper.MakeInParam("@postupdatetime", (DbType)SqlDbType.DateTime, 8, spaceposts.PostUpDateTime) }; string commandText = string.Format("UPDATE [{0}spaceposts] SET [author] = @author, [uid] = @uid, [postdatetime] = @postdatetime, [content] = @content, [title] = @title, [category] = @category, [poststatus] = @poststatus, [commentstatus] = @commentstatus, [postupdatetime] = @postupdatetime WHERE [postid] = @postid", BaseConfigs.GetTablePrefix); DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); commandText = string.Format("UPDATE [{0}spaceconfigs] SET [updatedatetime]=@postupdatetime WHERE [userid]=@uid", BaseConfigs.GetTablePrefix); DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); //先删除指定的日志关联数据再插入新数据 DeleteSpacePostCategoryByPostID(spaceposts.Postid); foreach (string cateogryid in spaceposts.Category.Split(',')) { if (cateogryid != "") { SpacePostCategoryInfo spacepostCategoryInfo = new SpacePostCategoryInfo(); spacepostCategoryInfo.PostID = spaceposts.Postid; spacepostCategoryInfo.CategoryID = Convert.ToInt32(cateogryid); AddSpacePostCategory(spacepostCategoryInfo); } } return true; }
public int AddSpacePost(SpacePostInfo spaceposts) { DbParameter[] parms = { DbHelper.MakeInParam("@postid", (DbType)SqlDbType.Int, 4,spaceposts.Postid), DbHelper.MakeInParam("@author", (DbType)SqlDbType.NVarChar, 20,spaceposts.Author), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spaceposts.Uid), DbHelper.MakeInParam("@postdatetime", (DbType)SqlDbType.DateTime, 8,spaceposts.Postdatetime), DbHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 0,spaceposts.Content), DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 150,spaceposts.Title), DbHelper.MakeInParam("@category", (DbType)SqlDbType.VarChar, 255,spaceposts.Category), DbHelper.MakeInParam("@poststatus", (DbType)SqlDbType.TinyInt, 1,spaceposts.PostStatus), DbHelper.MakeInParam("@commentstatus", (DbType)SqlDbType.TinyInt, 1,spaceposts.CommentStatus), DbHelper.MakeInParam("@postupdatetime", (DbType)SqlDbType.DateTime, 8,spaceposts.PostUpDateTime), DbHelper.MakeInParam("@commentcount", (DbType)SqlDbType.Int, 4,spaceposts.Commentcount) }; string commandText = string.Format("INSERT INTO [{0}spaceposts] ([author], [uid], [postdatetime], [content], [title], [category], [poststatus], [commentstatus], [postupdatetime], [commentcount]) VALUES ( @author, @uid, @postdatetime, @content, @title, @category, @poststatus, @commentstatus, @postupdatetime, @commentcount);SELECT SCOPE_IDENTITY();", BaseConfigs.GetTablePrefix); //向关联表中插入相关数据 int postid = TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(CommandType.Text, commandText, parms)); commandText = string.Format("UPDATE [{0}spaceconfigs] SET [updatedatetime]=@postupdatetime WHERE [userid]=@uid", BaseConfigs.GetTablePrefix); DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); if (postid > 0) { foreach (string cateogryid in spaceposts.Category.Split(',')) { if (cateogryid != "") { SpacePostCategoryInfo spacepostCategoryInfo = new SpacePostCategoryInfo(); spacepostCategoryInfo.PostID = postid; spacepostCategoryInfo.CategoryID = Convert.ToInt32(cateogryid); AddSpacePostCategory(spacepostCategoryInfo); } } } DbParameter[] prams1 = { DbHelper.MakeInParam("@spacepostid", (DbType)SqlDbType.Int, 4, postid), DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4,spaceposts.Uid) }; //更新与当前日志关联的附件表中的数据 DbHelper.ExecuteReader(CommandType.Text, string.Format("UPDATE [{0}spaceattachments] SET [spacepostid] = @spacepostid WHERE [spacepostid] = 0 AND [uid] = @uid ", BaseConfigs.GetTablePrefix), prams1); //对当前用户日志加1 CountUserSpacePostCountByUserID(spaceposts.Uid, 1); return postid; }