public bool Persistence2DB(ScenicEntity se)
{
String sql1 = string.Empty;
string sql2 = string.Empty;
//分解
if (!IfExistScenic(se.name))
{
sql1 = "insert into Scenic(Sname,Slevel,Saddress,Sarea,Stopic,Stopicseo,Strafficintro,Sbookintro,Sscenicdetail,Sscenicintro,Smainimg) " +
"values('" + se.name + "','" + se.level + "','" + se.address + "','" + se.areaid + "','" + se.topic
+ "','" + se.topicseo + "','" + se.trafficintro + "','" + se.bookintro + "','" + se.scenicdetail + "','" + se.scenicintro + "','" + se.mainimg + "')";
foreach (var item in se.ticketlist)
{
sql2 += "insert into TicketPrice values('" + item.scenicname + "','" + item.ticketname + "','" + item.orgprice + "','" + item.olprice + "');";
}
}
else
{
sql1 = "update Scenic set Sname='" + se.name + "',Slevel='" + se.level + "',Saddress='" + se.address
+ "',Sarea='" + se.areaid + "',Stopic='" + se.topic
+ "',Stopicseo='" + se.topicseo + "',Strafficintro='" + se.trafficintro + "',Sbookintro='"
+ se.bookintro + "',Sscenicdetail='" + se.scenicdetail + "',Sscenicintro='" + se.scenicintro + "', Smainimg='" + se.mainimg + "' "
+ " where Sname='" + se.name + "'";
sql2 += "delete from TicketPrice where Tscenic='" + se.name + "';";
foreach (var item in se.ticketlist)
{
sql2 += "insert into TicketPrice values('" + item.scenicname + "','" + item.ticketname + "','" + item.orgprice + "','" + item.olprice + "');";
}
}
return dbhelper.ExecSql(sql1) && dbhelper.ExecSql(sql2);
}
public bool Persistence2DB4topic(ScenicEntity se)
{
String sql1 = string.Empty;
sql1 = "update Scenic set Stopic='" + se.topic
+ "' where Sname='" + se.name + "'";
return dbhelper.ExecSql(sql1);
}
