public static long InsertCategoryBrand(CategoryBrandRankModel model, BaseDbHelper db)
{
string sql =
@"INSERT INTO [Activity].[dbo].[tbl_CategoryBrandRank]
([ParentPkid]
,[Date]
,[Name]
,[NameIndex]
,[PageTitle]
,[PageShareTitle]
,[PageShareDescription]
,[PageShareContent]
,[CreateTime])
VALUES
(@ParentPkid
,@Date
,@Name
,@NameIndex
,@PageTitle
,@PageShareTitle
,@PageShareDescription
,@PageShareContent
,GETDATE());SELECT @@IDENTITY";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ParentPkid", model.ParentPkid);
cmd.Parameters.AddWithValue("@Date", model.Date);
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@NameIndex", model.NameIndex);
cmd.Parameters.AddWithValue("@PageTitle", model.PageTitle);
cmd.Parameters.AddWithValue("@PageShareTitle", model.PageShareTitle);
cmd.Parameters.AddWithValue("@PageShareDescription", model.PageShareDescription);
cmd.Parameters.AddWithValue("@PageShareContent", model.PageShareContent);
return(long.Parse(db.ExecuteScalar(cmd).ToString()));
}
}