/// <summary> /// 评估记录-保存 /// </summary> /// <param name="pgData"></param> /// <param name="pgId"></param> /// <returns></returns> public int SaveGxyPgRecord(EntityGxyRecord gxyRecord, EntityGxyPg gxyPg, EntityGxyPgData pgData, out decimal pgId) { using (Biz205 biz = new Biz205()) { return(biz.SaveGxyPgRecord(gxyRecord, gxyPg, pgData, out pgId)); } }
/// <summary> /// 评估记录-保存 /// </summary> /// <param name="pgData"></param> /// <param name="pgId"></param> /// <returns></returns> public int SaveGxyPgRecord(EntityGxyRecord gxyRecord, EntityGxyPg gxyPg, EntityGxyPgData 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 (gxyPg.pgId <= 0) { id = svc.GetNextID("gxyPg", "pgId"); gxyPg.status = 1; gxyPg.pgId = id; gxyPg.recordDate = DateTime.Now; gxyRecord.pgTimes += 1; lstParm.Add(svc.GetInsertParm(gxyPg)); //高血压下次随访数据 string sql = @"update gxyRecord set pgTimes = ? where recId = ?"; IDataParameter[] param = svc.CreateParm(2); param[0].Value = gxyRecord.pgTimes; param[1].Value = gxyRecord.recId; lstParm.Add(svc.GetDacParm(EnumExecType.ExecSql, sql, param)); } else { id = gxyPg.pgId; lstParm.Add(svc.GetUpdateParm(gxyPg, new List <string> { EntityGxyPg.Columns.bloodPressLevel, EntityGxyPg.Columns.dangerLevel, EntityGxyPg.Columns.manageLevel, EntityGxyPg.Columns.evaDate, }, new List <string> { EntityGxyPg.Columns.pgId })); } pgData.pgId = id; //评估数据 lstParm.Add(svc.GetDelParm(pgData, EntityGxyPgData.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); }
/// <summary> /// SaveData /// </summary> /// <returns></returns> void SaveData() { if (pgVo == null) { pgVo = new EntityGxyPg(); pgVo.recId = gxyRecord.recId; } if (gxyRecord == null) { gxyRecord = new EntityGxyRecord(); gxyRecord.recId = pgVo.recId; } if (chkXyfj01.Checked == true) { pgVo.bloodPressLevel = "1"; } if (chkXyfj02.Checked == true) { pgVo.bloodPressLevel = "2"; } if (chkXyfj03.Checked == true) { pgVo.bloodPressLevel = "3"; } if (chkXyfj04.Checked == true) { pgVo.bloodPressLevel = "4"; } if (chkXyfj05.Checked == true) { pgVo.bloodPressLevel = "5"; } if (chkXyfj06.Checked == true) { pgVo.bloodPressLevel = "6"; } if (chkWxfc01.Checked == true) { pgVo.dangerLevel = "1"; } if (chkWxfc02.Checked == true) { pgVo.dangerLevel = "2"; } if (chkWxfc03.Checked == true) { pgVo.dangerLevel = "3"; } 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 EntityGxyPgData(); pgData.xmlData = GetData(); decimal pgId = 0; bool isNew = this.pgVo.pgId <= 0 ? true : false; using (ProxyHms proxy = new ProxyHms()) { if (proxy.Service.SaveGxyPgRecord(this.gxyRecord, 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("保存失败。"); } } }