public bool Update(CsRebate model) { var strSql = new StringBuilder(); strSql.Append("UPDATE CrabShop.dbo.[CsRebate] SET "); strSql.Append("UserId = @UserId,RebateMoney = @RebateMoney,RebateWeight = @RebateWeight,RebateTime = @RebateTime"); strSql.Append(" WHERE RebateId = @RebateId"); return(DbClient.Excute(strSql.ToString(), model) > 0); }
public int Add(CsRebate model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsRebate] ("); strSql.Append("UserId,RebateMoney,RebateWeight,RebateTime"); strSql.Append(") VALUES ("); strSql.Append("@UserId,@RebateMoney,@RebateWeight,@RebateTime);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }