/// <summary> /// 通过医嘱表ID获得药品或项目ID /// </summary> /// <returns></returns> public int GetItemId() { DataRow[] dr = CashDataTable.Select("order_id = " + order_id + ""); if (dr != null && dr.Length > 0) //如果能在缓存表中找到,则直接从表中取得数据 { if (dr[0]["orditem_id"].ToString().Trim() != "0") { return(Convert.ToInt32(dr[0]["orditem_id"].ToString().Trim())); } else { return(Convert.ToInt32(dr[0]["makedicid"].ToString().Trim())); } } else { HIS.Model.ZY_DOC_ORDERRECORD record = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetModel(order_id); if (record.ORDITEM_ID != 0) { return(record.ORDITEM_ID); } return(record.MAKEDICID); } }
/// <summary> /// 通过医嘱表ID获得医嘱类别 /// </summary> /// <returns></returns> public OrderType GetOrderType() { DataRow[] dr = CashDataTable.Select("order_id = " + order_id + ""); if (dr != null && dr.Length > 0) //如果能在缓存表中找到,则直接从表中取得数据 { int index = Convert.ToInt32(dr[0]["order_type"].ToString()); if (dr[0]["execdept"].ToString() == "-1") { index = 4; } if (dr[0]["item_type"].ToString() == "10" && index == 0 && (dr[0]["order_content"].ToString() == "术后医嘱" || dr[0]["order_content"].ToString() == "产后医嘱")) { index = 8; } return((OrderType)Convert.ToInt32(index)); } else { DataTable dt = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetList(Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + order_id); int index = Convert.ToInt32(dt.Rows[0]["order_type"].ToString()); if (dt.Rows[0]["execdept"].ToString() == "-1") { index = 4; } if (dt.Rows[0]["item_type"].ToString() == "10" && index == 0 && (dt.Rows[0]["order_content"].ToString() == "术后医嘱" || dt.Rows[0]["order_content"].ToString() == "产后医嘱")) { index = 8; } return((OrderType)Convert.ToInt32(index)); } }
/// <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> /// 通过医嘱表ID获得首日执行次数 /// </summary> /// <returns></returns> public int GetFirstTimes() { DataRow[] dr = CashDataTable.Select("order_id = " + order_id + ""); if (dr != null && dr.Length > 0) //如果能在缓存表中找到,则直接从表中取得数据 { return(Convert.ToInt32(dr[0]["firset_times"])); } else { object obj = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetFieldValue(Tables.zy_doc_orderrecord.FIRSET_TIMES, Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + order_id); return(Convert.ToInt32(obj.ToString())); } }
/// <summary> /// 通过医嘱表ID获得医嘱状态 /// </summary> /// <returns></returns> public Status GetStatus() { DataRow[] dr = CashDataTable.Select("order_id = " + order_id + ""); if (dr != null && dr.Length > 0) //如果能在缓存表中找到,则直接从表中取得数据 { return((Status)Convert.ToInt32(dr[0]["status_falg"])); } else { object obj = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetFieldValue(Tables.zy_doc_orderrecord.STATUS_FALG, Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + order_id); return((Status)Convert.ToInt32(obj.ToString())); } }
/// <summary> /// 通过医嘱表ID获得医嘱类型 /// </summary> /// <returns></returns> public ItemType GetItemType() { DataRow[] dr = CashDataTable.Select("order_id = " + order_id + ""); if (dr != null && dr.Length > 0) //如果能在缓存表中找到,则直接从表中取得数据 { return((ItemType)Convert.ToInt32(dr[0]["item_type"])); } else { object obj = BindEntity <HIS.Model.ZY_DOC_ORDERRECORD> .CreateInstanceDAL(oleDb).GetFieldValue(Tables.zy_doc_orderrecord.ITEM_TYPE, Tables.zy_doc_orderrecord.ORDER_ID + oleDb.EuqalTo() + order_id); return((ItemType)Convert.ToInt32(obj.ToString())); } }
internal CashRow(System.Data.DataRowBuilder rb) : base(rb) { this.tableCash = ((CashDataTable)(this.Table)); }
private void InitClass() { this.DataSetName = "MDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/MDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableCash = new CashDataTable(); base.Tables.Add(this.tableCash); this.tableDocumentType = new DocumentTypeDataTable(); base.Tables.Add(this.tableDocumentType); this.tableInvoiceMaster = new InvoiceMasterDataTable(); base.Tables.Add(this.tableInvoiceMaster); this.tableInvoiceDetail = new InvoiceDetailDataTable(false); base.Tables.Add(this.tableInvoiceDetail); this.tablePeriods = new PeriodsDataTable(); base.Tables.Add(this.tablePeriods); this.tableReceiptDetail = new ReceiptDetailDataTable(false); base.Tables.Add(this.tableReceiptDetail); this.tableReceiptMaster = new ReceiptMasterDataTable(); base.Tables.Add(this.tableReceiptMaster); this.tableReceiptRemains = new ReceiptRemainsDataTable(); base.Tables.Add(this.tableReceiptRemains); this.tableProduct = new ProductDataTable(); base.Tables.Add(this.tableProduct); this.tableRemains = new RemainsDataTable(false); base.Tables.Add(this.tableRemains); this.tableStock = new StockDataTable(); base.Tables.Add(this.tableStock); this.tableLocalSetting = new LocalSettingDataTable(); base.Tables.Add(this.tableLocalSetting); this.tableOrders = new OrdersDataTable(); base.Tables.Add(this.tableOrders); this.tableinventoryMaster = new inventoryMasterDataTable(); base.Tables.Add(this.tableinventoryMaster); this.tableinventoryDetails = new inventoryDetailsDataTable(false); base.Tables.Add(this.tableinventoryDetails); System.Data.ForeignKeyConstraint fkc; fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] { this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.InvoiceMasterRefColumn}); this.tableInvoiceDetail.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; fkc = new System.Data.ForeignKeyConstraint("Remains_InvoiceDetail", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}); this.tableInvoiceDetail.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.None; fkc = new System.Data.ForeignKeyConstraint("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] { this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] { this.tableinventoryDetails.inventoryMasterRefColumn}); this.tableinventoryDetails.Constraints.Add(fkc); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.None; fkc.UpdateRule = System.Data.Rule.Cascade; this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] { this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.InvoiceMasterRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster); this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationRemains_InvoiceDetail); this.relationFK_inventoryMaster_inventoryDetails = new System.Data.DataRelation("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] { this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] { this.tableinventoryDetails.inventoryMasterRefColumn}, false); this.Relations.Add(this.relationFK_inventoryMaster_inventoryDetails); this.relationFK_ReceiptDetail_ReceiptMaster = new System.Data.DataRelation("FK_ReceiptDetail_ReceiptMaster", new System.Data.DataColumn[] { this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ReceiptMasterRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptDetail_ReceiptMaster); this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] { this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.DocumentTypeRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType); this.relationFK_InvoiceDetail_ReceiptRemains = new System.Data.DataRelation("FK_InvoiceDetail_ReceiptRemains", new System.Data.DataColumn[] { this.tableReceiptRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false); this.Relations.Add(this.relationFK_InvoiceDetail_ReceiptRemains); this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.MainStockRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Stock); this.relationFK_ReceiptMaster_Stock1 = new System.Data.DataRelation("FK_ReceiptMaster_Stock1", new System.Data.DataColumn[] { this.tableStock.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptMaster.SenderStockRefColumn}, false); this.Relations.Add(this.relationFK_ReceiptMaster_Stock1); this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] { this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.IDColumn}, false); this.Relations.Add(this.relationReceiptDetail_Remains); this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableReceiptDetail.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_ReceiptDetail); this.relationInvoiceDetail_Product = new System.Data.DataRelation("InvoiceDetail_Product", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableInvoiceDetail.ProductRefColumn}, false); this.Relations.Add(this.relationInvoiceDetail_Product); this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableOrders.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Orders); this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] { this.tableProduct.IDColumn}, new System.Data.DataColumn[] { this.tableRemains.ProductRefColumn}, false); this.Relations.Add(this.relationProduct_Remains); }
internal void InitVars(bool initTable) { this.tableCash = ((CashDataTable)(base.Tables["Cash"])); if ((initTable == true)) { if ((this.tableCash != null)) { this.tableCash.InitVars(); } } this.tableDocumentType = ((DocumentTypeDataTable)(base.Tables["DocumentType"])); if ((initTable == true)) { if ((this.tableDocumentType != null)) { this.tableDocumentType.InitVars(); } } this.tableInvoiceMaster = ((InvoiceMasterDataTable)(base.Tables["InvoiceMaster"])); if ((initTable == true)) { if ((this.tableInvoiceMaster != null)) { this.tableInvoiceMaster.InitVars(); } } this.tableInvoiceDetail = ((InvoiceDetailDataTable)(base.Tables["InvoiceDetail"])); if ((initTable == true)) { if ((this.tableInvoiceDetail != null)) { this.tableInvoiceDetail.InitVars(); } } this.tablePeriods = ((PeriodsDataTable)(base.Tables["Periods"])); if ((initTable == true)) { if ((this.tablePeriods != null)) { this.tablePeriods.InitVars(); } } this.tableReceiptDetail = ((ReceiptDetailDataTable)(base.Tables["ReceiptDetail"])); if ((initTable == true)) { if ((this.tableReceiptDetail != null)) { this.tableReceiptDetail.InitVars(); } } this.tableReceiptMaster = ((ReceiptMasterDataTable)(base.Tables["ReceiptMaster"])); if ((initTable == true)) { if ((this.tableReceiptMaster != null)) { this.tableReceiptMaster.InitVars(); } } this.tableReceiptRemains = ((ReceiptRemainsDataTable)(base.Tables["ReceiptRemains"])); if ((initTable == true)) { if ((this.tableReceiptRemains != null)) { this.tableReceiptRemains.InitVars(); } } this.tableProduct = ((ProductDataTable)(base.Tables["Product"])); if ((initTable == true)) { if ((this.tableProduct != null)) { this.tableProduct.InitVars(); } } this.tableRemains = ((RemainsDataTable)(base.Tables["Remains"])); if ((initTable == true)) { if ((this.tableRemains != null)) { this.tableRemains.InitVars(); } } this.tableStock = ((StockDataTable)(base.Tables["Stock"])); if ((initTable == true)) { if ((this.tableStock != null)) { this.tableStock.InitVars(); } } this.tableLocalSetting = ((LocalSettingDataTable)(base.Tables["LocalSetting"])); if ((initTable == true)) { if ((this.tableLocalSetting != null)) { this.tableLocalSetting.InitVars(); } } this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"])); if ((initTable == true)) { if ((this.tableOrders != null)) { this.tableOrders.InitVars(); } } this.tableinventoryMaster = ((inventoryMasterDataTable)(base.Tables["inventoryMaster"])); if ((initTable == true)) { if ((this.tableinventoryMaster != null)) { this.tableinventoryMaster.InitVars(); } } this.tableinventoryDetails = ((inventoryDetailsDataTable)(base.Tables["inventoryDetails"])); if ((initTable == true)) { if ((this.tableinventoryDetails != null)) { this.tableinventoryDetails.InitVars(); } } this.relationFK_InvoiceDetail_InvoiceMaster = this.Relations["FK_InvoiceDetail_InvoiceMaster"]; this.relationRemains_InvoiceDetail = this.Relations["Remains_InvoiceDetail"]; this.relationFK_inventoryMaster_inventoryDetails = this.Relations["FK_inventoryMaster_inventoryDetails"]; this.relationFK_ReceiptDetail_ReceiptMaster = this.Relations["FK_ReceiptDetail_ReceiptMaster"]; this.relationFK_ReceiptMaster_DocumentType = this.Relations["FK_ReceiptMaster_DocumentType"]; this.relationFK_InvoiceDetail_ReceiptRemains = this.Relations["FK_InvoiceDetail_ReceiptRemains"]; this.relationFK_ReceiptMaster_Stock = this.Relations["FK_ReceiptMaster_Stock"]; this.relationFK_ReceiptMaster_Stock1 = this.Relations["FK_ReceiptMaster_Stock1"]; this.relationReceiptDetail_Remains = this.Relations["ReceiptDetail_Remains"]; this.relationProduct_ReceiptDetail = this.Relations["Product_ReceiptDetail"]; this.relationInvoiceDetail_Product = this.Relations["InvoiceDetail_Product"]; this.relationProduct_Orders = this.Relations["Product_Orders"]; this.relationProduct_Remains = this.Relations["Product_Remains"]; }