public async Task <IActionResult> acceptApplicant(AcceptApplicant applicant)
{
var alreadyMember = _context.ProfileEnsembles.Where(p => p.EnsembleId == int.Parse(applicant.EnsembleId) && p.ProfileId == int.Parse(applicant.ProfileId)).ToList();
if (alreadyMember.Count() >= 1)
{
return(NoContent());
}
var profile = _context.Profiles.Where(p => p.ProfileId == int.Parse(applicant.ProfileId)).ToList()[0];
ProfileEnsemble profens = new ProfileEnsemble();
profens.Start_Date = System.DateTime.Now;
profens.End_Date = System.DateTime.MaxValue;
profens.ProfileId = profile.ProfileId;
profens.Profile = profile;
profens.Ensemble = _context.Ensembles.Find(int.Parse(applicant.EnsembleId));
profens.EnsembleId = int.Parse(applicant.EnsembleId);
if (ModelState.IsValid)
{
_context.Add(profens);
await _context.SaveChangesAsync();
}
return(NoContent());
}
private void Commit()
{
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
exs.F_status = ProjectStatus.UnderEducationAudit;
dc.SubmitChanges();
}
private string GetStatus()
{
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
return(exs.F_status);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
AcceptApplicant es = dc.AcceptApplicant.SingleOrDefault(ess => ess.F_projectID.Equals(projectID));
es.F_status = ProjectStatus.UnderEducationAudit;
dc.SubmitChanges();
Response.Redirect("frmAcceptApplicant.aspx");
}
private void SavePage3()
{
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
exs.F_actualAchieve = paras["F_actualAchieve"].ToString();
exs.F_achieveBenefit = paras["F_achieveBenefit"].ToString();
dc.SubmitChanges();
}
private string GetBaseInfo()
{
String result;
context.Response.ContentType = "application/json";
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
result = UtilHelper.GetJSON(exs);
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
AcceptApplicant es = dc.AcceptApplicant.SingleOrDefault(ess => ess.F_projectID.Equals(projectID));
if (String.IsNullOrEmpty(txtAppliedDate.Text) == false)
{
es.F_appliedDate = DateTime.Parse(txtAppliedDate.Text);
}
dc.SubmitChanges();
Response.Redirect("frmAcceptApplicant.aspx");
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
if (!IsPostBack)
{
bool showSave = false, showCommit = false;
String fileName = Request.Path;
fileName = fileName.Substring(fileName.IndexOf(Tag) + Tag.Length);
String strPageIndex = fileName.Substring(0, fileName.IndexOf('.'));
int pageIndex = int.Parse(strPageIndex);
String F_ID = Session[SessionMgm.ProjectID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
AcceptApplicant aap = dc.AcceptApplicant.SingleOrDefault(_ap => _ap.F_ID.Equals(F_ID));
if (aap == null)
{
showSave = true;
}
else
{
if (Session[SessionMgm.UserID].Equals(aap.F_leaderID))
{
showSave = true;
showCommit = true;
}
if (aap.F_status.Equals(ProjectStatus.Deny) == false && aap.F_status.Equals(ProjectStatus.Draft) == false)
{
showCommit = false;
showSave = false;
}
}
if (showSave)
{
litContent = "<input id='btnSave' type='button' value='保 存' onclick='savePage(" + pageIndex + ")' class='btn' /> ";
}
if (showCommit)
{
litContent += " <input id='btnSubmit' type='button' value='提 交' onclick='commit(" + pageIndex + ")' class='btn' />";
}
if (litContent.Length > 0)
{
litContent = " <div class='systitleline'>" + litContent + "</div>";
}
}
}
private void SavePage2()
{
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
if (String.IsNullOrEmpty(paras["F_acceptDate"].ToString()) == false)
{
exs.F_acceptDate = DateTime.Parse(paras["F_acceptDate"].ToString());
}
exs.F_acceptType = paras["F_acceptType"].ToString();
exs.F_acceptPlace = paras["F_acceptPlace"].ToString();
exs.F_acceptContact = paras["F_acceptContact"].ToString();
exs.F_acceptPhone = paras["F_acceptPhone"].ToString();
exs.F_acceptEmail = paras["F_acceptEmail"].ToString();
exs.F_acceptAddress = paras["F_acceptAddress"].ToString();
exs.F_acceptZipcode = paras["F_acceptZipcode"].ToString();
dc.SubmitChanges();
}
private void SavePage5()
{
DataClassesDataContext dc = new DataClassesDataContext();
String projectID = context.Session[SessionMgm.AcceptProjectID].ToString();
AcceptApplicant exs = dc.AcceptApplicant.SingleOrDefault(es => es.F_projectID.Equals(projectID));
exs.F_acceptOpinion = paras["F_acceptOpinion"].ToString();
exs.F_acceptLeader = paras["F_acceptLeader"].ToString();
if (String.IsNullOrEmpty(paras["F_acceptLeaderDate"].ToString()) == false)
{
exs.F_acceptLeaderDate = DateTime.Parse(paras["F_acceptLeaderDate"].ToString());
}
if (paras["F_acceptPass"].ToString() == "1")
{
exs.F_status = ProjectStatus.PassEduCheck;
}
else
{
exs.F_status = ProjectStatus.Deny;
}
dc.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
projectID = Session[SessionMgm.AcceptProjectID].ToString();
if (!IsPostBack)
{
DataClassesDataContext dc = new DataClassesDataContext();
AcceptApplicant es = dc.AcceptApplicant.SingleOrDefault(ess => ess.F_projectID.Equals(projectID));
labAcceptNo.Text = es.F_acceptNo;
labDomain.Text = es.F_domain;
labProjectName.Text = es.F_name;
labType.Text = es.F_type;
labUnit.Text = es.F_projectUnit;
labLeader.Text = es.F_leaderName;
if (es.F_appliedDate != null)
{
txtAppliedDate.Text = es.F_appliedDate.Value.ToShortDateString();
}
if (es.F_status.Equals(ProjectStatus.UnderEducationAudit))
{
btnSave.Visible = false;
btnSubmit.Visible = false;
}
}
}
public static void CreateAcceptProject(DataClassesDataContext dc, ScienceProject project)
{
var aps = dc.AcceptProject.Where(apss => apss.F_projectID.Equals(project.F_ID));
dc.AcceptProject.DeleteAllOnSubmit(aps);
AcceptProject acceptProject = new AcceptProject();
EducationV2.User user = dc.User.SingleOrDefault(us => us.F_ID.Equals(project.F_leaderID));
int num = dc.AcceptProject.Count();
acceptProject.F_ID = Guid.NewGuid().ToString();
acceptProject.F_acceptApplicantState = ProjectStatus.Draft;
acceptProject.F_acceptedCode = "";
acceptProject.F_acceptNo = DateTime.Now.ToString("yyyyMMddhh") + num.ToString();
acceptProject.F_applicantUnit = user.F_adminUnit;
acceptProject.F_appliedDate = project.F_applicantDate;
if (project.F_applicantDate != null)
{
acceptProject.F_appliedYear = project.F_applicantDate.Value.Year.ToString();
}
acceptProject.F_executeState = ProjectStatus.Draft;
acceptProject.F_leaderName = user.F_userName;
acceptProject.F_leaderID = project.F_leaderID;
acceptProject.F_projectID = project.F_ID;
acceptProject.F_projectName = project.F_name;
if (project.F_finishDate != null)
{
acceptProject.F_finishDate = project.F_finishDate.Value;
if (DateTime.Now < project.F_finishDate.Value)
{
acceptProject.F_projectState = "在研";
}
else
{
acceptProject.F_projectState = "到期未验收";
}
}
acceptProject.F_projectType = project.F_type;
dc.AcceptProject.InsertOnSubmit(acceptProject);
var aas = dc.AcceptApplicant.Where(_aa => _aa.F_projectID.Equals(project.F_ID));
dc.AcceptApplicant.DeleteAllOnSubmit(aas);
AcceptApplicant aa = new AcceptApplicant();
aa.F_ID = Guid.NewGuid().ToString();
aa.F_type = project.F_type;
aa.F_domain = project.F_belongeddomain;
aa.F_name = project.F_name;
aa.F_acceptNo = acceptProject.F_acceptNo;
aa.F_leaderName = user.F_realName;
aa.F_projectUnit = user.F_adminUnit;
if (project.F_totalFund != null)
{
aa.F_totalFund = decimal.Parse(project.F_totalFund.Value.ToString());
}
aa.F_projectID = project.F_ID;
aa.F_projectObject = project.F_finalOutput;
aa.F_cooperator = project.F_majorCooperator;
aa.F_status = EducationV2.App_Code.ProjectStatus.Draft;
if (project.F_applicantDate != null && project.F_finishDate != null)
{
aa.F_startStopDate = project.F_applicantDate.Value.ToShortDateString() + "-" + project.F_finishDate.Value.ToShortDateString();
}
aa.F_leaderID = user.F_ID;
dc.AcceptApplicant.InsertOnSubmit(aa);
dc.SubmitChanges();
}
private void CreateAcceptProject(DataClassesDataContext dc, ScienceProject project)
{
var aps = dc.AcceptProject.Where(apss => apss.F_projectID.Equals(project.F_ID));
dc.AcceptProject.DeleteAllOnSubmit(aps);
AcceptProject acceptProject = new AcceptProject();
EducationV2.User user = dc.User.SingleOrDefault(us => us.F_ID.Equals(project.F_leaderID));
EducationV2.ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_ID.Equals(user.F_belongUnitID));
int num = dc.AcceptProject.Count();
acceptProject.F_ID = Guid.NewGuid().ToString();
acceptProject.F_acceptApplicantState = ProjectStatus.Complete;
acceptProject.F_acceptedCode = "";
acceptProject.F_applicantUnit = unit.F_name;
acceptProject.F_acceptNo = DateTime.Now.ToString("yyyyMMddhh") + num.ToString();
acceptProject.F_applicantUnit = user.F_adminUnit;
acceptProject.F_appliedDate = project.F_applicantDate;
acceptProject.F_appliedYear = project.F_applicantDate.Value.Year.ToString();
acceptProject.F_executeState = ProjectStatus.Complete;
acceptProject.F_leaderName = user.F_userName;
acceptProject.F_leaderID = project.F_leaderID;
acceptProject.F_projectID = project.F_ID;
acceptProject.F_projectName = project.F_name;
acceptProject.F_finishDate = project.F_finishDate.Value;
acceptProject.F_projectState = ProjectStatus.Complete;
acceptProject.F_projectType = project.F_type;
dc.AcceptProject.InsertOnSubmit(acceptProject);
var ess = dc.ExecuteStatus.Where(_es => _es.F_projectID.Equals(project.F_ID));
dc.ExecuteStatus.DeleteAllOnSubmit(ess);
ExecuteStatus es = new ExecuteStatus();
es.F_acceptNo = acceptProject.F_acceptNo;
es.F_planMoney = Decimal.ToInt32(project.F_totalFund.Value);
es.F_applicantName = project.F_name;
es.F_applicantType = project.F_type;
es.F_applicantUnit = user.F_adminUnit;
es.F_ContactPhone = user.F_phone;
es.F_domain = project.F_belongeddomain;
es.F_ID = Guid.NewGuid().ToString();
es.F_leaderID = project.F_leaderID;
es.F_leaderName = project.F_leader;
es.F_leaderNo = user.F_idNumber;
es.F_mobile = user.F_mobile;
es.F_projectID = project.F_ID;
es.F_status = ProjectStatus.Complete;
es.F_startAndStopDate = project.F_beginDate.Value.ToShortDateString() + "-" + project.F_finishDate.Value.ToShortDateString();
dc.ExecuteStatus.InsertOnSubmit(es);
var aas = dc.AcceptApplicant.Where(_aa => _aa.F_projectID.Equals(project.F_ID));
dc.AcceptApplicant.DeleteAllOnSubmit(aas);
AcceptApplicant aa = new AcceptApplicant();
aa.F_ID = Guid.NewGuid().ToString();
aa.F_type = project.F_type;
if (String.IsNullOrEmpty(project.F_belongeddomain))
{
aa.F_domain = "未定义";
}
else
{
aa.F_domain = project.F_belongeddomain;
}
aa.F_name = project.F_name;
aa.F_acceptNo = acceptProject.F_acceptNo;
aa.F_leaderName = user.F_realName;
aa.F_projectUnit = user.F_adminUnit;
aa.F_projectUnit = unit.F_name;
aa.F_startStopDate = es.F_startAndStopDate;
aa.F_totalFund = decimal.Parse(project.F_totalFund.Value.ToString());
aa.F_projectID = project.F_ID;
aa.F_projectObject = project.F_finalOutput;
aa.F_cooperator = project.F_majorCooperator;
aa.F_status = EducationV2.App_Code.ProjectStatus.Complete;
aa.F_leaderID = user.F_ID;
aa.F_appliedDate = project.F_applicantDate;
dc.AcceptApplicant.InsertOnSubmit(aa);
}