/// <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">药品厂家典ＩＤ</param>
/// <param name="deptId">药剂科室ＩＤ</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);
}
