public static OrderMixModel GetOrderMixInfo(long orderId, long userId) { #region OrderMixModel result = new OrderMixModel(); SqlDataReader reader = null; try { SqlParameter[] dbParams = new SqlParameter[] { SQLHelper.MakeParam(PARAM_ORDER_I,SqlDbType.BigInt,0,orderId), SQLHelper.MakeParam(PARAM_USER_ID,SqlDbType.BigInt,0,userId) }; reader = SQLHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, "OrderInfo_GetOrderMixInfo", dbParams); FillModelFrom(reader, result); } catch (Exception e) { ExceptionMessageDAL.Record(e); } finally { if (reader != null && reader.IsClosed == false) { reader.Close(); } } return result; #endregion }
private static void FillModelFrom(SqlDataReader reader, OrderMixModel obj) { #region while (reader.Read()) {//OrderInfo FillModelFrom(reader, obj.OrderInfo); } if (reader.NextResult()) {//OrderItem while (reader.Read()) { var orderItem = new OrderItemModel(); OrderItemDAL.FillModelFrom(reader, orderItem); obj.OrderItemList.Add(orderItem); } } if (reader.NextResult()) {//OrderDeliveryDetails while (reader.Read()) { OrderDeliveryDetailsDAL.FillModelFrom(reader, obj.OrderDeliveryDetails); } } #endregion }