public List <CyberBar> GetAllWBs()
{
List <CyberBar> result = new List <CyberBar>();
try
{
using (OleDbConnection conn = new OleDbConnection(this.zzjgDBConnectBuilder.ConnectionString))
{
//String sql = "select WB_CODE, GAJG_KEY, WBMC, WBXZ, WBJD, WBWD, FZR_XM, FZR_SFZH, LXDH, WB_CODE_OLD from ZZJGXT.WB_INFO t ";
String sql = "SELECT YYCSDM,YYCS_DWMC,SSDS_XZQHDM,YYCS_DZMC,DLJD,DLWD,FZR_LXDH,DJDW_GAJGMC from B_ZTK_SP_WBYYCS WHERE DLJD is not null AND DLWD is not null";
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CyberBar info = new CyberBar();
//GPSID
if (!reader.IsDBNull(0))
{
info.Wb_code = reader[0].ToString();
}
//公安机构代码变成名称
if (!reader.IsDBNull(7))
{
info.Gajg_key = reader[7].ToString();
}
if (!reader.IsDBNull(1))
{
info.Wbmc = reader[1].ToString();
}
if (!reader.IsDBNull(3))
{
info.Wbxz = reader[3].ToString();
}
if (!reader.IsDBNull(4) && !reader.IsDBNull(5))
{
double x, y;
Double.TryParse(reader[4].ToString(), out x);
if (x > 0)
{
info.Wbjd = x;
}
Double.TryParse(reader[5].ToString(), out y);
if (y > 0)
{
info.Wbwd = y;
}
}
//if (!reader.IsDBNull(6))
//{
// info.Fzr_xm = reader[6].ToString();
//}
//if (!reader.IsDBNull(7))
//{
// info.Fzr_sfzh = reader[7].ToString();
//}
if (!reader.IsDBNull(6))
{
info.Lxdh = reader[6].ToString();
}
//if (!reader.IsDBNull(9))
//{
// info.Wb_code_old = reader[9].ToString();
//}
//if (info.Wbjd > 0 && info.Wbwd > 0)
//{
result.Add(info);
//}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 根据屏幕坐标范围获取所有网吧
/// </summary>
/// <param name="minX"></param>
/// <param name="minY"></param>
/// <param name="maxX"></param>
/// <param name="maxY"></param>
/// <returns></returns>
public List <CyberBar> GetAllWBsByExtent_backup(double minX, double minY, double maxX, double maxY)
{
List <CyberBar> result = new List <CyberBar>();
try
{
using (OleDbConnection conn = new OleDbConnection(this.zzjgDBConnectBuilder.ConnectionString))
{
String sql = "select WB_CODE, GAJG_KEY, WBMC, WBXZ, WBJD, WBWD, FZR_XM, FZR_SFZH, LXDH from ZZJGXT.WB_INFO t where WBJD IS NOT NULL and WBWD IS NOT NULL and WBJD >= ? and WBWD >= ? and WBJD <= ? and WBWD <= ?";
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add(new OleDbParameter("@minX", OleDbType.Double));
cmd.Parameters[0].Value = minX;
cmd.Parameters.Add(new OleDbParameter("@minY", OleDbType.Double));
cmd.Parameters[1].Value = minY;
cmd.Parameters.Add(new OleDbParameter("@maxX", OleDbType.Double));
cmd.Parameters[2].Value = maxX;
cmd.Parameters.Add(new OleDbParameter("@maxY", OleDbType.Double));
cmd.Parameters[3].Value = maxY;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CyberBar info = new CyberBar();
//GPSID
if (!reader.IsDBNull(0))
{
info.Wb_code = reader[0].ToString();
}
if (!reader.IsDBNull(1))
{
info.Gajg_key = reader[1].ToString();
}
if (!reader.IsDBNull(2))
{
info.Wbmc = reader[2].ToString();
}
if (!reader.IsDBNull(3))
{
info.Wbxz = reader[3].ToString();
}
if (!reader.IsDBNull(4) && !reader.IsDBNull(5))
{
double x, y;
Double.TryParse(reader[4].ToString(), out x);
if (x > 0)
{
info.Wbjd = x;
}
Double.TryParse(reader[5].ToString(), out y);
if (y > 0)
{
info.Wbwd = y;
}
}
if (!reader.IsDBNull(6))
{
info.Fzr_xm = reader[6].ToString();
}
if (!reader.IsDBNull(7))
{
info.Fzr_sfzh = reader[7].ToString();
}
if (!reader.IsDBNull(8))
{
info.Lxdh = reader[8].ToString();
}
if (info.Wbjd > 0 && info.Wbwd > 0)
{
result.Add(info);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 根据屏幕坐标范围获取所有网吧
/// </summary>
/// <param name="minX"></param>
/// <param name="minY"></param>
/// <param name="maxX"></param>
/// <param name="maxY"></param>
/// <returns></returns>
public List <CyberBar> GetAllWBsByExtent(double minX, double minY, double maxX, double maxY)
{
List <CyberBar> result = new List <CyberBar>();
try
{
using (OleDbConnection conn = new OleDbConnection(this.zzjgDBConnectBuilder.ConnectionString))
{
String sql = String.Format("select YYCSDM,YYCS_DWMC,SSDS_XZQHDM,YYCS_DZMC,DLJD,DLWD,FZR_LXDH,DJDW_GAJGMC from B_ZTK_SP_WBYYCS t where DLJD IS NOT NULL and DLWD IS NOT NULL AND DLWD>='{0}' AND DLWD<='{1}'", minY, maxY);
if (minX >= 100 || maxX < 100)
{
sql = String.Format("select YYCSDM,YYCS_DWMC,SSDS_XZQHDM,YYCS_DZMC,DLJD,DLWD,FZR_LXDH,DJDW_GAJGMC from B_ZTK_SP_WBYYCS t where DLJD IS NOT NULL and DLWD IS NOT NULL AND DLJD>='{0}' AND DLJD<='{1}' AND DLWD>='{2}' AND DLWD<='{3}'", minX, maxX, minY, maxY);
}
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CyberBar info = new CyberBar();
//GPSID
if (!reader.IsDBNull(0))
{
info.Wb_code = reader[0].ToString();
}
//公安机构代码变成名称
if (!reader.IsDBNull(7))
{
info.Gajg_key = reader[7].ToString();
}
if (!reader.IsDBNull(1))
{
info.Wbmc = reader[1].ToString();
}
if (!reader.IsDBNull(3))
{
info.Wbxz = reader[3].ToString();
}
if (!reader.IsDBNull(4) && !reader.IsDBNull(5))
{
double x, y;
Double.TryParse(reader[4].ToString(), out x);
if (x > 0)
{
info.Wbjd = x;
}
Double.TryParse(reader[5].ToString(), out y);
if (y > 0)
{
info.Wbwd = y;
}
}
//if (!reader.IsDBNull(6))
//{
// info.Fzr_xm = reader[6].ToString();
//}
//if (!reader.IsDBNull(7))
//{
// info.Fzr_sfzh = reader[7].ToString();
//}
if (!reader.IsDBNull(6))
{
info.Lxdh = reader[6].ToString();
}
//if (!reader.IsDBNull(9))
//{
// info.Wb_code_old = reader[9].ToString();
//}
if (info.Wbjd > 0 && info.Wbwd > 0 && info.Wbjd >= minX && info.Wbwd >= minY && info.Wbjd <= maxX && info.Wbwd <= maxY)
{
result.Add(info);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public List <CyberBar> FindCyberBarsBySearch(string exp)
{
List <CyberBar> result = new List <CyberBar>();
try
{
using (OleDbConnection conn = new OleDbConnection(this.zzjgDBConnectBuilder.ConnectionString))
{
String sql = "select YYCSDM,YYCS_DWMC,SSDS_XZQHDM,YYCS_DZMC,DLJD,DLWD,FZR_LXDH,DJDW_GAJGMC from B_ZTK_SP_WBYYCS t where YYCS_DWMC like '%'||?||'%'";
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add(new OleDbParameter("@exp1", OleDbType.VarChar));
cmd.Parameters[0].Value = exp;
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CyberBar info = new CyberBar();
//GPSID
if (!reader.IsDBNull(0))
{
info.Wb_code = reader[0].ToString();
}
//公安机构代码变成名称
if (!reader.IsDBNull(7))
{
info.Gajg_key = reader[7].ToString();
}
if (!reader.IsDBNull(1))
{
info.Wbmc = reader[1].ToString();
}
if (!reader.IsDBNull(3))
{
info.Wbxz = reader[3].ToString();
}
if (!reader.IsDBNull(4) && !reader.IsDBNull(5))
{
double x, y;
Double.TryParse(reader[4].ToString(), out x);
if (x > 0)
{
info.Wbjd = x;
}
Double.TryParse(reader[5].ToString(), out y);
if (y > 0)
{
info.Wbwd = y;
}
}
//if (!reader.IsDBNull(6))
//{
// info.Fzr_xm = reader[6].ToString();
//}
//if (!reader.IsDBNull(7))
//{
// info.Fzr_sfzh = reader[7].ToString();
//}
if (!reader.IsDBNull(6))
{
info.Lxdh = reader[6].ToString();
}
//if (!reader.IsDBNull(9))
//{
// info.Wb_code_old = reader[9].ToString();
//}
//if (info.Wbjd > 0 && info.Wbwd > 0)
//{
result.Add(info);
//}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
