public List<OrderViewModel> GetUserAllOrder(int userId, List<int> orderStatus) { var orderList = new List<OrderViewModel>(); using (var cmd = DataCommandManager.GetDataCommand("GetUserAllOrder")) { cmd.CommandText = string.Format(cmd.CommandText, string.Join(",", orderStatus)); cmd.SetParameterValue("@UserId", userId); using (var dr=cmd.ExecuteDataReader()) { while (dr.Read()) { var orderViewModel = new OrderViewModel(); orderViewModel.OrderId = !Convert.IsDBNull(dr["OrderId"]) ? Convert.ToInt64(dr["OrderId"]) : 0; orderViewModel.UserId = !Convert.IsDBNull(dr["UserId"]) ? Convert.ToInt32(dr["UserId"]) : 0; orderViewModel.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue; orderViewModel.ProductId = !Convert.IsDBNull(dr["ProductId"]) ? Convert.ToInt32(dr["ProductId"]) : 0; orderViewModel.ProductCount = !Convert.IsDBNull(dr["ProductCount"]) ? Convert.ToInt32(dr["ProductCount"]) : 0; orderViewModel.Price = !Convert.IsDBNull(dr["Price"]) ? Convert.ToDecimal(dr["Price"]) : 0; orderViewModel.Status = !Convert.IsDBNull(dr["Status"]) ? Convert.ToInt32(dr["Status"]) : 0; orderViewModel.PayType = !Convert.IsDBNull(dr["PayType"]) ? Convert.ToInt32(dr["PayType"]) : 0; orderViewModel.ProductName = !Convert.IsDBNull(dr["ProductName"]) ? dr["ProductName"].ToString() : string.Empty; //orderViewModel.TotalMoney = !Convert.IsDBNull(dr["TotalMoney"]) ? Convert.ToDecimal(dr["TotalMoney"]) : 0; orderViewModel.Earning = !Convert.IsDBNull(dr["Earning"]) ? Convert.ToDecimal(dr["Earning"]) : 0; orderViewModel.EarningDay = !Convert.IsDBNull(dr["EarningDay"]) ? Convert.ToInt32(dr["EarningDay"]) : 0; orderViewModel.EarningRate = !Convert.IsDBNull(dr["EarningRate"]) ? Convert.ToDecimal(dr["EarningRate"]) : 0; orderViewModel.YearEarningRate = !Convert.IsDBNull(dr["YearEarningRate"]) ? Convert.ToDecimal(dr["YearEarningRate"]) : 0; orderViewModel.StartTime = !Convert.IsDBNull(dr["StartTime"]) ? Convert.ToDateTime(dr["StartTime"]) : DateTime.MinValue; orderViewModel.EndTime = !Convert.IsDBNull(dr["EndTime"]) ? Convert.ToDateTime(dr["EndTime"]) : DateTime.MinValue; if (orderViewModel.OrderId > 0) { orderList.Add(orderViewModel); } } } } return orderList; }
private OrderViewModel OrderModelToOrderViewModel(OrderModel orderModel,ProductModel productModel) { var orderViewModel = new OrderViewModel(); if (orderModel != null) { orderViewModel.OrderId = orderModel.OrderId; orderViewModel.UserId = orderModel.UserId; orderViewModel.CreateTime = orderModel.CreateTime; orderViewModel.ProductId = orderModel.ProductId; orderViewModel.ProductCount = orderModel.ProductCount; orderViewModel.Price = orderModel.Price; orderViewModel.Status = orderModel.Status; orderViewModel.PayType = orderModel.PayType; orderViewModel.TotalMoney = orderModel.Price*orderModel.ProductCount; } if (productModel != null) { orderViewModel.ProductName = productModel.Name; } return orderViewModel; }
public OrderViewModel GetOrderViewModel(long orderId, int userId) { var orderModel = new OrderViewModel(); using (var cmd = DataCommandManager.GetDataCommand("GetOrderViewModel")) { cmd.SetParameterValue("@UserId", userId); cmd.SetParameterValue("@OrderId", orderId); using (var dr = cmd.ExecuteDataReader()) { while (dr.Read()) { orderModel.OrderId = !Convert.IsDBNull("OrderId") ? long.Parse(dr["OrderId"].ToString()) : 0; orderModel.UserId = !Convert.IsDBNull("UserId") ? int.Parse(dr["UserId"].ToString()) : 0; orderModel.ProductId = !Convert.IsDBNull("ProductId") ? int.Parse(dr["ProductId"].ToString()) : 0; orderModel.ProductCount = !Convert.IsDBNull("ProductCount") ? int.Parse(dr["ProductCount"].ToString()) : 0; orderModel.Price = !Convert.IsDBNull("Price") ? decimal.Parse(dr["Price"].ToString()) : 0; orderModel.Status = !Convert.IsDBNull("Status") ? int.Parse(dr["Status"].ToString()) : 0; orderModel.PayType = !Convert.IsDBNull("PayType") ? int.Parse(dr["PayType"].ToString()) : 0; orderModel.ProductName = !Convert.IsDBNull(dr["ProductName"]) ? dr["ProductName"].ToString() : string.Empty; orderModel.TotalMoney = !Convert.IsDBNull(dr["TotalMoney"]) ? Convert.ToDecimal(dr["TotalMoney"]) : 0; orderModel.CreateTime = !Convert.IsDBNull("CreateTime") ? DateTime.Parse(dr["CreateTime"].ToString()) : DateTime.MinValue; } } } return orderModel; }
public PagedList<OrderViewModel> GetOrderList(int userId, int pageIndex, int pageSize) { var orderList = new List<OrderViewModel>(); var totalOrderCount = 0; using (var cmd = DataCommandManager.GetDataCommand("GetOrderList")) { cmd.SetParameterValue("@UserId", userId); cmd.SetParameterValue("@PageIndex", pageIndex); cmd.SetParameterValue("@PageSize", pageSize); using (var dr = cmd.ExecuteDataReader()) { while (dr.Read()) { var orderViewModel = new OrderViewModel(); if (totalOrderCount == 0) { totalOrderCount = !Convert.IsDBNull(dr["TotalOrderCount"]) ? int.Parse(dr["TotalOrderCount"].ToString()) : 0; } orderViewModel.OrderId = !Convert.IsDBNull(dr["OrderId"]) ? Convert.ToInt64(dr["OrderId"]) : 0; orderViewModel.UserId = !Convert.IsDBNull(dr["UserId"]) ? Convert.ToInt32(dr["UserId"]) : 0; orderViewModel.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue; orderViewModel.ProductId = !Convert.IsDBNull(dr["ProductId"]) ? Convert.ToInt32(dr["ProductId"]) : 0; orderViewModel.ProductCount = !Convert.IsDBNull(dr["ProductCount"]) ? Convert.ToInt32(dr["ProductCount"]) : 0; orderViewModel.Price = !Convert.IsDBNull(dr["Price"]) ? Convert.ToDecimal(dr["Price"]) : 0; orderViewModel.Status = !Convert.IsDBNull(dr["Status"]) ? Convert.ToInt32(dr["Status"]) : 0; orderViewModel.PayType = !Convert.IsDBNull(dr["PayType"]) ? Convert.ToInt32(dr["PayType"]) : 0; orderViewModel.ProductName = !Convert.IsDBNull(dr["ProductName"]) ? dr["ProductName"].ToString() : string.Empty; orderViewModel.ProductImgUrl = !Convert.IsDBNull(dr["ImgUrl"])? dr["ImgUrl"].ToString(): string.Empty; orderViewModel.TotalMoney = !Convert.IsDBNull(dr["TotalMoney"]) ? Convert.ToDecimal(dr["TotalMoney"]) : 0; orderViewModel.EarningDay = !Convert.IsDBNull(dr["EarningDay"]) ? Convert.ToInt32(dr["EarningDay"]) : 0; orderViewModel.StartTime = !Convert.IsDBNull(dr["StartTime"]) ? Convert.ToDateTime(dr["StartTime"]) : DateTime.MaxValue; orderViewModel.EndTime = !Convert.IsDBNull(dr["EndTime"]) ? Convert.ToDateTime(dr["EndTime"]) : DateTime.MaxValue; if (orderViewModel.OrderId > 0) { orderList.Add(orderViewModel); } } } } var result = new PagedList<OrderViewModel>(orderList, pageIndex, pageSize, totalOrderCount); return result; }