public static DanhMucDonViCollection SelectAll()
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_SelectAll_hoangda"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection NoiGuiListDmGiaTri(string LDM_ID)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("LDM_ID", LDM_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_NoiGuiListDmGiaTri_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReaderNoiGuiListDmGiaTri(rd));
}
}
return(List);
}
public static DanhMucDonViCollection DeleteByDM_Ma(string Username, string Ma)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("Username", Username);
obj[1] = new SqlParameter("Ma", Ma);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Delete_ByDMMa_hoangda_Fix", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection SelectAllByUserLDM_Ma(SqlConnection con, string Username, string LDM_Ma)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("Username", Username);
obj[1] = new SqlParameter("Ma", LDM_Ma);
using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblDanhMucDonVi_SelectDanhMucDonVi_By_GH_ID_LDM_Ma", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection SearchNguoiThao(string Top, string q)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("Top", Top);
obj[1] = new SqlParameter("q", q);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_SearchNguoiThao_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection DanhMucHeThog(string LDM_ID, string DM_Alias, string ListID)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[3];
if (!string.IsNullOrEmpty(LDM_ID))
{
obj[0] = new SqlParameter("LDM_ID", LDM_ID);
}
else
{
obj[0] = new SqlParameter("LDM_ID", DBNull.Value);
}
if (!string.IsNullOrEmpty(DM_Alias))
{
obj[1] = new SqlParameter("DM_Alias", DM_Alias);
}
else
{
obj[1] = new SqlParameter("DM_Alias", DBNull.Value);
}
if (!string.IsNullOrEmpty(ListID))
{
obj[2] = new SqlParameter("ListID", ListID);
}
else
{
obj[2] = new SqlParameter("ListID", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_HeThong_Select_SelectAll_hoangda_Fix", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection SearchByLDM(string LDM_Ma, string q, string Username)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[3];
if (string.IsNullOrEmpty(LDM_Ma))
{
obj[0] = new SqlParameter("LDM_Ma", DBNull.Value);
}
else
{
obj[0] = new SqlParameter("LDM_Ma", LDM_Ma);
}
if (string.IsNullOrEmpty(q))
{
obj[1] = new SqlParameter("q", DBNull.Value);
}
else
{
obj[1] = new SqlParameter("q", q);
}
if (string.IsNullOrEmpty(Username))
{
obj[2] = new SqlParameter("Username", DBNull.Value);
}
else
{
obj[2] = new SqlParameter("Username", Username);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_SearchByLDM_Username_hoangda", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DanhMucDonViCollection ByLdmAndPID(string LDM_ID, string PID)
{
DanhMucDonViCollection List = new DanhMucDonViCollection();
SqlParameter[] obj = new SqlParameter[2];
if (string.IsNullOrEmpty(LDM_ID))
{
obj[0] = new SqlParameter("LDM_ID", DBNull.Value);
}
else
{
obj[0] = new SqlParameter("LDM_ID", LDM_ID);
}
obj[1] = new SqlParameter("PID", PID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDanhMucDonVi_Select_ByLdmAndPID_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReaderSearch(rd));
}
}
return(List);
}
