/// <summary>
/// 获取实时数据列表
/// </summary>
/// <param name="device"></param>
/// <returns></returns>
public int GetDeviceInfoCount(DEVICEINFO device)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT COUNT(1) ");
strSql.Append(" FROM DEVICEINFO DI ");
strSql.Append(" LEFT JOIN DEVICEATTACH DA ON DI.DEVICECODE=DA.DEVICECODE ");
strSql.Append(" WHERE 1=1 ");
List <OracleParameter> list = new List <OracleParameter>();
// 设备类型（岸基站、浮标）
if (device.DEVICETYPE > 0)
{
strSql.Append(" AND DEVICETYPE=:DEVICETYPE ");
list.Add(new OracleParameter(":DEVICETYPE", device.DEVICETYPE));
}
if (!string.IsNullOrEmpty(device.SEAAREA))
{
strSql.Append(" AND SEAAREA=:SEAAREA ");
list.Add(new OracleParameter(":SEAAREA", device.SEAAREA));
}
if (!string.IsNullOrEmpty(device.PROVINCE))
{
strSql.Append(" AND PROVINCE=:PROVINCE ");
list.Add(new OracleParameter(":PROVINCE", device.PROVINCE));
}
if (!string.IsNullOrEmpty(device.BAY))
{
strSql.Append(" AND BAY=:BAY ");
list.Add(new OracleParameter(":BAY", device.BAY));
}
if (!string.IsNullOrEmpty(device.BUREAUDEVICE))
{
strSql.Append(" AND BUREAUDEVICE=:BUREAUDEVICE ");
list.Add(new OracleParameter(":BUREAUDEVICE", device.BUREAUDEVICE));
}
if (!string.IsNullOrEmpty(device.LOCALDEVICE))
{
strSql.Append(" AND LOCALDEVICE=:LOCALDEVICE ");
list.Add(new OracleParameter(":LOCALDEVICE", device.LOCALDEVICE));
}
if (!string.IsNullOrEmpty(device.SERVICE))
{
strSql.Append(" AND SERVICE=:SERVICE ");
list.Add(new OracleParameter(":SERVICE", device.SERVICE));
}
DbAPI dbHelper = new DbAPI();
dbHelper.OpenConn("");
object result = dbHelper.ExecuteOracleScalar(strSql.ToString(), list.ToArray());
dbHelper.CloseConn();
return(Convert.ToInt32(result.ToString()));
}
public DataTablesResult GetDeviceInfoList(string bianhao, string haiqu, string shengfen, string haiwan, string jushusheshi, string difangsheshi, string yewu, int dType)
{
DEVICEINFO device = new DEVICEINFO();
device.DEVICECODE = bianhao;
device.SEAAREA = haiqu;
device.PROVINCE = shengfen;
device.BAY = haiwan;
device.BUREAUDEVICE = jushusheshi;
device.LOCALDEVICE = difangsheshi;
device.SERVICE = yewu;
device.DEVICETYPE = dType;
DEVICEINFO_BN fun = new DEVICEINFO_BN();
return(fun.GetDeviceInfo(device));
}
/// <summary>
/// 获取实时数据列表
/// </summary>
/// <param name="device"></param>
/// <returns></returns>
public DataTablesResult GetDeviceInfo(DEVICEINFO device)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT * FROM( ");
strSql.Append(" SELECT DI.DEVICECODE,DEVICENAME,DEVICEUSER,DEVICETYPE,LAYTIME,ELON,ELAT,COMTYPE,STRUCTTYPE,COMARRAY,PACKNUM,RUNNINGSTATUS,POSITION,PRODUCER,MANAGER,ROWNUM NUM ");
strSql.Append(" FROM DEVICEINFO DI ");
strSql.Append(" LEFT JOIN DEVICEATTACH DA ON DI.DEVICECODE=DA.DEVICECODE ");
strSql.Append(" WHERE 1=1 ");
List <OracleParameter> list = new List <OracleParameter>();
// 编号
if (!string.IsNullOrEmpty(device.DEVICECODE))
{
strSql.Append(" AND DI.DEVICECODE=:DEVICECODE ");
list.Add(new OracleParameter(":DEVICECODE", device.DEVICECODE));
}
// 设备类型（岸基站、浮标）
if (device.DEVICETYPE > 0)
{
strSql.Append(" AND DEVICETYPE=:DEVICETYPE ");
list.Add(new OracleParameter(":DEVICETYPE", device.DEVICETYPE));
}
if (!string.IsNullOrEmpty(device.SEAAREA))
{
if ("全部" != device.SEAAREA)
{
strSql.Append(" AND SEAAREA=:SEAAREA ");
list.Add(new OracleParameter(":SEAAREA", device.SEAAREA));
}
}
if (!string.IsNullOrEmpty(device.PROVINCE))
{
if ("全部" != device.PROVINCE)
{
strSql.Append(" AND PROVINCE=:PROVINCE ");
list.Add(new OracleParameter(":PROVINCE", device.PROVINCE));
}
}
if (!string.IsNullOrEmpty(device.BAY))
{
if ("全部" != device.BAY)
{
strSql.Append(" AND BAY=:BAY ");
list.Add(new OracleParameter(":BAY", device.BAY));
}
}
if (!string.IsNullOrEmpty(device.BUREAUDEVICE))
{
if ("全部" != device.BUREAUDEVICE)
{
strSql.Append(" AND BUREAUDEVICE=:BUREAUDEVICE ");
list.Add(new OracleParameter(":BUREAUDEVICE", device.BUREAUDEVICE));
}
}
if (!string.IsNullOrEmpty(device.LOCALDEVICE))
{
if ("全部" != device.LOCALDEVICE)
{
strSql.Append(" AND LOCALDEVICE=:LOCALDEVICE ");
list.Add(new OracleParameter(":LOCALDEVICE", device.LOCALDEVICE));
}
}
if (!string.IsNullOrEmpty(device.SERVICE))
{
if ("全部" != device.SERVICE)
{
strSql.Append(" AND SERVICE=:SERVICE ");
list.Add(new OracleParameter(":SERVICE", device.SERVICE));
}
}
strSql.Append(" )INFO ");
// strSql.Append(" )INFO WHERE NUM>(:pageIndex-1)*:pageSize AND NUM<=:pageIndex*:pageSize ");
//list.Add(new OracleParameter(":pageIndex", device.page));
// list.Add(new OracleParameter(":pageSize", device.limit));
try
{
DbAPI dbHelper = new DbAPI();
DataTablesResult result = new DataTablesResult();
dbHelper.OpenConn("");
DataTable bt = dbHelper.GetDataTable(strSql.ToString(), list.ToArray());
result.aaData = bt;
result.sEcho = Convert.ToInt16(device.limit);
//result.iTotalDisplayRecords = bt.Rows.Count;
//result.iTotalRecords = bt.Rows.Count.ToString();
result.iTotalDisplayRecords = GetDeviceInfoCount(device);
result.iTotalRecords = GetDeviceInfoCount(device).ToString();
dbHelper.CloseConn();
return(result);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(DEVICEINFO_BN), "GetDeviceInfo 程序段的异常" + ex);
return(null);
}
}
public static extern int CKT_GetDeviceInfo(int Sno, ref DEVICEINFO devinfo);
