/// <summary> /// 分页绑定数据 /// </summary> /// <param name="currentPage">要显示的当前页码数</param> private void BindPagedEmployees(int pageIndex) { string employeeName = txtEmployeeName.Text; string userName = txtUserName.Text; EmployeeStatusType status = (EmployeeStatusType)Convert.ToInt32(rblStatus.SelectedValue); int totalResults; // 返回的员工总行数 List <Employee> results = BLLStaff.SearchPagedEmployees(employeeName, userName, status, pageSize, pageIndex, out totalResults); int totalPages = totalResults / pageSize + (totalResults % pageSize == 0 ? 0 : 1); // 计算总分页数 if (totalPages == 0) // 如果没有返回记录 { divNoResults.Visible = true; divResults.Visible = false; } else { divNoResults.Visible = false; divResults.Visible = true; lblTotalResults.Text = totalResults.ToString(); // 显示总行数 lblTotalPages.Text = totalPages.ToString(); // 显示总分页数 lblCurrentPage.Text = pageIndex.ToString(); // 显示当前页码数 } repEmployees.DataSource = results; repEmployees.DataBind(); }
private void BindEmployees() { List <Employee> list = BLLStaff.GetUnApprovedEmployees(); repAccounts.DataSource = list; repAccounts.DataBind(); }
private void BindDepartments() { ddlDepartments.DataSource = BLLStaff.GetAllDepartments(); ddlDepartments.DataTextField = "DepartmentName"; ddlDepartments.DataValueField = "DepartmentID"; ddlDepartments.DataBind(); }
protected void gvDepartments_RowUpdating(object sender, GridViewUpdateEventArgs e) { int deptID = Convert.ToInt32(e.Keys[0]); // 获取被编辑的行所对应Department的编号。需在GridView中预先设置DataKeyNames GridViewRow gvr = gvDepartments.Rows[e.RowIndex]; // 获取当前被编辑的行 TextBox txtDepartmentName = gvr.FindControl("txtDepartmentName") as TextBox; // 找到部门名称编辑框 string newName = txtDepartmentName.Text; Department department = new Department(); department.DepartmentID = deptID; department.DepartmentName = newName; StaffOpResult result = BLLStaff.UpdateDepartment(department); string script; if (result == StaffOpResult.Duplicate) { script = "<script type='text/javascript'>alert('部门:" + newName + " 已经存在!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "duplicate", script); e.Cancel = true; // 不再执行后续操作,回到编辑状态 } else { script = "<script type='text/javascript'>alert('部门修改成功!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "success", script); gvDepartments.EditIndex = -1; // 退出编辑状态 BindDepartments(); } }
private void BindDepartments() { List <Department> list = BLLStaff.GetAllDepartments(); gvDepartments.DataSource = list; gvDepartments.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { string meetingName = txtMeetingName.Text; int numberofParticipants = Convert.ToInt32(txtNumberofParticipants.Text); DateTime start = DateTime.Parse(txtStartDate.Text + " " + txtStartTime.Text); DateTime end = DateTime.Parse(txtEndDate.Text + " " + txtEndTime.Text); int roomID = Convert.ToInt32(ddlRooms.SelectedValue); string description = txtDescription.Text; string script; if (start >= end) // 检查结束时间是否大于起始时间 { script = "<script type='text/javascript'>alert('会议结束时间必须大于起始时间');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "dateerror", script); return; } Meeting meeting = new Meeting(); meeting.MeetingName = meetingName; meeting.NumberofParticipants = numberofParticipants; meeting.StartTime = start; meeting.EndTime = end; meeting.Description = description; meeting.Room = BLLRoom.GetRoomByID(roomID); meeting.Reservationist = BLLStaff.GetEmployeeforLoggedInUser(); meeting.Status = MeetingStatus.Normal; meeting.Participants = new List <Employee>(); foreach (ListItem item in lbSelectedEmployees.Items) { int employeeID = Convert.ToInt32(item.Value); meeting.Participants.Add(new Employee { EmployeeID = employeeID }); } MeetingOpResults result = BLLMeeting.ReserveMeeting(meeting); script = string.Format("<script>alert('会议预订成功!');window.location.href='MyReservations.aspx';</script>"); switch (result) { case MeetingOpResults.NotEnoughCapacity: script = string.Format("<script>alert('所选会议室容量为{0},无法容纳{1}人');</script>", meeting.Room.Capacity, meeting.NumberofParticipants); break; case MeetingOpResults.ReservationTooLate: script = string.Format("<script>alert('距会议开始时间{0}已不足30分钟,请推迟时间');</script>", meeting.StartTime.ToString("HH:mm")); break; case MeetingOpResults.RoomScheduleNotAvailable: script = string.Format("<script>alert('该会议室已被预订,请更改时间或重新选择会议室');</script>"); break; } Page.ClientScript.RegisterStartupScript(this.GetType(), "result", script); }
private void BindReservations() { Employee reservationist = BLLStaff.GetEmployeeforLoggedInUser(); List <Meeting> list = BLLMeeting.GetReservationsByReservationistID(reservationist.EmployeeID); repReservations.DataSource = list; repReservations.DataBind(); }
private void BindMeetings() { Employee employee = BLLStaff.GetEmployeeforLoggedInUser(); List <Meeting> list = BLLMeeting.GetMeetingsForEmployee(employee.EmployeeID); repReservations.DataSource = list; repReservations.DataBind(); }
protected void ddlDepartments_SelectedIndexChanged(object sender, EventArgs e) { int departmentID = Convert.ToInt32(ddlDepartments.SelectedValue); List <Employee> list = BLLStaff.GetEmployeesByDepartment(departmentID); lbEmployees.DataSource = list; lbEmployees.DataTextField = "EmployeeName"; lbEmployees.DataValueField = "EmployeeID"; lbEmployees.DataBind(); }
protected void repEmployees_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "CloseAccount") { int employeeID = Convert.ToInt32(e.CommandArgument); Label lblUserName = e.Item.FindControl("lblUserName") as Label; string userName = lblUserName.Text; BLLStaff.CloseAccount(employeeID, userName); BindPagedEmployees(1); } }
protected void repAccounts_ItemCommand(object source, RepeaterCommandEventArgs e) { int employeeID = Convert.ToInt32(e.CommandArgument); Label lblUserName = e.Item.FindControl("lblUserName") as Label; string userName = lblUserName.Text; if (e.CommandName == "Approve") { BLLStaff.ApproveEmployee(employeeID, userName); } else if (e.CommandName == "Delete") { BLLStaff.DeleteEmployee(employeeID, userName); } BindEmployees(); }
protected void btnSubmit_Click(object sender, EventArgs e) { string oldPassword = txtOrigin.Text; string newPassword = txtNew.Text; StaffOpResult result = BLLStaff.ChangePassword(oldPassword, newPassword); string script = ""; if (result == StaffOpResult.PasswordIncorrect) { script = "<script type='text/javascript'>alert('原始密码错误!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "error", script); } else { script = "<script type='text/javascript'>alert('密码修改成功!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "success", script); } }
protected void gvDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e) { int deptID = Convert.ToInt32(e.Keys[0]); StaffOpResult result = BLLStaff.DeleteDepartment(deptID); string script; if (result == StaffOpResult.DependanceExists) { script = "<script type='text/javascript'>alert('该部门下仍有员工,不能删除!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "duplicate", script); e.Cancel = true; } else { script = "<script type='text/javascript'>alert('部门删除成功!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "success", script); BindDepartments(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string departmentName = txtDepartmentName.Text; StaffOpResult result = BLLStaff.AddDepartment(departmentName); string script; if (result == StaffOpResult.Duplicate) { script = "<script type='text/javascript'>alert('部门:" + departmentName + " 已经存在!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "duplicate", script); } else { BindDepartments(); // 重新绑定以显示新增部门数据 txtDepartmentName.Text = ""; script = "<script type='text/javascript'>alert('部门:" + departmentName + " 添加成功!');</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "success", script); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string employeeName = txtEmployeeName.Text; string userName = txtUserName.Text; string password = txtPassword.Text; string email = txtEmail.Text; string phone = txtPhone.Text; Employee employee = new Employee(); employee.EmployeeName = employeeName; employee.UserName = userName; employee.Password = password; employee.Phone = phone; employee.Email = email; Department department = new Department(); department.DepartmentID = Convert.ToInt32(ddlDepartments.SelectedValue); department.DepartmentName = ddlDepartments.SelectedItem.Text; employee.RelatedDepartment = department; employee.Status = EmployeeStatusType.Inactive; StaffOpResult result = BLLStaff.Register(employee); if (result == StaffOpResult.Duplicate) { lblResult.Text = "用户名或电子邮件已经存在,请修改!"; } else if (result == StaffOpResult.UserCreateError) { lblResult.Text = "创建用户账号失败,请联系管理员!"; } else { txtEmployeeName.Text = ""; txtUserName.Text = ""; txtPhone.Text = ""; txtEmail.Text = ""; ddlDepartments.SelectedIndex = 0; lblResult.Text = "注册成功!"; } }