コード例 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        vUTPScheduleMessager vScheduleLogObj;
        tblScheduler         SchedulerObj;

        if (!IsPostBack)
        {
            if (Request.QueryString["KeyGuid"] != null && Request.QueryString["KeyGuid"] != string.Empty)
            {
                KeyId           = Request.QueryString["KeyGuid"].ToString();
                BLL_ScheduleLog = new vScheduleLogBLL();
                //显示UserName信息
                vScheduleLogObj = BLL_ScheduleLog.FindUserNameByScheduleId(KeyId);
                if (vScheduleLogObj != null)
                {
                    lbl_UserName.Text = vScheduleLogObj.UserName;
                }
                //显示TaskName
                BLL_ScheduleTasks = new ScheduleTasksBLL();
                SchedulerObj      = BLL_ScheduleTasks.FindSchedulerById(KeyId);
                lbl_TaskName.Text = SchedulerObj.TaskName.Substring(0, SchedulerObj.TaskName.LastIndexOf("-"));
            }
        }
        GridViewDataBinding(KeyId);
    }
コード例 #2
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        Guid KeyIdGuid;

        if (this.KeyId == string.Empty)
        {
            //将数据保存到客户端cookie
            HttpCookie myCookie = new HttpCookie("EmailSetting");

            myCookie.Values.Add("EmailTo", rtxtTo.Text.Trim());
            myCookie.Expires = System.DateTime.Now.AddDays(1);
            Response.AppendCookie(myCookie);

            Response.Redirect("~/Schedule Billing/TaskDetailForm.aspx");
        }
        else
        {
            KeyIdGuid               = new Guid(this.KeyId);//转换成Guid类型
            SchedulerObj            = new tblScheduler();
            SchedulerObj.EmailTo    = rtxtTo.Text.Trim();
            SchedulerObj.ScheduleID = KeyIdGuid;
            BLL_ScheduleTasks       = new ScheduleTasksBLL();
            successFlag             = BLL_ScheduleTasks.UpdateInEmailForm(SchedulerObj);
            if (!successFlag.Equals("InsertError"))
            {
                Response.Redirect("~/Schedule Billing/TaskDetailForm.aspx?KeyGuid=" + this.KeyId);
            }
            else
            {
                //错误提示信息
                MessageBox(false, false, true,
                           GetGlobalResourceObject("WebResource", "EmailSettingForm_UpdateEmailSetting_ErrorMessage").ToString());
            }
        }
    }
コード例 #3
0
 protected void GetData()
 {
     if (this.KeyId != string.Empty)
     {
         BLL_ScheduleTasks = new ScheduleTasksBLL();
         SchedulerObj      = BLL_ScheduleTasks.FindSchedulerById(this.KeyId);
     }
 }
コード例 #4
0
    protected Boolean rbtnCheck_Click(object sender, EventArgs e)
    {
        ObjectQuery <tblScheduler> SchedulerObjs;

        string strWhere;
        string orderBy;
        string taskName;

        taskName = rtxtTaskName.Text.Trim() + "-CreateSD";
        if (taskName != null && taskName != string.Empty)
        {
            strWhere = " and it.TaskName='" + taskName + "'";
            orderBy  = "it.ScheduleID desc";

            BLL_ScheduleTasks = new ScheduleTasksBLL();
            SchedulerObjs     = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);

            if (this.KeyId != string.Empty)
            {
                if (SchedulerObjs.Count() > 1)//编辑的时候包括自己
                {
                    MessageBox(false, true, false,
                               GetGlobalResourceObject("WebResource", "TaskDetailForm_lnkMessage_ErrorMessage").ToString());

                    return(false);
                }
                else
                {
                    pnlMessage.Visible = false;
                }
            }
            else
            {
                if (SchedulerObjs.Count() > 0)
                {
                    MessageBox(false, true, false,
                               GetGlobalResourceObject("WebResource", "TaskDetailForm_lnkMessage_ErrorMessage").ToString());

                    return(false);
                }
                else
                {
                    pnlMessage.Visible = false;
                }
            }
        }

        return(true);
    }
コード例 #5
0
    protected void GetData()
    {
        string whereStr;
        string orderBy;

        whereStr                  = "";
        orderBy                   = "it.EmailFrom desc";
        BLL_ScheduleTasks         = new ScheduleTasksBLL();
        vBackupAndEmailSettingObj = BLL_ScheduleTasks.GetBackupAndEmailSetting(whereStr, orderBy);
        if (vBackupAndEmailSettingObj.Count() > 0)
        {
            foreach (var item in vBackupAndEmailSettingObj)
            {
                this.TempKeyId = item.BackupID.ToString();
            }
        }
    }
