public int maxid_bvlogin()
{
int s_maxid = 0;
sql = " select nvl(max(id),0) from " + schema + ".bv_login";
ds = ora_conn.getData(sql);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
s_maxid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
}
return(s_maxid);
}
public int maxid_bvdlogin()
{
int s_maxid = 0;
sql = " select max(id) from bv115.bv_dlogin";
ds = ora_conn.getData(sql);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
s_maxid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
}
return(s_maxid);
}
public DataSet load_bv_login(string username, string password)
{
ora_conn = new CConnection_Oracle();
ds = new DataSet();
sql = "select * from " + schema + ".bv_login where Upper(username)=Upper('" + username + "') and password='******'";
ds = ora_conn.getData(sql);
// AccessData libc = new AccessData();
//ds=libc.get_data(sql);
return(ds);
}
public DataSet load_DM_NhomKho()
{
ds = conn.getData("select * from medibv115.d_dmnhomkho");
return(ds);
}