private void dgvchitiet_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 1)
{
if (x == 1)
{
try { dgvchitiet.Rows.RemoveAt(e.RowIndex); }
catch { }
return;
}
ChiTietNhapDTO hh = new ChiTietNhapDTO();
hh.TenHang = dgvchitiet.Rows[e.RowIndex].Cells[2].Value.ToString();
hh.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
DataTable dt = HoaDonNhapDAO.TimHangHoa(hh.TenHang);
try
{
hh.SoLuong = int.Parse(dgvchitiet.Rows[e.RowIndex].Cells[3].Value.ToString());
hh.MaHangHoa = int.Parse(dt.Rows[0][0].ToString());
ChiTietNhapDAO.Xoa(hh);
LoadChiTiet(int.Parse(txtMaHD.Text.ToString()));
HoaDonNhapDTO hd = new HoaDonNhapDTO();
hd.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
}
catch
{
try { dgvchitiet.Rows.RemoveAt(e.RowIndex); }
catch { }
}
}
else
{
return;
}
}
private void Sua()
{
HoaDonNhapDTO hd = new HoaDonNhapDTO();
hd.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
hd.NgayNhap = dateNhap.Value.ToShortDateString();
hd.MaNhaCC = (int)cboCC.SelectedValue;
hd.TongTien = 0;
HoaDonNhapDAO.sua(hd);
ChiTietNhapDTO hh = new ChiTietNhapDTO();
hh.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
for (int i = 0; i < dgvchitiet.RowCount - 1; i++)
{
hh.TenHang = dgvchitiet.Rows[i].Cells[2].Value.ToString();
hh.SoLuong = int.Parse(dgvchitiet.Rows[i].Cells[3].Value.ToString());
hh.DonGia = int.Parse(dgvchitiet.Rows[i].Cells[4].Value.ToString());
hh.GiaXuat = int.Parse(dgvchitiet.Rows[i].Cells[4].Value.ToString()) * 2;
try { hh.GhiChu = dgvchitiet.Rows[i].Cells[0].Value.ToString(); }
catch { }
DataTable dt = HoaDonNhapDAO.TimHangHoa(hh.TenHang);
try
{
hh.MaHangHoa = int.Parse(dt.Rows[0][0].ToString());
ChiTietNhapDAO.SuaCT(hh);
}
catch
{
hh.MaHangHoa = ChiTietNhapDAO.IDMax() + 1;
ChiTietNhapDAO.themmoi(hh);
}
HoaDonNhapDAO.UpdateTongTien(hh);
}
}
public static bool UpdateTongTien(ChiTietNhapDTO hh)
{
string sTruyVan = string.Format("update tblHoaDonNhap set TongTien=(select sum(SoLuong*DonGia) from tblChiTietNhap a where a.MaHDNhap={0}) where MaHDNhap={0}", hh.MaHDNhap);
con = DataProvider.KetNoi();
DataProvider.ThucThiTruyVan(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(true);
}
public static ChiTietNhap MappingChiTietNhap(this ChiTietNhapDTO chitietnhapDTO)
{
return(new ChiTietNhap
{
MaNhap = chitietnhapDTO.MaNhap,
MaMon = chitietnhapDTO.MaMon,
DVT = chitietnhapDTO.DVT,
Ngay = chitietnhapDTO.Ngay,
TongTien = chitietnhapDTO.TongTien,
SoLuong = chitietnhapDTO.SoLuong
});
}
public static bool Xoa(ChiTietNhapDTO ct)
{
string sTruyVan = string.Format("update tblHangHoa set SoLuong=SoLuong-{0} where MaHangHoa={1}", ct.SoLuong, ct.MaHangHoa);
con = DataProvider.KetNoi();
DataProvider.ThucThiTruyVan(sTruyVan, con);
string s = string.Format("delete tblChiTietNhap where MaHDNhap={0} and MaHangHoa={1}", ct.MaHDNhap, ct.MaHangHoa);
DataProvider.ThucThiTruyVan(s, con);
DataProvider.DongKetNoi(con);
return(true);
}
public static bool themmoi(ChiTietNhapDTO hh)
{
string s = string.Format("insert into tblHangHoa values ({0},N'{1}',{2},{3},{4},N'{5}')", hh.MaHangHoa, hh.TenHang, hh.SoLuong, hh.DonGia, hh.GiaXuat, hh.GhiChu);
con = DataProvider.KetNoi();
DataProvider.ThucThiTruyVan(s, con);
string sTruyVan = string.Format("insert into tblChiTietNhap values ({0},{1},{2},{3})", hh.MaHDNhap, hh.MaHangHoa, hh.SoLuong, hh.DonGia);
DataProvider.ThucThiTruyVan(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(true);
}
public static bool SuaCT(ChiTietNhapDTO hh)
{
string sTruyVan = string.Format("update tblChiTietNhap set SoLuong={0},DonGia={1} where MaHDNhap={2} and MaHangHoa={3}", hh.SoLuong, hh.DonGia, hh.MaHDNhap, hh.MaHangHoa);
con = DataProvider.KetNoi();
DataProvider.ThucThiTruyVan(sTruyVan, con);
string s = string.Format("update tblHangHoa set GiaNhap={0},GiaXuat={1},GhiChu=N'{2}' where MaHangHoa={3}", hh.DonGia, hh.DonGia * 1.15, hh.GhiChu, hh.MaHangHoa);
DataProvider.ThucThiTruyVan(s, con);
string s1 = string.Format("update tblHangHoa set SoLuong=A from (select Sum(SoLuong)A from tblChiTietNhap where MaHangHoa={0})A where MaHangHoa={0}", hh.MaHangHoa);
DataProvider.ThucThiTruyVan(s1, con);
DataProvider.DongKetNoi(con);
return(true);
}
public static bool them(ChiTietNhapDTO hh)
{
string sTruyVan = string.Format("insert into tblChiTietNhap values ({0},{1},{2},{3})", hh.MaHDNhap, hh.MaHangHoa, hh.SoLuong, hh.DonGia);
con = DataProvider.KetNoi();
DataProvider.ThucThiTruyVan(sTruyVan, con);
string s = string.Format("update tblHangHoa set GiaNhap={0},GiaXuat={1},GhiChu=N'{2}' where MaHangHoa={3}", hh.DonGia, hh.GiaXuat, hh.GhiChu, hh.MaHangHoa);
DataProvider.ThucThiTruyVan(s, con);
string s1 = string.Format("update tblHangHoa set SoLuong=A from (select Sum(SoLuong)A from tblChiTietNhap where MaHangHoa={0})A where MaHangHoa={0}", hh.MaHangHoa);
DataProvider.ThucThiTruyVan(s1, con);
DataProvider.DongKetNoi(con);
return(true);
}
private void Xoa()
{
HoaDonNhapDTO hd = new HoaDonNhapDTO();
ChiTietNhapDTO ct = new ChiTietNhapDTO();
ct.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
hd.MaHDNhap = int.Parse(txtMaHD.Text.ToString());
for (int i = 0; i < dgvchitiet.RowCount; i++)
{
DataTable dt = HoaDonNhapDAO.TimHangHoa(dgvchitiet.Rows[i].Cells[2].Value.ToString());
try
{
ct.SoLuong = int.Parse(dgvchitiet.Rows[i].Cells[3].Value.ToString());
ct.MaHangHoa = int.Parse(dt.Rows[0][0].ToString());
ChiTietNhapDAO.Xoa(ct);
}
catch { }
}
HoaDonNhapDAO.Xoa(hd);
}
public void themChiTietNhap(ChiTietNhapDTO chitietnhapDTO)
{
_chitietnhapRepository.ThemChiTietNhap(chitietnhapDTO.MappingChiTietNhap());
}
public void suaChiTietNhap(ChiTietNhapDTO chitietnhapDTO)
{
_chitietnhapRepository.SuaChiTietNhap(chitietnhapDTO.MappingChiTietNhap());
}
