/// <summary> /// 修改病人就诊状态 /// </summary> /// <param name="status"></param> public void ChangeCureInfo(Public.PatCureStatus status) { string strwhere = Tables.mz_patlist.PATLISTID + oleDb.EuqalTo() + this._patList.PatListID + oleDb.And() + Tables.mz_patlist.CURESTATUS + oleDb.NotEqualTo() + Public.PatCureStatus.结束状态.GetHashCode(); string[] strvalue = { Tables.mz_patlist.CUREEMPCODE + oleDb.EuqalTo() + "'" + Public.StaticConfig.CureDocCode + "'", Tables.mz_patlist.CUREDEPTCODE + oleDb.EuqalTo() + "'" + Public.StaticConfig.CureDeptCode + "'", Tables.mz_patlist.CURESTATUS + oleDb.EuqalTo() + status.GetHashCode() }; BindEntity <Model.MZ_PatList> .CreateInstanceDAL(oleDb).Update(strwhere, strvalue); }
/// <summary> /// 获得就诊病人列表 /// </summary> /// <param name="onlyCureDoc">是否是查找单个医生的病人</param> /// <param name="status">病人状态</param> /// <param name="beginTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <returns></returns> public static List <HIS.Model.MZ_PatList> SearchPatList(bool onlyCureDoc, Public.PatCureStatus status, DateTime beginTime, DateTime endTime) { string strsql = HIS.BLL.Tables.mz_patlist.CUREDATE + oleDb.Between() + "'" + beginTime.Date + "'" + oleDb.And() + "'" + endTime.Date.AddDays(1) + "'" + oleDb.And() + HIS.BLL.Tables.mz_patlist.VISITNO + oleDb.NotEqualTo() + "''"; if (onlyCureDoc) { strsql = strsql + oleDb.And() + '(' + HIS.BLL.Tables.mz_patlist.REG_DOC_CODE + oleDb.EuqalTo() + "'" + Public.StaticConfig.CureDocCode + "'" + oleDb.And() + HIS.BLL.Tables.mz_patlist.CUREEMPCODE + oleDb.EuqalTo() + "''" + oleDb.Or() + HIS.BLL.Tables.mz_patlist.CUREEMPCODE + oleDb.EuqalTo() + "'" + Public.StaticConfig.CureDocCode + "'" + ')'; } if (status == Public.PatCureStatus.结束状态) { strsql = strsql + oleDb.And() + Tables.mz_patlist.CURESTATUS + oleDb.EuqalTo() + Public.PatCureStatus.结束状态.GetHashCode(); } else { strsql = strsql + oleDb.And() + Tables.mz_patlist.CURESTATUS + oleDb.NotEqualTo() + Public.PatCureStatus.结束状态.GetHashCode(); } return(BindEntity <HIS.Model.MZ_PatList> .CreateInstanceDAL(oleDb).GetListArray(strsql)); }