//修改重大节点表的信息 public void Update(ProjectImportantNode pin) { try { ProjectImportantNode npin = dbcontext.ProjectImportantNodeContext.Find(pin.ProjectImportantNodeID); npin.MissionName = pin.MissionName; //npin.Time = pin.Time; npin.ProjectID = pin.ProjectID; npin.Remark = pin.Remark; npin.SecrecyLevel = pin.SecrecyLevel; npin.CompleteSpecificPerson = pin.CompleteSpecificPerson; npin.EndTime = pin.EndTime; npin.PersonCharge = pin.PersonCharge; npin.ActualComleption = pin.ActualComleption; npin.ProjectCompletion = pin.ProjectCompletion; npin.ResearchCharge = pin.ResearchCharge; npin.StartTime = pin.StartTime; dbcontext.SaveChanges(); } catch (System.Data.SqlClient.SqlException e) { throw e; } }
//保存 protected void Save_Click(object sender, EventArgs e) { try { //if (MissionName.Text.Trim() == "") //{ // Alert.ShowInTop("节点名称不能为空!"); // MissionName.Text = ""; // return; //} ProjectImportantNode Important = new ProjectImportantNode(); Important.MissionName = MissionName.Text.Trim(); Important.ProjectID = bllProject.SelectProjectID(DropDownListProjectID.SelectedText.ToString()); //Important.Time = DatePickerTime.SelectedDate; Important.StartTime = DatePickerStartTime.SelectedDate; Important.EndTime = DatePickerEndTime.SelectedDate; Important.CompleteSpecificPerson = CompleteSpecificPerson.Text.Trim(); //lby ↓ Important.ResearchCharge = Agency.SelectedText; Important.PersonCharge = txtPersonCharge.Text.Trim(); Important.ActualComleption = txtActualComleption.Text.Trim(); Important.ProjectCompletion = txtProjectCompletion.Text.Trim(); Important.Remark = Remark.Text.Trim(); Important.SecrecyLevel = DropDownListSecrecyLevel.SelectedIndex + 1; Important.EntryPerson = bllImportant.FindProjectImportant(Convert.ToInt32(Session["ProjectImportantID"]), true).EntryPerson; if (Convert.ToInt32(Session["SecrecyLevel"]) == 5) { Important.ProjectImportantNodeID = Convert.ToInt32(Session["ProjectImportantID"]); Important.IsPass = true; bllImportant.Update(Important); //插入项目重大节点表 //bllImportant.ChangePass(Convert.ToInt32(Session["ProjectImportantID"]), false); PageContext.RegisterStartupScript(ActiveWindow.GetConfirmHideRefreshReference() + Alert.GetShowInTopReference("项目重大节点修改完成!")); } else { bllImportant.ChangePass(Convert.ToInt32(Session["ProjectImportantID"]), false); Important.IsPass = false; bllImportant.insert(Important);//插入项目重大节点表 OperationLog operate = new OperationLog(); operate.LoginName = Important.EntryPerson; operate.OperationType = "更新"; operate.OperationContent = "ProjectImportantNode"; operate.OperationDataID = Convert.ToInt32(Session["ProjectImportantID"]); operate.LoginIP = ""; operate.OperationTime = DateTime.Now; operate.Remark = Important.ProjectImportantNodeID.ToString(); bllOperate.Insert(operate);//插入操作日志表 PageContext.RegisterStartupScript(ActiveWindow.GetConfirmHideRefreshReference() + Alert.GetShowInTopReference("您的操作已提交审核,请等待!")); } } catch (Exception ex) { publicmethod.SaveError(ex, this.Request); } }
/// <summary> /// 录入重要时间节点机任务,向项目重大节点表中插入数据(包括暂停项目,中止项目,验收项目) /// </summary> /// <param name="important"></param> public void insert(ProjectImportantNode important) { try { dbcontext.ProjectImportantNodeContext.Add(important); dbcontext.SaveChanges(); } catch (System.Data.SqlClient.SqlException e) { throw e; } }
//删除重大节点表的一条信息 public bool Delete(int projectimportantnodeid) { if (projectimportantnodeid != 0) { ProjectImportantNode pi = dbcontext.ProjectImportantNodeContext.Where(u => u.ProjectImportantNodeID == projectimportantnodeid).FirstOrDefault(); dbcontext.ProjectImportantNodeContext.Attach(pi); dbcontext.ProjectImportantNodeContext.Remove(pi); dbcontext.SaveChanges(); return(true); } else { return(false); } }
//将表中的审核状态变为False public bool ChangePass(int ProjectID, bool ispass) { try { ProjectImportantNode project = dbcontext.ProjectImportantNodeContext.Find(ProjectID); if (project == null) { return(false); } project.IsPass = ispass; dbcontext.SaveChanges(); return(true); } catch (System.Data.SqlClient.SqlException e) { throw e; } }
public void BindData() { try { ProjectImportantNode Important = bllImportant.FindProjectImportant(Convert.ToInt32(Session["ProjectImportantID"]), true); MissionName.Text = Important.MissionName; //DatePickerTime.SelectedDate = Important.Time.Value; DatePickerStartTime.SelectedDate = Important.StartTime.Value; DatePickerEndTime.SelectedDate = Important.EndTime.Value; txtPersonCharge.Text = Important.PersonCharge; txtActualComleption.Text = Important.ActualComleption; txtProjectCompletion.Text = Important.ProjectCompletion; CompleteSpecificPerson.Text = Important.CompleteSpecificPerson; DropDownListProjectID.SelectedValue = bllProject.SelectProjectName(Convert.ToInt32(Important.ProjectID)); DropDownListSecrecyLevel.SelectedIndex = Convert.ToInt32(Important.SecrecyLevel - 1); Remark.Text = Important.Remark; } catch (Exception ex) { publicmethod.SaveError(ex, this.Request); ; } }