/// <summary> /// 保存 /// </summary> /// <param name="vo"></param> /// <param name="templateId"></param> /// <returns></returns> public int SaveSportItem(EntityDicSportItem vo, out decimal templateId) { using (Biz210 biz = new Biz210()) { return(biz.SaveSportItem(vo, out templateId)); } }
void New() { SportItemVo = new EntityDicSportItem() { sId = 0 }; SetContent(SportItemVo); }
void SetContent(EntityDicSportItem vo) { this.txtSportNo.Text = vo.sportNo; this.txtSportName.Text = vo.sportName; this.txtMetValue.Text = vo.metValue.ToString(); this.cboSportTime.Text = vo.sportTimeName; this.cboSportType.Text = vo.sportTypeName; this.cboSportNum.Text = vo.sportNumName; this.txtMinAge.Text = vo.minAge.ToString(); this.txtMaxAge.Text = vo.maxAge.ToString(); this.cboSex.Text = vo.sex; this.txtAnnouncements.Text = vo.announcements; this.txtEffect.Text = vo.effect; this.txtDecription.Text = vo.decription; }
/// <summary> /// 保存 /// </summary> /// <param name="vo"></param> /// <param name="templateId"></param> /// <returns></returns> public int SaveSportItem(EntityDicSportItem vo, out decimal templateId) { int affectRows = 0; templateId = 0; string Sql = string.Empty; SqlHelper svc = null; try { svc = new SqlHelper(EnumBiz.onlineDB); if (vo.sId <= 0) { Sql = @"select max(t.sId) as maxId from dicSportItem t"; DataTable dt = svc.GetDataTable(Sql); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["maxId"] != DBNull.Value) { vo.sId = Convert.ToDecimal(dt.Rows[0]["maxId"]) + 1; } } if (vo.sId <= 0) { vo.sId = 1; } } List <DacParm> lstParm = new List <DacParm>(); lstParm.Add(svc.GetDelParmByPk(vo)); lstParm.Add(svc.GetInsertParm(vo)); affectRows = svc.Commit(lstParm); templateId = vo.sId; } catch (Exception e) { ExceptionLog.OutPutException(e); affectRows = -1; } finally { svc = null; } return(affectRows); }
public frmPopup21001(EntityDicSportItem _sportItemVo) { InitializeComponent(); SportItemVo = _sportItemVo; }