コード例 #1
0
 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;
 }
コード例 #2
0
        /// <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();
            }
        }
コード例 #3
0
 /// <summary>
 /// 获得商品评论(通过SKUID)
 /// </summary>
 public List<Model.ProductAppraiseBase> GetModelListByskuId(string strWhere)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("select pa.pa_ID,m.m_UserName,m.m_HeadImg,pa.pa_PraiseCount,pa.pa_CreatedOn,pa.pa_Content,pa_Satisfied,(select COUNT(m_Id) from MemberBase where m_ID  in(select m_id from ProductAppraiseBase)) midcount,(select AVG(pa_Satisfied) from ProductAppraiseBase) as pavg   from ProductAppraiseBase pa,MemberBase m where pa.m_ID=m.m_ID  and pa.pa_StatusCode=0 and pa.pa_IsDel=0  and ");
     if (strWhere.Trim() != "")
     {
         strSql.Append(strWhere);
     }
     DataSet ds = DbHelperSQL.Query(strSql.ToString());
     List<Model.ProductAppraiseBase> pinglun = new List<Model.ProductAppraiseBase>();
     foreach (DataRow r in ds.Tables[0].Rows)
     {
         Model.ProductAppraiseBase p = new Model.ProductAppraiseBase();
         p.pa_ID =int.Parse( r["pa_ID"].ToString());
         p.pa_PraiseCount = int.Parse(r["pa_PraiseCount"].ToString());
         p.pa_Content = r["pa_Content"].ToString();
         p.pa_CreatedOn = DateTime.Parse(r["pa_CreatedOn"].ToString());
         p.pa_Satisfied = int.Parse(r["pa_Satisfied"].ToString());
         p.pavg = int.Parse(r["pavg"].ToString());
         p.member = new Model.MemberBase
         {
             midcount=int.Parse(r["midcount"].ToString()),
             m_UserName = r["m_UserName"].ToString(),
             m_HeadImg = r["m_HeadImg"].ToString()
         };
         pinglun.Add(p);
     }
     return pinglun;
 }