/// <summary>
/// 查询所有上级渠道
/// </summary>
/// <returns></returns>
public virtual DataTable qd_query2()
{
string sql = string.Format("select distinct(上级渠道) as sjqd from 渠道 where 上级渠道 is not null");
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
public DataTable qd_query3(string name)
{
string sql = "";
if (name.ToString() != "")
{
sql = string.Format("select * from 渠道 " + name + "");
}
else
{
sql = string.Format("select * from 渠道");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
public DataTable csd_query1(string name)
{
string sql = "";
if (name.ToString() != "")
{
sql = string.Format("select dbo.沉沙池.* FROM dbo.渠道 INNER JOIN dbo.沉沙池 ON dbo.渠道.渠道名称 = dbo.沉沙池.所属渠道 " + name + "");
}
else
{
sql = string.Format("select * from 沉沙池");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
/// <summary>
/// 沉沙地信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable csd_query(string id)
{
string sql = "";
if (id.ToString() != "")
{
sql = string.Format("select * from 沉沙池 where id='{0}'", id);
}
else
{
sql = string.Format("select * from 沉沙池");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
public virtual DataTable dp_query1(string name)
{
string sql = "";
if (name != "")
{
sql = string.Format("select dbo.陡坡.* FROM dbo.渠道 INNER JOIN dbo.陡坡 ON dbo.渠道.渠道名称 = dbo.陡坡.所属渠道 " + name + "");
}
else
{
sql = string.Format("select * from 陡坡");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
/// <summary>
/// 渠道查询
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public virtual DataTable qd_query1(string name)
{
string sql = "";
if (name.ToString() != "")
{
sql = string.Format("select * from 渠道 where 上级渠道='{0}'", name);
}
else
{
sql = string.Format("select * from 渠道 where 上级渠道 is not null");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
/// <summary>
/// 水库信息查询
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable sk_query(string id)
{
string sql = "";
string conn = System.Configuration.ConfigurationSettings.AppSettings["wmgis"];
if (id.ToString() != "")
{
sql = string.Format("select * from 水库 where id='{0}'", id);
}
else
{
sql = string.Format("select * from 水库");
}
DataTable dt = DBI.GetDBI_wmgis().ExecuteDataTable(sql);
return(dt);
}
