//修改重大节点表的信息
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); ;
}
}
