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