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";
}
