/// <summary>
/// 更新一条回复咨询
/// </summary>
/// <param name="reply">
/// 回复咨询的对象
/// </param>
public void UpdateConsultReply(Product_Consult reply)
{
var paras = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
reply.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
reply.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Content",
SqlDbType.NVarChar,
reply.Content,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.VarChar,
reply.CreateTime,
ParameterDirection.Input)
};
try
{
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Product_Consult_Reply_Update",
paras,
null);
}
catch (Exception exception)
{
throw new Exception("Exception - ProductConsult - ReplyConsult", exception);
}
}
/// <summary>
/// 添加商品咨询.
/// </summary>
/// <param name="productConsult">
/// Product_Consult.
/// </param>
/// <returns>
/// 咨询的编号.
/// </returns>
public int Insert(Product_Consult productConsult)
{
if (productConsult == null)
{
throw new ArgumentNullException("productConsult");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ProductID",
SqlDbType.Int,
productConsult.ProductID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UserID",
SqlDbType.Int,
productConsult.UserID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Content",
SqlDbType.VarChar,
productConsult.Content,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_Consult_Insert", parameters, null);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
public JsonResult AddConsult(int productID, string content)
{
try
{
var userID = this.GetUserID();
var productConsult = new Product_Consult
{
UserID = userID,
ProductID = productID,
Content = content
};
productConsult.ID = new ProductConsultService().Add(productConsult);
return this.Json(new AjaxResponse(1, "咨询成功！"));
}
catch (Exception exception)
{
return this.Json(new AjaxResponse(0, "咨询失败！：" + exception.Message));
}
}
/// <summary>
/// 修改咨询的回复信息
/// </summary>
/// <param name="reply">
/// 咨询对象
/// </param>
public void ModifyConsultReply(Product_Consult reply)
{
this.productConsultDA.UpdateConsultReply(reply);
}
/// <summary>
/// 添加商品咨询.
/// </summary>
/// <param name="productConsult">
/// Product_Consult.
/// </param>
/// <returns>
/// 咨询的编号.
/// </returns>
public int Add(Product_Consult productConsult)
{
return this.productConsultDA.Insert(productConsult);
}
/// <summary>
/// 回复商品咨询
/// </summary>
/// <param name="reply">
/// 回复咨询
/// </param>
public void ReplyConsult(Product_Consult reply)
{
this.productConsultDA.ReplyConsult(reply);
}