public List <D_ExtFsu> GetExtFsus()
{
var entities = new List <D_ExtFsu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetExtFsus, null)) {
while (rdr.Read())
{
var entity = new D_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"]);
entity.GroupId = SqlTypeConverter.DBNullStringHandler(rdr["GroupId"]);
entity.UpgradeStatus = SqlTypeConverter.DBNullUpgradeStatusHandler(rdr["UpgradeStatus"]);
entity.UpgradeResult = SqlTypeConverter.DBNullStringHandler(rdr["UpgradeResult"]);
entity.UpgradeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpgradeTime"]);
entity.Upgrader = SqlTypeConverter.DBNullStringHandler(rdr["Upgrader"]);
entities.Add(entity);
}
}
return(entities);
}
public D_ExtFsu GetExtFsu(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
D_ExtFsu entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetExtFsu, parms)) {
if (rdr.Read())
{
entity = new D_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"]);
entity.GroupId = SqlTypeConverter.DBNullStringHandler(rdr["GroupId"]);
entity.UpgradeStatus = SqlTypeConverter.DBNullUpgradeStatusHandler(rdr["UpgradeStatus"]);
entity.UpgradeResult = SqlTypeConverter.DBNullStringHandler(rdr["UpgradeResult"]);
entity.UpgradeTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpgradeTime"]);
entity.Upgrader = SqlTypeConverter.DBNullStringHandler(rdr["Upgrader"]);
}
}
return(entity);
}
