/// <summary>
/// 查询实时岗位信息
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>返回查询结果</returns>
public DataTable SelectRealTimePostInfo(string condition)
{
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.VarChar, 1000) };
para[0].Value = condition;
return(help.ReturnDataTable("SelectRealTimePostInfo", para));
}
/// <summary>
/// 查询PathInfo信息
/// </summary>
/// <param name="strCondition">查询条件</param>
/// <returns>返回的记录表信息</returns>
public DataTable SelectPathInfo(string strCondition)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@condition", SqlDbType.VarChar, 200)
};
para[0].Value = strCondition;
DataTable dt = help.ReturnDataTable("select_Path_Info", para);
return(dt);
}
public DataTable SelectHisPathCheckByPath(string pathNo)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@pathNo", SqlDbType.VarChar, 1000)
};
para[0].Value = pathNo;
DataTable dt = help.ReturnDataTable("select_HisPathCheckByPath", para);
return(dt);
}
public DataTable LoadMenu(int iAdminID)
{
SqlParameter[] parameters =
{
new SqlParameter("@AdminID", SqlDbType.Int, 4)
};
parameters[0].Value = iAdminID;
return(DB.ReturnDataTable("W_GetUserGroupMenu", parameters));
}
public DataTable GetHisPathAlertInfo(string condition)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@condition", SqlDbType.VarChar, 100)
};
para[0].Value = condition;
DataTable dt = help.ReturnDataTable("select_His_PathAlert", para);
return(dt);
}
/// <summary>
/// 按时间段查询所有员工状态信息
/// </summary>
/// <param name="beginTime">查询开始时间</param>
/// <param name="endTime">查询结束时间</param>
/// <returns>返回DataTable数据表</returns>
public DataTable SelectAllEmpStateInfo(DateTime beginTime, DateTime endTime)
{
SqlParameter[] para =
{
new SqlParameter("@beginTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime)
};
para[0].Value = beginTime;
para[1].Value = endTime;
return(help.ReturnDataTable("selectEmpStateByTime", para));
}
/// <summary>
/// 查询实时进出天线人数统计信息
/// </summary>
/// <param name="beginTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <returns>统计出来的信息表</returns>
public DataTable SelectRealTimeSationHeadStatInfo(DateTime beginTime, DateTime endTime)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@beginTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime)
};
para[0].Value = beginTime;
para[1].Value = endTime;
return(help.ReturnDataTable("StatCount", para));
}
public DataTable RealTimeAlarmPathInfo()
{
return(help.ReturnDataTable("select_RealTimeAlarmPathInfo", null));
}
/// <summary>
/// 获取传输分站信息
/// </summary>
/// <returns>数据表</returns>
public static DataTable GetStationInfo()
{
return(help.ReturnDataTable("select_StationInfo", null));
}