public DistrictInfo DistrictInfoIDataReader(IDataReader dr)
{
DistrictInfo obj = new DataAccess.DistrictInfo();
obj.DistrictID = (dr["DistrictID"] is DBNull) ? string.Empty : dr["DistrictID"].ToString();
obj.CityCode = (dr["CityCode"] is DBNull) ? string.Empty : dr["CityCode"].ToString();
obj.DistrictCode = (dr["DistrictCode"] is DBNull) ? string.Empty : dr["DistrictCode"].ToString();
obj.DistrictName = (dr["DistrictName"] is DBNull) ? string.Empty : dr["DistrictName"].ToString();
return(obj);
}
public List <DistrictInfo> DistrictInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.DistrictInfo> list = new List <DataAccess.DistrictInfo>();
DataAccess.DistrictInfo obj = new DataAccess.DistrictInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_DistrictInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.DistrictInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <DistrictInfo> DistrictInfo_GetByAll()
{
List <DataAccess.DistrictInfo> list = new List <DataAccess.DistrictInfo>();
DataAccess.DistrictInfo obj = new DataAccess.DistrictInfo();
DbCommand cmd = db.GetStoredProcCommand("District_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.DistrictInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <DistrictInfo> DistrictInfo_Paging(string CurentDistrictInfo, string DistrictInfoSize)
{
List <DataAccess.DistrictInfo> list = new List <DataAccess.DistrictInfo>();
DataAccess.DistrictInfo obj = new DataAccess.DistrictInfo();
DbCommand cmd = db.GetStoredProcCommand("District_SelectPage", CurentDistrictInfo, DistrictInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.DistrictInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
