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);
}
Helper 是用的PetShop的 SQLHelper类
Access 对应字段类型如下：
CategoryId --自动编号
ParentId --长整型
TemplateId --长整型
Title --文本
Content --备注
ContentView --长整型
UseSubTemplate --是/否
SubOrdering --长整型
Kind --长整型
SortOrder --长整型
保存后 就是没反应 调试的时候
Helper里面
int val = cmd.ExecuteNonQuery(); 总是返回 0
研究了 一天了 还是没研究出来什么问题 急需 大牛 帮助啊 ！！ 最好邮箱233186958@qq.com
