请假单联动功能SOP.docVIP

請假單聯運功能SOP: 第一步：先確定數據庫中哪個表，哪些字段可以帶出 第二步：建立一個 QJDLL.aspx 文件，前臺代碼如下： %@ Page Language=C# AutoEventWireup=true CodeFile=QJDLL.aspx.cs Inherits=QJDLL % !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head runat=server title請?假¨′單?連B動¨?功|能¨1/title script type=text/javascript function execute() { window.returnValue = { second: document.getElementsByName(department)[0].value, three: document.getElementsByName(applicat)[0].value } window.close(); } /script /head body onload=execute() form id=form1 runat=server div asp:TextBox ID=TextBox1 runat=server/asp:TextBox asp:TextBox ID=department runat=server/asp:TextBox asp:TextBox ID=applicat runat=server/asp:TextBox /div /form /body /html 后臺代碼： protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string employeeno = Request[id]; string con = server=27;database=FlowMaster;UId=sa;PWD=bruce_zhao888418;; SqlConnection sqlcon = new SqlConnection(con); string str = select EmpNo,PartName,EmpCName from HR_EmployeeXX where EmpNO= + employeeno + ; SqlDataAdapter sqlda = new SqlDataAdapter(str, sqlcon); sqlcon.Open(); DataSet ds = new DataSet(); sqlda.Fill(ds); sqlcon.Close(); int count = ds.Tables[0].Rows.Count; if (count 0) { TextBox1.Text = ds.Tables[0].Rows[0][0].ToString(); department.Text = ds.Tables[0].Rows[0][1].ToString() + ; applicat.Text = ds.Tables[0].Rows[0][2].ToString() + ; } else { Response.Write(script language=javascriptwindow.close();/script); } } } 再建一個XXX.aspx 文件不需要只是用來瀏覽測試用；上面的文件是不可以進行測試的； 前臺代碼： %@ Page Language=C# AutoEve