public Support SupportIDataReader(IDataReader dr) { DataAccess.Support obj = new DataAccess.Support(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Tel = (dr["Tel"] is DBNull) ? string.Empty : dr["Tel"].ToString(); obj.Type = (dr["Type"] is DBNull) ? string.Empty : dr["Type"].ToString(); obj.Nick = (dr["Nick"] is DBNull) ? string.Empty : dr["Nick"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.GroupSupportId = (dr["GroupSupportId"] is DBNull) ? string.Empty : dr["GroupSupportId"].ToString(); obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString(); obj.Location = (dr["Location"] is DBNull) ? string.Empty : dr["Location"].ToString(); return(obj); }
public List <Support> Support_GetByAll(string Lang) { List <DataAccess.Support> list = new List <DataAccess.Support>(); DataAccess.Support obj = new DataAccess.Support(); DbCommand cmd = db.GetStoredProcCommand("sp_Support_GetByAll", Lang); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.SupportIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }