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