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(); }