/// <summary> /// 是否已成功插入病历记录表数据 /// </summary> /// <returns></returns> private bool hasInsertedMedicalRecords(Web_MedicalRecords MedicalRecords, string strLcoalLSH, string strLocalCS, string strLocalCLBH, ref string strLocalRecordId) { bool result = false; try { MedicalRecords.CLBH = strLocalCLBH; MedicalRecords.LSH = strLcoalLSH; MedicalRecords.CS = strLocalCS; //20151215 修改人:朱星汉 修改内容:TIMPLATEFLAG,MEDICALTYPE字段不能为空,默认值为0 if (MedicalRecords.TIMPLATEFLAG == null || MedicalRecords.TIMPLATEFLAG == "") { MedicalRecords.TIMPLATEFLAG = "0"; } if (MedicalRecords.MEDICALTYPE == null || MedicalRecords.MEDICALTYPE == "") { MedicalRecords.MEDICALTYPE = "0"; } ParameterSql parSql = SyncDataSql.GetAddMedicalRecordsSql(MedicalRecords); int i = DB120Help.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i <= 0) { LogHelper.WriteLog("病历记录数据更新本地库失败流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); } else { //插入成功,则获取当前的ID string Sql = "select max(ID) from web_medicalrecords where lsh='" + strLcoalLSH + "' and cs='" + strLocalCS + "' and clbh ='" + strLocalCLBH + "'"; object obj = DB120Help.GetSingle(Sql); strLocalRecordId = obj.ToString(); LogHelper.WriteLog("病历记录数据更新本地库成功本地ID:" + strLocalRecordId + " 流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); result = true; } } catch (Exception ex) { LOG.LogHelper.WriteLog("", ex); } return(result); }
/// <summary> /// 同步病历记录 /// </summary> /// <param name="strMsg"></param> public void HandleWeb_MedicalRecordsData(string message) { try { Web_MedicalRecords item = (Web_MedicalRecords)XmlUtil.Deserialize(typeof(Web_MedicalRecords), message); IDataExchangeDataAccess Data = DataAccess.DataExchangeDataAccess(); Data.Web_MedicalRecordsRespExchange += new EventHandler <DataExchangeRespEventArgs>(Data_Web_MedicalRecordsRespExchange); List <Web_MedicalRecords> DataList = new List <Web_MedicalRecords>(); DataList.Add(item); Data.InsertWeb_MedicalRecords(DataList, ServerClient.UnitXZBM); //同步联网调度单的患者信息到市120本地库中 ISyncData syncData = LocalDataAccess.SyncDataAccess(); syncData.Web_MedicalRecordsRespExchange += new EventHandler <SyncDataRespEventArgs>(Data_Web_MedicalRecordsRespSync); syncData.SyncWeb_MedicalRecords(item, ServerClient.UnitCode); } catch (Exception ex) { LogHelper.WriteLog("", ex); } }
/// <summary> ///添加病历记录 /// </summary> public static ParameterSql GetAddMedicalRecordsSql(Web_MedicalRecords Data) { ParameterSql sqlpar = new ParameterSql(); sqlpar.StrSql = "insert into web_medicalrecords(JJYXM,SXB,APGAR,TAPGAR,MEDICALTYPE,BRGJ,BQSCTP,ZZLB,ZZ,YY1,BS,JJCS,HZZJ,HZBZ,LSH,CS,CLBH,SSDWMC,ZBCH,BRXM,BRNL,BRXB,WJDD,SWDD,BZ,DJR,DJRQ,BRID,XBS,GQXGS,ZCYZD,YWGMS,T,P,BP,ZTK,CBYX,XT,XYBHD,XDTYX,XDJHYX,BRMZ,BRZY,BRJG,BRGZDW,XG_FLAG,XG_YY,XG_SHR,XG_SJ,FLAG,R,ZBY,HJDH,WJDD_TJ,SWDD_TJ,HYZK,HR,YTK,QT,GCS,TI,ZDS,RZY,RFBYL,QTJC,SWZMBH,XDTYXFJ,XDJHYXFJ,TIMPLATENAME,TIMPLATEFLAG,JZYS,TGCS,TTI,TIMPLATEPY,TIMPLATEPARENTID,READER) values(:JJYXM,:SXB,:APGAR,:TAPGAR,:MEDICALTYPE,:BRGJ,:BQSCTP,:ZZLB,:ZZ,:YY1,:BS,:JJCS,:HZZJ,:HZBZ,:LSH,:CS,:CLBH,:SSDWMC,:ZBCH,:BRXM,:BRNL,:BRXB,:WJDD,:SWDD,:BZ,:DJR,:DJRQ,:BRID,:XBS,:GQXGS,:ZCYZD,:YWGMS,:T,:P,:BP,:ZTK,:CBYX,:XT,:XYBHD,:XDTYX,:XDJHYX,:BRMZ,:BRZY,:BRJG,:BRGZDW,:XG_FLAG,:XG_YY,:XG_SHR,:XG_SJ,:FLAG,:R,:ZBY,:HJDH,:WJDD_TJ,:SWDD_TJ,:HYZK,:HR,:YTK,:QT,:GCS,:TI,:ZDS,:RZY,:RFBYL,:QTJC,:SWZMBH,:XDTYXFJ,:XDJHYXFJ,:TIMPLATENAME,:TIMPLATEFLAG,:JZYS,:TGCS,:TTI,:TIMPLATEPY,:TIMPLATEPARENTID,:READER)"; OracleParameter[] par = { //JJYXM,SXB,APGAR,TAPGAR,MEDICALTYPE,BRGJ,BQSCTP,ZZLB,ZZ,YY1,BS, new OracleParameter(":JJYXM", GetString(Data.JJYXM)), new OracleParameter(":SXB", GetString(Data.SXB)), new OracleParameter(":APGAR", GetNumber(Data.APGAR)), new OracleParameter(":TAPGAR", GetString(Data.TAPGAR)), new OracleParameter(":MEDICALTYPE", GetNumber(Data.MEDICALTYPE)), new OracleParameter(":BRGJ", GetString(Data.BRGJ)), new OracleParameter(":BQSCTP", GetString(Data.BQSCTP)), new OracleParameter(":ZZLB", GetString(Data.ZZLB)), new OracleParameter(":ZZ", GetString(Data.ZZ)), new OracleParameter(":YY1", GetString(Data.YY1)), new OracleParameter(":BS", GetString(Data.BS)), //JJCS,HZZJ,HZBZ,ID,LSH,CS,CLBH,SSDWMC,ZBCH,BRXM,BRNL,BRXB,WJDD, new OracleParameter(":JJCS", GetString(Data.JJCS)), new OracleParameter(":HZZJ", GetString(Data.HZZJ)), new OracleParameter(":HZBZ", GetString(Data.HZBZ)), // new OracleParameter(":ID",GetNumber(Data.ID)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CS", GetString(Data.CS)), new OracleParameter(":CLBH", GetString(Data.CLBH)), new OracleParameter(":SSDWMC", GetString(Data.SSDWMC)), new OracleParameter(":ZBCH", GetString(Data.ZBCH)), new OracleParameter(":BRXM", GetString(Data.BRXM)), new OracleParameter(":BRNL", GetString(Data.BRNL)), new OracleParameter(":BRXB", GetString(Data.BRXB)), new OracleParameter(":WJDD", GetString(Data.WJDD)), //SWDD,BZ,DJR,DJRQ,BRID,XBS,GQXGS,ZCYZD,YWGMS,T,P,BP,ZTK,CBYX,XT, new OracleParameter(":SWDD", GetString(Data.SWDD)), new OracleParameter(":BZ", GetString(Data.BZ)), new OracleParameter(":DJR", GetString(Data.DJR)), new OracleParameter(":DJRQ", GetDateTime(Data.DJRQ)), new OracleParameter(":BRID", GetString(Data.BRID)), new OracleParameter(":XBS", GetString(Data.XBS)), new OracleParameter(":GQXGS", GetString(Data.GQXGS)), new OracleParameter(":ZCYZD", GetString(Data.ZCYZD)), new OracleParameter(":YWGMS", GetString(Data.YWGMS)), new OracleParameter(":T", GetString(Data.T)), new OracleParameter(":P", GetString(Data.P)), new OracleParameter(":BP", GetString(Data.BP)), new OracleParameter(":ZTK", GetString(Data.ZTK)), new OracleParameter(":CBYX", GetString(Data.CBYX)), new OracleParameter(":XT", GetString(Data.XT)), //XYBHD,XDTYX,XDJHYX,BRMZ,BRZY,BRJG,BRGZDW,XG_FLAG,XG_YY,XG_SHR,XG_SJ, new OracleParameter(":XYBHD", GetString(Data.XYBHD)), new OracleParameter(":XDTYX", GetString(Data.XDTYX)), new OracleParameter(":XDJHYX", GetString(Data.XDJHYX)), new OracleParameter(":BRMZ", GetString(Data.BRMZ)), new OracleParameter(":BRZY", GetString(Data.BRZY)), new OracleParameter(":BRJG", GetString(Data.BRJG)), new OracleParameter(":BRGZDW", GetString(Data.BRGZDW)), new OracleParameter(":XG_FLAG", GetString(Data.XG_FLAG)), new OracleParameter(":XG_YY", GetString(Data.XG_YY)), new OracleParameter(":XG_SHR", GetString(Data.XG_SHR)), new OracleParameter(":XG_SJ", GetDateTime(Data.XG_SJ)), //FLAG,R,ZBY,HJDH,WJDD_TJ,SWDD_TJ,HYZK,HR,YTK,QT,GCS,TI,ZDS,RZY, new OracleParameter(":FLAG", GetString(Data.FLAG)), new OracleParameter(":R", GetString(Data.R)), new OracleParameter(":ZBY", GetString(Data.ZBY)), new OracleParameter(":HJDH", GetString(Data.HJDH)), new OracleParameter(":WJDD_TJ", GetString(Data.WJDD_TJ)), new OracleParameter(":SWDD_TJ", GetString(Data.SWDD_TJ)), new OracleParameter(":HYZK", GetString(Data.HYZK)), new OracleParameter(":HR", GetString(Data.HR)), new OracleParameter(":YTK", GetString(Data.YTK)), new OracleParameter(":QT", GetString(Data.QT)), new OracleParameter(":GCS", GetNumber(Data.GCS)), new OracleParameter(":TI", GetNumber(Data.TI)), new OracleParameter(":ZDS", GetString(Data.ZDS)), new OracleParameter(":RZY", GetString(Data.RZY)), //RFBYL,QTJC,SWZMBH,XDTYXFJ,XDJHYXFJ,TIMPLATENAME,TIMPLATEFLAG,JZYS, new OracleParameter(":RFBYL", GetString(Data.RFBYL)), new OracleParameter(":QTJC", GetString(Data.QTJC)), new OracleParameter(":SWZMBH", GetString(Data.SWZMBH)), new OracleParameter(":XDTYXFJ", GetString(Data.XDTYXFJ)), new OracleParameter(":XDJHYXFJ", GetString(Data.XDJHYXFJ)), new OracleParameter(":TIMPLATENAME", GetString(Data.TIMPLATENAME)), new OracleParameter(":TIMPLATEFLAG", GetNumber(Data.TIMPLATEFLAG)), new OracleParameter(":JZYS", GetString(Data.JZYS)), //TGCS,TTI,TIMPLATEPY,TIMPLATEPARENTID,READER,XZBM new OracleParameter(":TGCS", GetString(Data.TGCS)), new OracleParameter(":TTI", GetString(Data.TTI)), new OracleParameter(":TIMPLATEPY", GetString(Data.TIMPLATEPY)), new OracleParameter(":TIMPLATEPARENTID", GetString(Data.TIMPLATEPARENTID)), new OracleParameter(":READER", GetNumber(Data.READER)), }; sqlpar.OrclPar = par; return(sqlpar); }
/// <summary> /// 更新病历记录 /// </summary> public static ParameterSql GetUpadateMedicalRecordsSql(Web_MedicalRecords Data) { ParameterSql sqlpar = new ParameterSql(); sqlpar.StrSql = "update web_medicalrecords set JJYXM=:JJYXM,SXB=:SXB,APGAR=:APGAR,TAPGAR=:TAPGAR,MEDICALTYPE=:MEDICALTYPE,BRGJ=:BRGJ,BQSCTP=:BQSCTP,ZZLB=:ZZLB,ZZ=:ZZ,YY1=:YY1,BS=:BS,JJCS=:JJCS,HZZJ=:HZZJ,HZBZ=:HZBZ,SSDWMC=:SSDWMC,ZBCH=:ZBCH,BRXM=:BRXM,BRNL=:BRNL,BRXB=:BRXB,WJDD=:WJDD,SWDD=:SWDD,BZ=:BZ,DJR=:DJR,DJRQ=:DJRQ,BRID=:BRID,XBS=:XBS,GQXGS=:GQXGS,ZCYZD=:ZCYZD,YWGMS=:YWGMS,T=:T,P=:P,BP=:BP,ZTK=:ZTK,CBYX=:CBYX,XT=:XT,XYBHD=:XYBHD,XDTYX=:XDTYX,XDJHYX=:XDJHYX,BRMZ=:BRMZ,BRZY=:BRZY,BRJG=:BRJG,BRGZDW=:BRGZDW,XG_FLAG=:XG_FLAG,XG_YY=:XG_YY,XG_SHR=:XG_SHR,XG_SJ=:XG_SJ,FLAG=:FLAG,R=:R,ZBY=:ZBY,HJDH=:HJDH,WJDD_TJ=:WJDD_TJ,SWDD_TJ=:SWDD_TJ,HYZK=:HYZK,HR=:HR,YTK=:YTK,QT=:QT,GCS=:GCS,TI=:TI,ZDS=:ZDS,RZY=:RZY,RFBYL=:RFBYL,QTJC=:QTJC,SWZMBH=:SWZMBH,XDTYXFJ=:XDTYXFJ,XDJHYXFJ=:XDJHYXFJ,TIMPLATENAME=:TIMPLATENAME,TIMPLATEFLAG=:TIMPLATEFLAG,JZYS=:JZYS,TGCS=:TGCS,TTI=:TTI,TIMPLATEPY=:TIMPLATEPY,TIMPLATEPARENTID=:TIMPLATEPARENTID,READER=:READER where ID=:ID and LSH=:LSH and CS=:CS and CLBH=:CLBH"; OracleParameter[] par = { //JJYXM,SXB,APGAR,TAPGAR,MEDICALTYPE,BRGJ,BQSCTP,ZZLB,ZZ,YY1,BS, new OracleParameter(":JJYXM", GetString(Data.JJYXM)), new OracleParameter(":SXB", GetString(Data.SXB)), new OracleParameter(":APGAR", GetNumber(Data.APGAR)), new OracleParameter(":TAPGAR", GetString(Data.TAPGAR)), new OracleParameter(":MEDICALTYPE", GetNumber(Data.MEDICALTYPE)), new OracleParameter(":BRGJ", GetString(Data.BRGJ)), new OracleParameter(":BQSCTP", GetString(Data.BQSCTP)), new OracleParameter(":ZZLB", GetString(Data.ZZLB)), new OracleParameter(":ZZ", GetString(Data.ZZ)), new OracleParameter(":YY1", GetString(Data.YY1)), new OracleParameter(":BS", GetString(Data.BS)), //JJCS,HZZJ,HZBZ,ID,LSH,CS,CLBH,SSDWMC,ZBCH,BRXM,BRNL,BRXB,WJDD, new OracleParameter(":JJCS", GetString(Data.JJCS)), new OracleParameter(":HZZJ", GetString(Data.HZZJ)), new OracleParameter(":HZBZ", GetString(Data.HZBZ)), new OracleParameter(":ID", GetNumber(Data.ID)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CS", GetString(Data.CS)), new OracleParameter(":CLBH", GetString(Data.CLBH)), new OracleParameter(":SSDWMC", GetString(Data.SSDWMC)), new OracleParameter(":ZBCH", GetString(Data.ZBCH)), new OracleParameter(":BRXM", GetString(Data.BRXM)), new OracleParameter(":BRNL", GetString(Data.BRNL)), new OracleParameter(":BRXB", GetString(Data.BRXB)), new OracleParameter(":WJDD", GetString(Data.WJDD)), //SWDD,BZ,DJR,DJRQ,BRID,XBS,GQXGS,ZCYZD,YWGMS,T,P,BP,ZTK,CBYX,XT, new OracleParameter(":SWDD", GetString(Data.SWDD)), new OracleParameter(":BZ", GetString(Data.BZ)), new OracleParameter(":DJR", GetString(Data.DJR)), new OracleParameter(":DJRQ", GetDateTime(Data.DJRQ)), new OracleParameter(":BRID", GetString(Data.BRID)), new OracleParameter(":XBS", GetString(Data.XBS)), new OracleParameter(":GQXGS", GetString(Data.GQXGS)), new OracleParameter(":ZCYZD", GetString(Data.ZCYZD)), new OracleParameter(":YWGMS", GetString(Data.YWGMS)), new OracleParameter(":T", GetString(Data.T)), new OracleParameter(":P", GetString(Data.P)), new OracleParameter(":BP", GetString(Data.BP)), new OracleParameter(":ZTK", GetString(Data.ZTK)), new OracleParameter(":CBYX", GetString(Data.CBYX)), new OracleParameter(":XT", GetString(Data.XT)), //XYBHD,XDTYX,XDJHYX,BRMZ,BRZY,BRJG,BRGZDW,XG_FLAG,XG_YY,XG_SHR,XG_SJ, new OracleParameter(":XYBHD", GetString(Data.XYBHD)), new OracleParameter(":XDTYX", GetString(Data.XDTYX)), new OracleParameter(":XDJHYX", GetString(Data.XDJHYX)), new OracleParameter(":BRMZ", GetString(Data.BRMZ)), new OracleParameter(":BRZY", GetString(Data.BRZY)), new OracleParameter(":BRJG", GetString(Data.BRJG)), new OracleParameter(":BRGZDW", GetString(Data.BRGZDW)), new OracleParameter(":XG_FLAG", GetString(Data.XG_FLAG)), new OracleParameter(":XG_YY", GetString(Data.XG_YY)), new OracleParameter(":XG_SHR", GetString(Data.XG_SHR)), new OracleParameter(":XG_SJ", GetDateTime(Data.XG_SJ)), //FLAG,R,ZBY,HJDH,WJDD_TJ,SWDD_TJ,HYZK,HR,YTK,QT,GCS,TI,ZDS,RZY, new OracleParameter(":FLAG", GetString(Data.FLAG)), new OracleParameter(":R", GetString(Data.R)), new OracleParameter(":ZBY", GetString(Data.ZBY)), new OracleParameter(":HJDH", GetString(Data.HJDH)), new OracleParameter(":WJDD_TJ", GetString(Data.WJDD_TJ)), new OracleParameter(":SWDD_TJ", GetString(Data.SWDD_TJ)), new OracleParameter(":HYZK", GetString(Data.HYZK)), new OracleParameter(":HR", GetString(Data.HR)), new OracleParameter(":YTK", GetString(Data.YTK)), new OracleParameter(":QT", GetString(Data.QT)), new OracleParameter(":GCS", GetNumber(Data.GCS)), new OracleParameter(":TI", GetNumber(Data.TI)), new OracleParameter(":ZDS", GetString(Data.ZDS)), new OracleParameter(":RZY", GetString(Data.RZY)), //RFBYL,QTJC,SWZMBH,XDTYXFJ,XDJHYXFJ,TIMPLATENAME,TIMPLATEFLAG,JZYS, new OracleParameter(":RFBYL", GetString(Data.RFBYL)), new OracleParameter(":QTJC", GetString(Data.QTJC)), new OracleParameter(":SWZMBH", GetString(Data.SWZMBH)), new OracleParameter(":XDTYXFJ", GetString(Data.XDTYXFJ)), new OracleParameter(":XDJHYXFJ", GetString(Data.XDJHYXFJ)), new OracleParameter(":TIMPLATENAME", GetString(Data.TIMPLATENAME)), new OracleParameter(":TIMPLATEFLAG", GetNumber(Data.TIMPLATEFLAG)), new OracleParameter(":JZYS", GetString(Data.JZYS)), //TGCS,TTI,TIMPLATEPY,TIMPLATEPARENTID,READER,XZBM new OracleParameter(":TGCS", GetString(Data.TGCS)), new OracleParameter(":TTI", GetString(Data.TTI)), new OracleParameter(":TIMPLATEPY", GetString(Data.TIMPLATEPY)), new OracleParameter(":TIMPLATEPARENTID", GetString(Data.TIMPLATEPARENTID)), new OracleParameter(":READER", GetNumber(Data.READER)), }; sqlpar.OrclPar = par; return(sqlpar); }
/// <summary> /// 同步病历记录 /// </summary> public void SyncWeb_MedicalRecords(Web_MedicalRecords MedicalRecords, string UnitCode) { try { string strLcoalLSH = ""; string strLocalCS = ""; string strLocalCLBH = ""; string strLocalRecordId = ""; string strTargetLSH = MedicalRecords.LSH; string strTargetCS = MedicalRecords.CS; string strTargetCLBH = MedicalRecords.CLBH; string strTargetRecordId = MedicalRecords.ID; if (IsLWDD(MedicalRecords.LSH, UnitCode, ref strLcoalLSH)) { //需要添加一条虚拟出车记录 if (!HasVehicleMatchRecord(MedicalRecords.LSH, MedicalRecords.CLBH, MedicalRecords.CS, UnitCode, ref strLocalCS, ref strLocalCLBH)) { //如果还未有出车记录的话不再虚拟,不插入等待重新插入 LogHelper.WriteLog("SyncWeb_MedicalRecords无出车记录,不插入患者信息。本地流水号:" + strLcoalLSH + " ID:" + strTargetRecordId + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); return; ////出车信息尚未关联,需先往出车信息表,生成一条记录 //DispatchVehicleData Dispatchdata = new DispatchVehicleData(); //if (hasInsertedDispatchVehicleRecord(Dispatchdata, UnitCode, strLcoalLSH, ref strLocalCLBH, ref strLocalCS)) //{ // //主键关联 // string sql = "insert into LWCLTBDYB (locallsh,localCS,localCLBH,TargetLSH,TargetCS,TargetCLBH,TargetDWBH) values ('" // + strLcoalLSH + "','" + strLocalCS + "','" + strLocalCLBH + "','" // + strTargetLSH + "','" + strTargetCS + "','" + strTargetCLBH + "','" + UnitCode + "')"; // int i = DB120Help.ExecuteSql(sql); // if (i > 0) // { // LogHelper.WriteLog("车辆信息表主键关联成功本地流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); // } // else // { // LogHelper.WriteLog("车辆信息表主键关联失败本地流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); // } //} //else //{ // return; //} } if (hasMedicalMatchRecords(strTargetRecordId, UnitCode, strTargetLSH, ref strLocalRecordId)) { MedicalRecords.ID = strLocalRecordId; MedicalRecords.CLBH = strLocalCLBH; MedicalRecords.LSH = strLcoalLSH; MedicalRecords.CS = strLocalCS; ParameterSql parSql = SyncDataSql.GetUpadateMedicalRecordsSql(MedicalRecords); int i = DB120Help.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i == 0) { LogHelper.WriteLog("病历记录数据更新本地库失败本地ID:" + MedicalRecords.ID + " 流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); return; } Web_MedicalRecordsResp Data = new Web_MedicalRecordsResp(); Data.CommandID = MedicalRecords.CommandID + "Resp"; Data.ID = strTargetRecordId; Data.Result = 1; ExchangeDataResp(Data); } //需要添加患者记录 else { if (hasInsertedMedicalRecords(MedicalRecords, strLcoalLSH, strLocalCS, strLocalCLBH, ref strLocalRecordId)) { //将患者信息关联起来 string Sql = "insert into LWBLTBDYB (locallsh,localRecordId,TargetLSH,TargetRecordId,TargetDWBH) values (" + strLcoalLSH + ",'" + strLocalRecordId + "','" + strTargetLSH + "','" + strTargetRecordId + "','" + UnitCode + "')"; int i = DB120Help.ExecuteSql(Sql); if (i > 0) { LogHelper.WriteLog("患者病历记录主键关联成功"); } else { LogHelper.WriteLog("患者病历记录主键关联失败"); } Web_MedicalRecordsResp Data = new Web_MedicalRecordsResp(); Data.CommandID = MedicalRecords.CommandID + "Resp"; Data.ID = strTargetRecordId; Data.Result = 1; ExchangeDataResp(Data); } } } else { Web_MedicalRecordsResp Data = new Web_MedicalRecordsResp(); Data.CommandID = MedicalRecords.CommandID + "Resp"; Data.ID = strTargetRecordId; Data.Result = 1; ExchangeDataResp(Data); } } catch (Exception ex) { Web_MedicalRecordsResp Data = new Web_MedicalRecordsResp(); Data.CommandID = MedicalRecords.CommandID + "Resp"; Data.ID = MedicalRecords.ID; Data.Result = 0; Data.FailtureReason = ex.Message; ExchangeDataResp(Data); LogHelper.WriteLog("", ex); } }