/// <summary>
/// 获得商品咨询
/// </summary>
/// <param name="consultId">咨询id</param>
/// <returns></returns>
public static ProductConsultInfo GetProductConsultById(int consultId)
{
ProductConsultInfo productConsultInfo = null;
IDataReader reader = BrnShop.Core.BSPData.RDBS.GetProductConsultById(consultId);
if (reader.Read())
{
productConsultInfo = BuildProductConsultFromReader(reader);
}
reader.Close();
return(productConsultInfo);
}
/// <summary>
/// 后台获得商品咨询
/// </summary>
/// <param name="consultId">咨询id</param>
/// <returns></returns>
public static ProductConsultInfo AdminGetProductConsultById(int consultId)
{
ProductConsultInfo productConsultInfo = null;
IDataReader reader = NStore.Core.BMAData.RDBS.AdminGetProductConsultById(consultId);
if (reader.Read())
{
productConsultInfo = BuildProductConsultFromReader(reader);
}
reader.Close();
return(productConsultInfo);
}
/// <summary>
/// 获得用户商品咨询列表
/// </summary>
/// <param name="uid">用户id</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public static List <ProductConsultInfo> GetUserProductConsultList(int uid, int pageSize, int pageNumber)
{
List <ProductConsultInfo> productConsultList = new List <ProductConsultInfo>();
IDataReader reader = NStore.Core.BMAData.RDBS.GetUserProductConsultList(uid, pageSize, pageNumber);
while (reader.Read())
{
ProductConsultInfo productConsultInfo = BuildProductConsultFromReader(reader);
productConsultList.Add(productConsultInfo);
}
reader.Close();
return(productConsultList);
}
/// <summary>
/// 获得商品咨询列表
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pid">商品id</param>
/// <param name="consultTypeId">咨询类型id</param>
/// <param name="consultMessage">咨询内容</param>
/// <returns></returns>
public static List <ProductConsultInfo> GetProductConsultList(int pageSize, int pageNumber, int pid, int consultTypeId, string consultMessage)
{
List <ProductConsultInfo> productConsultList = new List <ProductConsultInfo>();
IDataReader reader = NStore.Core.BMAData.RDBS.GetProductConsultList(pageSize, pageNumber, pid, consultTypeId, consultMessage);
while (reader.Read())
{
ProductConsultInfo productConsultInfo = BuildProductConsultFromReader(reader);
productConsultList.Add(productConsultInfo);
}
reader.Close();
return(productConsultList);
}
/// <summary>
/// 后台获得商品咨询列表
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="condition">条件</param>
/// <returns></returns>
public static List <ProductConsultInfo> AdminGetProductConsultList(int pageSize, int pageNumber, string condition)
{
List <ProductConsultInfo> productConsultList = new List <ProductConsultInfo>();
IDataReader reader = BrnShop.Core.BSPData.RDBS.AdminGetProductConsultList(pageSize, pageNumber, condition);
while (reader.Read())
{
ProductConsultInfo productConsultInfo = BuildProductConsultFromReader(reader);
productConsultList.Add(productConsultInfo);
}
reader.Close();
return(productConsultList);
}
public ActionResult Reply(int consultId = -1)
{
ProductConsultInfo productConsultInfo = AdminProductConsults.AdminGetProductConsultById(consultId);
if (productConsultInfo == null)
{
return(PromptView("商品咨询不存在"));
}
ReplyProductConsultModel model = new ReplyProductConsultModel();
model.ReplyMessage = productConsultInfo.ReplyMessage;
ViewData["productConsultInfo"] = productConsultInfo;
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
public ActionResult Reply(ReplyProductConsultModel model, int consultId = -1)
{
ProductConsultInfo productConsultInfo = AdminProductConsults.AdminGetProductConsultById(consultId);
if (productConsultInfo == null)
{
return(PromptView("商品咨询不存在"));
}
if (ModelState.IsValid)
{
AdminProductConsults.ReplyProductConsult(consultId, WorkContext.Uid, DateTime.Now, model.ReplyMessage, WorkContext.NickName, WorkContext.IP);
AddMallAdminLog("回复商品咨询", "回复商品咨询,商品咨询为:" + consultId);
return(PromptView("商品咨询回复成功"));
}
ViewData["productConsultInfo"] = productConsultInfo;
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 更新商品咨询状态
/// </summary>
/// <param name="consultId">商品咨询id</param>
/// <param name="state">状态</param>
/// <returns></returns>
public ActionResult UpdateProductConsultState(int consultId = -1, int state = -1)
{
ProductConsultInfo productConsultInfo = AdminProductConsults.AdminGetProductConsultById(consultId);
if (productConsultInfo == null || productConsultInfo.StoreId != WorkContext.StoreId)
{
return(Content("0"));
}
bool result = AdminProductConsults.UpdateProductConsultState(consultId, state);
if (result)
{
AddStoreAdminLog("更新商品咨询状态", "更新商品咨询状态,咨询ID和状态为:" + consultId + "_" + state);
return(Content("1"));
}
else
{
return(Content("0"));
}
}
public ActionResult Reply(int consultId = -1)
{
ProductConsultInfo productConsultInfo = AdminProductConsults.AdminGetProductConsultById(consultId);
if (productConsultInfo == null)
{
return(PromptView("商品咨询不存在"));
}
if (productConsultInfo.StoreId != WorkContext.StoreId)
{
return(PromptView("不能回复其它店铺的商品咨询"));
}
ReplyProductConsultModel model = new ReplyProductConsultModel();
model.ProductConsultInfo = productConsultInfo;
model.ReplyMessage = productConsultInfo.ReplyMessage;
ViewData["referer"] = MallUtils.GetStoreAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 通过IDataReader创建ProductConsultInfo信息
/// </summary>
public static ProductConsultInfo BuildProductConsultFromReader(IDataReader reader)
{
ProductConsultInfo productConsultInfo = new ProductConsultInfo();
productConsultInfo.ConsultId = TypeHelper.ObjectToInt(reader["consultid"]);
productConsultInfo.ConsultTypeId = TypeHelper.ObjectToInt(reader["consulttypeid"]);
productConsultInfo.State = TypeHelper.ObjectToInt(reader["state"]);
productConsultInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]);
productConsultInfo.ConsultUid = TypeHelper.ObjectToInt(reader["consultuid"]);
productConsultInfo.ReplyUid = TypeHelper.ObjectToInt(reader["replyuid"]);
productConsultInfo.ConsultTime = TypeHelper.ObjectToDateTime(reader["consulttime"]);
productConsultInfo.ReplyTime = TypeHelper.ObjectToDateTime(reader["replytime"]);
productConsultInfo.ConsultMessage = reader["consultmessage"].ToString();
productConsultInfo.ReplyMessage = reader["replymessage"].ToString();
productConsultInfo.PName = reader["pname"].ToString();
productConsultInfo.ConsultNickName = reader["consultnickname"].ToString();
productConsultInfo.ReplyNickName = reader["replynickname"].ToString();
productConsultInfo.PShowImg = reader["pshowimg"].ToString();
productConsultInfo.ConsultIP = reader["consultip"].ToString();
productConsultInfo.ReplyIP = reader["replyip"].ToString();
return(productConsultInfo);
}
/// <summary>
/// 回复页面
/// </summary>
/// <returns></returns>
public ActionResult Maintain()
{
string sysNoText = Request["SysNo"];
if (!string.IsNullOrEmpty(sysNoText))
{
int sysNo = 0;
int.TryParse(sysNoText, out sysNo);
ProductConsultInfo entity = ProductConsultService.LoadProductConsultWithoutReply(sysNo);
if (entity == null)
{
return(RedirectToAction("Index", "ProductConsult"));
}
ViewBag.ProductConsultInfo = entity;
}
else
{
return(RedirectToAction("Index", "ProductConsult"));
}
return(View());
}
/// <summary>
/// 根据编号，加载相应的评咨询
/// </summary>
/// <param name="sysNo">The item system no.</param>
/// <returns></returns>
public static ProductConsultInfo LoadProductConsultWithoutReply(int sysNo)
{
ProductConsultInfo item = ProductConsultDA.LoadProductConsult(sysNo);
return(item);
}
