private void btnSaveEdit_Click(object sender, EventArgs e)
{
DialogResult dr;
dr = MessageBox.Show("Bạn có muốn lưu dữ liệu không ?", "Xác nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
DataTable dt = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinPhieuXuatNL("WHERE PSO = '" + txtbPhieuSo.Text + "'");
DataTable dt3 = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinCTPhieuNhapNL("WHERE MSPXNL = '" + dt.Rows[0]["MSPXNL"].ToString() + "'");
PHIEU_XUAT_NGUYEN_LIEU.ChinhSuaPhieuXuatNL(int.Parse(dt.Rows[0]["MSPXNL"].ToString()), int.Parse(cbbKhoXuat.SelectedValue.ToString()), int.Parse(cbbKhoNhap.SelectedValue.ToString())
, txtLiDo.Text.ToString(), dtpNgayXuat.Value.Date, int.Parse(txtTongTien.Text.ToString()), txtbPhieuSo.Text.ToString(), txtNguoiGiao.Text.ToString());
// lưu ct_hóa đơn
PHIEU_XUAT_NGUYEN_LIEU.XoaCTPhieuXuatNguyenLieu(int.Parse(dt.Rows[0]["MSPXNL"].ToString()));
for (int i = 0; i < dt3.Rows.Count; i++)
{
NGUYEN_LIEU.CongThemNguyenLieu(int.Parse(dt3.Rows[i]["MSNL"].ToString()), int.Parse(dt3.Rows[i]["SOLUONG"].ToString()));
}
for (int i = 0; i < dgvXuatNL.Rows.Count - 1; i++)
{
PHIEU_XUAT_NGUYEN_LIEU.ThemCTPhieuXuatNguyenLieu(int.Parse(dt.Rows[0]["MSPXNL"].ToString()), int.Parse(dgvXuatNL.Rows[i].Cells[0].Value.ToString()),
int.Parse(dgvXuatNL.Rows[i].Cells[5].Value.ToString()),
int.Parse(dgvXuatNL.Rows[i].Cells[6].Value.ToString()), int.Parse(dgvXuatNL.Rows[i].Cells[7].Value.ToString()),
dgvXuatNL.Rows[i].Cells[4].Value.ToString() + dgvXuatNL.Rows[i].Cells[3].Value.ToString());
NGUYEN_LIEU.TruBotNguyenLieu(int.Parse(dgvXuatNL.Rows[i].Cells[0].Value.ToString()),
int.Parse(dgvXuatNL.Rows[i].Cells[5].Value.ToString()));
}
MessageBox.Show("Lưu dữ liệu thành công");
Reset();
btnSave.Enabled = false;
}
}
private void txtbPhieuSo_TextChanged(object sender, EventArgs e)
{
string PhieuSo = txtbPhieuSo.Text;
btnThemMoi.Visible = true;
btnReset.Visible = false;
DataTable TTPN = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinPhieuXuatNL("Where PSO ='" + PhieuSo + "'");
if (TTPN.Rows.Count > 0)
{
enableALL();
btnEdit.Visible = true;
btnSave.Visible = false;
DataTable CTPN = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinCTPhieuNhapNL("Where MSPXNL ='" + TTPN.Rows[0]["MSPXNL"] + "'");
ResetDataTable();
cbbKhoXuat.SelectedValue = TTPN.Rows[0]["MSKHOXUAT"].ToString();
cbbKhoNhap.SelectedValue = TTPN.Rows[0]["MSKHONHAP"].ToString();
dtpNgayXuat.Value = Convert.ToDateTime(TTPN.Rows[0]["NGAYXUAT"]);
txtLiDo.Text = TTPN.Rows[0]["LYDO"].ToString();
txtTongTien.Text = TTPN.Rows[0]["TONGTIENTT"].ToString();
txtNguoiGiao.Text = TTPN.Rows[0]["NGUOIVANCHUYEN"].ToString();
txtTienChu.Text = NumberToTextVN(decimal.Parse(TTPN.Rows[0]["TONGTIENTT"].ToString()));
for (int i = 0; i < CTPN.Rows.Count; i++)
{
DataGridViewRow row = (DataGridViewRow)dgvXuatNL.Rows[0].Clone();
row.Cells[0].Value = CTPN.Rows[i]["MSNL"];
DataTable CTNL = PHIEU_NHAP_NGUYEN_LIEU.LayThongTin1NL("Where MSNL ='" + CTPN.Rows[i]["MSNL"] + "'");
if (CTNL.Rows.Count > 0)
{
row.Cells[1].Value = CTNL.Rows[0]["TENNL"];
}
if (CTNL.Rows[0]["DVT"].ToString() == "bao" || CTNL.Rows[0]["DVT"].ToString() == "bình" || CTNL.Rows[0]["DVT"].ToString() == "cây")
{
row.Cells[3].Value = CTNL.Rows[0]["DVT"].ToString();
row.Cells[4].Value = "";
}
else
{
row.Cells[4].Value = CTNL.Rows[0]["DVT"].ToString();
row.Cells[3].Value = "";
}
row.Cells[5].Value = CTPN.Rows[i]["SOLUONG"];
row.Cells[6].Value = CTPN.Rows[i]["DONGIA"];
row.Cells[7].Value = CTPN.Rows[i]["SOTIENXUAT"];
dgvXuatNL.Rows.Add(row);
}
btnDelete.Enabled = true;
}
}
public string PhieuSoNext()
{
DataTable dt = PHIEU_XUAT_NGUYEN_LIEU.DemPhieuSo();
if (dt.Rows.Count > 0)
{
string current = dt.Rows[0]["PSO"].ToString();
current = current.Substring(2);
int cur = int.Parse(current);
cur = cur + 1;
string next = cur.ToString();
string PhieuSo = "PX";
char pad = '0';
next = next.PadLeft(7, pad);
return(PhieuSo + next);
}
else
{
return("PX0000001");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dr;
dr = MessageBox.Show("Bạn có muốn xóa liệu không ?", "Xác nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
DataTable dt = PHIEU_XUAT_NGUYEN_LIEU.LayPhieuXuatLieuByPhieuSo("WHERE PSO = '" + txtbPhieuSo.Text + "'");
if (int.Parse(dt.Rows[0]["count_mspn"].ToString()) > 0)
{
DataTable dt2 = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinPhieuXuatNL("WHERE PSO = '" + txtbPhieuSo.Text + "'");
DataTable dt3 = PHIEU_XUAT_NGUYEN_LIEU.LayThongTinCTPhieuNhapNL("WHERE MSPXNL = '" + dt2.Rows[0]["MSPXNL"].ToString() + "'");
PHIEU_XUAT_NGUYEN_LIEU.XoaCTPhieuXuatNguyenLieu(int.Parse(dt2.Rows[0]["MSPXNL"].ToString()));
PHIEU_XUAT_NGUYEN_LIEU.XoaPhieuXuatNguyenLieu(txtbPhieuSo.Text);
for (int i = 0; i < dt3.Rows.Count; i++)
{
NGUYEN_LIEU.CongThemNguyenLieu(int.Parse(dt3.Rows[i]["MSNL"].ToString()), int.Parse(dt3.Rows[i]["SOLUONG"].ToString()));
}
MessageBox.Show("Xóa dữ liệu thành công");
Reset();
}
}
}
