コード例 #1
0
ファイル: Work.cs プロジェクト: snoopy83101/Uzor001
        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();
        }
コード例 #2
0
ファイル: RecommendBLL.cs プロジェクト: snoopy83101/Uzor001
        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);
            }
        }