//删
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");
}
}
