/// <summary>
/// 煤矿信息-百度地图中使用
/// </summary>
/// <param name="mineID"></param>
/// <returns></returns>
public DataTable GetMap_MineInfo(string mineID)
{
DataTable dt = new DataTable();
SqlParameter[] sqlparms =
{
new SqlParameter("@mineCode", mineID)
};
dt = SQLDataServer.ProcedureDataTable("Map_MineInfo", sqlparms, conn);
return(dt);
}
/// <summary>
/// 获取历史传输异常信息
/// </summary>
/// <param name="where">条件</param>
/// <returns></returns>
public DataTable GetRtBadLog(string where)
{
DataTable dt = new DataTable();
SqlParameter[] sqlparms =
{
new SqlParameter("@where", where)
};
dt = SQLDataServer.ProcedureDataTable("Call_RtBadLog", sqlparms, conn);
return(dt);
}
/// <summary>
/// 获取设备配置信息
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="devtype">设备类型</param>
/// <returns></returns>
public DataTable GetDeviceInfo(string where, string devtype)
{
DataTable dt = new DataTable();
if (devtype != "" && devtype != null)
{
where = "d.type='" + devtype + "' and " + where;
}
SqlParameter[] sqlparms =
{
new SqlParameter("@where", where)
};
if (devtype == "D")
{
dt = SQLDataServer.ProcedureDataTable("Call_DeviceInfo_D", sqlparms, conn);
}
else
{
dt = SQLDataServer.ProcedureDataTable("Call_DeviceInfo", sqlparms, conn);
}
return(dt);
}