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 + "')"); }