コード例 #6
0
    protected Boolean JudgeBackupAndEmailSetting()
    {
        string whereStr;
        string orderBy;

        whereStr                  = "";
        orderBy                   = "it.EmailFrom desc";
        BLL_ScheduleTasks         = new ScheduleTasksBLL();
        vBackupAndEmailSettingObj = BLL_ScheduleTasks.GetBackupAndEmailSetting(whereStr, orderBy);
        if (vBackupAndEmailSettingObj.Count() > 0)
        {
            foreach (var item in vBackupAndEmailSettingObj)
            {
                return(true);
            }
        }
        return(false);
    }
コード例 #7
0
    protected void rbtnOK_Click(object sender, EventArgs e)
    {
        System.Guid KeyIdGuid;
        string      successFlag;//标记数据库操作是否成功

        int startCycleIndex = 0;
        int endCycleIndex   = 0;

        startCycleIndex = rctxtStartingCycle.SelectedIndex;
        endCycleIndex   = rctxtStartingCycle.FindItemIndexByValue(rctxtEndingCycle.SelectedValue);

        if (rctxtCompany.SelectedValue != "N/A" && rctxtStartingCycle.SelectedValue != "N/A" && rctxtEndingCycle.SelectedValue != "N/A")
        {
            if (startCycleIndex < endCycleIndex || startCycleIndex == endCycleIndex)
            {
                if (this.KeyId == string.Empty)//新增
                {
                    //将数据保存到客户端cookie
                    HttpCookie myCookie = new HttpCookie("Billing");

                    if (rctxtCompany.SelectedItem != null)
                    {
                        myCookie.Values.Add("Company", rctxtCompany.SelectedItem.Value);
                    }

                    if (rctxtStartingCycle.SelectedItem != null)
                    {
                        myCookie.Values.Add("StartingCycle", rctxtStartingCycle.SelectedItem.Value);
                    }

                    if (rctxtEndingCycle.SelectedItem != null)
                    {
                        myCookie.Values.Add("EndingCycle", rctxtEndingCycle.SelectedItem.Value);
                    }

                    if (rctxtStatusCode.SelectedItem != null)
                    {
                        myCookie.Values.Add("StatusCode", rctxtStatusCode.SelectedItem.Value);
                    }

                    myCookie.Values.Add("AllCycles", chkAllCycles.Checked.ToString());
                    myCookie.Values.Add("Copy", chkCopy.Checked.ToString());
                    myCookie.Values.Add("Calc", chkCalc.Checked.ToString());

                    myCookie.Expires = System.DateTime.Now.AddDays(1);
                    Response.AppendCookie(myCookie);
                    Response.Redirect("~/Schedule Billing/TaskDetailForm.aspx");
                }
                else//更新
                {
                    SchedulerObj = new tblScheduler();
                    HttpCookie UserData = Request.Cookies.Get("UserIdCookies");
                    if (UserData != null)
                    {
                        SchedulerObj.UTPUser = UserData.Value;
                    }
                    HttpCookie UserPasswordData = Request.Cookies.Get("UserPasswordCookies");
                    if (UserPasswordData != null)
                    {
                        SchedulerObj.UTPPwd = UserPasswordData.Value;
                    }
                    if (rctxtCompany.SelectedItem != null)
                    {
                        SchedulerObj.Company = rctxtCompany.SelectedItem.Value;
                    }

                    if (rctxtStartingCycle.SelectedItem != null && rctxtEndingCycle.SelectedItem != null)
                    {
                        SchedulerObj.Cycle = rctxtStartingCycle.SelectedItem.Value + "," + rctxtEndingCycle.SelectedItem.Value;
                    }

                    if (rctxtStatusCode.SelectedItem != null)
                    {
                        SchedulerObj.Status = rctxtStatusCode.SelectedItem.Value;
                    }

                    SchedulerObj.Copy = chkCopy.Checked.ToString();
                    SchedulerObj.Calc = chkCalc.Checked.ToString();

                    KeyIdGuid = new Guid(this.KeyId);//转换成Guid类型

                    SchedulerObj.ScheduleID = KeyIdGuid;

                    BLL_ScheduleTasks = new ScheduleTasksBLL();
                    successFlag       = BLL_ScheduleTasks.UpdateInBillingPage(SchedulerObj);
                    if (!successFlag.Equals("InsertError"))
                    {
                        //将数据保存到客户端cookie
                        HttpCookie myCookie = new HttpCookie("Billing");

                        myCookie.Values.Add("billingEdit", "billingEdit");

                        myCookie.Expires = System.DateTime.Now.AddDays(1);
                        Response.AppendCookie(myCookie);

                        Response.Redirect("~/Schedule Billing/TaskDetailForm.aspx?KeyGuid=" + this.KeyId);
                    }
                    else
                    {
                        //错误提示信息
                        MessageBox(false, false, true,
                                   GetGlobalResourceObject("WebResource", "BillingForm_SaveMessage_ErrorMessage").ToString());
                    }
                }
            }
            else//EndCycle<startCycle
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "BillingForm_SelectCycleMessage_Message").ToString());
            }
        }
        else//Cycle的数据无效
        {
            MessageBox(false, true, false,
                       GetGlobalResourceObject("WebResource", "BillingForm_ConpanyCycle_Message").ToString());
        }
    }
