public static int UpdateCategoryBrand(CategoryBrandRankModel model, BaseDbHelper db)
{
string sql =
@"UPDATE Activity..[tbl_CategoryBrandRank] WITH(ROWLOCK)
SET
[ParentPkid] = @ParentPkid
,[Name] = ISNULL(@Name,[Name])
,[NameIndex] = @NameIndex
,[PageTitle] = ISNULL(@PageTitle,PageTitle)
,[PageShareTitle] = ISNULL(@PageShareTitle,PageShareTitle)
,[PageShareDescription] = ISNULL(@PageShareDescription,PageShareDescription)
,[PageShareContent] = ISNULL(@PageShareContent,PageShareContent)
WHERE PKID=@PKID";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.AddWithValue("@ParentPkid", model.ParentPkid);
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);
cmd.Parameters.AddWithValue("@PKID", model.PKID);
return(db.ExecuteNonQuery(cmd));
}
}
public long InsertCategoryBrand(CategoryBrandRankModel model)
{
using (var db = Tuhu.Component.Common.DbHelper.CreateDefaultDbHelper())
{
return(DalCategoryBrandRank.InsertCategoryBrand(model, db));
}
}
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()));
}
}
