private void button3_Click(object sender, EventArgs e) { DateTime start = dateTimePicker1.Value.Date; DateTime end = dateTimePicker2.Value.Date; if (start == end) { mySql sql = new mySql(); string query = "SELECT sum( IF (CONTAINS(feiyong,'元'),substr(feiyong,1,LENGTH(feiyong)-3),feiyong) ) allcheck FROM `check` WHERE riqi='" + end.ToString() + "'"; MySqlDataReader mdr = sql.searchData(query); while (mdr.Read()) { textBox8.Text = mdr["allcheck"].ToString(); } sql.closeConnection(); query = "SELECT sum(IF(CONTAINS(medzongjia,'元'),substr(medzongjia,1,LENGTH(medzongjia)-3),medzongjia) ) allyaopin FROM `chufang` WHERE meddate='" + end.ToString() + "'"; mdr = sql.searchData(query); while (mdr.Read()) { textBox11.Text = mdr["allyaopin"].ToString(); } sql.closeConnection(); textBox10.Text = (Convert.ToDecimal(textBox8.Text) + Convert.ToDecimal(textBox11.Text)).ToString(); } else if (start > end) { MessageBox.Show("时间范围错误"); } else { mySql sql = new mySql(); string query = "SELECT sum( IF (CONTAINS(feiyong,'元'),substr(feiyong,1,LENGTH(feiyong)-3),feiyong) ) allcheck FROM `check` WHERE riqi BETWEEN '" + start.ToString() + "' AND '" + end.ToString() + "'"; MySqlDataReader mdr = sql.searchData(query); while (mdr.Read()) { textBox8.Text = mdr["allcheck"].ToString(); } sql.closeConnection(); query = "SELECT sum(IF(CONTAINS(medzongjia,'元'),substr(medzongjia,1,LENGTH(medzongjia)-3),medzongjia) ) allyaopin FROM `chufang` WHERE meddate BETWEEN '" + start.ToString() + "' AND '" + end.ToString() + "'"; mdr = sql.searchData(query); while (mdr.Read()) { textBox11.Text = mdr["allyaopin"].ToString(); } sql.closeConnection(); textBox10.Text = (Convert.ToDecimal(textBox8.Text) + Convert.ToDecimal(textBox11.Text)).ToString(); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请输入医生工号"); } else { dataGridView3.Rows.Clear(); string query = "SELECT regandduty.`data`,classanddoctor.class,classanddoctor.`name`,COUNT(*),sum(regpay) FROM regandduty INNER JOIN classanddoctor ON regandduty.doctorID=classanddoctor.ID WHERE regandduty.doctorID='" + textBox1.Text + "' AND regandduty.ifUse='1' AND regandduty.`data`='" + dateTimePicker3.Value.Date.ToString() + "'"; mySql sql = new mySql(); MySqlDataReader mdr = sql.searchData(query); int i = 0; while (mdr.Read()) { dataGridView3.Rows.Add(); dataGridView3.Rows[i].Cells["Column16"].Value = Convert.ToDateTime(mdr["data"].ToString()).Date.ToString("yyyy-MM-dd");; dataGridView3.Rows[i].Cells["Column23"].Value = mdr["class"].ToString(); dataGridView3.Rows[i].Cells["Column24"].Value = mdr["name"].ToString(); dataGridView3.Rows[i].Cells["Column25"].Value = mdr["COUNT(*)"].ToString(); dataGridView3.Rows[i].Cells["Column26"].Value = mdr["sum(regpay)"].ToString(); i++; } } }
private void button1_Click(object sender, EventArgs e) { string name = textBox1.Text; string passwd = textBox2.Text; string md5Passwd = md5_passwd(passwd); string query = "SELECT COUNT(*) FROM `user` WHERE `name`='" + name + "' AND `passwd`='" + md5Passwd + "'"; int userRight = mysql.count(query); if (userRight >= 1) { string useID = name; string type = ""; query = "SELECT type FROM `user` WHERE `name`='" + name + "' AND `passwd`='" + md5Passwd + "'"; MySqlDataReader searchResult = mysql.searchData(query); while (searchResult.Read()) { type = searchResult["type"].ToString(); } if (type == "") { MessageBox.Show("当前账号无权限,请联系管理员或更换账号"); } else { new choose(type, useID).Show(); this.Hide(); } } else if (userRight == 0) { MessageBox.Show("密码错误"); } }
//查询按钮 private void buttonSearch_Click(object sender, EventArgs e) { if (cardNum.Text == "") { MessageBox.Show("请输入诊疗卡号"); } else { string cardnum = cardNum.Text; string query = "SELECT COUNT(*) FROM `HIS`.`Patient` WHERE `CardNum`='" + cardnum + "'"; int countResult = sql.count(query); if (countResult >= 1) { query = "SELECT * FROM `HIS`.`Patient` WHERE `CardNum`='" + cardnum + "'"; MySqlDataReader searchResult = sql.searchData(query); while (searchResult.Read()) { paName.Text = searchResult["paName"].ToString(); string paSexNum = searchResult["paSex"].ToString(); if (paSexNum == "1") { paSex.Text = "男"; } else { paSex.Text = "女"; } string paBorthStr = searchResult["paBorth"].ToString(); if (paBorthStr != "") { paBorth.Value = Convert.ToDateTime(paBorthStr); } if (searchResult["paIDType"].ToString() != "") { paIDType.SelectedIndex = Convert.ToInt32(searchResult["paIDType"].ToString()); } paID.Text = searchResult["paID"].ToString(); paAddress.Text = searchResult["paAddress"].ToString(); paAllergy.Text = searchResult["paAllergy"].ToString(); paAge.Text = searchResult["paAge"].ToString(); paPhone.Text = searchResult["paPhone"].ToString(); } sql.closeConnection(); } else { MessageBox.Show("未查询到此诊疗卡"); } } }
void yaofei() { mySql sql = new mySql(); string query = "SELECT medname,meddanwei,medshuliang,medjiage,medzongjia FROM chufang WHERE regid='" + textBox5.Text + "'"; MySqlDataReader mdr = sql.searchData(query); int i = dataGridView1.Rows.Count; while (mdr.Read()) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Column1"].Value = mdr["medname"].ToString(); dataGridView1.Rows[i].Cells["Column2"].Value = mdr["meddanwei"].ToString(); dataGridView1.Rows[i].Cells["Column3"].Value = mdr["medshuliang"].ToString(); dataGridView1.Rows[i].Cells["Column4"].Value = mdr["medjiage"].ToString(); dataGridView1.Rows[i].Cells["Column5"].Value = mdr["medzongjia"].ToString(); i++; } sql.closeConnection(); }
void CT() { mySql sql = new mySql(); string query = "SELECT appnum,feiyong FROM `check` WHERE appnum = 'CT" + textBox5.Text + "'"; MySqlDataReader mdr = sql.searchData(query); int i = dataGridView1.Rows.Count; while (mdr.Read()) { dataGridView1.Rows.Add(); string type = mdr["appnum"].ToString().Substring(0, 2); dataGridView1.Rows[i].Cells["Column1"].Value = type; dataGridView1.Rows[i].Cells["Column2"].Value = "次"; dataGridView1.Rows[i].Cells["Column3"].Value = "1"; dataGridView1.Rows[i].Cells["Column4"].Value = mdr["feiyong"].ToString() + "/次"; dataGridView1.Rows[i].Cells["Column5"].Value = mdr["feiyong"].ToString(); i++; } sql.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请输入药品编号"); } else if (textBox2.Text == "") { MessageBox.Show("请输入新增库存量"); } else { if (textBox1.Text.Substring(0, 1) == "c") { string query = "SELECT COUNT(*) FROM chinesemed WHERE chinesemedid='" + textBox1.Text + "' "; mySql sql = new mySql(); int result = sql.count(query); if (result == 0) { MessageBox.Show("没有查询到该中药"); } else if (result == 1) { query = "UPDATE `chinesemed` set ckucun=ckucun+" + textBox2.Text + " WHERE chinesemedid='" + textBox1.Text + "'"; result = sql.update(query); if (result == 1) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } query = "SELECT chinesemedid,cname,ckucun FROM chinesemed WHERE chinesemedid='" + textBox1.Text + "'"; MySqlDataReader mdr = sql.searchData(query); dataGridView2.Rows.Clear(); int i = 0; while (mdr.Read()) { dataGridView2.Rows.Add(); dataGridView2.Rows[i].Cells["Column4"].Value = mdr["chinesemedid"].ToString(); dataGridView2.Rows[i].Cells["Column5"].Value = mdr["cname"].ToString(); dataGridView2.Rows[i].Cells["Column6"].Value = mdr["ckucun"].ToString(); } tabControl1.SelectedTab = tabPage2; } else { MessageBox.Show("数据库错误"); } } else if (textBox1.Text.Substring(0, 1) == "w") { string query = "SELECT COUNT(*) FROM westmed WHERE westmedid='" + textBox1.Text + "' "; mySql sql = new mySql(); int result = sql.count(query); if (result == 0) { MessageBox.Show("没有查询到该西药"); } else if (result == 1) { query = "UPDATE `westmed` set wkucun=wkucun+" + textBox2.Text + " WHERE westmedid='" + textBox1.Text + "'"; result = sql.update(query); if (result == 1) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } query = "SELECT westmedid,wname,wkucun FROM westmed WHERE westmedid='" + textBox1.Text + "'"; MySqlDataReader mdr = sql.searchData(query); dataGridView1.Rows.Clear(); int i = 0; while (mdr.Read()) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Column1"].Value = mdr["westmedid"].ToString(); dataGridView1.Rows[i].Cells["Column2"].Value = mdr["wname"].ToString(); dataGridView1.Rows[i].Cells["Column3"].Value = mdr["wkucun"].ToString(); } tabControl1.SelectedTab = tabPage1; } else { MessageBox.Show("数据库错误"); } } else { MessageBox.Show("药品编号不合法"); } } }
private void button4_Click(object sender, EventArgs e) { mySql MySQL = new mySql(); string cmd = "SELECT classanddoctor.`name` FROM regandduty INNER JOIN classanddoctor ON regandduty.doctorID=classanddoctor.ID WHERE regandduty.regID='" + textBox5.Text + "'"; MySqlDataReader mdr = MySQL.searchData(cmd); while (mdr.Read()) { textBox6.Text = mdr["name"].ToString(); } dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); if (textBox5.Text == "") { MessageBox.Show("请输入就诊号"); } else if (comboBox1.SelectedIndex == -1) { MessageBox.Show("请选择收费项目"); } else { //全部项目 if (comboBox1.SelectedIndex == 0) { yaofei(); allcheck(); } //药费 if (comboBox1.SelectedIndex == 1) { yaofei(); } //全部检查 if (comboBox1.SelectedIndex == 2) { allcheck(); } //超声检查 if (comboBox1.SelectedIndex == 3) { CS(); } //CT检查 if (comboBox1.SelectedIndex == 4) { CT(); } //MR检查 if (comboBox1.SelectedIndex == 5) { MR(); } //化验检查 if (comboBox1.SelectedIndex == 6) { HY(); } decimal sum = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { string jiage = dataGridView1.Rows[i].Cells["Column5"].Value.ToString(); if (jiage.Contains("元") && jiage.IndexOf('元') != 0) { decimal danjia = Convert.ToDecimal(jiage.Substring(0, jiage.IndexOf('元'))); sum = sum + danjia; } else if (jiage.Contains("元") && jiage.IndexOf('元') == 0) { sum = sum + 0; } else { decimal danjia = Convert.ToDecimal(jiage); sum = sum + danjia; } } textBox3.Text = sum.ToString(); } }