public DataTable login(string user, string pass) { try { const string strSQL = "SP_LOGIN"; string[] pNames = { "@username", "@pass" }; object[] pValues = { user, pass }; return(con.GetValue(strSQL, pNames, pValues)); } catch { return(null); } }
public DataTable findByID(string content) { try { const string strSQL = "SP_SELECT_KHACHHANG"; string[] pNames = { "@id" }; object[] pValues = { content }; return(con.GetValue(strSQL, pNames, pValues)); } catch { return(null); } }
public DataTable getHoaDon() { try { const string strSQL = "SP_GETALL_PHIEUTT"; string[] pNames = { "@content" }; object[] pValues = { "2" }; return(con.GetValue(strSQL, pNames, pValues)); } catch { return(null); } }
public DataTable searchObject(string content) { try { const string strSQL = "SP_SEARCH_DONGXE"; string[] pNames = { "@content" }; object[] pValues = { content }; return(con.GetValue(strSQL, pNames, pValues)); } catch { return(null); } }