/// <summary>
/// 更新库存方法
/// </summary>
/// <param name="num">用户输入</param>
/// <param name="key">主键</param>
/// <param name="b">true为增加，false为减少</param>
private void updateReserve(double num, int key)
{
if (num == 0)
{
return;
}
string sql_SelectReserve = "SELECT d_reserve FROM tb_drug WHERE d_id=" + key;
double reserve = (double)MySqlTools.ExecuteScalar(sql_SelectReserve);
if (reserve - num < 0)
{
MessageBox.Show(" 该药品剩余库存为:" + reserve + "\n 库存不足,请尽快补货！", "温馨提示");
}
else
{
string sql_updateReserve = string.Format("UPDATE tb_drug SET d_reserve={0} WHERE d_id={1}", reserve - num, key);
// sql_select_r_price = "SELECT d_r_price FROM tb_drug WHERE d_id=" + key;
//double money =num*(double)MySqlTools.ExecuteScalar(sql_select_r_price);
if (MySqlTools.ExecuteNonQuery(sql_updateReserve) == 1)
{
MessageBox.Show("出库成功！", "温馨提示");
}
else
{
MessageBox.Show("出库失败！", "温馨提示");
}
}
//}
}
/// <summary>
/// 修改密码按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bun_ch_Click(object sender, EventArgs e)
{
string sql = string.Format("UPDATE tb_pwd SET pwd='{0}' where id=1", tb_pwdCh.Text);
if ((int)MySqlTools.ExecuteNonQuery(sql) == 1)
{
MessageBox.Show("密码更改成功，请牢记！\n" + tb_pwdCh.Text, "温馨提示");
}
else
{
MessageBox.Show("密码更改失败！", "温馨提示");
}
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
string caption = "温馨提示";
string message = "是否删除该条数据？";
MessageBoxButtons btn = MessageBoxButtons.YesNo;
DialogResult result = new DialogResult();
result = MessageBox.Show(message, caption, btn);
if (result == System.Windows.Forms.DialogResult.Yes)
{
string sql = "delete from tb_drug where d_id=" + KEY;
if (MySqlTools.ExecuteNonQuery(sql) > 0)
{
MessageBox.Show("成功删除该条记录！", "温馨提示");
BindAll_K();
}
}
}
private void button10_Click(object sender, EventArgs e)
{
string caption = "温馨提示";
string message = "是否删除该记录？";
MessageBoxButtons btn = MessageBoxButtons.YesNo;
DialogResult result = new DialogResult();
result = MessageBox.Show(message, caption, btn);
if (result == System.Windows.Forms.DialogResult.Yes)
{
DateTime dt = dateTimePicker1.Value;
string time = dt.ToLongDateString().ToString();
string sql = "delete from tb_order";
if (MySqlTools.ExecuteNonQuery(sql) > 0)
{
MessageBox.Show("成功删除该记录！", "温馨提示");
BindAndShow();
}
}
}
