private void qurey() { RICBll = new RIClientTestBLL(); DataTable dt = RICBll.OutPatCodeToOutPatID(txtOutPatCode.Text, cInfo.strConn); if (dt.Rows.Count == 0) { MessageBox.Show("输入的就诊号: " + txtOutPatCode.Text + " 错误,查无此病人"); txt_OutPatName.Text = ""; } else { cmbChargeClassId.SelectedValue = dt.Rows[0]["CHARGE_CLASS_ID"].ToString(); OutPatID = dt.Rows[0]["OUT_PAT_ID"].ToString(); txt_OutPatName.Text = dt.Rows[0]["OUT_PAT_NAME"].ToString(); //txtAutoIds_Click(this, new EventArgs()); } dt = new DataTable(); //dt = RICBll.OutPatCodeToInvoice(OutPatID, cInfo.strConn, dataTime_StartTime.Value.ToString("yyyy-MM-dd 00:00:00"), dateTime_EndTime.Value.ToString("yyyy-MM-dd 23:59:59")); if (dt.Rows.Count == 0) { return; } else { //dgrv_Invoice.DataSource = dt; } }
private void tbPatInHosCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { RICBll = new RIClientTestBLL(); DataTable dt = RICBll.PatInHosCodeToPatInHosID(tbPatInHosCode.Text, cInfo.strConn); ArrayList arry_1 = new ArrayList(); if (dt.Rows.Count == 0) { MessageBox.Show("输入的住院号不正确"); } else { txt_PatInChargeClassID.Text = dt.Rows[0]["CHARGE_CLASS_NAME"].ToString(); txt_pat_in_name.Text = dt.Rows[0]["IN_PAT_NAME"].ToString(); PatInHosChargeClassID = dt.Rows[0]["CHARGE_CLASS_ID"].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { arry_1.Add(new DictionaryEntry(dt.Rows[i]["PAT_IN_HOS_ID"], dt.Rows[i]["PAT_AGAIN_IN_TIMES"])); } Cmb_In_Times.DataSource = arry_1; Cmb_In_Times.ValueMember = "Key"; Cmb_In_Times.DisplayMember = "Value"; } } }
private void txt_QueryContent_TextChanged(object sender, EventArgs e) { if (cmb_QuerySelection.Text == "姓名") { if (txt_QueryContent.Focused == false) { dgrv_SelectName.Visible = false; return; } if (txt_QueryContent.Text == "") { dgrv_SelectName.Visible = false; return; } //筛选 RICBll = new RIClientTestBLL(); DataTable dt = new DataTable(); dt = RICBll.OutPatNameToAllInfo(txt_QueryContent.Text, cInfo.strConn); if (dt.Rows.Count > 0) { dgrv_SelectName.Visible = true; } else { dgrv_SelectName.Visible = false; } dgrv_SelectName.DataSource = dt; //将datagirdview的AutoSizeColumnsMode属性改为AllCells根据内容自动调整宽度,但数据量大速度慢 dgrv_SelectName.Refresh(); } }
//------------------------------------------------------------- private void txt_QueryContent_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar != 13) { return; } if (dgrv_SelectName.Visible == true) { dgrv_SelectName_DoubleClick(this, e); } if (cmb_QuerySelection.Text == "OUT_PAT_ID") { RICBll = new RIClientTestBLL(); DataTable dt = new DataTable(); dt = RICBll.OutPatIDToOutPatCode(txt_QueryContent.Text, cInfo.strConn); if (dt.Rows.Count != 0) { txtOutPatCode.Text = dt.Rows[0]["OUT_PAT_CODE"].ToString(); } else { return; } } if (cmb_QuerySelection.Text == "就诊号") { txtOutPatCode.Text = txt_QueryContent.Text; } qurey(); }
/// <summary> /// 费别列表 /// </summary> public void FillChargeClassID() { RICBll = new RIClientTestBLL(); DataTable dt = RICBll.QueryChargeClassId(cInfo.strConn); ArrayList arry_2 = new ArrayList(); for (int i = 0; i < dt.Rows.Count; i++) { arry_2.Add(new DictionaryEntry(dt.Rows[i]["CHARGE_CLASS_ID"].ToString(), dt.Rows[i]["CHARGE_CLASS_NAME"].ToString())); } cmbChargeClassId.DataSource = arry_2; cmbChargeClassId.DisplayMember = "Value"; cmbChargeClassId.ValueMember = "Key"; }