public HT_Nguoi_Dung_Don_Vi_Chi_Tiet Lay(int Nguoi_Dung_Don_Vi) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_Nguoi_Dung_Don_Vi_Lay", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pNguoi_Dung_Don_Vi = new SqlParameter("@Nguoi_Dung_Don_Vi", SqlDbType.Int, 4); pNguoi_Dung_Don_Vi.Value = Nguoi_Dung_Don_Vi; myCommand.Parameters.Add(pNguoi_Dung_Don_Vi); SqlParameter pMa_Nguoi_Dung = new SqlParameter("@Ma_Nguoi_Dung", SqlDbType.Int, 4); pMa_Nguoi_Dung.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pMa_Nguoi_Dung); SqlParameter pMa_Don_Vi = new SqlParameter("@Ma_Don_Vi", SqlDbType.Int, 4); pMa_Don_Vi.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pMa_Don_Vi); myConnection.Open(); myCommand.ExecuteNonQuery(); HT_Nguoi_Dung_Don_Vi_Chi_Tiet myHT_Nguoi_Dung_Don_Vi_Chi_Tiet = new HT_Nguoi_Dung_Don_Vi_Chi_Tiet(); myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Nguoi_Dung_Don_Vi = Nguoi_Dung_Don_Vi; myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Ma_Nguoi_Dung = (int)pMa_Nguoi_Dung.Value; myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Ma_Don_Vi = (int)pMa_Don_Vi.Value; return(myHT_Nguoi_Dung_Don_Vi_Chi_Tiet); } } }
public void Cap_Nhat(HT_Nguoi_Dung_Don_Vi_Chi_Tiet myHT_Nguoi_Dung_Don_Vi_Chi_Tiet) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_Nguoi_Dung_Don_Vi_Cap_Nhat", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pNguoi_Dung_Don_Vi = new SqlParameter("@Nguoi_Dung_Don_Vi", SqlDbType.Int, 4); pNguoi_Dung_Don_Vi.Value = myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Nguoi_Dung_Don_Vi; myCommand.Parameters.Add(pNguoi_Dung_Don_Vi); SqlParameter pMa_Nguoi_Dung = new SqlParameter("@Ma_Nguoi_Dung", SqlDbType.Int, 4); pMa_Nguoi_Dung.Value = myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Ma_Nguoi_Dung; myCommand.Parameters.Add(pMa_Nguoi_Dung); SqlParameter pMa_Don_Vi = new SqlParameter("@Ma_Don_Vi", SqlDbType.Int, 4); pMa_Don_Vi.Value = myHT_Nguoi_Dung_Don_Vi_Chi_Tiet.Ma_Don_Vi; myCommand.Parameters.Add(pMa_Don_Vi); myConnection.Open(); myCommand.ExecuteNonQuery(); } } }