基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Play : Page
{
    public string Name;
    public string flower;
    public string playSum;
    public string tile;
    public string videoContent;
    public string videoDate;
    public string videoTitle;
    public string videoType;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["UserName"] == null)
            {
                PanelLogin.Visible = true;
                PanelHello.Visible = false;
            }
            else
            {
                PanelLogin.Visible = false;
                PanelHello.Visible = true;
                lbeUserName.Text = Session["UserName"].ToString();
            }
            AddPlaySum();
        }

        VideoInfo();
        BindComment();
    }

    // 播放视频并显示视频详细信息
    private void VideoInfo()
    {
        string strSql = "SELECT * FROM VideoInfo WHERE id="   Request["ID"];
        SqlDataReader reader = OperateData.GetSqlDataReader(strSql);
        reader.Read();
        string link = reader["videoPath"].ToString();
        playSum = reader["playSum"].ToString();
        flower = reader["flower"].ToString();
        tile = reader["tile"].ToString();
        videoDate = reader["videoDate"].ToString();
        Name = reader["userName"].ToString();
        videoTitle = reader["videoTitle"].ToString();
        videoContent = reader["videoContent"].ToString();
        videoType = reader["videoType"].ToString();

        // 判断视频路径开头字符串是否为http://
        if (!link.StartsWith("http://"))
        {
            string sss = Request.Url.AbsoluteUri;
            int idx = sss.IndexOf("Play.aspx");
            sss = sss.Substring(0, idx);
            link = sss   link;
        }

        // 显示播放器并可以播放视频
        Literal1.Text = OperateMethod.ShowFlash(link);
    }

    // 查看留言
    private void BindComment()
    {
        string strSql = "SELECT * FROM VideoIdea WHERE videoId="   Request["ID"]   " ORDER BY issuanceDate DESC";
        DataTable table = OperateData.GetDataTable(strSql);
        if (table.Rows.Count < 5)
        {
            PanelIdea.ScrollBars = ScrollBars.None;
        }
        dlIdea.DataSource = table;
        dlIdea.DataKeyField = "id";
        dlIdea.DataBind();
    }

    // 增加点击率和用户积分
    private void AddPlaySum()
    {
        string strSql = "UPDATE VideoInfo SET playSum = playSum   1, monthSum = monthSum   1 WHERE id="   Request["ID"];
        OperateData.ExecuteSQL(strSql);
        string strSelect = "SELECT userName FROM VideoInfo WHERE id="   Request["ID"];
        string userName = OperateData.GetValue(strSelect);
        string strUpdate = "UPDATE UserInfo SET sumMark = sumMark   1 WHERE userName='"   userName   "'";
        OperateData.ExecuteSQL(strUpdate);
    }

    // 返回发布的时间
    public string GetIsDate(string date)
    {
        DateTime isDate = Convert.ToDateTime(date);
        DateTime nowDate = DateTime.Now;
        TimeSpan timeSpan = nowDate - isDate;
        int second = Convert.ToInt32(timeSpan.TotalSeconds)/60;

        if (second == 0)
        {
            return "60秒内";
        }
        else if (second < 60)
        {
            return second.ToString()   "分钟前";
        }
        else if (second > 60 && second < 1440)
        {
            return Convert.ToString(second/60)   "小时前";
        }
        else
        {
            return date;
        }
    }

    protected void btnIdea_Click(object sender, EventArgs e)
    {
        if (txtContent.Text != "")
        {
            string userName;
            if (Session["UserName"] != null)
            {
                userName = Session["UserName"].ToString();
            }
            else
            {
                userName = "游客";
            }

            string videoId = Request["ID"];
            string content = OperateMethod.FiltrateHTML(txtContent.Text);
            string date = DateTime.Now.ToString();

            string strInsert = "INSERT INTO VideoIdea VALUES ('"   userName   "','"   content   "','"   videoId   "','"  
                               date   "')";
            if (OperateData.ExecuteSQL(strInsert))
            {
                RegisterStartupScript("true", "<script>alert('评论成功！')</script>");
                txtContent.Text = "";
                BindComment();
            }
            else
            {
                RegisterStartupScript("false", "<script>alert('评论失败！')</script>");
            }
        }
        else
        {
            RegisterStartupScript("false", "<script>alert('评论内容不许为空')</script>");
        }
    }

    // 将视频ID和用户IP保存到数据库中防止重复投票
    protected void AddPoll(string sqlUpd, string videoId)
    {
        string userIP = Request.UserHostAddress;

        string strSql = "SELECT * FROM VideoPoll WHERE ip='"   userIP   "' AND videoId='"   videoId   "'";
        if (!(OperateData.GetCount(strSql) > 0))
        {
            OperateData.ExecuteSQL(sqlUpd);
            string strInsert = "INSERT VideoPoll VALUES ('"   userIP   "',"   videoId   ")";
            OperateData.ExecuteSQL(strInsert);
            RegisterStartupScript("", "<script>alert('成功！')</script>");
        }
        else
        {
            RegisterStartupScript("", "<script>alert('一个视频只可以投一次')</script>");
        }
    }

    protected void imgbtnD_Click(object sender, ImageClickEventArgs e)
    {
        string strSql = "UPDATE VideoInfo SET flower = flower   1 WHERE id="   Request["ID"];
        AddPoll(strSql, Request["ID"]);
        VideoInfo();
    }

    protected void imgbtnC_Click(object sender, ImageClickEventArgs e)
    {
        string strSql = "UPDATE VideoInfo SET tile = tile   1 WHERE id="   Request["ID"];
        AddPoll(strSql, Request["id"]);
        VideoInfo();
    }
}