public LandTypeInfo LandTypeInfoIDataReader(IDataReader dr) { LandTypeInfo obj = new DataAccess.LandTypeInfo(); obj.LandTypeID = (dr["LandTypeID"] is DBNull) ? string.Empty : dr["LandTypeID"].ToString(); obj.LandTypeName = (dr["LandTypeName"] is DBNull) ? string.Empty : dr["LandTypeName"].ToString(); return(obj); }
public List <LandTypeInfo> LandTypeInfo_GetByAll() { List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>(); DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("Group_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.LandTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <LandTypeInfo> LandTypeInfo_GetByLevel(string Level, int LevelLength) { List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>(); DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_LandTypeInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.LandTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <LandTypeInfo> LandTypeInfo_Paging(string CurentLandTypeInfo, string LandTypeInfoSize) { List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>(); DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo(); DbCommand cmd = db.GetStoredProcCommand("Group_SelectPage", CurentLandTypeInfo, LandTypeInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.LandTypeInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }