/// <summary>
/// 通过医嘱表ＩＤ获得药品或项目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>
/// 通过医嘱表ＩＤ获得医嘱类别
/// </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>
/// 通过医嘱表ＩＤ获得首日执行次数
/// </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>
/// 通过医嘱表ＩＤ获得医嘱状态
/// </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>
/// 通过医嘱表ＩＤ获得医嘱类型
/// </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"];
}
