public string evapage()
{
int pageSize = 2;//每一页的行数
int pageNumber = 1;//当前页数
string html = "";
string skuid = "";
string where = "";
string where2 = "";
string skulist = "";
string sortby = " order by pa.pa_Id";
int mid = 0;
if (LoginMember != null)
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
}
Model.ProductAppraiseBase cmodel = new Model.ProductAppraiseBase();
var clist = new BLL.ProductAppraiseBase().GetModelList(" m_Id=" + mid + " and pa_IsDel=0 and pa_StatusCode=0");
if (clist.Count > 0)
{
foreach (var item in clist)
{
skulist += item.sku_ID + ",";
}
skulist = skulist.Substring(0, skulist.Length - 1);
where2 = " and vw.sku_ID in(" + skulist + ")";
where = " and sku_ID in(" + skulist + ")";
}
if (!string.IsNullOrEmpty(RequestBase.GetString("pageNum")))
{
pageNumber = Convert.ToInt32(RequestBase.GetString("pageNum"));
}
List<Model.vw_PInfo> list = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_SellStatus=1 and p_StatusCode=0 " + where);
ViewBag.collect = new BLL.vw_PInfo().GetModelListPA(" pa.m_ID=" + mid + " and p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 and pa.pa_IsDel=0 " + where2, pageNumber, pageSize, sortby);
//ViewBag.collect = list.ToPagedList(pageNumber, pageSize);
foreach (var item in ViewBag.collect)
{
html += " <li><table class=\"order-list\"><tbody><tr><td width=\"345\"><div class=\"pro-imgs\"><a href=\"/ProDetail/ProDetail?skuid="+item.sku_ID+"\"><img name=\"page_cnt_1\" _src=\""+item.pi_Url+"\" alt=\""+item.p_Name+"\" /></a></div><p><a href=\"/ProDetail/ProDetail?skuid="+item.sku_ID+"\">"+item.p_Name+" "+ item.shuxing+"</a></p></td><td width=\"200\" align=\"center\">";
if (item.pa_Satisfied == 1)
{ html += "<div class=\"stars star-icon1\"></div>";}
else if (item.pa_Satisfied == 2)
{ html +="<div class=\"stars star-icon2\"></div>";}
else if (item.pa_Satisfied == 3)
{html +="<div class=\"stars star-icon3\"></div>";}
else if (item.pa_Satisfied == 4)
{ html +="<div class=\"stars star-icon4\"></div>";}
else if (item.pa_Satisfied == 5)
{html += "<div class=\"stars star-icon5\"></div>";}
else
{
html += "<div class=\"stars star-icon5\"></div>";
}
html += "</td><td width=\"320\">" + item.pa_Content + "</td></tr></tbody></table></li>";
}
return html;
}
/// <summary>
/// 账户管理-商品评价页面
/// </summary>
/// <returns></returns>
public ActionResult vipMyEvaluation()
{
// Model.MemberBase model = null;
var model = new ListModel();
string where = "";
string where2 = "";
string sortby = " order by pa.pa_Id";
int page = 1;
int pagerows = 2;
string skulist = "";
int mid = 0;
if (LoginMember != null)
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
Model.ProductAppraiseBase cmodel = new Model.ProductAppraiseBase();
var clist = new BLL.ProductAppraiseBase().GetModelList(" m_Id=" + mid + " and pa_IsDel=0 and pa_StatusCode=0");
if (clist.Count > 0)
{
ViewData["Appraise"] = true;
foreach (var item in clist)
{
skulist += item.sku_ID + ",";
}
skulist = skulist.Substring(0, skulist.Length - 1);
where = " and vw.sku_ID in(" + skulist + ")";
where2 = " and sku_ID in(" + skulist + ")";
model.vmpinfolist = new BLL.vw_PInfo().GetModelListPA(" pa.m_ID=" + mid + " and p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 and pa.pa_IsDel=0 " + where, page, pagerows, sortby);
ViewData["count"] = clist.Count;
ViewData["pagerows"] = pagerows;
ViewData["page"] = page;
return View(model.vmpinfolist);
}
else
{
ViewData["Appraise"] = false;
return View();
}
}
else
{
Response.Redirect("/Index/Index");
return View();
}
}
public string ProPinglun2()
{
int pinglunpageSize = 2;//每一页的行数
int pinglunpageNumber = 1;//当前页数
string html = "";
int xing = 0;
string skuid = "";
if (!string.IsNullOrEmpty(RequestBase.GetString("pageNum")))
{
pinglunpageNumber = Convert.ToInt32(RequestBase.GetString("pageNum"));
}
if (!string.IsNullOrEmpty(RequestBase.GetString("skuid")))
{
skuid = RequestBase.GetString("skuid").ToString();
}
var pl = new BLL.ProductAppraiseBase().GetModelListByskuId(" sku_ID= " + int.Parse(skuid) + " order by pa_CreatedOn desc");
ViewBag.pinlun = pl.ToPagedList(pinglunpageNumber, pinglunpageSize);
html += "<ul class=\"vip-pj-list\">";
if (pl.Count > 0)
{
xing = int.Parse(pl[0].pavg.ToString()) * 68 / 5;
}
foreach (var item in ViewBag.pinlun)
{
var fen = item.pa_Satisfied;
var width = fen * 1 * 68 / 5;
html += "<li><div class=\"head-img\"><dl><dt><img name=\"page_cnt_1\" _src=\"" + item.member.m_HeadImg + "\" alt=\"会员头像\" /></dt><dd>" + item.member.m_UserName + "</dd></dl></div><div class=\"borders vip-pj\"><div class=\"dashed-div\"><div class=\"pj-star alignleft\"><span><em class=\"showstart\" value=\""+item.pa_Satisfied+"\" style=\"width:"+width+"px\"></em></span></div><div class=\"say-time alignright\">" + item.pa_CreatedOn + "</div><div class=\"clear\"></div></div><!--dashed-div end--><div class=\"dashed-div\"><div class=\"pj-font\">评价：</div><div class=\"pj-fonts\"><p>" + item.pa_Content + "</p></div></div><!--dashed-div end--><div class=\"button-pointer\"><div class=\"hands\"></div><span value=\"@item.pa_ID\">赞（<i>" + item.pa_PraiseCount + "</i>）</span></div></div></li>";
}
html += " </ul>";
return html;
}
//提交 评论type=pinglun/ 咨询type=zixun
public string Tijiao()
{
string message = "";
string type = "";
string content = "";
int skuid = 0;
string radio = "0";
int result = 0;
HttpCookie user = Request.Cookies["UserInfo"];
int mid = 0;
string name = user.Value;
if (LoginMember != null)//如果已登陆
{
mid = (CookieEncrypt.DeserializeObject(System.Web.HttpContext.Current.Request.Cookies["UserInfo"].Value) as Model.MemberBase).m_ID;
if (!string.IsNullOrEmpty(RequestBase.GetString("type")))
{
type = RequestBase.GetString("type").ToString();
}
if (!string.IsNullOrEmpty(RequestBase.GetString("content")))
{
content = RequestBase.GetString("content").ToString();
}
if (!string.IsNullOrEmpty(RequestBase.GetString("skuid")))
{
skuid = Convert.ToInt32(RequestBase.GetString("skuid"));
}
if (!string.IsNullOrEmpty(RequestBase.GetString("radio")))
{
radio = RequestBase.GetString("radio").ToString();
}
if (content == "")
{
return "请输入200个以内的字符";
}
if (type == "zixun")
{
Model.ProductConsultBase pcmodel = new ProductConsultBase();
pcmodel.pc_Content = content;
pcmodel.pc_CreatedOn = DateTime.Now;
pcmodel.pc_CreatedBy = mid;//用户ID
pcmodel.sku_ID = skuid;
pcmodel.pc_huifu = 0;
if (radio == "1")
pcmodel.pc_Type = "商品提问";
if (radio == "2")
pcmodel.pc_Type = "促销活动提问";
if (radio == "3")
pcmodel.pc_Type = "库存及物流提问";
if (radio == "4")
pcmodel.pc_Type = "售后提问";
if (radio == "undefined")
return "请选择提问类别";
result = new BLL.ProductConsultBase().Add(pcmodel);
}
else if (type == "pinglun")
{
Model.ProductAppraiseBase pamodel = new ProductAppraiseBase();
pamodel.pa_Content = content;
pamodel.pa_CreatedOn = DateTime.Now;
pamodel.pa_CreatedBy = mid;
pamodel.m_ID = mid;
pamodel.sku_ID = skuid;
if (radio == "0")
return "请给商品评分";
else
{
pamodel.pa_Satisfied = int.Parse(radio);//满意度
}
result = new BLL.ProductAppraiseBase().Add(pamodel);
}
if (result > 0)
{
return "提交成功";
}
else
{
message = "提交失败，请稍后重试";
}
return message;
}
else
{
return "不登陆没有发言权";
}
}
public ActionResult ProPinglun()
{
int pinglunpageSize = 2;//每一页的行数
int pinglunpageNumber = 1;//当前页数
//评论
model.pinglun = new BLL.ProductAppraiseBase().GetModelListByskuId(" sku_ID=" + int.Parse(skuid) + "and pa_StatusCode=0 and pa_IsDel=0 order by pa_CreatedOn desc");
model.vmpinfolist = new BLL.vw_PInfo().GetModelList(" p_IsDel=0 and p_StatusCode=0 and p_SellStatus=1 and sku_ID= " + int.Parse(skuid));//商品信息
ViewBag.vmpinfolist = model.vmpinfolist[0];
if (model.pinglun.Count > 0)
{
ViewData["midcount"] = model.pinglun[0].member.midcount;
ViewData["pinglunscore"] = model.pinglun[0].pavg;
ViewData["tiao"] = int.Parse(model.pinglun[0].pavg.ToString()) * 20;//显示满意度的箭头所指的地方
ViewData["xing"] = int.Parse(model.pinglun[0].pavg.ToString()) * 68 / 5;//显示满意度的箭头所指的地方
}
else
{
ViewData["midcount"] = "0";
ViewData["pinglunscore"] = "0";
}
if (LoginMember != null)
{ ViewData["logon"] = true; }
else
{ ViewData["logon"] = false; }
var pl = new BLL.ProductAppraiseBase().GetModelListByskuId(" sku_ID=" + int.Parse(skuid)+" and pa_IsDel=0 and pa_StatusCode=0 order by pa_CreatedOn desc");
ViewBag.pinlun = pl.ToPagedList(pinglunpageNumber, pinglunpageSize);
ViewData["pingluncount"] = model.pinglun.Count;
ViewData["pagerows"] = pinglunpageSize;
ViewData["page"] = pinglunpageNumber;
var pinglunshuoming = _newsBase.GetModelList(" n_Title='商品评论说明' and n_StatusCode=0 and n_IsDel=0");
if (pinglunshuoming != null && pinglunshuoming.Any())
{
ViewBag.pinglunshuoming = pinglunshuoming[0].n_Content;
}
else
{
ViewBag.pinglunshuoming = "暂无商品评论说明";
}
return View(ViewBag.pinlun);
}
