/// <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);
}
}
