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