/// <summary>
/// 获得店铺评价
/// </summary>
/// <param name="oid">订单id</param>
public static StoreReviewInfo GetStoreReviewByOid(int oid)
{
StoreReviewInfo storeReviewInfo = null;
IDataReader reader = BrnMall.Core.BMAData.RDBS.GetStoreReviewByOid(oid);
if (reader.Read())
{
storeReviewInfo = BuildStoreReviewFromReader(reader);
}
reader.Close();
return(storeReviewInfo);
}
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 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);
}
/// <summary>
/// 创建店铺评价
/// </summary>
/// <param name="storeReviewInfo">店铺评价信息</param>
public static void CreateStoreReview(StoreReviewInfo storeReviewInfo)
{
NStore.Data.Stores.CreateStoreReview(storeReviewInfo);
}
/// <summary>
/// 创建店铺评价
/// </summary>
/// <param name="storeReviewInfo">店铺评价信息</param>
public static void CreateStoreReview(StoreReviewInfo storeReviewInfo)
{
BrnMall.Core.BMAData.RDBS.CreateStoreReview(storeReviewInfo);
}
