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