/// <summary>
/// 评估记录-保存
/// </summary>
/// <param name="pgData"></param>
/// <param name="pgId"></param>
/// <returns></returns>
public int SaveTnbPgRecord(EntityTnbRecord tnbRecord, EntityTnbPg tnbPg, EntityTnbPgData pgData, out decimal pgId)
{
using (Biz205 biz = new Biz205())
{
return(biz.SaveTnbPgRecord(tnbRecord, tnbPg, pgData, out pgId));
}
}
/// <summary>
/// SaveData
/// </summary>
/// <returns></returns>
void SaveData()
{
if (pgVo == null)
{
pgVo = new EntityTnbPg();
pgVo.recId = tnbRecord.recId;
}
if (tnbRecord == null)
{
tnbRecord = new EntityTnbRecord();
tnbRecord.recId = pgVo.recId;
}
if (chkManageLevel01.Checked == true)
{
pgVo.manageLevel = "1";
}
if (chkManageLevel02.Checked == true)
{
pgVo.manageLevel = "2";
}
if (chkManageLevel03.Checked == true)
{
pgVo.manageLevel = "3";
}
pgVo.evaluator = lueEnaOper.EditValue.ToString();
pgVo.evaDate = Function.Datetime(dteEnaDate.Text);
pgData = new EntityTnbPgData();
pgData.xmlData = GetData();
decimal pgId = 0;
bool isNew = this.pgVo.pgId <= 0 ? true : false;
using (ProxyHms proxy = new ProxyHms())
{
if (proxy.Service.SaveTnbPgRecord(this.tnbRecord, this.pgVo, this.pgData, out pgId) > 0)
{
this.IsRequireRefresh = true;
if (isNew)
{
this.pgVo.pgId = pgId;
this.pgData.pgId = pgId;
}
DialogBox.Msg("保存成功！");
}
else
{
DialogBox.Msg("保存失败。");
}
}
}
/// <summary>
/// 评估记录-保存
/// </summary>
/// <param name="pgData"></param>
/// <param name="pgId"></param>
/// <returns></returns>
public int SaveTnbPgRecord(EntityTnbRecord tnbRecord, EntityTnbPg tnbPg, EntityTnbPgData pgData, out decimal pgId)
{
int affectRows = 0;
pgId = 0;
string Sql = string.Empty;
SqlHelper svc = null;
decimal id = 0;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
List <DacParm> lstParm = new List <DacParm>();
svc = new SqlHelper(EnumBiz.onlineDB);
if (tnbPg.pgId <= 0)
{
id = svc.GetNextID("tnbPg", "pgId");
tnbPg.status = 1;
tnbPg.pgId = id;
tnbPg.recordDate = DateTime.Now;
tnbRecord.pgTimes += 1;
lstParm.Add(svc.GetInsertParm(tnbPg));
//糖尿病下次随访数据
string sql = @"update tnbRecord set pgTimes = ? where recId = ?";
IDataParameter[] param = svc.CreateParm(2);
param[0].Value = tnbRecord.pgTimes;
param[1].Value = tnbRecord.recId;
lstParm.Add(svc.GetDacParm(EnumExecType.ExecSql, sql, param));
}
else
{
id = tnbPg.pgId;
lstParm.Add(svc.GetUpdateParm(tnbPg,
new List <string> {
EntityTnbPg.Columns.dangerLevel,
EntityTnbPg.Columns.manageLevel,
EntityTnbPg.Columns.evaDate,
},
new List <string> {
EntityTnbPg.Columns.pgId
}));
}
pgData.pgId = id;
//评估数据
lstParm.Add(svc.GetDelParm(pgData, EntityTnbPgData.Columns.pgId));
lstParm.Add(svc.GetInsertParm(pgData));
if (lstParm.Count > 0)
{
affectRows = svc.Commit(lstParm);
}
pgId = id;
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
