//20160105修改人:朱星汉 修改内容:添加病历记录删除表的上传
/// <summary>
/// 病历记录删除数据
/// </summary>
public void SyncLWBLTBDELB(LWBLTBDELB lwbltbdel, string UnitCode)
{
string strLocalRecordId = "";
string strTargetRecordId = lwbltbdel.ID;
string strsql = "select localRecordID from LWBLTBDYB where Targetdwbh= '" + UnitCode + "' and TargetRecordID = " + strTargetRecordId;
object obj = DB120Help.GetSingle(strsql);
if (obj != null)
{
strLocalRecordId = obj.ToString();
strsql = "delete from web_medicalrecords where id=" + strLocalRecordId + " and lsh in (select locallsh from lwbltbdyb)";
int i = DB120Help.ExecuteSql(strsql);
if (i > 0)
{
LogHelper.WriteLog("病历信息删除成功");
strsql = "delete from web_medicalStatistics where medicalrecordsid=" + strLocalRecordId;
i = DB120Help.ExecuteSql(strsql);
if (i > 0)
{
LogHelper.WriteLog("删除病历信息同时删除statistic值");
}
strsql = "delete from lwbltbdyb where localRecordID =" + strLocalRecordId + " and Targetdwbh='" + UnitCode + "'";
i = DB120Help.ExecuteSql(strsql);
if (i > 0)
{
LogHelper.WriteLog("病历信息对应记录删除成功");
}
}
}
}
//20160105修改人:朱星汉 修改内容:添加病历记录删除表的上传
/// <summary>
/// 病历记录删除表数据
/// </summary>
/// <param name="strMsg"></param>
public void HandleLWBLTBDELBData(string message)
{
try
{
LWBLTBDELB item = (LWBLTBDELB)XmlUtil.Deserialize(typeof(LWBLTBDELB), message);
IDataExchangeDataAccess Data = DataAccess.DataExchangeDataAccess();
Data.LWBLTBDELBRespExchange += new EventHandler <DataExchangeRespEventArgs>(Data_LWBLTBDELBRespExchange);
List <LWBLTBDELB> DataList = new List <LWBLTBDELB>();
DataList.Add(item);
Data.DeleteWeb_MedicalRecords(DataList, ServerClient.UnitXZBM);
ISyncData syncData = LocalDataAccess.SyncDataAccess();
syncData.SyncLWBLTBDELB(item, ServerClient.UnitCode);
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
