private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentCell.RowIndex != -1) { ChildBaseInfoObj obj = dataGridView1.CurrentRow.Tag as ChildBaseInfoObj; if (String.IsNullOrEmpty(obj.jiuzhenCardNo)) { obj.jiuzhenCardNo = _txtNo; } else { obj.jiuzhenCardNo += "," + _txtNo; } int id = obj.id; globalInfoClass.Wm_Index = id; _panelyibanxinximain.obj = obj; _panelyibanxinximain.RefreshCode(); DialogResult = System.Windows.Forms.DialogResult.OK; } }
private void txtNo_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { string sqls = string.Format("select * from TB_CHILDBASE where status='1' "); if (!String.IsNullOrEmpty(txtNo.Text)) { sqls += " and jiuzhenCardNo like '%" + txtNo.Text + "%'"; } else { return; } ArrayList list = bll.getchildBaseListTwo(sqls); if (list != null && list.Count > 0) { ChildBaseInfoObj obj = list[0] as ChildBaseInfoObj; int id = obj.Id; globalInfoClass.Wm_Index = id; _panelyibanxinximain.obj = obj; _panelyibanxinximain.RefreshCode(); DialogResult = System.Windows.Forms.DialogResult.OK; } else { SqlDataReader sdr = null; HosDateLogic dg = new HosDateLogic(); String usersql = "select visit_number,patient_name,regist_time,identityno,contact_phone,sex,age,address,birthtime from v_yyt_registration where cardnum='" + txtNo.Text.Trim() + "' order by regist_time desc"; try { sdr = dg.executequery(usersql); if (!sdr.HasRows) { MessageBox.Show("检索不到病人就诊信息!", "系统提示"); //textBoxX20.Focus(); return; } else { sdr.Read(); ChildBaseInfoObj obj = new ChildBaseInfoObj(); obj.ChildName = sdr["patient_name"].ToString().Trim(); obj.ChildGender = sdr["sex"].ToString().Trim(); obj.jiuzhenCardNo = txtNo.Text.Trim(); if (!String.IsNullOrEmpty(sdr["birthtime"].ToString())) { obj.childBirthDay = sdr["birthtime"].ToString(); } sqls = "select * from TB_CHILDBASE where status='1' and childName like '%" + obj.ChildName + "%'"; list = bll.getchildBaseListTwo(sqls); if (list != null && list.Count > 0) { if (list.Count == 1) { obj = list[0] as ChildBaseInfoObj; if (String.IsNullOrEmpty(obj.jiuzhenCardNo)) { obj.jiuzhenCardNo = txtNo.Text.Trim(); } else { obj.jiuzhenCardNo += "," + txtNo.Text.Trim(); } int id = obj.Id; globalInfoClass.Wm_Index = id; _panelyibanxinximain.obj = obj; _panelyibanxinximain.RefreshCode(); DialogResult = System.Windows.Forms.DialogResult.OK; } else { DialogResult = System.Windows.Forms.DialogResult.OK; Panel_readCardlist readlist = new Panel_readCardlist(list, txtNo.Text.Trim(), _panelyibanxinximain); readlist.ShowDialog(); } } else { MessageBox.Show("未检索到该儿童信息,请新建档案"); globalInfoClass.Wm_Index = -1; _panelyibanxinximain.obj = obj; _panelyibanxinximain.RefreshCode(); DialogResult = System.Windows.Forms.DialogResult.OK; } } } catch (Exception ex) { throw ex; } finally { sdr.Close(); dg.con_close(); } } } }