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