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