Esempio n. 1
0
 /// <summary>
 /// 删除任务功能
 /// 先删除当前线程中的任务,然后再删除数据库表中的任务状态
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void Delete(object sender, CommandEventArgs e)
 {
     try
     {
         string             missionid = e.CommandArgument.ToString();
         Model.TimerMission model     = _bll.GetModel(new Guid(missionid));
         //删除线程中的任务
         _missionControl.DeleteJob(model.GroupName, model.MissionName);
         //更改存储在数据库中当前的任务状态ISDel=1
         bool isdel = _bll.Delete(new Guid(missionid));
         UiHelper.Alert(this, isdel ? "删除成功" : "删除失败");
         NewDatabind(Convert.ToInt32(countDDL.SelectedValue));
     }
     catch (Exception)
     {
         UiHelper.Alert(this, "删除失败,未知错误");
         throw;
     }
 }
Esempio n. 2
0
 /// <summary>
 /// 修改任务并立即执行
 /// 操作步骤:先将当前进程中任务删除,然后再重新添加到进程中
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void btnEditMissionBeginNow_Click(object sender, EventArgs e)
 {
     try
     {
         //获取当前修改的任务的主键
         string missionid = EditTimerMission();
         if (missionid != "")
         {
             //当前的任务模型
             Model.TimerMission model = _bll.GetModel(new Guid(missionid));
             //删除线程中的任务
             _missionControl.DeleteJob(model.GroupName, model.MissionName);
             bool issuccess = _missionControl.AddSqlExecuteJob(model.SqlStr, Convert.ToDateTime(model.StartTime), Convert.ToDateTime(model.EndTime), model.GroupName, model.MissionName, model.TimeCorn);
             if (issuccess)
             {
                 UiHelper.Alert(this, "修改任务成功,当前任务已开始运行!");
                 model.MissionState = 1;
                 _bll.Update(model);                                   //更新数据
                 NewDatabind(Convert.ToInt32(countDDL.SelectedValue)); //重新绑定数据
             }
             else
             {
                 UiHelper.Alert(this, "操作失败,请重试!");
             }
         }
         else
         {
             UiHelper.Alert(this, "操作失败,请重试!");
         }
     }
     catch (Exception)
     {
         UiHelper.Alert(this, "操作失败,未知错误!");
         throw;
     }
 }
Esempio n. 3
0
        /// <summary>
        /// 任务修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnMissionEdit_Click(object sender, EventArgs e)
        {
            string edit = EditTimerMission();

            UiHelper.Alert(this, edit != "" ? "修改任务成功,当前任务状态恢复为未执行状态!" : "修改任务失败,请校验数据后重试!");
        }
Esempio n. 4
0
        /// <summary>
        /// TimerMission表数据修改
        /// </summary>
        /// <returns>返回修改的任务主键</returns>
        private string EditTimerMission()
        {
            try
            {
                #region 校验非空错误提示
                string strErr = "";
                if (this.txtEditMissionName.Text.Trim().Length == 0)
                {
                    strErr += "任务名称不能为空!\\n";
                }
                if (this.txtEditGroupName.Text.Trim().Length == 0)
                {
                    strErr += "组名称不能为空!\\n";
                }
                if (this.txtEditSqlStr.Text.Trim().Length == 0)
                {
                    strErr += "SQL执行语句不能为空!\\n";
                }
                if (this.txtEditTimeCorn.Text.Trim().Length == 0)
                {
                    strErr += "时间调度表达式不能为空!\\n";
                }

                if (this.txtEditMissionStartTime.Text.Trim().Length == 0)
                {
                    strErr += "任务开始时间不能为空!\\n";
                }
                if (this.txtEditMissionEndTime.Text.Trim().Length == 0)
                {
                    strErr += "任务结束时间不能为空!\\n";
                }
                if (Convert.ToDateTime(this.txtEditMissionStartTime.Text.Trim()) >= Convert.ToDateTime(this.txtEditMissionEndTime.Text.Trim()))
                {
                    strErr += "任务开始时间不可大于结束时间\\n";
                }
                if (strErr != "")
                {
                    UiHelper.Alert(this, strErr);
                    return("");
                }
                #endregion

                var    model       = _bll.GetModel(new Guid(txtHiddenText.Text));
                string missionName = this.txtEditMissionName.Text;
                string groupName   = this.txtEditGroupName.Text;
                //判断除去当前数据外是否存在重名数据
                var isrepeat = _bll.TestRepeat(missionName, groupName, model.ID.ToString());
                if (isrepeat) //判断当前任务名和组名是否重复
                {
                    UiHelper.Alert(this, "当前已存在重复的任务组名和任务名,请修改名称后再进行操作!");
                    return("");
                }
                else
                {
                    model.MissionName    = missionName;
                    model.GroupName      = groupName;
                    model.SqlStr         = this.txtEditSqlStr.Text;
                    model.TimeCorn       = this.txtEditTimeCorn.Text;
                    model.RepeatCount    = int.Parse(this.txtEditRepeatCount.Text);
                    model.StartTime      = DateTime.Parse(this.txtEditMissionStartTime.Text);
                    model.EndTime        = DateTime.Parse(this.txtEditMissionEndTime.Text);
                    model.CreateTime     = DateTime.Now;
                    model.InveralTime    = 0;
                    model.MissionExplain = this.txtEditMissionExplain.Text;
                    model.MissionState   = 2;//默认设置当前的MissionState为空
                    //数据添加
                    bool issuccess = _bll.Update(model);
                    if (issuccess)
                    {
                        //重新进行数据绑定
                        NewDatabind(Convert.ToInt32(countDDL.SelectedValue));

                        //清空原有的输入框数据
                        foreach (TextBox tbx in this.form1.Controls.OfType <TextBox>())
                        {
                            if (tbx != null)
                            {
                                tbx.Text = "";
                            }
                        }
                    }
                    return(issuccess ? model.ID.ToString() : "");
                }
            }
            catch
            {
                UiHelper.Alert(this, "未知原因,操作失败!");
                return("");
            }
        }
