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