Exemplo n.º 1
0
        public static void ThemGiaoDich(GiaoDichDTO gdDto, PhieuRutTienTuTKDTO rutTienTuTKDto, string nhanVien, ref double LePhi)
        {
            SqlConnection cnn = KetNoiCSDL.TaoKetNoi();
               SqlCommand cmd = new SqlCommand("sp_Lay_phi_rut", cnn);

               cmd.CommandType = CommandType.StoredProcedure;

               cmd.Parameters.Add("@Ma_TK", SqlDbType.Char);
               cmd.Parameters.Add("@So_tien", SqlDbType.Money );
               cmd.Parameters.Add("@MaNV", SqlDbType.VarChar );

               cmd.Parameters["@Ma_TK"].Value = gdDto.MaTK ;
               cmd.Parameters["@So_tien"].Value = rutTienTuTKDto.SoTien;

               cmd.Parameters["@MaNV"].Value = nhanVien;

               cnn.Open();
               SqlDataReader dr = cmd.ExecuteReader();

               try
               {
               if (dr.Read())
               {
                   LePhi = double.Parse(dr["LePhi"].ToString());
               }
               cnn.Close();
               }
               catch (Exception ex)
               {
               if (cnn.State == ConnectionState.Open)
                   cnn.Close();
               throw ex;
               }
        }
Exemplo n.º 2
0
 // end 0712455
 // Rút tiền từ tài khoản
 //0712452
 private double RutTienTuTaiKhoan(string Ma_tai_khoan)
 {
     double Lephi = 0.0;
     GiaoDichDTO gdDto = new GiaoDichDTO();
     PhieuRutTienTuTKDTO rutTienTuTKDto = new PhieuRutTienTuTKDTO();
     gdDto.MaTK = Ma_tai_khoan;
     rutTienTuTKDto.SoTien = Convert.ToDouble(tb_so_tien_rut.Text.Trim());
     try
     {
         RutTienBUS.ThemGiaoDich(gdDto, rutTienTuTKDto, recentUser, ref Lephi );
         return Lephi;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
         return Lephi ;
     }
 }
Exemplo n.º 3
0
 public static void ThemGiaoDich(GiaoDichDTO gdDto, PhieuRutTienTuTKDTO rutTienTuTKDto, string nhanVien, ref double LePhi)
 {
     RutTienDAO.ThemGiaoDich(gdDto, rutTienTuTKDto, nhanVien , ref LePhi );
 }