学步园

 

一、RettingSetting类

using System;
using System.Collections.Generic;
using System.Text;
/// <summary>
    /// 计算投票评均值
    /// </summary>
    public class RetingSettings
    {
        
        private bool _showHalfImage = false;//是否显示有小数部分
        private double _roundValue;//平均值的整数部分
        private int _imageHalfnum; //根据值显示图片
        /// <summary>
        /// 
        /// </summary>
        /// <param name="totalScore">总分数</param>
        /// <param name="evaluationnum">评价人数</param>
        /// <param name="num"></param>
        public RetingSettings(int totalScore, int evaluationnum)
        {
            double _average = (double)totalScore /(double)evaluationnum;//平均值
            _roundValue  = Math.Truncate(_average);
            int remainder = (int)((_average - _roundValue) * 10);//平均值的小数部分
           
                if(remainder>0 &&remainder<3)
                {
                    _showHalfImage = true;
                    _imageHalfnum = 1;
                }else if(  remainder>=3 && remainder<7)
                {
                    _showHalfImage = true;
                    _imageHalfnum = 2;
                }else if(remainder>=7 && remainder<=9)
                {    
                    _showHalfImage = true;
                    _imageHalfnum = 3;
                }
                else if (remainder == 0)
                {
                    _imageHalfnum = 0;
                }
            }

        /// <summary>
        /// 平均值的整数部分
        /// </summary>
        public int RroundValue
        {
            get { return (int)_roundValue; }
        }
        /// <summary>
        /// 是否有小数部分
        /// </summary>
        public bool ShowHalfImage
        {
            get { return _showHalfImage; }
        }
        /// <summary>
        /// 根据值显示图片
        /// </summary>
        public int ImageHalfnum
        {
            get { return _imageHalfnum; }
        }
    }
