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