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); }
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()); } } }
protected void GetData() { if (this.KeyId != string.Empty) { BLL_ScheduleTasks = new ScheduleTasksBLL(); SchedulerObj = BLL_ScheduleTasks.FindSchedulerById(this.KeyId); } }
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); }
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(); } } }
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); }
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()); } }
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()); } } } } }
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); }
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(); } }
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; }
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()); } } }