private bool XuLySoLieu()
{
BaoCao = new List <BCCSThangDTO>();
Result = new List <PhieuMuaVatTuDTO>();
int count = 0, i = 0, number = 0;
if (yearBT.Text == "" || monthBT.Text == "")
{
return(false);
}
else if (int.Parse(yearBT.Text) < 0)
{
return(false);
}
else if (int.Parse(monthBT.Text) < 0 || int.Parse(monthBT.Text) >= 12)
{
return(false);
}
DateTime ngayTim = new DateTime(int.Parse(yearBT.Text), int.Parse(monthBT.Text), 1);
for (i = 0; i < ListPhieuMua.Count(); i++)
{
if (ListPhieuMua[i].NgayMuaPT.Month == ngayTim.Month && ListPhieuMua[i].NgayMuaPT.Year == ngayTim.Year)
{
Result.Add(ListPhieuMua[i]);
}
}
if (Result == null || Result.Count == 0)
{
return(false);
}
count = Result.Count();
number = listVatTu.Count();
for (i = 0; i < listVatTu.Count(); i++)
{
BCCSThangDTO Temp = new BCCSThangDTO();
Temp.MaCTChiPhiThangPT = monthBT.Text + yearBT.Text + (i).ToString();
Temp.MaChiPhiThangPT = monthBT.Text + yearBT.Text + i.ToString();
Temp.TenVatTuPT = listVatTu[i].TenVatTuPT;
Temp.MaVatTuPT = listVatTu[i].MaVatTuPT;
for (number = 0; number < Result.Count(); number++)
{
if (Result[number].MaVatTuPT == Temp.MaVatTuPT)
{
Temp.SoPhieuMuaPT++;
Temp.TongTriGiaPT = Temp.TongTriGiaPT + Result[number].SoTienPT;
}
}
Temp.TyLePT = Convert.ToDouble(Temp.SoPhieuMuaPT) / count;
if (Temp.SoPhieuMuaPT != 0 && Temp.TongTriGiaPT != 0)
{
BaoCao.Add(Temp);
}
Temp = null;
}
return(true);
}
public List <BCCSThangDTO> selectChiPhi()
{
string query = string.Empty;
query += "SELECT[mactchiphithang],[machiphithang],[mavattu],[sophieumua],[tongtrigia],[tyle]";
query += "FROM [CTCHIPHICHAMSOCTHANG]";
List <BCCSThangDTO> lsChiPhi = new List <BCCSThangDTO>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
BCCSThangDTO chiphi = new BCCSThangDTO();
chiphi.MaCTChiPhiThangPT = reader["mactchiphithang"].ToString();
chiphi.MaChiPhiThangPT = reader["machiphithang"].ToString();
chiphi.MaVatTuPT = int.Parse(reader["sophieumua"].ToString());
chiphi.SoPhieuMuaPT = int.Parse(reader["ngayTrong"].ToString());
chiphi.TongTriGiaPT = int.Parse(reader["tongtrigia"].ToString());
chiphi.TyLePT = double.Parse(reader["tyle"].ToString());
lsChiPhi.Add(chiphi);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(lsChiPhi);
}
public bool themChiPhi(BCCSThangDTO thang)
{
string query = string.Empty;
query += "INSERT INTO [CTCHIPHICHAMSOCTHANG] ([mactchiphithang],[machiphithang],[mavattu],[sophieumua],[tongtrigia],[tyle]) ";
query += "VALUES (@mactchiphithang,@machiphithang,@mavattu,@sophieumua,@tongtrigia,@tyle)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@mactchiphithang", thang.MaCTChiPhiThangPT);
cmd.Parameters.AddWithValue("@machiphithang", thang.MaChiPhiThangPT);
cmd.Parameters.AddWithValue("@mavattu", thang.MaVatTuPT);
cmd.Parameters.AddWithValue("@sophieumua", thang.SoPhieuMuaPT);
cmd.Parameters.AddWithValue("@tongtrigia", thang.TongTriGiaPT);
cmd.Parameters.AddWithValue("@tyle", thang.TyLePT);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public bool them(BCCSThangDTO thang)
{
bool result = ChiphiDAL.themChiPhi(thang);
return(result);
}
