private void get_xiaoqu(string xiaoquid)
{
xiaoquExist = false;
MysqlTOOLS mt = new MysqlTOOLS();
string sql = "SELECT area_name , area_city , area_province,xiaoquid,xiaoqu_name from area,xiaoqu WHERE xiaoqu_area_id = areaID\n" +
$"and xiaoquID = '{xiaoquid}'\n";
var rdr = mt.sqlToReader(sql);
while (rdr.Read())
{
xiaoquExist = true;
var tmpitem = new xiaoqu_item();
tmpitem.area.name = rdr[0].ToString();
tmpitem.area.city = rdr[1].ToString();
tmpitem.area.province = rdr[2].ToString();
tmpitem.id = rdr[3].ToString();
tmpitem.name = rdr[4].ToString();
theXiaoqu = tmpitem;
}
TextBox2.Text = theXiaoqu.name;
TextBox3.Text = theXiaoqu.area.province;
TextBox4.Text = theXiaoqu.area.city;
TextBox5.Text = theXiaoqu.area.name;
rdr.Close();
mt.closeconnection();
}
public string get(string xiaoqu_id,
string xiaoqu_name,
string province,
string city,
string qu)
{
MysqlTOOLS mt = new MysqlTOOLS();
string sql =
"SELECT area_name , area_city , area_province,xiaoquid,xiaoqu_name from area,xiaoqu WHERE xiaoqu_area_id = areaID\n" +
$"and xiaoquID like '{xiaoqu_id}%'\n" +
$"and xiaoqu_name like '%{xiaoqu_name}%'\n" +
$"and area_name like '%{qu}%'\n" +
$"and area_city like '%{city}%'\n" +
$"and area_province like '%{province}%'";
var rdr = mt.sqlToReader(sql);
while (rdr.Read())
{
// tmpitem,可是专门设计的类,也可以是有足够信息的实体类.
// 通过reader 获取信息
var tmpitem = new xiaoqu_item();
tmpitem.area.name = rdr[0].ToString();
tmpitem.area.city = rdr[1].ToString();
tmpitem.area.province = rdr[2].ToString();
tmpitem.id = rdr[3].ToString();
tmpitem.name = rdr[4].ToString();
xxxlist.AddLast(tmpitem);
}
rdr.Close();
mt.closeconnection();
string contentstr = "";
foreach (var item in xxxlist)
{
// 每一行表格的html代码
string addstr =
" <tr>\n" +
$" <td>{item.id}</td>\n" +
$" <td>{item.name}</td>\n" +
$" <td>{item.area.ToString()}</td>\n" +
" </tr>";
contentstr += addstr;
}
return(contentstr);
}
