//反填 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)); }