コード例 #8
0
    protected void btnOK_Click(object sender, EventArgs e)
    {
        System.Guid KeyIdGuid;
        Boolean     flagCookie   = false;
        Boolean     flagTaskName = false;
        Boolean     flagQequest;
        Boolean     flagRunTime = false;

        if (this.KeyId == string.Empty)
        {
            flagQequest = CheckRequired(sender, e);//校验必填字段是否不为空
            if (flagQequest == true)
            {
                flagCookie = CheckCookiesInfo(sender, e);//校验Cookies是否为空
                if (flagCookie == true)
                {
                    flagTaskName = rbtnCheck_Click(sender, e);//判断Tast名是否重复
                    if (flagTaskName == true)
                    {
                        flagRunTime = JudgeRunTime(rdStartTime.SelectedDate.ToString(), rdEndTime.SelectedDate.ToString());
                    }
                }
            }

            if (flagCookie == true && flagTaskName == true && flagQequest == true && flagRunTime == true)
            {
                //新增
                EncapsulationData(); //封装数据

                GetLoginUserInfo();  //获取当前登陆的账号和密码

                BLL_ScheduleTasks = new ScheduleTasksBLL();
                successFlag       = BLL_ScheduleTasks.Insert(SchedulerObj);
                if (!successFlag.Equals("InsertError"))
                {
                    PageSet(successFlag);//跳View
                }
                else
                {
                    //错误提示信息
                    MessageBox(false, false, true,
                               GetGlobalResourceObject("WebResource", "TaskDetailForm_SaveTasksMessage_ErrorMessage").ToString());
                }
            }
        }
        else//编辑更新
        {
            //billing前不进行备份
            if (chkBDBB.Checked == false)
            {
                flagQequest = CheckRequired(sender, e);//校验必填字段是否为空
                if (flagQequest == true)
                {
                    flagTaskName = rbtnCheck_Click(sender, e);//判断Tast名是否重复
                    if (flagTaskName == true)
                    {
                        flagRunTime = JudgeRunTime(rdStartTime.SelectedDate.ToString(), rdEndTime.SelectedDate.ToString());
                    }
                }
                if (flagTaskName == true && flagQequest == true && flagRunTime == true)
                {
                    EncapsulationData(); //封装数据
                    GetLoginUserInfo();  //获取当前登陆的账号和密码

                    SchedulerObj.BackupID   = null;
                    KeyIdGuid               = new Guid(this.KeyId);//转换成Guid类型
                    SchedulerObj.ScheduleID = KeyIdGuid;
                    successFlag             = BLL_ScheduleTasks.UpdateInTaskDetailForm(SchedulerObj);
                    if (!successFlag.Equals("InsertError"))
                    {
                        PageSet(this.KeyId);//跳View
                    }
                    else
                    {
                        //错误提示信息
                        MessageBox(false, false, true,
                                   GetGlobalResourceObject("WebResource", "TaskDetailForm_UpdateTasksMessage_ErrorMessage").ToString());
                    }
                }
            }
            else
            {                                           //billing前进行备份
                flagQequest = CheckRequired(sender, e); //校验必填字段是否为空
                if (flagQequest == true)
                {
                    flagTaskName = rbtnCheck_Click(sender, e);//判断Tast名是否重复
                    if (flagTaskName == true)
                    {
                        flagCookie = JudgeBackupAndEmailSetting();
                        if (flagCookie == true)                                                                                 //Cookie中是否有值
                        {
                            flagRunTime = JudgeRunTime(rdStartTime.SelectedDate.ToString(), rdEndTime.SelectedDate.ToString()); //新的Tast的StartTime、EndTime不在其他的RunOnlyStart和RunOnlyEnd之间
                        }
                    }
                }
                if (flagTaskName == true && flagQequest == true && flagRunTime == true && flagCookie == true)
                {
                    EncapsulationData();                  //封装数据
                    GetLoginUserInfo();                   //获取当前登陆的账号和密码

                    if (chkBDBB.Checked == true)          //系统备份
                    {
                        KeyIdGuid = new Guid(this.KeyId); //转换成Guid类型
                        SchedulerObj.ScheduleID = KeyIdGuid;
                        successFlag             = BLL_ScheduleTasks.UpdateInTaskDetailForm(SchedulerObj);
                    }
                    if (!successFlag.Equals("InsertError"))
                    {
                        PageSet(this.KeyId);//跳View
                    }
                    else
                    {
                        //错误提示信息
                        MessageBox(false, false, true,
                                   GetGlobalResourceObject("WebResource", "TaskDetailForm_UpdateTasksMessage_ErrorMessage").ToString());
                    }
                }
                else
                {
                    if (flagCookie == false)
                    {
                        MessageBox(false, true, false,
                                   GetGlobalResourceObject("WebResource", "TaskDetailForm_CookiesBackup_ErrorMessage").ToString());
                    }
                }
            }
        }
    }
