//
// GET: /projMeeting/Edit/5
public ActionResult Edit(int id)
{
List <ProjMeeting> rm = dbContext.ProjMeetings.ToList();
ProjMeeting projMeeting = rm.Find(a => a.MeetingID == id);
if (projMeeting == null)
{
return(View());
}
//项目列表
List <Proj> ls1 = dbContext.Projs.ToList();
SelectList sl2 = null;
sl2 = new SelectList(ls1, "ProjID", "ProjName");
ViewBag.ProjList = sl2;
// 会议类型列表
ViewBag.MeetingTypeList = MyTools.GetSelectList(Constants.MeetingTypeList);
// 需求会议评审结果列表
ViewBag.ReviewConclusionList = MyTools.GetSelectList(Constants.ReviewConclusionList);
// 需求会议当前状态列表
ViewBag.StatList = MyTools.GetSelectList(Constants.StatList);
return(View(projMeeting));
}
//
// GET: /projMeeting/Details/5
public ActionResult Details(int id)
{
List <ProjMeeting> ls = dbContext.ProjMeetings.ToList();
ProjMeeting projMeeting = ls.Find(a => a.MeetingID == id);
if (projMeeting == null)
{
return(View());
}
return(View(projMeeting));
}
public string Edit(ProjMeeting projMeeting)
{
try
{
dbContext.Entry(projMeeting).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
return(Constants.AJAX_EDIT_SUCCESS_RETURN);
}
catch (Exception e1)
{
return("<p class='alert alert-danger'>出错了: " + e1.Message + "</p>");
}
}
public string Create(ProjMeeting projMeeting)
{
try
{
dbContext.ProjMeetings.Add(projMeeting);
dbContext.SaveChanges();
return(Constants.AJAX_CREATE_SUCCESS_RETURN);
}
catch (Exception e1)
{
return("<p class='alert alert-danger'>出错了: " + e1.Message + "</p>");
}
}
/// <summary>
/// 需求会议导入
/// </summary>
/// <param name="worksheet"></param>
/// <param name="fileName"></param>
/// <returns></returns>
private string ProjMeetingExcel(ExcelWorksheet worksheet, string fileName)
{
int rowStart = worksheet.Dimension.Start.Row; //工作区开始行号
int rowEnd = worksheet.Dimension.End.Row; //工作区结束行号
var ls = this.GetProjList();
for (int row = rowStart + 1; row <= rowEnd; row++)
{
// 第一列为空则结束
if (worksheet.Cells[row, 1] == null)
{
break;
}
// 第1列，项目名称
string projName = worksheet.Cells[row, 1].GetValue <string>();
// 项目名称转ProjID
var p = ls.Find(a => a.ProjName == projName);
int projId = p == null ? 0 : p.ProjID;
ProjMeeting r = new ProjMeeting();
r.ProjID = projId;
r.MeetingTopic = worksheet.Cells[row, 2].GetValue <string>();
r.MeetingType = worksheet.Cells[row, 3].GetValue <string>();
r.HostDept = worksheet.Cells[row, 4].GetValue <string>();
r.HostPerson = worksheet.Cells[row, 5].GetValue <string>();
r.ReviewExpert = worksheet.Cells[row, 6].GetValue <string>();
r.Participants = worksheet.Cells[row, 7].GetValue <string>();
r.NoticeNo = worksheet.Cells[row, 9].GetValue <string>();
r.ReviewConclusion = worksheet.Cells[row, 10].GetValue <string>();
r.MeetingConclusion = worksheet.Cells[row, 11].GetValue <string>();
r.Remark = worksheet.Cells[row, 12].GetValue <string>();
string meetingDate = worksheet.Cells[row, 8].GetValue <string>();
if (!string.IsNullOrEmpty(meetingDate))
{
r.MeetingDate = DateTime.Parse(meetingDate);
}
dbContext.ProjMeetings.Add(r);
}
// 保存
int realNum = dbContext.SaveChanges();
return(string.Format("<p class='alert alert-success'>《{0}》处理成功！共{1}条数据，实际导入{2}条数据</p>", fileName, rowEnd - rowStart, realNum));
}
//
// GET: /projMeeting/Delete/5
public string Delete(int id)
{
try
{
List <ProjMeeting> ls = dbContext.ProjMeetings.ToList();
ProjMeeting projMeeting = ls.Find(a => a.MeetingID == id);
dbContext.Entry(projMeeting).State = System.Data.Entity.EntityState.Deleted;
dbContext.SaveChanges();
return("删除成功");
}
catch (Exception e1)
{
return("出错了: " + e1.Message);
}
}
