/// <summary> /// 转科医嘱 /// </summary> /// <param name="patlistid">病人ID</param> /// <param name="list">需自动停嘱对象</param> /// <param name="transDate">转科日期</param> /// <param name="transDeptID">转科科室</param> /// <param name="oprator">操作员</param> /// <param name="spciRecord">转科医嘱对象</param> public void TransDeptOrder(int patlistid, List <IPD_OrderRecord> list, DateTime transDate, int transDeptID, int oprator, IPD_OrderRecord spciRecord) { //医嘱自动停保存 foreach (IPD_OrderRecord record in list) { this.BindDb(record); record.save(); } IP_PatList patlist = NewObject <IP_PatList>().getmodel(patlistid) as IP_PatList; if (patlist.Status != 2 || patlist.IsLeaveHosOrder == 1) { throw new Exception("病人状态已经不在床或已经开出院医嘱,不能开转科医嘱"); } List <IPD_TransDept> listTrans = NewObject <IPD_TransDept>().getlist <IPD_TransDept>(" patlistid=" + patlistid + " and cancelFlag=0 and finishFlag=0"); if (listTrans.Count > 0) { throw new Exception("该病人存在未完成的转科医嘱,不能再开转科医嘱"); } SerialNumberSource serialNumberSource = NewObject <SerialNumberSource>(); string groupID = serialNumberSource.GetSerialNumber(SnType.医嘱组号); //生成说明性临嘱保存 spciRecord.GroupID = Convert.ToInt32(groupID); spciRecord.PatDeptID = patlist.CurrDeptID; spciRecord.WardID = patlist.CurrWardID; spciRecord.Dosage = 1; this.BindDb(spciRecord); spciRecord.save(); //转入信息保存 IPD_TransDept transDept = new IPD_TransDept(); transDept.Operator = oprator; transDept.PatListID = patlistid; transDept.OldDeptID = patlist.CurrDeptID; transDept.NewDeptID = transDeptID; transDept.TransDate = transDate; transDept.OrderID = spciRecord.OrderID; transDept.OperDate = DateTime.Now; transDept.FinishFlag = 0; this.BindDb(transDept); transDept.save(); }
/// <summary> /// 标注皮试 /// </summary> /// <param name="iOrder">医嘱ID</param> /// <param name="bIsPassed">是否通过(阴性)</param> /// <param name="iDeptId">科室ID</param> /// <param name="iEmpId">操作员ID</param> /// <returns>true:标记成功</returns> public bool CheckSkinTest(int iOrder, bool bIsPassed, int iDeptId, int iEmpId) { try { int iAstFlag = bIsPassed ? 1 : 2; IPD_OrderRecord orderRecord = NewObject <IPD_OrderRecord>().getmodel(iOrder) as IPD_OrderRecord; if (orderRecord != null) { //1.获取父医嘱 判断时候已经转抄,已转抄的不允许再修改 IPD_OrderRecord orderRecordF = NewObject <IPD_OrderRecord>().getmodel(orderRecord.AstOrderID) as IPD_OrderRecord; if (orderRecordF != null && orderRecordF.OrderStatus < 2) { //2.修改皮试医嘱的皮试结果 orderRecord.AstFlag = iAstFlag; orderRecord.ExecDate = System.DateTime.Now; this.BindDb(orderRecord); orderRecord.save(); //3.修改皮试医嘱对应的父医嘱的皮试结果 if (orderRecordF != null) { orderRecordF.AstFlag = iAstFlag; this.BindDb(orderRecordF); orderRecordF.save(); } //List<IPD_OrderRecord> orderRecordFList = NewObject<IPD_OrderRecord>().getlist<IPD_OrderRecord>(" AstOrderID=" + iOrder + " and CancelFlag = 0 and DeleteFlag = 0"); //foreach (IPD_OrderRecord orderRecordF in orderRecordFList) //{ // orderRecordF.AstFlag = iAstFlag; // this.BindDb(orderRecordF); // orderRecordF.save(); //} //4.修改或者增加皮试医嘱结果表信息 List <IPN_OrderAstResult> orderAstResultList = NewObject <IPN_OrderAstResult>().getlist <IPN_OrderAstResult>("OrderID =" + iOrder); if (orderAstResultList.Count > 0) { foreach (IPN_OrderAstResult orderAstResult in orderAstResultList) { orderAstResult.AstResult = iAstFlag; orderAstResult.ExecDeptID = iDeptId; orderAstResult.ExecEmpID = iEmpId; orderAstResult.ExecDate = System.DateTime.Now; this.BindDb(orderAstResult); orderAstResult.save(); } } else { IPN_OrderAstResult orderAstResult = NewObject <IPN_OrderAstResult>(); orderAstResult.OrderID = iOrder; orderAstResult.AstResult = iAstFlag; orderAstResult.ExecDeptID = iDeptId; orderAstResult.ExecEmpID = iEmpId; orderAstResult.ExecDate = System.DateTime.Now; this.BindDb(orderAstResult); orderAstResult.save(); } return(true); } else { return(false); } } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 保存医技申请 /// </summary> /// <param name="head">申请头实体</param> /// <param name="itemData">项目数据</param> /// <param name="dt">明细数据</param> /// <returns>申请头id</returns> public int SaveMedicalApply(EXA_MedicalApplyHead head, DataTable itemData, DataTable dt) { DataRow dr = null; head.Remark = GetItemName(itemData); DeleteData(itemData, dt); if (dt != null) { head.ApplyHeadID = Convert.ToInt32(dt.Rows[0]["ApplyHeadID"].ToString()); } this.BindDb(head); head.save(); int headid = head.ApplyHeadID; OPD_PresHead presHead = new OPD_PresHead(); if (head.SystemType == 0) { if (dt != null) { presHead.PresHeadID = Convert.ToInt32(dt.Rows[0]["PresHeadID"].ToString()); } presHead.MemberID = head.MemberID; presHead.PatListID = head.PatListID; presHead.PresType = 4; BindDb(presHead); int presheadid = presHead.save(); NewObject <PrescriptionProcess>().UpdatePatCurrentDoctorID(head.PatListID, head.ApplyDoctorID, head.ApplyDeptID); } for (int i = 0; i < itemData.Rows.Count; i++) { dr = NewDao <IOPDDao>().GetPresNO().Rows[0]; int predetailid = 0; OPD_PresDetail presdetail = new OPD_PresDetail(); IPD_OrderRecord orderRecord = new IPD_OrderRecord(); DataRow detaildr = null; DataTable orderdt = NewDao <IOPDDao>().GetStatID(itemData.Rows[i]["ExamItemID"].ToString()); if (dt != null) { detaildr = dt.Select("ItemID=" + Convert.ToInt32(itemData.Rows[i]["ExamItemID"].ToString())).FirstOrDefault(); } if (head.SystemType == 0) { if (detaildr != null) { presdetail.PresDetailID = Convert.ToInt32(detaildr["PresDetailID"]); } if (head.ApplyType == 2) { presdetail.Price = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()) * Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); presdetail.ChargeAmount = Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); presdetail.PresAmount = Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); } else { presdetail.Price = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()); presdetail.ChargeAmount = 1; presdetail.PresAmount = 1; } presdetail.DoseNum = 1; presdetail.PresHeadID = presHead.PresHeadID; presdetail.ItemID = Convert.ToInt32(itemData.Rows[i]["ExamItemID"].ToString()); presdetail.ItemName = itemData.Rows[i]["ExamItemName"].ToString(); presdetail.ExecDeptID = head.ExecuteDeptID; presdetail.StatID = Convert.ToInt32(orderdt.Rows[0]["StatID"]); if (dr != null) { if (dr["PresNO"] == null || dr["PresNO"].ToString() == string.Empty) { presdetail.PresNO = 1; } else { presdetail.PresNO = Convert.ToInt32(dr["PresNO"]) + 1; } } presdetail.IsEmergency = 0; presdetail.IsLunacyPosion = 0; presdetail.PresDate = head.ApplyDate; presdetail.PresDeptID = head.ApplyDeptID; presdetail.PresDoctorID = head.ApplyDoctorID; BindDb(presdetail); predetailid = presdetail.save(); if (presdetail.PresDetailID > 0) { predetailid = presdetail.PresDetailID; } } else { if (detaildr != null) { orderRecord.OrderID = Convert.ToInt32(detaildr["PresDetailID"]); } DataTable ipPatlist = NewDao <IOPDDao>().GetInBedPatient(head.PatListID); SerialNumberSource serialNumberSource = NewObject <SerialNumberSource>(); string groupID = serialNumberSource.GetSerialNumber(SnType.医嘱组号); orderRecord.GroupID = Convert.ToInt32(groupID); orderRecord.ExecDeptID = head.ExecuteDeptID; orderRecord.OrderCategory = 1; orderRecord.CancelFlag = 0; orderRecord.DeleteFlag = 0; orderRecord.AstFlag = -1; orderRecord.DoseNum = 1; orderRecord.Dosage = 1; // orderRecord.DosageUnit = itemData.Rows[i][""].ToString(); orderRecord.OrderStatus = 1; orderRecord.PatDeptID = Convert.ToInt32(ipPatlist.Rows[0]["CurrDeptID"]); orderRecord.WardID = Convert.ToInt32(ipPatlist.Rows[0]["EnterWardID"]); orderRecord.StatID = Convert.ToInt32(orderdt.Rows[0]["StatID"]); orderRecord.ItemID = Convert.ToInt32(itemData.Rows[i]["ExamItemID"].ToString()); orderRecord.PresDeptID = head.ApplyDeptID; orderRecord.OrderDoc = head.ApplyDoctorID; orderRecord.ItemName = itemData.Rows[i]["ExamItemName"].ToString(); orderRecord.Amount = Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); orderRecord.OrderBdate = head.CheckDate; //DateTime.Now; 20170418改成检查时间 if (head.ApplyType == 2) { orderRecord.ItemPrice = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()) * Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); } else { orderRecord.ItemPrice = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()); } orderRecord.ItemType = 4; orderRecord.PatListID = head.PatListID; BindDb(orderRecord); predetailid = orderRecord.save(); //插入费用明细 FeeItemDataSource feeDataSource = NewObject <FeeItemDataSource>(); DataTable dtDetailItem = feeDataSource.GetExamItemDetailDt(orderRecord.ItemID); for (int index = 0; index < dtDetailItem.Rows.Count; index++) { int feeitemId = Convert.ToInt32(dtDetailItem.Rows[index]["ITEMID"]); DataTable dtDrugItem = NewDao <IOPDDao>().GetFeeItemData(feeitemId); decimal amount = Convert.ToDecimal(dtDetailItem.Rows[index]["ItemAmount"]); DataRow[] rows = dtDrugItem.Select(" ItemID=" + feeitemId); if (rows.Length < 1) { continue; } IP_FeeItemGenerate feeItem = GenerateRecordFee(amount, 1, orderRecord, ipPatlist, rows[0]); feeItem.FeeSource = 1; feeItem.CalCostMode = 0; this.BindDb(feeItem); feeItem.save(); } } EXA_MedicalApplyDetail detail = new EXA_MedicalApplyDetail(); if (detaildr != null) { detail.ApplyDetailID = Convert.ToInt32(detaildr["ApplyDetailID"]); } detail.SystemType = head.SystemType; detail.PresDetailID = predetailid; detail.ApplyHeadID = head.ApplyHeadID; detail.ItemID = Convert.ToInt32(itemData.Rows[i]["ExamItemID"].ToString()); detail.ItemName = itemData.Rows[i]["ExamItemName"].ToString(); detail.Price = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()); if (head.ApplyType == 2) { detail.Amount = Convert.ToInt32(itemData.Rows[i]["Amount"].ToString()); detail.TotalFee = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()) * detail.Amount; } else { detail.Amount = 1; detail.TotalFee = Convert.ToDecimal(itemData.Rows[i]["Price"].ToString()); } BindDb(detail); detail.save(); } return(headid); }
/// <summary> /// 插入皮试医嘱 /// </summary> /// <param name="dtDrugItem">药品项目数据</param> /// <param name="astOrderRecord">皮试医嘱</param> /// <param name="ipPatlist">病人对象</param> private void InsertPSYZ(DataTable dtDrugItem, IPD_OrderRecord astOrderRecord, IP_PatList ipPatlist) { DataRow[] rows = dtDrugItem.Select(" ItemID=" + astOrderRecord.ItemID); if (rows.Length <= 0) { return; } DataRow row = rows[0]; List <IPD_OrderRecord> data = new List <IPD_OrderRecord>(); IPD_OrderRecord record = new IPD_OrderRecord(); record.ItemID = Convert.ToInt32(row["itemid"]); record.ItemName = row["itemname"].ToString(); record.ChannelName = "皮试"; record.ChannelID = 34; record.FrenquencyID = 22; record.Frequency = "q.d."; record.Amount = 1; record.Unit = row["MiniUnitName"].ToString(); record.UnitNO = 1; record.StatID = Convert.ToInt32(row["StatID"]); record.DoseNum = 1; record.OrderBdate = DateTime.Now; record.OrderCategory = 1; record.OrderType = 0; record.Dosage = 1; record.AstOrderID = astOrderRecord.OrderID; record.Factor = Convert.ToDecimal(row["DoseConvertNum"]); record.ItemType = Convert.ToInt32(row["ItemClass"]); record.ExecDeptID = astOrderRecord.ExecDeptID; record.AstFlag = 0; record.ItemPrice = Convert.ToDecimal(row["SellPrice"]); record.OrderStatus = 0; record.PatListID = astOrderRecord.PatListID; record.PresDeptID = astOrderRecord.PresDeptID; record.OrderDoc = astOrderRecord.OrderDoc; record.OrderID = 0; record.PatDeptID = ipPatlist.CurrDeptID; record.WardID = ipPatlist.CurrWardID; SerialNumberSource serialNumberSource = NewObject <SerialNumberSource>(); string groupID = serialNumberSource.GetSerialNumber(SnType.医嘱组号); record.GroupID = Convert.ToInt32(groupID); this.BindDb(record); record.save(); GenerateFee(record, dtDrugItem, ipPatlist); GenerateChannelFee(record, dtDrugItem, ipPatlist); int actDrugid = Convert.ToInt32(_getActDrugId()); if (actDrugid != 0) { DataRow[] drugrows = dtDrugItem.Select("ItemID=" + actDrugid); if (drugrows.Length > 0) { IPD_OrderRecord recordDrug = new IPD_OrderRecord(); recordDrug.ItemID = Convert.ToInt32(drugrows[0]["itemid"]); recordDrug.ItemName = drugrows[0]["itemname"].ToString(); recordDrug.ChannelName = record.ChannelName; recordDrug.ChannelID = record.ChannelID; recordDrug.FrenquencyID = record.FrenquencyID; recordDrug.OrderBdate = record.OrderBdate; recordDrug.Frequency = record.Frequency; recordDrug.Amount = 1; recordDrug.Unit = rows[0]["MiniUnitName"].ToString(); recordDrug.UnitNO = 1; recordDrug.StatID = Convert.ToInt32(rows[0]["StatID"]); recordDrug.DoseNum = 1; recordDrug.OrderStatus = 0; recordDrug.OrderCategory = 1; recordDrug.OrderType = 0; recordDrug.GroupID = record.GroupID; recordDrug.Dosage = 1; recordDrug.AstOrderID = astOrderRecord.OrderID; recordDrug.Factor = Convert.ToDecimal(rows[0]["DoseConvertNum"]); recordDrug.ItemType = Convert.ToInt32(rows[0]["ItemClass"]); recordDrug.ExecDeptID = astOrderRecord.ExecDeptID;// Convert.ToInt32(rows[0]["ExecDeptId"]); recordDrug.AstFlag = -1; recordDrug.ItemPrice = Convert.ToDecimal(rows[0]["SellPrice"]); recordDrug.PatListID = ipPatlist.PatListID; recordDrug.PresDeptID = record.PresDeptID; recordDrug.OrderDoc = record.OrderDoc; recordDrug.OrderID = 0; recordDrug.Memo = "PsDrug"; recordDrug.PatDeptID = ipPatlist.CurrDeptID; recordDrug.WardID = ipPatlist.CurrWardID; this.BindDb(recordDrug); recordDrug.save(); GenerateFee(recordDrug, dtDrugItem, ipPatlist); } } }
/// <summary> /// 医嘱操作 /// </summary> /// <param name="records">医嘱数据</param> /// <param name="operatorType">//1医嘱删除 2医嘱发送 3医嘱停嘱 4医嘱取消停</param> /// <param name="empid">操作员ID</param> public void OperatorOrder(List <IPD_OrderRecord> records, int operatorType, int empid) { foreach (IPD_OrderRecord record in records) { IPD_OrderRecord newRecord = NewObject <IPD_OrderRecord>().getmodel(record.OrderID) as IPD_OrderRecord; if (operatorType == 1) { if (newRecord.OrderStatus > 1) { throw new Exception("已经转抄,不能删除"); } spcialOrderDelete(record, empid); //皮试医嘱删除,连带皮试医嘱产生的关联医嘱一起删除 if (record.AstFlag == 0) { //已经转抄的不能删除 List <IPD_OrderRecord> astRecords = NewObject <IPD_OrderRecord>().getlist <IPD_OrderRecord>("AstOrderID=" + newRecord.OrderID + " and OrderStatus<=1"); foreach (IPD_OrderRecord astRecord in astRecords) { List <IPD_OrderRecord> astSameRecords = NewObject <IPD_OrderRecord>().getlist <IPD_OrderRecord>("GroupID=" + astRecord.GroupID + " and OrderStatus<=1"); foreach (IPD_OrderRecord astSameRecord in astSameRecords) { astSameRecord.DeleteFlag = 1; this.BindDb(astSameRecord); astSameRecord.save(); } //原来存在费用,原来一组费用删除 List <IP_FeeItemGenerate> feeItems = NewObject <IP_FeeItemGenerate>().getlist <IP_FeeItemGenerate>(" GroupID=" + astRecord.GroupID); if (feeItems.Count > 0) { foreach (IP_FeeItemGenerate fee in feeItems) { this.BindDb(fee); fee.delete(); } } } } //删除的是关联皮试医嘱时,要把原来的医嘱改为免试 if (record.AstOrderID > 0) { IPD_OrderRecord aOrderRecord = NewObject <IPD_OrderRecord>().getmodel(record.AstOrderID) as IPD_OrderRecord; aOrderRecord.AstFlag = 3; aOrderRecord.save(); } } else if (operatorType == 3) { if (newRecord.OrderStatus != 2) { throw new Exception("不是已经转抄长嘱,不能停嘱"); } } else if (operatorType == 4) { if (newRecord.OrderStatus > 3) { throw new Exception("停嘱已经转抄,不能取消停嘱"); } } this.BindDb(record); record.save(); //医嘱删除时,医嘱费用同时删除 if (operatorType == 1) { if (record.OrderID > 0) { //原来存在费用,原来费用删除 List <IP_FeeItemGenerate> feeItems = NewObject <IP_FeeItemGenerate>().getlist <IP_FeeItemGenerate>(" OrderID=" + record.OrderID + " and groupid=" + record.GroupID); if (feeItems.Count > 0) { foreach (IP_FeeItemGenerate fee in feeItems) { this.BindDb(fee); fee.delete(); } } } } } }