/// <summary> /// 评价详情 /// </summary> /// <returns></returns> public ActionResult Evaluate() { int _orderdetailid = QueryString.IntSafeQ("odid"); VWOrderDetailEntity _orderdetail = OrderDetailBLL.Instance.GetVWOrderDetail(_orderdetailid, memid); if (_orderdetail != null && _orderdetail.Id > 0) { WLPsOrderDetailEntity _ps = WLPsOrderDetailBLL.Instance.GetWLByDetailId(_orderdetailid); ViewBag.WLDetail = _ps; } ViewBag.OrderDetail = _orderdetail; return(View()); }
public IList <VWOrderDetailEntity> GetOrderDetailsByCode(long code, int status = -1) { string where = " where Code=@Code "; if (status != -1) { where += " and Status=@Status"; } string sql = @"SELECT Id as PreTempDetailsId, [Code],[ProductDetailId],BrandId,ClassId,[ProductId],[ProductName],Spec1,Spec2,Spec3,[ProductPic],[ProductPicSuffix],[DiscountId],[MarketPrice],[ActualPrice],[Num],[TotalPrice],[TotalMarketPrice],[CreateTime],TransFeeType,TransFee,ProductType,Status,Remark,CGMemId,IsAhmTake from dbo.[OrderDetailPreTemp] WITH(NOLOCK) " + where; IList <VWOrderDetailEntity> entityList = new List <VWOrderDetailEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Code", DbType.Int64, code); if (status != -1) { db.AddInParameter(cmd, "@Status", DbType.Int64, status); } using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { VWOrderDetailEntity entity = new VWOrderDetailEntity(); entity.OrderDetailId = StringUtils.GetDbInt(reader["PreTempDetailsId"]); entity.OrderCode = StringUtils.GetDbLong(reader["Code"]); entity.ProductDetailId = StringUtils.GetDbInt(reader["ProductDetailId"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.Spec1 = StringUtils.GetDbString(reader["Spec1"]); entity.Spec2 = StringUtils.GetDbString(reader["Spec2"]); entity.Spec3 = StringUtils.GetDbString(reader["Spec3"]); entity.ProductPic = StringUtils.GetDbString(reader["ProductPic"]); entity.ProductPicSuffix = StringUtils.GetDbString(reader["ProductPicSuffix"]); entity.ActualPrice = StringUtils.GetDbDecimal(reader["ActualPrice"]); entity.TransFeeType = StringUtils.GetDbInt(reader["TransFeeType"]); entity.TransFee = StringUtils.GetDbDecimal(reader["TransFee"]); entity.Num = StringUtils.GetDbInt(reader["Num"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.TotalPrice = StringUtils.GetDbDecimal(reader["TotalPrice"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.CGMemId = StringUtils.GetDbInt(reader["CGMemId"]); entity.IsAhmTake = StringUtils.GetDbInt(reader["IsAhmTake"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 评价详情,只读 /// </summary> /// <returns></returns> public ActionResult EvaluateRead() { int _odid = QueryString.IntSafeQ("odid"); IList <CommentEntity> _list = CommentBLL.Instance.GetCommentByODId(_odid, memid); if (_list != null && _list.Count > 0) { CommentEntity centity = _list[0]; int productid = centity.ProductId; VWOrderDetailEntity _detailentity = OrderDetailBLL.Instance.GetVWOrderDetail(_odid, memid); IList <CommentPicEntity> commentpics = CommentPicBLL.Instance.GetCommentPicAll(centity.Id); //ViewBag.CommentList = _list; ViewBag.CommentEntity = centity; ViewBag.ProductEntity = _detailentity; ViewBag.CommentPicList = commentpics; } return(View()); }