コード例 #9
0
    protected Boolean JudgeRunTime(string startDate, string endDate)
    {
        string strWhere;
        string orderBy;

        ObjectQuery <tblScheduler> SchedulerObjs;

        BLL_ScheduleTasks = new ScheduleTasksBLL();
        //检测新建Task的起始时间段内,不包含旧的Task时间
        strWhere      = " and it.RunOnlyStart>=cast('" + startDate + "' as System.DateTime) and it.RunOnlyStart<=cast('" + endDate + "' as System.DateTime)";
        orderBy       = "it.TaskName desc";
        SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);

        if (this.KeyId == string.Empty)//插入验证
        {
            if (SchedulerObjs.Count() > 0)
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }
        else
        {
            if (SchedulerObjs.Count() > 1)//更新验证
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }

        strWhere      = " and it.RunOnlyEnd>=cast('" + startDate + "' as System.DateTime) and it.RunOnlyEnd<=cast('" + endDate + "' as System.DateTime)";
        orderBy       = "it.TaskName desc";
        SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);

        if (this.KeyId == string.Empty)//插入验证
        {
            if (SchedulerObjs.Count() > 0)
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }
        else
        {
            if (SchedulerObjs.Count() > 1)//更新验证
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }

        //检测旧Task的起始时间段内,不包含的新建Task时间
        strWhere      = " and it.RunOnlyStart<=cast('" + startDate + "' as System.DateTime) and it.RunOnlyEnd>=cast('" + startDate + "' as System.DateTime)";
        orderBy       = "it.TaskName desc";
        SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);

        if (this.KeyId == string.Empty)//插入验证
        {
            if (SchedulerObjs.Count() > 0)
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }
        else
        {
            if (SchedulerObjs.Count() > 1)//更新验证
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }

        strWhere      = " and it.RunOnlyStart<=cast('" + endDate + "' as System.DateTime) and it.RunOnlyEnd>=cast('" + endDate + "' as System.DateTime)";
        orderBy       = "it.TaskName desc";
        SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);

        if (this.KeyId == string.Empty)//插入验证
        {
            if (SchedulerObjs.Count() > 0)
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }
        else
        {
            if (SchedulerObjs.Count() > 1)//更新验证
            {
                MessageBox(false, true, false,
                           GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
                return(false);
            }
        }

        return(true);
    }
