private void dgPat_CurrentCellChanged(object sender, System.EventArgs e)
{
dgList.DataSource = null;
dgList.CaptionText = "费用明细";
int nrow = dgPat.CurrentCell.RowNumber;
dgPat.Select(nrow);
Guid sInpatientId = new Guid(dgPat[nrow, 6].ToString().Trim());
if (sInpatientId != Guid.Empty)
{
Cursor.Current = PubStaticFun.WaitCursor();
dgList.CaptionText += " [病区：" + dgPat[nrow, 1].ToString() + " 住院号：" + dgPat[nrow, 4].ToString() + " 姓名：" + dgPat[nrow, 5].ToString() + "]";
string sSql = "select a.subcode as 项目代码, " +
" a.item_name 项目名称, " +
" a.retail_price 单价,a.num*a.dosage 数量,a.acvalue 金额,a.charge_date 记帐日期,dbo.fun_getempname(a.charge_user) 记帐人, " +
" dbo.fun_getdeptname(a.execdept_id) 执行科室,c.item_name 项目类别 " +
" from (select * from (select * from zy_fee_speci union all select * from zy_fee_speci_h) a where inpatient_id='" + sInpatientId + "' and charge_bit=1 and delete_bit=0" +
" and charge_date >= '" + dtpBegin.Value.ToShortDateString() + " 00:00:00' and charge_date < '" + dtpEnd.Value.AddDays(1).ToShortDateString() + " 00:00:00' and dept_id=" + cmbDept.SelectedValue + ") a" +
" inner join jc_stat_item c" +
" on a.statitem_code=c.code" +
" order by c.code,charge_date";
DataTable myTb = InstanceForm.BDatabase.GetDataTable(sSql);
dgList.DataSource = myTb;
}
Cursor.Current = Cursors.Default;
}
private void dgWard_CurrentCellChanged(object sender, System.EventArgs e)
{
dgPat.DataSource = null;
dgList.DataSource = null;
dgPat.CaptionText = "病人费用";
dgList.CaptionText = "费用明细";
int nrow = dgWard.CurrentCell.RowNumber;
dgWard.Select(nrow);
if (dgWard[nrow, 0].ToString().Trim() == "AAAA")
{
patTb = dataTb.Copy();
dgPat.CaptionText += " [全部病区]";
}
else
{
patTb = dataTb.Clone();
DataRow[] drM = dataTb.Select("ward_id='" + dgWard[nrow, 0].ToString() + "'", "dept_id");
foreach (DataRow dr in drM)
{
patTb.Rows.Add(dr.ItemArray);
}
dgPat.CaptionText += " [" + dgWard[nrow, 1].ToString().Trim() + "]";
}
dgPat.DataSource = patTb;
}
private void dGrid_Pat_CurrentCellChanged(object sender, System.EventArgs e)
{
myDV = (DataView)dGrid_Pat.DataSource;
int nrow = dGrid_Pat.CurrentCell.RowNumber;
dGrid_Pat.Select(nrow);
for (int i = 0; i < myDV.Table.Rows.Count; i++)
{
myDV[i]["sel"] = 0;
}
myDV[nrow]["sel"] = 1;
if (myDV.Table.Rows.Count > nrow && myDV.Table.Rows.Count != 0)
{
txtPatID.Text = myDV[nrow]["住院号"].ToString();
pnl_2.Refresh();
}
else
{
txtPatID.Text = "";
}
dGrid_Pat.Refresh();
}
