/// <summary> /// 根据指定用户的指定产品返回所有订单信息 /// </summary> public List <XCLCMS.Data.Model.View.v_Orders> GetUserProductOrderModelList(Order_UserProductCondition condition) { Database db = base.CreateDatabase(); string topStr = " * "; if (condition.Top > 0) { topStr = string.Format(" TOP {0} * ", condition.Top); } DbCommand dbCommand = db.GetSqlStringCommand("SELECT " + topStr + " FROM dbo.v_Orders WITH(NOLOCK) WHERE FK_ProductID=@FK_ProductID AND FK_UserID=@FK_UserID AND UserName=@UserName "); db.AddInParameter(dbCommand, "FK_ProductID", DbType.Int64, condition.ProductID); db.AddInParameter(dbCommand, "FK_UserID", DbType.Int64, condition.UserID); db.AddInParameter(dbCommand, "UserName", DbType.String, condition.UserName); if (!string.IsNullOrWhiteSpace(condition.PayStatus)) { dbCommand.CommandText += " AND PayStatus=@PayStatus "; db.AddInParameter(dbCommand, "PayStatus", DbType.AnsiString, condition.PayStatus); } if (!string.IsNullOrWhiteSpace(condition.RecordState)) { dbCommand.CommandText += " AND RecordState=@RecordState "; db.AddInParameter(dbCommand, "RecordState", DbType.AnsiString, condition.RecordState); } using (var dr = db.ExecuteReader(dbCommand)) { return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToList <XCLCMS.Data.Model.View.v_Orders>(dr)); } }
/// <summary> /// 根据指定用户的指定产品返回所有订单信息 /// </summary> public List <XCLCMS.Data.Model.View.v_Orders> GetUserProductOrderModelList(Order_UserProductCondition condition) { return(dal.GetUserProductOrderModelList(condition)); }