private void btnregito_Click_2(object sender, EventArgs e) //挂号按钮
{
if (this.txtsfz1.Text.Trim() == "") //判断身份证号文本框为空否
{
MessageBox.Show("输入身份证号或填写新病历");
return;
}
else
{
string sql = "select psfz from [user] where psfz='" + txtsfz1.Text.Trim() + "'";
SqlConnection con = DBhelper.Gethelper(); //验证该身份证有否病史
SqlCommand com = new SqlCommand(sql, con);
con.Open();
try
{
string idcard = com.ExecuteScalar().ToString(); //声明变量查询返回第一行第一列的值
if (idcard == txtsfz1.Text.Trim()) //找到记录的记录是否与文本框一致
{
sql = "insert into [user](pname,psex,page,blood,phone,psfz,[money],adds) values('" + this.txtname1.Text.Trim() + "','" + txtsex1.Text.Trim() + "','" + this.txtage1.Text.Trim() + "','" + txtblood.Text + "','" + this.txtphone1.Text.Trim() + "','" + this.txtsfz1.Text.Trim() + "','0','" + this.txtadd1.Text.Trim() + "') ";
com = new SqlCommand(sql, con); //将有病史的病人的资料重新插入数据库一次
int temp = com.ExecuteNonQuery(); //声明变量获取插入成功的行数，只要不为0就成功
if (temp != 0)
{
sql = "select top 1 [pid] from [user] order by [pid] desc"; //找到此人本次看病的编号
com.CommandText = sql;
Num = Convert.ToInt32(com.ExecuteScalar().ToString());
string aa = string.Format("您本次挂号临时编号为{0}", Num);
MessageBox.Show(aa, "领取成功！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
con.Close();
Relook obj = new Relook(); //挂号窗口打开，此窗体隐藏
obj.Show();
this.Hide();
}
}
}
catch (Exception)
{
this.txtsfz1.Clear();
MessageBox.Show("输入有错，请输入正确的身份证号查询或注册新病历！");
}
}
}
private void btnUp_Click_1(object sender, EventArgs e) //提交按钮
{
sfz = this.txtsfz.Text; //给变量赋值
if (this.txtsfz.Text.Trim() == "") //判断身份证为不为空
{
MessageBox.Show("请输入身份证");
this.txtsfz.Focus();
}
else if (this.txtage.Text.Trim() == "")
{
MessageBox.Show("请输入年龄");
this.txtage.Focus();
}
else if (this.txtname.Text.Trim() == "")
{
MessageBox.Show("请输入真实姓名");
this.txtname.Focus();
}
else if (this.txtphone.Text.Trim() == "")
{
MessageBox.Show("请输入联系方式");
this.txtphone.Focus();
}
else if (this.txtadd.Text.Trim() == "")
{
MessageBox.Show("请输入住址");
this.txtadd.Focus();
}
else
{
try
{
long sfz1 = Convert.ToInt64(this.txtsfz.Text); //声明身份证的变量接受强转INT型的身份证文本框的值
int age7 = Convert.ToInt32(this.txtage.Text); //声明年龄的变量接受强转INT型的年龄文本框的值
if (age7 >= 1 && age7 <= 130) //判断年龄规范
{
SqlConnection con = DBhelper.Gethelper(); //声明SqlConnection对象
string sex = "男"; //给变量附初始值＝男
if (this.radioButton2.Checked == true) //用户选择的按钮2被选中的话，变量为 女
{
sex = "女";
}
string sql = "insert into [user](pname,psex,page,blood,phone,psfz,[money],adds) values('" + this.txtname.Text.Trim() + "','" + sex + "','" + this.txtage.Text.Trim() + "','" + this.cbxblood.SelectedItem.ToString() + "','" + this.txtphone.Text.Trim() + "','" + this.txtsfz.Text.Trim() + "','0','" + this.txtadd.Text.Trim() + "') ";
SqlCommand com = new SqlCommand(sql, con); //往[user]表里添加病人信息,声明SqlCommand对象
con.Open(); //打开连接
int temp = com.ExecuteNonQuery(); //声明变量接收SqlCommand对象的ExecuteNonQuery方法
if (temp != 0)
{
sql = "select top 1 [pid] from [user] order by [pid] desc"; //降序排列得到[user]表中新注册用户的自动增长列
com.CommandText = sql; //获取SQL语句
Num = Convert.ToInt32(com.ExecuteScalar().ToString()); //用静态变量接收强转INT型的查询所返回的1行1列的值即ID
string aa = string.Format("您的电子病历号是{0}", Num);
MessageBox.Show(aa, "电子病历注册成功！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
con.Close(); //声明aa变量接收格式化后的字符串用消息框弹出成功信息
Relook obj1 = new Relook(); //病历注册后即进入挂号窗口
obj1.Show();
this.Hide(); //此窗体隐藏
}
}
else
{
MessageBox.Show("年龄格式不正确", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.txtage.Focus();
}
}
catch (Exception)
{
MessageBox.Show("请输入数字", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}