public bool UpdateCT_XuatKho(CT_XuatKhoDTO dtoCT_XuatKho)
{
string strQuery = "Update CT_XUATKHO Set ";
strQuery += "MAMATHANG = N'" + dtoCT_XuatKho.MaMatHang + "',";
strQuery += "SOLUONGXUAT = " + dtoCT_XuatKho.SoLuongXuat + ",";
strQuery += "GIATIEN = " + dtoCT_XuatKho.GiaTien + ",";
strQuery += "THANHTIEN = " + dtoCT_XuatKho.ThanhTien ;
strQuery += "Where MAHOADONXUAT = N'" + dtoCT_XuatKho.MaHoaDonXuat + "'";
return dp.ExecuteNonQuery(strQuery);
}
public bool InsertCT_XuatKho(CT_XuatKhoDTO dtoCT_XuatKho)
{
string strQuery = "Insert Into CT_XUATKHO Values(";
strQuery += "N'" + dtoCT_XuatKho.MaCTXuatKho + "',";
strQuery += "N'" + dtoCT_XuatKho.MaXuatKho + "',";
strQuery += "N'" + dtoCT_XuatKho.MaMatHang + "',";
strQuery += dtoCT_XuatKho.SoLuongXuat + ",";
strQuery += dtoCT_XuatKho.GiaTien + ",";
strQuery += dtoCT_XuatKho.ThanhTien + "," + dtoCT_XuatKho.TinhTrang + ")";
return dp.ExecuteNonQuery(strQuery);
}
public bool InsertCT_XuatKho(CT_XuatKhoDTO dtoCT_XuatKho)
{
return dalCTXuatKho.InsertCT_XuatKho(dtoCT_XuatKho);
}
private CT_XuatKhoDTO LayThongTinChiTietXuatKho(XuatKhoDTO dtoNhapKho, int i)
{
CT_XuatKhoDTO dtoCTXuat = new CT_XuatKhoDTO();
dtoCTXuat.MaCTXuatKho = cf.CreateId("CTX", "CT_XUATKHO");
dtoCTXuat.MaXuatKho = dtoNhapKho.MaXuatKho;
double dbGia = double.Parse(dgvMatHang.Rows[i].Cells["colGia"].Value.ToString());
dtoCTXuat.GiaTien = dbGia;
dtoCTXuat.MaMatHang = dgvMatHang.Rows[i].Cells["colMaMatHang"].Value.ToString();
dtoCTXuat.SoLuongXuat = int.Parse(dgvMatHang.Rows[i].Cells["colSoLuong"].Value.ToString());
dtoCTXuat.ThanhTien = double.Parse(dgvMatHang.Rows[i].Cells["colThanhTien"].Value.ToString());
dtoCTXuat.TinhTrang = "1";
return dtoCTXuat;
}
