/// <summary>
/// 随访记录-保存
/// </summary>
/// <param name="sfData"></param>
/// <param name="sfId"></param>
/// <returns></returns>
public int SaveTnbSfRecord(EntityTnbRecord tnbRecord, EntityTnbSf tnbSf, EntityTnbSfData sfData, out decimal sfId)
{
int affectRows = 0;
sfId = 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 (tnbSf.sfId <= 0)
{
id = svc.GetNextID("tnbSf", "sfId");
tnbSf.sfId = id;
tnbSf.sfStatus = 1;
tnbSf.recordDate = DateTime.Now;
tnbRecord.sfId = id;
tnbRecord.sfTimes += 1;
sfData.sfId = id;
lstParm.Add(svc.GetInsertParm(tnbSf));
}
else
{
id = tnbSf.sfId;
lstParm.Add(svc.GetUpdateParm(tnbSf,
new List <string> {
EntityTnbSf.Columns.sfMethod,
EntityTnbSf.Columns.sfClass,
EntityTnbSf.Columns.sfDate
},
new List <string> {
EntityTnbSf.Columns.sfId
}));
}
//随访数据
lstParm.Add(svc.GetDelParm(sfData, EntityTnbSfData.Columns.sfId));
lstParm.Add(svc.GetInsertParm(sfData));
if (tnbRecord.sfTimes > 0)
{
//高血压下次随访数据
string sql = @"update tnbRecord set manageLevel = ?, nextSfDate = ?, sfId = ?,sfTimes = ? where recId = ?";
IDataParameter[] param = svc.CreateParm(5);
param[0].Value = tnbRecord.manageLevel;
param[1].Value = tnbRecord.nextSfDate;
param[2].Value = tnbRecord.sfId;
param[3].Value = tnbRecord.sfTimes;
param[4].Value = tnbRecord.recId;
lstParm.Add(svc.GetDacParm(EnumExecType.ExecSql, sql, param));
}
else
{
//高血压下次随访数据
string sql = @"update tnbRecord set manageLevel = ?, nextSfDate = ?, sfId = ? where recId = ?";
IDataParameter[] param = svc.CreateParm(4);
param[0].Value = tnbRecord.manageLevel;
param[1].Value = tnbRecord.nextSfDate;
param[2].Value = tnbRecord.sfId;
param[3].Value = tnbRecord.recId;
lstParm.Add(svc.GetDacParm(EnumExecType.ExecSql, sql, param));
}
if (lstParm.Count > 0)
{
affectRows = svc.Commit(lstParm);
}
sfId = id;
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
/// <summary>
/// SaveData
/// </summary>
/// <returns></returns>
void SaveData()
{
if (tnbSf == null)
{
tnbSf = new EntityTnbSf();
tnbSf.recId = tnbRecord.recId;
}
if (tnbRecord == null)
{
tnbRecord = new EntityTnbRecord();
tnbRecord.recId = tnbSf.recId;
}
tnbSf.sfDate = Function.Datetime(dteSfDate.Text);
tnbSf.sfMethod = string.Empty;
tnbSf.sfClass = string.Empty;
tnbRecord.manageLevel = string.Empty;
if (chkSffs01.Checked == true)
{
tnbSf.sfMethod = "1";
}
if (chkSffs02.Checked == true)
{
tnbSf.sfMethod = "2";
}
if (chkSffs03.Checked == true)
{
tnbSf.sfClass = "3";
}
if (chkSfClass01.Checked == true)
{
tnbSf.sfClass = "1";
}
if (chkSfClass02.Checked == true)
{
tnbSf.sfClass = "2";
}
if (chkSfClass03.Checked == true)
{
tnbSf.sfClass = "3";
}
if (chkSfClass04.Checked == true)
{
tnbSf.sfClass = "4";
}
if (chkManageLevel01.Checked == true)
{
tnbRecord.manageLevel = "1";
}
if (chkManageLevel02.Checked == true)
{
tnbRecord.manageLevel = "2";
}
if (chkManageLevel03.Checked == true)
{
tnbRecord.manageLevel = "3";
}
if (string.IsNullOrEmpty(tnbSf.sfMethod))
{
DialogBox.Msg("随访形式必选 ！");
return;
}
if (string.IsNullOrEmpty(tnbSf.sfClass))
{
DialogBox.Msg("随访分类必选 ！");
return;
}
if (string.IsNullOrEmpty(tnbRecord.manageLevel))
{
DialogBox.Msg("管理等级必选 ！");
return;
}
tnbSf.sfRecorder = this.lueSfRecorder.EditValue.ToString();
tnbSf.sfStatus = 1;
if (this.sfData == null)
{
this.sfData = new EntityTnbSfData();
}
this.sfData.sfId = tnbSf.sfId;
this.sfData.xmlData = this.GetData();
if (!string.IsNullOrEmpty(dteNextSfDate.Text))
{
tnbRecord.nextSfDate = Function.Datetime(dteNextSfDate.Text);
}
decimal sfId = 0;
bool isNew = this.sfData.sfId <= 0 ? true : false;
using (ProxyHms proxy = new ProxyHms())
{
if (proxy.Service.SaveTnbSfRecord(this.tnbRecord, this.tnbSf, this.sfData, out sfId) > 0)
{
this.IsRequireRefresh = true;
if (isNew)
{
this.tnbSf.sfId = sfId;
this.sfData.sfId = sfId;
this.tnbRecord.sfId = sfId;
}
DialogBox.Msg("保存成功！");
}
else
{
DialogBox.Msg("保存失败。");
}
}
}
