private void button4_Click(object sender, EventArgs e)
{
try
{
int card_id = Convert.ToInt32(textBox6.Text);
long doc_id = 10015;
string m_his = richTextBox1.Text;
string t_d = richTextBox3.Text;
string inf = comboBox2.SelectedItem.ToString();
string com = @"INSERT prescription VALUES({0},{1},{2},'{3}','{4}','{5}');";
com = string.Format(com, pb_id, card_id, doc_id, m_his, t_d, inf);
DbOS.GetSqlcom(com);
string com1 = @"SELECT cnt FROM inf WHERE inf_name = '{0}';";
com1 = string.Format(com1, inf);
DataTable inf_table = new DataTable();
inf_table = DbOS.dataSet(com1).Tables[0];
int cnt = Convert.ToInt32(inf_table.Rows[0][0].ToString());
cnt = cnt + 1;
string com2 = @"UPDATE inf SET cnt = {0} WHERE inf_name = '{1}';";
com2 = string.Format(com2, cnt, inf);
DbOS.GetSqlcom(com2);
button6_Click(sender, e);
}
catch
{
MBox.Warn("请输入病历！");
}
}
private void button2_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(textBox1.Text.ToString());
string sql = @"SELECT password FROM login WHERE id = {0};";
sql = string.Format(sql, id);
DataTable pw_table = DbOS.dataSet(sql).Tables[0];
string pw = pw_table.Rows[0][0].ToString();
string tpw = textBox3.Text.ToString();
if (tpw == textBox4.Text.ToString())
{
if (pw == textBox2.Text.ToString())
{
string com = @"UPDATE login SET password = '******' WHERE id ={1} ;";
com = string.Format(com, tpw, id);
DbOS.GetSqlcom(com);
MBox.Hint1("修改成功！");
this.Close();
}
else
{
MBox.Warn("原始密码错误！");
}
}
else
{
MBox.Warn("两次密码不匹配！");
}
}
public bool logout()
{
if (MBox.Hint1("确定需要退出吗？"))
{
user.Dispose(); //退出账户时可以进行内存释放
GC.Collect(); //强制回收内存
return(true);
}
else
{
return(false);
}
}
private void label10_Click(object sender, EventArgs e)
{
try
{
string com = @"DELETE patient WHERE id ={0};";
com = string.Format(com, Patient.Id);
DbOS.GetSqlcom(com);
MBox.Warn("注销成功！");
}
catch
{
MBox.Warn("注销有误！");
}
}
private void label22_Click(object sender, EventArgs e)
{
try
{
Pat_Message();
string com = @"UPDATE patient SET pat_name = '{0}',pat_telnum = '{1}',pat_id='{2}',is_married = '{3}',pat_address='{4}',pat_pre_his = '{5}',pat_allegen='{6}' WHERE id ={7} ;";
com = string.Format(com, Patient.Pat_name, Patient.Pat_telnum, Patient.Pat_id, Patient.Is_married, Patient.Pat_address, Patient.Pat_pre_his, Patient.Pat_allergen, Patient.Id);
DbOS.GetSqlcom(com);
MBox.Warn("修改成功！");
}
catch
{
MBox.Warn("修改有误！");
}
}
private static MySqlConnection conn; //连接为全局变量
/*为了减少对象的创建，使用静态方法*/
/// <summary>
/// 建立数据库连接
/// </summary>
/// <returns></returns>
public static MySqlConnection Open() //连接方法
{
//string constr = @"Server=localhost;User ID=root;Password=LHJ1996;Database=hisdb;CharSet='utf8';";
string constr = @"server=210.38.111.41;port=5656;user=root;password=123456; database=hisdb;CharSet='utf8';";
try
{
conn = new MySqlConnection(constr);
conn.Open(); //连接成功
return(conn);
}
catch (Exception ex)
{
MBox.Warn("内部错误！");
return(null);
}
}
/// <summary>
/// 初始化专科信息
/// </summary>
private void br_dep_load()
{
try
{
DataTable br_dep_table = new DataTable();
br_dep_table = br_department.Br_dep_search(comboBox1.SelectedItem.ToString());
foreach (DataRow row in br_dep_table.Rows)
{
string br_de_items = row[0].ToString();
comboBox2.Items.Add(br_de_items);
}
br_dep_table.Dispose();
comboBox2.SelectedIndex = 0;
}
catch
{
MBox.Warn("该科室暂无医生！");
}
}
private void Pat_show()
{
DataTable pat_table = new DataTable();
string pat_id = textBox3.Text;
string id = textBox1.Text;
try
{
string com = string.Empty;
if (pat_id.Length == 18)
{
com = string.Format("SELECT * FROM patient WHERE pat_id = '{0}'", pat_id);
}
if (id.Length == 10)
{
com = string.Format("SELECT * FROM patient WHERE id = {0}", id);
}
pat_table = DbOS.dataSet(com).Tables[0];
textBox1.Text = pat_table.Rows[0][0].ToString();
textBox2.Text = pat_table.Rows[0][1].ToString();
textBox3.Text = pat_table.Rows[0][3].ToString();
string bir = textBox3.Text.ToString().Substring(6, 8).Trim();
dateTimePicker1.Value = DateTime.ParseExact(bir, "yyyyMMdd", null);
bool married = Convert.ToBoolean(pat_table.Rows[0][4].ToString());
if (married)
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
textBox4.Text = pat_table.Rows[0][2].ToString();
textBox5.Text = pat_table.Rows[0][5].ToString();
comboBox6.Text = pat_table.Rows[0][7].ToString();
richTextBox1.Text = pat_table.Rows[0][6].ToString();
}
catch
{
MBox.Warn("请输入正确的身份证号或诊疗卡号！");
}
}
/// <summary>
/// 初始化医生
/// </summary>
private void doc_load()
{
DataTable doc_table = new DataTable();
doc_table = Docotor.doc_search(comboBox2.SelectedItem.ToString());
foreach (DataRow row in doc_table.Rows)
{
string doc_items = row[0].ToString();
comboBox4.Items.Add(doc_items);
}
doc_table.Dispose();
try
{
comboBox4.SelectedIndex = 0;
}
catch (Exception ex)
{
MBox.Warn("该科室仍无医师！");
}
}
/// <summary>
/// 时间段的初始化
/// </summary>
private void time_load()
{
DataTable time_table = new DataTable();
time_table = Docotor.time_search(comboBox5.SelectedItem.ToString(), comboBox4.SelectedItem.ToString());
foreach (DataRow row in time_table.Rows)
{
string time_items = row[0].ToString();
comboBox9.Items.Add(time_items);
}
time_table.Dispose();
try
{
comboBox9.SelectedIndex = 0;
}
catch (Exception ex)
{
MBox.Warn("已满号！");
}
}
/// <summary>
/// 返回需要的对象
/// </summary>
/// <param name="index"></param>
/// <param name="password"></param>
/// <returns></returns>
public static UserControl Choose(string uid, int index, string password) //简单工厂模式
{
UserControl user = null;
try
{
int id = Convert.ToInt32(uid);
string sql = @"SELECT password FROM login WHERE id = {0};";
sql = string.Format(sql, id);
DataTable pw_table = DbOS.dataSet(sql).Tables[0];
string pw = pw_table.Rows[0][0].ToString();
if (pw == password)
{
switch (index)
{
case 0:
user = new Regestrion(id);
break;
case 1:
user = new OutPatient(id);
break;
case 2:
user = new Chasier(id);
break;
}
}
else
{
string message = "账号或密码错误！";
MBox.Warn(message);
}
}
catch
{
MBox.Warn("请输入账号和密码！");
}
return(user);
}
/// <summary>
/// 病人信息插入
/// </summary>
private void Pat_Message()
{
try
{
Patient.Id = Convert.ToInt32(textBox1.Text);
Patient.Pat_name = textBox2.Text;
Patient.Pat_id = textBox3.Text;
string bir = Patient.Pat_id.Substring(6, 8).Trim();
dateTimePicker1.Value = DateTime.ParseExact(bir, "yyyyMMdd", null);
Patient.Is_married = Convert.ToInt16(radioButton1.Checked);
Patient.Pat_telnum = textBox4.Text;
Patient.Pat_address = textBox5.Text;
Patient.Pat_allergen = comboBox6.Text;
Patient.Pat_pre_his = richTextBox1.Text;
Patient.Start = comboBox5.Text;
Patient.End = comboBox9.Text;
}
catch
{
MBox.Warn("信息填写错误！");
}
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
MBox.Hint1("请联系10086！");
}
