public virtual List <Alarm> GetActEntities()
{
var entities = new List <Alarm>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_His.Sql_Alarm_Repository_GetActEntities, null)) {
while (rdr.Read())
{
var entity = new Alarm();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.PointId = SqlTypeConverter.DBNullInt32Handler(rdr["PointId"]);
entity.PointType = SqlTypeConverter.DBNullEnmScTypeHandler(rdr["PointType"]);
entity.PointName = SqlTypeConverter.DBNullStringHandler(rdr["PointName"]);
entity.DeviceId = SqlTypeConverter.DBNullInt32Handler(rdr["DeviceId"]);
entity.DeviceName = SqlTypeConverter.DBNullStringHandler(rdr["DeviceName"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.DriverName = SqlTypeConverter.DBNullStringHandler(rdr["DriverName"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmAlarmLevelHandler(rdr["AlarmLevel"]);
entity.AlarmValue = SqlTypeConverter.DBNullFloatHandler(rdr["AlarmValue"]);
entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]);
entity.AlarmClassId = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmClassId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
var confirmTime = SqlTypeConverter.DBNullStringHandler(rdr["ConfirmTime"]);
if (!string.IsNullOrWhiteSpace(confirmTime))
{
entity.ConfirmTime = DateTime.Parse(confirmTime);
}
entity.ConfirmName = SqlTypeConverter.DBNullStringHandler(rdr["ConfirmName"]);
var endTime = SqlTypeConverter.DBNullStringHandler(rdr["EndTime"]);
if (!string.IsNullOrWhiteSpace(endTime))
{
entity.EndTime = DateTime.Parse(endTime);
}
entity.EndValue = SqlTypeConverter.DBNullFloatHandler(rdr["EndValue"]);
entity.EndType = SqlTypeConverter.DBNullEnmAlarmEndHandler(rdr["EndType"]);
entity.AuxSet = SqlTypeConverter.DBNullStringHandler(rdr["AuxSet"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_AMeasure> GetEntities(List <VariableDetail> keys)
{
if (keys == null || keys.Count == 0)
{
throw new ArgumentNullException("keys");
}
var commands = new string[keys.Count];
for (var i = 0; i < keys.Count; i++)
{
commands[i] = string.Format(@"SELECT '{0}' AS [DeviceId], '{1}' AS [PointId]", keys[i].DeviceId, keys[i].PointId);
}
var query = string.Format(@"
;WITH Keys AS (
{0}
)
SELECT VA.* FROM [dbo].[V_AMeasure] VA INNER JOIN Keys K ON VA.[DeviceId]=K.[DeviceId] AND VA.[PointId]=K.[PointId];", string.Join(@" UNION ALL ", commands));
var entities = new List <V_AMeasure>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, query, null)) {
while (rdr.Read())
{
var entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SignalDesc = SqlTypeConverter.DBNullStringHandler(rdr["SignalDesc"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
entities.Add(entity);
}
}
return(entities);
}
public A_AAlarm GetAlarm(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
A_AAlarm entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_AAlarm_Repository_GetAlarm, parms)) {
if (rdr.Read())
{
entity = new A_AAlarm();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]);
entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]);
entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]);
entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]);
entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]);
entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]);
entity.Confirmed = SqlTypeConverter.DBNullEnmConfirmStatusHandler(rdr["Confirmed"]);
entity.Confirmer = SqlTypeConverter.DBNullStringHandler(rdr["Confirmer"]);
entity.ConfirmedTime = SqlTypeConverter.DBNullDateTimeNullableHandler(rdr["ConfirmedTime"]);
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.PrimaryId = SqlTypeConverter.DBNullStringHandler(rdr["PrimaryId"]);
entity.RelatedId = SqlTypeConverter.DBNullStringHandler(rdr["RelatedId"]);
entity.FilterId = SqlTypeConverter.DBNullStringHandler(rdr["FilterId"]);
entity.ReversalId = SqlTypeConverter.DBNullStringHandler(rdr["ReversalId"]);
entity.ReversalCount = SqlTypeConverter.DBNullInt32Handler(rdr["ReversalCount"]);
entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
}
}
return(entity);
}
public List <M_Authorization> GetEntitiesInCard(string card)
{
SqlParameter[] parms = { new SqlParameter("@CardId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(card);
var entities = new List <M_Authorization>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Authorization_Repository_GetEntitiesInCard, parms)) {
while (rdr.Read())
{
var entity = new M_Authorization();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitTime"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entities.Add(entity);
}
}
return(entities);
}
public List <H_Notice> GetNoticesInUser(string uid)
{
SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(uid);
var entities = new List <H_Notice>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_H_Notice_Repository_GetNoticesInUser, parms)) {
while (rdr.Read())
{
var entity = new H_Notice();
entity.Id = SqlTypeConverter.DBNullGuidHandler(rdr["Id"]);
entity.Title = SqlTypeConverter.DBNullStringHandler(rdr["Title"]);
entity.Content = SqlTypeConverter.DBNullStringHandler(rdr["Content"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <H_Note> GetEntities()
{
var entities = new List <H_Note>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_H_Note_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new H_Note();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.SysType = SqlTypeConverter.DBNullInt32Handler(rdr["SysType"]);
entity.GroupID = SqlTypeConverter.DBNullStringHandler(rdr["GroupID"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.DtType = SqlTypeConverter.DBNullInt32Handler(rdr["DtType"]);
entity.OpType = SqlTypeConverter.DBNullInt32Handler(rdr["OpType"]);
entity.Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["Time"]);
entity.Desc = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual List <User> GetEntities()
{
var entities = new List <User>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cfg.Sql_User_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new User();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.GroupId = SqlTypeConverter.DBNullInt32Handler(rdr["GroupId"]);
entity.DeptId = SqlTypeConverter.DBNullInt32Handler(rdr["DeptId"]);
entity.LastId = SqlTypeConverter.DBNullInt32Handler(rdr["LastId"]);
entity.LimitTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitTime"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <Reservation> GetEntities()
{
var entities = new List <Reservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Reservation_Repository_GetEntities1, null)) {
while (rdr.Read())
{
var entity = new Reservation();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]);
entity.ProjectId = SqlTypeConverter.DBNullStringHandler(rdr["ProjectId"]);
entity.Creator = SqlTypeConverter.DBNullStringHandler(rdr["Creator"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
/// <summary>
/// 获取服务基本参数
/// </summary>
public List <ParamEntity> GetParams()
{
var _params = new List <ParamEntity>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SqliteCommands.Registry_Get_Param, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var _param = new ParamEntity();
_param.Id = SqlTypeConverter.DBNullParamIdHandler(rdr["id"]);
_param.Value = SqlTypeConverter.DBNullStringHandler(rdr["value"]);
_param.Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["time"]);
_params.Add(_param);
}
}
}
}
return(_params);
}
public List <V_Offline> GetActive(EnmFormula ftype)
{
SqlParameter[] parms = { new SqlParameter("@FormulaType", SqlDbType.Int) };
parms[0].Value = (int)ftype;
var entities = new List <V_Offline>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Offline_Repository_GetActive2, parms)) {
while (rdr.Read())
{
var entity = new V_Offline();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual List <ActValue> GetAO()
{
SqlParameter[] parms = { new SqlParameter("@AO", SqlDbType.Int) };
parms[0].Value = (int)EnmScType.Aoc;
var entities = new List <ActValue>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_His.Sql_Value_Repository_GetAO, parms)) {
while (rdr.Read())
{
entities.Add(new ActValue {
DevId = SqlTypeConverter.DBNullInt32Handler(rdr["DevId"]),
NodeId = SqlTypeConverter.DBNullInt32Handler(rdr["NodeId"]),
NodeType = SqlTypeConverter.DBNullEnmScTypeHandler(rdr["NodeType"]),
Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]),
State = SqlTypeConverter.DBNullEnmPointStatusHandler(rdr["State"]),
UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"])
});
}
}
return(entities);
}
public List <Group> GetEntities()
{
var entities = new List <Group>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Group_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new Group();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeID"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]);
entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]);
entities.Add(entity);
}
}
return(entities);
}
/// <summary>
/// 获得服务命令
/// </summary>
public List <OrderEntity> GetOrders()
{
var orders = new List <OrderEntity>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SqliteCommands.Registry_Get_Order, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var order = new OrderEntity();
order.Id = SqlTypeConverter.DBNullOrderIdHandler(rdr["id"]);
order.Param = SqlTypeConverter.DBNullStringHandler(rdr["param"]);
order.Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["time"]);
orders.Add(order);
}
}
}
}
return(orders);
}
public void DeleteEntities(string device, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[2].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
using (var conn = new SqlConnection(this._databaseConnectionString)) {
conn.Open();
var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Cs.Sql_V_Load_Repository_DeleteEntities, parms);
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
public double GetAvg(string device, string point, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@PointId", SqlDbType.VarChar, 100),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullStringChecker(point);
parms[2].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[3].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var value = 0d;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_HMeasure_Repository_GetValAvg, parms)) {
if (rdr.Read())
{
value = SqlTypeConverter.DBNullDoubleHandler(rdr["AvgValue"]);
}
}
return(value);
}
public List <A_AAlarm> GetEntities()
{
var entities = new List <A_AAlarm>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_AAlarm_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new A_AAlarm();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]);
entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]);
entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]);
entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]);
entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]);
entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]);
entity.Confirmed = SqlTypeConverter.DBNullEnmConfirmHandler(rdr["Confirmed"]);
entity.Confirmer = SqlTypeConverter.DBNullStringHandler(rdr["Confirmer"]);
entity.ConfirmedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ConfirmedTime"]);
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.PrimaryId = SqlTypeConverter.DBNullStringHandler(rdr["PrimaryId"]);
entity.RelatedId = SqlTypeConverter.DBNullStringHandler(rdr["RelatedId"]);
entity.FilterId = SqlTypeConverter.DBNullStringHandler(rdr["FilterId"]);
entity.ReversalId = SqlTypeConverter.DBNullStringHandler(rdr["ReversalId"]);
entity.ReversalCount = SqlTypeConverter.DBNullInt32Handler(rdr["ReversalCount"]);
entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_AMeasure> GetEntities()
{
var entities = new List <V_AMeasure>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_AMeasure_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SignalDesc = SqlTypeConverter.DBNullStringHandler(rdr["SignalDesc"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <H_FsuEvent> GetEntities(DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var entities = new List <H_FsuEvent>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_H_FsuEvent_Repository_GetEntities1, parms)) {
while (rdr.Read())
{
var entity = new H_FsuEvent();
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.EventType = SqlTypeConverter.DBNullEnmFtpEventHandler(rdr["EventType"]);
entity.EventDesc = SqlTypeConverter.DBNullStringHandler(rdr["EventDesc"]);
entity.EventTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EventTime"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual User GetEntity(string uid)
{
SqlParameter[] parms = { new SqlParameter("@Uid", SqlDbType.VarChar, 20) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(uid);
User entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cfg.Sql_User_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new User();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.GroupId = SqlTypeConverter.DBNullInt32Handler(rdr["GroupId"]);
entity.DeptId = SqlTypeConverter.DBNullInt32Handler(rdr["DeptId"]);
entity.LastId = SqlTypeConverter.DBNullInt32Handler(rdr["LastId"]);
entity.LimitTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitTime"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
private U_User getEntity(SqlDataReader sdr)
{
var entity = new U_User();
entity.Id = SqlTypeConverter.DBNullStringHandler(sdr["ID"]);
entity.EmployeeId = SqlTypeConverter.DBNullStringHandler(sdr["EmpID"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(sdr["Enabled"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(sdr["UID"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(sdr["PWD"]);
entity.PasswordFormat = SqlTypeConverter.DBNullEnmPasswordFormatHandler(sdr["PwdFormat"]);
entity.PasswordSalt = SqlTypeConverter.DBNullStringHandler(sdr["PwdSalt"]);
entity.RoleId = SqlTypeConverter.DBNullStringHandler(sdr["RoleID"]);
entity.LimitedDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["LimitTime"]);
entity.CreatedDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["CreateTime"]);
entity.LastLoginDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["LastLoginTime"]);
entity.LastPasswordChangedDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["LastPwdChangedTime"]);
entity.FailedPasswordAttemptCount = SqlTypeConverter.DBNullInt32Handler(sdr["FailedPwdAttemptCount"]);
entity.FailedPasswordDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["FailedPwdTime"]);
entity.IsLockedOut = SqlTypeConverter.DBNullBooleanHandler(sdr["IsLockedOut"]);
entity.LastLockoutDate = SqlTypeConverter.DBNullDateTimeHandler(sdr["LastLockoutTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(sdr["Remark"]);
return(entity);
}
public List <V_BatCurve> GetProcedures(string device, int pack, EnmBatPoint ptype, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@PackId", SqlDbType.Int),
new SqlParameter("@PType", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullInt32Checker(pack);
parms[2].Value = (int)ptype;
parms[3].Value = SqlTypeConverter.DBNullDateTimeChecker(start);
parms[4].Value = SqlTypeConverter.DBNullDateTimeChecker(end);
var entities = new List <V_BatCurve>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatCurve_Repository_GetProcedures2, parms)) {
while (rdr.Read())
{
var entity = new V_BatCurve();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]);
entity.Type = SqlTypeConverter.DBNullBatStatusHandler(rdr["Type"]);
entity.PType = SqlTypeConverter.DBNullBatPointHandler(rdr["PType"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]);
entity.ProcTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ProcTime"]);
entities.Add(entity);
}
}
return(entities);
}
public Group GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
Group entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Group_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Group();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeID"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]);
entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]);
}
}
return(entity);
}
public double GetTotal(string id, EnmSSH type, EnmFormula formula, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@FormulaType", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
parms[1].Value = (int)type;
parms[2].Value = (int)formula;
parms[3].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[4].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var total = 0d;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_GetHistory7, parms)) {
if (rdr.Read())
{
total = SqlTypeConverter.DBNullDoubleHandler(rdr["Total"]);
}
}
return(total);
}
public List <V_Static> GetValuesInPoint(string device, string point, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@PointId", SqlDbType.VarChar, 100),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullStringChecker(point);
parms[2].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[3].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var entities = new List <V_Static>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Static_Repository_GetValuesInPoint, parms)) {
while (rdr.Read())
{
var entity = new V_Static();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]);
entity.MaxValue = SqlTypeConverter.DBNullDoubleHandler(rdr["MaxValue"]);
entity.MinValue = SqlTypeConverter.DBNullDoubleHandler(rdr["MinValue"]);
entity.AvgValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AvgValue"]);
entity.MaxTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["MaxTime"]);
entity.MinTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["MinTime"]);
entity.Total = SqlTypeConverter.DBNullInt32Handler(rdr["Total"]);
entities.Add(entity);
}
}
return(entities);
}
public List <Formula> GetEntities(string id, EnmOrganization type)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = id;
parms[1].Value = (int)type;
var entities = new List <Formula>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetEntities, parms)) {
while (rdr.Read())
{
var entity = new Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmOrganizationHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["Formula"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <A_TAlarm> GetEntities()
{
var entities = new List <A_TAlarm>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_TAlarm_Repository_GetEntities1, null)) {
while (rdr.Read())
{
var entity = new A_TAlarm();
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SerialNo = SqlTypeConverter.DBNullStringHandler(rdr["SerialNo"]);
entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]);
entity.AlarmTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AlarmTime"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]);
entity.AlarmFlag = SqlTypeConverter.DBNullEnmFlagHandler(rdr["AlarmFlag"]);
entity.AlarmDesc = SqlTypeConverter.DBNullStringHandler(rdr["AlarmDesc"]);
entity.AlarmValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmValue"]);
entity.AlarmRemark = SqlTypeConverter.DBNullStringHandler(rdr["AlarmRemark"]);
entities.Add(entity);
}
}
return(entities);
}
public List <M_Card> GetEntities()
{
var entities = new List <M_Card>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Card_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new M_Card();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["PWD"]);
entity.Type = SqlTypeConverter.DBNullCardTypeHandler(rdr["Type"]);
entity.Status = SqlTypeConverter.DBNullCardStatusHandler(rdr["Status"]);
entity.StatusTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StatusTime"]);
entity.StatusReason = SqlTypeConverter.DBNullStringHandler(rdr["StatusReason"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.Remarks = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
/// <summary>
/// 获取基本参数信息
/// </summary>
public List <ParamEntity> GetParams()
{
var parameters = new List <ParamEntity>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SqliteCommands.Registry_Get_Params, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var json = SqlTypeConverter.DBNullStringHandler(rdr["json"]);
parameters.Add(new ParamEntity {
Id = SqlTypeConverter.DBNullStringHandler(rdr["id"]),
Name = SqlTypeConverter.DBNullStringHandler(rdr["name"]),
Json = string.IsNullOrWhiteSpace(json) ? null : JsonConvert.DeserializeObject <ParamModel>(json),
Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["time"])
});
}
}
}
}
return(parameters);
}
public List <V_BatTime> GetProcedures(DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var entities = new List <V_BatTime>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_BatTime_Repository_GetProcedures1, parms)) {
while (rdr.Read())
{
var entity = new V_BatTime();
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PackId = SqlTypeConverter.DBNullInt32Handler(rdr["PackId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]);
entity.ProcTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ProcTime"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual List <ActValue> GetAIP(int pid)
{
SqlParameter[] parms = { new SqlParameter("@PId", SqlDbType.Int),
new SqlParameter("@AI", SqlDbType.Int) };
parms[0].Value = pid;
parms[1].Value = (int)EnmScType.Aic;
var entities = new List <ActValue>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_His.Sql_Value_Repository_GetAIP, parms)) {
while (rdr.Read())
{
var entity = new ActValue();
entity.DevId = SqlTypeConverter.DBNullInt32Handler(rdr["DevId"]);
entity.NodeId = SqlTypeConverter.DBNullInt32Handler(rdr["NodeId"]);
entity.NodeType = SqlTypeConverter.DBNullEnmScTypeHandler(rdr["NodeType"]);
entity.Value = SqlTypeConverter.DBNullFloatHandler(rdr["Value"]);
entity.State = SqlTypeConverter.DBNullEnmPointStatusHandler(rdr["State"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
entities.Add(entity);
}
}
return(entities);
}