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