public IList<Core.Business.UnitInfo> GetAllUnitInfo() { IList<Core.Business.UnitInfo> unitInfolist = new List<Core.Business.UnitInfo>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitInfosAll"); if (reader != null) { while (reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.Name = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.SuperUnit = reader.GetGuid(2); if (!reader.IsDBNull(3)) unitInfo.Place = reader.GetString(3); if (!reader.IsDBNull(4)) unitInfo.UnitSign = reader.GetString(4); if (!reader.IsDBNull(5)) unitInfo.UnitPostCode = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.UnitPhone = reader.GetString(6); unitInfo.MarkOld(); unitInfolist.Add(unitInfo); } reader.Close(); } return unitInfolist; }
public Core.Business.UnitInfo Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Code", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitInfo"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.Name = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.SuperUnit = reader.GetGuid(2); if (!reader.IsDBNull(3)) unitInfo.Place = reader.GetString(3); if (!reader.IsDBNull(4)) unitInfo.UnitSign = reader.GetString(4); if (!reader.IsDBNull(5)) unitInfo.UnitPostCode = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.UnitPhone = reader.GetString(6); reader.Close(); return unitInfo; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Core.Business.UnitInfo Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitInfo"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.UnitName = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.Alias = reader.GetString(2); if (!reader.IsDBNull(3)) unitInfo.ProvinceID = reader.GetGuid(3); if (!reader.IsDBNull(4)) unitInfo.CityID = reader.GetGuid(4); if (!reader.IsDBNull(5)) unitInfo.Address = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.Postalcode = reader.GetString(6); if (!reader.IsDBNull(7)) unitInfo.Tel = reader.GetString(7); if (!reader.IsDBNull(8)) unitInfo.Fax = reader.GetString(8); if (!reader.IsDBNull(9)) unitInfo.Website = reader.GetString(9); if (!reader.IsDBNull(10)) unitInfo.Email = reader.GetString(10); if (!reader.IsDBNull(11)) unitInfo.UnitType = reader.GetGuid(11); if (!reader.IsDBNull(12)) unitInfo.Ownership = reader.GetString(12); if (!reader.IsDBNull(13)) unitInfo.DrtificialPerson = reader.GetString(13); if (!reader.IsDBNull(14)) unitInfo.DrtificialPersonDutyID = reader.GetGuid(14); if (!reader.IsDBNull(15)) unitInfo.DrtificialPersonTel = reader.GetString(15); if (!reader.IsDBNull(16)) unitInfo.LinkDepartdement = reader.GetString(16); if (!reader.IsDBNull(17)) unitInfo.Linkman = reader.GetString(17); if (!reader.IsDBNull(18)) unitInfo.LinkmanDutyID = reader.GetGuid(18); if (!reader.IsDBNull(19)) unitInfo.LinkmanTel = reader.GetString(19); if (!reader.IsDBNull(20)) unitInfo.ChargeDepartMent = reader.GetString(20); if (!reader.IsDBNull(21)) unitInfo.BankAccountName = reader.GetString(21); if (!reader.IsDBNull(22)) unitInfo.BankName = reader.GetString(22); if (!reader.IsDBNull(23)) unitInfo.BankAccount = reader.GetString(23); if (!reader.IsDBNull(24)) unitInfo.Certificate = reader.GetString(24); if (!reader.IsDBNull(25)) unitInfo.Rel_certificate = reader.GetString(25); if (!reader.IsDBNull(26)) unitInfo.WorkCode = reader.GetString(26); if (!reader.IsDBNull(27)) unitInfo.Synopsis = reader.GetString(27); if (!reader.IsDBNull(28)) unitInfo.InstrumentSection = reader.GetString(28); if (!reader.IsDBNull(29)) unitInfo.VindicatorCount = reader.GetInt32(29); if (!reader.IsDBNull(30)) unitInfo.Subjection = reader.GetInt32(30); if (!reader.IsDBNull(31)) unitInfo.TradeSortID = reader.GetGuid(31); if (!reader.IsDBNull(32)) unitInfo.IsModification = reader.GetInt32(32); if (!reader.IsDBNull(33)) unitInfo.IsCooperantUnit = reader.GetInt32(33); if (!reader.IsDBNull(34)) unitInfo.Operation = reader.GetString(34); if (!reader.IsDBNull(35)) unitInfo.Remark = reader.GetString(35); if (!reader.IsDBNull(36)) unitInfo.InstrumentCount = reader.GetInt32(36); if (!reader.IsDBNull(37)) unitInfo.InfoDutyDepartment = reader.GetString(37); if (!reader.IsDBNull(38)) unitInfo.AuditingState = reader.GetInt32(38); if (!reader.IsDBNull(39)) unitInfo.Assessor = reader.GetString(39); if (!reader.IsDBNull(40)) unitInfo.AuditingDate = reader.GetDateTime(40); if (!reader.IsDBNull(41)) unitInfo.CreatDate = reader.GetDateTime(41); if (!reader.IsDBNull(42)) unitInfo.UpdateDate = reader.GetDateTime(42); if (!reader.IsDBNull(43)) unitInfo.Annex = reader.GetInt32(43); if (!reader.IsDBNull(44)) unitInfo.UnitInWorkPerson = reader.GetGuid(44); if (!reader.IsDBNull(45)) unitInfo.UnitApplicationUserType = reader.GetInt32(45); if (!reader.IsDBNull(46)) unitInfo.Count = reader.GetInt64(46); reader.Close(); unitInfo.MarkOld(); return unitInfo; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IEnumerable<UnitInfo> SearchUnitUnPaged(UnitSearchJsonPatch json) { try { if (json == null) throw new ArgumentException("json or pageinfo is null "); IList<Core.Business.UnitInfo> unitInfolist = new List<Core.Business.UnitInfo>(); SqlServerUtility sql = new SqlServerUtility(); if (!string.IsNullOrEmpty(json.Name)) { sql.AddParameter("@name", SqlDbType.NVarChar, json.Name); } if (!string.IsNullOrEmpty(json.Alias)) { sql.AddParameter("@alias", SqlDbType.NVarChar, json.Alias); } if (json.Province != null) { sql.AddParameter("@province", SqlDbType.UniqueIdentifier, json.Province.Value); } if (json.City != null) { sql.AddParameter("@city", SqlDbType.UniqueIdentifier, json.City.Value); } if (json.IsCorp != null) { sql.AddParameter("@iscorp", SqlDbType.Int, json.IsCorp.Value); } if (json.UnitType != null) { sql.AddParameter("@unittype", SqlDbType.UniqueIdentifier, json.UnitType.Value); } if (json.TradeSort != null) { sql.AddParameter("@tradesort", SqlDbType.UniqueIdentifier, json.TradeSort.Value); } if (json.StartAuditingDate != null) { sql.AddParameter("@startauditdate", SqlDbType.DateTime, json.StartAuditingDate.Value); } if (json.EndAuditingDate != null) { sql.AddParameter("@endauditdate", SqlDbType.DateTime, json.EndAuditingDate.Value); } if (json.State != null) { sql.AddParameter("@state", SqlDbType.Int, json.State.Value); } SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitUnPaged"); if (reader != null) { while (reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.UnitName = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.Alias = reader.GetString(2); if (!reader.IsDBNull(3)) unitInfo.ProvinceID = reader.GetGuid(3); if (!reader.IsDBNull(4)) unitInfo.CityID = reader.GetGuid(4); if (!reader.IsDBNull(5)) unitInfo.Address = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.Postalcode = reader.GetString(6); if (!reader.IsDBNull(7)) unitInfo.Tel = reader.GetString(7); if (!reader.IsDBNull(8)) unitInfo.Fax = reader.GetString(8); if (!reader.IsDBNull(9)) unitInfo.Website = reader.GetString(9); if (!reader.IsDBNull(10)) unitInfo.Email = reader.GetString(10); if (!reader.IsDBNull(11)) unitInfo.UnitType = reader.GetGuid(11); if (!reader.IsDBNull(12)) unitInfo.Ownership = reader.GetString(12); if (!reader.IsDBNull(13)) unitInfo.DrtificialPerson = reader.GetString(13); if (!reader.IsDBNull(14)) unitInfo.DrtificialPersonDutyID = reader.GetGuid(14); if (!reader.IsDBNull(15)) unitInfo.DrtificialPersonTel = reader.GetString(15); if (!reader.IsDBNull(16)) unitInfo.LinkDepartdement = reader.GetString(16); if (!reader.IsDBNull(17)) unitInfo.Linkman = reader.GetString(17); if (!reader.IsDBNull(18)) unitInfo.LinkmanDutyID = reader.GetGuid(18); if (!reader.IsDBNull(19)) unitInfo.LinkmanTel = reader.GetString(19); if (!reader.IsDBNull(20)) unitInfo.ChargeDepartMent = reader.GetString(20); if (!reader.IsDBNull(21)) unitInfo.BankAccountName = reader.GetString(21); if (!reader.IsDBNull(22)) unitInfo.BankName = reader.GetString(22); if (!reader.IsDBNull(23)) unitInfo.BankAccount = reader.GetString(23); if (!reader.IsDBNull(24)) unitInfo.Certificate = reader.GetString(24); if (!reader.IsDBNull(25)) unitInfo.Rel_certificate = reader.GetString(25); if (!reader.IsDBNull(26)) unitInfo.WorkCode = reader.GetString(26); if (!reader.IsDBNull(27)) unitInfo.Synopsis = reader.GetString(27); if (!reader.IsDBNull(28)) unitInfo.InstrumentSection = reader.GetString(28); if (!reader.IsDBNull(29)) unitInfo.VindicatorCount = reader.GetInt32(29); if (!reader.IsDBNull(30)) unitInfo.Subjection = reader.GetInt32(30); if (!reader.IsDBNull(31)) unitInfo.TradeSortID = reader.GetGuid(31); if (!reader.IsDBNull(32)) unitInfo.IsModification = reader.GetInt32(32); if (!reader.IsDBNull(33)) unitInfo.IsCooperantUnit = reader.GetInt32(33); if (!reader.IsDBNull(34)) unitInfo.Operation = reader.GetString(34); if (!reader.IsDBNull(35)) unitInfo.Remark = reader.GetString(35); if (!reader.IsDBNull(36)) unitInfo.InstrumentCount = reader.GetInt32(36); if (!reader.IsDBNull(37)) unitInfo.InfoDutyDepartment = reader.GetString(37); if (!reader.IsDBNull(38)) unitInfo.AuditingState = reader.GetInt32(38); if (!reader.IsDBNull(39)) unitInfo.Assessor = reader.GetString(39); if (!reader.IsDBNull(40)) unitInfo.AuditingDate = reader.GetDateTime(40); if (!reader.IsDBNull(41)) unitInfo.CreatDate = reader.GetDateTime(41); if (!reader.IsDBNull(42)) unitInfo.UpdateDate = reader.GetDateTime(42); if (!reader.IsDBNull(43)) unitInfo.Annex = reader.GetInt32(43); if (!reader.IsDBNull(44)) unitInfo.UnitInWorkPerson = reader.GetGuid(44); if (!reader.IsDBNull(45)) unitInfo.UnitApplicationUserType = reader.GetInt32(45); if (!reader.IsDBNull(46)) unitInfo.Count = reader.GetInt64(46); unitInfo.MarkOld(); unitInfolist.Add(unitInfo); } reader.Close(); } return unitInfolist; } catch (Exception ex) { throw ex; } }
public IEnumerable<UnitInfo> GetUnitInfoRandom() { IList<Core.Business.UnitInfo> unitInfolist = new List<Core.Business.UnitInfo>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(Sql_PickUpRandom); if (reader != null) { while (reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.UnitName = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.Alias = reader.GetString(2); if (!reader.IsDBNull(3)) unitInfo.ProvinceID = reader.GetGuid(3); if (!reader.IsDBNull(4)) unitInfo.CityID = reader.GetGuid(4); if (!reader.IsDBNull(5)) unitInfo.Address = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.Postalcode = reader.GetString(6); if (!reader.IsDBNull(7)) unitInfo.Tel = reader.GetString(7); if (!reader.IsDBNull(8)) unitInfo.Fax = reader.GetString(8); if (!reader.IsDBNull(9)) unitInfo.Website = reader.GetString(9); if (!reader.IsDBNull(10)) unitInfo.Email = reader.GetString(10); if (!reader.IsDBNull(11)) unitInfo.UnitType = reader.GetGuid(11); if (!reader.IsDBNull(12)) unitInfo.Ownership = reader.GetString(12); if (!reader.IsDBNull(13)) unitInfo.DrtificialPerson = reader.GetString(13); if (!reader.IsDBNull(14)) unitInfo.DrtificialPersonDutyID = reader.GetGuid(14); if (!reader.IsDBNull(15)) unitInfo.DrtificialPersonTel = reader.GetString(15); if (!reader.IsDBNull(16)) unitInfo.LinkDepartdement = reader.GetString(16); if (!reader.IsDBNull(17)) unitInfo.Linkman = reader.GetString(17); if (!reader.IsDBNull(18)) unitInfo.LinkmanDutyID = reader.GetGuid(18); if (!reader.IsDBNull(19)) unitInfo.LinkmanTel = reader.GetString(19); if (!reader.IsDBNull(20)) unitInfo.ChargeDepartMent = reader.GetString(20); if (!reader.IsDBNull(21)) unitInfo.BankAccountName = reader.GetString(21); if (!reader.IsDBNull(22)) unitInfo.BankName = reader.GetString(22); if (!reader.IsDBNull(23)) unitInfo.BankAccount = reader.GetString(23); if (!reader.IsDBNull(24)) unitInfo.Certificate = reader.GetString(24); if (!reader.IsDBNull(25)) unitInfo.Rel_certificate = reader.GetString(25); if (!reader.IsDBNull(26)) unitInfo.WorkCode = reader.GetString(26); if (!reader.IsDBNull(27)) unitInfo.Synopsis = reader.GetString(27); if (!reader.IsDBNull(28)) unitInfo.InstrumentSection = reader.GetString(28); if (!reader.IsDBNull(29)) unitInfo.VindicatorCount = reader.GetInt32(29); if (!reader.IsDBNull(30)) unitInfo.Subjection = reader.GetInt32(30); if (!reader.IsDBNull(31)) unitInfo.TradeSortID = reader.GetGuid(31); if (!reader.IsDBNull(32)) unitInfo.IsModification = reader.GetInt32(32); if (!reader.IsDBNull(33)) unitInfo.IsCooperantUnit = reader.GetInt32(33); if (!reader.IsDBNull(34)) unitInfo.Operation = reader.GetString(34); if (!reader.IsDBNull(35)) unitInfo.Remark = reader.GetString(35); if (!reader.IsDBNull(36)) unitInfo.InstrumentCount = reader.GetInt32(36); if (!reader.IsDBNull(37)) unitInfo.InfoDutyDepartment = reader.GetString(37); if (!reader.IsDBNull(38)) unitInfo.AuditingState = reader.GetInt32(38); if (!reader.IsDBNull(39)) unitInfo.Assessor = reader.GetString(39); if (!reader.IsDBNull(40)) unitInfo.AuditingDate = reader.GetDateTime(40); if (!reader.IsDBNull(41)) unitInfo.CreatDate = reader.GetDateTime(41); if (!reader.IsDBNull(42)) unitInfo.UpdateDate = reader.GetDateTime(42); if (!reader.IsDBNull(43)) unitInfo.Annex = reader.GetInt32(43); if (!reader.IsDBNull(44)) unitInfo.UnitInWorkPerson = reader.GetGuid(44); if (!reader.IsDBNull(45)) unitInfo.UnitApplicationUserType = reader.GetInt32(45); if (!reader.IsDBNull(46)) unitInfo.Count = reader.GetInt64(46); unitInfo.MarkOld(); unitInfolist.Add(unitInfo); } reader.Close(); } return unitInfolist; }
public List<UnitInfo> SelectUnitInfosDynamic(string whereCondition, string orderExpression) { if (string.IsNullOrEmpty(whereCondition)) { return this.GetAllUnitInfo() as List<UnitInfo>; } List<Core.Business.UnitInfo> unitInfolist = new List<Core.Business.UnitInfo>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderExpression); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitInfosDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo(); if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) unitInfo.UnitName = reader.GetString(1); if (!reader.IsDBNull(2)) unitInfo.Alias = reader.GetString(2); if (!reader.IsDBNull(3)) unitInfo.ProvinceID = reader.GetGuid(3); if (!reader.IsDBNull(4)) unitInfo.CityID = reader.GetGuid(4); if (!reader.IsDBNull(5)) unitInfo.Address = reader.GetString(5); if (!reader.IsDBNull(6)) unitInfo.Postalcode = reader.GetString(6); if (!reader.IsDBNull(7)) unitInfo.Tel = reader.GetString(7); if (!reader.IsDBNull(8)) unitInfo.Fax = reader.GetString(8); if (!reader.IsDBNull(9)) unitInfo.Website = reader.GetString(9); if (!reader.IsDBNull(10)) unitInfo.Email = reader.GetString(10); if (!reader.IsDBNull(11)) unitInfo.UnitType = reader.GetGuid(11); if (!reader.IsDBNull(12)) unitInfo.Ownership = reader.GetString(12); if (!reader.IsDBNull(13)) unitInfo.DrtificialPerson = reader.GetString(13); if (!reader.IsDBNull(14)) unitInfo.DrtificialPersonDutyID = reader.GetGuid(14); if (!reader.IsDBNull(15)) unitInfo.DrtificialPersonTel = reader.GetString(15); if (!reader.IsDBNull(16)) unitInfo.LinkDepartdement = reader.GetString(16); if (!reader.IsDBNull(17)) unitInfo.Linkman = reader.GetString(17); if (!reader.IsDBNull(18)) unitInfo.LinkmanDutyID = reader.GetGuid(18); if (!reader.IsDBNull(19)) unitInfo.LinkmanTel = reader.GetString(19); if (!reader.IsDBNull(20)) unitInfo.ChargeDepartMent = reader.GetString(20); if (!reader.IsDBNull(21)) unitInfo.BankAccountName = reader.GetString(21); if (!reader.IsDBNull(22)) unitInfo.BankName = reader.GetString(22); if (!reader.IsDBNull(23)) unitInfo.BankAccount = reader.GetString(23); if (!reader.IsDBNull(24)) unitInfo.Certificate = reader.GetString(24); if (!reader.IsDBNull(25)) unitInfo.Rel_certificate = reader.GetString(25); if (!reader.IsDBNull(26)) unitInfo.WorkCode = reader.GetString(26); if (!reader.IsDBNull(27)) unitInfo.Synopsis = reader.GetString(27); if (!reader.IsDBNull(28)) unitInfo.InstrumentSection = reader.GetString(28); if (!reader.IsDBNull(29)) unitInfo.VindicatorCount = reader.GetInt32(29); if (!reader.IsDBNull(30)) unitInfo.Subjection = reader.GetInt32(30); if (!reader.IsDBNull(31)) unitInfo.TradeSortID = reader.GetGuid(31); if (!reader.IsDBNull(32)) unitInfo.IsModification = reader.GetInt32(32); if (!reader.IsDBNull(33)) unitInfo.IsCooperantUnit = reader.GetInt32(33); if (!reader.IsDBNull(34)) unitInfo.Operation = reader.GetString(34); if (!reader.IsDBNull(35)) unitInfo.Remark = reader.GetString(35); if (!reader.IsDBNull(36)) unitInfo.InstrumentCount = reader.GetInt32(36); if (!reader.IsDBNull(37)) unitInfo.InfoDutyDepartment = reader.GetString(37); if (!reader.IsDBNull(38)) unitInfo.AuditingState = reader.GetInt32(38); if (!reader.IsDBNull(39)) unitInfo.Assessor = reader.GetString(39); if (!reader.IsDBNull(40)) unitInfo.AuditingDate = reader.GetDateTime(40); if (!reader.IsDBNull(41)) unitInfo.CreatDate = reader.GetDateTime(41); if (!reader.IsDBNull(42)) unitInfo.UpdateDate = reader.GetDateTime(42); if (!reader.IsDBNull(43)) unitInfo.Annex = reader.GetInt32(43); if (!reader.IsDBNull(44)) unitInfo.UnitInWorkPerson = reader.GetGuid(44); if (!reader.IsDBNull(45)) unitInfo.UnitApplicationUserType = reader.GetInt32(45); if (!reader.IsDBNull(46)) unitInfo.Count = reader.GetInt64(46); unitInfo.MarkOld(); unitInfolist.Add(unitInfo); } reader.Close(); } return unitInfolist; }