protected override IEnumerable <VHISPLANINFO> GetDataFromSourdeDb(OracleTableMaxId maxId)
{
var type = typeof(VHISPLANINFO);
var specialColumn = "MOBILENUMBER4";
var selectColumns = string.Join(",", type.GetProperties().Select(p => p.Name))
.Replace(specialColumn, $"ROWNUM AS {specialColumn}");
var condition = maxId == null ? string.Empty : $"WHERE {specialColumn}>{maxId.MaxId}";
var sql = $"SELECT * FROM (SELECT {selectColumns} FROM {nameof(VHISPLANINFO)}) {condition}";
return(OracleBaseBll.QueryBySql(sql));
}
