//反填
public SanHui FanSanHui(int Id)
{
string sql = $"select * from SanHui where Shid={Id}";
var dt = DBHelper.ExecuteQuery(sql, System.Data.CommandType.Text);
string str = JsonConvert.SerializeObject(dt);
SanHui s = JsonConvert.DeserializeObject <List <SanHui> >(str).FirstOrDefault();
return(s);
}
//修改三会一课信息
public int SanHuiUpd(SanHui s)
{
string sql = $"update SanHui set Shlei='{s.Shlei}',ShTitle='{s.ShTitle}',HuiYish='{s.HuiYish}',ShKtime='{s.ShKtime}',ShJtime='{s.ShJtime}',FuJian='{s.FuJian}',ShZt='{s.ShZt}' where Shid={s.Shid}";
return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text));
}
//添加三会一课信息
public int JiaoYuAdd(SanHui s)
{
string sql = $"insert into SanHui(Shlei,ShTitle,HuiYish,ShKtime,ShJtime,FuJian,ShZt) values('{s.Shlei}','{s.ShTitle}','{s.HuiYish}','{s.ShKtime}','{s.ShJtime}','{s.FuJian}','{s.ShZt}')";
return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text));
}
