private void button2_Click(object sender, EventArgs e) { if (textBox3.Text == "") { MessageBox.Show("请输入就诊号"); } else { MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; sql.openConnetction(); cmd = new MySqlCommand("SELECT * FROM chufang WHERE regid='" + textBox3.Text + "'", sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView1.DataSource = dtb; this.dataGridView1.AutoGenerateColumns = false; this.dataGridView1.Columns["Column19"].DataPropertyName = dtb.Columns["painame"].ToString(); this.dataGridView1.Columns["Column3"].DataPropertyName = dtb.Columns["medid"].ToString(); this.dataGridView1.Columns["Column1"].DataPropertyName = dtb.Columns["medname"].ToString(); this.dataGridView1.Columns["Column7"].DataPropertyName = dtb.Columns["meddanwei"].ToString(); this.dataGridView1.Columns["Column2"].DataPropertyName = dtb.Columns["medshuliang"].ToString(); this.dataGridView1.Columns["Column5"].DataPropertyName = dtb.Columns["medyongfa"].ToString(); this.dataGridView1.Columns["Column6"].DataPropertyName = dtb.Columns["medyongliang"].ToString(); this.dataGridView1.Columns["Column4"].DataPropertyName = dtb.Columns["medkaifang"].ToString(); this.dataGridView1.Columns["Column16"].DataPropertyName = dtb.Columns["meddate"].ToString(); this.dataGridView1.Columns["painame"].Visible = false; this.dataGridView1.Columns["medid"].Visible = false; this.dataGridView1.Columns["medname"].Visible = false; this.dataGridView1.Columns["meddanwei"].Visible = false; this.dataGridView1.Columns["medshuliang"].Visible = false; this.dataGridView1.Columns["medyongfa"].Visible = false; this.dataGridView1.Columns["medyongliang"].Visible = false; this.dataGridView1.Columns["medkaifang"].Visible = false; this.dataGridView1.Columns["meddate"].Visible = false; this.dataGridView1.Columns["regid"].Visible = false; this.dataGridView1.Columns["paid"].Visible = false; this.dataGridView1.Columns["medjiage"].Visible = false; this.dataGridView1.Columns["medzongjia"].Visible = false; this.dataGridView1.Columns["medclass"].Visible = false; this.dataGridView1.Columns["meddoctor"].Visible = false; sql.closeConnection(); } }
//查询医生排班信息 private void button13_Click(object sender, EventArgs e) { { if (textBox12.Text == "") { MessageBox.Show("请输入医生工号"); } else { dataGridView2.DataSource = null; string query = "SELECT doctorID,data,time,classanddoctor.class,classanddoctor.name,classanddoctor.phone FROM `regandduty` INNER JOIN `classanddoctor` ON regandduty.doctorID=classanddoctor.ID WHERE `data`='" + dateTimePicker1.Value.Date.ToString() + "' AND `doctorID`='" + textBox12.Text + "'"; MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; sql.openConnetction(); cmd = new MySqlCommand(query, sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView2.DataSource = dtb; this.dataGridView2.AutoGenerateColumns = false; this.dataGridView2.Columns["Column6"].DataPropertyName = dtb.Columns["data"].ToString(); this.dataGridView2.Columns["Column7"].DataPropertyName = dtb.Columns["time"].ToString(); this.dataGridView2.Columns["Column8"].DataPropertyName = dtb.Columns["class"].ToString(); this.dataGridView2.Columns["Column9"].DataPropertyName = dtb.Columns["doctorID"].ToString(); this.dataGridView2.Columns["Column10"].DataPropertyName = dtb.Columns["name"].ToString(); this.dataGridView2.Columns["Column11"].DataPropertyName = dtb.Columns["phone"].ToString(); this.dataGridView2.Columns["data"].Visible = false; this.dataGridView2.Columns["time"].Visible = false; this.dataGridView2.Columns["class"].Visible = false; this.dataGridView2.Columns["doctorID"].Visible = false; this.dataGridView2.Columns["name"].Visible = false; this.dataGridView2.Columns["phone"].Visible = false; } } }
private void button15_Click(object sender, EventArgs e) { //string query = "SELECT regID,doctorID,paiID,data,time FROM `regandduty` WHERE `data`='" + dateTimePicker2.Value.Date.ToString() + "' AND `ifUse`='1'"; string query = "SELECT regandduty.regID,patient.paName,classanddoctor.class,classanddoctor.`name`,regandduty.`level`,regandduty.regtype,case WHEN time='20:00:00' THEN '是' WHEN time!='20:00:00' THEN '否' end AS `ifjiahao`,regandduty.time,regandduty.paytype,regandduty.regpay FROM regandduty INNER JOIN patient ON regandduty.paiID=patient.CardNum INNER JOIN classanddoctor ON regandduty.doctorID=classanddoctor.ID WHERE regandduty.data='" + dateTimePicker2.Value.Date.ToString() + "' AND regandduty.ifUse='1'"; Console.WriteLine(query); MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; sql.openConnetction(); cmd = new MySqlCommand(query, sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView4.DataSource = dtb; this.dataGridView4.AutoGenerateColumns = false; this.dataGridView4.Columns["Column12"].DataPropertyName = dtb.Columns["regID"].ToString(); this.dataGridView4.Columns["Column14"].DataPropertyName = dtb.Columns["paName"].ToString(); this.dataGridView4.Columns["Column15"].DataPropertyName = dtb.Columns["class"].ToString(); this.dataGridView4.Columns["Column13"].DataPropertyName = dtb.Columns["name"].ToString(); this.dataGridView4.Columns["Column17"].DataPropertyName = dtb.Columns["regtype"].ToString(); this.dataGridView4.Columns["Column18"].DataPropertyName = dtb.Columns["level"].ToString(); this.dataGridView4.Columns["Column19"].DataPropertyName = dtb.Columns["ifjiahao"].ToString(); this.dataGridView4.Columns["Column20"].DataPropertyName = dtb.Columns["time"].ToString(); this.dataGridView4.Columns["Column21"].DataPropertyName = dtb.Columns["paytype"].ToString(); this.dataGridView4.Columns["Column22"].DataPropertyName = dtb.Columns["regpay"].ToString(); //this.dataGridView4.Columns["Column19"].DataPropertyName = dtb.Columns["ifjiahao"].ToString(); this.dataGridView4.Columns["regID"].Visible = false; this.dataGridView4.Columns["paName"].Visible = false; this.dataGridView4.Columns["class"].Visible = false; this.dataGridView4.Columns["name"].Visible = false; this.dataGridView4.Columns["level"].Visible = false; this.dataGridView4.Columns["regtype"].Visible = false; this.dataGridView4.Columns["ifjiahao"].Visible = false; this.dataGridView4.Columns["time"].Visible = false; this.dataGridView4.Columns["paytype"].Visible = false; this.dataGridView4.Columns["regpay"].Visible = false; }
//重绘列值 //查询科室信息 private void buttonCountClass_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == -1 && comboBox1.Text == "") { MessageBox.Show("请选择科室类别"); } else { string classtype = comboBox1.SelectedItem.ToString(); MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; sql.openConnetction(); cmd = new MySqlCommand("SELECT ID,name,classType,class,case when `level` = '1' then '专家'when `level` = '2' then '主任医师'when `level` = '3'then '副主任医师' WHEN `level`= '4' THEN '医师'end as `level` FROM classanddoctor WHERE classType='" + classtype + "'", sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView1.DataSource = dtb; this.dataGridView1.AutoGenerateColumns = false; this.dataGridView1.Columns["Column1"].DataPropertyName = dtb.Columns["classType"].ToString(); this.dataGridView1.Columns["Column2"].DataPropertyName = dtb.Columns["class"].ToString(); this.dataGridView1.Columns["Column3"].DataPropertyName = dtb.Columns["ID"].ToString(); this.dataGridView1.Columns["Column4"].DataPropertyName = dtb.Columns["name"].ToString(); this.dataGridView1.Columns["Column5"].DataPropertyName = dtb.Columns["level"].ToString(); this.dataGridView1.Columns["classType"].Visible = false; this.dataGridView1.Columns["class"].Visible = false; this.dataGridView1.Columns["ID"].Visible = false; this.dataGridView1.Columns["name"].Visible = false; this.dataGridView1.Columns["level"].Visible = false; } }
private void button3_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; MySqlCommand cmd1 = null; MySqlDataAdapter dpt1 = null; mySql sql1 = new mySql(); DataSet ds1 = new DataSet(); DataTable dtb1 = null; sql.openConnetction(); cmd = new MySqlCommand("SELECT * FROM westmed WHERE 1", sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView4.DataSource = dtb; this.dataGridView4.AutoGenerateColumns = false; this.dataGridView4.Columns["wNum1"].DataPropertyName = dtb.Columns["westmedid"].ToString(); this.dataGridView4.Columns["wName1"].DataPropertyName = dtb.Columns["wname"].ToString(); this.dataGridView4.Columns["wGuiGe1"].DataPropertyName = dtb.Columns["wguige"].ToString(); this.dataGridView4.Columns["wYaoJia1"].DataPropertyName = dtb.Columns["wyaojia"].ToString(); this.dataGridView4.Columns["wDanWei1"].DataPropertyName = dtb.Columns["wdanwei"].ToString(); this.dataGridView4.Columns["wGongXiao1"].DataPropertyName = dtb.Columns["wyaowugongxiao"].ToString(); this.dataGridView4.Columns["wZhuZhi1"].DataPropertyName = dtb.Columns["wyaowuzhuzhi"].ToString(); this.dataGridView4.Columns["wShiYong1"].DataPropertyName = dtb.Columns["wshiyongshuoming"].ToString(); this.dataGridView4.Columns["wKuCun1"].DataPropertyName = dtb.Columns["wkucun"].ToString(); this.dataGridView4.Columns["wBeiZhu1"].DataPropertyName = dtb.Columns["wbeizhu"].ToString(); this.dataGridView4.Columns["westmedid"].Visible = false; this.dataGridView4.Columns["wname"].Visible = false; this.dataGridView4.Columns["wguige"].Visible = false; this.dataGridView4.Columns["wyaojia"].Visible = false; this.dataGridView4.Columns["wdanwei"].Visible = false; this.dataGridView4.Columns["wyaowugongxiao"].Visible = false; this.dataGridView4.Columns["wyaowuzhuzhi"].Visible = false; this.dataGridView4.Columns["wshiyongshuoming"].Visible = false; this.dataGridView4.Columns["wkucun"].Visible = false; this.dataGridView4.Columns["wbeizhu"].Visible = false; sql.closeConnection(); sql1.openConnetction(); cmd1 = new MySqlCommand("SELECT * FROM chinesemed WHERE 1", sql1.conn); dpt1 = new MySqlDataAdapter(cmd1); dpt1.Fill(ds1); dtb1 = ds1.Tables[0]; dataGridView12.DataSource = dtb1; Console.WriteLine("secong fresh"); this.dataGridView12.AutoGenerateColumns = false; this.dataGridView12.Columns["cNum1"].DataPropertyName = dtb1.Columns["chinesemedid"].ToString(); this.dataGridView12.Columns["cName1"].DataPropertyName = dtb1.Columns["cname"].ToString(); this.dataGridView12.Columns["cGuiGe1"].DataPropertyName = dtb1.Columns["cguige"].ToString(); this.dataGridView12.Columns["cJiaGe1"].DataPropertyName = dtb1.Columns["cjiagedanwei"].ToString(); this.dataGridView12.Columns["cDanWei1"].DataPropertyName = dtb1.Columns["cdanwei"].ToString(); this.dataGridView12.Columns["cKuCun1"].DataPropertyName = dtb1.Columns["ckucun"].ToString(); this.dataGridView12.Columns["cZhuJiao1"].DataPropertyName = dtb1.Columns["czhujiao"].ToString(); this.dataGridView12.Columns["cBeiZhu1"].DataPropertyName = dtb1.Columns["cbeizhu"].ToString(); this.dataGridView12.Columns["chinesemedid"].Visible = false; this.dataGridView12.Columns["cname"].Visible = false; this.dataGridView12.Columns["cguige"].Visible = false; this.dataGridView12.Columns["cjiagedanwei"].Visible = false; this.dataGridView12.Columns["cdanwei"].Visible = false; this.dataGridView12.Columns["ckucun"].Visible = false; this.dataGridView12.Columns["czhujiao"].Visible = false; this.dataGridView12.Columns["cbeizhu"].Visible = false; sql1.closeConnection(); } else { MySqlCommand cmd = null; MySqlDataAdapter dpt = null; mySql sql = new mySql(); DataSet ds = new DataSet(); DataTable dtb = null; MySqlCommand cmd1 = null; MySqlDataAdapter dpt1 = null; mySql sql1 = new mySql(); DataSet ds1 = new DataSet(); DataTable dtb1 = null; sql.openConnetction(); cmd = new MySqlCommand("SELECT * FROM westmed WHERE `wname` LIKE '%" + textBox1.Text + "%'", sql.conn); dpt = new MySqlDataAdapter(cmd); dpt.Fill(ds); dtb = ds.Tables[0]; dataGridView4.DataSource = dtb; this.dataGridView4.AutoGenerateColumns = false; this.dataGridView4.Columns["wNum1"].DataPropertyName = dtb.Columns["westmedid"].ToString(); this.dataGridView4.Columns["wName1"].DataPropertyName = dtb.Columns["wname"].ToString(); this.dataGridView4.Columns["wGuiGe1"].DataPropertyName = dtb.Columns["wguige"].ToString(); this.dataGridView4.Columns["wYaoJia1"].DataPropertyName = dtb.Columns["wyaojia"].ToString(); this.dataGridView4.Columns["wDanWei1"].DataPropertyName = dtb.Columns["wdanwei"].ToString(); this.dataGridView4.Columns["wGongXiao1"].DataPropertyName = dtb.Columns["wyaowugongxiao"].ToString(); this.dataGridView4.Columns["wZhuZhi1"].DataPropertyName = dtb.Columns["wyaowuzhuzhi"].ToString(); this.dataGridView4.Columns["wShiYong1"].DataPropertyName = dtb.Columns["wshiyongshuoming"].ToString(); this.dataGridView4.Columns["wKuCun1"].DataPropertyName = dtb.Columns["wkucun"].ToString(); this.dataGridView4.Columns["wBeiZhu1"].DataPropertyName = dtb.Columns["wbeizhu"].ToString(); this.dataGridView4.Columns["westmedid"].Visible = false; this.dataGridView4.Columns["wname"].Visible = false; this.dataGridView4.Columns["wguige"].Visible = false; this.dataGridView4.Columns["wyaojia"].Visible = false; this.dataGridView4.Columns["wdanwei"].Visible = false; this.dataGridView4.Columns["wyaowugongxiao"].Visible = false; this.dataGridView4.Columns["wyaowuzhuzhi"].Visible = false; this.dataGridView4.Columns["wshiyongshuoming"].Visible = false; this.dataGridView4.Columns["wkucun"].Visible = false; this.dataGridView4.Columns["wbeizhu"].Visible = false; sql.closeConnection(); sql1.openConnetction(); cmd1 = new MySqlCommand("SELECT * FROM chinesemed WHERE `cname` LIKE '%" + textBox1.Text + "%'", sql1.conn); dpt1 = new MySqlDataAdapter(cmd1); dpt1.Fill(ds1); dtb1 = ds1.Tables[0]; dataGridView12.DataSource = dtb1; Console.WriteLine("secong fresh"); this.dataGridView12.AutoGenerateColumns = false; this.dataGridView12.Columns["cNum1"].DataPropertyName = dtb1.Columns["chinesemedid"].ToString(); this.dataGridView12.Columns["cName1"].DataPropertyName = dtb1.Columns["cname"].ToString(); this.dataGridView12.Columns["cGuiGe1"].DataPropertyName = dtb1.Columns["cguige"].ToString(); this.dataGridView12.Columns["cJiaGe1"].DataPropertyName = dtb1.Columns["cjiagedanwei"].ToString(); this.dataGridView12.Columns["cDanWei1"].DataPropertyName = dtb1.Columns["cdanwei"].ToString(); this.dataGridView12.Columns["cKuCun1"].DataPropertyName = dtb1.Columns["ckucun"].ToString(); this.dataGridView12.Columns["cZhuJiao1"].DataPropertyName = dtb1.Columns["czhujiao"].ToString(); this.dataGridView12.Columns["cBeiZhu1"].DataPropertyName = dtb1.Columns["cbeizhu"].ToString(); this.dataGridView12.Columns["chinesemedid"].Visible = false; this.dataGridView12.Columns["cname"].Visible = false; this.dataGridView12.Columns["cguige"].Visible = false; this.dataGridView12.Columns["cjiagedanwei"].Visible = false; this.dataGridView12.Columns["cdanwei"].Visible = false; this.dataGridView12.Columns["ckucun"].Visible = false; this.dataGridView12.Columns["czhujiao"].Visible = false; this.dataGridView12.Columns["cbeizhu"].Visible = false; sql1.closeConnection(); } }