/// <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);
}
