public frmInHospitalPatient(DataTable p_dtbRecord) { InitializeComponent(); ListViewItem tempItem; clsBrithdayToAge m_objAge = new clsBrithdayToAge(); foreach (DataRow dr in p_dtbRecord.Rows) { tempItem = new ListViewItem(dr["inpatientid_chr"].ToString().Trim()); tempItem.SubItems.Add(dr["lastname_vchr"].ToString().Trim()); tempItem.SubItems.Add(dr["sex_chr"].ToString().Trim()); tempItem.SubItems.Add(m_objAge.m_strGetAge(dr["birth_dat"])); tempItem.SubItems.Add(dr["status"].ToString().Trim()); tempItem.SubItems.Add(dr["icd10diagtext_vchr"].ToString().Trim()); tempItem.SubItems.Add(Convert.ToDateTime(dr["inpatient_dat"]).ToString("yyyy-MM-dd HH:mm")); tempItem.SubItems.Add(dr["inpatientcount_int"].ToString().Trim()); tempItem.SubItems.Add(dr["pstatus"].ToString().Trim()); tempItem.SubItems.Add(dr["phone"].ToString().Trim()); tempItem.SubItems.Add(dr["address"].ToString().Trim()); tempItem.Tag = dr["registerid_chr"].ToString().Trim(); tempItem.SubItems[0].Tag = dr["patientid_chr"].ToString().Trim(); m_lsvPatientInfo.Items.Add(tempItem); } if (m_lsvPatientInfo.Items.Count > 0) { m_lsvPatientInfo.Items[0].Selected = true; } }
public clsCtl_ShowReports() { objSvc = new clsDcl_ShowReports(); m_objAge = new clsBrithdayToAge(); objCalPatientCharge = new clsCalcPatientCharge(string.Empty, "0001", 100, this.m_objComInfo.m_strGetHospitalTitle(), 1, 100); // // TODO: 在此处添加构造函数逻辑 // }
/// <summary> /// 根据病区ID查询未安排床位的病人信息 /// </summary> public void m_mthGetTurnInNotAccept() { m_objViewer.m_lsvPatientInfo.Items.Clear(); DataTable p_dtbResult; try { m_objManage.m_lngGetTurnInNA(m_objViewer.m_strAreaID, out p_dtbResult); clsBrithdayToAge m_objAge = new clsBrithdayToAge(); ListViewItem listviewitem; ListViewItem[] tempItemArr = new ListViewItem[p_dtbResult.Rows.Count]; int index = 0; foreach (DataRow dr in p_dtbResult.Rows) { listviewitem = new ListViewItem(dr["name_vchr"].ToString().Trim()); listviewitem.SubItems.Add(dr["inpatientid_chr"].ToString().Trim()); listviewitem.SubItems.Add(dr["name_vchr"].ToString().Trim()); listviewitem.SubItems.Add(dr["sex_chr"].ToString().Trim()); listviewitem.SubItems.Add(m_objAge.m_strGetAge(dr["birth_dat"])); listviewitem.SubItems.Add(dr["status"].ToString().Trim()); listviewitem.SubItems.Add(Convert.ToDateTime(dr["modify_dat"]).ToString("yyyy年MM月dd日 HH时mm分")); listviewitem.SubItems.Add(m_objViewer.m_lblAREAName.Text.Trim()); listviewitem.SubItems.Add(dr["type_int"].ToString().Trim()); listviewitem.SubItems.Add(Convert.ToDateTime(dr["HISINPATIENTDATE"]).ToString("yyyy年MM月dd日 HH时mm分")); listviewitem.Tag = dr["REGISTERID_CHR"].ToString().Trim(); //listviewitem.ImageIndex = intDisplayImageIndex(Int32.Parse(dr["STATE_INT"].ToString().Trim()), dr["SEX_CHR"].ToString().Trim()); listviewitem.ImageIndex = intDisplayImageIndex(dr["STATE_INT"].ToString().Trim(), dr["SEX_CHR"].ToString().Trim(), dr["nursecate"].ToString().Trim()); tempItemArr[index] = listviewitem; index++; } m_objViewer.m_lsvPatientInfo.Items.AddRange(tempItemArr); p_dtbResult = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "获取当前病区未安排床位的病人信息出错!"); } }
public void m_mthCreateChargeVO(ref clsBihOrderDic_VO p_objOrderDicVO, ref clsBihPatientCharge_VO p_objPatientChargeVO, string p_strInPatientID, int p_intBagNum, string p_strOrderCreateAreaID) { string chargeItemId = clsPublic.m_strGetSysparm("0088"); clsDcl_CommonFind objDcl = new clsDcl_CommonFind(); DataTable dtOrderDicInfo = new DataTable(); DataTable dtPatientInfo = new DataTable(); objDcl.m_lngQueryInfoForChargeMedBag(chargeItemId, p_strInPatientID, ref dtOrderDicInfo, ref dtPatientInfo); bool isChildPrice = false; if (dtPatientInfo != null && dtPatientInfo.Rows.Count > 0) { if (new clsDcl_YB().IsUseChildPrice()) { isChildPrice = new clsBrithdayToAge().IsChild(Convert.ToDateTime(dtPatientInfo.Rows[0]["birth_dat"])); } } clsDcl_Charge objDcl1 = new clsDcl_Charge(); DataTable dtItemInfo = new DataTable(); objDcl1.m_lngGetChargeItemByOrderID(chargeItemId, dtPatientInfo.Rows[0]["paytypeid_chr"].ToString(), out dtItemInfo, false); DataRow dr = dtItemInfo.Rows[0]; //p_objOrderDicVO p_objOrderDicVO.Type = 1; p_objOrderDicVO.OrderQue = 1; p_objOrderDicVO.OrderDicID = chargeItemId; p_objOrderDicVO.OrderDicName = dtOrderDicInfo.Rows[0][0].ToString(); p_objOrderDicVO.Spec = dtOrderDicInfo.Rows[0][1].ToString(); p_objOrderDicVO.Qty = 0; p_objOrderDicVO.PriceMny = 0; p_objOrderDicVO.TotalMny = 0; p_objOrderDicVO.AttachOrderID = "1->" + chargeItemId; p_objOrderDicVO.SbBaseMny = 0; //p_objPatientChargeVO p_objPatientChargeVO.PatientID = dtPatientInfo.Rows[0]["patientid_chr"].ToString(); p_objPatientChargeVO.RegisterID = dtPatientInfo.Rows[0]["registerid_chr"].ToString(); p_objPatientChargeVO.ClacArea = dtPatientInfo.Rows[0]["areaid_chr"].ToString(); p_objPatientChargeVO.CreateArea = p_strOrderCreateAreaID; p_objPatientChargeVO.CalcCateID = dr["itemipcalctype_chr"].ToString(); p_objPatientChargeVO.InvCateID = dr["itemipinvtype_chr"].ToString(); p_objPatientChargeVO.ChargeItemID = dr["itemid_chr"].ToString(); p_objPatientChargeVO.ChargeItemName = dr["itemname_vchr"].ToString(); if (dr["ipchargeflg_int"].ToString().Trim() == "1") { p_objPatientChargeVO.Unit = dr["itemipunit_chr"].ToString().Trim(); p_objPatientChargeVO.UnitPrice = clsPublic.ConvertObjToDecimal(dr["submoney"]); } else { p_objPatientChargeVO.Unit = dr["itemunit_chr"].ToString().Trim(); p_objPatientChargeVO.UnitPrice = clsPublic.ConvertObjToDecimal(dr["itemprice_mny"]); } p_objPatientChargeVO.Amount = clsPublic.ConvertObjToDecimal(p_intBagNum); p_objPatientChargeVO.Discount = Convert.ToDecimal(dr["precent_dec"]); p_objPatientChargeVO.Ismepay = 0; p_objPatientChargeVO.Des = ""; p_objPatientChargeVO.CreateType = 4; p_objPatientChargeVO.Creator = this.strEmpID; p_objPatientChargeVO.Operator = this.strEmpID; p_objPatientChargeVO.PStatus = 1; p_objPatientChargeVO.Activator = this.strEmpID; p_objPatientChargeVO.ActivateType = 2; p_objPatientChargeVO.IsRich = int.Parse(dr["isrich_int"].ToString()); p_objPatientChargeVO.CurAreaID = dtPatientInfo.Rows[0]["areaid_chr"].ToString(); p_objPatientChargeVO.CurBedID = dtPatientInfo.Rows[0]["bedid_chr"].ToString(); p_objPatientChargeVO.DoctorID = dtPatientInfo.Rows[0]["casedoctor_chr"].ToString(); p_objPatientChargeVO.Doctor = dtPatientInfo.Rows[0]["lastname_vchr"].ToString(); p_objPatientChargeVO.DoctorGroupID = ""; p_objPatientChargeVO.NeedConfirm = 0; p_objPatientChargeVO.ActiveDat = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); p_objPatientChargeVO.TotalMoney_dec = clsPublic.Round(p_objPatientChargeVO.UnitPrice * p_objPatientChargeVO.Amount, 2); p_objPatientChargeVO.AcctMoney_dec = p_objPatientChargeVO.TotalMoney_dec - clsPublic.Round(p_objPatientChargeVO.UnitPrice * p_objPatientChargeVO.Amount * p_objPatientChargeVO.Discount / 100, 2); p_objPatientChargeVO.AttachOrderID = "1->" + chargeItemId; p_objPatientChargeVO.AttachOrderBaseNum = 0; p_objPatientChargeVO.SPEC_VCHR = dr["itemspec_vchr"].ToString(); p_objPatientChargeVO.PutMedicineFlag = 0; p_objPatientChargeVO.CHARGEDOCTORID_CHR = dtPatientInfo.Rows[0]["casedoctor_chr"].ToString(); p_objPatientChargeVO.CHARGEDOCTOR_VCHR = dtPatientInfo.Rows[0]["lastname_vchr"].ToString(); p_objPatientChargeVO.CHARGEDOCTORGROUPID_CHR = ""; }
public long m_lngInsertRegister(string p_strlsh0, string p_inpatientid) { long lngRes = -1; DataTable dtResult = new DataTable(); string strSQL = @"select a.registerid_chr, a.inpatientid_chr, a.inpatient_dat, a.areaid_chr, a.bedid_chr, a.inareadate_dat, a.mzdiagnose_vchr, b.homeaddress_vchr, b.birth_dat, b.insuranceid_vchr, b.homephone_vchr, b.lastname_vchr, b.sex_chr, b.idcard_chr, b.operatorid_chr as inhospital_operator, b.govcard_chr, c.code_chr, d.outhospital_dat, d.operatorid_chr as outhospital_operator, d.diagnose_vchr, d.diseasetype_int, e.deptname_vchr, f.lastname_vchr as reg_operator, h.paytypeno_vchr from t_opr_bih_register a, t_opr_bih_registerdetail b, t_bse_bed c, t_opr_bih_leave d, t_bse_deptdesc e, t_bse_employee f, t_bse_patient g, t_bse_patientpaytype h where a.registerid_chr = b.registerid_chr and a.registerid_chr = d.registerid_chr and a.deptid_chr = e.deptid_chr(+) and a.patientid_chr = g.patientid_chr(+) and g.paytypeid_chr = h.paytypeid_chr and a.inpatientid_chr = ? and a.pstatus_int = 2 and b.registerid_chr = c.bihregisterid_chr(+) and b.operatorid_chr = f.empid_chr(+) and d.status_int = 1"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objSvc = new clsHRPTableService(); IDataParameter[] objDPArr; objSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_inpatientid; lngRes = objSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); DataRow drPatientInfo = null; if (lngRes > 0 && dtResult.Rows.Count > 0) { drPatientInfo = dtResult.Rows[0]; } dtResult.Dispose(); objSvc.Dispose(); #region 插入台山旧的His系统 baojian.mo if (drPatientInfo == null) { return(0); } else { com.digitalwave.iCare.middletier.TSZZYHRPServiceYB.clsTSYBHRPService objYBSvc = new com.digitalwave.iCare.middletier.TSZZYHRPServiceYB.clsTSYBHRPService(); //Created by baojian.mo string strSQL1 = @"delete from zy_zydjb0 where zyhao0 = '"; strSQL = @"insert into zy_zydjb0 (zylsh0, zyhao0, brxm00, brxbie, brnl00, brdzhi, brlxdh, sfzhao, zydjrq, zyrqi0, zyfwbm, ksmc00, cwbhao, zyyyin, ysxm00, bzhong, cydjr0, ylbxh1, cyzd00, sffsbh ) values ("; StringBuilder sb = new StringBuilder(); DateTime datTmp; string strTemp = null; sb.Append(p_strlsh0 + ", '"); if (drPatientInfo["inpatientid_chr"].ToString().Length > 9) { strTemp = drPatientInfo["inpatientid_chr"].ToString().Substring(drPatientInfo["inpatientid_chr"].ToString().Length - 9, 9); sb.Append(strTemp + "', '");//截后面9位 } else { strTemp = drPatientInfo["inpatientid_chr"].ToString(); sb.Append(strTemp + "', '"); } //<------------------------ strSQL1 += strTemp + "'"; //------------------------> sb.Append(drPatientInfo["lastname_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["sex_chr"].ToString() + "', "); if (string.IsNullOrEmpty(drPatientInfo["birth_dat"].ToString())) { sb.Append("null, '"); } else { datTmp = DateTime.Parse(drPatientInfo["birth_dat"].ToString()); strTemp = new clsBrithdayToAge().m_strGetAge(datTmp); sb.Append("'" + this.m_strCutString(strTemp) + "', '"); } sb.Append(drPatientInfo["homeaddress_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["homephone_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["idcard_chr"].ToString() + "', "); if (string.IsNullOrEmpty(drPatientInfo["inpatient_dat"].ToString())) { sb.Append("null, "); } else { datTmp = Convert.ToDateTime(drPatientInfo["inpatient_dat"]); strTemp = datTmp.ToString("yyyyMMdd"); sb.Append("'" + strTemp + "', "); } if (string.IsNullOrEmpty(drPatientInfo["inareadate_dat"].ToString())) { sb.Append("null, '"); } else { datTmp = Convert.ToDateTime(drPatientInfo["inareadate_dat"]); strTemp = datTmp.ToString("yyyyMMdd"); sb.Append("'" + strTemp + "', '"); } strTemp = drPatientInfo["areaid_chr"].ToString(); if (strTemp.Length > 6) { strTemp = strTemp.Substring(strTemp.Length - 6, 6); } sb.Append(strTemp + "', '"); sb.Append(drPatientInfo["deptname_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["code_chr"].ToString() + "', '"); sb.Append(drPatientInfo["mzdiagnose_vchr"].ToString() + "', '"); strTemp = m_strCutString(drPatientInfo["reg_operator"].ToString(), 8); sb.Append(strTemp + "', '"); sb.Append(drPatientInfo["diseasetype_int"].ToString() + "', "); //if (string.IsNullOrEmpty(drPatientInfo["outhospital_dat"].ToString())) //{ // sb.Append("null, null, "); //} //else //{ // datTmp = Convert.ToDateTime(drPatientInfo["outhospital_dat"]); // strTemp = datTmp.ToString("yyyyMMdd"); // sb.Append("'" + strTemp + "', '" + strTemp + "', "); //} sb.Append("'" + drPatientInfo["outhospital_operator"].ToString() + "', '"); sb.Append(drPatientInfo["insuranceid_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["diagnose_vchr"].ToString() + "', '"); sb.Append(drPatientInfo["paytypeno_vchr"].ToString() + "'"); strSQL += sb.ToString() + ")"; lngRes = objYBSvc.DoExcute(strSQL1); lngRes = objYBSvc.DoExcute(strSQL); objYBSvc.Dispose(); } #endregion } catch (Exception ex) { com.digitalwave.Utility.clsLogText objText = new clsLogText(); objText.LogError(ex); } return(lngRes); }
public clsOrderBooking() { this.m_objDomain = new clsDclOrderBooking(); m_objAge = new clsBrithdayToAge(); }