//删除一条购物车数据
public int deleteOrdetail(OrDetailId orDetail)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete OrDetailId where GId=" + orDetail.GId + " and UserId=" + orDetail.UserId);
return(DbHelperSQL.ExecuteSql(strSql.ToString()));
}
//修改一条购物车数据
public int UpOrdetail(OrDetailId orDetail)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrDetailId set num=" + orDetail.num + ",total=" + orDetail.total + " where GId=" + orDetail.GId);
return(DbHelperSQL.ExecuteSql(strSql.ToString()));
}
//插入一条购物车数据
public int InsertOD(OrDetailId orDetailId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrDetailId(GId,price,num,total,UserId,createTime) ");
strSql.Append("values(" + orDetailId.GId + "," + orDetailId.price + "," + orDetailId.num + "," + orDetailId.total + "," + orDetailId.UserId + ",'" + orDetailId.createTime + "')");
return(DbHelperSQL.ExecuteSql(strSql.ToString()));
}
public int InsetGw(OrDetailId orDetailId)
{
return(dal.InsertOD(orDetailId));
}
public int deleteOrdetail(OrDetailId orDetail)
{
return(dal.deleteOrdetail(orDetail));
}
public int UpOrdetail(OrDetailId orDetail)
{
return(dal.UpOrdetail(orDetail));
}
