public static LoaiKhachDTO LaylKhach(int MLK)
{
OleDbConnection link = null;
LoaiKhachDTO LK = new LoaiKhachDTO();
try
{
link = KetNoi();
string chuoiLenh = "Select * from LoaiKhach where MaLoaiKH=@MLK";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MLK", OleDbType.Integer);
thamso.Value = MLK;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
Doc.Read();
LK.MaLoaiKH = Doc.GetInt16(0);
LK.TenLoaiKH = Doc.GetString(1);
LK.HeSo = Doc.GetInt16(2);
LK.Xoa = Doc.GetString(3);
}
catch (Exception ex)
{
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(LK);
}
public static List <LoaiKhachDTO> LayDSLoaiKhach()
{
OleDbConnection link = null;
List <LoaiKhachDTO> ds = new List <LoaiKhachDTO>();
try
{
link = KetNoi();
string chuoiLenh = "Select * from LoaiKhach";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
LoaiKhachDTO lphg = new LoaiKhachDTO();
lphg.MaLoaiKH = Doc.GetInt16(0);
lphg.TenLoaiKH = Doc.GetString(1);
lphg.HeSo = Doc.GetInt16(2);
lphg.Xoa = Doc.GetString(3);
ds.Add(lphg);
}
}
catch (Exception ex)
{
ds = new List <LoaiKhachDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(ds);
}
public static List <KhachHangDTO> LayDSKhach()
{
OleDbConnection link = null;
List <KhachHangDTO> dsKH = new List <KhachHangDTO>();
try
{
link = KetNoi();
string chuoiLenh = "Select * from KhachHang,LoaiKhach Where KhachHang.MaLoaiKH=LoaiKhach.MaLoaiKH order by MaKH";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
KhachHangDTO kh = new KhachHangDTO();
kh.MaKH = Doc.GetString(0); //1 MAKH 2 ten 3... 4 Diachi 5.so giay to
kh.HoTen = Doc.GetString(1); //7.ten loai
LoaiKhachDTO loai = new LoaiKhachDTO();
loai.MaLoaiKH = Doc.GetInt16(2);
loai.TenLoaiKH = Doc.GetString(6);
loai.HeSo = Doc.GetInt16(7);
kh.LoaiKhach = loai;
kh.DiaChi = Doc.GetString(3);
kh.SoGiayTo = Doc.GetString(4);
dsKH.Add(kh);
}
}
catch (Exception ex)
{
dsKH = new List <KhachHangDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsKH);
}
public static KhachHangDTO LayKhach(string MKH)
{
OleDbConnection link = null;
KhachHangDTO kh = new KhachHangDTO();
try
{
link = KetNoi();
string chuoiLenh = "Select * from KhachHang,LoaiKhach where MaKH=@MKH and KhachHang.MaLoaiKH=LoaiKhach.MaLoaiKH";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MKH", OleDbType.LongVarChar);
thamso.Value = MKH;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
Doc.Read();
kh.MaKH = Doc.GetString(0);
kh.HoTen = Doc.GetString(1);
LoaiKhachDTO loai = new LoaiKhachDTO();
loai.MaLoaiKH = Doc.GetInt16(2);
loai.TenLoaiKH = Doc.GetString(6);
loai.HeSo = Doc.GetInt16(7);
kh.LoaiKhach = loai;
kh.DiaChi = Doc.GetString(3);
kh.SoGiayTo = Doc.GetString(4);
}
catch (Exception ex)
{
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(kh);
}
