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