public static async void TestReadAssetsWithManually(int count, bool outputEnabled = false) { Stopwatch stopwach = null; if (outputEnabled) { stopwach = new Stopwatch(); stopwach.Restart(); } using (var reader = GetReader("Asset", count)) { while (await reader.ReadAsync()) { var entity = new Models.Asset(); SetAsset(entity, reader); //for(var i = 0; i < reader.FieldCount; i++) //{ // var name = reader.GetName(i); // switch(name) // { // case "AssetId": // entity.AssetId = (ulong)reader[i]; // break; // case "AssetNo": // entity.AssetNo = (string)reader[i]; // break; // case "Name": // entity.Name = (string)reader[i]; // break; // case "Status": // entity.Status = (AssetStatus)reader[i]; // break; // } //} } } if (outputEnabled) { stopwach.Stop(); Console.WriteLine($"手动组装 {count} 条数据实体耗时 {stopwach.ElapsedMilliseconds} 毫秒。"); } }
private static void SetAsset(Models.Asset entity, IDataRecord record) { if (!record.IsDBNull(record.GetOrdinal("ActiveTime"))) { entity.ActiveTime = record.GetDateTime(record.GetOrdinal("ActiveTime")); } if (!record.IsDBNull(record.GetOrdinal("AddressDetail"))) { entity.AddressDetail = (string)record["AddressDetail"]; } if (!record.IsDBNull(record.GetOrdinal("AddressId"))) { entity.AddressId = (uint?)record["AddressId"]; } if (!record.IsDBNull(record.GetOrdinal("Altitude"))) { entity.Altitude = (short)record["Altitude"]; } if (!record.IsDBNull(record.GetOrdinal("Appearance"))) { entity.Appearance = (byte)record["Appearance"]; } if (!record.IsDBNull(record.GetOrdinal("AssetClassId"))) { entity.AssetClassId = (uint?)record["AssetClassId"]; } if (!record.IsDBNull(record.GetOrdinal("AssetId"))) { entity.AssetId = (ulong)record["AssetId"]; } if (!record.IsDBNull(record.GetOrdinal("AssetNo"))) { entity.AssetNo = (string)record["AssetNo"]; } if (!record.IsDBNull(record.GetOrdinal("AssetTypeId"))) { entity.AssetTypeId = (uint?)record["AssetTypeId"]; } if (!record.IsDBNull(record.GetOrdinal("AttachmentMark"))) { entity.AttachmentMark = (string)record["AttachmentMark"]; } if (!record.IsDBNull(record.GetOrdinal("Barcode"))) { entity.Barcode = (string)record["Barcode"]; } if (!record.IsDBNull(record.GetOrdinal("BranchId"))) { entity.BranchId = (ushort)record["BranchId"]; } if (!record.IsDBNull(record.GetOrdinal("CorporationId"))) { entity.CorporationId = (uint)record["CorporationId"]; } if (!record.IsDBNull(record.GetOrdinal("CreatedTime"))) { entity.CreatedTime = record.GetDateTime(record.GetOrdinal("CreatedTime")); } if (!record.IsDBNull(record.GetOrdinal("CreatorId"))) { entity.CreatorId = (uint)record["CreatorId"]; } if (!record.IsDBNull(record.GetOrdinal("DepartmentId"))) { entity.DepartmentId = (ushort?)record["DepartmentId"]; } if (!record.IsDBNull(record.GetOrdinal("ExaminationId"))) { entity.ExaminationId = (ulong?)record["ExaminationId"]; } if (!record.IsDBNull(record.GetOrdinal("ExaminationResultId"))) { entity.ExaminationResultId = (ulong?)record["ExaminationResultId"]; } if (!record.IsDBNull(record.GetOrdinal("Flags"))) { entity.Flags = (AssetFlags)record["Flags"]; } if (!record.IsDBNull(record.GetOrdinal("FlagsTimestamp"))) { entity.FlagsTimestamp = record.GetDateTime(record.GetOrdinal("FlagsTimestamp")); } if (!record.IsDBNull(record.GetOrdinal("Grade"))) { entity.Grade = (byte)record["Grade"]; } if (!record.IsDBNull(record.GetOrdinal("GradeDescription"))) { entity.GradeDescription = (string)record["GradeDescription"]; } if (!record.IsDBNull(record.GetOrdinal("Kind"))) { entity.Kind = (byte)record["Kind"]; } if (!record.IsDBNull(record.GetOrdinal("Latitude"))) { entity.Latitude = (decimal)record["Latitude"]; } if (!record.IsDBNull(record.GetOrdinal("Longitude"))) { entity.Longitude = (decimal)record["Longitude"]; } if (!record.IsDBNull(record.GetOrdinal("ManufacturedDate"))) { entity.ManufacturedDate = record.GetDateTime(record.GetOrdinal("ManufacturedDate")); } if (!record.IsDBNull(record.GetOrdinal("ManufacturerId"))) { entity.ManufacturerId = (uint?)record["ManufacturerId"]; } if (!record.IsDBNull(record.GetOrdinal("MeasuredDescription"))) { entity.MeasuredDescription = (string)record["MeasuredDescription"]; } if (!record.IsDBNull(record.GetOrdinal("MeasuredValue"))) { entity.MeasuredValue = (decimal)record["MeasuredValue"]; } if (!record.IsDBNull(record.GetOrdinal("Name"))) { entity.Name = (string)record["Name"]; } if (!record.IsDBNull(record.GetOrdinal("NameEx"))) { entity.NameEx = (string)record["NameEx"]; } if (!record.IsDBNull(record.GetOrdinal("OperatingVendorId"))) { entity.OperatingVendorId = (uint?)record["OperatingVendorId"]; } if (!record.IsDBNull(record.GetOrdinal("OperatingVendorName"))) { entity.OperatingVendorName = (string)record["OperatingVendorName"]; } if (!record.IsDBNull(record.GetOrdinal("OperatingVendorPhoneNumber"))) { entity.OperatingVendorPhoneNumber = (string)record["OperatingVendorPhoneNumber"]; } if (!record.IsDBNull(record.GetOrdinal("ParentId"))) { entity.ParentId = (ulong?)record["ParentId"]; } if (!record.IsDBNull(record.GetOrdinal("PinYin"))) { entity.PinYin = (string)record["PinYin"]; } if (!record.IsDBNull(record.GetOrdinal("PlaceId"))) { entity.PlaceId = (uint?)record["PlaceId"]; } if (!record.IsDBNull(record.GetOrdinal("PlatedTime"))) { entity.PlatedTime = record.GetDateTime(record.GetOrdinal("PlatedTime")); } if (!record.IsDBNull(record.GetOrdinal("PlateNo"))) { entity.PlateNo = (string)record["PlateNo"]; } if (!record.IsDBNull(record.GetOrdinal("PointId"))) { entity.PointId = (ulong)record["PointId"]; } if (!record.IsDBNull(record.GetOrdinal("Remark"))) { entity.Remark = (string)record["Remark"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedAmount1"))) { entity.ReservedAmount1 = (decimal)record["ReservedAmount1"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedAmount2"))) { entity.ReservedAmount2 = (decimal)record["ReservedAmount2"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedAmount3"))) { entity.ReservedAmount3 = (decimal)record["ReservedAmount3"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedAmount4"))) { entity.ReservedAmount4 = (decimal)record["ReservedAmount4"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedCount1"))) { entity.ReservedCount1 = (int)record["ReservedCount1"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedCount2"))) { entity.ReservedCount2 = (int)record["ReservedCount2"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedCount3"))) { entity.ReservedCount3 = (int)record["ReservedCount3"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedCount4"))) { entity.ReservedCount4 = (int)record["ReservedCount4"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedData"))) { entity.ReservedData = (string)record["ReservedData"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedText1"))) { entity.ReservedText1 = (string)record["ReservedText1"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedText2"))) { entity.ReservedText2 = (string)record["ReservedText2"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedText3"))) { entity.ReservedText3 = (string)record["ReservedText3"]; } if (!record.IsDBNull(record.GetOrdinal("ReservedText4"))) { entity.ReservedText4 = (string)record["ReservedText4"]; } if (!record.IsDBNull(record.GetOrdinal("ResponsibleId"))) { entity.ResponsibleId = (uint?)record["ResponsibleId"]; } if (!record.IsDBNull(record.GetOrdinal("ResponsibleName"))) { entity.ResponsibleName = (string)record["ResponsibleName"]; } if (!record.IsDBNull(record.GetOrdinal("ResponsiblePhoneNumber"))) { entity.ResponsiblePhoneNumber = (string)record["ResponsiblePhoneNumber"]; } if (!record.IsDBNull(record.GetOrdinal("Schema"))) { entity.Schema = (string)record["Schema"]; } if (!record.IsDBNull(record.GetOrdinal("Score"))) { entity.Score = (byte)record["Score"]; } if (!record.IsDBNull(record.GetOrdinal("ScoringTimestamp"))) { entity.ScoringTimestamp = record.GetDateTime(record.GetOrdinal("ScoringTimestamp")); } if (!record.IsDBNull(record.GetOrdinal("Size"))) { entity.Size = (decimal)record["Size"]; } if (!record.IsDBNull(record.GetOrdinal("Source"))) { entity.Source = (AssetSource)record["Source"]; } if (!record.IsDBNull(record.GetOrdinal("Spec"))) { entity.Spec = (string)record["Spec"]; } if (!record.IsDBNull(record.GetOrdinal("Status"))) { entity.Status = (AssetStatus)record["Status"]; } if (!record.IsDBNull(record.GetOrdinal("StatusDescription"))) { entity.StatusDescription = (string)record["StatusDescription"]; } if (!record.IsDBNull(record.GetOrdinal("StatusTimestamp"))) { entity.StatusTimestamp = record.GetDateTime(record.GetOrdinal("StatusTimestamp")); } if (!record.IsDBNull(record.GetOrdinal("SummaryPath"))) { entity.SummaryPath = (string)record["SummaryPath"]; } if (!record.IsDBNull(record.GetOrdinal("Tags"))) { entity.Tags = (string)record["Tags"]; } if (!record.IsDBNull(record.GetOrdinal("Village"))) { entity.Village = (string)record["Village"]; } if (!record.IsDBNull(record.GetOrdinal("Visible"))) { entity.Visible = (bool)record["Visible"]; } }