public List <LopCN> GetListLopCN()
{
List <LopCN> list = new List <LopCN>();
DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetLopCNList");
foreach (DataRow item in data.Rows)
{
LopCN lopcn = new LopCN(item);
list.Add(lopcn);
}
return(list);
}
public List <LopCN> SearchLopCNByTenKhoa(string makhoa)
{
List <LopCN> list = new List <LopCN>();
string query = string.Format("select * from LOPCN where [dbo].[GetUnsignString](MAKHOA) " +
"like N'%'+[dbo].[GetUnsignString](N'{0}')+'%' ", makhoa);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
LopCN lopcn = new LopCN(item);
list.Add(lopcn);
}
return(list);
}
