/// <summary>
/// 获取传染病实例(vo)
/// </summary>
/// <param name="rptId"></param>
/// <returns></returns>
internal EntityRptContagion GetContagion(decimal rptId)
{
EntityRptContagion vo = new EntityRptContagion();
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
vo.rptId = rptId;
vo = EntityTools.ConvertToEntity <EntityRptContagion>(svc.SelectPk(vo));
EntityRptContagionData dataVo = new EntityRptContagionData();
dataVo.rptId = rptId;
dataVo = EntityTools.ConvertToEntity <EntityRptContagionData>(svc.SelectPk(dataVo));
vo.xmlData = dataVo.xmlData;
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(vo);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="vo"></param>
/// <param name="rptId"></param>
/// <returns></returns>
internal int SaveContagion(EntityRptContagion vo, string reqNo, out decimal rptId)
{
int affectRows = 0;
rptId = 0;
string Sql = string.Empty;
IDataParameter[] parm = null;
SqlHelper svc = null;
try
{
List <DacParm> lstParm = new List <DacParm>();
svc = new SqlHelper(EnumBiz.onlineDB);
EntityRptContagionData voData = new EntityRptContagionData();
if (vo.rptId <= 0) // new
{
rptId = svc.GetNextID(EntityTools.GetTableName(vo), EntityTools.GetFieldName(vo, EntityRptContagion.Columns.rptId));
vo.rptId = rptId;
lstParm.Add(svc.GetInsertParm(vo));
voData.rptId = rptId;
voData.xmlData = vo.xmlData;
lstParm.Add(svc.GetInsertParm(voData));
if (!string.IsNullOrEmpty(reqNo))
{
Sql = @"update rptContagion set reques_no = ? where rptId = ?";
parm = svc.CreateParm(2);
parm[0].Value = reqNo;
parm[1].Value = rptId;
lstParm.Add(svc.GetDacParm(EnumExecType.ExecSql, Sql, parm));
}
}
else // edit
{
lstParm.Add(svc.GetUpdateParm(vo, new List <string>()
{
EntityRptContagion.Columns.reportTime, EntityRptContagion.Columns.reportOperCode, EntityRptContagion.Columns.reportOperName, EntityRptContagion.Columns.reportId,
EntityRptContagion.Columns.registerCode, EntityRptContagion.Columns.patType, EntityRptContagion.Columns.patNo, EntityRptContagion.Columns.patName,
EntityRptContagion.Columns.patSex, EntityRptContagion.Columns.birthday, EntityRptContagion.Columns.idCard, EntityRptContagion.Columns.contactAddr,
EntityRptContagion.Columns.contactTel, EntityRptContagion.Columns.deptCode, EntityRptContagion.Columns.formId, EntityRptContagion.Columns.operCode,
EntityRptContagion.Columns.recordDate, EntityRptContagion.Columns.status
},
new List <string>()
{
EntityRptContagion.Columns.rptId
}));
voData.rptId = vo.rptId;
voData.xmlData = vo.xmlData;
lstParm.Add(svc.GetUpdateParm(voData, new List <string>()
{
EntityRptEventData.Columns.xmlData
}, new List <string>()
{
EntityRptEventData.Columns.rptId
}));
rptId = vo.rptId;
}
affectRows = svc.Commit(lstParm);
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
