public static UserOrderCommonInfo GetDownloadInfo(string userName, int orderItemId) { UserOrderCommonInfo downloadInfo = dal.GetDownloadInfo(userName, orderItemId); if (string.IsNullOrEmpty(downloadInfo.TableName)) { PresentInfo presentById = Present.GetPresentById(downloadInfo.ProductId); downloadInfo.DownloadUrl = presentById.DownloadUrl; downloadInfo.Remark = presentById.Remark; return(downloadInfo); } ProductInfo productById = Product.GetProductById(downloadInfo.ProductId); downloadInfo.DownloadUrl = productById.DownloadUrl; downloadInfo.Remark = productById.Remark; return(downloadInfo); }
public UserOrderCommonInfo GetDownloadInfo(string userName, int orderItemId) { UserOrderCommonInfo info = new UserOrderCommonInfo(); string strSql = "SELECT I.* FROM PE_Orders O INNER JOIN PE_OrderItem I ON O.OrderID = I.OrderID WHERE O.UserName = @UserName AND EnableDownload = 1 AND I.ItemID = @ItemID"; Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@UserName", DbType.String, userName); cmdParams.AddInParameter("@ItemID", DbType.Int32, orderItemId); using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams)) { if (reader.Read()) { return(GetUserOrderCommonInfo(reader)); } return(new UserOrderCommonInfo(true)); } }
private static UserOrderCommonInfo GetUserOrderCommonInfo(NullableDataReader rdr) { UserOrderCommonInfo info = new UserOrderCommonInfo(); info.ProductId = rdr.GetInt32("ProductId"); info.TableName = rdr.GetString("TableName"); info.ProductName = rdr.GetString("ProductName"); info.Unit = rdr.GetString("Unit"); info.Amount = rdr.GetInt32("Amount"); info.BeginDate = rdr.GetDateTime("BeginDate"); info.Price = rdr.GetDecimal("Price"); info.TruePrice = rdr.GetDecimal("TruePrice"); info.ServiceTerm = rdr.GetInt32("ServiceTerm"); info.Remark = rdr.GetString("Remark"); info.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit"); info.OrderItemId = rdr.GetInt32("ItemId"); return(info); }