public static List <TongTienDTO> LoadTongTienTheoPhong(string maphong)
{
string query = string.Format("usp_tdoanhthutheophong @maphong =N'%{0}%'", maphong);
DataTable table = DataProvider.ExecuteQuery(query);
List <TongTienDTO> lsTDT1 = new List <TongTienDTO>();
for (int i = 0; i < table.Rows.Count; i++)
{
TongTienDTO TT = new TongTienDTO();
TT.TongTien = (float)Convert.ToDouble(table.Rows[i]["tongdoanhthu"].ToString());
lsTDT1.Add(TT);
}
return(lsTDT1);
}
public static List <TongTienDTO> LoadTongDoanhThu()
{
string query = "usp_tdoanhthu";
DataTable table = DataProvider.ExecuteQuery(query);
List <TongTienDTO> lsTDT = new List <TongTienDTO>();
for (int i = 0; i < table.Rows.Count; i++)
{
TongTienDTO TT = new TongTienDTO();
TT.TongTien = (float)Convert.ToDouble(table.Rows[i]["tongdoanhthu"].ToString());
lsTDT.Add(TT);
}
return(lsTDT);
}
