//反填
public JiaoYu FanJiaoYu(int Id)
{
string sql = $"select * from JiaoYu where JYid={Id}";
var dt = DBHelper.ExecuteQuery(sql, System.Data.CommandType.Text);
string str = JsonConvert.SerializeObject(dt);
JiaoYu j = JsonConvert.DeserializeObject <List <JiaoYu> >(str).FirstOrDefault();
return(j);
}
//修改教育信息
public int NewsUpd(JiaoYu j)
{
string sql = $"update JiaoYu set JYlei='{j.JYlei}',JYTitle='{j.JYTitle}',JYmiao='{j.JYmiao}',JYFaBuRiQi='{j.JYFaBuRiQi}',JYimg='{j.JYimg}',JYShiPin='{j.JYShiPin}',JYnei='{j.JYnei}'.JYjLY='{j.JYjLY}',JYurl='{j.JYurl}' where JYid={j.JYid}";
return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text));
}
//添加教育信息
public int JiaoYuAdd(JiaoYu j)
{
string sql = $"insert into JiaoYu(JYlei,JYTitle,JYmiao,JYFaBuRiQi,JYimg,JYShiPin,JYnei,JYjLY,JYurl) values('{j.JYlei}','{j.JYTitle}','{j.JYmiao}','{j.JYFaBuRiQi}','{j.JYimg}','{j.JYShiPin}','{j.JYnei}'.'{j.JYjLY}','{j.JYurl}')";
return(DBHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text));
}
