3层架构在C_中实现3层架构.pdfVIP

c3 MS Access 3 c3 MS Access 3 3 3 3 3 3 3 GUI 3 SQL Server Oracle GUI 3 GUI form FrmGUI BOCustomerBussniess Object Customer DACustomerData Access Customer //This function get the details from the user via GUI //tier and calls the Add method of business logic layer. private void cmdAdd_Click(object sender, System.EventArgs e) { try { cus = new BOCustomer(); cus.cusID=txtID.Text.ToString(); cus.LName = txtLName.Text.ToString(); cus.FName = txtFName.Text.ToString(); cus.Tel= txtTel.Text.ToString(); cus.Address = txtAddress.Text.ToString(); cus.Add(); } catch(Exception err) { MessageBox.Show(err.Message.ToString()); } } //This function gets the ID from the user and finds the //customer details and return the details in the form of //a dataset via busniss object layer. Then it loops through //the content of the dataset and fills the controls. private void cmdFind_Click(object sender, System.EventArgs e) { try { String cusID = txtID.Text.ToString(); BOCustomer thisCus = new BOCustomer(); DataSet ds = thisCus.Find(cusID); DataRow row; row = ds.Tables[0].Rows[0]; //via looping foreach(DataRow rows in ds.Tables[0].Rows ) { txtFName.Text = rows[CUS_F_NAME].ToString(); txtLName.Text = rows[CUS_L_NAME].ToString(); txtAddress.Text = rows[CUS_ADDRESS].ToString(); txtTel.Text = rows[CUS_TEL].ToString(); } } catch (Exception err) { MessageBox.Show(err.Mess