public IEnumerable<CIll> GetIllsByPym(string pym) { DCNhDataContext db=new DCNhDataContext(_hisConn); try { return (from ii in db.p_Illness where ii.OrganID == "420302" &&(ii.Spell.Contains(pym)|| ii.IllName.Contains(pym)) select new CIll { IllCode=ii.IllCode, IllDesc=ii.IllName, Spell=ii.Spell } ).ToArray(); } catch (System.Exception ex) { return null; } }
public CIll GetIllsByIllCode(string pym) { DCNhDataContext db = new DCNhDataContext(_hisConn); try { return (from ii in db.p_Illness where ii.OrganID == "420302" && ii.IllCode==pym select new CIll { IllCode = ii.IllCode, IllDesc = ii.IllName, Spell = ii.Spell } ).FirstOrDefault(); } catch (System.Exception ex) { return new CIll(); } }
public IEnumerable<string> ProcessFeeListByZyh(int zyh,bool Direct) { List<string> lsNoNhCodes = new List<string>(); DCCbhisDataContext hisDb = new DCCbhisDataContext(GSettings.HisConnStr); DCNhDataContext nhDb = new DCNhDataContext(GSettings.NhConnStr); var _NhPersonInfo = GetNhPersonInfoByZyh(zyh); if (_NhPersonInfo==null) { lsNoNhCodes.Add(" 未找到患者有效的农合入院登记信息"); return lsNoNhCodes; } StringBuilder sb = null; int hr = -1; var feeItems = from _f in hisDb.WyNhFeeList where _f.Zyh == zyh && _f.FeeNo == null select _f; foreach (var feeItem in feeItems) { try { var _nhcode = (from _f in nhDb.P_HiHosItem where _f.HosCode == feeItem.HosCode && _f.OrganId == _NhPersonInfo.OrganCode && _f.ztyear == _NhPersonInfo.AccountYear select _f).FirstOrDefault(); //var _nhcode = (from _f in nhDb.P_HiHosItem where _f.HosCode == feeItem.HosCode && _f.OrganId =="420302" && _f.ztyear == _NhPersonInfo.AccountYear select _f).FirstOrDefault(); if (_nhcode==null) { lsNoNhCodes.Add(string.Format(@"{0}农合项目编码为空", feeItem.HosCode)); } if (Direct || _nhcode!=null) { sb = new StringBuilder(256); hr = NhLocalWrap.SaveFreeList( string.Format("{0}$${1}", _NhPersonInfo.OrganCode, _NhPersonInfo.AccountYear), _NhPersonInfo.CoopMedCode, _NhPersonInfo.AiIDNo, int.Parse(_NhPersonInfo.DiagNo), null, feeItem.HosCode, //feeItem.UseDate, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), (double)feeItem.Price, (double)feeItem.Num, (double)feeItem.Fee, null, feeItem.OfficeName, feeItem.Doctor, "1", sb ); if (hr<0) { throw new Exception(string.Format(@"{0}单据上传错误:{1}", feeItem.Cfh, sb.ToString())); } if (_nhcode!=null) { feeItem.NhCode = _nhcode.InCode; } feeItem.FeeNo = sb.ToString(); hisDb.SubmitChanges(); } } catch (System.Exception ex) { lsNoNhCodes.Add(ex.Message); } } sb = new StringBuilder(500); hr = NhLocalWrap.PreClearing( string.Format("{0}$${1}", _NhPersonInfo.OrganCode, _NhPersonInfo.AccountYear), _NhPersonInfo.CoopMedCode, _NhPersonInfo.AiIDNo, int.Parse(_NhPersonInfo.DiagNo), 0, 2, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "1", sb ); return lsNoNhCodes; }
public WyNhRegister GetNhPersonInfoByZyh(int zyh) { try { DCCbhisDataContext hisDb = new DCCbhisDataContext(GSettings.HisConnStr); DCNhDataContext nhDb = new DCNhDataContext(GSettings.NhConnStr); var feeItems = from _f in hisDb.WyNhFeeList where _f.Zyh == zyh && _f.FeeNo == null select _f; var _NhPersonInfo = (from _f in hisDb.WyNhRegister where _f.Zyh == zyh && _f.IsFail == (byte)0 select _f).FirstOrDefault(); return _NhPersonInfo; } catch (System.Exception ex) { return null; } }