//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)); }