/// <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;
}
