public int UptLiveList(Model.Live live)
{
try
{
logger.Debug($"用户对直播列表进行修改,修改的ID为:{live.LiveId}");
int i = _liveRepository.UptDate(live);
return(i);
}
catch (Exception)
{
throw;
}
}
public int UptZt(int lid)
{
string sql = $"select * FROM live";
List <Model.Live> lv = DapperHelper.GetList <Model.Live>(sql);
Model.Live ll = lv.FirstOrDefault(x => x.LiveId.Equals(lid));
string sql1 = "";
if (ll.IsEnable == 0)
{
sql1 = $"UPDATE Live SET IsEnable=IsEnable+1 WHERE LiveId ={lid}";
}
else
{
sql1 = $"UPDATE Live SET IsEnable=IsEnable-1 WHERE LiveId ={lid}";
}
string sql2 = $"insert into Lognote values (NULL,'修改状态',NOW(),'Live直播表');";
DapperHelper.Execute(sql2);
return(DapperHelper.Execute(sql1));
}
