/// <summary>
/// 修改视频
/// </summary>
/// <param name="Video">Video</param>
/// <returns></returns>
public bool ModfiyVideo(Tz888.Model.Video.VideoInfo Video)
{
string sql = "update VideoInfo set Title=@Title,ImgUrl=@ImgUrl,VideoUrl=@VideoUrl,VideoType=@VideoType,IsRecommend=@IsRecommend,ShowId=@ShowId,SortId=@SortId,Remarks=@Remarks,[Type]=@Type where Id=@Id";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.VarChar, 100),
new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200),
new SqlParameter("@VideoUrl", SqlDbType.VarChar, 200),
new SqlParameter("@VideoType", SqlDbType.Int, 4),
new SqlParameter("@IsRecommend", SqlDbType.Int, 4),
new SqlParameter("@ShowId", SqlDbType.Int, 4),
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 200),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
Paras[0].Value = Video.Title;
Paras[1].Value = Video.ImgUrl;
Paras[2].Value = Video.VodeoUrl;
Paras[3].Value = Video.VideoType;
Paras[4].Value = Video.IsRecommend;
Paras[5].Value = Video.ShowId;
Paras[6].Value = Video.SortId;
Paras[7].Value = Video.Remarks;
Paras[8].Value = Video.Type;
Paras[9].Value = Video.Id;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加视频
/// </summary>
/// <param name="Video">Video</param>
/// <returns></returns>
public bool AddVideo(Tz888.Model.Video.VideoInfo Video)
{
string sql = "insert into VideoInfo(Title,ImgUrl,VideoUrl,VideoType,IsRecommend,ShowId,SortId,Remarks,[Type]) " +
"values(@Title,@ImgUrl,@VideoUrl,@VideoType,@IsRecommend,@ShowId,@SortId,@Remarks,@Type)";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.VarChar, 100),
new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200),
new SqlParameter("@VideoUrl", SqlDbType.VarChar, 200),
new SqlParameter("@VideoType", SqlDbType.Int, 4),
new SqlParameter("@IsRecommend", SqlDbType.Int, 4),
new SqlParameter("@ShowId", SqlDbType.Int, 4),
new SqlParameter("@SortId", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 200),
new SqlParameter("@Type", SqlDbType.Int, 4)
};
Paras[0].Value = Video.Title;
Paras[1].Value = Video.ImgUrl;
Paras[2].Value = Video.VodeoUrl;
Paras[3].Value = Video.VideoType;
Paras[4].Value = Video.IsRecommend;
Paras[5].Value = Video.ShowId;
Paras[6].Value = Video.SortId;
Paras[7].Value = Video.Remarks;
Paras[8].Value = Video.Type;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
