private void buttonChange_Click(object sender, EventArgs e) { int paSexInt = 1; if (paSex.Text == "男") { paSexInt = 1; } else { paSexInt = 2; } string query = "UPDATE `patient` SET `paName`='" + paName.Text + "',`paSex`='" + paSexInt + "',`paBorth`='" + paBorth.Value.ToString() + "',`paIDType`='" + paIDType.SelectedIndex + "',`paID`='" + paID.Text + "',`paAge`='" + paAge.Text + "',`paPhone`='" + paPhone.Text + "',`paAllergy`='" + paAllergy.Text + "',`paAddress`='" + paAddress.Text + "' WHERE (`CardNum`='" + cardNum.Text + "') LIMIT 1"; int updateResult = sql.update(query); switch (updateResult) { case -1:; break; case -2:; break; case 1: MessageBox.Show("更新成功"); break; } }
private void button1_Click(object sender, EventArgs e) { string name = textBox1.Text; string passwd = textBox2.Text; string firstNew = textBox3.Text; string secondNew = textBox4.Text; md5 md = new md5(); string md5Old = md.md5_passwd(passwd); string md5New = md.md5_passwd(firstNew); if (firstNew != secondNew) { MessageBox.Show("两次输入的密码不一致"); } else { mySql mysql = new mySql(); string query = "SELECT COUNT(*) FROM `user` WHERE `name`='" + name + "' AND `passwd`='" + md5Old + "'"; int returnNumber = mysql.count(query); if (returnNumber == -2) { //do nothing } else if (returnNumber == -1) { //do nothing } else if (returnNumber == 0) { MessageBox.Show("原密码错误"); } else { if (returnNumber == 1) { //change number string updatePasswd = "UPDATE `user` set passwd='" + md5New + "' WHERE name='" + name + "'"; mysql.update(updatePasswd); MessageBox.Show("改密成功"); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); } else if (returnNumber > 1) { MessageBox.Show("系统缺陷,数据库没有做主键限制,数据库中存在两个或以上的同名用户,无法改密"); } } } }
private void button1_Click(object sender, EventArgs e) { for (int i = 0; i < dataGridView1.Rows.Count; i++) { string mednum = dataGridView1.Rows[i].Cells["Column3"].Value.ToString(); string query = ""; if (mednum.Substring(0, 1) == "c") { query = "update chinesemed set ckucun = ckucun - 1 WHERE chinesemedid='" + mednum + "' "; } else { query = "update westmed set wkucun = wkucun - 1 WHERE westmedid='" + mednum + "'"; } mySql sql = new mySql(); sql.update(query); } MessageBox.Show("发药成功"); dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); textBox3.Clear(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请输入药品编号"); } else if (textBox2.Text == "") { MessageBox.Show("请输入新增库存量"); } else { if (textBox1.Text.Substring(0, 1) == "c") { string query = "SELECT COUNT(*) FROM chinesemed WHERE chinesemedid='" + textBox1.Text + "' "; mySql sql = new mySql(); int result = sql.count(query); if (result == 0) { MessageBox.Show("没有查询到该中药"); } else if (result == 1) { query = "UPDATE `chinesemed` set ckucun=ckucun+" + textBox2.Text + " WHERE chinesemedid='" + textBox1.Text + "'"; result = sql.update(query); if (result == 1) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } query = "SELECT chinesemedid,cname,ckucun FROM chinesemed WHERE chinesemedid='" + textBox1.Text + "'"; MySqlDataReader mdr = sql.searchData(query); dataGridView2.Rows.Clear(); int i = 0; while (mdr.Read()) { dataGridView2.Rows.Add(); dataGridView2.Rows[i].Cells["Column4"].Value = mdr["chinesemedid"].ToString(); dataGridView2.Rows[i].Cells["Column5"].Value = mdr["cname"].ToString(); dataGridView2.Rows[i].Cells["Column6"].Value = mdr["ckucun"].ToString(); } tabControl1.SelectedTab = tabPage2; } else { MessageBox.Show("数据库错误"); } } else if (textBox1.Text.Substring(0, 1) == "w") { string query = "SELECT COUNT(*) FROM westmed WHERE westmedid='" + textBox1.Text + "' "; mySql sql = new mySql(); int result = sql.count(query); if (result == 0) { MessageBox.Show("没有查询到该西药"); } else if (result == 1) { query = "UPDATE `westmed` set wkucun=wkucun+" + textBox2.Text + " WHERE westmedid='" + textBox1.Text + "'"; result = sql.update(query); if (result == 1) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } query = "SELECT westmedid,wname,wkucun FROM westmed WHERE westmedid='" + textBox1.Text + "'"; MySqlDataReader mdr = sql.searchData(query); dataGridView1.Rows.Clear(); int i = 0; while (mdr.Read()) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Column1"].Value = mdr["westmedid"].ToString(); dataGridView1.Rows[i].Cells["Column2"].Value = mdr["wname"].ToString(); dataGridView1.Rows[i].Cells["Column3"].Value = mdr["wkucun"].ToString(); } tabControl1.SelectedTab = tabPage1; } else { MessageBox.Show("数据库错误"); } } else { MessageBox.Show("药品编号不合法"); } } }