/// <summary>
/// 常规问卷--保存
/// </summary>
/// <param name="qnRecord"></param>
/// <param name="qnData"></param>
/// <param name="recId"></param>
/// <returns></returns>
public int SaveQnRecord(EntityQnRecord qnRecord, EntityQnData qnData, out decimal recId)
{
using (Biz202 biz = new Biz202())
{
return(biz.SaveQnRecord(qnRecord, qnData, out recId));
}
}
/// <summary>
/// 常规问卷-保存
/// </summary>
/// <param name="sfData"></param>
/// <param name="sfId"></param>
/// <returns></returns>
public int SaveQnRecord(EntityQnRecord qnRecord, EntityQnData qnData, out decimal recId)
{
int affectRows = 0;
recId = 0;
string Sql = string.Empty;
SqlHelper svc = null;
try
{
List <DacParm> lstParm = new List <DacParm>();
svc = new SqlHelper(EnumBiz.onlineDB);
if (qnRecord.recId <= 0)
{
recId = svc.GetNextID("qnRecord", "recId");
qnRecord.recId = recId;
qnRecord.recorder = "00";
qnRecord.recordDate = DateTime.Now;
qnRecord.status = 0;
qnData.recId = recId;
lstParm.Add(svc.GetInsertParm(qnRecord));
lstParm.Add(svc.GetInsertParm(qnData));
}
else
{
recId = qnRecord.recId;
lstParm.Add(svc.GetUpdateParm(qnRecord,
new List <string> {
EntityQnRecord.Columns.clientNo,
EntityQnRecord.Columns.qnType,
EntityQnRecord.Columns.qnSource
},
new List <string> {
EntityQnRecord.Columns.recId
}));
lstParm.Add(svc.GetUpdateParm(qnData,
new List <string> {
EntityQnData.Columns.xmlData
},
new List <string> {
EntityQnData.Columns.recId
}));
}
if (lstParm.Count > 0)
{
affectRows = svc.Commit(lstParm);
}
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
