public DataTable GetAllMuaHangByMaNhaCungCap(MuaHangO mh) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaNhaCungCap"; param.Value = mh.MaNhaCungCap; return(conn.executeSelectQuery("proGetMuaHang_NhaCC_Kho_IfMaNhaCungCap", param)); }
public DataTable getGiaoVienByName(GiaoVienVO gv) { string query = string.Format("select * from GiaoVien where TenGV = @TenGV"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@TenGV", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(gv.TenGV); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getLopByName(LopVO L) { string query = string.Format("select * from Lop where TenLop = @TenLop"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@TenLop", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(L.TenLop); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getMonHocByMa(String ma) { string query = string.Format("select * from MonHoc where MaMH = @MaMH"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@MaMH", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(ma); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable GetAllChiTietPhieuBanHangByMaPhieuBan(ChiTietPhieuBanHangO ctpbh) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaPhieuBan"; param.Value = ctpbh.MaPhieuBan; return(conn.executeSelectQuery("proGetChiTietPhieuBanHang_HangHoa_DonVi_IfMaPhieu", param)); }
public DataTable GetAllTonKhoByMaKho(TonKhoO tk) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaKho"; param.Value = tk.MaKho; return(conn.executeSelectQuery("proGetTonKho_Kho_HangHoa_DonVi_NhomHang_IfMaKho", param)); }
public DataTable GetAllChiTietChuyenKhoByMaPhieuChuyen(ChiTietChuyenKhoO ctpck) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaPhieuChuyen"; param.Value = ctpck.MaPhieuChuyen; return(conn.executeSelectQuery("proGetChiTietChuyenKho_HangHoa_DonVi_IfMaPhieuChuyen", param)); }
/* * public DataTable GetAllBanHangByMaKhachHang(BanHangO bh) * { * SqlParameter param = new SqlParameter(); * param.ParameterName = "@MaKhachHang"; * param.Value = bh.MaKhachHang; * return conn.executeSelectQuery("proGetBanHang_NhaCC_Kho_IfMaKH", param);///// * } */ public DataTable GetAllBanHangByMaPhieuBan(BanHangO bh) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaPhieuBan"; param.Value = bh.MaPhieuBan; return(conn.executeSelectQuery("proGetBanHang_KhachHang_Kho_IfMaPhieuBan", param)); }
public DataTable GetAllChiTietPhieuTraHangByMaPhieuTra(ChiTietTraHangO ctth) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaPhieuTra"; param.Value = ctth.MaPhieuTra; return(conn.executeSelectQuery("proGetChiTietTraHang_HangHoa_DonVi_IfMaPhieuTra", param));// }
public DataTable getLichDayTuongTu(LichDayVO lichDay) { DataTable dt = new DataTable(); string query = string.Format("select * from LichDayThucHanh where Tuan = @Tuan and Thu = @Thu and MaPhong = @MaPhong"); SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@Tuan", SqlDbType.Int); sqlParameters[0].Value = lichDay.Tuan; sqlParameters[1] = new SqlParameter("@Thu", SqlDbType.VarChar); sqlParameters[1].Value = lichDay.Thu; sqlParameters[2] = new SqlParameter("@MaPhong", SqlDbType.VarChar); sqlParameters[2].Value = lichDay.MaPhong; return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getPhongByMa(String Ma) { string query = string.Format("select * from Phong where MaPhong = @MaPhong"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@MaPhong", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(Ma); return(conn.executeSelectQuery(query, sqlParameters)); }
/// <method> /// Get User Email By Firstname or Lastname and return DataTable /// </method> public DataTable searchByName(string tenDangNhap, string matKhau, int quyen) { String query = ""; if (quyen == 1) { query = string.Format("select * from Admin where TenDangNhap = @username and MatKhau=@MatKhau"); } else { query = string.Format("select * from Account where TenDangNhap = @username and MatKhau=@MatKhau"); } SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@username", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(tenDangNhap); sqlParameters[1] = new SqlParameter("@MatKhau", SqlDbType.VarChar); sqlParameters[1].Value = Convert.ToString(matKhau); return(conn.executeSelectQuery(query, sqlParameters)); }