public List <ProducerDebt> GetListProducerDebt()
{
List <ProducerDebt> list = new List <ProducerDebt>();
string query = "select * from ProducerDebt";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ProducerDebt producerDebt = new ProducerDebt(item);
list.Add(producerDebt);
}
return(list);
}
public List <ProducerDebt> SearchProducerDebtByName(string name)
{
List <ProducerDebt> list = new List <ProducerDebt>();
string query = string.Format("select * from ProducerDebt where dbo.fuConvertToUnsign1(name) like N'%' + dbo.fuConvertToUnsign1(N'{0}') + '%'", name);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ProducerDebt producerDebt = new ProducerDebt(item);
list.Add(producerDebt);
}
return(list);
}
