public List <ZcZoning> FindAll()
{
List <ZcZoning> list = new List <ZcZoning>();
OracleConnection conn = null;
try
{
conn = OracleUtil.OpenConn();
string sql = "select * from ZC_ZONING";
OracleCommand command = new OracleCommand(sql);
command.Connection = conn;
var reader = command.ExecuteReader();
while (reader.Read())
{
ZcZoning obj = new ZcZoning();
obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
obj.City = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
obj.County = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
obj.Province = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
obj.Street = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
list.Add(obj);
}
}
catch (Exception ex)
{
log.Error("下载全部数据失败", ex);
}
finally
{
OracleUtil.CloseConn(conn);
}
return(list);
}
public List <ZcZoning> FindUpdate(DateTime lastUpdate)
{
List <ZcZoning> list = new List <ZcZoning>();
string sql = "select * from zc_zoning where updatetime > :last";
OracleConnection conn = null;
OracleCommand cmd = new OracleCommand();
try
{
conn = OracleUtil.OpenConn();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.Parameters.Add(":last", lastUpdate);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ZcZoning obj = new ZcZoning();
obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
obj.City = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
obj.County = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
obj.Province = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
obj.Street = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
list.Add(obj);
}
}
catch (Exception ex)
{
log.Error("下载区域更新的数据失败", ex);
}
finally
{
cmd.Dispose();
OracleUtil.CloseConn(conn);
}
return(list);
}
