public static List <ChiPhiDTO> LayChiPhiPhieuNhap()
{
SqlConnection connection = DataProvider.GetConnection();
string query = "SELECT SUM(tong_tien) chi_phi, MONTH(ngay_lap), YEAR(ngay_lap) FROM PhieuNhap WHERE trang_thai=1 AND YEAR(ngay_lap)=YEAR(GETDATE()) GROUP BY MONTH(ngay_lap), YEAR(ngay_lap) ORDER BY chi_phi DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <ChiPhiDTO> result = new List <ChiPhiDTO>();
if (reader.HasRows)
{
while (reader.Read())
{
ChiPhiDTO cp = new ChiPhiDTO();
cp.Thang = reader.GetInt32(1);
cp.ChiPhi = reader.GetDouble(0);
result.Add(cp);
}
}
connection.Close();
return(result);
}
public static int kiemtrachiphi(string maphong)
{
try
{
string sQuery = string.Format("usp_MaChiPhi @maphong ={0}", maphong);
DataTable dt = DataProvider.ExecuteQuery(sQuery);
if (dt.Rows.Count > 0)
{
ChiPhiDTO cphiphu = new ChiPhiDTO();
cphiphu.machiphi = Int32.Parse(dt.Rows[0][0].ToString());
return(cphiphu.machiphi);
}
else
{
return(-1);
}
}
catch (Exception ex)
{
throw ex;
}
}