private void btn_search_Click(object sender, EventArgs e) { int rowCount = 0; if (rdo_visitno.Checked) { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT COUNT(1) FROM tb_card c WHERE c.visitNo='" + tb_searchvn.Text.Trim() + "';"; conn.Open(); rowCount = (int)comm.ExecuteScalar(); conn.Close(); if (rowCount == 1) { tb_cardno.Text = tb_searchvn.Text.Trim(); } else { MessageBox.Show("您输入的就诊卡号不存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); tb_searchvn.Focus(); tb_searchvn.SelectAll(); } } if (rdo_patientno.Checked) { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT COUNT(1) FROM tb_card c WHERE c.patientNo='" + tb_searchPatienNo.Text.Trim() + "' AND c.cardType=0;"; conn.Open(); rowCount = (int)comm.ExecuteScalar(); conn.Close(); if (rowCount == 1) { tb_patientno.Text = tb_searchPatienNo.Text.Trim(); } else { MessageBox.Show("您输入的患者编号不存在或该患者没有就诊卡,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); tb_searchPatienNo.Focus(); tb_searchPatienNo.SelectAll(); } } }
private void cmb_docname_SelectedIndexChanged(object sender, EventArgs e) { cmb_dept.Enabled = false; SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT d1.name FROM tb_dept d1,tb_doctor d2 WHERE d2.NAME='" + cmb_docname.SelectedItem.ToString() + "' AND d2.deptNo=d1.NO;"; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); dr.Read(); cmb_dept.SelectedItem = dr["Name"].ToString(); dr.Close(); conn.Close(); }
//获取医院信息 public void getHospitalInfo() { sqlHelper mysql = new sqlHelper(); SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT name, ADDRESS FROM tb_hospital WHERE signUpCode='" + userHelper.signUpCode + "';"; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { userHelper.hospitalName = dr["Name"].ToString(); userHelper.hospitalAddress = dr["ADDRESS"].ToString(); } dr.Close(); conn.Close(); }
private void tb_patientNo_TextChanged(object sender, EventArgs e) { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT cardType,id,visitNo,balance,creditLimit FROM dbo.tb_card WHERE patientNo='" + tb_patientNo.Text.Trim() + "';"; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { cmb_cardType.SelectedIndex = Convert.ToInt32(dr["cardType"]); tb_id.Text = dr["id"].ToString(); tb_cardNo.Text = dr["visitNo"].ToString(); tb_balance.Text = dr["balance"].ToString(); tb_creditLimit.Text = dr["creditLimit"].ToString(); } dr.Close(); conn.Close(); }
private void tb_patientno_TextChanged(object sender, EventArgs e) { if (tb_patientno.Text == "") { tb_tel.Text = ""; tb_email.Text = ""; } else { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT tel,email FROM dbo.tb_patient WHERE No='" + tb_patientno.Text.Trim() + "';"; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { tb_tel.Text = dr["tel"].ToString(); tb_email.Text = dr["email"].ToString(); } dr.Close(); conn.Close(); } }
private void btn_search_Click(object sender, EventArgs e) { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT NO,NAME,DSCP FROM tb_dept WHERE NO=" + tb_schNo.Text.Trim() + ";"; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { tb_id.Text = dr["NO"].ToString(); tb_name.Text = dr["NAME"].ToString(); rtb_dscp.Text = dr["DSCP"].ToString(); } else { MessageBox.Show("科室编号不存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); tb_schNo.Focus(); tb_schNo.SelectAll(); } dr.Close(); conn.Close(); }
private void btn_logIn_Click(object sender, EventArgs e) { if (rdo_remote.Checked) { sqlHelper.sqlconstr = @"Server=192.168.189.128; Database=OPRSBase; UID=sa; Pwd=sa"; } if (rdo_backup.Checked) { sqlHelper.sqlconstr = @"Server=SERVER-1; Database=OPRSBase; UID=jsj; Pwd=2wsx@WSX"; } if (rdo_local.Checked) { sqlHelper.sqlconstr = @"Server=(local); Database=OPRSBase; Integrated Security=sspi"; } if (texbox_psw.Text == "") { userHelper.operatorNo = texbox_userName.Text.Trim(); SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT COUNT(1) FROM tb_operator WHERE No='" + userHelper.operatorNo + "' AND password IS NULL;"; conn.Open(); int rowCount = (int)comm.ExecuteScalar(); conn.Close(); if (rowCount == 1) { this.Enabled = false; Frm_firstTimeLogin frm = new Frm_firstTimeLogin(); frm.Show(); } else { MessageBox.Show("用户名或密码错误,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); texbox_userName.Focus(); texbox_userName.SelectAll(); } } else { SqlConnection conn = mysql.getcon(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "SELECT * FROM tb_operator WHERE No=@No AND Password=HASHBYTES('SHA',@Password);"; comm.Parameters.AddWithValue("@No", this.texbox_userName.Text.Trim()); comm.Parameters["@No"].SqlDbType = SqlDbType.VarChar; comm.Parameters.AddWithValue("@Password", this.texbox_psw.Text.Trim()); comm.Parameters["@Password"].SqlDbType = SqlDbType.VarChar; conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { this.DialogResult = DialogResult.OK; userHelper.operatorNo = this.texbox_userName.Text.Trim(); userHelper.operatorName = dr["Name"].ToString(); userHelper.operatorPsw = this.texbox_psw.Text.Trim(); this.Close(); } else { MessageBox.Show("用户名或密码错误,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.texbox_psw.Focus(); this.texbox_psw.SelectAll(); } dr.Close(); conn.Close(); } }