コード例 #10
0
    public void EncapsulationData()
    {
        //string selectDate;//选择的时间
        string whereStr;
        string orderBy;

        if (this.KeyId == string.Empty) //Tasks的billing相关信息,在billing页面完成
        {
            GetDataFromCookie();        //从cookies读取数据
        }
        else
        {
            SchedulerObj = new tblScheduler();
            //HttpCookie BuckupSettingData = Request.Cookies.Get("BuckupSetting");
            //if (BuckupSettingData != null)
            //{
            //    System.Guid KeyIdGuid = new Guid(BuckupSettingData.Values["BackupId"]);
            //    SchedulerObj.BackupID = KeyIdGuid;
            //}
        }

        whereStr                  = "";
        orderBy                   = "it.EmailFrom desc";
        BLL_ScheduleTasks         = new ScheduleTasksBLL();
        vBackupAndEmailSettingObj = BLL_ScheduleTasks.GetBackupAndEmailSetting(whereStr, orderBy);
        if (vBackupAndEmailSettingObj.Count() > 0)
        {
            foreach (var item in vBackupAndEmailSettingObj)
            {
                if (chkBDBB.Checked == true)
                {
                    SchedulerObj.BackupID = item.BackupID;
                }
                SchedulerObj.EmailID = item.EmailID;
            }
        }

        SchedulerObj.TaskName = rtxtTaskName.Text.Trim() + "-CreateSD";
        if (rcbScheduleType.SelectedItem != null)
        {
            SchedulerObj.ScheduleType = rcbScheduleType.SelectedItem.Value.Trim();
        }
        SchedulerObj.StartTime = rdStartTime.SelectedDate;

        //if (ckxlROOTD.Items.Count>0)
        //{
        //    selectDate = "#";
        //    for (int i = 0; i < ckxlROOTD.Items.Count; i++)
        //    {
        //        if (ckxlROOTD.Items[i].Selected == true)
        //        {
        //            selectDate += ckxlROOTD.Items[i].Value + "#";
        //        }
        //    }
        //    SchedulerObj.RunOnly = selectDate;
        //}
        SchedulerObj.RunOnlyStart = rdStartTime.SelectedDate; //运行开始时间
        SchedulerObj.RunOnlyEnd   = rdEndTime.SelectedDate;   //运行结束时间

        if (rcbAction.SelectedItem != null)
        {
            SchedulerObj.Action = rcbAction.SelectedItem.Value.Trim();
        }
        if (rcbPostAction.SelectedItem != null)
        {
            SchedulerObj.PostAction = rcbPostAction.SelectedItem.Value.Trim();
        }
    }
コード例 #11
0
    public void GridViewDataBinding()
    {
        Boolean       isExtit;
        StringBuilder jobExpetion;

        this.OrderBy = " it.StartTime desc ";
        string whereStr;

        whereStr          = "";
        BLL_ScheduleTasks = new ScheduleTasksBLL();
        SchedulerObjList  = BLL_ScheduleTasks.GetSchedulers(whereStr, OrderBy);//查询SD的job信息

        BLL_vSysJobs = new vSysJobsBLL();
        if (SchedulerObjList.Count() > 0)
        {
            BLL_ScheduleLog = new vScheduleLogBLL();
            TasksTempList   = new List <TasksTemp>();

            foreach (tblScheduler item in SchedulerObjList)
            {
                this.OrderBy = " it.name desc";
                whereStr     = " and it.name='" + item.TaskName + "'";

                vSysJobsObjs = BLL_vSysJobs.GetVSysJobs(whereStr, this.OrderBy);

                if (vSysJobsObjs.Count() > 0)
                {//job存在
                    foreach (vSchedulerTasks Temp in vSysJobsObjs)
                    {
                        TasksTempObj              = new TasksTemp();
                        TasksTempObj.ScheduleID   = item.ScheduleID;
                        TasksTempObj.TaskName     = item.TaskName.Substring(0, item.TaskName.LastIndexOf("-"));//截取-CreateSD;
                        TasksTempObj.ScheduleType = item.ScheduleType;
                        TasksTempObj.Enable       = Temp.enabled;
                        if (TasksTempObj.Enable.Equals(1))
                        {//job运行
                            TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
                            TasksTempObj.Status         = "Enable";
                        }
                        else
                        {//job停止运行
                            TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
                            TasksTempObj.Status         = "Disable";
                        }
                        TasksTempObj.Next_run_date = Temp.RunOnlyEnd.ToString();
                        TasksTempObj.Last_run_date = Temp.RunOnlyStart.ToString();

                        TasksTempObj.LogResult = BLL_ScheduleLog.FindJobResultByScheduleId(
                            item.ScheduleID.ToString(),
                            item.RunOnlyStart.ToString(),
                            item.RunOnlyEnd.ToString());
                    }
                    TasksTempList.Add(TasksTempObj);
                }
                else
                {//job不存在
                    TasksTempObj                = new TasksTemp();
                    TasksTempObj.ScheduleID     = item.ScheduleID;
                    TasksTempObj.TaskName       = item.TaskName.Substring(0, item.TaskName.LastIndexOf("-"));//截取-CreateSD;;
                    TasksTempObj.ScheduleType   = item.ScheduleType;
                    TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
                    TasksTempObj.Status         = "Disable";
                    TasksTempList.Add(TasksTempObj);
                }
            }
        }

        this.OrderBy  = " it.name desc";
        whereStr      = "";
        vOnlyJobsObjs = BLL_vSysJobs.GetVOnlyJobs(whereStr, this.OrderBy);//查询job的系统信息

        jobExpetion = new StringBuilder();
        foreach (vOnlySysJobs job in vOnlyJobsObjs)
        {
            isExtit = SchedulerObjList.Any(it => it.TaskName == job.name); //在SD中是否存在相应的Taskname
            if (!isExtit)                                                  //不存在
            {
                if (job.name.IndexOf("-CreateSD") > 0)                     //是否SD创建
                {
                    pnlMessage.Visible = true;                             //显示提示信息
                    //在系统中存在为-CreateSD结尾的job但是在SD数据库中不存在
                    if (jobExpetion.ToString() == string.Empty)
                    {
                        jobExpetion.Append("Job Excepetion:" + " ");
                        jobExpetion.Append("\"" + job.name + "\"");
                    }
                    else
                    {
                        jobExpetion.Append(",\"" + job.name + "\"");
                    }
                }
            }
        }
        if (pnlMessage.Visible == true && SuccessFlag == null)//显示异常job信息
        {
            jobExpetion.Append(" ");
            jobExpetion.Append(GetGlobalResourceObject("WebResource", "ScheduleTasksForm_JobExcepeciton_Message").ToString());
            MessageBox(false, true, false,
                       jobExpetion.ToString());
        }
        else
        {
            pnlMessage.Visible = false;
        }

        RadGrid.DataSource = TasksTempList;
    }
