private void ReadField <T>(T obj, FieldInfo fieldInfo, MySqlDataReader reader, int ordinal) { Type type = fieldInfo.FieldType; System.Object value = null; if (type == typeof(int)) { value = reader.GetFieldValue <int>(ordinal); } else if (type == typeof(byte)) { value = reader.GetFieldValue <byte>(ordinal); } else if (type == typeof(uint)) { value = reader.GetFieldValue <uint>(ordinal); } else if (type == typeof(string)) { value = reader.GetFieldValue <string>(ordinal); } else if (type == typeof(float)) { value = reader.GetFieldValue <float>(ordinal); } //else if (type == typeof(Vector3)) //{ // value = reader.GetFieldValue<string>(ordinal); // string[] str = value.ToString().Split(','); // value = new Vector3(float.Parse(str[0]), float.Parse(str[1]), float.Parse(str[2])); //} fieldInfo.SetValue(obj, value); }
public User GetUser(string username, string password) { MySqlCommand cmd = Connection.CreateCommand(); cmd.CommandText = @"SELECT fname, lname, role FROM userexample WHERE username=@username AND password=@password"; cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@password", password); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (!reader.HasRows) { throw new UserCredentialNotMatchException("Incorrect username or password"); } User user = new User(); user.Username = username; user.Firstname = reader.GetFieldValue <string>(0); user.Lastname = reader.GetFieldValue <string>(1); user.Role = reader.GetFieldValue <string>(2); if (reader.Read()) { throw new MutipleUsersFoundException("Found more than one user"); } return(user); }
private void ReadField <T>(T obj, FieldInfo fieldInfo, MySqlDataReader reader, int ordinal) { Type type = fieldInfo.FieldType; System.Object value = null; if (type == typeof(int)) { value = reader.GetFieldValue <int>(ordinal); } else if (type == typeof(byte)) { value = reader.GetFieldValue <byte>(ordinal); } else if (type == typeof(uint)) { value = reader.GetFieldValue <uint>(ordinal); } else if (type == typeof(string)) { value = reader.GetFieldValue <string>(ordinal); } else if (type == typeof(float)) { value = reader.GetFieldValue <float>(ordinal); } fieldInfo.SetValue(obj, value); }
public static async Task <bool> ProcessListEntry(UInt64 user_id) { string sdays = "", stimes = ""; byte enable = 0; var sqlconn = await ARDBConnectionManager.default_manager.CheckOut(); try { string cmd = "SELECT * FROM `" + elevator_list_id.ToString() + "` WHERE user_id=@user_id;"; using (MySqlCommand sqlcmd = new MySqlCommand(cmd, sqlconn.Connection)) { sqlcmd.Parameters.AddWithValue("@user_id", user_id); using (MySqlDataReader reader = sqlcmd.ExecuteReader()) if (reader.Read()) { sdays = reader.GetFieldValue <string>(1); stimes = reader.GetFieldValue <string>(2); enable = reader.GetFieldValue <byte>(3); } } } catch (Exception ex) { return(false); } ARDBConnectionManager.default_manager.CheckIn(sqlconn); if (enable == 0) { return(false); } var spans = ListEntryUtilities.ConvertTimeStringToTimeSpans(stimes); var days = ListEntryUtilities.ConvertDOWStringToBools(sdays); var current_stamp = DateTime.Now; var day_of_week = current_stamp.DayOfWeek; if (days[(int)day_of_week] == false) { return(false); } if (((((current_stamp.Hour == spans[0].Hours) && (current_stamp.Minute >= spans[0].Minutes)) || ((current_stamp.Hour == spans[1].Hours) && current_stamp.Minute <= spans[1].Minutes))) || ((current_stamp.Hour > spans[0].Hours) && (current_stamp.Hour < spans[1].Hours))) { return(true); } return(false); }
public List <Point> GetCoordinates(string id) { List <Point> result = new List <Point>(); string query = $"SELECT * FROM vCoordinate WHERE kCut = {id}"; MySqlCommand cmd = new MySqlCommand(query, Connection) { CommandType = CommandType.Text }; using (MySqlDataReader mySqlDataReader = cmd.ExecuteReader()) { while (mySqlDataReader.Read()) { try { Point point = new Point(); try { point.X = Convert.ToInt32(mySqlDataReader.GetFieldValue <double>(1)); } catch (Exception ex) { point.X = 0; } try { point.Y = Convert.ToInt32(mySqlDataReader.GetFieldValue <double>(2)); } catch (Exception ex) { point.Y = 0; } result.Add(point); } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } } mySqlDataReader.Close(); } return(result); }
public static List <Patient> GetAll() { List <Patient> pl = new(); MySqlCommand command; command = new("SELECT * FROM patients Limit 50;", DataBaseHandler.Connection); DataBaseHandler.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pl.Add(new Patient ( (reader.IsDBNull(0)) ? null : reader.GetFieldValue <int>(0), (reader.IsDBNull(1)) ? null : reader.GetFieldValue <int>(1), (reader.IsDBNull(2)) ? null : reader.GetFieldValue <string>(2), (reader.IsDBNull(3)) ? null : reader.GetFieldValue <string>(3), (reader.IsDBNull(4)) ? null : reader.GetFieldValue <string>(4), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(5), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(6), (reader.IsDBNull(6)) ? null : JsonSerializer.Deserialize <List <PatientData> >(reader.GetFieldValue <string>(7)), (reader.IsDBNull(7)) ? null : reader.GetFieldValue <int>(8) )); } reader.Close(); DataBaseHandler.Close(); return(pl); }
public static List <Patient> GetByUserID(int?userID) { List <Patient> pl = new(); MySqlCommand command; command = new("SELECT * FROM patients WHERE doctor_id = @doctor_id", DataBaseHandler.Connection); command.Parameters.Add("@doctor_id", MySqlDbType.Int32).Value = userID; DataBaseHandler.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pl.Add(new Patient ( (reader.IsDBNull(0)) ? null : reader.GetFieldValue <int>(0), (reader.IsDBNull(1)) ? null : reader.GetFieldValue <int>(1), (reader.IsDBNull(2)) ? null : reader.GetFieldValue <string>(2), (reader.IsDBNull(3)) ? null : reader.GetFieldValue <string>(3), (reader.IsDBNull(4)) ? null : reader.GetFieldValue <string>(4), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(5), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(6), (reader.IsDBNull(6)) ? null : JsonSerializer.Deserialize <List <PatientData> >(reader.GetFieldValue <string>(7)), (reader.IsDBNull(7)) ? null : reader.GetFieldValue <int>(8) )); } reader.Close(); DataBaseHandler.Close(); return(pl); }
public static List <Patient> FindBySomeData(string request) { List <Patient> pl = new(); MySqlCommand command; command = new("SELECT * FROM patients WHERE last_name LIKE @last_name;", DataBaseHandler.Connection); command.Parameters.Add("@last_name", MySqlDbType.VarChar).Value = "%" + request + "%"; DataBaseHandler.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pl.Add(new Patient ( (reader.IsDBNull(0)) ? null : reader.GetFieldValue <int>(0), (reader.IsDBNull(1)) ? null : reader.GetFieldValue <int>(1), (reader.IsDBNull(2)) ? null : reader.GetFieldValue <string>(2), (reader.IsDBNull(3)) ? null : reader.GetFieldValue <string>(3), (reader.IsDBNull(4)) ? null : reader.GetFieldValue <string>(4), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(5), (reader.IsDBNull(5)) ? null : reader.GetFieldValue <string>(6), (reader.IsDBNull(6)) ? null : JsonSerializer.Deserialize <List <PatientData> >(reader.GetFieldValue <string>(7)), (reader.IsDBNull(7)) ? null : reader.GetFieldValue <int>(8) )); } reader.Close(); DataBaseHandler.Close(); return(pl); }
IEnumerable <T> ForEachFirstCol <T>(IWrappedDataReader p_wrappedReader) { // yield无法使用await,无法在含catch的try内 // 一定要使用using 或 finally方式释放资源,不然foreach内部break时资源无法释放!!! try { using (p_wrappedReader) { MySqlDataReader reader = (MySqlDataReader)p_wrappedReader.Reader; var cols = reader.GetColumnSchema(); if (cols[0].DataType == typeof(T)) { while (reader.Read()) { yield return(reader.GetFieldValue <T>(0)); } } else { while (reader.Read()) { yield return((T)Convert.ChangeType(reader.GetValue(0), typeof(T))); } } } } finally { ReleaseConnection(); } }
public T ExecuteReader(string query, T source) { cmd = new MySqlCommand(); Get_Connection(); using (cmd.Connection = conn) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; T item; try { using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { item = source; reader.GetFieldValue <T>(i); } } } } catch (Exception) { throw; } return(item = source); } }
private static T GetSafeField <T>(MySqlDataReader reader, int index) { if (!reader.IsDBNull(index)) { return(reader.GetFieldValue <T>(index)); } return(default(T)); }
public static T?GetValueOrNullable <T>(this MySqlDataReader reader, int ordinal) where T : struct { if (reader.IsDBNull(ordinal)) { return(null); } return(reader.GetFieldValue <T>(ordinal)); }
public static T GetValueOrDefault <T>( [NotNull] this MySqlDataReader reader, [NotNull] string name) { var idx = reader.GetOrdinal(name); return(reader.IsDBNull(idx) ? default(T) : reader.GetFieldValue <T>(idx)); }
private void удалитьКнигуToolStripMenuItem_Click(object sender, EventArgs e) { string bookid; try { bookid = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); string Connect = "Database=" + Properties.Settings.Default.DataBase + ";Data Source=" + Properties.Settings.Default.DataSourse + ";User Id=" + Properties.Settings.Default.UserLog + ";Password= "******"SELECT bookway FROM BookLocation WHERE idBookLocation ='" + bookid + "'"; using (MySqlDataReader reader = MyCommand.ExecuteReader()) { if (reader.Read()) { FName = reader.GetFieldValue <string>(0); MyConnection.Close(); try { MyConnection.Open(); MyCommand.CommandText = "DELETE FROM Books WHERE idКниги = " + bookid; MyCommand.ExecuteNonQuery(); string path = "/"; ftpRequest = (FtpWebRequest)WebRequest.Create("ftp://" + _Host + path + "/" + FName); ftpRequest.Credentials = new NetworkCredential(_UserName, _Password); ftpRequest.EnableSsl = _UseSSL; ftpRequest.Method = WebRequestMethods.Ftp.DeleteFile; FtpWebResponse ftpResponse = (FtpWebResponse)ftpRequest.GetResponse(); ftpResponse.Close(); MyConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public List <Result> GetResults(string id) { List <Result> resultList = new List <Result>(); string query = $"SELECT * FROM vResult WHERE kCut = {id} ORDER BY cResultType, cIdentifier, cKey"; MySqlCommand cmd = new MySqlCommand(query, Connection) { CommandType = CommandType.Text }; using (MySqlDataReader mySqlDataReader = cmd.ExecuteReader()) { while (mySqlDataReader.Read()) { Result result = new Result(); object rawResultType = mySqlDataReader.GetFieldValue <object>(1); object rawIdentifier = mySqlDataReader.GetFieldValue <object>(2); object rawKey = mySqlDataReader.GetFieldValue <object>(3); object rawValue = mySqlDataReader.GetFieldValue <object>(4); object rawUnit = mySqlDataReader.GetFieldValue <object>(5); result.CutId = Convert.ToInt16(id); result.ResultType = rawResultType is DBNull ? null : (string)rawResultType; result.Identifier = rawIdentifier is DBNull ? null : (string)rawIdentifier; result.Key = rawKey is DBNull ? null : (string)rawKey; result.Value = rawValue is DBNull ? null : (string)rawValue; result.Unit = rawUnit is DBNull ? null : (string)rawUnit; resultList.Add(result); } mySqlDataReader.Close(); } return(resultList); }
public static T SafeRead <T>(MySqlDataReader reader, string column) { var index = reader.GetOrdinal(column); if (!reader.IsDBNull(index)) { return(reader.GetFieldValue <T>(index)); } else { return(default(T)); } }
private Dictionary <Service, Doctor> GetDoctorOfService(uint idType) { Dictionary <Service, Doctor> buffer = new Dictionary <Service, Doctor>(); if (connect.IsConnect()) { string selectDoctor = "SELECT s.id, s.lable, s.price, s.action_service, d.id, d.fio, d.cabinet_number, d.specialization FROM service_of_doctor AS sod " + "JOIN service AS s ON s.id = sod.id_service " + "JOIN doctor AS d ON d.id = sod.id_doctor " + "WHERE s.id_type = @idType"; using (MySqlCommand command = new MySqlCommand(selectDoctor, connect.GetConnect)) { command.Parameters.AddWithValue("@idType", idType); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { buffer.Add(new Service() { Id = reader.GetFieldValue <uint>(0), Lable = reader.GetString(1), Price = reader.GetFieldValue <uint>(2), Action = reader.GetString(3) }, new Doctor() { Id = reader.GetFieldValue <uint>(4), Fio = reader.GetString(5), CabinetNumber = reader.GetString(6), Specialization = reader.GetString(7) }); } reader.Close(); } } connect.Close(); } return(new Dictionary <Service, Doctor>(buffer)); }
public static List <Dictionary <String, Object> > ExecSqlReturn(String sql) //返回查找结果集的 { List <Dictionary <String, Object> > list = new List <Dictionary <String, Object> >(); MySqlCommand command = new MySqlCommand(sql, GetSqlConnection()); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Dictionary <string, Object> keyValues = new Dictionary <string, Object>(); for (int i = 0; i < reader.FieldCount; i++) { keyValues.Add(reader.GetName(i), reader.GetFieldValue <Object>(i)); } list.Add(keyValues); } reader.Close(); return(list); }
async public static Task <DataTable> GetTableAsync(string sql, DbParameter[] paras) { DataTable dt = new DataTable(); var conn = CreateConnection(); var cmd = CreateCmd(sql, conn, paras); await OpenConnectionAsync(conn); try { MySqlDataReader dr = await cmd.ExecuteReaderAsync() as MySqlDataReader; for (int i = 0; i < dr.FieldCount; i++) { string columnName = dr.GetName(i); dt.Columns.Add(new DataColumn(columnName)); } while (await dr.ReadAsync()) { var row = dt.NewRow(); for (int i = 0; i < dr.FieldCount; i++) { row[i] = dr.GetFieldValue <object>(i); } dt.Rows.Add(row); } CloseConnection(conn); } catch (Exception ex) { CloseConnection(conn); throw ex; } return(dt); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string userid; sbyte checkadd = 0; sbyte checkdelete = 0; sbyte checkedit = 0; sbyte checkcontrol = 0; userid = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); try { string Connect = "Database=" + Properties.Settings.Default.DataBase + ";Data Source=" + Properties.Settings.Default.DataSourse + ";User Id=" + Properties.Settings.Default.UserLog + ";Password= "******"SELECT ИмяПользователя,Логин,Пароль FROM User WHERE idПользователя ='" + userid + "'"; MyConnection.Open(); using (MySqlDataReader reader = MyCommand.ExecuteReader()) { if (reader.Read()) { UserName.Text = reader.GetFieldValue <string>(0); Login.Text = reader.GetFieldValue <string>(1); Pass.Text = reader.GetFieldValue <string>(2); MyConnection.Close(); try { MyCommand.CommandText = "SELECT bookadd,bookdelete,bookedit,usercontrol FROM UserRights WHERE idUserRights ='" + userid + "'"; MyConnection.Open(); using (MySqlDataReader reader1 = MyCommand.ExecuteReader()) { if (reader1.Read()) { checkadd = reader1.GetFieldValue <sbyte>(0); checkdelete = reader1.GetFieldValue <sbyte>(1); checkedit = reader1.GetFieldValue <sbyte>(2); checkcontrol = reader1.GetFieldValue <sbyte>(3); if (checkadd != 0) { CheckAdd.Checked = true; } else { CheckAdd.Checked = false; } if (checkdelete != 0) { CheckDelete.Checked = true; } else { CheckDelete.Checked = false; } if (checkedit != 0) { CheckEdit.Checked = true; } else { CheckEdit.Checked = false; } if (checkcontrol != 0) { CheckControl.Checked = true; } else { CheckControl.Checked = false; } MyConnection.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static T SafeGet <T>(this MySqlDataReader reader, int col) { return(reader.IsDBNull(col) ? default(T) : reader.GetFieldValue <T>(col)); }
private void button1_Click(object sender, EventArgs e) { try { int id; string username; string log; string password; SByte Add, Delete, Edit, UserControl; username = "******"; log = Login.Text; password = Pass.Text; string Connect = "Database=" + Properties.Settings.Default.DataBase + ";Data Source=" + Properties.Settings.Default.DataSourse + ";User Id=" + Properties.Settings.Default.UserLog + ";Password="******"SELECT idПользователя,ИмяПользователя FROM user WHERE Логин ='" + log + "'and Пароль ='" + password + "'"; using (MySqlDataReader reader = MyCommand.ExecuteReader()) { if (reader.Read()) { id = reader.GetFieldValue <int>(0); Properties.Settings.Default.UserName = reader.GetFieldValue <string>(1); Properties.Settings.Default.UserLogId = id; MyConnection.Close(); try { MyCommand.CommandText = "SELECT bookadd,bookdelete,bookedit,usercontrol FROM UserRights WHERE idUserRights = '" + id + "'"; MyConnection.Open(); using (MySqlDataReader reader1 = MyCommand.ExecuteReader()) { if (reader1.Read()) { Add = reader1.GetFieldValue <SByte>(0); Delete = reader1.GetFieldValue <SByte>(1); Edit = reader1.GetFieldValue <SByte>(2); UserControl = reader1.GetFieldValue <SByte>(3); Properties.Settings.Default.Add = Add; Properties.Settings.Default.Delete = Delete; Properties.Settings.Default.Editing = Edit; Properties.Settings.Default.Eduser = UserControl; MessageBox.Show("Добро пожаловать " + Properties.Settings.Default.UserName); Data.EventHanler1(username); MyConnection.Close(); Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { groupBox1.Text = "Неверный логин или пароль"; groupBox1.ForeColor = Color.Red; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public T GetFieldValue <T>(int ordinal) { return(_mySqlDataReader.GetFieldValue <T>(ordinal)); }
public static T GetValueOrNull <T>(this MySqlDataReader reader, int ordinal) where T : class { return(!reader.IsDBNull(ordinal) ? reader.GetFieldValue <T>(ordinal) : null); }
public List <Cut> GetCut(int minId, int maxId, string orderBy = "kCut") { List <Cut> result = new List <Cut>(); try { string query = $"SELECT * FROM vCut WHERE kCut >= {minId} AND kCut <= {maxId} ORDER BY {orderBy}"; MySqlCommand cmd = new MySqlCommand(query, Connection) { CommandType = CommandType.Text }; using (MySqlDataReader mySqlDataReader = cmd.ExecuteReader()) { while (mySqlDataReader.Read()) { //Cut cut = new Cut(); //cut.Id = Convert.ToInt16(mySqlDataReader.GetFieldValue<UInt16>(0)); //cut.Age = Convert.ToInt16(mySqlDataReader.GetFieldValue<byte>(1)); //cut.Genotype = mySqlDataReader.GetFieldValue<string>(2); //cut.Animal = mySqlDataReader.GetFieldValue<string>(3); //cut.CutIdentifier = mySqlDataReader.GetFieldValue<string>(4); //cut.Method = mySqlDataReader.GetFieldValue<string>(5); //if (DateTime.TryParse(mySqlDataReader.GetValue(6)?.ToString(), out var dateMeasurement)) //{ // cut.DateMeasurement = dateMeasurement; //} //if (DateTime.TryParse(mySqlDataReader.GetValue(7)?.ToString(), out var dateStaining)) //{ // cut.DateStaining = dateStaining; //} //cut.ZoomFactor = (float) Convert.ToDouble(mySqlDataReader.GetFieldValue<Single>(8)); //cut.Layer = mySqlDataReader.GetFieldValue<string>(9); //cut.Note = mySqlDataReader.GetFieldValue<string>(10); //result.Add(cut); try { Cut cut = new Cut(); try { cut.Id = Convert.ToInt16(mySqlDataReader.GetFieldValue <UInt16>(0)); } catch (Exception ex) { cut.Id = -1; } try { cut.Age = Convert.ToInt16(mySqlDataReader.GetFieldValue <byte>(1)); } catch (Exception ex) { cut.Age = -1; } try { cut.Genotype = mySqlDataReader.GetFieldValue <string>(2); } catch (Exception ex) { cut.Genotype = "KO"; } try { cut.Animal = mySqlDataReader.GetFieldValue <string>(3); } catch (Exception ex) { cut.Animal = "unknown"; } try { cut.CutIdentifier = mySqlDataReader.GetFieldValue <string>(4); } catch (Exception ex) { cut.CutIdentifier = "unknown"; } try { cut.Method = mySqlDataReader.GetFieldValue <string>(5); } catch (Exception ex) { cut.Method = "unknown"; } try { if (DateTime.TryParse(mySqlDataReader.GetValue(6)?.ToString(), out var dateMeasurement)) { cut.DateMeasurement = dateMeasurement; } } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } try { if (DateTime.TryParse(mySqlDataReader.GetValue(7)?.ToString(), out var dateStaining)) { cut.DateStaining = dateStaining; } } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } try { cut.ZoomFactor = (float)Convert.ToDouble(mySqlDataReader.GetFieldValue <Single>(8)); } catch (Exception ex) { cut.ZoomFactor = -1; } try { cut.Layer = mySqlDataReader.GetFieldValue <string>(9); } catch (Exception ex) { cut.Layer = "unknown"; } try { cut.Note = mySqlDataReader.GetFieldValue <string>(10); } catch (Exception ex) { cut.Note = "unknown"; } result.Add(cut); } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } } mySqlDataReader.Close(); } } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } return(result); }
private void dataGridView1_DoubleClick(object sender, EventArgs e) { string bookid; string bookname; try { bookid = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); bookname = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); Properties.Settings.Default.BookName = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); string Connect = "Database=" + Properties.Settings.Default.DataBase + ";Data Source=" + Properties.Settings.Default.DataSourse + ";User Id=" + Properties.Settings.Default.UserLog + ";Password= "******"SELECT bookway FROM BookLocation WHERE idBookLocation ='" + bookid + "'"; using (MySqlDataReader reader = MyCommand.ExecuteReader()) { if (reader.Read()) { FName = reader.GetFieldValue <string>(0); Properties.Settings.Default.BookFName = reader.GetFieldValue <string>(0); Properties.Settings.Default.BookFName = FName; Properties.Settings.Default.BookName = bookname; try { string path; path = "/"; ftpRequest = (FtpWebRequest)WebRequest.Create("ftp://" + _Host + path + "/" + FName); ftpRequest.Credentials = new NetworkCredential(_UserName, _Password); //команда фтп RETR ftpRequest.Method = WebRequestMethods.Ftp.DownloadFile; ftpRequest.EnableSsl = _UseSSL; //Файлы будут копироваться в кталог программы FileStream downloadedFile = new FileStream(FName, FileMode.OpenOrCreate, FileAccess.ReadWrite); ftpResponse = (FtpWebResponse)ftpRequest.GetResponse(); //Получаем входящий поток Stream responseStream = ftpResponse.GetResponseStream(); //Буфер для считываемых данных byte[] buffer = new byte[1024]; int size = 0; while ((size = responseStream.Read(buffer, 0, 1024)) > 0) { downloadedFile.Write(buffer, 0, size); } ftpResponse.Close(); downloadedFile.Close(); responseStream.Close(); MyConnection.Close(); try { var command = MyConnection.CreateCommand(); command.CommandText = "INSERT INTO UserOpenBook" + " (idПользователя,idКниги,НазваниеКниги,ИмяКниги) VALUES (@idUser,@idBooks,@UserName,@BookName)"; MySqlParameter param = new MySqlParameter(); param.ParameterName = "@idUser"; param.Value = Properties.Settings.Default.UserLogId; param.MySqlDbType = MySqlDbType.VarChar; command.Parameters.Add(param); param = new MySqlParameter(); param.ParameterName = "@idBooks"; param.Value = bookid; param.MySqlDbType = MySqlDbType.VarChar; command.Parameters.Add(param); param = new MySqlParameter(); param.ParameterName = "@UserName"; param.Value = Properties.Settings.Default.UserName; param.MySqlDbType = MySqlDbType.VarChar; command.Parameters.Add(param); param = new MySqlParameter(); param.ParameterName = "@BookName"; param.Value = bookname; param.MySqlDbType = MySqlDbType.VarChar; command.Parameters.Add(param); MyConnection.Open(); command.ExecuteNonQuery(); MyConnection.Close(); Data.EventHanler(FName); } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MyConnection.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public Cut GetCut(string kAge, string cGenoType, string cAnimal, string cCutIdentifier) { string query = $"SELECT * FROM vCut WHERE kAge = '{kAge}' AND cGenoType = '{cGenoType}' AND cAnimal = '{cAnimal}' AND cCutIdentifier = '{cCutIdentifier}' LIMIT 1"; MySqlCommand cmd = new MySqlCommand(query, Connection) { CommandType = CommandType.Text }; using (MySqlDataReader mySqlDataReader = cmd.ExecuteReader()) { while (mySqlDataReader.Read()) { try { Cut cut = new Cut(); try { cut.Id = Convert.ToInt16(mySqlDataReader.GetFieldValue <UInt16>(0)); } catch (Exception ex) { cut.Id = -1; } try { cut.Age = Convert.ToInt16(mySqlDataReader.GetFieldValue <byte>(1)); } catch (Exception ex) { cut.Age = -1; } try { cut.Genotype = mySqlDataReader.GetFieldValue <string>(2); } catch (Exception ex) { cut.Genotype = "KO"; } try { cut.Animal = mySqlDataReader.GetFieldValue <string>(3); } catch (Exception ex) { cut.Animal = "unknown"; } try { cut.CutIdentifier = mySqlDataReader.GetFieldValue <string>(4); } catch (Exception ex) { cut.CutIdentifier = "unknown"; } try { cut.Method = mySqlDataReader.GetFieldValue <string>(5); } catch (Exception ex) { cut.Method = "unknown"; } try { if (DateTime.TryParse(mySqlDataReader.GetValue(6)?.ToString(), out var dateMeasurement)) { cut.DateMeasurement = dateMeasurement; } } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } try { if (DateTime.TryParse(mySqlDataReader.GetValue(7)?.ToString(), out var dateStaining)) { cut.DateStaining = dateStaining; } } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } try { cut.ZoomFactor = (float)Convert.ToDouble(mySqlDataReader.GetFieldValue <Single>(8)); } catch (Exception ex) { cut.ZoomFactor = -1; } try { cut.Layer = mySqlDataReader.GetFieldValue <string>(9); } catch (Exception ex) { cut.Layer = "unknown"; } try { cut.Note = mySqlDataReader.GetFieldValue <string>(10); } catch (Exception ex) { cut.Note = "unknown"; } return(cut); } catch (Exception ex) { MessageBoxAutocloseWithButtons.Show(_waitTime, true, "Ok", "Cancel", ex.Message); } } mySqlDataReader.Close(); } return(null); }
private void EditUserForm_Load(object sender, EventArgs e) { sbyte checkadd = 0; sbyte checkdelete = 0; sbyte checkedit = 0; sbyte checkcontrol = 0; try { string Connect = "Database=mydb;Data Source=sorok.pp.ua;User Id=root;Password="******"SELECT ИмяПользователя,Логин,Пароль FROM User WHERE idПользователя ='" + Properties.Settings.Default.UserId + "'"; MyConnection.Open(); using (MySqlDataReader reader = MyCommand.ExecuteReader()) { if (reader.Read()) { label4.Text = reader.GetFieldValue <string>(0); label5.Text = reader.GetFieldValue <string>(1); label6.Text = reader.GetFieldValue <string>(2); MyConnection.Close(); try { MyCommand.CommandText = "SELECT bookadd,bookdelete,bookedit,usercontrol FROM UserRights WHERE idUserRights ='" + Properties.Settings.Default.UserId + "'"; MyConnection.Open(); using (MySqlDataReader reader1 = MyCommand.ExecuteReader()) { if (reader1.Read()) { checkadd = reader1.GetFieldValue <sbyte>(0); checkdelete = reader1.GetFieldValue <sbyte>(1); checkedit = reader1.GetFieldValue <sbyte>(2); checkcontrol = reader1.GetFieldValue <sbyte>(3); if (checkadd != 0) { CheckAdd.Checked = true; } else { CheckAdd.Checked = false; } if (checkdelete != 0) { CheckDelete.Checked = true; } else { CheckDelete.Checked = false; } if (checkedit != 0) { CheckEdit.Checked = true; } else { CheckEdit.Checked = false; } if (checkcontrol != 0) { CheckControl.Checked = true; } else { CheckControl.Checked = false; } MyConnection.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }