public EmergentOrder QueryEmergentOrder(decimal id, OrderIdType orderIdType) { string sql = "SELECT Id,[Type],Content,[Time],Account,OrderIdType FROM T_EmergentOrder WHERE Id=@Id AND OrderIdType =@OrderIdType"; EmergentOrder result = null; using (DbOperator dboperator = new DbOperator(Provider, ConnectionString)) { dboperator.AddParameter("Id", id); dboperator.AddParameter("OrderIdType", orderIdType); using (System.Data.Common.DbDataReader reader = dboperator.ExecuteReader(sql)) { if (reader.Read()) { result = new EmergentOrder(); result.Id = reader.GetDecimal(0); result.Type = (OrderStatus)reader.GetInt32(1); result.Content = reader.GetString(2); result.Time = reader.GetDateTime(3); result.Account = reader.GetString(4); result.OrderIdTypeValue = (OrderIdType)reader.GetByte(5); } } } return(result); }
public SignalProp getCurSigProp() { SignalProp prop = null; String sql = " SELECT s.lampId, s.signalName, s.type, s.state, c.state as specState, direction, dir_to, s.ip FROM cursignal c LEFT JOIN signal s ON c.lampId=s.lampId AND c.type=1 "; MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn); System.Data.Common.DbDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { prop = new SignalProp(); prop.SignalID = reader.GetString(0).ToUpper(); prop.SignalName = DBStringToNormal(reader.GetString(1)); prop.Type = reader.IsDBNull(2)? (byte)0 : (byte)reader.GetInt16(2); prop.State = reader.GetString(3); prop.SpecState = reader.IsDBNull(4) ? (byte)0 : (byte)reader.GetInt16(4); prop.DirFrom = reader.IsDBNull(5) ? (byte)0 : (byte)reader.GetInt16(5); prop.DirTo = reader.IsDBNull(6) ? (byte)0 : (byte)reader.GetInt16(6); prop.Ip = reader.GetString(7); } reader.Close(); } catch (Exception e) { reader.Close(); Trace.TraceError("get cur signal prop " + e.StackTrace); } return(prop); }
public void frun() { try { using (SqlConnection connection = new SqlConnection("")) { connection.ConnectionString = @"Data Source=192.168.56.101,1433\SQLEXPRESS;Initial Catalog=mybase;Persist Security Info=True;User ID=User01;Password=User001"; connection.Open(); string text = "SELECT users.name, users.login, users.password, users.isadmin, users.id FROM users where users.id=" + this.id.ToString(); using (SqlCommand command = new SqlCommand(text, connection)) using (System.Data.Common.DbDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); textBox1.Text = reader.GetString(0); textBox2.Text = reader.GetString(1); textBox3.Text = reader.GetString(2); int i = reader.GetInt32(3); textBox4.Text = "Нет"; if (i == 1) { textBox4.Text = "Да"; } } } connection.Close(); } } catch (Exception ex) { MessageBox.Show("Ошибка работы с базой данных " + ex); } }
private async void ReadCommands() { try { MySqlCommand readCommands = new MySqlCommand("SELECT command,target,status FROM COMMANDS WHERE target = '" + ProgramOptions.LoggedInUser.Nick + "' AND status = 'start' LIMIT 1;", DataReaderMySQLConnection); System.Data.Common.DbDataReader reader = await readCommands.ExecuteReaderAsync(); while ((isReadingCommands = await reader.ReadAsync()) == true) { if (reader.GetString(2) == "start" && (reader.GetString(0) == "kicked" || reader.GetString(0) == "banned")) { MySqlCommand updateCommand = new MySqlCommand("START TRANSACTION; UPDATE COMMANDS SET status = 'finished' WHERE target = '" + ProgramOptions.LoggedInUser.Nick + "'; COMMIT; ", DataManipulationMySQLConnection); await updateCommand.ExecuteNonQueryAsync(); MessageBox.Show("You were " + reader.GetString(0) + " from the server!"); this.Close(); } } reader.Close(); } catch (Exception mysqlException) { if (mysqlException is MySqlException) { System.Diagnostics.Debug.WriteLine("Exception thrown in ReadCommandsAsync; Not harmful; " + mysqlException.ToString()); } } }
public static MobileDeviceCC getMobileDeviceCC(System.Data.Common.DbDataReader reader) { MobileDeviceCC mobileDeviceCC = new MobileDeviceCC(); mobileDeviceCC.MD_ = reader.GetString(reader.GetOrdinal("MD#")); mobileDeviceCC.CC = reader.GetString(reader.GetOrdinal("CC")); return(mobileDeviceCC); }
public static Manufacture getManufacture(System.Data.Common.DbDataReader reader) { Manufacture manufacture = new Manufacture(); manufacture.ManuName = reader.GetString(reader.GetOrdinal("ManuName")); manufacture.ManuURL = reader.GetString(reader.GetOrdinal("ManuURL")); return(manufacture); }
private static ListedAccount ReadAccount(System.Data.Common.DbDataReader reader) { return(new ListedAccount() { ProtectionId = reader.GetInt64("protection"), AccountName = reader.GetString("account"), Reason = reader.GetString("reason") }); }
public static MobileDeviceOther getMobileDeviceOther(System.Data.Common.DbDataReader reader) { MobileDeviceOther mobileDeviceOther = new MobileDeviceOther(); mobileDeviceOther.MD_ = reader.GetString(reader.GetOrdinal("MD#")); mobileDeviceOther.Other = reader.GetString(reader.GetOrdinal("Other")); return(mobileDeviceOther); }
public static MobileDeviceMutimedia getMobileDeviceMutimedia(System.Data.Common.DbDataReader reader) { MobileDeviceMutimedia mobileDeviceMutimedia = new MobileDeviceMutimedia(); mobileDeviceMutimedia.MD_ = reader.GetString(reader.GetOrdinal("MD#")); mobileDeviceMutimedia.Mutimedia = reader.GetString(reader.GetOrdinal("Mutimedia")); return(mobileDeviceMutimedia); }
public static SMD getSMD(System.Data.Common.DbDataReader reader) { SMD SMD = new SMD(); SMD.StoreName = reader.GetString(reader.GetOrdinal("StoreName")); SMD.MD_ = reader.GetString(reader.GetOrdinal("MD#")); SMD.SMDURL = reader.GetString(reader.GetOrdinal("SMDURL")); SMD.SMDPrice = reader.GetInt32(reader.GetOrdinal("SMDPrice")); return(SMD); }
public static MobileDeviceReview getMobileDeviceReview(System.Data.Common.DbDataReader reader) { MobileDeviceReview mobileDeviceReview = new MobileDeviceReview(); mobileDeviceReview.MD_ = reader.GetString(reader.GetOrdinal("MD#")); mobileDeviceReview.ReviewURL = reader.GetString(reader.GetOrdinal("ReviewURL")); mobileDeviceReview.ReviewType = reader.GetString(reader.GetOrdinal("ReviewType")); mobileDeviceReview.ReviewName = reader.GetString(reader.GetOrdinal("ReviewName")); mobileDeviceReview.ReviewMainSite = reader.GetString(reader.GetOrdinal("ReviewMainSite")); return(mobileDeviceReview); }
private async void ReadOnlineUsers() { try { MySqlCommand readOnlineUsers = new MySqlCommand("SELECT ONLINE_USERS.nick, ONLINE_USERS.status, ACCOUNTS.privileges, ACCOUNTS.login FROM ONLINE_USERS LEFT JOIN ACCOUNTS ON ONLINE_USERS.Nick = ACCOUNTS.Nick WHERE ONLINE_USERS.status != 'Offline';", DataReaderMySQLConnection); System.Data.Common.DbDataReader reader = await readOnlineUsers.ExecuteReaderAsync(); List <Users> temporaryUsers = new List <Users> { }; while ((isReadingUsers = await reader.ReadAsync()) == true) { switch (reader.GetString(2)) { case "administrator": temporaryUsers.Add(new Administrator(reader.GetString(0), reader.GetString(1))); if (reader.GetString(0) == ProgramOptions.LoggedInUser.Nick && !(ProgramOptions.LoggedInUser is Administrator)) { ProgramOptions.LoggedInUser = new Administrator(ProgramOptions.LoggedInUser.Nick, ProgramOptions.LoggedInUser.Status, reader.GetString(3)); } break; case "moderator": temporaryUsers.Add(new Moderator(reader.GetString(0), reader.GetString(1))); if (reader.GetString(0) == ProgramOptions.LoggedInUser.Nick && !(ProgramOptions.LoggedInUser is Moderator)) { ProgramOptions.LoggedInUser = new Moderator(ProgramOptions.LoggedInUser.Nick, ProgramOptions.LoggedInUser.Status, reader.GetString(3)); } break; default: temporaryUsers.Add(new User(reader.GetString(0), reader.GetString(1))); if (reader.GetString(0) == ProgramOptions.LoggedInUser.Nick && !(ProgramOptions.LoggedInUser is User)) { ProgramOptions.LoggedInUser = new User(ProgramOptions.LoggedInUser.Nick, ProgramOptions.LoggedInUser.Status, reader.GetString(3)); } break; } } if (temporaryUsers != onlineUsers) { onlineUsers = temporaryUsers; } reader.Close(); loggedInUsersList.ItemsSource = onlineUsers; } catch (Exception mysqlException) { if (mysqlException is MySqlException) { System.Diagnostics.Debug.WriteLine("Exception thrown in ReadOnlineUsersAsync; Not harmful; " + mysqlException.ToString()); } } }
private void DoSearch() { try { _searching = true; _isStop = false; SetRecordText(null, txtRecord); string sql = "select Count(*) from c2lp_optRecord " + _where; int sum = Convert.ToInt32(BaseServer._SqlHelp.ExecuteScalar(sql, CommandType.Text)); if (sum == 0) { MessageBox.Show("没有查到符合条件的相关记录!"); return; } SetRecordText("共查到" + sum + "条记录.", txtRecord); sql = sql.Replace("Count(*)", "optTime,optNumber,optType,optCustomerId") + " order by optTime desc ,optTypeId,optCustomerId"; using (System.Data.Common.DbDataReader r = BaseServer._SqlHelp.ExecuteReader(sql, CommandType.Text)) { while (r.Read()) { if (_isStop) { SetRecordText("已手动停止显示剩余记录.", txtRecord); break; } DateTime optTime = r.GetDateTime(0); string optNumber = r.GetString(1); string optType = r.GetString(2); int optCustomerId = r.GetInt32(3); string optCustomer = ""; if (_dicConsignor.ContainsKey(optCustomerId)) { optCustomer = _dicConsignor[optCustomerId]; } SetRecordText(string.Format("{0} {1} {2} {3}", optTime.ToString("MM-dd HH:mm:ss"), optNumber, optType, optCustomer), txtRecord); } } } catch (Exception ex) { SetRecordText(ex.Message, txtRecord); } finally { _searching = false; SetRecordText("查询完毕.", txtRecord); SetRecordText("CNM", btnSearch); } }
private static void QueryEmployee(Oracle.DataAccess.Client.OracleConnection conn) { string sql = "Select Emp_Id, Emp_No, Emp_Name, Mng_Id from Employee"; // Tạo một đối tượng Command. Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(); // Liên hợp Command với Connection. cmd.Connection = conn; cmd.CommandText = sql; using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { // Chỉ số (index) của cột Emp_ID trong câu lệnh SQL. int empIdIndex = reader.GetOrdinal("Emp_Id"); // 0 long empId = Convert.ToInt64(reader.GetValue(0)); // Chỉ số của cột Emp_No là 1. string empNo = reader.GetString(1); int empNameIndex = reader.GetOrdinal("Emp_Name");// 2 string empName = reader.GetString(empNameIndex); int mngIdIndex = reader.GetOrdinal("Mng_Id"); long?mngId = null; if (!reader.IsDBNull(mngIdIndex)) { mngId = Convert.ToInt64(reader.GetValue(mngIdIndex)); } Console.WriteLine("--------------------"); Console.WriteLine("empIdIndex:" + empIdIndex); Console.WriteLine("EmpId:" + empId); Console.WriteLine("EmpNo:" + empNo); Console.WriteLine("EmpName:" + empName); Console.WriteLine("MngId:" + mngId); } } } }
public Models.User GetId(int P_ID) { Models.User ret = new Models.User(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where ID = " + P_ID, null); while (rs.Read()) { ret.Id = rs.GetInt32(0); ret.Name = rs.GetString(1); ret.Age = rs.GetInt32(2); ret.Address = rs.GetString(3); } return(ret); }
public User GetUserSourceInfo(int user_id) { User us = new User(); string sql = $"SELECT users.id, users.name, sources.id, upload_time FROM users,sources WHERE sources.user_id=users.id AND users.id={user_id} AND used=1 AND sources.status='ok'"; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = myConnection; cmd.CommandText = sql; using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { us.id = reader.GetInt16(0); us.name = reader.GetString(1); us.compiledAndUsedSourceId = reader.GetInt16(3); us.last_upload_time = reader.GetInt16(4); } } } return(us); }
public DataTransferObject.Organization.WithholdingView GetWithholding(WithholdingAccountType accountType, Guid company) { DataTransferObject.Organization.WithholdingView withholding = null; //[AccountNo] = @AccountNo AND string sql = "SELECT [AccountNo],[AccountType],[Time],[Status],[Amount],[Company] FROM [T_Withholding] WHERE [AccountType]=@AccountType AND [Company] = @Company "; using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString)) { //dbOperator.AddParameter("AccountNo", withholdingView.AccountNo); dbOperator.AddParameter("AccountType", accountType); dbOperator.AddParameter("Company", company); using (System.Data.Common.DbDataReader reader = dbOperator.ExecuteReader(sql)) { if (reader.Read()) { withholding = new DataTransferObject.Organization.WithholdingView(); withholding.AccountNo = reader.GetString(0); withholding.AccountType = (WithholdingAccountType)reader.GetByte(1); withholding.Time = reader.GetDateTime(2); withholding.Status = (WithholdingProtocolStatus)reader.GetByte(3); withholding.Amount = reader.GetDecimal(4); withholding.Company = reader.GetGuid(5); } } } return(withholding); }
public Dictionary <string, string> QueryAccountNames(IEnumerable <string> accounts) { string sql = string.Format("select [login],name from T_Employee where [Login] in ('{0}');", string.Join("','", accounts)); var result = new Dictionary <string, string>(); using (DbOperator dboperator = new DbOperator(Provider, ConnectionString)) { using (System.Data.Common.DbDataReader reader = dboperator.ExecuteReader(sql)) { while (reader.Read()) { result.Add(reader.GetString(0), reader.GetString(1)); } } } return(result); }
public static string SafeGetString(this System.Data.Common.DbDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) { return(reader.GetString(colIndex)); } return(string.Empty); }
private static DBSerie ExtractDataFromDataReader(System.Data.Common.DbDataReader result) { DBSerie dbSerie = new DBSerie(); dbSerie.ID = result.GetInt32(0); dbSerie.Name = result.GetString(1); if (!string.IsNullOrEmpty(result.GetValue(2).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(2).ToString())) { dbSerie.Image = ReadToEnd(result.GetStream(2)); } dbSerie.Extension = result.GetString(3); if (!string.IsNullOrEmpty(result.GetValue(4).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(4).ToString())) { dbSerie.ParentID = result.GetInt32(4); } return(dbSerie); }
public void MapProperties(System.Data.Common.DbDataReader dr) { ID = dr.GetLong("ID"); Invoice_ID = dr.GetString("Invoice_ID"); Payment_Type = (DepositType)dr.GetByte("Payment_Type"); Detail = dr.GetString("Detail"); Payment = dr.GetDouble("Payment"); Total_Payment = dr.GetDouble("Total_Payment"); Balance = dr.GetDouble("Balance"); Created_By = dr.GetLong("Created_By"); Updated_By = dr.GetLong("Updated_By"); Created_Date = dr.GetDateTime("Created_Date"); Updated_Date = dr.GetDateTime("Updated_Date"); Organization_ID = dr.GetLong("Organization_ID"); IsActive = dr.GetBoolean("IsActive"); IsDeleted = dr.GetBoolean("IsDeleted"); }
public static GPU getGPU(System.Data.Common.DbDataReader reader) { GPU GPU = new GPU(); GPU.GPU_ = reader.GetString(reader.GetOrdinal("GPU#")); GPU.ManuName = reader.GetString(reader.GetOrdinal("ManuName")); GPU.GPUName = reader.GetString(reader.GetOrdinal("GPUName")); GPU.Cores = reader.GetString(reader.GetOrdinal("Cores")); GPU.BaseClock = reader.GetString(reader.GetOrdinal("BaseClock")); GPU.BoostClock = reader.GetString(reader.GetOrdinal("BoostClock")); GPU.MemorySpeed = reader.GetString(reader.GetOrdinal("MemorySpeed")); GPU.MemoryConfig = reader.GetString(reader.GetOrdinal("MemoryConfig")); GPU.PowerDraw = reader.GetString(reader.GetOrdinal("PowerDraw")); return(GPU); }
public static x86CPU getX86CPU(System.Data.Common.DbDataReader reader) { x86CPU x86CPU = new x86CPU(); x86CPU.CpuName = reader.GetString(reader.GetOrdinal("CpuName")); x86CPU.ManuName = reader.GetString(reader.GetOrdinal("ManuName")); x86CPU.CAndT = reader.GetString(reader.GetOrdinal("CAndT")); x86CPU.BaseClock = reader.GetString(reader.GetOrdinal("BaseClock")); x86CPU.TurboClock = reader.GetString(reader.GetOrdinal("TurboClock")); x86CPU.TDP = reader.GetString(reader.GetOrdinal("TDP")); x86CPU.Graphics = reader.GetString(reader.GetOrdinal("Graphics")); x86CPU.Cache = reader.GetString(reader.GetOrdinal("Cache")); return(x86CPU); }
public static LapTop getLapTop(System.Data.Common.DbDataReader reader) { LapTop laptop = new LapTop(); laptop.MD_ = reader.GetString(reader.GetOrdinal("MD#")); laptop.CDPlayer = reader.GetString(reader.GetOrdinal("CDPlayer")); laptop.Adapter = reader.GetString(reader.GetOrdinal("Adapter")); laptop.Port = reader.GetString(reader.GetOrdinal("Port")); laptop.Webcam = reader.GetString(reader.GetOrdinal("Webcam")); laptop.CpuName = reader.GetString(reader.GetOrdinal("CpuName")); laptop.CPUManuName = reader.GetString(reader.GetOrdinal("CPUManuName")); laptop.InPort = reader.GetString(reader.GetOrdinal("InPort")); return(laptop); }
private static Domain.IncomeGroupLimitGroup loadIncomeGroup(System.Data.Common.DbDataReader reader) { Domain.IncomeGroupLimitGroup income = new Domain.IncomeGroupLimitGroup(); income.Limitation = new List <Domain.IncomeGroupLimit>(); Domain.IncomeGroupLimit limit = null; while (reader.Read()) { var currentId = reader.GetGuid(0); if (income.Id != currentId) { income.Id = currentId; income.CompanyId = reader.GetGuid(1); income.IncomeGroupId = reader.IsDBNull(2) ? (Guid?)null : reader.GetGuid(2); income.Remark = reader.GetString(3); income.Limitation = new List <Domain.IncomeGroupLimit>(); } var currlimitId = reader.GetGuid(4); if (!income.Limitation.Any(it => it.Id == currlimitId)) { limit = new Domain.IncomeGroupLimit(); limit.Id = currlimitId; limit.IncomeId = reader.GetGuid(5); limit.Type = (Common.Enums.PeriodType)reader.GetByte(6); limit.Price = reader.GetInt32(7); limit.Airlines = reader.GetString(12); limit.IsOwnerPolicy = reader.GetBoolean(13); limit.Period = new List <Domain.IncomeGroupPeriod>(); income.Limitation.Add(limit); } Domain.IncomeGroupPeriod period = new Domain.IncomeGroupPeriod(); period.DeductId = reader.GetGuid(8); period.StartPeriod = reader.GetDecimal(9); period.EndPeriod = reader.GetDecimal(10); period.Period = reader.GetDecimal(11); limit.Period.Add(period); } return(income); }
public EmergentOrder QueryEmergentOrder(decimal id, DataTransferObject.Order.OrderStatus status) { EmergentOrder emergentOrder = new EmergentOrder(); string sql = "select Id,[Type],Content,[Time],Account from T_EmergentOrder WHERE Id =@Id AND [Type] = @Type"; using (DbOperator dboperator = new DbOperator(Provider, ConnectionString)) { dboperator.AddParameter("Id", id); dboperator.AddParameter("Type", status); using (System.Data.Common.DbDataReader reader = dboperator.ExecuteReader(sql)) { if (reader.Read()) { emergentOrder.Id = reader.GetDecimal(0); emergentOrder.Type = (DataTransferObject.Order.OrderStatus)reader.GetInt32(1); emergentOrder.Content = reader.GetString(2); emergentOrder.Time = reader.GetDateTime(3); emergentOrder.Account = reader.GetString(4); } } } return(emergentOrder); }
public List <SignalProp> getSignalList() { List <SignalProp> list = new List <SignalProp>(); String sql = " SELECT lampId, signalName, type, ip FROM signal WHERE type IN (1, 4, 5) "; MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn); System.Data.Common.DbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { SignalProp prop = new SignalProp(); prop.SignalID = reader.GetString(0).Trim().ToUpper(); //.Replace('-', '_') prop.SignalName = DBStringToNormal(reader.GetString(1).Trim()); prop.Type = reader.IsDBNull(2) ? (byte)1 : (byte)reader.GetInt32(2); prop.Ip = reader.IsDBNull(3) ? "" : reader.GetString(3).Trim(); list.Add(prop); } reader.Close(); return(list); }
public List <Models.User> GetAll() { List <Models.User> ret = new List <Models.User>(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS order by NAME", null); while (rs.Read()) { ret.Add(new Models.User { Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3) }); } return(ret); }
public List <Models.User> GetName(Models.Search P_NAME) { List <Models.User> ret = new List <Models.User>(); BdUtil bdUtil = new BdUtil(); System.Data.Common.DbDataReader rs = bdUtil.Qry("select ID,NAME,AGE,ADDRESS from USERS where upper(name) like '%" + P_NAME.Name.ToUpperInvariant() + "%' order by NAME", null); while (rs.Read()) { ret.Add(new Models.User { Id = rs.GetInt32(0), Name = rs.GetString(1), Age = rs.GetInt32(2), Address = rs.GetString(3) }); } return(ret); }
private static DBFichier ExtractDataFromDataReader(System.Data.Common.DbDataReader result) { DBFichier dBFichier = new DBFichier(); dBFichier.ID = result.GetInt32(0); dBFichier.Name = result.GetString(1); if (!string.IsNullOrEmpty(result.GetValue(2).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(2).ToString())) { dBFichier.Order = result.GetInt32(2); } if (!string.IsNullOrEmpty(result.GetValue(3).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(3).ToString())) { dBFichier.Image = ReadToEnd(result.GetStream(3)); } if (!string.IsNullOrEmpty(result.GetValue(4).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(4).ToString())) { dBFichier.ParentID = result.GetInt32(4); } if (!string.IsNullOrEmpty(result.GetValue(5).ToString()) && !string.IsNullOrWhiteSpace(result.GetValue(5).ToString())) { dBFichier.Collection = result.GetString(5); } return(dBFichier); }