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