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());
}
}
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual Boolean UpdateInTaskView(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
Boolean flagSuccess = false;
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
//SchedulerObjUpdate.Action = SchedulerObj.Action;
//SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
//SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
//SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
//SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
//SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
//SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
//SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
//SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
SchedulerObjUpdate.JobID = SchedulerObj.JobID;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
flagSuccess = true;
return(flagSuccess);
}
return(flagSuccess);
}
/// <summary>
/// 插入的对象
/// </summary>
/// <param name="SchedulerObj">需要插入的对象</param>
/// <returns>受影响的行数</returns>
public virtual string Insert(tblScheduler SchedulerObj)
{
int counts; //影响行数标记
string strScheduleID; //插入对象的ID
string strErrorMessage = "InsertError";
SchedulerObj.ScheduleID = System.Guid.NewGuid();
//插入数据
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblScheduler.AddObject(SchedulerObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
if (counts > 0)
{
strScheduleID = SchedulerObj.ScheduleID.ToString();
return(strScheduleID);
}
return(strErrorMessage);
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string UpdateInTaskDetailForm(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
string strMessage = "UpdateError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
SchedulerObjUpdate.Action = SchedulerObj.Action;
SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.BackupID = SchedulerObj.BackupID;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "Update success";
return(strMessage);
}
return(strMessage);
}
protected void GetData()
{
if (this.KeyId != string.Empty)
{
BLL_ScheduleTasks = new ScheduleTasksBLL();
SchedulerObj = BLL_ScheduleTasks.FindSchedulerById(this.KeyId);
}
}
protected void GetDataFromCookie()
{
HttpCookie billingData = Request.Cookies.Get("Billing");
HttpCookie EmailSettingData = Request.Cookies.Get("EmailSetting");
SchedulerObj = new tblScheduler();
if (billingData != null)
{
SchedulerObj.Company = billingData.Values["Company"];
SchedulerObj.Cycle = billingData.Values["StartingCycle"] + "," + billingData.Values["EndingCycle"];
SchedulerObj.Status = billingData.Values["StatusCode"];
SchedulerObj.Copy = billingData.Values["Copy"];
SchedulerObj.Calc = billingData.Values["Calc"];
}
if (EmailSettingData != null)
{
SchedulerObj.EmailTo = EmailSettingData.Values["EmailTo"];
}
}
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());
}
}
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();
}
}
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());
}
}
}
