//Tim MaKH Theo ten KH
public bool TimMaKH(string TenKH)
{
string sql = "select MaKH from Tb_KhachHang where TenKH='" + TenKH + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(true);
}
//Lay ra Tham So
public DataTable LayThamSo()
{
string sql = "select * from Tb_ThamSo";
return
(ConnectToDB.TruyVan_TraVe_DataTable(sql));
}
//Tim MaLoaiNV theo MaNhanVien
public string TimMaLoaiNV(string MaNV)
{
string sql = "select MaLoaiNV from Tb_ThongTinNhanVien where MaNV='" + MaNV + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt.Rows[0][0].ToString());
}
public static string SinhMaChamCong()
{
string ma = "";
string sql = "SELECT MaChamCong FROM Tb_ChamCong ORDER BY MaChamCong DESC";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
if (dt.Rows.Count == 0)
{
return("MCC001");
}
string temp = dt.Rows[0][0].ToString();
//Lay ve ID hien tai
//temp = temp.Substring(4,3);
int i = int.Parse(temp.Substring(3, 3));
i += 1;
int so = 3;//So luong sach toi da, vi du: 3 chu so
String so0 = "";
for (int j = 1; j <= so; j++)
{
if (i.ToString().Length == j)
{
for (int k = 0; k < so - j; k++)
{
so0 += "0";
}
break;
}
}
ma = "MCC" + so0 + i.ToString();
return(ma);
}
public string TimMaMA(string tenMA)
{
string sql = "select MaMonAn from Tb_MonAn where TenMonAn='" + tenMA + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt.Rows[0][0].ToString());
}
//Truy van lay ra bang mon an
public string GiaMonAn(string MaMA)
{
string sql = "select DonGia from Tb_MonAn where MaMonAn='" + MaMA + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt.Rows[0][0].ToString());
}
//Lay ra bang cham cong ung voi ma cham cong
public static DataTable layBangChamCong(string MaBangChamCong)
{
string sql = "select * from Tb_ChiTietBangChamCong where MaBangChamCong='" + MaBangChamCong + "'";
DataTable tb = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(tb);
}
//Truy van lay ra danh sach thang ung voi nam
public DataTable LayRaThang(string Nam)
{
string sql = "select DISTINCT Thang from Tb_ChamCong where Nam='" + Nam + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt);
}
//Truy van lay ra danh sach nam trong bang cham cong
public DataTable LayRaNam()
{
string sql = "select DISTINCT Nam from Tb_ChamCong";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt);
}
//Kiem tra ten dang nhap va mat khau
public bool KiemTraDangNhap(String TenDangNhap, String MatKhau)
{
bool kq = false;
string sql = "select * from Tb_Users where UserName='******' and Password='******'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
if (dt.Rows.Count > 0)
{
kq = true;
}
else
{
kq = false;
}
return(kq);
}
public DataTable TraCuuMonAn(String tenMA, String maxcost, String mincost)
{
if (tenMA == "")
{
if (maxcost == "" || int.Parse(maxcost) == 0)
{
MessageBox.Show("Nhập lại giá muốn tìm");
return(null);
}
else
{
string sql = "select TenMonAn,DonGia from Tb_MonAn where DonGia between '" + mincost + "' and '" + maxcost + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
return(dt);
}
}
else
{
if (maxcost == "" || int.Parse(maxcost) == 0)
{
if (mincost == "" || int.Parse(mincost) == 0)
{
string sql = "";
sql = "select TenMonAn,DonGia from Tb_MonAn where TenMonAn='" + tenMA + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
//MessageBox.Show(dt.Rows[0][0].ToString());
return(dt);
}
else
{
MessageBox.Show("Nhập lại giá muốn tìm kiếm");
return(null);
}
}
else
{
string sql = "";
sql = "select * from (select TenMonAn,DonGia from Tb_MonAn where TenMonAn='" + tenMA + "') AS tam where tam.DonGia between '" + mincost + "' and '" + maxcost + "'";
DataTable dt = ConnectToDB.TruyVan_TraVe_DataTable(sql);
//MessageBox.Show(dt.Rows[0][0].ToString());
return(dt);
}
}
return(null);
}
//lay danh sach khach hang
public DataTable DanhSachKH()
{
string sql = "select * from Tb_KhachHang";
return(ConnectToDB.TruyVan_TraVe_DataTable(sql));
}
//Lay ra thong tin mon an
public DataTable DanhSachMonAn()
{
string sql = "select * from Tb_MonAn";
return(ConnectToDB.TruyVan_TraVe_DataTable(sql));
}
//Lay ra loai nhan vien
public DataTable LayThongTinLoaiNV(string MaLoaiNV)
{
string sql = "select * from Tb_LoaiNhanVien where MaLoaiNV='" + MaLoaiNV + "'";
return(ConnectToDB.TruyVan_TraVe_DataTable(sql));
}
//Truy van lay ra bang Loai Nhan Vien
public DataTable LayDanhSachLoaiNV()
{
string sql = "select * from Tb_LoaiNhanVien";
return(ConnectToDB.TruyVan_TraVe_DataTable(sql));
}
