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