private void dataSouceBind()
{
tb_Video video = new tb_Video();
video = vb.selOneVideo(Convert.ToInt32(Request.Params["VideoID"]));
VUrl = video.VideoUrl;
lblClickSum.Text = video.ClickSum.ToString();
lblFBDate.Text = video.FBDate.ToString();
lblName.Text = video.Name;
lblVideoName.Text = video.VideoName;
txtContent.Text = video.VideoContent;
}
public tb_Video selOneVideo(int VideoID)
{
tb_Video video = new tb_Video();
string sel = "select VideoID,VideoName,FBDate,ClickSum,Name,VideoUrl,VideoContent from tb_Video where VideoID=@VideoID";
ArrayList list = sqlDal.sqlOnesDr(sel,
new string[] { "@VideoID" },
new string[] { VideoID.ToString() });
video.VideoID = (int)list[0];
video.VideoName = list[1].ToString();
video.FBDate = (DateTime)list[2];
video.ClickSum = (int)list[3];
video.Name = list[4].ToString();
video.VideoUrl = list[5].ToString();
video.VideoContent = list[6].ToString();
return video;
}
protected void btnIssuanced_Click(object sender, EventArgs e)
{
try
{
if (ddlType.SelectedIndex == 0)
{
Response.Write("<script>alert('请选择课程类型')</script>");
}
else
{
string fileName = FileUpload1.FileName;
string newFileName = Guid.NewGuid().ToString() + fileName.Substring(fileName.LastIndexOf("."));
if (rdoVideo.Checked == true)
{
string filePath = Server.MapPath("./video/");
FileUpload1.SaveAs(filePath + newFileName);
tb_Video video = new tb_Video();
video.VideoContent = txtContainer.Text;
video.VideoName = txtTitle.Text;
video.VideoUrl = filePath + newFileName;
video.Name = Session["UserName"].ToString();
video.VideoType = Convert.ToInt32(ddlType.SelectedIndex);
vb.addVideo(video);
}
else
{
string filePath = Server.MapPath("./sound/");
FileUpload1.SaveAs(filePath + newFileName);
tb_Sound sound = new tb_Sound();
sound.SoundContent = txtContainer.Text;
sound.SoundName = txtTitle.Text;
sound.SoundUrl = filePath + newFileName;
sound.Name = Session["UserName"].ToString();
sound.SoundType = Convert.ToInt32(ddlType.SelectedIndex);
sb.addSound(sound);
}
Response.Write("<script>alert('上传成功')</script>");
Response.AddHeader("Refresh", "0");
}
}
catch (Exception ee)
{
Response.Write(ee.Message);
throw;
}
}
private void dataSouceBind()
{
if (Request.Params["TutorialType"] == "Sound")
{
tb_Sound sound = new tb_Sound();
int SoundID = Convert.ToInt32(Request.Params["TutorialID"]);
soundb.AddClickNum(SoundID);
sound = soundb.selOneSound(SoundID);
Url = sound.SoundUrl;
lblClickSum.Text = sound.ClickSum.ToString();
lblFBDate.Text = sound.FBDate.ToString();
lblName.Text = sound.Name;
lblTutorialName.Text = sound.SoundName;
txtContainer.Text = sound.SoundContent;
}
else
{
tb_Video video = new tb_Video();
int VideoID = Convert.ToInt32(Request.Params["TutorialID"]);
videob.AddClickNum(VideoID);
video = videob.selOneVideo(VideoID);
Url = video.VideoUrl;
lblClickSum.Text = video.ClickSum.ToString();
lblFBDate.Text = video.FBDate.ToString();
lblName.Text = video.Name;
lblTutorialName.Text = video.VideoName;
txtContainer.Text = video.VideoContent;
}
}
public List<tb_Video> selSearchVideo(string VideoType, string SearchKey, string pageIndex, string pageSize)
{
tb_Video video = null;
List<ArrayList> list = sqlDal.sqlProcDr("GETTUTORIALTABLEPAGE",
new string[] { "@TABLENAME", "@TutorialID", "@SearchKey", "@pageIndex", "@pageSize" },
new string[] { "Video", VideoType, SearchKey, pageIndex, pageSize });
List<tb_Video> videoList = new List<tb_Video>();
foreach (ArrayList obj in list)
{
video = new tb_Video();
video.VideoID = (int)obj[0];
video.VideoName = obj[1].ToString();
video.FBDate = (DateTime)obj[2];
video.Name = obj[3].ToString();
videoList.Add(video);
}
return videoList;
}
public DataSet selNewVideo()
{
tb_Video video = new tb_Video();
string sel = "select top 10 VideoID,VideoName,TypeName,FBDate from tb_Video,tb_Type where VideoType=TypeID order by FBDate desc";
return sqlDal.sqlDs(sel, null, null);
}
public int addVideo(tb_Video video)
{
return sqlDal.sqlUpdate("insert into tb_Video(VideoType,VideoName,VideoUrl,Name,VideoContent) values(@VideoType,@VideoName,@VideoUrl,@Name,@VideoContent)",
new string[] { "@VideoType", "@VideoName", "@VideoUrl", "@Name", "@VideoContent" },
new string[] { video.VideoType.ToString(), video.VideoName, video.VideoUrl, video.Name,video.VideoContent });
}
public List<tb_Video> selVideo()
{
tb_Video video = null;
string sel = "select VideoID,VideoName,FBDate from tb_Video";
List<ArrayList> list = sqlDal.sqlDr(sel, null, null);
List<tb_Video> videoList = new List<tb_Video>();
foreach (ArrayList obj in list)
{
video = new tb_Video();
video.VideoID = (int)obj[0];
video.VideoName = obj[1].ToString();
video.FBDate = (DateTime)obj[2];
videoList.Add(video);
}
return videoList;
}
public DataSet selTopVideo()
{
tb_Video video = new tb_Video();
string sel = "select top 5 VideoID,VideoName,TypeName,ClickSum from tb_Video,tb_Type where VideoType=TypeID order by ClickSum desc";
return sqlDal.sqlDs(sel, null, null);
}
public int addVideo(tb_Video video)
{
return vd.addVideo(video);
}