//20151216修改人:朱星汉 修改内容:添加病历关系记录删除表的上传
/// <summary>
/// 病历关系记录删除表数据
/// </summary>
/// <param name="strMsg"></param>
public void HandleLWBLGXTBDELBData(string message)
{
try
{
LWBLGXTBDELB item = (LWBLGXTBDELB)XmlUtil.Deserialize(typeof(LWBLGXTBDELB), message);
IDataExchangeDataAccess Data = DataAccess.DataExchangeDataAccess();
Data.LWBLGXTBDELBRespExchange += new EventHandler <DataExchangeRespEventArgs>(Data_LWBLGXTBDELBRespExchange);
List <LWBLGXTBDELB> DataList = new List <LWBLGXTBDELB>();
DataList.Add(item);
Data.DeleteWeb_MedicalStatistics(DataList, ServerClient.UnitXZBM);
ISyncData syncData = LocalDataAccess.SyncDataAccess();
syncData.SyncLWBLGXTBDELB(item, ServerClient.UnitCode);
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
//20151216修改人:朱星汉 修改内容:添加病历关系记录删除表的上传
/// <summary>
/// 病历关系记录删除数据
/// </summary>
public void SyncLWBLGXTBDELB(LWBLGXTBDELB lwblgxtbdel, string UnitCode)
{
string strLocalStatisticsId = "";
string strTargetStatisticsId = lwblgxtbdel.ID;
string strsql = "select localStatisticsID from LWBLGXTBDYB where Targetdwbh= '" + UnitCode + "' and TargetStatisticsID = " + strTargetStatisticsId;
object obj = DB120Help.GetSingle(strsql);
if (obj != null)
{
strLocalStatisticsId = obj.ToString();
strsql = "delete from web_medicalstatistics where id=" + strLocalStatisticsId + " and medicalrecordsid in (select localrecordid from lwbltbdyb)";
int i = DB120Help.ExecuteSql(strsql);
if (i > 0)
{
LogHelper.WriteLog("病历关联信息删除成功");
strsql = "delete from lwblgxtbdyb where localStatisticsID =" + strLocalStatisticsId + " and Targetdwbh='" + UnitCode + "'";
i = DB120Help.ExecuteSql(strsql);
if (i > 0)
{
LogHelper.WriteLog("病历关联信息对应记录删除成功");
}
}
}
}
