public int SuaSoLuong(EC_tblHangHoa et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE tblHangHoa SET SoLuong =" + et.SoLuong + " where MaHH = N'" + et.MaHH + "'"));
}
public int XoaDuLieu(EC_tblHangHoa et)
{
return(cn.ThucThiCauLenhSQL(@"DELETE FROM tblHangHoa where MaHH=N'" + et.MaHH + "'"));
}
public int ThemDuLieu(EC_tblHangHoa et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO tblHangHoa (MaHH, TenHH, SoLuong, GiaNhap, GiaXuat, NSX, ThongTin)
VALUES(N'" + et.MaHH + "',N'" + et.TenHH + "','" + et.SoLuong + "','" + et.GiaNhap + "','" + et.GiaXuat + "',N'" + et.NSX + "',N'" + et.ThongTin + "')"));
}
public int SuaDuLieu(EC_tblHangHoa et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE tblHangHoa SET TenHH =N'" + et.TenHH + "', SoLuong ='" + et.SoLuong + "', GiaNhap ='" + et.GiaNhap + "', GiaXuat ='" +
et.GiaXuat + "', NSX =N'" + et.NSX + "', ThongTin =N'" + et.ThongTin + "' where MaHH=N'" + et.MaHH + "'"));
}
public int XoaDuLieu(EC_tblHangHoa et)
{
return(sql.XoaDuLieu(et));
}
public int SuaSoLuong(EC_tblHangHoa et)
{
return(sql.SuaSoLuong(et));
}
public int ThemDuLieu(EC_tblHangHoa et)
{
return(sql.ThemDuLieu(et));
}
public int SuaDuLieu(EC_tblHangHoa et)
{
return(sql.SuaDuLieu(et));
}
public void xoadulieu(EC_tblHangHoa et)
{
this.sql.xoadulieu(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 void suadulieu(EC_tblHangHoa et)
{
this.sql.suadulieu(et);
}
public void themdulieu(EC_tblHangHoa et)
{
this.sql.themdulieu(et);
}
public void xoadulieu(EC_tblHangHoa et)
{
this.cn.thucthicaulenh("DELETE FROM DMHangHoa where mahh='" + et.Mahh + "'");
}
public void suadulieu(EC_tblHangHoa et)
{
this.cn.thucthicaulenh("UPDATE DMHangHoa SET tenhh =N'" + et.Tenhh + "', soluong ='" + et.Soluong + "', donvitinh =N'" + et.Donvitinh + "', ngaynhap ='" + et.Ngaynhap + "' where mahh='" + et.Mahh + "'");
}
public void themdulieu(EC_tblHangHoa et)
{
this.cn.thucthicaulenh("INSERT INTO DMHangHoa (mahh, tenhh, soluong, donvitinh, ngaynhap) VALUES ('" + et.Mahh + "',N'" + et.Tenhh + "','" + et.Soluong + "',N'" + et.Donvitinh + "','" + et.Ngaynhap + "')");
}
