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>
/// 创建新的 tblScheduler 对象。
/// </summary>
/// <param name="scheduleID">ScheduleID 属性的初始值。</param>
public static tblScheduler CreatetblScheduler(global::System.Guid scheduleID)
{
tblScheduler tblScheduler = new tblScheduler();
tblScheduler.ScheduleID = scheduleID;
return tblScheduler;
}
/// <summary>
/// 用于向 tblScheduler EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTotblScheduler(tblScheduler tblScheduler)
{
base.AddObject("tblScheduler", tblScheduler);
}
protected void GetData()
{
if (this.KeyId!=string.Empty)
{
BLL_ScheduleTasks = new ScheduleTasksBLL();
SchedulerObj=BLL_ScheduleTasks.FindSchedulerById(this.KeyId);
}
}
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());
}
}
/// <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 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;
}
/// <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;
}
