62,041
社区成员
发帖
与我相关
我的任务
分享
public const string CategoryUpdate = "UPDATE [SCM_ContentCategory] SET [ParentId] = @ParentId, [TemplateId] = @TemplateId, [Title] = @Title, [Content] = @Content, [ContentView] = @ContentView, [UseSubTemplate] = @UseSubTemplate, [SubOrdering] = @SubOrdering, [Kind] = @Kind, [SortOrder] = @SortOrder WHERE [CategoryId] = @CategoryId;";
public bool Update(CategoryInfo target)
{
OleDbParameter[] op = {
new OleDbParameter("@CategoryId", OleDbType.Integer),
new OleDbParameter("@ParentId", OleDbType.Integer),
new OleDbParameter("@TemplateId", OleDbType.Integer),
new OleDbParameter("@Title", OleDbType.VarWChar),
new OleDbParameter("@Content", OleDbType.LongVarWChar),
new OleDbParameter("@ContentView", OleDbType.Integer),
new OleDbParameter("@UseSubTemplate", OleDbType.Boolean),
new OleDbParameter("@SubOrdering", OleDbType.Integer),
new OleDbParameter("@Kind", OleDbType.Integer),
new OleDbParameter("@SortOrder", OleDbType.Integer)
};
op[0].Value = target.CategoryId;
op[1].Value = target.ParentId;
op[2].Value = target.TemplateId;
op[3].Value = target.Title;
op[4].Value = target.Content;
op[5].Value = (Int32)target.ContentView;
op[6].Value = target.UseSubTemplate;
op[7].Value = (Int32)target.SubOrdering;
op[8].Value = (Int32)target.Kind;
op[9].Value = target.SortOrder;
int result = OleDbHelper.ExecuteNonQuery(ConfigValue.ConnectionString, CommandType.Text, SqlStatements.CategoryUpdate, op);
return (1 == result);
}
public bool Update(CategoryInfo target)
{
OleDbParameter[] op = {
new OleDbParameter("@ParentId", OleDbType.Integer),
new OleDbParameter("@TemplateId", OleDbType.Integer),
new OleDbParameter("@Title", OleDbType.VarWChar),
new OleDbParameter("@Content", OleDbType.LongVarWChar),
new OleDbParameter("@ContentView", OleDbType.Integer),
new OleDbParameter("@UseSubTemplate", OleDbType.Boolean),
new OleDbParameter("@SubOrdering", OleDbType.Integer),
new OleDbParameter("@Kind", OleDbType.Integer),
new OleDbParameter("@SortOrder", OleDbType.Integer),
new OleDbParameter("@CategoryId", OleDbType.Integer)
};
op[0].Value = target.ParentId;
op[1].Value = target.TemplateId;
op[2].Value = target.Title;
op[3].Value = target.Content;
op[4].Value = (Int32)target.ContentView;
op[5].Value = target.UseSubTemplate;
op[6].Value = (Int32)target.SubOrdering;
op[7].Value = (Int32)target.Kind;
op[8].Value = target.SortOrder;
op[9].Value = target.CategoryId;
int result = OleDbHelper.ExecuteNonQuery(ConfigValue.ConnectionString, CommandType.Text, SqlStatements.CategoryUpdate, op);
return (1 == result);