/// <summary>
/// ProductEvaluation_Insert Method
/// </summary>
/// <param name="ProductEvaluationInfo">ProductEvaluation object</param>
/// <returns></returns>
internal int ProductEvaluation_Insert(ProductEvaluationInfo model)
{
string sqlCommand = "ProductEvaluation_Insert";
DbCommand dbCommand = dbw.GetStoredProcCommand(sqlCommand);
dbw.AddOutParameter(dbCommand, "EvaluationID", DbType.Int64, 4);
dbw.AddInParameter(dbCommand, "ProductID", DbType.Int32, model.ProductID);
dbw.AddInParameter(dbCommand, "ProductCode", DbType.String, model.ProductCode);
dbw.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
dbw.AddInParameter(dbCommand, "UserName", DbType.String, model.UserName);
dbw.AddInParameter(dbCommand, "EvalTime", DbType.DateTime, model.EvalTime);
dbw.AddInParameter(dbCommand, "Title", DbType.String, model.Title);
dbw.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
dbw.AddInParameter(dbCommand, "Score", DbType.Int16, model.Score);
dbw.AddInParameter(dbCommand, "ScoreDes", DbType.Decimal, model.ScoreDes);
dbw.AddInParameter(dbCommand, "ScoreService", DbType.Decimal, model.ScoreService);
dbw.AddInParameter(dbCommand, "ScoreSend", DbType.Decimal, model.ScoreSend);
dbw.AddInParameter(dbCommand, "ScoreLogistics", DbType.Decimal, model.ScoreLogistics);
dbw.AddInParameter(dbCommand, "FlowerCount", DbType.Int32, model.FlowerCount);
dbw.AddInParameter(dbCommand, "EggCount", DbType.Int32, model.EggCount);
dbw.AddInParameter(dbCommand, "OrderID", DbType.String, model.OrderID);
dbw.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status);
dbw.AddInParameter(dbCommand, "UpdateTime", DbType.DateTime, model.UpdateTime);
dbw.ExecuteNonQuery(dbCommand);
return(int.Parse(dbw.GetParameterValue(dbCommand, "EvaluationID").ToString()));
}
/// <summary>
/// 从 IDataReader 中恢复ProductEvaluation对象
/// </summary>
/// <param name="IDataReader"></param>
/// <returns></returns>
private ProductEvaluationInfo RecoverModel(IDataReader dataReader)
{
ProductEvaluationInfo info = new ProductEvaluationInfo();
info.EvaluationID = long.Parse(dataReader["EvaluationID"].ToString());
info.ProductID = int.Parse(dataReader["ProductID"].ToString());
info.ProductCode = dataReader["ProductCode"].ToString();
info.UID = int.Parse(dataReader["UID"].ToString());
info.UserName = dataReader["UserName"].ToString();
info.EvalTime = DateTime.Parse(dataReader["EvalTime"].ToString());
info.Title = dataReader["Title"].ToString();
info.Content = dataReader["Content"].ToString();
info.Score = short.Parse(dataReader["Score"].ToString());
info.ScoreDes = decimal.Parse(dataReader["ScoreDes"].ToString());
info.ScoreService = decimal.Parse(dataReader["ScoreService"].ToString());
info.ScoreSend = decimal.Parse(dataReader["ScoreSend"].ToString());
info.ScoreLogistics = decimal.Parse(dataReader["ScoreLogistics"].ToString());
info.FlowerCount = int.Parse(dataReader["FlowerCount"].ToString());
info.EggCount = int.Parse(dataReader["EggCount"].ToString());
info.OrderID = dataReader["OrderID"].ToString();
info.Status = short.Parse(dataReader["Status"].ToString());
info.UpdateTime = DateTime.Parse(dataReader["UpdateTime"].ToString());
return(info);
}
/// <summary>
/// 新增评论
/// </summary>
/// <param name="info">评论实体</param>
/// <returns></returns>
public bool Add(ProductEvaluationInfo info)
{
// 提交评论
string postData = JsonHelper.GetJson(info);
CommonRequest request = new CommonRequest();
CommonResponse response = client.Execute(request, add, postData);
if (response != null)
{
return(response.success);
}
return(false);
}
/// <summary>
/// ProductEvaluation_Get Method
/// </summary>
/// <param name="evaluationID">ProductEvaluation Main ID</param>
/// <returns>ProductEvaluationInfo get from ProductEvaluation table.</returns>
internal ProductEvaluationInfo ProductEvaluation_Get(long evaluationID)
{
ProductEvaluationInfo model = null;
string sqlCommand = "ProductEvaluation_Get";
DbCommand dbCommand = dbr.GetStoredProcCommand(sqlCommand);
dbr.AddInParameter(dbCommand, "EvaluationID", DbType.Int64, evaluationID);
using (IDataReader dataReader = dbr.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
model = RecoverModel(dataReader);
}
}
return(model);
}
/// <summary>
/// 评论详细
/// </summary>
/// <param name="evaluationId">评论ID</param>
/// <returns></returns>
public ProductEvaluationInfo Get(int evaluationId)
{
ProductEvaluationInfo info = new ProductEvaluationInfo()
{
evaluationID = evaluationId
};
// 查询
ProductEvaluationRequest request = new ProductEvaluationRequest()
{
evaluationId = evaluationId
};
string postData = JsonHelper.GetJson(request);
ProductEvaluationResponse response = client.Execute(request, get, postData);
if (response != null && response.evaluationDetail != null)
{
return(response.evaluationDetail);
}
return(info);
}
