//添加参与人员 protected void Button1_Click(object sender, EventArgs e) { //获取到选择人员的Id int personId = Convert.ToInt32(DropDownList1.SelectedValue); int itemId = Convert.ToInt32(Label1.Text); //判断是否存在 var isExit = DB.ItemPersonnel.FirstOrDefault(a => a.ItemId == itemId && a.PersonId == personId); if (isExit != null) { Message("该人员已经加入改项目,不需要重复添加!", false); return; } //添加 ItemPersonnel itemPerson = new ItemPersonnel(); itemPerson.ItemId = itemId; itemPerson.PersonId = personId; itemPerson.OperTime = DateTime.Now; DB.ItemPersonnel.Add(itemPerson); DB.SaveChanges(); Message("添加成功", false); Response.Redirect(Request.Url.ToString()); }
//项目申报 protected void Button1_Click(object sender, EventArgs e) { if (Request.QueryString["type"] != null) { //添加 if (!FileUpload2.HasFile && string.IsNullOrEmpty(Label1.Text)) { Message("请上传详细材料", false); return; } //更新 int id = Convert.ToInt32(Request.QueryString["id"].ToString()); var Item = DB.ResearchItem.FirstOrDefault(a => a.Id == id);//获取对象 Item.ItemName = ItemName.Text; Item.ItemType = ItemType.Text; Item.ItemCompany = ItemCompany.Text; Item.MajorPerson = MajorPerson.Text; Item.Tel = Tel.Text; Item.Funds = Convert.ToDecimal(Funds.Text); Item.ExeYear = Convert.ToInt32(ExeYear.Text); if (FileUpload2.HasFile) { string fileName = string.Empty; Item.UpFile = FileUp.SaveFile(FileUpload2, Server.MapPath("~/UpFile/"), ref fileName); Item.FileName = fileName; } Item.State = "暂存"; //更新数据 DB.Entry(Item).State = EntityState.Modified; DB.SaveChanges(); } else { //添加 if (!FileUpload1.HasFile) { Message("请上传详细材料"); return; } ResearchItem Item = new ResearchItem(); Item.PersonId = Convert.ToInt32(Session["PersonId"]); Item.ItemName = ItemName.Text; Item.ItemType = ItemType.Text; Item.ItemCompany = ItemCompany.Text; Item.MajorPerson = MajorPerson.Text; Item.Tel = Tel.Text; Item.Funds = Convert.ToDecimal(Funds.Text); Item.ExeYear = Convert.ToInt32(ExeYear.Text); string fileName = string.Empty; Item.UpFile = FileUp.SaveFile(FileUpload1, Server.MapPath("~/UpFile/"), ref fileName); Item.FileName = fileName; Item.OperTime = DateTime.Now; Item.State = "暂存"; //插入数据 DB.ResearchItem.Add(Item); DB.SaveChanges(); //将自己作为参与人员 ItemPersonnel itemPerson = new ItemPersonnel(); itemPerson.ItemId = Item.Id; itemPerson.PersonId = Convert.ToInt32(Session["PersonId"]); itemPerson.OperTime = DateTime.Now; DB.ItemPersonnel.Add(itemPerson); DB.SaveChanges(); } Message("/ResearchItemPage/Manage.aspx", "保存成功"); }