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; }