📄 addproject.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using OfficeAutomatization;
using SQLHelper;
public partial class AddProject : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindDepartmentData();
BindEmployeeData();
}
}
private void BindEmployeeData()
{
///定义获取数据的类
Employee employee = new Employee();
SqlDataReader recu = employee.GetEmployees();
///设定控件的数据源
EmployeeList.DataSource = recu;
///设定控件的Text属性和Value属性
EmployeeList.DataTextField = "EmployName";
EmployeeList.DataValueField = "EmployeeID";
///绑定控件的数据
EmployeeList.DataBind();
///关闭数据读取器和数据库的连接
recu.Close();
}
private void BindDepartmentData()
{
///定义获取数据的类
OfficeAutomatization.Department depart = new OfficeAutomatization.Department();
SqlDataReader recd = depart.GetDepartments();
///设定控件的数据源
DepartmentList.DataSource = recd;
///设定控件的Text属性和Value属性
DepartmentList.DataTextField = "Name";
DepartmentList.DataValueField = "DepartmentID";
///绑定控件的数据
DepartmentList.DataBind();
///关闭数据读取器和数据库的连接
recd.Close();
}
protected void AddBtn_Click(object sender, EventArgs e)
{
if (Page.IsValid == true)
{
///定义类
Project project = new Project();
try
{
///添加操作
project.AddProject(Name.Text.Trim(),
Desn.Text,
Int32.Parse(EmployeeList.SelectedValue),
DateTime.Parse(CreateDate.Text.Trim()),
DateTime.Parse(StartDate.Text.Trim()),
DateTime.Parse(EndDate.Text.Trim()),
Int32.Parse(DepartmentList.SelectedValue),
Int32.Parse(StateList.SelectedValue));
///显示操作结果信息
Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONADDSUCCESSMESSAGE + "')</script>");
}
catch (Exception ex)
{
///显示添加操作中的失败、错误信息
Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
+ ASPNET2System.RedirectErrorUrl(Request.RawUrl)
+ "&ErrorMessage=" + ex.Message.Replace("\n", " "));
}
}
}
protected void ReturnBtn_Click(object sender, EventArgs e)
{
///跳转到管理页面
Response.Redirect("~/DesktopModules/Project/ProjectManage.aspx");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -