public void insertNewLSVehInfo(List <VEHICLEHISTROYSTATE> aci) { if (aci.Count > 0) { foreach (VEHICLEHISTROYSTATE item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }
/// <summary> /// 更新出车信息数据 /// </summary> /// <param name="Data"></param> /// <param name="VehicleNo"></param> /// <returns></returns> public static ParameterSql GetUpadateCCXXBSql(DispatchVehicleData Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加车辆信息状态字段 sqlpar.StrSql = "update CCXXB set CCLX=:CCLX,SJ=:SJ,SCYS=:SCYS,SCHS=:SCHS,SCDJG=:SCDJG,PCSJ=:PCSJ,CCDD=:CCDD,CCSJ=:CCSJ,DDXCSJ=:DDXCSJ,SCSJ=:SCSJ,DDSJ=:DDSJ,WCSJ=:WCSJ,FZSJ=:FZSJ,CCYS=:CCYS,LTYS=:LTYS,XCYS=:XCYS,ZTYS=:ZTYS,ZHS=:ZHS,XSLC=:XSLC,TSSJ=:TSSJ,TSYY=:TSYY,TSSJSJ=:TSSJSJ,CLID=:CLID,SDXXSJ=:SDXXSJ,SWYY=:SWYY,ZT=:ZT,CCCC=:CCCC where LSH=:LSH and CS=:CS and CLBH=:CLBH "; OracleParameter[] par = { new OracleParameter(":LSH", GetString(Data.DealRecordID)), new OracleParameter(":CLBH", GetString(Data.VehicleCode)), new OracleParameter(":CS", GetString(Data.Times)), new OracleParameter(":CCLX", GetString(Data.DispatchVehicleType)), new OracleParameter(":SJ", GetString(Data.Driver)), new OracleParameter(":SCYS", GetString(Data.Doctor)), new OracleParameter(":SCHS", GetString(Data.Nurse)), new OracleParameter(":SCDJG", GetString(Data.StretcherPerson)), new OracleParameter(":PCSJ", GetDateTime(Data.DispatchVehicleTime)), new OracleParameter(":CCDD", GetString(Data.StartoffAddress)), new OracleParameter(":CCSJ", GetDateTime(Data.StartoffTime)), new OracleParameter(":DDXCSJ", GetDateTime(Data.ArriveSceneTime)), new OracleParameter(":SCSJ", GetDateTime(Data.GetInVehicleTime)), new OracleParameter(":DDSJ", GetDateTime(Data.ArriveDestinationTime)), new OracleParameter(":WCSJ", GetDateTime(Data.FinishTaskTime)), new OracleParameter(":FZSJ", GetDateTime(Data.ReturnParkTime)), new OracleParameter(":CCYS", GetNumber(Data.StartoffUseTime)), new OracleParameter(":LTYS", GetNumber(Data.ArriveSceneUseTime)), new OracleParameter(":XCYS", GetNumber(Data.SceneUseTime)), new OracleParameter(":ZTYS", GetNumber(Data.AarriveDestinationUseTime)), new OracleParameter(":ZHS", GetNumber(Data.TotalUseTime)), new OracleParameter(":XSLC", GetNumber(Data.SteerMileage)), new OracleParameter(":TSSJ", GetString(Data.SpecialEvent)), new OracleParameter(":TSYY", GetString(Data.SpecialReason)), new OracleParameter(":TSSJSJ", GetDateTime(Data.SpecialEventTime)), new OracleParameter(":CLID", GetString(Data.VehicleID)), new OracleParameter(":SDXXSJ", GetDateTime(Data.ReceiveTaskTime)), new OracleParameter(":SWYY", GetString(Data.AcceptHospital)), new OracleParameter(":ZT", GetString(Data.VehicleZT)), //20160106 修改人:朱星汉 修改内容:添加出车车次(CCCC)字段 new OracleParameter(":CCCC", GetString(Data.VehicleCCCC)), }; sqlpar.OrclPar = par; return(sqlpar); }
/// <summary> ///病历填写项目与值对应关系数据 /// </summary> public static ParameterSql GetAddMedicalStatisticsSql(Web_MedicalStatistics Data) { ParameterSql sqlpar = new ParameterSql(); sqlpar.StrSql = "insert into web_medicalstatistics(CONTROLID,MEDICALRECORDSID,CONTROLVALUE,CONTROLPARENTID)values(:CONTROLID,:MEDICALRECORDSID,:CONTROLVALUE,:CONTROLPARENTID)"; OracleParameter[] par = { //new OracleParameter(":ID",GetNumber(Data.ID)), new OracleParameter(":CONTROLID", GetString(Data.CONTROLID)), new OracleParameter(":MEDICALRECORDSID", GetNumber(Data.MEDICALRECORDSID)), new OracleParameter(":CONTROLVALUE", GetNumber(Data.CONTROLVALUE)), new OracleParameter(":CONTROLPARENTID", GetString(Data.CONTROLPARENTID)), }; sqlpar.OrclPar = par; return(sqlpar); }
public static ParameterSql GetDataExchangeDataAccessSql(ALARM_EVENT_INFO Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "insert into ALARM_EVENT_INFO(DATATIME,CALLCOUNT,DEALCOUNT,DISPATCHCOUNT,PAIENTCOUNT,LASTTIME,READFLAG)values(:DATATIME,:CALLCOUNT,:DEALCOUNT,:DISPATCHCOUNT,:PAIENTCOUNT,:LASTTIME,:READFLAG)"; OracleParameter[] par = { new OracleParameter(":DATATIME", GetString(Data.DATATIME)), new OracleParameter(":CALLCOUNT", Data.CALLCOUNT), new OracleParameter(":DEALCOUNT", Data.DEALCOUNT), new OracleParameter(":DISPATCHCOUNT", Data.DISPATCHCOUNT), new OracleParameter(":PAIENTCOUNT", Data.PAIENTCOUNT), new OracleParameter(":LASTTIME", GetDateTime(Data.LASTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }
/// <summary> /// 病历填写项目与值对应关系数据 /// </summary> public static ParameterSql GetUpadateMedicalStatisticsSql(Web_MedicalStatistics Data) { ParameterSql sqlpar = new ParameterSql(); sqlpar.StrSql = "update web_medicalstatistics set CONTROLID=:CONTROLID,CONTROLVALUE=:CONTROLVALUE,CONTROLPARENTID=:CONTROLPARENTID where ID=:ID and MEDICALRECORDSID=:MEDICALRECORDSID"; OracleParameter[] par = { new OracleParameter(":ID", GetNumber(Data.ID)), new OracleParameter(":CONTROLID", GetString(Data.CONTROLID)), new OracleParameter(":MEDICALRECORDSID", GetNumber(Data.MEDICALRECORDSID)), new OracleParameter(":CONTROLVALUE", GetNumber(Data.CONTROLVALUE)), new OracleParameter(":CONTROLPARENTID", GetString(Data.CONTROLPARENTID)), }; sqlpar.OrclPar = par; return(sqlpar); }
public void insertNewEventInfo(List <ALARM_EVENT_INFO> aci) { if (aci.Count > 0) { foreach (ALARM_EVENT_INFO item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); bool Have_ALARM_EVENT = SelSql.GetBoolHave_ALARM_EVENT(item.DATATIME); LogHelper.WriteLog("ALARM_EVENT_INFO开始" + Have_ALARM_EVENT + "," + item.DATATIME); if (Have_ALARM_EVENT == true) { ParameterSql parSql = DataExchangeDataAccessUpdateSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("ALARM_EVENT_INFO更新数据成功。"); } else { LogHelper.WriteLog("ALARM_EVENT_INFO更新数据失败。"); } } else { ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("ALARM_EVENT_INFO插入数据成功。"); } else { LogHelper.WriteLog("ALARM_EVENT_INFO插入数据成功。"); } } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }
public void insertNewSSVehInfo(List <VEHICLEREALSTATUS> aci) { if (aci.Count > 0) { foreach (VEHICLEREALSTATUS item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); bool HaveVeh = SelSql.GetBoolHaveVeh(item.VEHICLECARD); LogHelper.WriteLog("VEHICLEREALSTATUS开始" + HaveVeh + "," + item.VEHICLECARD); if (HaveVeh == true) { ParameterSql parSql = DataExchangeDataAccessUpdateSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS更新数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS更新数据失败。"); } } else { ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEREALSTATUS Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "insert into VEHICLEREALSTATUS(VEHICLECARD,VEHICLENAME,VEHICLEDEPARTMENT,STATUS,JD,WD,LASTTIME,READFLAG)values(:VEHICLECARD,:VEHICLENAME,:VEHICLEDEPARTMENT,:STATUS,:JD,:WD,:LASTTIME,:READFLAG)"; OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)), new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)), new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)), new OracleParameter(":STATUS", GetString(Data.STATUS)), new OracleParameter(":JD", Data.JD), new OracleParameter(":WD", Data.WD), new OracleParameter(":LASTTIME", GetDateTime(Data.LASTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEHISTROYSTATE Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "update VEHICLEHISTROYSTATE set VEHICLENAME:=VEHICLENAME,VEHICLEDEPARTMENT:=VEHICLEDEPARTMENT,LSH:=LSH,CCXH:=CCXH,JD:=JD,WD:=WD,REPORTTIME=:REPORTTIME,READFLAG=:READFLAG where VEHICLECARD=:VEHICLECARD"; OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)), new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)), new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CCXH", Data.CCXH), new OracleParameter(":JD", Data.JD), new OracleParameter(":WD", Data.WD), new OracleParameter(":REPORTTIME", GetDateTime(Data.REPORTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }
public static ParameterSql GetDataExchangeDataAccessSql(VEHICLEHISTROYSTATE Data) { ParameterSql sqlpar = new ParameterSql(); //20151210 修改人:朱星汉 修改内容:添加系统人员密码 sqlpar.StrSql = "insert into VEHICLEHISTROYSTATE(VEHICLECARD,VEHICLENAME,VEHICLEDEPARTMENT,LSH,CCXH,JD,WD,REPORTTIME,READFLAG)values(:VEHICLECARD,:VEHICLENAME,:VEHICLEDEPARTMENT,:LSH,:CCXH,:JD,:WD,:REPORTTIME,:READFLAG)"; OracleParameter[] par = { new OracleParameter(":VEHICLECARD", GetString(Data.VEHICLECARD)), new OracleParameter(":VEHICLENAME", GetString(Data.VEHICLENAME)), new OracleParameter(":VEHICLEDEPARTMENT", GetString(Data.VEHICLEDEPARTMENT)), new OracleParameter(":LSH", GetString(Data.LSH)), new OracleParameter(":CCXH", GetNumber(Data.CCXH == 0? "":Data.CCXH.ToString())), new OracleParameter(":JD", Data.JD), new OracleParameter(":WD", Data.WD), new OracleParameter(":REPORTTIME", GetDateTime(Data.REPORTTIME.ToString())), new OracleParameter(":READFLAG", Data.READFLAG), }; sqlpar.OrclPar = par; return(sqlpar); }
/// <summary> /// 是否已成功插入出车信息表数据 /// </summary> /// <param name="DispatchVehicle"></param> /// <param name="UnitCode"></param> /// <param name="strLcoalLSH"></param> /// <param name="strLocalCLBH"></param> /// <param name="strLocalCS"></param> /// <returns></returns> private bool hasInsertedDispatchVehicleRecord(DispatchVehicleData DispatchVehicle, string UnitCode, string strLcoalLSH, ref string strLocalCLBH, ref string strLocalCS) { bool result = false; try { //选取对应的虚拟车辆 string sql = "select clbh from (select clbh,0 as zt from clxxb where ssdw= (select DWMC from dwxxb where dwbh='" + UnitCode + "') and (clzt = '任务完成' or clzt='待命') union select clbh,1 as zt from clxxb where ssdw=(select DWMC from dwxxb where dwbh='" + UnitCode + "')and clzt<>'待命' and clzt<>'任务完成')a order by a.zt"; object obj = DB120Help.GetSingle(sql); if (obj != null) { strLocalCLBH = obj.ToString(); //在本地库选取对应的车次 sql = "select nvl(max(cs),'00') from ccxxb where lsh ='" + strLcoalLSH + "'"; obj = DB120Help.GetSingle(sql); strLocalCS = (int.Parse(obj.ToString()) + 1).ToString("00"); //将取出对应的本地流水号,车次,车辆编号已经本身的业务信息插入本地库,同时插入后将对应的主键在联网信息表中进行关联 DispatchVehicle.VehicleCode = strLocalCLBH; DispatchVehicle.DealRecordID = strLcoalLSH; DispatchVehicle.Times = strLocalCS; LogHelper.WriteLog("新增CCXXB,LSH:" + strLcoalLSH + ",CLBH:" + strLocalCLBH + ",CS:" + strLocalCS); ParameterSql parSql = SyncDataSql.GetAddCCXXBSql(DispatchVehicle); int i = DB120Help.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { result = true; } } else { LogHelper.WriteLog("本地库没有" + UnitCode + "的车辆"); } } catch (Exception ex) { LOG.LogHelper.WriteLog("", ex); } return(result); }
/// <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> 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); } }
/// <summary> /// 同步出车信息数据 /// </summary> public void SyncDispatchVehicleData(DispatchVehicleData DispatchVehicle, string UnitCode) { try { string strLcoalLSH = ""; string strTargetLSH = DispatchVehicle.DealRecordID; string strTargetCS = DispatchVehicle.Times; string strTargetCLBH = DispatchVehicle.VehicleCode; if (IsLWDD(DispatchVehicle.DealRecordID, UnitCode, ref strLcoalLSH)) { LogHelper.WriteLog("联网单需要更新CCXX,LSH:" + strLcoalLSH); CheckDispatchRecord(strLcoalLSH, DispatchVehicle.DispatchVehicleTime, UnitCode); CheckHJQY(strLcoalLSH, UnitCode); string strLocalCS = ""; string strLocalCLBH = ""; if (HasVehicleMatchRecord(DispatchVehicle.DealRecordID, DispatchVehicle.VehicleCode, DispatchVehicle.Times, UnitCode, ref strLocalCS, ref strLocalCLBH)) { LogHelper.WriteLog("进入HasVehicleMatchRecord=true,LSH:" + strLcoalLSH); string sql = "select * from ccxxb where lsh = '" + strLcoalLSH + "' and cs = '" + strLocalCS + "' and clbh = '" + strLocalCLBH + "'"; object obj = DB120Help.GetSingle(sql); //如果已经存在记录更新当前出车信息 if (obj != null) { DispatchVehicle.VehicleCode = strLocalCLBH; DispatchVehicle.DealRecordID = strLcoalLSH; DispatchVehicle.Times = strLocalCS; LogHelper.WriteLog("更新CCXXB,LSH:" + strLcoalLSH + ",CLBH:" + strLocalCLBH + ",CS:" + strLocalCS); ParameterSql parSql = SyncDataSql.GetUpadateCCXXBSql(DispatchVehicle); int i = DB120Help.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i == 0) { LogHelper.WriteLog("车辆信息数据更新本地库失败本地流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); } else //成功更新车辆信息表中的车辆状态 { sql = "update clxxb set clzt ='" + DispatchVehicle.VehicleZT + "' where clbh= '" + strLocalCLBH + "'"; i = DB120Help.ExecuteSql(sql); if (i != 0) { LogHelper.WriteLog("车辆状态更新成功 车辆编号:" + strLocalCLBH); } DispatchVehicleDataResp Data = new DispatchVehicleDataResp(); Data.CommandID = DispatchVehicle.CommandID + "Resp"; Data.DealRecordID = strTargetLSH; Data.VehicleCode = strTargetCLBH; Data.Times = strTargetCS; Data.Result = 1; ExchangeDataResp(Data); } } } //未在联网信息关联表关联主键 需要插入记录,同时虚拟该车的车辆 else { LogHelper.WriteLog("进入HasVehicleMatchRecord=false,LSH:" + strLcoalLSH); strTargetLSH = DispatchVehicle.DealRecordID; strTargetCS = DispatchVehicle.Times; strTargetCLBH = DispatchVehicle.VehicleCode; if (hasInsertedDispatchVehicleRecord(DispatchVehicle, UnitCode, strLcoalLSH, ref strLocalCLBH, ref strLocalCS)) { //成功更新车辆信息表中的车辆状态 string sql = "update clxxb set clzt ='" + DispatchVehicle.VehicleZT + "' where clbh= '" + strLocalCLBH + "'"; int i = DB120Help.ExecuteSql(sql); if (i != 0) { LogHelper.WriteLog("车辆状态更新成功 车辆编号:" + strLocalCLBH); } //主键关联 sql = "insert into LWCLTBDYB (locallsh,localCS,localCLBH,TargetLSH,TargetCS,TargetCLBH,TargetDWBH) values ('" + strLcoalLSH + "','" + strLocalCS + "','" + strLocalCLBH + "','" + strTargetLSH + "','" + strTargetCS + "','" + strTargetCLBH + "','" + UnitCode + "')"; i = DB120Help.ExecuteSql(sql); if (i > 0) { LogHelper.WriteLog("车辆信息表主键关联成功本地流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); } else { LogHelper.WriteLog("车辆信息表主键关联失败本地流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); } DispatchVehicleDataResp Data = new DispatchVehicleDataResp(); Data.CommandID = DispatchVehicle.CommandID + "Resp"; Data.DealRecordID = strTargetLSH; Data.VehicleCode = strTargetCLBH; Data.Times = strTargetCS; Data.Result = 1; ExchangeDataResp(Data); } } } //非联网单直接更新不需要重发消息 else { DispatchVehicleDataResp Data = new DispatchVehicleDataResp(); Data.CommandID = DispatchVehicle.CommandID + "Resp"; Data.DealRecordID = strTargetLSH; Data.VehicleCode = strTargetCLBH; Data.Times = strTargetCS; Data.Result = 1; ExchangeDataResp(Data); } } catch (Exception ex) { DispatchVehicleDataResp Data = new DispatchVehicleDataResp(); Data.CommandID = DispatchVehicle.CommandID + "Resp"; Data.DealRecordID = DispatchVehicle.DealRecordID; Data.VehicleCode = DispatchVehicle.VehicleCode; Data.Times = DispatchVehicle.Times; Data.Result = 0; Data.FailtureReason = ex.Message; ExchangeDataResp(Data); LogHelper.WriteLog("", ex); } }
/// <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 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 void SyncWeb_MedicalStatistics(Web_MedicalStatistics MedicalStatistics, string UnitCode) { try { string strLcoalLSH = ""; string strLocalCS = ""; string strLocalCLBH = ""; string strLocalRecordId = ""; string strLocalStatisticsId = ""; string strTargetLSH = MedicalStatistics.LSH; string strTargetCS = MedicalStatistics.CS; string strTargetCLBH = MedicalStatistics.CLBH; string strTargetStatisticsId = MedicalStatistics.ID; string strTargetRecordId = MedicalStatistics.MEDICALRECORDSID; if (IsLWDD(MedicalStatistics.LSH, UnitCode, ref strLcoalLSH)) { //如果不存在出车对应记录,需要添加一条虚拟出车记录 if (!HasVehicleMatchRecord(MedicalStatistics.LSH, MedicalStatistics.CLBH, MedicalStatistics.CS, UnitCode, ref strLocalCS, ref strLocalCLBH)) { //如果还未有出车记录的话不再虚拟,不插入等待重新插入 LogHelper.WriteLog("SyncWeb_MedicalStatistics无出车记录,不插入患者信息。本地流水号:" + 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)) { LogHelper.WriteLog("SyncWeb_MedicalStatistics无出车记录,不插入患者信息。本地流水号:" + strLcoalLSH + " ID:" + strTargetRecordId + " 关联的流水号:" + strTargetLSH + " 车次:" + strTargetCS + " 车辆编号:" + strTargetCLBH); return; ////需要添加患者记录 //Web_MedicalRecords MedicalRecords = new Web_MedicalRecords(); //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("患者病历记录主键关联失败"); // } //} //else //{ // return; //} } //是否存在病历项目-值对应数据 if (hasMedicalMatchStatistics(strTargetStatisticsId, UnitCode, strTargetLSH, ref strLocalStatisticsId)) { MedicalStatistics.ID = strLocalStatisticsId; MedicalStatistics.MEDICALRECORDSID = strLocalRecordId; MedicalStatistics.CLBH = strLocalCLBH; MedicalStatistics.LSH = strLcoalLSH; MedicalStatistics.CS = strLocalCS; ParameterSql parSql = SyncDataSql.GetUpadateMedicalStatisticsSql(MedicalStatistics); int i = DB120Help.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i == 0) { LogHelper.WriteLog("病历记录数据更新本地库失败本地ID:" + MedicalStatistics.ID + " 流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); } else { Web_MedicalStatisticsResp Data = new Web_MedicalStatisticsResp(); Data.CommandID = MedicalStatistics.CommandID + "Resp"; Data.ID = strTargetStatisticsId; Data.Result = 1; ExchangeDataResp(Data); } } //需要添加病历项目-值对应数据 else { MedicalStatistics.CLBH = strLocalCLBH; MedicalStatistics.LSH = strLcoalLSH; MedicalStatistics.CS = strLocalCS; MedicalStatistics.MEDICALRECORDSID = strLocalRecordId; ParameterSql parSql = SyncDataSql.GetAddMedicalStatisticsSql(MedicalStatistics); 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_medicalstatistics where MEDICALRECORDSID='" + strLocalRecordId + "'"; string Sql = "select max(ID) from web_medicalstatistics where MEDICALRECORDSID='" + strLocalRecordId + "' and CONTROLID = '" + MedicalStatistics.CONTROLID + "'"; object obj = DB120Help.GetSingle(Sql); strLocalStatisticsId = obj.ToString(); LogHelper.WriteLog("病历项目-值对应数据更新本地库成功本地ID:" + strLocalStatisticsId + " 流水号:" + strLcoalLSH + " 车次:" + strLocalCS + " 车辆编号:" + strLocalCLBH); //create table LWBLGXTBDYB //( // locallsh 本地流水号 // localStatisticsID 本地病历关系ID号 // TargetLSH 对方流水号 // TargetStatisticsID 对方病历关系ID号 // TargetDWBH 对方单位编号 // ) //将病历项目-值对应数据关联起来 Sql = "insert into LWBLGXTBDYB (locallsh,localStatisticsID,TargetLSH,TargetStatisticsID,TargetDWBH) values (" + strLcoalLSH + ",'" + strLocalStatisticsId + "','" + strTargetLSH + "','" + strTargetStatisticsId + "','" + UnitCode + "')"; i = DB120Help.ExecuteSql(Sql); if (i > 0) { LogHelper.WriteLog("病历项目-值对应数据主键关联成功"); } else { LogHelper.WriteLog("病历项目-值对应数据主键关联失败"); } Web_MedicalStatisticsResp Data = new Web_MedicalStatisticsResp(); Data.CommandID = MedicalStatistics.CommandID + "Resp"; Data.ID = strTargetStatisticsId; Data.Result = 1; ExchangeDataResp(Data); } } } else { Web_MedicalStatisticsResp Data = new Web_MedicalStatisticsResp(); Data.CommandID = MedicalStatistics.CommandID + "Resp"; Data.ID = strTargetStatisticsId; Data.Result = 1; ExchangeDataResp(Data); } } catch (Exception ex) { Web_MedicalStatisticsResp Data = new Web_MedicalStatisticsResp(); Data.CommandID = MedicalStatistics.CommandID + "Resp"; Data.ID = MedicalStatistics.ID; Data.Result = 0; Data.FailtureReason = ex.Message; ExchangeDataResp(Data); LogHelper.WriteLog("", ex); } }