二、根据评论分数显示图片
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;
using System.Text;
using System.Data.SqlClient;
/// <summary>
/// px 的摘要说明
/// </summary>
public class px
{
public px()
{
  //
  // TODO: 在此处添加构造函数逻辑
  //
    }
    #region 属性
    private int _dp_id;
    private string _dp_yj;
    private int _use_id;
    private int _shop_id;
    private int _fw;
    private int _kw;
    private int _hj;
    private int _xjb;
    private DateTime _dp_datetime;
    private string _dp_ip;
    /// <summary>
    /// 
    /// </summary>
    public int dp_id
    {
        set { _dp_id = value; }
        get { return _dp_id; }
    }
    /// <summary>
    /// 点评意见
    /// </summary>
    public string dp_yj
    {
        set { _dp_yj = value; }
        get { return _dp_yj; }
    }
    /// <summary>
    /// 
    /// </summary>
    public int use_id
    {
        set { _use_id = value; }
        get { return _use_id; }
    }
    /// <summary>
    /// 
    /// </summary>
    public int shop_id
    {
        set { _shop_id = value; }
        get { return _shop_id; }
    }
    /// <summary>
    /// 服务
    /// </summary>
    public int fw
    {
        set { _fw = value; }
        get { return _fw; }
    }
    /// <summary>
    /// 口味
    /// </summary>
    public int kw
    {
        set { _kw = value; }
        get { return _kw; }
    }
    /// <summary>
    /// 环境
    /// </summary>
    public int hj
    {
        set { _hj = value; }
        get { return _hj; }
    }
    /// <summary>
    /// 性价比
    /// </summary>
    public int xjb
    {
        set { _xjb = value; }
        get { return _xjb; }
    }
    /// <summary>
    /// 
    /// </summary>
    public DateTime dp_datetime
    {
        set { _dp_datetime = value; }
        get { return _dp_datetime; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string dp_ip
    {
        set { _dp_ip = value; }
        get { return _dp_ip; }
    }
    #endregion
    public static int attachnum = 0;//表示参与点评的人数
    public static ArrayList fimgList = null;
    public static Image image=null;//图片档案
    public static Image fimage=null;
    public static int _starnum = 5;//默认设置5颗星
    public static void Fimgbuding(string shop_id,string columnname)
    {
        int starno;
        int fullstar = 0;
        int halfstarnum = 0;
        bool HalfImage = false;//是否有半星

        attachnum = Convert.ToInt32(DataHelpe.ExecuteScalar("select dp_count from v_店铺详细统计信息 where shop_id='" + shop_id + "'").ToString());
        RetingSettings se = new RetingSettings(Convert.ToInt32(DataHelpe.ExecuteScalar("select " + columnname + " from v_店铺详细统计信息 where shop_id='" + shop_id + "'").ToString()), attachnum);
        //if (se.ShowHalfImage)//是否有半星图片
        //{
        halfstarnum = se.ImageHalfnum;
        fullstar = se.RroundValue;
        HalfImage = se.ShowHalfImage;
        fimgList = new System.Collections.ArrayList();

        for (int j = 1; j <= fullstar; j++)
        {
            fimage = new Image();
            fimage.ID = "ss_starfull" + j.ToString();
            fimage.ImageUrl = "../px/v2_gx_hxx1.gif";
            fimgList.Add(fimage);
        }
        if (HalfImage)
        {
            fimage = new Image();
            fimage.ID = "ss_starhalf";
            fimage.ImageUrl = "../px/v2_gx_hxx3n" + halfstarnum.ToString() + ".gif";
            fimgList.Add(fimage);
        }
        if (HalfImage)
            starno = _starnum - fullstar - 1;
        else
            starno = _starnum - fullstar;
        for (int i = 1; i <= starno; i++)
        {
            fimage = new Image();
            fimage.ID = "ss_starno" + i.ToString();
            fimage.ImageUrl = "../px/v2_gx_hxx2.gif";
            fimgList.Add(fimage);
        }
    }
    public static string result(string shop_id,string column)
    {
        px.Fimgbuding(shop_id,column);
        ArrayList al = px.fimgList;
        string img = "";
        for (int i = 0; i < al.Count; i++)
        {
            //'<%=  ((Image)al).ImageUrl%>' style="width:12px;height:14px;" />
            //  <%
            Image img1 = (Image)al;
            img += "<img src="+img1.ImageUrl+" style='width:14px;height:15px;' />";
        }
        return img;
    }
    //返回商家总的点评数
    public static string dp_count(string shop_id)
    {
        return DataHelpe.ExecuteScalar("select dp_count from v_店铺详细统计信息 where shop_id='" + shop_id + "'").ToString();
    }
    //插入评论信息
    
    public int Add(px p)
    {
        StringBuilder strSql = new StringBuilder();
        strSql.Append("insert into 点评表(");
        strSql.Append("dp_yj,use_id,shop_id,fw,kw,hj,xjb,dp_datetime,dp_ip)");
        strSql.Append(" values (");
        strSql.Append("@dp_yj,@use_id,@shop_id,@fw,@kw,@hj,@xjb,@dp_datetime,@dp_ip)");       
        SqlParameter[] parameters = {
     new SqlParameter("@dp_yj", SqlDbType.VarChar,1000),
     new SqlParameter("@use_id", SqlDbType.Int,4),
     new SqlParameter("@shop_id", SqlDbType.Int,4),
     new SqlParameter("@fw", SqlDbType.Int,4),
     new SqlParameter("@kw", SqlDbType.Int,4),
     new SqlParameter("@hj", SqlDbType.Int,4),
     new SqlParameter("@xjb", SqlDbType.Int,4),
     new SqlParameter("@dp_datetime", SqlDbType.DateTime),
     new SqlParameter("@dp_ip", SqlDbType.VarChar,50)};
        parameters[0].Value = p.dp_yj;
        parameters[1].Value = p.use_id;
        parameters[2].Value = p.shop_id;
        parameters[3].Value = p.fw;
        parameters[4].Value = p.kw;
        parameters[5].Value = p.hj;
        parameters[6].Value = p.xjb;
        parameters[7].Value = p.dp_datetime;
        parameters[8].Value = p.dp_ip;
        return DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);    
    }
    //返回用户的评论信息
    public static void Fimgbuding_use(string columnname,string dp_id)
    {
        int starno;
        int fullstar = 0;
        int halfstarnum = 0;
        bool HalfImage = false;//是否有半星

        attachnum = 1;
        RetingSettings se = new RetingSettings(Convert.ToInt32(DataHelpe.ExecuteScalar("select " + columnname + " from 点评表 where dp_id='" + dp_id + "'")), attachnum);
        //if (se.ShowHalfImage)//是否有半星图片
        //{
        halfstarnum = se.ImageHalfnum;
        fullstar = se.RroundValue;
        HalfImage = se.ShowHalfImage;
        fimgList = new System.Collections.ArrayList();

        for (int j = 1; j <= fullstar; j++)
        {
            fimage = new Image();
            fimage.ID = "ss_starfull" + j.ToString();
            fimage.ImageUrl = "../px/v2_gx_hxx1.gif";
            fimgList.Add(fimage);
        }
        if (HalfImage)
        {
            fimage = new Image();
            fimage.ID = "ss_starhalf";
            fimage.ImageUrl = "../px/v2_gx_hxx3n" + halfstarnum.ToString() + ".gif";
            fimgList.Add(fimage);
        }
        if (HalfImage)
            starno = _starnum - fullstar - 1;
        else
            starno = _starnum - fullstar;
        for (int i = 1; i <= starno; i++)
        {
            fimage = new Image();
            fimage.ID = "ss_starno" + i.ToString();
            fimage.ImageUrl = "../px/v2_gx_hxx2.gif";
            fimgList.Add(fimage);
        }
    }
    public static string result_use(string column,string dp_id)
    {
        px.Fimgbuding_use(column,dp_id);
        ArrayList al = px.fimgList;
        string img = "";
        for (int i = 0; i < al.Count; i++)
        {
            //'<%=  ((Image)al).ImageUrl%>' style="width:12px;height:14px;" />
            //  <%
            Image img1 = (Image)al;
            img += "<img src=" + img1.ImageUrl + " style='width:12px;height:14px;'/>";
        }
        return img;
    }
    
}