/// <summary>
/// 验证验证码是否正确
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public ValidInfo VerificationCodeValid(CodeInfo code)
{
ValidInfo valid = new ValidInfo();
try
{
List <SqlParameter> sqllist = new List <SqlParameter>();
sqllist.Add(new SqlParameter {
ParameterName = "@phone", SqlDbType = SqlDbType.VarChar, Value = code.phone
});
sqllist.Add(new SqlParameter {
ParameterName = "@code", SqlDbType = SqlDbType.VarChar, Value = code.code
});
sqllist.Add(new SqlParameter {
ParameterName = "@codetype", SqlDbType = SqlDbType.Int, Value = code.codetype
});
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
});
EPData ep = new EPData();
SqlCommand cmd = ep.CallProcCommon("cp_EqualVerificationCode", 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);
}
/// <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);
}
