public void AddMyCollectionVideosWatchCounts([FromBody] MyCollectionVideos json)
{
try
{
if (json.userid > 0 && json.id > 0)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"UPDATE EP_MyCollectionVideos SET WatchCounts = WatchCounts+1,MyWatchCounts =MyWatchCounts +1 WHERE UserId = {0} AND ID ={1};", json.userid, json.id);
EPData ep = new EPData();
ep.GetData(sb.ToString());
}
}
catch (Exception ex)
{
Log.WriteError(ex, "我的收藏视屏(AddMyCollectionVideosWatchCounts)");
}
}
public DataTable AddMyCollectionVideos([FromBody] MyCollectionVideos json)
{
DataTable dt = null;
try
{
if (json.userid > 0)
{
OperationData od = new common.OperationData();
ValidInfo valid = od.AddMyCollectionVideos(json);
dt = GetTable(valid.valid, valid.errmsg);
}
else
{
dt = GetTable("false", "参数错误");
}
}
catch (Exception ex)
{
dt = GetTable("false", ex.Message);
Log.WriteError(ex, "我的收藏视屏(AddMyCollectionVideos)");
}
return(dt);
}
/// <summary>
/// 添加视屏收藏
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public ValidInfo AddMyCollectionVideos(MyCollectionVideos video)
{
ValidInfo valid = new ValidInfo();
try
{
List <SqlParameter> sqllist = new List <SqlParameter>();
sqllist.Add(new SqlParameter {
ParameterName = "@userid", SqlDbType = SqlDbType.Int, Value = video.userid
});
sqllist.Add(new SqlParameter {
ParameterName = "@videoid", SqlDbType = SqlDbType.Int, Value = video.videoid
});
sqllist.Add(new SqlParameter {
ParameterName = "@videocategroyid", SqlDbType = SqlDbType.Int, Value = video.videocategroyid
});
sqllist.Add(new SqlParameter {
ParameterName = "@videocategroy", SqlDbType = SqlDbType.VarChar, Value = video.videocategroy
});
sqllist.Add(new SqlParameter {
ParameterName = "@videotitile", SqlDbType = SqlDbType.VarChar, Value = video.videotitile
});
sqllist.Add(new SqlParameter {
ParameterName = "@videodes", SqlDbType = SqlDbType.VarChar, Value = video.videodes
});
sqllist.Add(new SqlParameter {
ParameterName = "@videoimageurl", SqlDbType = SqlDbType.VarChar, Value = video.videoimageurl
});
sqllist.Add(new SqlParameter {
ParameterName = "@videoprice", SqlDbType = SqlDbType.Decimal, Value = video.videoprice
});
sqllist.Add(new SqlParameter {
ParameterName = "@videolecturerid", SqlDbType = SqlDbType.Int, Value = video.videolecturerid
});
sqllist.Add(new SqlParameter {
ParameterName = "@videolecturer", SqlDbType = SqlDbType.VarChar, Value = video.videolecturer
});
sqllist.Add(new SqlParameter {
ParameterName = "@issign", SqlDbType = SqlDbType.VarChar, Value = video.issign
});
sqllist.Add(new SqlParameter {
ParameterName = "@watchcounts", SqlDbType = SqlDbType.Int, Value = video.watchcounts
});
sqllist.Add(new SqlParameter {
ParameterName = "@mywatchcounts", SqlDbType = SqlDbType.Int, Value = video.mywatchcounts
});
sqllist.Add(new SqlParameter {
ParameterName = "@outvalid", SqlDbType = SqlDbType.Bit, Direction = ParameterDirection.Output
});
sqllist.Add(new SqlParameter {
ParameterName = "@outmsg", SqlDbType = SqlDbType.VarChar, Size = 100, Direction = ParameterDirection.Output
}); //错误提示：string[x]:size 属性具有无效大小值0 //解决方案： 输出参数需要明确指定长度
EPData ep = new EPData();
SqlCommand cmd = ep.CallProcCommon("cp_AddMyCollectionVideos", sqllist.ToArray());
string outvalid = cmd.Parameters["@outvalid"].Value == null ? "" : cmd.Parameters["@outvalid"].Value.ToString().ToLower();
string outmsg = cmd.Parameters["@outmsg"].Value == null ? "" : cmd.Parameters["@outmsg"].Value.ToString();
cmd.Parameters.Clear();
if (outvalid == "true" || outvalid == "True")
{
valid.valid = true;
valid.errmsg = "";
}
else
{
valid.valid = false;
valid.errmsg = outmsg;
}
}
catch (Exception ex)
{
throw ex;
}
return(valid);
}