コード例 #12
0
    protected void RadGrid_DeleteCommand(object sender, GridCommandEventArgs e)
    {
        string strWhere;
        string getScheduleID;//获取的绑定MasterTableView的Guid值

        getScheduleID = (e.Item as GridDataItem).GetDataKeyValue("ScheduleID").ToString();

        BLL_ScheduleTasks = new ScheduleTasksBLL();
        SchedulerObj      = BLL_ScheduleTasks.FindSchedulerById(getScheduleID);

        this.OrderBy = " it.name desc ";
        strWhere     = " and it.name='" + SchedulerObj.TaskName + "'";
        BLL_vSysJobs = new vSysJobsBLL();
        vSysJobsObjs = BLL_vSysJobs.GetVSysJobs(strWhere, this.OrderBy);

        if (vSysJobsObjs.Count() > 0)
        {
            BLL_JOB = new JOB();
            count   = BLL_JOB.DeleteJob(SchedulerObj.JobID.ToString()); //删除job

            if (count == 1)                                             //删除作业成功
            {
                successFlag = BLL_ScheduleTasks.LogicDelete(getScheduleID);
                if (!successFlag.Equals("InsertError"))//删除ScheduleTasks内的数据成功
                {
                    GridViewDataBinding();

                    //删除ScheduleTask数据成功
                    MessageBox(true, false, false,
                               GetGlobalResourceObject("WebResource", "ScheduleTasksForm_DeleteTasksMessage_RightMessage").ToString());
                    Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "reload", "<script>window.location=window.self.location;</script>");//强制刷页
                }
                else
                {
                    //删除ScheduleTask数据失败
                    MessageBox(false, false, true,
                               GetGlobalResourceObject("WebResource", "ScheduleTasksForm_DeleteTasksMessage_ErrorMessage").ToString());
                }
            }
            else
            {
                //删除job失败
                MessageBox(false, false, true,
                           GetGlobalResourceObject("WebResource", "ScheduleTasksForm_DeleteJobMessage_ErrorMessage").ToString());
            }
        }
        else
        {
            successFlag = BLL_ScheduleTasks.LogicDelete(getScheduleID);
            if (!successFlag.Equals("InsertError"))//删除ScheduleTasks内的数据成功
            {
                GridViewDataBinding();

                //删除ScheduleTask数据成功
                MessageBox(true, false, false,
                           GetGlobalResourceObject("WebResource", "ScheduleTasksForm_DeleteTasksMessage_RightMessage").ToString());
                Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "reload", "<script>window.location=window.self.location;</script>");//强制刷页
            }
            else
            {
                //删除ScheduleTask数据失败
                MessageBox(false, false, true,
                           GetGlobalResourceObject("WebResource", "ScheduleTasksForm_DeleteTasksMessage_ErrorMessage").ToString());
            }
        }
    }