Esempio n. 5
0
        /// <summary>
        /// TimerMission表数据添加
        /// </summary>
        /// <returns></returns>
        private string AddTimerMission()
        {
            try
            {
                #region 校验非空错误提示
                string strErr = "";
                if (this.txtAddMissionName.Text.Trim().Length == 0)
                {
                    strErr += "任务名称不能为空!\\n";
                }
                if (this.txtAddGroupName.Text.Trim().Length == 0)
                {
                    strErr += "组名称不能为空!\\n";
                }
                if (this.txtAddSqlStr.Text.Trim().Length == 0)
                {
                    strErr += "SQL执行语句不能为空!\\n";
                }
                if (this.txtAddTimeCorn.Text.Trim().Length == 0)
                {
                    strErr += "时间调度表达式不能为空!\\n";
                }

                if (this.txtAddMissionStartTime.Text.Trim().Length == 0)
                {
                    strErr += "任务开始时间不能为空!\\n";
                }
                if (this.txtAddMissionEndTime.Text.Trim().Length == 0)
                {
                    strErr += "任务结束时间不能为空!\\n";
                }
                if (Convert.ToDateTime(this.txtAddMissionStartTime.Text.Trim()) >= Convert.ToDateTime(this.txtAddMissionEndTime.Text.Trim()))
                {
                    strErr += "任务开始时间不可大于结束时间\\n";
                }
                if (strErr != "")
                {
                    UiHelper.Alert(this, strErr);
                    return("");
                }
                #endregion

                string missionName = this.txtAddMissionName.Text;
                string groupName   = this.txtAddGroupName.Text;
                bool   isrepeat    = _bll.TestRepeat(missionName, groupName);
                if (isrepeat) //判断当前任务名和组名是否重复
                {
                    UiHelper.Alert(this, "当前已存在重复的任务组名和任务名,请修改后再进行添加!");
                    return("");
                }
                else
                {
                    Model.TimerMission model = new Model.TimerMission {
                        ID             = Guid.NewGuid(),
                        MissionName    = missionName,
                        GroupName      = groupName,
                        SqlStr         = this.txtAddSqlStr.Text,
                        TimeCorn       = this.txtAddTimeCorn.Text,
                        RepeatCount    = int.Parse(this.txtAddRepeatCount.Text),
                        StartTime      = DateTime.Parse(this.txtAddMissionStartTime.Text),
                        EndTime        = DateTime.Parse(this.txtAddMissionEndTime.Text),
                        CreateTime     = DateTime.Now,
                        InveralTime    = 0,
                        MissionExplain = this.txtAddMissionExplain.Text,
                        MissionState   = 2//默认设置当前的MissionState为空
                    };
                    //数据添加
                    int issuccess = _bll.Add(model);
                    UiHelper.Alert(this, issuccess > 0 ? "保存成功!" : "数据添加失败,请校验数据后重试!");
                    if (issuccess > 0)
                    {
                        //重新进行数据绑定
                        NewDatabind(Convert.ToInt32(countDDL.SelectedValue));
                        //清空原有的输入框数据
                        foreach (object item in this.form1.Controls)
                        {
                            var box = item as TextBox;
                            if (box != null)
                            {
                                TextBox tbx = box; tbx.Text = "";
                            }
                        }
                    }
                    if (issuccess > 0)
                    {
                        return(model.ID.ToString());
                    }
                    else
                    {
                        return("");
                    }
                }
            }
            catch (Exception)
            {
                UiHelper.Alert(this, "未知原因,操作失败!");
                return("");

                throw;
            }
        }