public bool Update(CsMenus model) { var strSql = new StringBuilder(); strSql.Append("UPDATE CrabShop.dbo.[CsMenus] SET "); strSql.Append("MenuName = @MenuName,MenuUrl = @MenuUrl,MenuIcon = @MenuIcon,MenuParId = @MenuParId,MenuState = @MenuState,Remarks = @Remarks,MenuOrder = @MenuOrder"); strSql.Append(" WHERE MenuId = @MenuId"); return(DbClient.Excute(strSql.ToString(), model) > 0); }
public int Add(CsMenus model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsMenus] ("); strSql.Append("MenuName,MenuUrl,MenuIcon,MenuParId,MenuState,Remarks,MenuOrder"); strSql.Append(") VALUES ("); strSql.Append("@MenuName,@MenuUrl,@MenuIcon,@MenuParId,@MenuState,@Remarks,@MenuOrder);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }