protected void btnApproval_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> ids = GetSelectedIDs();
foreach (String id in ids)
{
ScienceProject sciProject = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (sciProject != null)
{
Services.SciProject.CreateAcceptProject(dc, sciProject);
sciProject.F_status = ProjectStatus.Approval;
dc.SubmitChanges();
}
else
{
SocialProject socialProject = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (socialProject != null)
{
Services.SocialProject.CreateAcceptProject(dc, socialProject);
socialProject.F_status = ProjectStatus.Approval;
dc.SubmitChanges();
}
}
}
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bool isVisible = false;
if (Session[SessionMgm.PageJumtType] == null)
{
return;
}
String jumpType = Session[SessionMgm.PageJumtType].ToString();
if (jumpType.Equals(PageJumpType.SCI))
{
String F_ID = Session[SessionMgm.SciProjectID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
ScienceProject sci = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_ID.Equals(F_ID));
if (sci != null)
{
if (sci.F_status.Equals(ProjectStatus.Deny) || sci.F_status.Equals(ProjectStatus.Draft))
{
if (sci.F_leaderID.Equals(Session[SessionMgm.UserID]))
{
isVisible = true;
}
}
}
}
else if (jumpType.Equals(PageJumpType.SOCIAL))
{
String F_ID = Session[SessionMgm.SocialProjectID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
SocialProject sci = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(F_ID));
if (sci != null)
{
if (sci.F_status.Equals(ProjectStatus.Deny) || sci.F_status.Equals(ProjectStatus.Draft))
{
if (sci.F_leaderID.Equals(Session[SessionMgm.UserID]))
{
isVisible = true;
}
}
}
}
else if (jumpType.Equals(PageJumpType.ASSIGN))
{
if (Session[SessionMgm.Role].Equals(RoleType.EduAdmin))
{
isVisible = true;
}
else
{
isVisible = false;
}
}
btnDel.Visible = isVisible;
btnAdd.Visible = isVisible;
btnRename.Visible = isVisible;
}
}
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.SocialProjectID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
SocialProject sciProject = dc.SocialProject.SingleOrDefault(c => c.F_ID.Equals(F_ID));
if (sciProject == null)
{
showSave = true;
}
else
{
if (Session[SessionMgm.UserID].Equals(sciProject.F_leaderID))
{
showSave = true;
ProjectDetail guide = dc.ProjectDetail.SingleOrDefault(pd => pd.F_ID.Equals(sciProject.F_guideProjectID));
if (guide != null && guide.F_startDate.Value.Date <= DateTime.Now.Date && DateTime.Now.Date <= guide.F_endDate.Value.Date)
{
showCommit = true;
}
}
if (sciProject.F_status.Equals(ProjectStatus.Deny) == false && sciProject.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 fillAudit(WordHelper helper, SocialProject project)
{
DataClassesDataContext dc = new DataClassesDataContext();
var deptAudit = dc.AuditOpinion.SingleOrDefault(ao => ao.F_projectID.Equals(project.F_ID) && ao.F_type.Equals(RoleType.DeptAdmin));
if (deptAudit != null)
{
helper.Replace("F_deptComment", deptAudit.F_content);
if (deptAudit.F_date != null)
{
helper.Replace("F_deptDate", deptAudit.F_date.Value.ToLongDateString());
}
}
var teamAudit = dc.AuditOpinion.SingleOrDefault(ao => ao.F_projectID.Equals(project.F_ID) && ao.F_type.Equals(RoleType.TeamAdmin));
if (teamAudit != null)
{
helper.Replace("F_teamComment", teamAudit.F_content);
if (teamAudit.F_date != null)
{
helper.Replace("F_teamDate", teamAudit.F_date.Value.ToLongDateString());
}
}
var schoAudit = dc.AuditOpinion.SingleOrDefault(ao => ao.F_projectID.Equals(project.F_ID) && ao.F_type.Equals(RoleType.SchoolAdmin));
if (schoAudit != null)
{
helper.Replace("F_scholComment", schoAudit.F_content);
if (schoAudit.F_date != null)
{
helper.Replace("F_scholDate", schoAudit.F_date.Value.ToLongDateString());
}
}
var eduAudit = dc.AuditOpinion.SingleOrDefault(ao => ao.F_projectID.Equals(project.F_ID) && ao.F_type.Equals(RoleType.EduAdmin));
if (eduAudit != null)
{
helper.Replace("F_eduComment", eduAudit.F_content);
if (eduAudit.F_date != null)
{
helper.Replace("F_eduDate", eduAudit.F_date.Value.ToLongDateString());
}
}
}
private void fillContent(WordHelper helper, SocialProject project)
{
String[] manualTypes = new String[] { "F_applicantDate", "F_completeDate" };
Type sciType = project.GetType();
System.Reflection.PropertyInfo[] properties = sciType.GetProperties();
foreach (System.Reflection.PropertyInfo property in properties)
{
if (property.GetValue(project, null) != null)
{
String value = property.GetValue(project, null).ToString();
String name = property.Name;
if (!manualTypes.Contains(name))
{
helper.Replace(name, value);
}
}
}
String F_type = "A类重点项目（ ）、一般项目（ ）、B类项目（ ）、委托项目（ ）";
switch (project.F_type)
{
case "A类重点项目": F_type = "A类重点项目（ √ ）、一般项目（ ）、B类项目（ ）、委托项目（ ）"; break;
case "一般项目": F_type = "A类重点项目（ ）、一般项目（ √ ）、B类项目（ ）、委托项目（ ）"; break;
case "B类项目": F_type = "A类重点项目（ ）、一般项目（ ）、B类项目（ √ ）、委托项目（ ）"; break;
case "委托项目": F_type = "A类重点项目（ ）、一般项目（ ）、B类项目（ ）、委托项目（ √ ）"; break;
}
helper.Replace("F_type1", F_type);
helper.Replace("F_name1", project.F_name);
helper.Replace("F_catogary1", project.F_catogary);
helper.Replace("F_applicantDate", project.F_applicantDate.Value.ToShortDateString());
helper.Replace("F_leader1", project.F_leader);
if (project.F_completeDate != null)
{
helper.Replace("F_completeDate", project.F_completeDate.Value.ToShortDateString());
}
helper.Replace("F_Fund2", project.F_Fund.ToString());
}
private void fillParticipants(WordHelper helper, SocialProject project)
{
DataClassesDataContext dc = new DataClassesDataContext();
var participants = dc.ApplicantMember.Where(am => am.F_applicantID.Equals(project.F_ID)).OrderBy(am => am.F_seq);
if (helper.FindCell("F_firstParticipant"))
{
for (int i = 0; i < participants.Count() - 5; i++)
{
helper.CreateNewRow();
}
helper.FindCell("F_firstParticipant");
int index = 0;
int count = participants.Count();
foreach (ApplicantMember member in participants)
{
index++;
helper.SetCellValue(member.F_realName);
helper.MoveNextCell();
helper.SetCellValue(member.F_sexual);
helper.MoveNextCell();
if (member.F_birthday != null)
{
helper.SetCellValue(member.F_birthday.Value.ToShortDateString());
}
helper.MoveNextCell();
helper.SetCellValue(member.F_title);
helper.MoveNextCell();
helper.SetCellValue(member.F_expert);
helper.MoveNextCell();
helper.SetCellValue(member.F_education);
helper.MoveNextCell();
helper.SetCellValue(member.F_degree);
helper.MoveNextCell();
helper.SetCellValue(member.F_workspace);
if (index < count)
{
helper.MoveNextCell();
}
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ret")
{
String role = Session[SessionMgm.Role].ToString();
String id = e.CommandArgument.ToString();
DataClassesDataContext dc = new DataClassesDataContext();
SocialProject project = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (project.F_status.Equals(ProjectStatus.UnderEducationAudit) && role.Equals(RoleType.SchoolAdmin))
{
project.F_status = ProjectStatus.UnderSchoolAudit;
}
else if (project.F_status.Equals(ProjectStatus.UnderSchoolAudit) && role.Equals(RoleType.DeptAdmin))
{
project.F_status = ProjectStatus.UnderDeptAudit;
}
else if (project.F_status.Equals(ProjectStatus.UnderDeptAudit) && role.Equals(RoleType.Expert))
{
project.F_status = ProjectStatus.Draft;
}
dc.SubmitChanges();
Response.Redirect("frmSocialProjectList.aspx");
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
WordHelper helper = new WordHelper();
String file = Server.MapPath("/resource/socialProject.dot");
helper.CreateNewWordDocument(file);
DataClassesDataContext dc = new DataClassesDataContext();
String F_ID = (sender as LinkButton).CommandArgument;
SocialProject project = dc.SocialProject.SingleOrDefault(sp => sp.F_ID.Equals(F_ID));
fillContent(helper, project);
fillParticipants(helper, project);
fillAudit(helper, project);
project.F_name = UtilHelper.getValidatePath(project.F_name);
String fileName = Server.MapPath("/resource/" + project.F_name + ".doc");
bool result = helper.SaveAs(fileName);
helper.Close();
Response.Clear();
Response.ContentType = "Application/msword";
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.HtmlEncode(Path.GetFileName(fileName)));
Response.TransmitFile(fileName);
Response.End();
}
protected void btnDeny_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> ids = GetSelectedIDs();
foreach (String id in ids)
{
ScienceProject sciProject = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (sciProject != null)
{
sciProject.F_status = ProjectStatus.Deny;
}
else
{
SocialProject socialProject = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (socialProject != null)
{
socialProject.F_status = ProjectStatus.Deny;
}
}
dc.SubmitChanges();
}
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String projectID = Session[SessionMgm.ProjectID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
String guideID = "";
ScienceProject sp = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_ID.Equals(projectID));
if (sp != null)
{
guideID = sp.F_guideProjectID;
}
else
{
SocialProject sop = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(projectID));
guideID = sop.F_guideProjectID;
}
IQueryable <AssignProject> assignProjects = dc.AssignProject.Where(_ap => _ap.F_authro.Value == true && _ap.F_projectID.Equals(guideID));
ddlDelegate.DataSource = assignProjects;
ddlDelegate.DataValueField = "F_unitID";
ddlDelegate.DataTextField = "F_unitName";
ddlDelegate.DataBind();
}
}
partial void DeleteSocialProject(SocialProject instance)
{
ExecuteDynamicDelete(instance);
LoggerHelper.Log("项目删除", "项目名:" + instance.F_name + ",ID：" + instance.F_ID);
}
protected void btnCommit_Click(object sender, EventArgs e)
{
String[] projects = txtName.Text.Trim().Split(new char[] { '\n' });
String[] units = txtUnit.Text.Trim().Split(new char[] { '\n' });
String[] leaders = this.txtLeader.Text.Trim().Split(new char[] { '\n' });
String[] funds = this.txtFund.Text.Trim().Split(new char[] { '\n' });
DateTime startDate = DateTime.Parse(txtStart.Text);
DateTime endDate = DateTime.Parse(txtEnd.Text);
if (projects.Length == units.Length && units.Length == leaders.Length)
{
DataClassesDataContext dc = new DataClassesDataContext();
for (int i = 0; i < projects.Length; i++)
{
try
{
units[i] = units[i].Trim().Replace("\"", "");
units[i] = units[i].Replace("\r", "").Trim();
units[i] = units[i].Replace(" ", "").Trim();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_name.Equals(units[i]));
if (unit == null)
{
unit = new ApplicantUnit();
unit.F_ID = Guid.NewGuid().ToString();
unit.F_name = units[i];
unit.F_status = RoleType.Authoried;
dc.ApplicantUnit.InsertOnSubmit(unit);
}
leaders[i] = leaders[i].Trim().Replace("\"", "");
leaders[i] = leaders[i].Replace(" ", "");
leaders[i] = leaders[i].Replace("\r", "").Trim();
EducationV2.User user = dc.User.SingleOrDefault(_user => _user.F_realName.Equals(leaders[i]) && _user.F_belongUnitID.Equals(unit.F_ID));
if (user == null)
{
user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_userName = leaders[i];
user.F_realName = leaders[i];
user.F_Role = RoleType.Expert;
user.F_belongUnitID = unit.F_ID;
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
}
if (ddlType.SelectedIndex < 4)
{
projects[i] = projects[i].Trim().Replace("\"", "");
projects[i] = projects[i].Replace("\r", "").Trim();
SocialProject project = dc.SocialProject.SingleOrDefault(_sp => _sp.F_name.Equals(projects[i]));
if (project != null)
{
continue;
}
project = new SocialProject();
project.F_unitID = unit.F_ID;
project.F_leader = user.F_realName;
project.F_leaderID = user.F_ID;
project.F_status = ProjectStatus.Approval;
project.F_guideProjectID = ddlGuide.SelectedValue;
project.F_code = EducationV2.Services.SocialProject.GetCode(ddlType.SelectedValue, txtYear.Text);
project.F_status = ProjectStatus.Approval;
if (txtSameFund.Text.Trim().Length > 0)
{
project.F_Fund = decimal.Parse(txtSameFund.Text);
}
else
{
project.F_Fund = decimal.Parse(funds[i]);
}
project.F_applicantDate = startDate;
project.F_completeDate = endDate;
project.F_type = ddlType.SelectedValue;
project.F_name = projects[i];
project.F_ID = Guid.NewGuid().ToString();
CreateAcceptProject(dc, project);
dc.SocialProject.InsertOnSubmit(project);
}
else
{
ScienceProject project = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_name.Equals(projects[i]));
if (project != null)
{
continue;
}
project = new ScienceProject();
project.F_unitID = unit.F_ID;
project.F_leader = user.F_realName;
project.F_leaderID = user.F_ID;
project.F_status = ProjectStatus.Approval;
project.F_guideProjectID = ddlGuide.SelectedValue;
project.F_code = EducationV2.Services.SciProject.GetCode(ddlType.SelectedValue, txtYear.Text);
project.F_status = ProjectStatus.Approval;
if (txtSameFund.Text.Trim().Length > 0)
{
project.F_totalFund = decimal.Parse(txtSameFund.Text);
}
else
{
project.F_totalFund = decimal.Parse(funds[i]);
}
project.F_beginDate = startDate;
project.F_applicantDate = startDate;
project.F_finishDate = endDate;
project.F_type = ddlType.SelectedValue;
project.F_name = projects[i];
project.F_ID = Guid.NewGuid().ToString();
dc.ScienceProject.InsertOnSubmit(project);
CreateAcceptProject(dc, project);
}
dc.SubmitChanges();
}
catch (Exception exp) {
Console.Write(exp.ToString());
}
}
}
else
{
UtilHelper.AlertMsg(Response, "name: " + projects.Length + " unit: " + units.Length + " leader: " + leaders.Length +
" fund: " + funds.Length);
UtilHelper.AlertMsg(Response, "inequal");
}
}
private void CreateAcceptProject(DataClassesDataContext dc, SocialProject 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_acceptNo = DateTime.Now.ToString("yyyyMMddhh") + num.ToString();
acceptProject.F_applicantUnit = unit.F_name;
acceptProject.F_appliedDate = project.F_applicantDate;
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;
acceptProject.F_finishDate = project.F_completeDate.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_Fund.Value);
es.F_applicantName = project.F_name;
es.F_applicantType = project.F_type;
es.F_applicantUnit = unit.F_name;
es.F_ContactPhone = user.F_phone;
es.F_domain = project.F_catogary;
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.Draft;
es.F_startAndStopDate = project.F_applicantDate.Value.ToShortDateString() + "-" + project.F_completeDate.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;
aa.F_domain = project.F_catogary;
if (String.IsNullOrEmpty(aa.F_domain))
{
aa.F_domain = "未定义";
}
aa.F_name = project.F_name;
aa.F_acceptNo = acceptProject.F_acceptNo;
aa.F_leaderName = user.F_realName;
aa.F_projectUnit = unit.F_name;
aa.F_appliedDate = project.F_applicantDate;
aa.F_startStopDate = es.F_startAndStopDate;
aa.F_totalFund = decimal.Parse(project.F_Fund.Value.ToString());
aa.F_projectID = project.F_ID;
aa.F_projectObject = project.F_achievement + ", 成果字数 " + project.F_wordCount;
aa.F_cooperator = project.F_teamName;
aa.F_status = EducationV2.App_Code.ProjectStatus.Draft;
aa.F_leaderID = user.F_ID;
dc.AcceptApplicant.InsertOnSubmit(aa);
}
