private void init()
{
DataSet nopayds = mysql.getds(sqlstr, mytable);
mybdsource.DataSource = nopayds.Tables[0];
this.dataGridView1.DataSource = mybdsource;
}
private void Frm_patient_Load(object sender, EventArgs e)
{
//添加已有病人供检索
DataSet getnameds = mysql.getds("SELECT Name FROM tb_patient", "patient");
for (int i = 0; i < getnameds.Tables[0].Rows.Count; i++)
{
this.cmb_searchName.Items.Add(getnameds.Tables[0].Rows[i][0]);
}
this.cmb_searchName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.cmb_searchName.AutoCompleteSource = AutoCompleteSource.ListItems;
//添加性别
cmb_sex.Items.Add("男");
cmb_sex.Items.Add("女");
cmb_sex.SelectedIndex = 0;
//添加卡类型
cmb_cardtype.Items.Add("就诊卡");
cmb_cardtype.Items.Add("社保卡");
cmb_cardtype.SelectedIndex = 0;
//只可查看
this.setFalse();
}
private void Frm_balanceQuery_Load(object sender, EventArgs e)
{
this.init();
tb_patientno.DataBindings.Add("text", mybdsource, "患者编号");
tb_name.DataBindings.Add("text", mybdsource, "患者姓名");
tb_cardno.DataBindings.Add("text", mybdsource, "就诊卡号");
tb_balance.DataBindings.Add("text", mybdsource, "余额");
//添加已有病人供检索
DataSet getnameds = mysql.getds("SELECT Name FROM tb_patient WHERE visitNo IS NOT NULL;", "patient");
for (int i = 0; i < getnameds.Tables[0].Rows.Count; i++)
{
this.cmb_searchName.Items.Add(getnameds.Tables[0].Rows[i][0]);
}
this.cmb_searchName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.cmb_searchName.AutoCompleteSource = AutoCompleteSource.ListItems;
//只可查看
tb_patientno.Enabled = false;
tb_name.Enabled = false;
tb_cardno.Enabled = false;
tb_balance.Enabled = false;
rdo_visitno.Select();
}
private void Frm_doctor_Load(object sender, EventArgs e)
{
//初始化科室列表
DataSet myds1 = mysql.getds("SELECT NO 科室编号,NAME 科室名称 FROM tb_dept; ", "department");
BindingSource mybdsource = new BindingSource();
mybdsource.DataSource = myds1.Tables[0];
this.dataGridView2.DataSource = mybdsource;
tb_curDept.DataBindings.Add("text", mybdsource, "科室名称");
Mstr = "SELECT d1.No 工号,d1.NAME 姓名,d1.pinyin 拼音码,d1.title 职称,d2.NAME 所属科室,d1.specialty 擅长 "
+ "FROM tb_doctor d1,tb_dept d2 "
+ "WHERE d1.deptNo=d2.NO AND d2.Name='" + tb_curDept.Text.Trim() + "';";
tb_curDept.Enabled = false;
this.setFalse();
this.init();
//绑定数据
tb_name.DataBindings.Add("text", bdsource, "姓名");
tb_pinyin.DataBindings.Add("text", bdsource, "拼音码");
tb_no.DataBindings.Add("text", bdsource, "工号");
tb_title.DataBindings.Add("text", bdsource, "职称");
cmb_dept.DataBindings.Add("text", bdsource, "所属科室");
rtb_spec.DataBindings.Add("text", bdsource, "擅长");
//添加科室
DataSet partds = mysql.getds("SELECT NAME FROM tb_dept;", "department");
for (int i = 0; i < partds.Tables[0].Rows.Count; i++)
{
this.cmb_dept.Items.Add(partds.Tables[0].Rows[i][0]);
}
}
private void init()
{
DataSet myds = mysql.getds(sqlstr, mytable);
mybdsource.DataSource = myds.Tables[0];
this.dataGridView1.DataSource = mybdsource;
this.bindingNavigator1.BindingSource = mybdsource;
}
private void init(string Mstr)
{
DataSet myds = mysql.getds(Mstr, Mtable);
bdsource.DataSource = myds.Tables[0];
this.dataGridView1.DataSource = bdsource;
if (flag == 1)
{
this.databing();
flag = 0;
}
}
private void Frm_deptQuery_Load(object sender, EventArgs e)
{
//添加已有科室供检索
DataSet getnameds = mysql.getds("SELECT NAME FROM tb_dept;", "dept");
for (int i = 0; i < getnameds.Tables[0].Rows.Count; i++)
{
this.cmb_searchName.Items.Add(getnameds.Tables[0].Rows[i][0]);
}
this.cmb_searchName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.cmb_searchName.AutoCompleteSource = AutoCompleteSource.ListItems;
//初始化
tb_id.Enabled = false;
tb_name.Enabled = false;
rtb_dscp.Enabled = false;
}
private void Frm_mediCardRecharge_Load(object sender, EventArgs e)
{
//添加已有病人供检索
DataSet getnameds = mysql.getds("SELECT Name FROM tb_patient WHERE visitNo IS NOT NULL;", "patient");
for (int i = 0; i < getnameds.Tables[0].Rows.Count; i++)
{
this.cmb_searchName.Items.Add(getnameds.Tables[0].Rows[i][0]);
}
this.cmb_searchName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.cmb_searchName.AutoCompleteSource = AutoCompleteSource.ListItems;
//只可查看
tb_patientno.Enabled = false;
tb_name.Enabled = false;
tb_cardno.Enabled = false;
tb_balance.Enabled = false;
rdo_visitno.Select();
rdo_cash.Select();
}