Esempio n. 1
0
        /// <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);
        }
Esempio n. 2
0
        /// <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));
        }