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!"); }