public DataTable load_douongvoi_where(DOUONG_PUBLIC douong_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@MADM";
values[0] = douong_public.IDDM;
string sql = "LOAD_DOUONG_WITH_WHERE";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public DataTable load_timhd_old(HOADON_OLD_PUBLIC hd_old)
{
int paramater = 1;
string[] name = new string[paramater];
object[] values = new object[paramater];
name[0] = "@TEMBAN";
values[0] = hd_old.Soban;
string sql = "TIM_HOADON_OLD";
return(ketnoi.LoadDataWithParameter(sql, name, values, paramater));
}
public DataTable load_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
values[0] = cthd_old.IDHOADON_OLD;
string sql = "LOAD_CTHD_OLD";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public DataTable Tim_nv(NHANVIEN_PUBLIC nhanvien_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TEN";
values[0] = nhanvien_public.TIMTEN;
string sql = "TIM_TENNV";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}
public DataTable get_tenvaquyen_taikhoan(TAIKHOAN_PUBLIC taikhoan_public)
{
int parameter = 2;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TENTK";
name[1] = "@MATKHAU";
values[0] = taikhoan_public.TENTK;
values[1] = taikhoan_public.MATKHAU;
string sql = "GET_TENVAQUYEN_TAIKHOAN";
return(ketnoi.LoadDataWithParameter(sql, name, values, parameter));
}