/// <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);