123 lines
3.6 KiB
C#
123 lines
3.6 KiB
C#
using AIMSExtension;
|
|
using HelperDB;
|
|
using System;
|
|
using System.Collections;
|
|
using System.Collections.Generic;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace AIMSModel
|
|
{
|
|
[Serializable]
|
|
public partial class DeviceCacheData
|
|
{
|
|
private int? id;
|
|
private string iPAddress;
|
|
private string deviceName;
|
|
private DateTime? createTime;
|
|
private DateTime? updateTime;
|
|
private string jsonData;
|
|
|
|
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public int? Id
|
|
{
|
|
get { return id; }
|
|
set { id = value; }
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public string IPAddress
|
|
{
|
|
get { return iPAddress; }
|
|
set { iPAddress = value; }
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public string DeviceName
|
|
{
|
|
get { return deviceName; }
|
|
set { deviceName = value; }
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public DateTime? CreateTime
|
|
{
|
|
get { return createTime; }
|
|
set { createTime = value; }
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public DateTime? UpdateTime
|
|
{
|
|
get { return updateTime; }
|
|
set { updateTime = value; }
|
|
}
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
public string JsonData
|
|
{
|
|
get { return jsonData; }
|
|
set { jsonData = value; }
|
|
}
|
|
public static List<DeviceCacheData> Select(string oql)
|
|
{
|
|
List<DeviceCacheData> deviceCacheDataList = new List<DeviceCacheData>();
|
|
using (SqlConnection conn = new SqlConnection(DATADBHelper._ConnectionString))
|
|
{
|
|
conn.Open();
|
|
using (SqlCommand cmd = conn.CreateCommand())
|
|
{
|
|
string filterString = " where " + oql;
|
|
cmd.Parameters.Clear();
|
|
cmd.CommandText = "select * from DeviceCacheData " + filterString;
|
|
using (SqlDataReader dr = cmd.ExecuteReader())
|
|
{
|
|
while (dr.Read())
|
|
{
|
|
DeviceCacheData deviceCacheData = DataReaderToEntity(dr);
|
|
deviceCacheDataList.Add(deviceCacheData);
|
|
}
|
|
}
|
|
return deviceCacheDataList;
|
|
}
|
|
}
|
|
}
|
|
private static DeviceCacheData DataReaderToEntity(SqlDataReader dr)
|
|
{
|
|
DeviceCacheData entity = new DeviceCacheData();
|
|
if (dr["Id"] != System.DBNull.Value)
|
|
{
|
|
entity.Id = Convert.ToInt32(dr["Id"]);
|
|
}
|
|
if (dr["IPAddress"] != System.DBNull.Value)
|
|
{
|
|
entity.IPAddress = dr["IPAddress"].ToString();
|
|
}
|
|
if (dr["DeviceName"] != System.DBNull.Value)
|
|
{
|
|
entity.DeviceName = dr["DeviceName"].ToString();
|
|
}
|
|
if (dr["CreateTime"] != System.DBNull.Value)
|
|
{
|
|
entity.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
|
|
}
|
|
if (dr["UpdateTime"] != System.DBNull.Value)
|
|
{
|
|
entity.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
|
|
}
|
|
if (dr["JsonData"] != System.DBNull.Value)
|
|
{
|
|
entity.JsonData = dr["JsonData"].ToString();
|
|
}
|
|
return entity;
|
|
}
|
|
}
|
|
}
|