protected void btnKeySearch_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
// linq动态组合可参见http://www.cnblogs.com/whitewolf/archive/2010/08/02/1790166.html
//>这里就简单做一下咯
User user = null;
if (ddlField.SelectedValue == "F_userName")
{
user = dc.User.SingleOrDefault(_user => _user.F_userName.Equals(txtKeyword.Text.Trim()));
}
else if (ddlField.SelectedValue == "F_ID")
{
user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(txtKeyword.Text.Trim()));
}
if (user != null)
{
// 这样获取的result字符串有很多\/之类的玩意，会传不到前端哦
//> TODO
User p_user = new User();
p_user.F_ID = user.F_ID;
p_user.F_userName = user.F_userName;
String result = UtilHelper.GetJSON(p_user);
Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>");
}
else
{
UtilHelper.AlertMsg("找不到指定用户");
}
}
private void ExportData(String F_ID, String selectCMD)
{
SqlDataAdapter adapter = new SqlDataAdapter();
String orderCmd = " order by F_seq ";
String sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , F_status, F_fund from ViewAuditedBySchool where ";
adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd);
adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
UtilHelper.AlertMsg("没有数据");
return;
}
sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , " +
" F_status, F_fund from ViewAuditedBySchool where F_projectType='科技项目' and ";
adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd);
adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString);
dt = new DataTable();
adapter.Fill(dt);
DataClassesDataContext dc = new DataClassesDataContext();
ProjectDetail projectDetail = dc.ProjectDetail.SingleOrDefault(_pd => _pd.F_ID.Equals(F_ID));
String sciFileName = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "科技项目汇总表.xls");
ExportFile(dt, sciFileName);
sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , " +
" F_status, F_fund from ViewAuditedBySchool where F_projectType='社科项目' and ";
adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd);
adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString);
dt = new DataTable();
adapter.Fill(dt);
String socialFileName = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "社科项目汇总表.xls");
ExportFile(dt, socialFileName);
List <String> outputFiles = new List <string>();
if (File.Exists(sciFileName))
{
outputFiles.Add(sciFileName);
}
if (File.Exists(socialFileName))
{
outputFiles.Add(socialFileName);
}
String zipFile = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "项目汇总表.zip");
UtilHelper.ZipFileMain(outputFiles, zipFile);
DownloadFile("项目汇总表.zip", zipFile);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
// 如果user是RoleType.ProjectMember类型的，也会查找到 by cy [20140919]
User user = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(ddlType.SelectedValue) && _user.F_idNumber.Equals(txtNo.Text));
if (user != null)
{
String result = UtilHelper.GetJSON(user);
Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>");
}
else
{
UtilHelper.AlertMsg("找不到指定用户");
}
}
protected void btnCommit_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(Session[SessionMgm.UserID].ToString()) &&
_user.F_pwd.Equals(UtilHelper.MD5Encrypt(txtOrgiPWD.Text)));
if (user != null)
{
user.F_pwd = UtilHelper.MD5Encrypt(txtNewPWD1.Text);
dc.SubmitChanges();
UtilHelper.AlertMsg("修改成功");
}
else
{
UtilHelper.AlertMsg("密码错误");
}
}
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();
}
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
List <String> unitIDs = GetSelectedIDs();
if (unitIDs.Contains(UnitService.EDUID))
{
UtilHelper.AlertMsg("教育厅不可删除");
return;
}
DataClassesDataContext dc = new DataClassesDataContext();
var units = dc.ApplicantUnit.Where(_unit => unitIDs.Contains(_unit.F_ID));
dc.ApplicantUnit.DeleteAllOnSubmit(units);
foreach (String unitID in unitIDs)
{
var users = dc.User.Where(_user => _user.F_belongUnitID.Equals(unitID));
dc.User.DeleteAllOnSubmit(users);
var depts = dc.DeptMent.Where(_dept => _dept.F_unitID.Equals(unitID));
dc.DeptMent.DeleteAllOnSubmit(depts);
}
dc.SubmitChanges();
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
User user = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(ddlType.SelectedValue) && _user.F_idNumber.Equals(txtNo.Text));
if (user != null)
{
ApplicantMember member = new ApplicantMember();
member.F_userID = user.F_ID;
member.F_realName = user.F_realName;
member.F_title = user.F_title;
member.F_workspace = user.F_workspace;
member.F_birthday = user.F_birthday;
member.F_sexual = user.F_sexual;
member.F_education = user.F_highestEducation;
member.F_degree = user.F_highestDegree;
String result = UtilHelper.GetJSON(member);
Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>");
}
else
{
UtilHelper.AlertMsg("找不到指定用户");
}
}
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");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> userIDs = Global.GetSuitUsers(Session);
IEnumerable <ViewPosApl> datasource = getDatasource(false);
if (txtKeyword.Text.Trim().Length > 0)
{
DataTable dt = UtilHelper.ToDataTable(datasource);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (ddlType.SelectedValue.Equals(SearchType.ExactMatch))
{
if (dt.Rows[i][ddlField.SelectedValue].ToString().Equals(txtKeyword.Text) == false)
{
dt.Rows.RemoveAt(i);
i--;
}
}
else if (ddlType.SelectedValue.Equals(SearchType.FuzzMatch))
{
if (dt.Rows[i][ddlField.SelectedValue].ToString().Contains(txtKeyword.Text) == false)
{
dt.Rows.RemoveAt(i);
i--;
}
}
else
{
DateTime selectedDate, inputDate;
if (DateTime.TryParse(dt.Rows[i][ddlField.SelectedValue].ToString(), out selectedDate))
{
if (DateTime.TryParse(txtKeyword.Text, out inputDate) == false)
{
UtilHelper.AlertMsg("请输入合法的日期");
}
else
{
if (ddlType.SelectedValue.Equals(SearchType.Bigger))
{
if (DateTime.Compare(selectedDate, inputDate) < 0)
{
dt.Rows.RemoveAt(i--);
}
}
else if (ddlType.SelectedValue.Equals(SearchType.Smaller))
{
if (DateTime.Compare(selectedDate, inputDate) > 0)
{
dt.Rows.RemoveAt(i--);
}
}
}
}
else
{
UtilHelper.AlertMsg("大小只能用于比较日期");
}
}
}
GridView1.DataSource = dt;
}
else
{
GridView1.DataSource = UtilHelper.ToDataTable(datasource);
}
Session.Add(SessionMgm.DataSource, GridView1.DataSource);
GridView1.PageIndex = 0;
GridView1.DataBind();
}
