public int XoaDuLieu(EC_tblChiTietPhieuXuat et)
{
return(sql.XoaDuLieu(et));
}
public int ThemDuLieu(EC_tblChiTietPhieuXuat et)
{
return(sql.ThemDuLieu(et));
}
private void btnXuat_Click(object sender, EventArgs e)
{
if (cmbChinhanh.Text == "")
{
MessageBox.Show("Chưa chọn chi nhánh!");
return;
}
List <EC_tblChiTietPhieuXuat> listChitiet = new List <EC_tblChiTietPhieuXuat>();
List <EC_tblHangHoa> listHanghoa = new List <EC_tblHangHoa>();
float tong = 0;
DateTime date = DateTime.Now;
EC_tblPhieuXuat ecPhieuxuat = new EC_tblPhieuXuat();
ecPhieuxuat.MaCN = lblMachinhanh.Text;
ecPhieuxuat.NgayXuat = date.ToShortDateString();
ecPhieuxuat.MaPX = date.Month.ToString() + date.Day.ToString() + date.Hour.ToString() + date.Minute.ToString() + date.Second.ToString();
for (int i = 0; i < dgvHanghoa.RowCount; i++)
{
if (dgvHanghoa.Rows[i].Cells["SoLuongXuat"].Value != null && dgvHanghoa.Rows[i].Cells["SoLuongXuat"].Value.ToString().Trim() != "")
{
if (kTra(dgvHanghoa.Rows[dong].Cells["SoLuongXuat"].Value.ToString()) == 0)
{
MessageBox.Show("Nhập sai!");
dgvHanghoa.Rows[dong].Cells["SoLuongXuat"].Value = null;
return;
}
{
EC_tblChiTietPhieuXuat ecChitiet = new EC_tblChiTietPhieuXuat();
ecChitiet.MaPX = ecPhieuxuat.MaPX;
ecChitiet.MaHH = dgvHanghoa.Rows[i].Cells["MaHH"].Value.ToString();
ecChitiet.SoLuong = int.Parse(dgvHanghoa.Rows[i].Cells["SoLuongXuat"].Value.ToString());
ecChitiet.DonGia = int.Parse(dgvHanghoa.Rows[i].Cells["GiaXuat"].Value.ToString());
listChitiet.Add(ecChitiet);
tong += ecChitiet.SoLuong * ecChitiet.DonGia;
EC_tblHangHoa ecHanghoa = new EC_tblHangHoa();
ecHanghoa.MaHH = dgvHanghoa.Rows[i].Cells["MaHH"].Value.ToString();
ecHanghoa.SoLuong = int.Parse(dgvHanghoa.Rows[i].Cells["SoLuong"].Value.ToString()) - int.Parse(dgvHanghoa.Rows[i].Cells["SoLuongXuat"].Value.ToString());
if (ecHanghoa.SoLuong < 0)
{
MessageBox.Show("Không đủ hàng để xuất!");
dgvHanghoa.Rows[i].Cells["SoLuongXuat"].Value = null;
return;
}
listHanghoa.Add(ecHanghoa);
}
}
}
if (tong == 0)
{
MessageBox.Show("Chưa chọn hàng để xuất !");
return;
}
ecPhieuxuat.TongTien = tong;
phieuxuatbus.ThemDuLieu(ecPhieuxuat);
foreach (var ec in listChitiet)
{
chitietphieuxuatbus.ThemDuLieu(ec);
}
foreach (var ec in listHanghoa)
{
hangHoabus.SuaSoLuong(ec);
}
MessageBox.Show(String.Format("OK!\n Tổng tiền là : {0:10}", tong));
DataTable tb = chiNhanhbus.TaoBang(" where TenCN = '" + cmbChinhanh.Text + "'");
}
public int XoaDuLieu(EC_tblChiTietPhieuXuat et)
{
return(cn.ThucThiCauLenhSQL(@"DELETE FROM tblChiTietPhieuXuat where MaPX='" + et.MaPX + "' and MaHH = '" + et.MaHH + "'"));
}
public int SuaDuLieu(EC_tblChiTietPhieuXuat et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE tblChiTietPhieuXuat SET MaHH =N'" + et.MaHH + "', SoLuong =" + et.SoLuong + ", DonGia =" + et.DonGia + " where MaPX= '" + et.MaPX + "' and MaHH = '" + et.MaHH + "'"));
}
public int ThemDuLieu(EC_tblChiTietPhieuXuat et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO tblChiTietPhieuXuat (MaPX,MaHH,SoLuong,DonGia)
VALUES('" + et.MaPX + "', '" + et.MaHH + "'," + et.SoLuong + ", " + et.DonGia + ")"));
}
