public static List <ShangjiaData> QueryShangjia(decimal lng_orig, decimal lat_orig, decimal lng_s, decimal lat_s)
{
MapData md = QueryFromOrig(1, lng_orig, lat_orig, lng_s, lat_s);
string sql = string.Format("select * from {0} where code={1}", SHANGJIA_DATA, md.code);
DataSet ds = MySqlHelper.GetDataSet(sql);
DataTable dt = ds.Tables[0];
List <ShangjiaData> list = new List <ShangjiaData>();
foreach (DataRow dr in dt.Rows)
{
ShangjiaData bd = new ShangjiaData()
{
code = (int)dr["code"],
name = dr["name"].ToString(),
id = (int)dr["id"],
lat = (Decimal)dr["lat"],
lng = (Decimal)dr["lng"]
};
list.Add(bd);
}
return(list);
}
public static List <ShangjiaData> QueryShangjiaAll()
{
string sql = string.Format("select distinct name from {0}", SHANGJIA_DATA);
DataSet ds = MySqlHelper.GetDataSet(sql);
DataTable dt = ds.Tables[0];
List <ShangjiaData> list = new List <ShangjiaData>();
foreach (DataRow dr in dt.Rows)
{
ShangjiaData bd = new ShangjiaData()
{
name = dr["name"].ToString()
};
list.Add(bd);
}
return(list);
}
public static List <ShangjiaData> QueryShangjiaByName(string name, int type)
{
string sql = string.Format("select * from {0} where name='{1}' and type={2} order by id desc", SHANGJIA_DATA, name, type);
DataSet ds = MySqlHelper.GetDataSet(sql);
DataTable dt = ds.Tables[0];
List <ShangjiaData> list = new List <ShangjiaData>();
foreach (DataRow dr in dt.Rows)
{
ShangjiaData bd = new ShangjiaData()
{
code = (int)dr["code"],
name = dr["name"].ToString(),
id = (int)dr["id"],
lat = (Decimal)dr["lat"],
lng = (Decimal)dr["lng"]
};
list.Add(bd);
}
return(list);
}
