/// <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("保存失败。"); } } }
public frmPopup2050202(EntityTnbPg _pgVo) { InitializeComponent(); this.Height = System.Windows.Forms.Screen.PrimaryScreen.WorkingArea.Height; if (!DesignMode) { this.lueEnaOper.LookAndFeel.UseDefaultLookAndFeel = false; this.lueEnaOper.LookAndFeel.SkinName = "Black"; this.lueRecorder.LookAndFeel.UseDefaultLookAndFeel = false; this.lueRecorder.LookAndFeel.SkinName = "Black"; this.pgVo = _pgVo; } }
/// <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); }
/// <summary> /// 评估记录-获取 /// </summary> /// <param name="parms"></param> /// <returns></returns> public List <EntityTnbPg> GetTnbPgRecords(List <EntityParm> parms) { List <EntityTnbPg> data = null; SqlHelper svc = new SqlHelper(EnumBiz.onlineDB); string Sql = string.Empty; Sql = @" select a.recId, b.clientNo, b.clientName, b.gender, b.birthday, b.gradeName, a.pgId, a.dangerLevel, a.manageLevel, a.evaDate, e.xmlData, d.oper_name as pgRecorder from tnbPg a left join tnbRecord c on a.recId = c.recId inner join V_ClientInfo b on c.clientNo = b.clientNo and c.regTimes = b.regTimes left join tnbPgData e on a.pgId = e.pgId left join code_operator d on a.evaluator = d.oper_code where a.status = 1" ; DataTable dt = svc.GetDataTable(Sql); if (dt != null && dt.Rows.Count > 0) { data = new List <EntityTnbPg>(); EntityTnbPg vo = null; foreach (DataRow dr in dt.Rows) { vo = new EntityTnbPg(); vo.pgId = Function.Dec(dr["pgId"]); vo.recId = Function.Dec(dr["recId"]); Function.SetClientInfo(ref vo, dr); vo.dangerLevel = dr["dangerLevel"].ToString(); if (vo.dangerLevel == "1") { vo.dangerLevel = "低危"; } if (vo.dangerLevel == "2") { vo.dangerLevel = "中危"; } if (vo.dangerLevel == "3") { vo.dangerLevel = "高危"; } vo.manageLevel = dr["manageLevel"].ToString(); if (vo.manageLevel == "1") { vo.manageLevel = "一级管理"; } if (vo.manageLevel == "2") { vo.manageLevel = "二级管理"; } if (vo.manageLevel == "3") { vo.manageLevel = "三级管理"; } vo.evaluator = dr["pgRecorder"].ToString(); vo.evaDateStr = Function.Datetime(dr["evaDate"]).ToString("yyyy-MM-dd"); vo.pgData = dr["xmlData"].ToString(); data.Add(vo); } } return(data); }