protected void videoPlay()
{
videoInfoModel = videobll.getVideoInfo(id);
link = videoInfoModel.videoPath;
playSum = videoInfoModel.playSum;
videoTitle = videoInfoModel.videoTitle;
videoContent = videoInfoModel.videoContent;
videoDate = videoInfoModel.videoDate;
videoType = videoInfoModel.videoType;
userName = videoInfoModel.userName;
flower = videoInfoModel.Flower;
tile = videoInfoModel.Tile;
if (!link.StartsWith("http://"))
{
//获取当前的绝对路径
string sss = Request.Url.AbsoluteUri;
//查询"play.aspx"在字符串中的位置
int idx = sss.IndexOf("play.aspx");
//获取指定字符串
sss = sss.Substring(0, idx);
link = sss + link;
}
//显示播放器并可以播放视频
this.ltlPlay.Text = common.GetFlashText(link, 540, 405);
}
/// <summary>
/// 返回视频信息
/// </summary>
/// <param name="id">视频编号</param>
/// <returns></returns>
public DataTable getVideoInfo(string id)
{
VideoInfoModel videoInfoModel = new VideoInfoModel();
DataTable dt = new DataTable();
string cmdText = "select * from videoInfo where id=@id";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter ("@id", id)
};
dt = sqlhelper.getRow(cmdText, paras, CommandType.Text);
return dt;
}
private void doStore(string saveName)
{
VideoInfoModel vim = new VideoInfoModel();
UInfoModel uim = new UInfoModel();
vim.userName = uinfo.userName;
vim.videoTitle = this.txtVideoTitle.Value;
vim.videoContent = this.txtVideoContent.Value;
vim.videoPath = "../" + common.playFile + saveName + ".flv";
vim.videoPicture = "../" + common.imgFile + saveName + ".jpg";
vim.videoType = this.dropVideoType.SelectedValue.ToString();
if (userbll.insertVideo(vim))
{
uim.userName = uinfo.userName;
uim.sumMark = "10";//上传一个视频加10个积分;
userbll.addSumMark(uim);
string redirect = "message.aspx?cmd=upload&msgid=3&uid=" + uinfo.userName;
Page.Response.Redirect(redirect);
}
}
//插入视频信息到数据库
public bool insertVideo(VideoInfoModel vim)
{
return userDAL.insertVideo(vim);
}
//视频信息
public VideoInfoModel getVideoInfo(string id)
{
VideoInfoModel videoInfoModel = new VideoInfoModel();
dt = videodal.getVideoInfo(id);
videoInfoModel.Id = dt.DefaultView[0]["id"].ToString();
videoInfoModel.userName = dt.DefaultView[0]["userName"].ToString();
videoInfoModel.videoTitle = dt.DefaultView[0]["videoTitle"].ToString();
videoInfoModel.videoPath = dt.DefaultView[0]["videoPath"].ToString();
videoInfoModel.videoContent = dt.DefaultView[0]["videoContent"].ToString();
videoInfoModel.videoDate = dt.DefaultView[0]["videoDate"].ToString();
videoInfoModel.videoPicture = dt.DefaultView[0]["videoPicture"].ToString();
videoInfoModel.Flower = int.Parse(dt.DefaultView[0]["Flower"].ToString());
videoInfoModel.Tile = int.Parse(dt.DefaultView[0]["Tile"].ToString());
videoInfoModel.playSum = int.Parse(dt.DefaultView[0]["playSum"].ToString());
videoInfoModel.Auditing = dt.DefaultView[0]["Auditing"].ToString();
return videoInfoModel;
}
/// <summary>
/// 上传视频到服务器
/// </summary>
/// <param name="vi">视频实体参数</param>
/// <returns>返回真或假</returns>
public bool insertVideo(VideoInfoModel vInfo)
{
bool flag = false;
string cmdText = "insert into videoInfo(userName,videoTitle,videoContent,videoPath,videoPicture,videoType) values(@username,@videotitle,@videocontent,@videopath,@videopicture,@videotype)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter ("@username",vInfo.userName),
new SqlParameter ("@videotitle",vInfo.videoTitle),
new SqlParameter ("@videocontent",vInfo.videoContent),
new SqlParameter ("@videopath",vInfo.videoPath),
new SqlParameter ("@videopicture",vInfo.videoPicture),
new SqlParameter ("@videotype",vInfo.videoType)
};
int res = sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return flag;
}
