/// <summary> /// 判断病人是否存在转科记录 /// </summary> /// <param name="patlistid"></param> /// <returns></returns> public bool IsTurnDept(int patlistid) { string strWhere = Tables.zy_doc_transdept.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_transdept.CANCEL_FLAG + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_transdept.FINISH_FLAG + oleDb.EuqalTo() + 0; if (BindEntity <HIS.Model.ZY_DOC_TRANSDEPT> .CreateInstanceDAL(oleDb).Exists(strWhere)) { return(true); } return(false); }
/// <summary> /// 更新医疗服务项目 /// </summary> /// <param name="Item"></param> public void UpdateServiceItem(ServiceItem Item) { try { //更新记录信息 BindEntity <Model.BASE_SERVICE_ITEMS> .CreateInstanceDAL(oleDb).Update(Item.EntityModel); } catch (Exception err) { throw err; } }
/// <summary> /// 添加新处方头 /// </summary> /// <param name="medicalApplyList"></param> /// <returns></returns> private int AddNewPresHead(IList medicalApplyList) { HIS.Model.Mz_Doc_PresHead presHead = new HIS.Model.Mz_Doc_PresHead(); presHead.PatId = (int)this.PatList.PatID; presHead.PatListId = this.PatList.PatListID; presHead.PresType = "00"; presHead.Pres_Doc = Public.StaticConfig.CureDocCode; presHead.Pres_Dept = Public.StaticConfig.CureDeptCode; presHead.Pres_ExeDept = ((BaseMedical)medicalApplyList[0]).Dept_Id; presHead.Pres_Date = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime; return(BindEntity <Model.Mz_Doc_PresHead> .CreateInstanceDAL(oleDb).Add(presHead)); }
/// <summary> /// 保存采购入库单 /// </summary> /// <param name="billMaster">采购入库单表头</param> /// <param name="listOrder">采购入库单明细</param> /// <param name="deptId">药剂科室ID</param> public override void SaveBill(BillMaster billMaster, List <BillOrder> listOrder, long deptId) { try { YP_InMaster masterInstore = (YP_InMaster)billMaster; YP_InOrder inStore = new YP_InOrder(); oleDb.BeginTransaction(); //声明操作对象 IBaseDAL <YP_InMaster> inMasterDao = BindEntity <YP_InMaster> .CreateInstanceDAL(oleDb, BLL.Tables.YK_INMASTER); IBaseDAL <YP_InOrder> inOrderDao = BindEntity <YP_InOrder> .CreateInstanceDAL(oleDb, BLL.Tables.YK_INORDER); IBaseDAL <YP_Storage> storeDao = BindEntity <YP_Storage> .CreateInstanceDAL(oleDb, BLL.Tables.YK_STORAGE); YP_Dal ypDal = new YP_Dal(); ypDal._oleDb = oleDb; //获取入库单据号 if (masterInstore.OpType == ConfigManager.OP_YK_INOPTYPE) { masterInstore.BillNum = ypDal.YP_Bill_GetBillNum(ConfigManager.OP_YK_INOPTYPE, deptId).BillNum; } else if (masterInstore.OpType == ConfigManager.OP_YK_BACKSTORE) { masterInstore.BillNum = ypDal.YP_Bill_GetBillNum(ConfigManager.OP_YK_BACKSTORE, deptId).BillNum; } else { masterInstore.BillNum = ypDal.YP_Bill_GetBillNum(ConfigManager.OP_YK_FIRSTIN, deptId).BillNum; } inMasterDao.Add(masterInstore); foreach (BillOrder order in listOrder) { //遍历DataTable取出明细记录并设置记录的值 inStore = (YP_InOrder)order; //计算入库金额 masterInstore.RetailFee += inStore.RetailFee; masterInstore.StockFee += inStore.StockFee; masterInstore.TradeFee += inStore.TradeFee; inStore.MasterInStorageID = masterInstore.MasterInStorageID; inStore.BillNum = masterInstore.BillNum; //依次添加明细记录 inOrderDao.Add(inStore); } inMasterDao.Update(masterInstore); oleDb.CommitTransaction(); } catch (Exception error) { oleDb.RollbackTransaction(); throw error; } }
/// <summary> /// 获得病人处方 /// </summary> /// <returns></returns> public DataTable GetPrescription(long presDocId) { int presNo = 0; InterFace.PrescMoneyCalculateInterFace PrescMoneyCalculateInterFace = new InterFace.PrescMoneyCalculateInterFace(); //获取处方头列表信息 List <Prescription> prescriptions = new List <Prescription>(); string strsql = HIS.BLL.Tables.mz_doc_preshead.PATLISTID + oleDb.EuqalTo() + this.PatList.PatListID + oleDb.And() + HIS.BLL.Tables.mz_doc_preshead.PRES_FLAG + oleDb.LessThan() + 3 + oleDb.And() + HIS.BLL.Tables.mz_doc_preshead.PRES_DOC + oleDb.EuqalTo() + presDocId + oleDb.OrderBy(HIS.BLL.Tables.mz_doc_preshead.PRESHEADID); List <HIS.Model.Mz_Doc_PresHead> presHead = BindEntity <HIS.Model.Mz_Doc_PresHead> .CreateInstanceDAL(oleDb).GetListArray(strsql); for (int index = 0; index < presHead.Count; index++) { //获取处方明细信息 List <PresDetail> presLists = new PresDetail(presHead[index].PresHeadId).GetAllPresDetailList(); if (presLists.Count > 0) { presNo++; List <Prescription> presTemp = new List <Prescription>(); for (int i = 0; i < presLists.Count; i++) { Prescription prescription = new Prescription(); prescription = (Prescription)HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjectToObj(presLists[i], prescription); prescription.Dept_Id = presHead[index].Pres_ExeDept; prescription.LoadData(); prescription.PresNo = presNo; prescription.Status = (HIS.MZDoc_BLL.Public.PresStatus)presHead[index].Pres_Flag; prescription.Pres_Date = presHead[index].Pres_Date; prescriptions.Add(prescription); if (prescription.SelfDrug_Flag == 0 || !prescription.IsDrug) { presTemp.Add(prescription); } } //插入小记 Prescription prescription0 = new Prescription(); prescription0.PresHeadId = presHead[index].PresHeadId; prescription0.Dept_Id = presHead[index].Pres_ExeDept; prescription0.Item_Name = "小计:"; prescription0.PresNo = presNo; prescription0.OrderNo = presLists.Count + 1; //2009-12-22 统一医生站和收费系统的处方费用合计 prescription0.Item_Money = (presTemp.Count <= 0) ? "0.0" : (PrescMoneyCalculateInterFace.GetPrescriptionTotalMoney(presTemp).ToString());//itemMoney.ToString(); prescription0.Status = (HIS.MZDoc_BLL.Public.PresStatus)presHead[index].Pres_Flag; prescriptions.Add(prescription0); } } return(HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjToDataTable(prescriptions)); }
/// <summary> /// 发药消息明细 /// </summary> /// <param name="presorderid"></param> /// <param name="masterid"></param> public void InsertDrugMessageRecord(int presorderid, int masterid) { Model.ZY_DRUGMESSAGE_MASTER zyDurgMessageMaster = new ZY_DRUGMESSAGE_MASTER(); Model.ZY_PresOrder zyPresOrder = BindEntity <ZY_PresOrder> .CreateInstanceDAL(oleDb).GetModel(presorderid); Model.ZY_PatList zyPatlist = BindEntity <ZY_PatList> .CreateInstanceDAL(oleDb).GetModel(zyPresOrder.PatListID); Model.YP_MakerDic makerdic = BindEntity <YP_MakerDic> .CreateInstanceDAL(oleDb).GetModel(zyPresOrder.ItemID); Model.YP_ProductDic productdic = BindEntity <YP_ProductDic> .CreateInstanceDAL(oleDb).GetModel(makerdic.ProductID); Model.ZY_DRUGMESSAGE_ORDER zy_drugMessageOrder = new ZY_DRUGMESSAGE_ORDER(); zy_drugMessageOrder.MASTERID = masterid; zy_drugMessageOrder.MAKERDICID = zyPresOrder.ItemID; zy_drugMessageOrder.CHEMNAME = zyPresOrder.ItemName; zy_drugMessageOrder.SPEC = zyPresOrder.Standard; zy_drugMessageOrder.DRUGNUM = zyPresOrder.Amount; zy_drugMessageOrder.CUREDEPT = Convert.ToInt32(zyPresOrder.PresDeptCode); zy_drugMessageOrder.CUREDOC = Convert.ToInt32(zyPresOrder.PresDocCode); zy_drugMessageOrder.CURENO = zyPatlist.CureNo; zy_drugMessageOrder.PATNAME = zyPatlist.PatientInfo.PatName; zy_drugMessageOrder.BEDNO = zyPatlist.BedCode; zy_drugMessageOrder.PATID = zyPresOrder.PatListID; zy_drugMessageOrder.UNITNAME = zyPresOrder.Unit; zy_drugMessageOrder.TRADEPRICE = zyPresOrder.Buy_Price; zy_drugMessageOrder.RETAILPRICE = zyPresOrder.Sell_Price; zy_drugMessageOrder.UNITNUM = Convert.ToInt32(zyPresOrder.RelationNum); zy_drugMessageOrder.ORDERRECIPEID = presorderid; zy_drugMessageOrder.CHARGEMAN = Convert.ToInt32(zyPresOrder.ChargeCode); zy_drugMessageOrder.CHARGEDATE = zyPresOrder.CostDate; zy_drugMessageOrder.ORDERGROUP_ID = zyPresOrder.group_id; zy_drugMessageOrder.DOCORDERTYPE = zyPresOrder.order_type; zy_drugMessageOrder.DOCORDERID = zyPresOrder.order_id; zy_drugMessageOrder.SPECDICID = makerdic.SpecDicID; // add 2010-09-19 zenghao zy_drugMessageOrder.PRODUCTNAME = productdic.ProductName; // add 2010-09-19 zenghao BindEntity <ZY_DRUGMESSAGE_ORDER> .CreateInstanceDAL(oleDb).Add(zy_drugMessageOrder); //object obj = BindEntity<ZY_DRUGMESSAGE_ORDER>.CreateInstanceDAL(oleDb).GetFieldValue("max(drugmessageid)", "1=1"); //string strwhere2 = "drugmessageid=" + int.Parse(obj.ToString()); //string updatefield = Tables.zy_drugmessage_order.SPECDICID+oleDb.EuqalTo()+ makerdic.SpecDicID; //BindEntity<HIS.Model.ZY_DRUGMESSAGE_ORDER>.CreateInstanceDAL(oleDb).Update(strwhere2, updatefield); //string strWhere = "drugmessageid=" + masterid; //string updatefiled1 = Tables.zy_drugmessage_master.PRESDEPTID + oleDb.EuqalTo() +Convert.ToInt32(zyPresOrder.PresDeptCode); //string updatefiled2 = Tables.zy_drugmessage_master.DISPDEPT + oleDb.EuqalTo() + Convert.ToInt32(zyPresOrder.ExecDeptCode); //BindEntity<HIS.Model.ZY_DRUGMESSAGE_MASTER>.CreateInstanceDAL(oleDb).Update(strWhere, updatefiled1,updatefiled2); return; }
/// <summary> /// 判断是否有科室 /// </summary> /// <returns></returns> public bool HasDepartments() { int count = BindEntity <Model.BASE_DEPT_PROPERTY> .CreateInstanceDAL(oleDb).GetListArray(BLL.Tables.base_dept_property.P_DEPT_ID + oleDb.EuqalTo( ) + layerId).Count; if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 判断是否有子层 /// </summary> /// <returns></returns> public bool HasChild() { int count = BindEntity <Model.BASE_DEPT_LAYER> .CreateInstanceDAL(oleDb).GetListArray(BLL.Tables.base_dept_layer.P_LAYER_ID + oleDb.EuqalTo( ) + layerId).Count; if (count > 0) { return(true); } else { return(false); } }
internal BindableObjectHandler Subscribe(BindableObject _object, Type propertyType, string propertyName) { if (!_callmap[propertyType].ContainsKey(propertyName)) { _callmap[propertyType].Add(propertyName, null); } var listenner = _callmap[propertyType]; var bindTarget = new BindEntity(_object, propertyName, this, propertyType); _entitys.Add(bindTarget); return(this); }
/// <summary> /// 就诊号号获得病人 /// </summary> /// <param name="InvoiceSerialNo">就诊号</param> public OutPatient(string VisitNo) { //List<HIS.Model.MZ_CostMaster> models = null; HIS.Model.MZ_PatList model = null; model = BindEntity <Model.MZ_PatList> .CreateInstanceDAL(oleDb).GetModel(Tables.mz_patlist.VISITNO + "='" + VisitNo + "'"); if (model == null) { throw new Exception("输入的门诊就诊号找不到病人登记信息"); } BindData(model); }
public void Add() { if (!BindEntity <PatientInfo> .CreateInstanceDAL(oleDb).Exists(this.PatID)) { this.CureNum = 1; BindEntity <PatientInfo> .CreateInstanceDAL(oleDb).Add(this); } else { this.CureNum = this.CureNum + 1; BindEntity <PatientInfo> .CreateInstanceDAL(oleDb).Update(this); } }
/// <summary> /// 获得所遇人员 /// </summary> /// <returns></returns> public static Employee[] GetEmployeies(string strWhere) { System.Collections.Generic.List <Model.BASE_EMPLOYEE_PROPERTY> list = BindEntity <Model.BASE_EMPLOYEE_PROPERTY> .CreateInstanceDAL(oleDb).GetListArray(strWhere); Employee[] employeies = new Employee[list.Count]; for (int i = 0; i < list.Count; i++) { employeies[i] = new Employee(list[i].EMPLOYEE_ID); } return(employeies); }
/// <summary> ///根据模板类型名得到该类型的模板名 /// </summary> /// <returns></returns> public List <HIS.Model.ZY_NURSE_FEEMODEL> GetModelName(int model_id) { try { string strWhere = Tables.zy_nurse_feemodel.P_ID + HIS.SYSTEM.Core.BaseBLL.oleDb.EuqalTo() + model_id + HIS.SYSTEM.Core.BaseBLL.oleDb.And() + Tables.zy_nurse_feemodel.DELETE_FLAG + HIS.SYSTEM.Core.BaseBLL.oleDb.EuqalTo() + 0; return(BindEntity <HIS.Model.ZY_NURSE_FEEMODEL> .CreateInstanceDAL(HIS.SYSTEM.Core.BaseBLL.oleDb).GetListArray(strWhere)); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 修改病人信息 /// </summary> /// <returns></returns> public void UpdatePatientInfo() { string[] pywb = GWMHIS.BussinessLogicLayer.Classes.PublicStaticFun.GetPyWbCode(_patientInfo.PatName); _patientInfo.PYM = pywb[0]; _patientInfo.WBM = pywb[1]; GetPatBirthday(); BindEntity <Model.PatientInfo> .CreateInstanceDAL(oleDb).Update(_patientInfo); _patList.PYM = pywb[0]; _patList.WBM = pywb[1]; BindEntity <Model.MZ_PatList> .CreateInstanceDAL(oleDb).Update(_patList); }
/// <summary> /// 获取医技申请格式的Xml文本 /// </summary> /// <param name="medicalClassId">医技类型Id</param> /// <returns></returns> public static string GetMedicalApplyXmlDocument(int medicalClassId) { Model.Base_Medical_Class medical_class = BindEntity <Model.Base_Medical_Class> .CreateInstanceDAL(oleDb).GetModel(medicalClassId); if (medical_class != null) { return(medical_class.PrintType); } else { return(""); } }
/// <summary> /// 对入院病人分配床位后修改入院状态 /// </summary> /// <param name="patid"></param> public void updateBedFlag(int patid) { try { string strWhere = "patlistid=" + patid; string string1 = "pattype='1'"; BindEntity <HIS.Model.ZY_PatList> .CreateInstanceDAL(oleDb).Update(strWhere, string1); } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 获取农合药品目录 /// </summary> /// <returns></returns> public static DataTable Get_Ncms_DrugList() { return(BindEntity <Model.NCMS_DRUG_CATALOG> .CreateInstanceDAL(oleDb).GetList("", HIS.BLL.Tables.ncms_drug_catalog.DRUG_CODE, HIS.BLL.Tables.ncms_drug_catalog.DRUG_NAME, HIS.BLL.Tables.ncms_drug_catalog.DRUG_ALIAS, HIS.BLL.Tables.ncms_drug_catalog.DRUG_TYPE, HIS.BLL.Tables.ncms_drug_catalog.DRUG_FORM, HIS.BLL.Tables.ncms_drug_catalog.LIMIT_PRICE, HIS.BLL.Tables.ncms_drug_catalog.LIMIT_DESC, HIS.BLL.Tables.ncms_drug_catalog.USE_LEVEL )); }
public decimal[] GetMenoyAndPosFee(string ChargeCode) { decimal[] dec = new decimal[5]; string strWhere = "ACCOUNTID = 0 and CHARGECODE = '" + ChargeCode + "' "; dec[0] = Convert.ToDecimal(BindEntity <HIS.ZY_BLL.DataModel.ZY_CostMaster> .CreateInstanceDAL(oleDb).GetSum("MONEY_FEE", strWhere)); dec[1] = Convert.ToDecimal(BindEntity <HIS.ZY_BLL.DataModel.ZY_CostMaster> .CreateInstanceDAL(oleDb).GetSum("POS_FEE", strWhere)); dec[2] = Convert.ToDecimal(BindEntity <HIS.ZY_BLL.DataModel.ZY_CostMaster> .CreateInstanceDAL(oleDb).GetSum("VILLAGE_FEE", strWhere)); dec[3] = Convert.ToDecimal(BindEntity <HIS.ZY_BLL.DataModel.ZY_CostMaster> .CreateInstanceDAL(oleDb).GetSum("FAVOR_FEE", strWhere)); dec[4] = Convert.ToDecimal(BindEntity <HIS.ZY_BLL.DataModel.ZY_CostMaster> .CreateInstanceDAL(oleDb).GetSum("DEPTOSIT_FEE", strWhere)); return(dec); }
/// <summary> /// 根据住院号得到病人信息 /// </summary> /// <param name="CureNo">住院号</param> /// <returns></returns> public ZY_PatList GetPatInfo(string CureNo) { try { //[20100628.0.07] string strWhere = "CURENO ='" + CureNo + "' and PATTYPE<>'6' order by PATLISTID desc " + oleDb.FETCH(); return(BindEntity <ZY_PatList> .CreateInstanceDAL(oleDb).GetModel(strWhere)); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> ///根据模板类型名得到该类型的模板名 /// </summary> /// <returns></returns> public DataTable GetModelName(int model_id) { try { string strWhere = Tables.zy_doc_ordermodel.P_ID + oleDb.EuqalTo() + model_id + oleDb.And() + Tables.zy_doc_ordermodel.DELETE_FLAG + oleDb.EuqalTo() + 0; return(BindEntity <HIS.Model.ZY_DOC_ORDERMODEL> .CreateInstanceDAL(oleDb).GetList(strWhere, Tables.zy_doc_ordermodel.MODEL_ID, Tables.zy_doc_ordermodel.MODEL_NAME)); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 更新门诊医生参数 /// </summary> private void UpdateMZYSConfig() { Parameters ps = parameterCollection[ParameterCatalog.门诊医生站]; foreach (Parameter p in ps) { string strWhere = "Code='" + p.Code + "'"; BindEntity <Model.MZ_DOC_CONFIG> .CreateInstanceDAL(oleDb).Update(strWhere, Tables.mz_config.VALUE + oleDb.EuqalTo() + "'" + FormatString(p.Value.ToString()) + "'", Tables.mz_config.BZ + oleDb.EuqalTo() + "'" + FormatString(p.Notes.Trim()) + "'", Tables.mz_config.NAME + oleDb.EuqalTo() + "'" + FormatString(p.Name.Trim()) + "'"); } }
/// <summary> /// 取消出院和死亡时修改病人 /// </summary> /// <param name="patlistid"></param> public void CancelOutDeath(int patlistid) { string strWhere = Tables.zy_patlist.PATLISTID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_patlist.PATTYPE + oleDb.EuqalTo() + "'7'"; string[] strSet = new string[5]; strSet[0] = Tables.zy_patlist.PATTYPE + oleDb.EuqalTo() + "'2'"; strSet[1] = Tables.zy_patlist.OUT_FLAG + oleDb.EuqalTo() + 0; strSet[2] = Tables.zy_patlist.OUTDIAGNCODE + oleDb.EuqalTo() + "''"; strSet[3] = Tables.zy_patlist.OUTDIAGNNAME + oleDb.EuqalTo() + "''"; strSet[4] = Tables.zy_patlist.OUTDATE + oleDb.EuqalTo() + "'0001-01-01'"; BindEntity <HIS.Model.ZY_PatList> .CreateInstanceDAL(oleDb).Update(strWhere, strSet); }
/// <summary> /// 删除报表 /// </summary> /// <param name="Rptid"></param> /// <returns></returns> public static bool DeleteReport(int Rptid) { try { BindEntity <Model.HIS_Report> .CreateInstanceDAL(oleDb).Delete(Rptid); return(true); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 检索指定药剂科室的未删除所有药品批次 /// </summary> /// <param name="deptId">指定科室ID</param> /// <returns>药品批次列表</returns> public static DataTable LoadBatch(int deptId) { try { string strWhere = BLL.Tables.yk_batch.DEPTID + oleDb.EuqalTo() + deptId.ToString() + oleDb.And() + BLL.Tables.yk_batch.DEL_FLAG + oleDb.EuqalTo() + "0"; return(BindEntity <YP_Batch> .CreateInstanceDAL(oleDb, Tables.YK_BATCH).GetList(strWhere)); } catch (Exception error) { throw error; } }
public static DataTable GetYKDept() { try { string strWhere = BLL.Tables.yp_deptdic.DEPTTYPE1 + oleDb.EuqalTo() + "'药库'" + oleDb.Or() + BLL.Tables.yp_deptdic.DEPTTYPE1 + oleDb.EuqalTo() + "'物资'"; return(BindEntity <YP_DeptDic> .CreateInstanceDAL(oleDb).GetList(strWhere)); } catch (Exception error) { throw error; } }
/// <summary> /// 检索指定药品在药剂科室中的批次(含已删除的) /// </summary> /// <param name="makerdicId">药品厂家典ID</param> /// <param name="deptId">药剂科室ID</param> /// <returns>药品批次列表</returns> public static DataTable LoadBatchWithDelete(int makerdicId, int deptId) { try { string strWhere = BLL.Tables.yk_batch.DEPTID + oleDb.EuqalTo() + deptId.ToString() + oleDb.And() + BLL.Tables.yk_batch.MAKERDICID + oleDb.EuqalTo() + makerdicId.ToString() + oleDb.OrderBy() + BLL.Tables.yk_batch.CURRENTNUM + oleDb.DESC(); //update by heyan 2010.12.15 return(BindEntity <YP_Batch> .CreateInstanceDAL(oleDb, Tables.YK_BATCH).GetList(strWhere)); } catch (Exception error) { throw error; } }
public void UpdateNoDrugFlag(int orderrecipeid, DateTime chargeTime) { try { string strWhere = Tables.zy_drugmessage_order.ORDERRECIPEID + oleDb.EuqalTo() + orderrecipeid.ToString() + oleDb.And() + Tables.zy_drugmessage_order.CHARGEDATE + oleDb.EuqalTo() + "'" + chargeTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; BindEntity <ZY_DRUGMESSAGE_ORDER> .CreateInstanceDAL(oleDb).Update(strWhere, "NODRUG_FLAG=1"); } catch (Exception error) { throw error; } }
/// <summary> /// 加载药品单位数据 /// </summary> /// <returns></returns> public static DataTable LoadUnitDic() { try { unit = BindEntity <HIS.Model.YP_UnitDic> .CreateInstanceDAL(oleDb, Tables.YP_UNITDIC).GetList("", Tables.yp_unitdic.UNITNAME, Tables.yp_unitdic.PYM, Tables.yp_unitdic.WBM); return(unit); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 查找病人信息 /// </summary> /// <param name="strWhere">查询条件</param> /// <returns></returns> public static OutPatient[] GetPatient(string strWhere) { List <HIS.Model.MZ_PatList> patList = BindEntity <Model.MZ_PatList> .CreateInstanceDAL(oleDb).GetListArray(strWhere); OutPatient[] patients = new OutPatient[patList.Count]; for (int i = 0; i < patList.Count; i++) { patients[i] = new OutPatient(patList[i].PatListID); } return(patients); }
/// <summary> /// 作废医嘱(只改医嘱内容,在内容前加“取消”) /// </summary> /// <param name="rowid"></param> /// <param name="dt"></param> /// <returns></returns> public bool Abolish(HIS.Model.ZY_DOC_ORDERRECORD record) { //作废时加“取消”的内容从数据库中取,不从界面上取 2010.4.6 string name = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetFieldValue (Tables.zy_doc_orderrecord.ORDER_CONTENT, Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + record.ORDER_ID).ToString(); string strSet = Tables.zy_doc_orderrecord.ORDER_CONTENT + oleDb.EuqalTo() + "'" + "【取消】" + name + "'"; BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).Update(Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + record.ORDER_ID, strSet); return(true); }