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 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 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 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 button1_Click(object sender, EventArgs e)
{
string name = textBox1.Text;
string passwd = textBox2.Text;
string firstNew = textBox3.Text;
string secondNew = textBox4.Text;
md5 md = new md5();
string md5Old = md.md5_passwd(passwd);
string md5New = md.md5_passwd(firstNew);
if (firstNew != secondNew)
{
MessageBox.Show("两次输入的密码不一致");
}
else
{
mySql mysql = new mySql();
string query = "SELECT COUNT(*) FROM `user` WHERE `name`='" + name + "' AND `passwd`='" + md5Old + "'";
int returnNumber = mysql.count(query);
if (returnNumber == -2)
{
//do nothing
}
else if (returnNumber == -1)
{
//do nothing
}
else if (returnNumber == 0)
{
MessageBox.Show("原密码错误");
}
else
{
if (returnNumber == 1)
{
//change number
string updatePasswd = "UPDATE `user` set passwd='" + md5New + "' WHERE name='" + name + "'";
mysql.update(updatePasswd);
MessageBox.Show("改密成功");
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
}
else if (returnNumber > 1)
{
MessageBox.Show("系统缺陷，数据库没有做主键限制，数据库中存在两个或以上的同名用户，无法改密");
}
}
}
}
//重绘列值
//查询科室信息
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;
}
}
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)
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string mednum = dataGridView1.Rows[i].Cells["Column3"].Value.ToString();
string query = "";
if (mednum.Substring(0, 1) == "c")
{
query = "update chinesemed set ckucun = ckucun - 1 WHERE chinesemedid='" + mednum + "' ";
}
else
{
query = "update westmed set wkucun = wkucun - 1 WHERE westmedid='" + mednum + "'";
}
mySql sql = new mySql();
sql.update(query);
}
MessageBox.Show("发药成功");
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
textBox3.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
/*
*
* string name = textBox1.Text;
* string passwd = textBox2.Text;
*
*
* string md5Passwd = md5_passwd(passwd);
*
* string query = "INSERT INTO `his`.`user` (`name`, `passwd`) VALUES ('" + name + "', '" + md5Passwd + "');";
* bool sighResult = mysql.addDate(query);
* if (sighResult == true)
* {
* MessageBox.Show("注册成功");
* }
*
*/
if (textBox2.Text == "")
{
MessageBox.Show("请填写姓名");
}
else if (textBox3.Text == "")
{
MessageBox.Show("请填写性别");
}
else if (textBox5.Text == "")
{
MessageBox.Show("请填写联系方式");
}
else if (textBox6.Text != textBox4.Text)
{
MessageBox.Show("两次输入的密码不一致");
}
else if (comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请选择职位类别");
}
else if (comboBox1.SelectedIndex == 1)
{
MessageBox.Show("暂不支持医生注册");
}
else
{
string type = (comboBox1.SelectedIndex + 1).ToString();
md5 jiami = new md5();
string hadjiami = jiami.md5_passwd(textBox4.Text);
string query = " SELECT COUNT(*) FROM user WHERE type='" + type + "'";
mySql sql = new mySql();
int num = sql.count(query) + 1;
string gonghao = "0" + type + num.ToString();
query = "INSERT INTO user (`name`, `passwd`,`realname`,`sex`,`type`,`date`,`phone`) VALUES ('" + gonghao + "', '" + hadjiami + "','" + textBox2.Text + "','" + textBox3.Text + "','" + type + "','" + dateTimePicker1.Value.Date.ToString() + "','" + textBox5.Text + "');";
bool result = sql.addDate(query);
if (result)
{
MessageBox.Show("注册成功，您的工号是" + gonghao);
textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = textBox6.Text = "";
}
else
{
MessageBox.Show("注册失败，请重试");
}
}
}
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();
}
}
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();
}
}
