/// <summary> /// 根据医嘱类别和病人ID获得病人的医嘱信息 /// </summary> /// <param name="patlistid">病人ID</param> /// <param name="babyid">婴儿Id</param> /// <param name="order_type">医嘱类型0=长期 1=临时 6=手术 -1有效长嘱</param> /// <returns></returns> private DataTable GetOrderDataTable(HIS.Model.ZY_PatList patlist, OrderType ordertype, Status status, int deptid) { try { string strWhere = ""; int patlistid = patlist.PatListID; if (ordertype == OrderType.临时医嘱) //临时医嘱 { strWhere = Tables.zy_doc_orderrecord.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_orderrecord.BABYID + oleDb.EuqalTo() + 0 + oleDb.And() + "(" + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + (int)ordertype + oleDb.Or() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 5 + oleDb.Or() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 7 + ")" + oleDb.And() + Tables.zy_doc_orderrecord.DELETE_FLAG + oleDb.NotEqualTo() + 1; } if (ordertype == OrderType.长期医嘱 && status == Status.所有) //长期医嘱 { strWhere = Tables.zy_doc_orderrecord.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_orderrecord.BABYID + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + (int)ordertype + oleDb.And() + Tables.zy_doc_orderrecord.DELETE_FLAG + oleDb.NotEqualTo() + 1; } if (ordertype == OrderType.长期医嘱 && status == Status.护士转抄)//已转抄医嘱 { strWhere = Tables.zy_doc_orderrecord.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_orderrecord.BABYID + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_orderrecord.STATUS_FALG + oleDb.EuqalTo() + 2 + oleDb.And() + Tables.zy_doc_orderrecord.DELETE_FLAG + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_orderrecord.ITEM_TYPE + oleDb.NotEqualTo() + 10; } //if (patlist.PatType != "3" && patlist.PatType != "4" && patlist.PatType != "5") //{ // strWhere += oleDb.And() + Tables.zy_doc_orderrecord.PRES_DEPTID + oleDb.EuqalTo() + deptid; // } List <HIS.Model.ZY_DOC_ORDERRECORD> records = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetListArray(strWhere); List <HIS.Model.zy_doc_orderrecord_son> recordSon = new List <HIS.Model.zy_doc_orderrecord_son>(); for (int i = 0; i < records.Count; i++) { HIS.Model.zy_doc_orderrecord_son son = new HIS.Model.zy_doc_orderrecord_son(); son = (HIS.Model.zy_doc_orderrecord_son)HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjectToObj(records[i], son); //son.LoadData(); GetName.GiveName(son); recordSon.Add(son); } return(HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjToDataTable(recordSon)); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 根据patlistid获得该病人特定类别的医嘱 /// </summary> /// <param name="patlistid"></param> /// <param name="ordertype"></param> /// <param name="isAll">true =全部 false=有效</param> /// <returns></returns> public DataTable GetOrders(int patlistid, OrderType ordertype, bool isAll)//得到医嘱信息 { string strWhere = ""; try { if (ordertype == OrderType.临时医嘱) //临时医嘱 { strWhere = Tables.zy_doc_orderrecord.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_orderrecord.BABYID + oleDb.EuqalTo() + 0 + oleDb.And() + "(" + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 1 + oleDb.Or() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 5 + oleDb.Or() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + 7 + ")" + oleDb.And() + Tables.zy_doc_orderrecord.DELETE_FLAG + oleDb.NotEqualTo() + 1; } else { strWhere = Tables.zy_doc_orderrecord.PATID + oleDb.EuqalTo() + patlistid + oleDb.And() + Tables.zy_doc_orderrecord.BABYID + oleDb.EuqalTo() + 0 + oleDb.And() + Tables.zy_doc_orderrecord.ORDER_TYPE + oleDb.EuqalTo() + (int)ordertype + oleDb.And() + Tables.zy_doc_orderrecord.DELETE_FLAG + oleDb.NotEqualTo() + 1; } if (!isAll) { strWhere += oleDb.And() + Tables.zy_doc_orderrecord.STATUS_FALG + oleDb.In("2", "4");// +oleDb.OrderBy(Tables.zy_doc_orderrecord.ORDER_BDATE, Tables.zy_doc_orderrecord.GROUP_ID, Tables.zy_doc_orderrecord.SERIAL_ID); } else { strWhere += oleDb.And() + Tables.zy_doc_orderrecord.STATUS_FALG + oleDb.GreaterThan() + 1;// +oleDb.OrderBy(Tables.zy_doc_orderrecord.ORDER_BDATE, Tables.zy_doc_orderrecord.GROUP_ID, Tables.zy_doc_orderrecord.SERIAL_ID); ; } List <HIS.Model.ZY_DOC_ORDERRECORD> records = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetListArray(strWhere); List <HIS.Model.zy_doc_orderrecord_son> recordSon = new List <HIS.Model.zy_doc_orderrecord_son>(); for (int i = 0; i < records.Count; i++) { HIS.Model.zy_doc_orderrecord_son son = new HIS.Model.zy_doc_orderrecord_son(); son = (HIS.Model.zy_doc_orderrecord_son)HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjectToObj(records[i], son); son.LoadData(); recordSon.Add(son); } CashDataTable = HIS.SYSTEM.PubicBaseClasses.ApiFunction.ObjToDataTable(recordSon); DataTable dt = CashDataTable.Copy(); PubMethd.OrderFomat(dt, 1); return(dt); } catch (System.Exception e) { throw new Exception(e.Message); } }
/// <summary> /// 模板应用 /// </summary> /// <param name="record"></param> /// <param name="model"></param> /// <param name="ordertype"></param> /// <param name="deptid"></param> /// <param name="order_doc"></param> public void ApplyModel(HIS.Model.zy_doc_orderrecord_son record, HIS.Model.ZY_DOC_ORDERMODELLIST model, int ordertype, int deptid, int order_doc) { ModelApply.ModelDataApply(record, model, ordertype, deptid, order_doc); }