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