/// <summary>
        /// 更新一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Update(InviteInterview model, SqlTransaction tran = null)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update InviteInterview set ");
            strSql.Append("ZhaoPinID=@ZhaoPinID,InviteTime=@InviteTime,ViewAddress=@ViewAddress,QiuZhiID=@QiuZhiID,QiuZhiPublisher=@QiuZhiPublisher,CreateTime=@CreateTime,CreateUser=@CreateUser,IsDelete=@IsDelete");

            strSql.Append(" where InviteInterviewId=@InviteInterviewId");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ZhaoPinID",         model.ZhaoPinID),
                new SqlParameter("@InviteTime",        model.InviteTime),
                new SqlParameter("@ViewAddress",       model.ViewAddress),
                new SqlParameter("@QiuZhiID",          model.QiuZhiID),
                new SqlParameter("@QiuZhiPublisher",   model.QiuZhiPublisher),
                new SqlParameter("@CreateTime",        model.CreateTime),
                new SqlParameter("@CreateUser",        model.CreateUser),
                new SqlParameter("@IsDelete",          model.IsDelete),


                new SqlParameter("@InviteInterviewId", model.InviteInterviewId)
            };

            if (tran == null)
            {
                return(SqlHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters) > 0);
            }
            else
            {
                return(SqlHelper.ExecuteSql(tran, CommandType.Text, strSql.ToString(), parameters) > 0);
            }
        }
        /// <summary>
        /// 添加一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(InviteInterview model, SqlTransaction tran = null)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into InviteInterview(");
            strSql.Append(" ZhaoPinID,InviteTime,ViewAddress,QiuZhiID,QiuZhiPublisher,CreateTime,CreateUser,IsDelete )");
            strSql.Append(" values (");
            strSql.Append("@ZhaoPinID,@InviteTime,@ViewAddress,@QiuZhiID,@QiuZhiPublisher,@CreateTime,@CreateUser,@IsDelete);select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ZhaoPinID",       model.ZhaoPinID),
                new SqlParameter("@InviteTime",      model.InviteTime),
                new SqlParameter("@ViewAddress",     model.ViewAddress),
                new SqlParameter("@QiuZhiID",        model.QiuZhiID),
                new SqlParameter("@QiuZhiPublisher", model.QiuZhiPublisher),
                new SqlParameter("@CreateTime",      model.CreateTime),
                new SqlParameter("@CreateUser",      model.CreateUser),
                new SqlParameter("@IsDelete",        model.IsDelete),
            };

            object obj;

            if (tran == null)
            {
                obj = SqlHelper.GetSingle(strSql.ToString(), CommandType.Text, parameters);
            }
            else
            {
                obj = SqlHelper.GetSingle(tran, CommandType.Text, strSql.ToString(), parameters);
            }
            return(obj == null ? 0 : Convert.ToInt32(obj));
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 修改 (可能有其他业务逻辑检查)
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public ResultInfo Update(InviteInterview model, SqlTransaction tran = null)
        {
            ResultInfo ri = new ResultInfo();

            if (Edit(model, tran))
            {
                ri.Ok  = true;
                ri.Msg = "修改成功";
            }

            return(ri);
        }
Ejemplo n.º 4
0
        public ActionResult IV(long id, long zid, string place, DateTime time)
        {
            ResultInfo ri     = new ResultInfo();
            var        zmodel = ZhaoPinBLL.Instance.GetModel(zid);

            if (zmodel != null && zmodel.IsDelete == 0)
            {
                var qmodel = QiuZhiBLL.Instance.GetModel(id);
                if (qmodel != null && qmodel.IsDelete == 0)
                {
                    //判断是否已邀请面试
                    if (!InviteInterviewBLL.Instance.Hasinvited(qmodel.QiuZhiID, UserID))
                    {
                        if (IsSafe(place))
                        {
                            InviteInterview inviteInterview = new InviteInterview()
                            {
                                CreateTime      = DateTime.Now,
                                CreateUser      = UserID.ToString(),
                                InviteTime      = time,
                                IsDelete        = 0,
                                ZhaoPinID       = zid,
                                QiuZhiID        = qmodel.QiuZhiID,
                                QiuZhiPublisher = qmodel.Publisher.ToInt64(),
                                ViewAddress     = place
                            };
                            if (InviteInterviewBLL.Instance.Add(inviteInterview) > 0)
                            {
                                ri.Ok = true;

                                #region 邮件通知求职者
                                NoticeBLL.Instance.OnInviteInterview_Notice_Author(UserInfo.UserName, zmodel.Gangwei, zmodel.ZhaoPinID.ToString(), time.ToString(), place, qmodel.IWant, qmodel.QiuZhiID.ToString(), GetDomainName, qmodel.Publisher.ToInt64(), NoticeTypeEnum.InviteInterview);
                                #endregion
                            }
                        }
                    }
                    else
                    {
                        ri.Msg = "您已邀请面试过了!";
                    }
                }
                else
                {
                    ri.Msg = "求职信息已被删除,不能邀请面试!";
                }
            }
            else
            {
                ri.Msg = "抱歉,您的该招聘信息已被删除!";
            }
            return(Result(ri));
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 保存 (可能有其他业务逻辑检查)
        /// </summary>
        /// <param name="model">实体</param>
        /// <returns></returns>
        public ResultInfo Create(InviteInterview model, SqlTransaction tran = null)
        {
            ResultInfo ri = new ResultInfo();

            if (model == null)
            {
                return(ri);
            }

            int result = Add(model, tran);

            if (result > 0)
            {
                ri.Ok  = true;
                ri.Msg = "添加成功";
            }

            return(ri);
        }
Ejemplo n.º 6
0
 /// <summary>
 /// 修改一条记录
 /// </summary>
 /// <param name="model">实体对象</param>
 /// <returns></returns>
 public bool Edit(InviteInterview model, SqlTransaction tran = null)
 {
     return(dal.Update(model, tran));
 }
Ejemplo n.º 7
0
 /// <summary>
 /// 添加一条记录,没有任何逻辑
 /// </summary>
 /// <param name="model">实体对象</param>
 /// <returns></returns>
 public int Add(InviteInterview model, SqlTransaction tran = null)
 {
     return(dal.Add(model, tran));
 }