/// <summary> /// 更新一条数据 /// </summary> public bool Update(SOSOshop.Model.Order.OrderProductCartPro model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderProductCartPro set "); strSql.Append("CartId=@CartId,"); strSql.Append("ProId=@ProId,"); strSql.Append("ProNum=@ProNum"); strSql.Append(" where Id=@Id "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CartId", DbType.Int32, model.CartId); db.AddInParameter(dbCommand, "ProId", DbType.Int32, model.ProId); db.AddInParameter(dbCommand, "ProNum", DbType.Int32, model.ProNum); db.AddInParameter(dbCommand, "Id", DbType.Int32, model.Id); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据([CartId],[ProId],[ProNum]) /// </summary> public void Add(SOSOshop.Model.Order.OrderProductCartPro model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderProductCartPro("); strSql.Append("[CartId],[ProId],[ProNum])"); strSql.Append(" values ("); strSql.Append("@CartId,@ProId,@ProNum)"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CartId", DbType.Int32, model.CartId); db.AddInParameter(dbCommand, "ProId", DbType.Int32, model.ProId); db.AddInParameter(dbCommand, "ProNum", DbType.Int32, model.ProNum); db.ExecuteScalar(dbCommand); }