private DataTable GetDatasource()
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> userIDs = Global.GetMinUsers(Session);
DataTable dt = new DataTable();
dt.Columns.Add("F_ID");
dt.Columns.Add("F_userName");
dt.Columns.Add("F_realName");
dt.Columns.Add("F_belongedUnit");
dt.Columns.Add("F_status");
dt.Columns.Add("F_role");
foreach (String userID in userIDs)
{
DataRow dr = dt.NewRow();
User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(userID));
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_un => _un.F_ID.Equals(user.F_belongUnitID));
dr[0] = userID;
dr[1] = user.F_userName;
dr[2] = user.F_realName;
if (unit != null)
{
dr[3] = unit.F_name;
}
dr[4] = user.F_status;
dr[5] = user.F_Role;
dt.Rows.Add(dr);
}
return(dt);
}
private string Initial()
{
context.Response.ContentType = "application/json";
DataClassesDataContext dc = new DataClassesDataContext();
String F_ID = context.Session[SessionMgm.VisitUnitID].ToString();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID));
if (context.Session[SessionMgm.Role].Equals(RoleType.EduAdmin))
{
unit.F_status = "未提交";
}
else if (context.Session[SessionMgm.Role].ToString().Equals(RoleType.SchoolAdmin) &&
context.Session[SessionMgm.UnitID].ToString().Equals(context.Session[SessionMgm.VisitUnitID]))
{
unit.F_status = "未提交";
}
else
{
unit.F_status = "已提交";
}
if (unit == null)
{
unit = new ApplicantUnit();
unit.F_ID = F_ID;
unit.F_status = "未提交";
}
return(UtilHelper.GetJSON(unit));
}
private string GetStatus()
{
DataClassesDataContext dc = new DataClassesDataContext();
String userID = Session[SessionMgm.UserID].ToString();
String role = Session[SessionMgm.Role].ToString();
User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(userID));
if (String.IsNullOrEmpty(user.F_belongUnitID) == false)
{
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_ID.Equals(user.F_belongUnitID));
if (unit.F_status != RoleType.Authoried)
{
return(RoleType.Draft);
}
if (role.Equals(RoleType.DeptAdmin) || role.Equals(RoleType.Expert))
{
DeptMent dept = dc.DeptMent.SingleOrDefault(_dm => _dm.F_ID.Equals(user.F_belongDeptID));
if (dept == null || dept.F_status != RoleType.Authoried || user.F_status != RoleType.Authoried)
{
return(RoleType.Draft);
}
}
}
return(RoleType.Authoried);
}
private String Commit()
{
DataClassesDataContext dc = new DataClassesDataContext();
String F_ID = context.Session[SessionMgm.VisitUnitID].ToString();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID));
unit.F_status = RoleType.UnderAudit;
dc.SubmitChanges();
return("提交成功");
}
private String CheckName()
{
String result = "";
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_name.Equals(paras["F_name"]));
if (unit == null)
{
result = "单位名称 " + paras["F_name"] + " 可用";
}
else
{
result = "单位名称 " + paras["F_name"] + " 已被注册";
}
return(result);
}
private string FillUnitInfo()
{
context.Response.ContentType = "application/json";
DataClassesDataContext dc = new DataClassesDataContext();
if (context.Session[SessionMgm.VisitUserID] != null)
{
String F_ID = context.Session[SessionMgm.VisitUserID].ToString();
User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(F_ID));
if (user != null && String.IsNullOrEmpty(user.F_belongUnitID) == false)
{
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_unit => _unit.F_ID.Equals(user.F_belongUnitID));
return(UtilHelper.GetJSON(unit));
}
}
return("");
}
private String Save()
{
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
String F_ID = context.Session[SessionMgm.VisitUnitID].ToString();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID));
unit.F_name = paras["F_name"];
unit.F_organizationCode = paras["F_organizationCode"];
unit.F_majorBusiness = paras["F_majorBusiness"];
unit.F_address = paras["F_address"];
unit.F_principalName = paras["F_principalName"];
unit.F_contactName = paras["F_contactName"];
unit.F_principalIDNum = paras["F_principalIDNum"];
unit.F_principalMobile = paras["F_principalMobile"];
unit.F_contactDept = paras["F_contactDept"];
unit.F_principalPhone = paras["F_principalPhone"];
unit.F_contactDuty = paras["F_contactDuty"];
Decimal num = 0;
unit.F_zipCode = paras["F_zipCode"];
unit.F_contactPhone1 = paras["F_contactPhone1"];
unit.F_location = paras["F_location"];
unit.F_contactPhone2 = paras["F_contactPhone2"];
unit.F_type = paras["F_type"];
unit.F_contactMobile = paras["F_contactMobile"];
num = 0;
Decimal.TryParse(paras["F_registeredAssets"], out num);
unit.F_registeredAssets = num;
unit.F_contactFax = paras["F_contactFax"];
unit.F_bank = paras["F_bank"];
unit.F_contactEmail = paras["F_contactEmail"];
unit.F_bankAccount = paras["F_bankAccount"];
unit.F_bankAccountName = paras["F_bankAccountName"];
unit.F_description = paras["F_description"];
unit.F_awards = paras["F_awards"];
unit.F_status = RoleType.Authoried;
dc.SubmitChanges();
return("保存成功");
}
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();
}
}
}
partial void DeleteApplicantUnit(ApplicantUnit 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 String AddUnit()
{
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
ApplicantUnit unit = null;
unit = new ApplicantUnit();
unit.F_ID = GetID();
unit.F_seq = GetSeq();
unit.F_name = paras["F_name"];
if (dc.ApplicantUnit.Count(_au => _au.F_name.Equals(unit.F_name)) > 0)
{
return("单位名: " + unit.F_name + " 已被占用");
}
unit.F_organizationCode = paras["F_organizationCode"];
unit.F_majorBusiness = paras["F_majorBusiness"];
unit.F_address = paras["F_address"];
unit.F_principalName = paras["F_principalName"];
unit.F_contactName = paras["F_contactName"];
unit.F_principalIDNum = paras["F_principalIDNum"];
unit.F_principalMobile = paras["F_principalMobile"];
unit.F_contactDept = paras["F_contactDept"];
unit.F_principalPhone = paras["F_principalPhone"];
unit.F_contactDuty = paras["F_contactDuty"];
Decimal num = 0;
unit.F_zipCode = paras["F_zipCode"];
unit.F_contactPhone1 = paras["F_contactPhone1"];
unit.F_location = paras["F_location"];
unit.F_contactPhone2 = paras["F_contactPhone2"];
unit.F_type = paras["F_type"];
unit.F_contactMobile = paras["F_contactMobile"];
num = 0;
Decimal.TryParse(paras["F_registeredAssets"], out num);
unit.F_registeredAssets = num;
unit.F_contactFax = paras["F_contactFax"];
unit.F_bank = paras["F_bank"];
unit.F_contactEmail = paras["F_contactEmail"];
unit.F_bankAccount = paras["F_bankAccount"];
unit.F_bankAccountName = paras["F_bankAccountName"];
unit.F_description = paras["F_description"];
unit.F_awards = paras["F_awards"];
unit.F_status = RoleType.Authoried;
dc.ApplicantUnit.InsertOnSubmit(unit);
User user = new User();
user.F_ID = Guid.NewGuid().ToString();
user.F_status = RoleType.Authoried;
user.F_userName = paras["F_userName"].ToString();
if (dc.User.SingleOrDefault(_user => _user.F_userName.Equals(user.F_userName)) != null)
{
return("用户名" + user.F_userName + "已被占用");
}
user.F_realName = paras["F_realName"].ToString();
user.F_belongUnitID = unit.F_ID;
user.F_Role = RoleType.SchoolAdmin;
user.F_pwd = UtilHelper.MD5Encrypt(paras["F_pwd"].ToString());
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
return("注册成功");
}
