public DataTable load_dgv(dichvu_DTO dv) { string query = "SELECT t_sudungdichvu.ID,t_loaidichvu.Ten,t_dichvu.Ten,t_dichvu.Dongia,t_sudungdichvu.Soluong FROM t_loaidichvu,t_thuephong,t_dichvu,t_sudungdichvu WHERE t_thuephong.ID =t_sudungdichvu.Idthuephong and t_loaidichvu.ID = t_dichvu.Idloai and t_dichvu.ID = t_sudungdichvu.Iddichvu and t_thuephong.ID ='" + dv.Int_temp + "'"; DataTable result = new DataTable(); result = processdata.Instance.ExecuteQuery(query); return(result); }
public DataTable loaddv(dichvu_DTO dv) { string query = "SELECT * FROM t_dichvu WHERE Idloai = N'" + dv.Temp + "'"; DataTable result = new DataTable(); result = processdata.Instance.ExecuteQuery(query); return(result); }
public DataTable loadkh(dichvu_DTO dv) { string query = "SELECT * FROM t_thuephong WHERE Idphong = '" + dv.Temp + "'"; DataTable result = new DataTable(); result = processdata.Instance.ExecuteQuery(query); return(result); }
public bool suadichvu(dichvu_DTO dv) { string query = "UPDATE t_sudungdichvu SET Soluong=N'" + dv.Soluong + "',Iddichvu=N'" + dv.Iddichvu + "' WHERE ID = " + dv.Idthuephong + ""; if (processdata.Instance.ExecuteNonQuery(query)) { return(true); } else { return(false); } }
public bool xoadichvu(dichvu_DTO dv) { string query = "DELETE FROM t_sudungdichvu WHERE ID= '" + dv.Int_temp + "'"; if (processdata.Instance.ExecuteNonQuery(query)) { return(true); } else { return(false); } }
public bool themdichvu(dichvu_DTO dv) { string query = "INSERT INTO t_sudungdichvu VALUES('" + dv.Idthuephong + "','" + dv.Iddichvu + "','" + dv.Soluong + "')"; if (processdata.Instance.ExecuteNonQuery(query)) { return(true); } else { return(false); } }
public bool suadichvu(dichvu_DTO dv) { return(dichvu_DAO.Instance.suadichvu(dv)); }
public bool themdichvu(dichvu_DTO dv) { return(dichvu_DAO.Instance.themdichvu(dv)); }
public DataTable load_dgv(dichvu_DTO dv) { return(dichvu_DAO.Instance.load_dgv(dv)); }