public IList<Core.Business.Enterprise> GetAllEnterprise() { IList<Core.Business.Enterprise> enterpriselist = new List<Core.Business.Enterprise>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllEnterprise); if(reader != null) { while(reader.Read()) { Core.Business.Enterprise enterprise = new Core.Business.Enterprise(); if (!reader.IsDBNull(0)) enterprise.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) enterprise.EntCode = reader.GetString(1); if (!reader.IsDBNull(2)) enterprise.Name = reader.GetString(2); if (!reader.IsDBNull(3)) enterprise.EntCate = reader.GetString(3); if (!reader.IsDBNull(4)) enterprise.EntCaptial = reader.GetDecimal(4); if (!reader.IsDBNull(5)) enterprise.Phone = reader.GetString(5); if (!reader.IsDBNull(6)) enterprise.Email = reader.GetString(6); if (!reader.IsDBNull(7)) enterprise.Address = reader.GetString(7); if (!reader.IsDBNull(8)) enterprise.InCharge = reader.GetString(8); if (!reader.IsDBNull(9)) enterprise.AddDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) enterprise.AddPersonCode = reader.GetString(10); if (!reader.IsDBNull(11)) enterprise.DepartmentCode = reader.GetString(11); if (!reader.IsDBNull(12)) enterprise.MajorTypesWork = reader.GetString(12); if (!reader.IsDBNull(13)) enterprise.WebSite = reader.GetString(13); if (!reader.IsDBNull(14)) enterprise.Positions = reader.GetString(14); enterprise.MarkOld(); enterpriselist.Add(enterprise); } reader.Close(); } return enterpriselist; }
public IList<Core.Business.Enterprise> GetEnterpriseListByQueryString(string wherestr) { IList<Core.Business.Enterprise> enterpriselist = new List<Core.Business.Enterprise>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder querystring = new StringBuilder(); querystring.Append(SqlGetEnterpriseLisByQueryString); if (!string.IsNullOrEmpty(wherestr)) { querystring.Append(" WHERE "); querystring.Append(" " + wherestr + " "); } SqlDataReader reader = sql.ExecuteSqlReader(querystring.ToString()); if (reader != null) { while (reader.Read()) { Core.Business.Enterprise enterprise = new Core.Business.Enterprise(); if (!reader.IsDBNull(0)) enterprise.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) enterprise.EntCode = reader.GetString(1); if (!reader.IsDBNull(2)) enterprise.Name = reader.GetString(2); if (!reader.IsDBNull(3)) enterprise.EntCate = reader.GetString(3); if (!reader.IsDBNull(4)) enterprise.EntCaptial = reader.GetDecimal(4); if (!reader.IsDBNull(5)) enterprise.Phone = reader.GetString(5); if (!reader.IsDBNull(6)) enterprise.Email = reader.GetString(6); if (!reader.IsDBNull(7)) enterprise.Address = reader.GetString(7); if (!reader.IsDBNull(8)) enterprise.InCharge = reader.GetString(8); if (!reader.IsDBNull(9)) enterprise.AddDate = reader.GetDateTime(9); if (!reader.IsDBNull(10)) enterprise.AddPersonCode = reader.GetString(10); if (!reader.IsDBNull(11)) enterprise.DepartmentCode = reader.GetString(11); if (!reader.IsDBNull(12)) enterprise.MajorTypesWork = reader.GetString(12); if (!reader.IsDBNull(13)) enterprise.WebSite = reader.GetString(13); if (!reader.IsDBNull(14)) enterprise.Positions = reader.GetString(14); enterprise.MarkOld(); enterpriselist.Add(enterprise); } reader.Close(); } else return null; return enterpriselist; }