protected void btnAdd_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
User user = dc.User.SingleOrDefault(_user => _user.F_userName.Equals(txtName.Text));
if (user != null)
{
Response.Write("<script>alert('该用户名已被使用');</script>");
return;
}
user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_status = ddlStatus.SelectedValue;
user.F_belongDeptID = ddlBelongDept.SelectedValue;
user.F_workDept = ddlBelongDept.SelectedItem.Text;
user.F_Role = ddlRole.SelectedValue;
user.F_realName = txtRealName.Text;
user.F_pwd = UtilHelper.MD5Encrypt(txtPwd.Text);
user.F_userName = txtName.Text;
user.F_lastModifyTime = DateTime.Now;
//user.F_belongUnitID = Session[SessionMgm.UnitID].ToString();
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
String[] units = txtUnitName.Text.Trim().Split(new char[] { '\n' });
String[] admins = txtAdminName.Text.Trim().Split(new char[] { '\n' });
if (units.Length != admins.Length)
{
UtilHelper.AlertMsg("error");
}
else
{
DataClassesDataContext dc = new DataClassesDataContext();
for (int i = 0; i < units.Length; i++)
{
ApplicantUnit unit = new ApplicantUnit();
unit.F_ID = UnitService.GetID();
unit.F_name = units[i];
unit.F_status = RoleType.Authoried;
unit.F_seq = UnitService.GetSeq();
admins[i] = admins[i].Trim();
EducationV2.User user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_userName = admins[i];
if (dc.User.SingleOrDefault(_user => _user.F_userName.Equals(admins[i])) != null)
{
Response.Write("重复");
return;
}
user.F_realName = admins[i];
user.F_pwd = UtilHelper.MD5Encrypt("000000");
user.F_status = RoleType.Authoried;
user.F_Role = RoleType.SchoolAdmin;
user.F_belongUnitID = unit.F_ID;
dc.ApplicantUnit.InsertOnSubmit(unit);
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
}
}
}
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();
}
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, 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);
}
