/// <summary> /// 更新视频 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdVideo(YouthVideo model) { StringBuilder str = new StringBuilder(); str.Append(" update video set "); str.Append(" video_title=@video_title,"); str.Append(" video_uper=@video_uper,"); str.Append(" video_up_time=@video_up_time,"); str.Append(" video_pic=@video_pic,"); str.Append(" video_link=@video_link "); str.Append(" where video_id=@video_id "); SqlParameter[] parameters = { new SqlParameter("@video_title", SqlDbType.NVarChar, 50), new SqlParameter("@video_uper", SqlDbType.NVarChar, 25), new SqlParameter("@video_up_time", SqlDbType.DateTime), new SqlParameter("@video_pic", SqlDbType.NVarChar, 50), new SqlParameter("@video_link", SqlDbType.NVarChar, 50), new SqlParameter("@video_id", SqlDbType.Int, 8) }; parameters[0].Value = model.Video_title; parameters[1].Value = model.Video_uper; parameters[2].Value = model.Video_up_time; parameters[3].Value = model.Video_pic; parameters[4].Value = model.Video_link; parameters[5].Value = model.Video_id; int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters); return(rows); }
/// <summary> /// 添加视频 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddVideo(YouthVideo model) { StringBuilder str = new StringBuilder(); str.Append(" insert into video "); str.Append("(video_title,video_uper,video_up_time,video_pic,video_link)"); str.Append(" values "); str.Append(" (@video_title,@video_uper,@video_up_time,@video_pic,@video_link) "); SqlParameter[] parameters = { new SqlParameter("@video_title", SqlDbType.NVarChar, 50), new SqlParameter("@video_uper", SqlDbType.NVarChar, 25), new SqlParameter("@video_up_time", SqlDbType.DateTime), new SqlParameter("@video_pic", SqlDbType.NVarChar, 50), new SqlParameter("@video_link", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Video_title; parameters[1].Value = model.Video_uper; parameters[2].Value = model.Video_up_time; parameters[3].Value = model.Video_pic; parameters[4].Value = model.Video_link; int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters); return(rows); }
protected void bindVideo() { int video_id = Convert.ToInt32(ViewState["video_id"].ToString()); model = bll.GetListById(video_id); videoTitle.Text = model.Video_title; videoUper.Text = model.Video_uper; videoLink.Text = model.Video_link; String pic = model.Video_pic; ViewState["pic"] = pic; }
/// <summary> /// 添加视频 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddVideo(YouthVideo model) { int rows = dal.AddVideo(model); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据id得到视频对象实体 /// </summary> /// <param name="video_id"></param> /// <returns></returns> public YouthVideo GetListById(int video_id) { YouthVideo model = new YouthVideo(); StringBuilder str = new StringBuilder(); str.Append(" select * from video "); str.Append(" where video_id=" + video_id); DataSet ds = DbHelperSQL.Query(str.ToString()); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["video_id"] != null) { model.Video_id = Convert.ToInt32(row["video_id"].ToString()); } if (row["video_title"] != null) { model.Video_title = row["video_title"].ToString(); } if (row["video_uper"] != null) { model.Video_uper = row["video_uper"].ToString(); } if (row["video_up_time"] != null) { model.Video_up_time = DateTime.Parse(row["video_up_time"].ToString()); } if (row["video_pic"] != null) { model.Video_pic = row["video_pic"].ToString(); } if (row["video_link"] != null) { model.Video_link = row["video_link"].ToString(); } return(model); } else { return(null); } }