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
}
