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