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("药品编号不合法");
}
}
}
