//删 public string[] deleteStandardAction(string hand_id) { mysql = new MySqlAccess(host, port, userName, password, databaseName); string[] res = new string[1]; res[0] = "null"; mysql.OpenSql(); string querySql = "select * from act where ac_id = '" + hand_id + "'"; DataSet ds = mysql.SimpleSql(querySql); if (ds.Tables[0].Rows.Count != 0) { res = new string[2]; res[0] = ds.Tables[0].Rows[0][0].ToString(); res[1] = ds.Tables[0].Rows[0][1].ToString(); string picName = ds.Tables[0].Rows[0][2].ToString(); string leftData = ds.Tables[0].Rows[0][3].ToString(); string rightData = ds.Tables[0].Rows[0][4].ToString(); querySql = "delete from act where ac_id = '" + hand_id + "'"; Debug.Log(querySql); deletePicture(picName); deleteActions(leftData); deleteActions(rightData); mysql.SimpleSql(querySql); Debug.Log("delete!!!!"); } mysql.Close(); return(res); }
private void btnFiltrar_Click(object sender, EventArgs e) { flowLayoutPanel1.Controls.Clear(); MySqlAccess mySqlBD = new MySqlAccess(); mySqlBD.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["mySqlStringConnection"].ConnectionString; mySqlBD.OpenConnection(); DataTable dataTable = new DataTable(); string busqL = String.Format("Select *From libros where usuarios_idusuario='{0}'and nombre like '%{1}%'", Login.idUsuario, txtNombreLibro.Text); dataTable = mySqlBD.QuerySQL(busqL); List <Libro> result = new List <Libro>(); for (int x = 0; x < dataTable.Rows.Count; x++) { Libro libro = new Libro(dataTable.Rows[x]["nombre"].ToString(), dataTable.Rows[x]["color"].ToString(), dataTable.Rows[x]["orden"].ToString(), dataTable.Rows[x]["categoria"].ToString()); result.Add(libro); } ListaLibros = result; for (int i = 0; i < ListaLibros.Count; i++) { flowLayoutPanel1.Controls.Add(ListaLibros[i]); } }
public string getActionId() { mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string querySQL = "select max(ac_id) from act;"; DataSet ds = mysql.SimpleSql(querySQL); string res_id = ""; if (ds != null) { if (ds.Tables[0].Rows.Count == 1) { if (ds.Tables[0].Rows[0][0].ToString() == "") { res_id = "400001"; } else { string cur_max_id = ds.Tables[0].Rows[0][0].ToString(); //Debug.Log("max id is: " + cur_max_id ); int next_id = int.Parse(cur_max_id) + 1; res_id = next_id.ToString(); //Debug.Log("next id is: " + res_id); } } else { Debug.Log("Error"); res_id = "error"; } } mysql.Close(); return(res_id); }
private void cargarlibros(object sender, EventArgs e) { MySqlAccess mySqlBD = new MySqlAccess(); mySqlBD.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["mySqlStringConnection"].ConnectionString; mySqlBD.OpenConnection(); DataTable dataTable = new DataTable(); dataTable = mySqlBD.QuerySQL("Select * From libros where usuarios_idusuario =" + Login.idUsuario + ""); List <Libro> result = new List <Libro>(); for (int x = 0; x < dataTable.Rows.Count; x++) { Libro libro = new Libro(dataTable.Rows[x]["nombre"].ToString(), dataTable.Rows[x]["color"].ToString(), dataTable.Rows[x]["orden"].ToString(), dataTable.Rows[x]["categoria"].ToString()); result.Add(libro); } ListaLibros = result; for (int i = 0; i < ListaLibros.Count; i++) { flowLayoutPanel1.Controls.Add(ListaLibros[i]); } }
private SqlAccess GetSqlAccess(Durados.SqlProduct sqlProduct) { SqlAccess sqlAccess = null; if (sqlAccess == null) { switch (sqlProduct) { case SqlProduct.MySql: sqlAccess = new MySqlAccess(); break; case SqlProduct.Postgre: sqlAccess = new PostgreAccess(); break; case SqlProduct.Oracle: sqlAccess = new OracleAccess(); break; default: sqlAccess = new SqlAccess(); break; } } return(sqlAccess); }
//查 public string[,] findStandardActions() { mysql = new MySqlAccess(host, port, userName, password, databaseName); string[,] res; res = new string[1, 1]; mysql.OpenSql(); Debug.Log("database name: " + databaseName); string querySql = "select ac_id, ac_name, ac_pic from act"; //string querySql = "select trp_ptID from trp"; DataSet ds = mysql.SimpleSql(querySql); int row_num = ds.Tables[0].Rows.Count; //Debug.Log("aaaa" + row_num); if (row_num != 0) { int col_num = ds.Tables[0].Rows[0].ItemArray.Length; //Debug.Log("rows num: " + row_num); //Debug.Log("cols_num: " + col_num); res = new string[row_num, col_num]; for (int i = 0; i < row_num; i++) { for (int j = 0; j < col_num; j++) { //Debug.Log("content: " + ds.Tables[0].Rows[i][j]); res[i, j] = ds.Tables[0].Rows[i][j].ToString(); } } } else { res[0, 0] = "null"; } mysql.Close(); return(res); }
//查看病人训练方案 public string [,] getPatientPlans(string pat_id) { mysql = new MySqlAccess(host, port, userName, password, databaseName); string[,] res; res = new string[1, 1]; mysql.OpenSql(); string querySql = "select act.ac_id, act.ac_name, trp.trp_hand, trp.trp_num, trp.trp_time, trp.trp_totl, trp.trp_finish " + "from trp, act where trp.trp_actID = act.ac_id and trp.trp_ptID = '" + pat_id + "'"; DataSet ds = mysql.SimpleSql(querySql); int row_num = ds.Tables[0].Rows.Count; if (row_num != 0) { int col_num = ds.Tables[0].Rows[0].ItemArray.Length; res = new string[row_num, col_num]; for (int i = 0; i < row_num; i++) { for (int j = 0; j < col_num; j++) { //Debug.Log("content: " + ds.Tables[0].Rows[i][j]); res[i, j] = ds.Tables[0].Rows[i][j].ToString(); } } } else { res[0, 0] = "null"; } return(res); }
private void button2_Click(object sender, EventArgs e) { flowLayoutPanel1.Controls.Clear(); MySqlAccess mySqlBD = new MySqlAccess(); mySqlBD.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["mySqlStringConnection"].ConnectionString; mySqlBD.OpenConnection(); DataTable dataTable = new DataTable(); dataTable = mySqlBD.QuerySQL("Select * From notas where libros_idlibros =" + Libro.idLibroEstatico + ""); List <Notas> result = new List <Notas>(); for (int x = 0; x < dataTable.Rows.Count; x++) { Notas notas = new Notas(dataTable.Rows[x]["titulo"].ToString(), dataTable.Rows[x]["privacidad"].ToString(), dataTable.Rows[x]["categoria"].ToString(), dataTable.Rows[x]["notascol"].ToString(), dataTable.Rows[x]["fecha_creacion"].ToString(), dataTable.Rows[x]["fecha_modificacion"].ToString(), dataTable.Rows[x]["texto_notas"].ToString()); result.Add(notas); } ListaNotas = result; for (int i = 0; i < ListaNotas.Count; i++) { flowLayoutPanel1.Controls.Add(ListaNotas[i]); } }
/// <summary> /// 初始化管理员表(将人员表中所有的管理员添加到管理员表中) /// </summary> public void InitialAdmin() { mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string query = "select ppl_id from ppl where ppl_role = '管理员'"; DataSet ds1 = mysql.QuerySet(query); if (ds1 != null) { DataTable table = ds1.Tables [0]; for (int i = 0; i < table.Rows.Count; i++) { Debug.Log(table.Rows [i] [0]); // 把激活改成1 string actquery = "update ppl set ppl_act = 1 where ppl_id = " + table.Rows[i][0]; DataSet ds2 = mysql.QuerySet(actquery); // 往管理员表里加 string dupliquery = "select * from adm where adm_id = " + table.Rows[i][0]; DataSet ds3 = mysql.QuerySet(dupliquery); if (ds3 == null) { string addquery = "insert into adm values ('" + table.Rows[i][0] + "', '" + table.Rows[i][0] + "')"; DataSet ds4 = mysql.QuerySet(addquery); } } Debug.Log("管理员表初始化完成!"); } else { Debug.Log("人员表中没有管理员身份的用户!"); } mysql.Close(); }
//获取病人信息 public string[,] getPatientInfos() { mysql = new MySqlAccess(host, port, userName, password, databaseName); string[,] res; res = new string[1, 1]; //res[0, 0] = "null"; mysql.OpenSql(); string querySql = "select pat.pt_id, pat.pt_name, pat.pt_sex, doc.dc_id, doc.dc_name, doc.dc_pro from pat, doc where pat.pt_dcID = doc.dc_id order by doc.dc_id"; DataSet ds = mysql.SimpleSql(querySql); int row_num = ds.Tables[0].Rows.Count; if (row_num != 0) { int col_num = ds.Tables[0].Rows[0].ItemArray.Length; res = new string[row_num, col_num]; for (int i = 0; i < row_num; i++) { for (int j = 0; j < col_num; j++) { //Debug.Log("content: " + ds.Tables[0].Rows[i][j]); res[i, j] = ds.Tables[0].Rows[i][j].ToString(); } } } else { res[0, 0] = "null"; } return(res); }
void Eliminarlibro(Object s, System.EventArgs h) { idLibroEstatico = idLibro; MySqlAccess mySql = new MySqlAccess(); String cn = "Server=localhost;Database=Database;Uid=root;Pwd=1234;"; mySql.ConnectionString = cn; mySql.OpenConnection(); mySql.BeginTransaction(); DataTable dataTable = new DataTable(); string query2 = string.Format("DELETE FROM libros WHERE(idlibros = '" + idLibroEstatico + "') and(usuarios_idusuario= '" + Login.idUsuario + "')"); string query = string.Format("DELETE FROM notas WHERE(libros_idlibros= '" + idLibroEstatico + "')"); String FechaHistorial = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); string query3 = string.Format("INSERT INTO transacciones(idhistorial,fecha,usuario, accion,objeto,info_adicional,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", "0", FechaHistorial, Login.Usuario, "Libro Eliminado", "Mantenimiento Libros", Libro.NombreStatico, Login.idUsuario); mySql.EjectSQL(query); mySql.EjectSQL(query2); mySql.EjectSQL(query3); mySql.CommitTransaction(); mySql.CloseConnection(); MessageBox.Show("El Libro se ha eliminado correctamente, Presione REFRESCAR LIBRO para visualizar el cambio", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }
void EliminarNota(Object s, System.EventArgs h) { titulounico = Titulo.Text; MySqlAccess mySql = new MySqlAccess(); String cn = "Server=localhost;Database=Database;Uid=root;Pwd=1234;"; mySql.ConnectionString = cn; mySql.OpenConnection(); mySql.BeginTransaction(); DataTable dataTable = new DataTable(); string query = string.Format("DELETE FROM notas WHERE(titulo = '" + titulounico + "') "); mySql.EjectSQL(query); String FechaHistorial = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); string query3 = string.Format("INSERT INTO transacciones(idhistorial,fecha,usuario, accion,objeto,info_adicional,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", "0", FechaHistorial, Login.Usuario, "Nota Eliminada", "Mantenimiento notas", titulounico, Login.idUsuario); mySql.EjectSQL(query3); mySql.CommitTransaction(); mySql.CloseConnection(); MessageBox.Show("La nota se ha eliminado correctamente", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }
void EditarNota(Object s, System.EventArgs h) { titulounico = Titulo.Text; MySqlAccess mySql = new MySqlAccess(); String cn = "Server=localhost;Database=Database;Uid=root;Pwd=1234;"; mySql.ConnectionString = cn; mySql.OpenConnection(); mySql.BeginTransaction(); DataTable dataTable = new DataTable(); String id = String.Format("SELECT idnotas from notas where titulo ='{0}'", titulounico); dataTable = mySql.QuerySQL(id); int idActual = Convert.ToInt32(dataTable.Rows[0][0].ToString()); idNotaEstatica = idActual; String FechaHistorial = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); string query3 = string.Format("INSERT INTO transacciones(idhistorial,fecha,usuario, accion,objeto,info_adicional,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", "0", FechaHistorial, Login.Usuario, "Nota Edittada", "Mantenimiento notas", titulounico, Login.idUsuario); mySql.EjectSQL(query3); mySql.CommitTransaction(); mySql.CloseConnection(); MantenimientoNotas mantenimientoLibros = new MantenimientoNotas(); mantenimientoLibros.ShowDialog(); }
/// <summary> /// Queries the user identifier and code matched. /// </summary> /// <returns><c>true</c>, if user identifier and code matched was queryed, <c>false</c> otherwise.</returns> /// <param name="db">Db.</param> /// <param name="id">Identifier.</param> /// <param name="code">Code.</param> public static bool QueryUserIdAndCodeMatched(MySqlAccess db, string id, string code) { if (db == null) { throw new Exception("db is null."); } string[] items = new string[] { _str_field_user_id, _str_field_user_code }; string[] where_cols = new string[] { _str_field_user_id, _str_field_user_code }; string[] operation = new string[] { _str_operation_equal, _str_operation_equal }; string[] values = new string[] { id, code }; DataSet result = db.Select(_str_table_name, items, where_cols, operation, values); if (result == null || result.Tables.Count < 0) { return(false); } if (result.Tables[0].Rows.Count == 1) { return(true); } else { return(false); } }
public string HistoryRecord(string Date, string actID, int Hand) { string ptID = ""; if (PlayerPrefs.HasKey("userID")) { ptID = PlayerPrefs.GetString("userID"); } Debug.Log("userID" + ptID); string date = Date; string act_id = actID; int hand = Hand; mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string query = "select rec_link from rec where rec_ptID = '" + ptID + "' and rec_hand = " + hand + " and rec_actID = '" + act_id + "' and rec_date = '" + date + "'"; DataSet ds = mysql.QuerySet(query); DataTable table = ds.Tables [0]; string res = ""; Debug.Log(table.Rows.Count); if (table.Rows.Count == 1) { res = table.Rows [0] [0].ToString(); } Debug.Log(res); mysql.Close(); return(res); }
private static void LoadConnections() { System.Configuration.ConnectionStringSettings systemConnection = System.Configuration.ConfigurationManager.ConnectionStrings["SystemMapsConnectionString"] ?? null; System.Data.Common.DbConnectionStringBuilder csb; if (MySqlAccess.IsMySqlConnectionString(systemConnection.ConnectionString)) { csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(systemConnection.ConnectionString); } else { csb = new System.Data.SqlClient.SqlConnectionStringBuilder(systemConnection.ConnectionString); } if (!List.ContainsKey(csb["data source"].ToString())) { List.Add(csb["data source"].ToString(), systemConnection.ConnectionString); } //else // List[cnnParameter.serverName]=new SqlServersManager(connectionString) ; AddOnPremissDemoDb(); AddExternalInstances(); isLoaded = true; }
// Use this for initialization void Start() { mysql = new MySqlAccess(host, port, userName, password, databaseName); //string next_id = getActionId(); //Debug.Log("neext iiiid: " + next_id); //saveStandardAction(next_id, "0"); //-----------------------删除动作-------------------------- //deleteStandardAction("400011"); //----------------------查找所有的动作--------------------- //string[,] res = findStandardActions(); //showFindActions(res); //-----------------------删除指定动作--------------------- //string[] res = deleteStandardAction("400011"); //showDeleteInfo(res); //----------------------修改指定动作----------------------- //changeStandardAction("400009", "屈指"); //----------------------添加动作--------------------------- //uploadActions("400001", "0"); //uploadPicture("400001", "F:/cat.jpg"); //string next_id = getActionId(); //Debug.Log("next_id: " + next_id); //saveStandardAction("400001", "0"); //Debug.Log("out....next"); //saveStandardAction(next_id, "1"); //addStandardAction(next_id, "拇指屈曲", "F:/115 - Learning - 暑期实训/大三/001_标准动作库/actionsPic/1_拇指屈曲.png"); //----------------------下载图片-------------------------- //downloadPicture("400011.jpg"); }
public static void DeleteTable(string connectionString, string appName, string tableName) { MySqlAccess sqlAccess = new MySqlAccess(); string sql = string.Format("drop TABLE `{0}` ", tableName); sqlAccess.ExecuteNonQuery(connectionString, sql, SqlProduct.MySql); }
// Use this for initialization void Start() { provider = FindObjectOfType <LeapProvider>() as LeapProvider; leftHands = new List <Hand>(); mysql = new MySqlAccess(host, port, userName, password, databaseName); //testMysql(); }
private void CopyDatabase(int sourceAppId, int targetAppId) { MySqlAccess sa = new MySqlAccess(); string adminConnectionString = GetAdminConnectionString(); MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(adminConnectionString); string username = connBuilder.UserID; string password = connBuilder.Password; sa.CopyDatabase(adminConnectionString, GetDatabaseName(sourceAppId), username, password, GetDatabaseName(targetAppId)); }
public static void AddBasicTable(string connectionString, string appName, string tableName) { MySqlAccess sqlAccess = new MySqlAccess(); string sql = string.Format("CREATE TABLE `{0}` ( " + "`id` INT NOT NULL AUTO_INCREMENT, " + "`name` VARCHAR(45) NULL, " + "PRIMARY KEY (`id`));", tableName); sqlAccess.ExecuteNonQuery(connectionString, sql, SqlProduct.MySql); }
/// <summary> /// 查询所有医生,返回医生编号、姓名、性别、职称、电话 /// </summary> public DataTable QueryDoctor() { mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string query = "select dc_id, dc_name, dc_sex, dc_pro, dc_tele from doc where dc_ex = 1"; DataSet ds = mysql.QuerySet(query); DataTable table = ds.Tables [0]; mysql.Close(); return(table); }
/// <summary> /// 查询未完成的训练计划 /// </summary> public static DataSet findUnfinishedTrainingPlan(string trp_ptID) { MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string querySql = "select * from trp where trp_ptID = '" + trp_ptID + "' and trp_totl > trp_finish"; DataSet ds = mysql.SimpleSql(querySql); mysql.Close(); return(ds); }
public NotasForm() { InitializeComponent(); cmbCategoria.Items.Add("Importante"); cmbCategoria.Items.Add("Expontanea"); cmbCategoria.Items.Add("Inconclusa"); cmbPrivacidad.Items.Add("Publica"); cmbPrivacidad.Items.Add("Privada"); cmbColor.Items.Add("Azul"); cmbColor.Items.Add("Gris"); cmbColor.Items.Add("Verde"); cmbColor.Items.Add("Cafe"); cmbFuente.Items.Add("Arial"); cmbFuente.Items.Add("Rive"); cmbFuente.Items.Add("Calibri"); cmbColorLetra.Items.Add("Rojo"); cmbColorLetra.Items.Add("Amarillo"); cmbColorLetra.Items.Add("Verde"); cmbColorLetra.Items.Add("Azul"); textFechaCreacion.Text = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); textFechaModificacion.Text = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); MySqlAccess mySqlBD = new MySqlAccess(); mySqlBD.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["mySqlStringConnection"].ConnectionString; mySqlBD.OpenConnection(); DataTable dataTable = new DataTable(); dataTable = mySqlBD.QuerySQL("Select * From notas where libros_idlibros =" + Libro.idLibroEstatico + ""); List <Notas> result = new List <Notas>(); for (int x = 0; x < dataTable.Rows.Count; x++) { Notas notas = new Notas(dataTable.Rows[x]["titulo"].ToString(), dataTable.Rows[x]["privacidad"].ToString(), dataTable.Rows[x]["categoria"].ToString(), dataTable.Rows[x]["notascol"].ToString(), dataTable.Rows[x]["fecha_creacion"].ToString(), dataTable.Rows[x]["fecha_modificacion"].ToString(), dataTable.Rows[x]["texto_notas"].ToString()); result.Add(notas); } ListaNotas = result; for (int i = 0; i < ListaNotas.Count; i++) { flowLayoutPanel1.Controls.Add(ListaNotas[i]); } }
//封装好的数据库类 public static void addTrainingPlan(string trp_ptID, string trp_actID, int trp_hand, int trp_num, int trp_time, int trp_totl) { MySqlAccess mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); string querySql = "insert into trp(trp_ptID, trp_actID, trp_hand, trp_num, trp_time, trp_totl) values("; querySql = querySql + "'" + trp_ptID + "', '" + trp_actID + "', '" + trp_hand + "', '" + trp_num + "', '" + trp_time + "', '" + trp_totl + "')"; Debug.Log(querySql); mysql.SimpleSql(querySql); mysql.Close(); }
private void btnAgregar_Click(object sender, EventArgs e) { if (textNombre.TextLength != 0 && textOrden.TextLength != 0) { Nombre = textNombre.Text; Orden = textOrden.Text; Color = cmbColor.Text; Categoria = cmbCategoria.Text; Ordenint = Convert.ToInt32(Orden); MySqlAccess mySql = new MySqlAccess(); String cn = "Server=localhost;Database=Database;Uid=root;Pwd=1234;"; mySql.ConnectionString = cn; mySql.OpenConnection(); mySql.BeginTransaction(); String idusuario = String.Format("SELECT idusuario from usuarios where usuario ='{0}'", Nusuario); mySql.QuerySQL(idusuario); DataTable dataTable = new DataTable(); dataTable = mySql.QuerySQL(idusuario); int idActual = Convert.ToInt32(dataTable.Rows[0][0].ToString()); idUsuarioactual = idActual; string query = string.Format("INSERT INTO libros(idlibros,nombre, categoria,color,orden,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}')", "0", textNombre.Text, cmbCategoria.Text, cmbColor.Text, Ordenint, idActual); //string query = string.Format("INSERT INTO libros('nombre', 'categoria', 'color', 'orden', 'usuarios_idusuario') values('" + textNombre.Text + "','" + (String)cmbCategoria.SelectedItem + "', '" + (String)cmbColor.SelectedItem + "'," + Ordenint + "," + idActual); String FechaHistorial = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); string query2 = string.Format("INSERT INTO transacciones(idhistorial,fecha,usuario, accion,objeto,info_adicional,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", "0", FechaHistorial, Login.Usuario, "Se agega un libro", "Agregar Libros", "Libro agregado correctamente", Login.idUsuario); mySql.EjectSQL(query2); mySql.EjectSQL(query); mySql.CommitTransaction(); mySql.CloseConnection(); this.Close(); } if (textNombre.TextLength == 0) { errorProviderAgregarLibro.SetError(textNombre, "Digite un nombre para el libro"); } if (textOrden.TextLength == 0) { errorProviderAgregarLibro.SetError(textOrden, "Digite un orden para el libro"); } }
/// <summary> /// 删除医生 /// </summary> // public void DeleteDoctor(string[] dc_id) { public void DeleteDoctor() { mysql = new MySqlAccess(host, port, userName, password, databaseName); mysql.OpenSql(); // string[] dcID = dc_id; string[] dcID = { "200001", "200002" }; for (int i = 0; i < dcID.Length; i++) { string query = "update doc set dc_ex = 0 where dc_id = '" + dcID [i] + "'"; DataSet ds = mysql.QuerySet(query); } mysql.Close(); }
// Use this for initialization void Start() { mysql = new MySqlAccess(host, port, userName, password, databaseName); //string[,] pat_infos = getPatientInfos(); //showDoubleArrays(pat_infos); //string[,] pat_plans = getPatientPlans("300001"); //showDoubleArrays(pat_plans); //string[,] pat_test = getPatientTrainRes("300001"); //showDoubleArrays(pat_test); }
public override void DropDB(string server, string catalog) { MySqlAccess sqlAccess = new MySqlAccess(); try { sqlAccess.DeleteDatabase(Connections.GetConnectionString(this.Server, this.ServerUserName, this.ServerPassword, false, GetSqlProduct()), catalog); } catch (MySql.Data.MySqlClient.MySqlException exception) { throw new DuradosException("Error occured when deleting app " + catalog + " Error message: " + exception.Message); } Maps.Instance.DuradosMap.Logger.Log("ProductMaintenance", "RemoveApp", "DropDB", null, 3, "Catalog:" + catalog + " was droped"); }
private void btnregistrarse_Click(object sender, EventArgs e) { RegistroUsuario usuario; if (txtUsuario.TextLength != 0 && txtContraseña.TextLength != 0) { usuario = new RegistroUsuario(txtContraseña.Text, txtUsuario.Text); ListaUsuario.Add(usuario); Historial historial = new Historial(txtUsuario.Text, "Usuario Registrado", "Login", ""); ListaHistorialstatica.Add(historial); MySqlAccess mySql = new MySqlAccess(); String cn = "Server=localhost;Database=Database;Uid=root;Pwd=1234;"; mySql.ConnectionString = cn; mySql.OpenConnection(); mySql.BeginTransaction(); string query = string.Format("INSERT INTO usuarios(idusuario,usuario, contraseña)VALUES('{0}','{1}','{2}')", "0", txtUsuario.Text, txtContraseña.Text); mySql.EjectSQL(query); DataTable dataTable2 = new DataTable(); String idusuarioregistrado = String.Format("SELECT idusuario from usuarios where usuario ='{0}'and contraseña= '{1}'", txtUsuario.Text, txtContraseña.Text); dataTable2 = mySql.QuerySQL(idusuarioregistrado); int idActual = Convert.ToInt32(dataTable2.Rows[0][0].ToString()); idUsuarioRegistrado = idActual; Console.WriteLine(idUsuarioRegistrado); String FechaHistorial = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); string query2 = string.Format("INSERT INTO transacciones(idhistorial,fecha,usuario, accion,objeto,info_adicional,usuarios_idusuario)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", "0", FechaHistorial, txtUsuario.Text, "Se registro un usuario", "Login", "Usuario agregado correctamente", idUsuarioRegistrado); mySql.EjectSQL(query2); mySql.CommitTransaction(); mySql.CloseConnection(); } if (txtUsuario.TextLength == 0) { LoginErrorProvider.SetError(txtUsuario, "Digite un nombre de usuario"); } if (txtContraseña.TextLength == 0) { LoginErrorProvider.SetError(txtContraseña, "Digite un nombre de contraseña"); } }