private static IStoreNOSQLStrategy _storenosql = BMAData.StoreNOSQL;//店铺非关系型数据库 #region 辅助方法 /// <summary> /// 从IDataReader创建StoreReviewInfo /// </summary> public static StoreReviewInfo BuildStoreReviewFromReader(IDataReader reader) { StoreReviewInfo storeReviewInfo = new StoreReviewInfo(); storeReviewInfo.ReviewId = TypeHelper.ObjectToInt(reader["reviewid"]); storeReviewInfo.Oid = TypeHelper.ObjectToInt(reader["oid"]); storeReviewInfo.StoreId = TypeHelper.ObjectToInt(reader["storeid"]); storeReviewInfo.DescriptionStar = TypeHelper.ObjectToInt(reader["descriptionstar"]); storeReviewInfo.ServiceStar = TypeHelper.ObjectToInt(reader["servicestar"]); storeReviewInfo.ShipStar = TypeHelper.ObjectToInt(reader["shipstar"]); storeReviewInfo.Uid = TypeHelper.ObjectToInt(reader["uid"]); storeReviewInfo.ReviewTime = TypeHelper.ObjectToDateTime(reader["reviewtime"]); storeReviewInfo.IP = reader["ip"].ToString(); return storeReviewInfo; }
/// <summary> /// 创建店铺评价 /// </summary> /// <param name="storeReviewInfo">店铺评价信息</param> public static void CreateStoreReview(StoreReviewInfo storeReviewInfo) { BrnMall.Data.Stores.CreateStoreReview(storeReviewInfo); }
/// <summary> /// 评价店铺 /// </summary> public ActionResult ReviewStore() { int oid = WebHelper.GetQueryInt("oid");//订单id int descriptionStar = WebHelper.GetFormInt("descriptionStar");//商品描述星星 int serviceStar = WebHelper.GetFormInt("serviceStar");//商家服务星星 int shipStar = WebHelper.GetFormInt("shipStar");//商家配送星星 if (descriptionStar > 5 || descriptionStar < 0) return AjaxResult("wrongdescriptionstar", "请选择正确的商品描述星星"); if (serviceStar > 5 || serviceStar < 0) return AjaxResult("wrongservicestar", "请选择正确的商家服务星星"); if (shipStar > 5 || shipStar < 0) return AjaxResult("wrongshipstar", "请选择正确的商家配送星星"); OrderInfo orderInfo = Orders.GetOrderByOid(oid); if (orderInfo == null || orderInfo.Uid != WorkContext.Uid) return AjaxResult("noexistorder", "订单不存在"); if (orderInfo.OrderState != (int)OrderState.Completed) return AjaxResult("nocomplete", "订单还未完成,不能评价"); StoreReviewInfo storeReviewInfo = Stores.GetStoreReviewByOid(oid); if (storeReviewInfo != null) return AjaxResult("reviewed", "店铺已经评价"); storeReviewInfo = new StoreReviewInfo() { Oid = oid, StoreId = orderInfo.StoreId, DescriptionStar = descriptionStar, ServiceStar = serviceStar, ShipStar = shipStar, Uid = WorkContext.Uid, ReviewTime = DateTime.Now, IP = WorkContext.IP }; Stores.CreateStoreReview(storeReviewInfo); if (Orders.IsReviewAllOrderProduct(Orders.GetOrderProductList(oid))) Orders.UpdateOrderIsReview(oid, 1); return AjaxResult("success", "店铺评价成功"); }
/// <summary> /// 创建店铺评价 /// </summary> /// <param name="storeReviewInfo">店铺评价信息</param> public static void CreateStoreReview(StoreReviewInfo storeReviewInfo) { BrnMall.Core.BMAData.RDBS.CreateStoreReview(storeReviewInfo); }
/// <summary> /// 创建店铺评价 /// </summary> /// <param name="storeReviewInfo">店铺评价信息</param> public void CreateStoreReview(StoreReviewInfo storeReviewInfo) { DbParameter[] parms = { GenerateInParam("@oid", SqlDbType.Int, 4, storeReviewInfo.Oid), GenerateInParam("@storeid", SqlDbType.Int, 4, storeReviewInfo.StoreId), GenerateInParam("@descriptionstar", SqlDbType.TinyInt, 1, storeReviewInfo.DescriptionStar), GenerateInParam("@servicestar", SqlDbType.TinyInt, 1, storeReviewInfo.ServiceStar), GenerateInParam("@shipstar", SqlDbType.TinyInt, 1, storeReviewInfo.ShipStar), GenerateInParam("@uid", SqlDbType.Int, 4, storeReviewInfo.Uid), GenerateInParam("@reviewtime", SqlDbType.DateTime, 8, storeReviewInfo.ReviewTime), GenerateInParam("@ip", SqlDbType.VarChar, 15, storeReviewInfo.IP) }; RDBSHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}createstorereview", RDBSHelper.RDBSTablePre), parms); }