//添加参与人员
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", "保存成功");
}
