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