private void button1_Click(object sender, EventArgs e) { string sex = "男"; //默认性别为男 if (this.radioButton2.Checked == true) { sex = "女"; } //判断用户名,密码,科室,年龄不能为空 if (this.textBox6.Text.Trim() == "") { MessageBox.Show("姓名不能为空"); this.Focus(); return; } if (this.textBox1.Text.Trim() == "") { MessageBox.Show("账号不能为空"); this.Focus(); return; } if (this.radioButton1.Checked == false && this.radioButton2.Checked == false) { MessageBox.Show("性别不能为空"); this.Focus(); return; } if (this.textBox2.Text.Trim() == "") { MessageBox.Show("年龄不能为空"); this.Focus(); return; } string sql = "update dbo.login set uname='" + this.textBox6.Text.Trim() + "',age='" + this.textBox2.Text.Trim() + "',sex='" + sex + "'where uid='" + this.textBox1.Text.Trim() + "'"; SqlConnection con = DBhelper.Gethelper(); //调用DBhelp类中的方法,连接数据库 SqlCommand com = new SqlCommand(sql, con); //创建command对象执行SQL语句 con.Open(); int count = com.ExecuteNonQuery(); con.Close(); if (count > 0) //判断数据库中受影响的行数 { string Message = string.Format("修改成功!"); MessageBox.Show(Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public string Getcount(string sql) { SqlConnection con = DBhelper.Gethelper(); sql = "select friend from dbo.Friend where id='" + Login.denglu + "'"; //查询医生有多少病员用的SQL语句 SqlCommand com = new SqlCommand(sql, con); con.Open(); string reng = com.ExecuteScalar().ToString(); //执行SQL语句返回一行一列的值 string[] bb = reng.Split('|'); //以'|'为分割符分割字符串 int temp = bb.Length - 1; //执行一次减少一个病人 lblCount.Text = Convert.ToString(temp); return(sql); }
public static bool Getz(string sql1) //静态bool型的Getz方法 { SqlConnection con1 = DBhelper.Gethelper(); //创建 SqlConnection对象 SqlCommand com2 = new SqlCommand(sql1, con1); con1.Open(); int count = com2.ExecuteNonQuery(); //接收受影响的行数 if (count > 0) //如果有影响行数 { //返回true return(true); } else { return(false); } }
//完成增删改查的方法 public static bool Getzsgc(string sql) { SqlConnection con = DBhelper.Gethelper(); SqlCommand com = new SqlCommand(sql, con); con.Open(); int temp = com.ExecuteNonQuery(); if (temp != 0) { return(true); } else { return(false); } }
private void button3_Click(object sender, EventArgs e) { if (this.textBox3.Text.Trim() == "" | this.textBox7.Text.Trim() == "") //判断输入的身份证格式 { MessageBox.Show("输入正确的登录密码或账号"); this.textBox3.Focus(); //重新输入 return; } else { SqlConnection con = DBhelper.Gethelper(); //打开连接 try { ff = this.textBox3.Text; //变量接收身份证验证文本框值 if (this.textBox4.Text != this.textBox5.Text) { MessageBox.Show("新密码不一致", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.textBox4.Clear(); this.textBox5.Clear(); //值清空 this.textBox4.Focus(); //聚焦身份证文本框 } else { string sql = "update dbo.login set pwd='" + this.textBox4.Text.Trim() + "'where uid='" + this.textBox7.Text.Trim() + "'"; SqlCommand com = new SqlCommand(sql, con);//创建command对象执行SQL语句 con.Open(); int count = com.ExecuteNonQuery(); con.Close(); if (count > 0) //判断数据库中受影响的行数 { string Message = string.Format("保存成功!"); MessageBox.Show(Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception) { this.textBox1.Clear(); MessageBox.Show("保存失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
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 btnserch_Click_1(object sender, EventArgs e) //查询按钮 { if (this.txtsfz1.Text.Trim() == "") //判断输入的身份证格式 { MessageBox.Show("输入正确的身份证号"); this.txtsfz1.Focus(); //重新输入 return; } else { SqlConnection con = DBhelper.Gethelper(); //打开连接 try { sfz = this.txtsfz1.Text; //变量接收身份证验证文本框值 if (sfz.Length < 18 && sfz.Length > 15) { MessageBox.Show("身份证格式不正确", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.txtsfz1.Clear(); //值清空 this.txtsfz1.Focus(); //聚焦身份证文本框 } else { string sql = "select pname,psex,page,blood,phone,adds from [user] where psfz='" + this.txtsfz1.Text.Trim() + "'"; DataSet ds = getds(sql); //查询有未有过病史判断是否来过调用方法重新创建数据集 txtname1.Text = ds.Tables[0].Rows[0][0].ToString(); //将值赋给各属性文本框 txtsex1.Text = ds.Tables[0].Rows[0][1].ToString(); txtage1.Text = ds.Tables[0].Rows[0][2].ToString(); txtblood.Text = ds.Tables[0].Rows[0][3].ToString(); txtphone1.Text = ds.Tables[0].Rows[0][4].ToString(); txtadd1.Text = ds.Tables[0].Rows[0][5].ToString(); txtbh.Text = Num.ToString(); } } catch (Exception) { this.txtsfz1.Clear(); MessageBox.Show("未找到,请您先挂号", "挂号提示", MessageBoxButtons.OK, MessageBoxIcon.Information); panel2.Visible = true; //注册病历窗口打开,查询挂号窗口关闭 panel1.Visible = false; } } }
private void button1_Click(object sender, EventArgs e) { if (this.textBox1.Text.Trim() == "") //判断输入的身份证格式 { MessageBox.Show("输入正确的身份证号"); this.textBox1.Focus(); //重新输入 return; } else { SqlConnection con = DBhelper.Gethelper(); //打开连接 try { sfz = this.textBox1.Text; //变量接收身份证验证文本框值 if (sfz.Length < 18 && sfz.Length > 15) { MessageBox.Show("身份证格式不正确", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.textBox1.Clear(); //值清空 this.textBox1.Focus(); //聚焦身份证文本框 } else { string sql = "select bingkuang from [bingkuang] where psfzId='" + this.textBox1.Text.Trim() + "'"; SqlCommand com = new SqlCommand(sql, con);//查询有未有过病史判断是否来过调用方法重新创建数据集 SqlDataAdapter da = new SqlDataAdapter(com); da.Fill(ds); List <String> list = new List <string>(); foreach (DataRow row in ds.Tables[0].Rows) { list.Add(row[0].ToString()); } richTextBox1.Lines = list.ToArray(); //将值赋给各属性文本框 } } catch (Exception) { this.textBox1.Clear(); MessageBox.Show("未找到,请您先挂号", "挂号提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void btnok_Click(object sender, EventArgs e) //确定按钮 { SqlConnection con = DBhelper.Gethelper(); con.Open(); string sid = Convert.ToString(register.Num); //声明sid变量获取强转String后的register类的Num变量 string sid1 = sid + "|"; //声明sid1变量获取sid和"|" int tem = 0; //声明int型的tem变量 if (dataGridView1.SelectedCells.Count == 0) //判断用户有未选择dataGridView的单元格 { MessageBox.Show("请选择一个医生!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else //获取当前选中的这一行第一个单元格的值,obj型转为String后强转int型用tem接收 { tem = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); string sql1 = "select friend from Friend where id='" + tem + "'"; //查询条件为医生的id SqlCommand com = new SqlCommand(sql1, con); try { string bianhao = com.ExecuteScalar().ToString(); //用string型bianhao变量接收返回的值 string sidd = bianhao + sid1; //将bianhao和sid1变量赋给sidd sql1 = "update Friend set friend='" + sidd + "' where id='" + tem + "'"; //将sidd的值更新到条件为该医生id号的行friend的列 Getz(sql1); //调用 Getz方法执行 MessageBox.Show("挂号成功!"); //成功后返回查询挂号窗体 register obj = new register(); obj.Show(); this.Hide(); //该窗体隐藏 } catch (Exception) { MessageBox.Show("选择有错", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } con.Close(); //关闭连接 }
private void save_Click(object sender, EventArgs e) { int accounts = 0; string sex = "男"; //默认性别为男 if (this.radiogirl.Checked == true) { sex = "女"; } string type = "挂号台"; if (this.DrRadio.Checked == true) { type = "医生"; } //判断用户名,密码,科室,年龄不能为空 if (this.trueName.Text.Trim() == "") { MessageBox.Show("用户名不能为空"); this.Focus(); return; } if (this.code.Text.Trim() == "") { MessageBox.Show("密码不能为空"); this.Focus(); return; } if (this.DrRadio.Checked == true && this.comboBox1.Text == "") { MessageBox.Show("科室不能为空"); this.Focus(); return; } if (this.ageAasked.Text.Trim() == "") { MessageBox.Show("年龄不能为空"); this.Focus(); return; } //向数据库插入注册的SQL语句 string sql = "insert into dbo.login values ('" + this.code.Text.Trim() + "','" + this.trueName.Text.Trim() + "','" + sex + "','" + this.ageAasked.Text.Trim() + "','" + type + "','" + this.comboBox1.Text.Trim() + "',0)"; SqlConnection con = DBhelper.Gethelper(); //调用DBhelp类中的方法,连接数据库 SqlCommand com = new SqlCommand(sql, con); //创建command对象执行SQL语句 con.Open(); int count = com.ExecuteNonQuery(); con.Close(); if (count > 0) //判断数据库中受影响的行数 { con.Open(); string sql1 = "select top 1 uid from dbo.login order by uid desc"; //将数据库中的数据按降序排列并查找出第一个 com.CommandText = sql1; accounts = Convert.ToInt32(com.ExecuteScalar()); //生成帐号 string Message = string.Format("注册成功!您的帐号是{0}", accounts); MessageBox.Show(Message, "注册成功", MessageBoxButtons.OK, MessageBoxIcon.Information); con.Close(); } sql = "insert into dbo.Friend(id,kemu,name) values(" + accounts + ",'" + this.comboBox1.Text + "','" + this.trueName.Text + "')"; Mindoc.Getzsgc(sql); }
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); } } }