public List <P_Point> GetPoints()
{
var entities = new List <P_Point>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_P_Point_Repository_GetPoints, null)) {
while (rdr.Read())
{
var entity = new P_Point();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = SqlTypeConverter.DBNullEnmPointHandler(rdr["Type"]);
entity.UnitState = SqlTypeConverter.DBNullStringHandler(rdr["UnitState"]);
entity.Number = SqlTypeConverter.DBNullStringHandler(rdr["Number"]);
entity.AlarmId = SqlTypeConverter.DBNullStringHandler(rdr["AlarmId"]);
entity.DeviceType = new C_DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.LogicType = new C_LogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeName"])
};
entity.DeviceEffect = SqlTypeConverter.DBNullStringHandler(rdr["DeviceEffect"]);
entity.BusiEffect = SqlTypeConverter.DBNullStringHandler(rdr["BusiEffect"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Interpret = SqlTypeConverter.DBNullStringHandler(rdr["Interpret"]);
entity.ExtSet = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public ExtFsu GetExtEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
ExtFsu entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Fsu_Repository_GetExtEntity, parms)) {
if (rdr.Read())
{
entity = new ExtFsu();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Pwd = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entity.FtpUid = SqlTypeConverter.DBNullStringHandler(rdr["FtpUid"]);
entity.FtpPwd = SqlTypeConverter.DBNullStringHandler(rdr["FtpPwd"]);
entity.FtpFilePath = SqlTypeConverter.DBNullStringHandler(rdr["FtpFilePath"]);
entity.FtpAuthority = SqlTypeConverter.DBNullInt32Handler(rdr["FtpAuthority"]);
entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]);
entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]);
entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
}
}
return(entity);
}
public virtual List <Device> GetGroupEntities(int gid)
{
SqlParameter[] parms = { new SqlParameter("@GroupId", SqlDbType.Int) };
parms[0].Value = gid;
var entities = new List <Device>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cfg.Sql_Device_Repository_GetGroupEntities, parms)) {
while (rdr.Read())
{
var entity = new Device();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Desc = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.DeviceType = SqlTypeConverter.DBNullInt32Handler(rdr["DeviceType"]);
entity.DeviceTypeName = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"]);
entity.VendorId = SqlTypeConverter.DBNullInt32Handler(rdr["VendorId"]);
entity.Version = SqlTypeConverter.DBNullStringHandler(rdr["Version"]);
entity.DeviceModel = SqlTypeConverter.DBNullStringHandler(rdr["DeviceModel"]);
entity.BeginRunTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginRunTime"]);
entity.MID = SqlTypeConverter.DBNullStringHandler(rdr["MID"]);
entity.ExpSet = SqlTypeConverter.DBNullStringHandler(rdr["ExpSet"]);
entity.TID = SqlTypeConverter.DBNullInt32Handler(rdr["TID"]);
entity.Bind = SqlTypeConverter.DBNullBooleanHandler(rdr["Bind"]);
entity.PId = SqlTypeConverter.DBNullInt32Handler(rdr["PId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_ParamDiff> GetDiffs(DateTime date)
{
SqlParameter[] parms = { new SqlParameter("@Date", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(date);
var entities = new List <V_ParamDiff>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_ParamDiff_Repository_GetDiffs, parms)) {
while (rdr.Read())
{
var entity = new V_ParamDiff();
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.Threshold = SqlTypeConverter.DBNullStringHandler(rdr["Threshold"]);
entity.AlarmLevel = SqlTypeConverter.DBNullStringHandler(rdr["AlarmLevel"]);
entity.NMAlarmID = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmID"]);
entity.AbsoluteVal = SqlTypeConverter.DBNullStringHandler(rdr["AbsoluteVal"]);
entity.RelativeVal = SqlTypeConverter.DBNullStringHandler(rdr["RelativeVal"]);
entity.StorageInterval = SqlTypeConverter.DBNullStringHandler(rdr["StorageInterval"]);
entity.StorageRefTime = SqlTypeConverter.DBNullStringHandler(rdr["StorageRefTime"]);
entity.Masked = SqlTypeConverter.DBNullBooleanHandler(rdr["Masked"]);
entities.Add(entity);
}
}
return(entities);
}
public List <ExtFsu> GetExtEntities()
{
var entities = new List <ExtFsu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Fsu_Repository_GetExtEntities, null)) {
while (rdr.Read())
{
var entity = new ExtFsu();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Pwd = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entity.FtpUid = SqlTypeConverter.DBNullStringHandler(rdr["FtpUid"]);
entity.FtpPwd = SqlTypeConverter.DBNullStringHandler(rdr["FtpPwd"]);
entity.FtpFilePath = SqlTypeConverter.DBNullStringHandler(rdr["FtpFilePath"]);
entity.FtpAuthority = SqlTypeConverter.DBNullInt32Handler(rdr["FtpAuthority"]);
entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]);
entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]);
entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual List <Project> GetEntities(DateTime starttime, DateTime endtime)
{
SqlParameter[] parms = { new SqlParameter("@starttime", SqlDbType.DateTime),
new SqlParameter("@endtime", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeChecker(starttime);
parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(endtime);
var entities = new List <Project>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Project_Repository_GetEntitiesByDate, parms)) {
while (rdr.Read())
{
var entity = new Project();
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.Responsible = SqlTypeConverter.DBNullStringHandler(rdr["Responsible"]);
entity.ContactPhone = SqlTypeConverter.DBNullStringHandler(rdr["ContactPhone"]);
entity.Company = SqlTypeConverter.DBNullStringHandler(rdr["Company"]);
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);
}
public virtual Project GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
Project entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Project_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Project();
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.Responsible = SqlTypeConverter.DBNullStringHandler(rdr["Responsible"]);
entity.ContactPhone = SqlTypeConverter.DBNullStringHandler(rdr["ContactPhone"]);
entity.Company = SqlTypeConverter.DBNullStringHandler(rdr["Company"]);
entity.Creator = SqlTypeConverter.DBNullStringHandler(rdr["Creator"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public List <M_Reservation> GetReservations()
{
var entities = new List <M_Reservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_Reservation_Repository_GetReservations, null)) {
while (rdr.Read())
{
var entity = new M_Reservation();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.ExpStartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ExpStartTime"]);
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.UserId = SqlTypeConverter.DBNullStringHandler(rdr["UserId"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entity.Status = SqlTypeConverter.DBNullResultHandler(rdr["Status"]);
entities.Add(entity);
}
}
return(entities);
}
public List <G_Page> GetEntities(string role, string id, int type)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100),
new SqlParameter("@ObjId", SqlDbType.VarChar, 100),
new SqlParameter("@ObjType", SqlDbType.Int) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(role);
parms[1].Value = SqlTypeConverter.DBNullStringChecker(id);
parms[2].Value = SqlTypeConverter.DBNullInt32Checker(type);
var entities = new List <G_Page>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_G_Page_Repository_GetEntitiesInObj, parms)) {
while (rdr.Read())
{
var entity = new G_Page();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IsHome = SqlTypeConverter.DBNullBooleanHandler(rdr["IsHome"]);
entity.Content = SqlTypeConverter.DBNullStringHandler(rdr["Content"]);
entity.ObjId = SqlTypeConverter.DBNullStringHandler(rdr["ObjId"]);
entity.ObjType = SqlTypeConverter.DBNullInt32Handler(rdr["ObjType"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
public List <Reservation> GetEntities(DateTime time)
{
SqlParameter[] parms = { new SqlParameter("@StartTime", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeChecker(time);
var entities = new List <Reservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Reservation_Repository_GetEntities2, parms)) {
while (rdr.Read())
{
var entity = new Reservation();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.ExpStartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ExpStartTime"]);
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.Status = SqlTypeConverter.DBNullResultHandler(rdr["Status"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public M_Card GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@CardId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
M_Card entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Card_Repository_GetEntity, parms)) {
if (rdr.Read())
{
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"]);
}
}
return(entity);
}
public C_Supplier GetSupplier(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
C_Supplier entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_Supplier_Repository_GetSupplier, parms)) {
if (rdr.Read())
{
entity = new C_Supplier();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["linkMan"]);
entity.Phone = SqlTypeConverter.DBNullStringHandler(rdr["Phone"]);
entity.Fax = SqlTypeConverter.DBNullStringHandler(rdr["Fax"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.Level = SqlTypeConverter.DBNullStringHandler(rdr["Level"]);
entity.PostalCode = SqlTypeConverter.DBNullStringHandler(rdr["PostalCode"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public List <Room> GetEntities(string parent)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(parent);
var entities = new List <Room>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Room_Repository_GetEntitiesByParent, parms)) {
while (rdr.Read())
{
var entity = new Room();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new RoomType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeName"])
};
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public virtual List <Station> GetEntities(int pid)
{
SqlParameter[] parms = { new SqlParameter("@PId", SqlDbType.Int) };
parms[0].Value = pid;
var entities = new List <Station>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cfg.Sql_Station_Repository_GetEntitiesByPId, parms)) {
while (rdr.Read())
{
var entity = new Station();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Desc = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.MID = SqlTypeConverter.DBNullStringHandler(rdr["MID"]);
entity.ExpSet = SqlTypeConverter.DBNullStringHandler(rdr["ExpSet"]);
entity.StationType = SqlTypeConverter.DBNullInt32Handler(rdr["StationType"]);
entity.StationTypeName = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeName"]);
entity.Longitude = SqlTypeConverter.DBNullDoubleHandler(rdr["Longitude"]);
entity.Latitude = SqlTypeConverter.DBNullDoubleHandler(rdr["Latitude"]);
entity.AreaId = SqlTypeConverter.DBNullInt32Handler(rdr["AreaId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public A_Area GetArea(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
A_Area entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_A_Area_Repository_GetArea, parms)) {
if (rdr.Read())
{
entity = new A_Area();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new Kv <int, string>()
{
Key = SqlTypeConverter.DBNullInt32Handler(rdr["NodeLevel"]), Value = ""
};
entity.ParentId = SqlTypeConverter.DBNullStringHandler(rdr["ParentId"]);
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public Room GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
Room entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Room_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Room();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new RoomType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeName"])
};
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public M_Reservation GetReservation(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
M_Reservation entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_Reservation_Repository_GetReservation, parms)) {
if (rdr.Read())
{
entity = new M_Reservation();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.ExpStartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ExpStartTime"]);
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.UserId = SqlTypeConverter.DBNullStringHandler(rdr["UserId"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entity.Status = SqlTypeConverter.DBNullResultHandler(rdr["Status"]);
}
}
return(entity);
}
public List<U_User> GetUsersInRole(string id)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List<U_User>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_User_Repository_GetUsersInRole, parms)) {
while (rdr.Read()) {
var entity = new U_User();
entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]);
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.PasswordFormat = SqlTypeConverter.DBNullEnmPasswordFormatHandler(rdr["PasswordFormat"]);
entity.PasswordSalt = SqlTypeConverter.DBNullStringHandler(rdr["PasswordSalt"]);
entity.CreatedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedDate"]);
entity.LimitedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitedDate"]);
entity.LastLoginDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLoginDate"]);
entity.LastPasswordChangedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]);
entity.FailedPasswordAttemptCount = SqlTypeConverter.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]);
entity.FailedPasswordDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["FailedPasswordDate"]);
entity.IsLockedOut = SqlTypeConverter.DBNullBooleanHandler(rdr["IsLockedOut"]);
entity.LastLockoutDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLockoutDate"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.EmployeeId = SqlTypeConverter.DBNullStringHandler(rdr["EmployeeId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return entities;
}
public List <Station> GetEntities()
{
var entities = new List <Station>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Station_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new Station();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new StationType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeName"])
};
entity.Longitude = SqlTypeConverter.DBNullStringHandler(rdr["Longitude"]);
entity.Latitude = SqlTypeConverter.DBNullStringHandler(rdr["Latitude"]);
entity.Altitude = SqlTypeConverter.DBNullStringHandler(rdr["Altitude"]);
entity.CityElecCap = SqlTypeConverter.DBNullStringHandler(rdr["CityElecCap"]);
entity.CityElectNumber = SqlTypeConverter.DBNullInt32Handler(rdr["CityElectNumber"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public Station GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
Station entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Station_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Station();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new StationType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeName"])
};
entity.Longitude = SqlTypeConverter.DBNullStringHandler(rdr["Longitude"]);
entity.Latitude = SqlTypeConverter.DBNullStringHandler(rdr["Latitude"]);
entity.Altitude = SqlTypeConverter.DBNullStringHandler(rdr["Altitude"]);
entity.CityElecCap = SqlTypeConverter.DBNullStringHandler(rdr["CityElecCap"]);
entity.CityElectNumber = SqlTypeConverter.DBNullInt32Handler(rdr["CityElectNumber"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public List <Fsu> GetEntities(string parent)
{
SqlParameter[] parms = { new SqlParameter("@RoomId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(parent);
var entities = new List <Fsu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Fsu_Repository_GetEntitiesByParent, parms)) {
while (rdr.Read())
{
var entity = new Fsu();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.ProdId = SqlTypeConverter.DBNullStringHandler(rdr["ProdId"]);
entity.BrandId = SqlTypeConverter.DBNullStringHandler(rdr["BrandId"]);
entity.SuppId = SqlTypeConverter.DBNullStringHandler(rdr["SuppId"]);
entity.SubCompId = SqlTypeConverter.DBNullStringHandler(rdr["SubCompId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.FsuCode = SqlTypeConverter.DBNullStringHandler(rdr["FsuCode"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Pwd = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entity.FtpUid = SqlTypeConverter.DBNullStringHandler(rdr["FtpUid"]);
entity.FtpPwd = SqlTypeConverter.DBNullStringHandler(rdr["FtpPwd"]);
entity.FtpFilePath = SqlTypeConverter.DBNullStringHandler(rdr["FtpFilePath"]);
entity.FtpAuthority = SqlTypeConverter.DBNullInt32Handler(rdr["FtpAuthority"]);
entity.ChangeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ChangeTime"]);
entity.LastTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastTime"]);
entity.Status = SqlTypeConverter.DBNullBooleanHandler(rdr["Status"]);
entity.Desc = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entities.Add(entity);
}
}
return(entities);
}
public List <Point> GetEntitiesByProtocol(string protocol)
{
SqlParameter[] parms = { new SqlParameter("@ProtocolId", SqlDbType.VarChar, 100) };
parms[0].Value = protocol;
var entities = new List <Point>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_Point_Repository_GetEntitiesByProtcol, parms)) {
while (rdr.Read())
{
var entity = new Point();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = SqlTypeConverter.DBNullEnmPointHandler(rdr["Type"]);
entity.UnitState = SqlTypeConverter.DBNullStringHandler(rdr["UnitState"]);
entity.Number = SqlTypeConverter.DBNullStringHandler(rdr["Number"]);
entity.AlarmId = SqlTypeConverter.DBNullStringHandler(rdr["AlarmId"]);
entity.NMAlarmId = SqlTypeConverter.DBNullStringHandler(rdr["NMAlarmId"]);
entity.StationType = new StationType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["StationTypeName"])
};
entity.SubDeviceType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.DeviceType = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubLogicType = new SubLogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeName"])
};
entity.LogicType = new LogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeName"])
};
entity.AlarmComment = SqlTypeConverter.DBNullStringHandler(rdr["AlarmComment"]);
entity.NormalComment = SqlTypeConverter.DBNullStringHandler(rdr["NormalComment"]);
entity.DeviceEffect = SqlTypeConverter.DBNullStringHandler(rdr["DeviceEffect"]);
entity.BusiEffect = SqlTypeConverter.DBNullStringHandler(rdr["BusiEffect"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]);
entity.TriggerTypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TriggerTypeId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Interpret = SqlTypeConverter.DBNullStringHandler(rdr["Interpret"]);
entity.AlarmLimit = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmLimit"]);
entity.AlarmReturnDiff = SqlTypeConverter.DBNullDoubleHandler(rdr["AlarmReturnDiff"]);
entity.AlarmRecoveryDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmRecoveryDelay"]);
entity.AlarmDelay = SqlTypeConverter.DBNullInt32Handler(rdr["AlarmDelay"]);
entity.SavedPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["SavedPeriod"]);
entity.StaticPeriod = SqlTypeConverter.DBNullInt32Handler(rdr["StaticPeriod"]);
entity.AbsoluteThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["AbsoluteThreshold"]);
entity.PerThreshold = SqlTypeConverter.DBNullDoubleHandler(rdr["PerThreshold"]);
entity.ExtSet1 = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet1"]);
entity.ExtSet2 = SqlTypeConverter.DBNullStringHandler(rdr["ExtSet2"]);
entity.Description = SqlTypeConverter.DBNullStringHandler(rdr["Description"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <D_Device> GetDevicesInStation(string id)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <D_Device>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Device_Repository_GetDevicesInStation, parms)) {
while (rdr.Read())
{
var entity = new D_Device();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new C_DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new C_SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.LogicType = new C_LogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeName"])
};
entity.SubLogicType = new C_SubLogicType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubLogicTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Productor = SqlTypeConverter.DBNullStringHandler(rdr["Productor"]);
entity.Brand = SqlTypeConverter.DBNullStringHandler(rdr["Brand"]);
entity.Supplier = SqlTypeConverter.DBNullStringHandler(rdr["Supplier"]);
entity.SubCompany = SqlTypeConverter.DBNullStringHandler(rdr["SubCompany"]);
entity.SubManager = SqlTypeConverter.DBNullStringHandler(rdr["SubManager"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Version = SqlTypeConverter.DBNullStringHandler(rdr["Version"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.StaTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.RoomTypeId = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <DivSwitElecSour> GetEntities()
{
var entities = new List <DivSwitElecSour>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_DivSwitElecSour_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new DivSwitElecSour();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.ProdId = SqlTypeConverter.DBNullStringHandler(rdr["ProdId"]);
entity.BrandId = SqlTypeConverter.DBNullStringHandler(rdr["BrandId"]);
entity.SuppId = SqlTypeConverter.DBNullStringHandler(rdr["SuppId"]);
entity.SubCompId = SqlTypeConverter.DBNullStringHandler(rdr["SubCompId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.FsuCode = SqlTypeConverter.DBNullStringHandler(rdr["FsuCode"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entity.RatedOutputVolt = SqlTypeConverter.DBNullDoubleHandler(rdr["RatedOutputVolt"]);
entity.MoniModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["MoniModuleModel"]);
entity.ExisRModuleCount = SqlTypeConverter.DBNullStringHandler(rdr["ExisRModuleCount"]);
entity.RModuleModel = SqlTypeConverter.DBNullStringHandler(rdr["RModuleModel"]);
entity.RModuleRatedWorkVolt = SqlTypeConverter.DBNullInt32Handler(rdr["RModuleRatedWorkVolt"]);
entity.SingRModuleRatedOPCap = SqlTypeConverter.DBNullStringHandler(rdr["SingRModuleRatedOPCap"]);
entity.SingGBattGFuseCap = SqlTypeConverter.DBNullStringHandler(rdr["SingGBattGFuseCap"]);
entity.BattGFuseGNumber = SqlTypeConverter.DBNullInt32Handler(rdr["BattGFuseGNumber"]);
entity.OPDistBoardModel = SqlTypeConverter.DBNullStringHandler(rdr["OPDistBoardModel"]);
entity.OPDistBoardNumber = SqlTypeConverter.DBNullInt32Handler(rdr["OPDistBoardNumber"]);
entities.Add(entity);
}
}
return(entities);
}
public BattGroup GetEntity(string device)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
BattGroup entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_BattGroup_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new BattGroup();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.ProdId = SqlTypeConverter.DBNullStringHandler(rdr["ProdId"]);
entity.BrandId = SqlTypeConverter.DBNullStringHandler(rdr["BrandId"]);
entity.SuppId = SqlTypeConverter.DBNullStringHandler(rdr["SuppId"]);
entity.SubCompId = SqlTypeConverter.DBNullStringHandler(rdr["SubCompId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.FsuCode = SqlTypeConverter.DBNullStringHandler(rdr["FsuCode"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
var cap = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupCap"]);
entity.SingGroupCap = string.IsNullOrWhiteSpace(cap) ? 0d : double.Parse(cap);
entity.SingVoltGrade = SqlTypeConverter.DBNullInt32Handler(rdr["SingVoltGrade"]);
var num = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupBattNumber"]);
entity.SingGroupBattNumber = string.IsNullOrWhiteSpace(num) ? 0 : int.Parse(num);
}
}
return(entity);
}
public List <U_Employee> GetEmployeesByDept(string dept)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@DeptId", SqlDbType.VarChar, 100) };
parms[0].Value = (int)EnmEmpType.Employee;
parms[1].Value = SqlTypeConverter.DBNullStringChecker(dept);
var entities = new List <U_Employee>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_U_Employee_Repository_GetEmployeesByDept, parms)) {
while (rdr.Read())
{
var entity = new U_Employee();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["EmpNo"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.EngName = SqlTypeConverter.DBNullStringHandler(rdr["EngName"]);
entity.UsedName = SqlTypeConverter.DBNullStringHandler(rdr["UsedName"]);
entity.Sex = SqlTypeConverter.DBNullEnmSexHandler(rdr["Sex"]);
entity.DeptId = SqlTypeConverter.DBNullStringHandler(rdr["DeptId"]);
entity.DeptName = SqlTypeConverter.DBNullStringHandler(rdr["DeptName"]);
entity.DutyId = SqlTypeConverter.DBNullStringHandler(rdr["DutyId"]);
entity.DutyName = SqlTypeConverter.DBNullStringHandler(rdr["DutyName"]);
entity.ICardId = SqlTypeConverter.DBNullStringHandler(rdr["ICardId"]);
entity.Birthday = SqlTypeConverter.DBNullDateTimeHandler(rdr["Birthday"]);
entity.Degree = SqlTypeConverter.DBNullEnmDegreeHandler(rdr["Degree"]);
entity.Marriage = SqlTypeConverter.DBNullEnmMarriageHandler(rdr["Marriage"]);
entity.Nation = SqlTypeConverter.DBNullStringHandler(rdr["Nation"]);
entity.Provinces = SqlTypeConverter.DBNullStringHandler(rdr["Provinces"]);
entity.Native = SqlTypeConverter.DBNullStringHandler(rdr["Native"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.PostalCode = SqlTypeConverter.DBNullStringHandler(rdr["PostalCode"]);
entity.AddrPhone = SqlTypeConverter.DBNullStringHandler(rdr["AddrPhone"]);
entity.WorkPhone = SqlTypeConverter.DBNullStringHandler(rdr["WorkPhone"]);
entity.MobilePhone = SqlTypeConverter.DBNullStringHandler(rdr["MobilePhone"]);
entity.Email = SqlTypeConverter.DBNullStringHandler(rdr["Email"]);
entity.Photo = SqlTypeConverter.DBNullBytesHandler(rdr["Photo"]);
entity.IsLeft = SqlTypeConverter.DBNullBooleanHandler(rdr["Leaving"]);
entity.EntryTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EntryTime"]);
entity.RetireTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["RetireTime"]);
entity.IsFormal = SqlTypeConverter.DBNullBooleanHandler(rdr["IsFormal"]);
entity.Remarks = SqlTypeConverter.DBNullStringHandler(rdr["Remarks"]);
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["CardId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <BattGroup> GetEntities()
{
var entities = new List <BattGroup>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_BattGroup_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new BattGroup();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.SysName = SqlTypeConverter.DBNullStringHandler(rdr["SysName"]);
entity.SysCode = SqlTypeConverter.DBNullStringHandler(rdr["SysCode"]);
entity.Type = new DeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["DeviceTypeName"])
};
entity.SubType = new SubDeviceType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["SubDeviceTypeName"])
};
entity.Model = SqlTypeConverter.DBNullStringHandler(rdr["Model"]);
entity.ProdId = SqlTypeConverter.DBNullStringHandler(rdr["ProdId"]);
entity.BrandId = SqlTypeConverter.DBNullStringHandler(rdr["BrandId"]);
entity.SuppId = SqlTypeConverter.DBNullStringHandler(rdr["SuppId"]);
entity.SubCompId = SqlTypeConverter.DBNullStringHandler(rdr["SubCompId"]);
entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.ScrapTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ScrapTime"]);
entity.StatusId = SqlTypeConverter.DBNullInt32Handler(rdr["StatusId"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.FsuCode = SqlTypeConverter.DBNullStringHandler(rdr["FsuCode"]);
entity.ProtocolId = SqlTypeConverter.DBNullStringHandler(rdr["ProtocolId"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
var cap = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupCap"]);
entity.SingGroupCap = string.IsNullOrWhiteSpace(cap) ? 0d : double.Parse(cap);
entity.SingVoltGrade = SqlTypeConverter.DBNullInt32Handler(rdr["SingVoltGrade"]);
var num = SqlTypeConverter.DBNullStringHandler(rdr["SingGroupBattNumber"]);
entity.SingGroupBattNumber = string.IsNullOrWhiteSpace(num) ? 0 : int.Parse(num);
entities.Add(entity);
}
}
return(entities);
}
public List <A_HAlarm> GetAlarmsInStation(string id, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
parms[1].Value = SqlTypeConverter.DBNullDateTimeChecker(start);
parms[2].Value = SqlTypeConverter.DBNullDateTimeChecker(end);
var entities = new List <A_HAlarm>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_A_HAlarm_Repository_GetAlarmsInStation, parms)) {
while (rdr.Read())
{
var entity = new A_HAlarm();
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.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]);
entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]);
entity.AlarmLevel = SqlTypeConverter.DBNullEnmLevelHandler(rdr["AlarmLevel"]);
entity.StartValue = SqlTypeConverter.DBNullDoubleHandler(rdr["StartValue"]);
entity.EndValue = SqlTypeConverter.DBNullDoubleHandler(rdr["EndValue"]);
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.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 <S_Room> GetRoomsInStation(string id)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <S_Room>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_S_Room_Repository_GetRoomsInStation, parms)) {
while (rdr.Read())
{
var entity = new S_Room();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = new C_RoomType {
Id = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]), Name = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeName"])
};
entity.Vendor = SqlTypeConverter.DBNullStringHandler(rdr["Vendor"]);
entity.Floor = SqlTypeConverter.DBNullInt32Handler(rdr["Floor"]);
entity.PropertyId = SqlTypeConverter.DBNullInt32Handler(rdr["PropertyId"]);
entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]);
entity.Length = SqlTypeConverter.DBNullStringHandler(rdr["Length"]);
entity.Width = SqlTypeConverter.DBNullStringHandler(rdr["Width"]);
entity.Heigth = SqlTypeConverter.DBNullStringHandler(rdr["Heigth"]);
entity.FloorLoad = SqlTypeConverter.DBNullStringHandler(rdr["FloorLoad"]);
entity.LineHeigth = SqlTypeConverter.DBNullStringHandler(rdr["LineHeigth"]);
entity.Square = SqlTypeConverter.DBNullStringHandler(rdr["Square"]);
entity.EffeSquare = SqlTypeConverter.DBNullStringHandler(rdr["EffeSquare"]);
entity.FireFighEuip = SqlTypeConverter.DBNullStringHandler(rdr["FireFighEuip"]);
entity.Owner = SqlTypeConverter.DBNullStringHandler(rdr["Owner"]);
entity.QueryPhone = SqlTypeConverter.DBNullStringHandler(rdr["QueryPhone"]);
entity.PowerSubMain = SqlTypeConverter.DBNullStringHandler(rdr["PowerSubMain"]);
entity.TranSubMain = SqlTypeConverter.DBNullStringHandler(rdr["TranSubMain"]);
entity.EnviSubMain = SqlTypeConverter.DBNullStringHandler(rdr["EnviSubMain"]);
entity.FireSubMain = SqlTypeConverter.DBNullStringHandler(rdr["FireSubMain"]);
entity.AirSubMain = SqlTypeConverter.DBNullStringHandler(rdr["AirSubMain"]);
entity.Contact = SqlTypeConverter.DBNullStringHandler(rdr["Contact"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public List <H_NoticeInUser> GetNoticesInUsers()
{
var entities = new List <H_NoticeInUser>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_H_NoticeInUser_Repository_GetNoticesInUsers, null)) {
while (rdr.Read())
{
var entity = new H_NoticeInUser();
entity.NoticeId = SqlTypeConverter.DBNullGuidHandler(rdr["NoticeId"]);
entity.UserId = SqlTypeConverter.DBNullStringHandler(rdr["UserId"]);
entity.Readed = SqlTypeConverter.DBNullBooleanHandler(rdr["Readed"]);
entity.ReadTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ReadTime"]);
entities.Add(entity);
}
}
return(entities);
}