public object themTongTienHopDong(String maHopDong, float tongTien)
{
SqlParameter prTongTien = new SqlParameter("@TONGTIEN", SqlDbType.Float);
prTongTien.Value = tongTien;
SqlParameter prMaHopDong = new SqlParameter("@MAHOPDONG", SqlDbType.NVarChar, 10);
prMaHopDong.Value = maHopDong;
SqlParameter[] pr = { prMaHopDong, prTongTien };
return(xuLyDuLieu.thucThiGiaTriDonThuTuc("psThemTongTienHopDong", pr));
}
public object themTongTienChoHoaDonNuoc(String maHoaDonNuoc, String tongTien)
{
SqlParameter prtongTien = new SqlParameter("@TONGTIEN", SqlDbType.Float);
prtongTien.Value = tongTien;
SqlParameter prmaHoaDonNuoc = new SqlParameter("@MAHOADONNUOC", SqlDbType.NVarChar, 10);
prmaHoaDonNuoc.Value = maHoaDonNuoc;
SqlParameter[] pr = { prmaHoaDonNuoc, prtongTien };
return(XuLyDuLieu.thucThiGiaTriDonThuTuc("psThemTongTienChoHoaDonNuoc", pr));
}
public int dangNhap(String tenDangNhap, String matKhau, String idQuyen)
{
SqlParameter prTenDangNhap = new SqlParameter("@TENDANGNHAP", SqlDbType.NVarChar, 30);
prTenDangNhap.Value = tenDangNhap;
SqlParameter prMatKhau = new SqlParameter("@MATKHAU", SqlDbType.NVarChar, 20);
prMatKhau.Value = matKhau;
SqlParameter prIDQuyen = new SqlParameter("@IDQUYEN", SqlDbType.NVarChar, 10);
prIDQuyen.Value = idQuyen;
SqlParameter[] pr = { prTenDangNhap, prMatKhau, prIDQuyen };
int kq = (int)xuLyDuLieu.thucThiGiaTriDonThuTuc("psDangNhap", pr);
return(kq);
}