private void doRecommend() { DAL.RecommendDAL dal = new DAL.RecommendDAL(); BLL.RecommendBLL bll = new BLL.RecommendBLL(); Model.RecommendModel model = new Model.RecommendModel(); model.RecommendId = ReStr("RecommendId", ""); if (model.RecommendId != "") { model = dal.GetModel(model.RecommendId); } model.Invalid = false; model.RecommendMemo = ReStr("RecommendMemo", ""); model.RecommendType = ReStr("RecommendType", ""); model.ReKey = ReStr("ReKey"); model.BgTime = ReTime("BgTime"); model.EndTime = ReTime("EndTime"); #region 事务开启 TransactionOptions transactionOption = new TransactionOptions(); transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption)) { #endregion bll.doRecommend(model); //添加一条推广信息 int RecommendLv = ReInt("RecommendLv"); switch (model.RecommendType) { case "职位": DAL.DalComm.ExReInt(" update dbo.Job set RecommendLv='" + RecommendLv + "' where JobId='" + model.ReKey + "' "); break; case "房源": DAL.DalComm.ExReInt(" update dbo.House set RecommendLv='" + RecommendLv + "' where HouseId='" + model.ReKey + "' "); break; case "供求": DAL.DalComm.ExReInt(" update dbo.Information set RecommendLv='" + RecommendLv + "' where InformationId='" + model.ReKey + "' "); break; } #region 事务结束 transactionScope.Complete(); } #endregion ReTrue(); }
public void doRecommend(Model.RecommendModel model) { DAL.RecommendDAL dal = new DAL.RecommendDAL(); if (model.RecommendId == "") { dal.DeleteList(" ReKey='" + model.ReKey + "' and RecommendType='" + model.RecommendType + "' "); //已经存在了,就删除之前的, 按照此次为准. model.RecommendId = Common.TimeString.GetNow_ff(); dal.Add(model); } else { dal.Update(model); } }