//反填 public TiKu FanTiKu(int Id) { string sql = $"select * from TiKu where TKid={Id}"; var dt = DBHelper.ExecuteQuery(sql, System.Data.CommandType.Text); string str = JsonConvert.SerializeObject(dt); TiKu t = JsonConvert.DeserializeObject <List <TiKu> >(str).FirstOrDefault(); return(t); }
//修改题库信息 public int TiKuUpd(TiKu t) { string sql = $"update TiKu set TKfenlei='{t.TKfenlei}',TKname='{t.TKname}',TKleixing='{t.TKleixing}',TKxuanxiang='{t.TKxuanxiang}',TKqita='{t.TKqita}',TKlaiyuan='{t.TKlaiyuan}',TKimg='{t.TKimg}',TKshipin='{t.TKshipin}',TKtime='{t.TKtime}' where TKid={t.TKid}"; return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text)); }
//添加题库信息 public int TiKuAdd(TiKu t) { string sql = $"insert into TiKu(TKfenlei,TKname,TKleixing,TKxuanxiang,TKqita,TKlaiyuan,TKimg,TKshipin,TKtime) values('{t.TKfenlei}','{t.TKname}','{t.TKleixing}','{t.TKxuanxiang}','{t.TKqita}','{t.TKlaiyuan}','{t.TKimg}','{t.TKshipin}','{t.TKtime}')"; return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text)); }