private void Loadfg()
{
fg.Tag = 0;
fg.BeginUpdate();
clsKho_VatTu cls = new clsKho_VatTu();
Byte loai = 0; //dang xem
if (!btnCapNhat.Visible)
{
loai = 1; //dang cap nhat
}
DataTable dt = cls.SelectDS_VatTu(int.Parse(cmbKho.GetValue("ID_Kho")), loai);
int iSTT = 1;
int i = fg.Rows.Fixed;
fg.Rows.Count = fg.Rows.Fixed;
foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
{
fg.Rows.Add();
fg[i, "STT"] = iSTT;
iSTT++;
fg[i, "Chon"] = dr["Chon"];
fg[i, "ID_Kho"] = dr["ID_Kho"];
fg[i, "Ten_Kho"] = dr["Ten_Kho"];
fg[i, "ID_VatTu"] = dr["ID_VatTu"];
fg[i, "Ten_VatTu"] = dr["Ten_VatTu"];
fg[i, "SoLuong"] = dr["SoLuong"];
i++;
}
fg.Row = -1;
fg.AutoSizeRows();
fg.EndUpdate();
fg.Tag = 1;
}
//Cach 1
private void CapNhatSLVatTuKhoVer1(int ID_QuyetDinh, byte trangthai)
{
clsQD_NhapVatTu_ChiTiet clsChiTiet = new clsQD_NhapVatTu_ChiTiet();
clsKho_VatTu clsKVT = new clsKho_VatTu();
DataTable dt = clsChiTiet.SelectAllW_ID_QuyetDinh(ID_QuyetDinh);
foreach (DataRow dr in dt.Rows)
{
clsKVT.ID_Kho = Convert.ToInt32(dr["ID_Kho"]);
clsKVT.ID_VatTu = Convert.ToInt32(dr["ID_VatTu"]);
bool bInsert = clsKVT.SelectOne().Rows.Count == 0;
if (trangthai == 5)
{
if (bInsert)
{
clsKVT.SoLuong = Convert.ToInt32(dr["SoLuong"]);
clsKVT.Insert();
}
else
{
clsKVT.SoLuong = clsKVT.SoLuong + Convert.ToInt32(dr["SoLuong"]);
clsKVT.Update();
}
}
else if (trangthai == 3)
{
clsKVT.SoLuong = clsKVT.SoLuong - Convert.ToInt32(dr["SoLuong"]);
clsKVT.Update();
}
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (m_bFlag)
{
if (!IsValid())
{
return;
}
clsKho_VatTu cls = new clsKho_VatTu();
cls.ID_Kho = int.Parse("0" + cmbKho.EditValue);
cls.DeleteWID_KhoLogic();
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
if (fg.GetBoolValue(i, "Chon"))
{
cls.ID_VatTu = fg.GetIntValue(i, "ID_VatTu");
cls.SoLuong = fg.GetIntValue(i, "SoLuong");
cls.Insert();
}
}
BaseMessages.ShowInformationMessage("Cập nhật thành công!");
LockEdit(true);
Loadfg();
fg.Filter("Ten_Kho", cmbKho.GetValue("Ten_Kho"));
fg.SetSTT();
}
else
{
if (!IsValidXuatKho())
{
return;
}
clsKho_VatTu cls = new clsKho_VatTu();
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
if (fg.GetBoolValue(i, "Chon"))
{
//Xuat Kho
cls.Xuat_Kho(Convert.ToInt32(fg[i, "ID_Kho"]), Convert.ToInt32(fg[i, "ID_VatTu"]),
Convert.ToInt32(fg[i, "SoLuongXuat"]), Convert.ToInt32(fg[i, "ID_KhoXuat"]));
}
}
BaseMessages.ShowInformationMessage("Cập nhật thành công!");
LockEdit(true);
LockEditXuatKho(true);
Loadfg();
fg.Filter("Ten_Kho", cmbKho.GetValue("Ten_Kho"));
fg.SetSTT();
}
}
private void fgVatTu_Click(object sender, EventArgs e)
{
if (fgVatTu.Tag + "" == "0" || fgVatTu.Row <= 1)
{
return;
}
fgChiTiet.Tag = 0;
fgChiTiet.BeginUpdate();
clsKho_VatTu cls = new clsKho_VatTu();
DataTable dt = cls.Select_TheKho_WT_VatTu_PN((int)cboKho.EditValue, int.Parse(fgVatTu[fgVatTu.Row, "ID_VatTu"].ToString()));
int iSTT = 0;
int sumPN = 0;
int sumPX = 0;
fgChiTiet.Rows.Count = fgChiTiet.Rows.Fixed + 1;
fgChiTiet[fgChiTiet.Rows.Count - 1, "SoPhieu"] = "Tổng";
fgChiTiet.Rows[fgChiTiet.Rows.Count - 1].Style = cs;
foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
{
Row fgRow = fgChiTiet.Rows.Add();
iSTT++;
fgRow["STT"] = iSTT;
//fgRow["icon"] = Image.FromFile(@"D:\TTH\Project QLVatTu Mau\QLKho\QLKho\Resources\ico_forward.png");
fgChiTiet.SetCellImage(int.Parse(fgChiTiet.Rows.Count.ToString()) - 1, 2, Image.FromFile(@"D:\Ki7\T4-TKGD&CNLTTH\Project QLVatTu Mau\QLKho\QLKho\Resources\ico_forward.png"));
fgRow["SoPhieu"] = dr["So_QuyetDinh"];
fgRow["SoLuongNhap"] = dr["SoLuong"];
sumPN += int.Parse(fgRow["SoLuongNhap"].ToString());
}
fgChiTiet[fgChiTiet.Rows.Fixed, "SoLuongNhap"] = sumPN;
DataTable dtt = cls.Select_TheKho_WT_VatTu_PX((int)cboKho.EditValue, int.Parse(fgVatTu[fgVatTu.Row, "ID_VatTu"].ToString()));
foreach (DataRow dr in dtt.DefaultView.ToTable().Rows)
{
Row fgRow = fgChiTiet.Rows.Add();
iSTT++;
fgChiTiet.SetCellImage(int.Parse(fgChiTiet.Rows.Count.ToString()) - 1, 2, Image.FromFile(@"D:\Ki7\T4-TKGD&CNLTTH\Project QLVatTu Mau\QLKho\QLKho\Resources\ico_Back.png"));
fgRow["STT"] = iSTT;
fgRow["SoPhieu"] = dr["So_PhieuXuat"];
fgRow["SoLuongXuat"] = dr["SoLuong"];
sumPX += int.Parse(fgRow["SoLuongXuat"].ToString());
}
fgChiTiet[fgChiTiet.Rows.Fixed, "SoLuongXuat"] = sumPX;
fgChiTiet.Row = -1;
fgVatTu.AutoSizeRows();
fgChiTiet.EndUpdate();
fgChiTiet.Tag = 1;
}
private void btnGhiTheKho_Click(object sender, System.EventArgs e)
{
clsKho_VatTu cls = new clsKho_VatTu();
int HieuSo = cls.KiemTraSoLuong(int.Parse(fgQDX[fgQDX.Row, "ID_PhieuXuat"].ToString()), int.Parse(fgQDX[fgQDX.Row, "ID_Kho"].ToString()), 0);
if (HieuSo >= 0) // kiểm tra số lượng xuất
{
Duyet("Bạn có chắc chắn muốn ghi thẻ kho?", 6, "Ghi thành công!");
cls.Update_SoLuong_Xuat(int.Parse(fgQDX[fgQDX.Row, "ID_PhieuXuat"].ToString()), 6);
}
else
{
BaseMessages.ShowErrorMessage("Số lượng xuất lớn hơn số lượng trong kho. Vui lòng cập nhật.");
return;
}
}
//Cach 3
private void CapNhatSLVatTuKhoVer3(int ID_QuyetDinh, byte trangthai)
{
clsQD_NhapVatTu_ChiTiet clsChiTiet = new clsQD_NhapVatTu_ChiTiet();
clsKho_VatTu clsKVT = new clsKho_VatTu();
DataTable dt = clsChiTiet.SelectAllW_ID_QuyetDinh(ID_QuyetDinh);
foreach (DataRow dr in dt.Rows)
{
if (trangthai == 5)
{
clsKVT.Update_SoLuongVer3(Convert.ToInt32(dr["ID_Kho"]), Convert.ToInt32(dr["ID_VatTu"]), Convert.ToInt32(dr["SoLuong"]));
}
else if (trangthai == 3)
{
clsKVT.Update_SoLuongVer3(Convert.ToInt32(dr["ID_Kho"]), Convert.ToInt32(dr["ID_VatTu"]), (-1) * Convert.ToInt32(dr["SoLuong"]));
}
}
}
private void cboKho_EditValueChanged(object sender, EventArgs e)
{
fgVatTu.Tag = 0;
fgVatTu.BeginUpdate();
clsKho_VatTu cls = new clsKho_VatTu();
DataTable dt = cls.TonKho_WT_CboTonKho((int)cboKho.EditValue);
fgVatTu.Rows.Count = fgVatTu.Rows.Fixed + 1;
fgVatTu[fgVatTu.Rows.Count - 1, "Ten_VatTu"] = "Tổng";
fgVatTu.Rows[fgVatTu.Rows.Count - 1].Style = cs;
int iSTT = 0;
int sumN = 0;
int sumX = 0;
int sumT = 0;
foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
{
Row fgRow = fgVatTu.Rows.Add();
iSTT++;
fgRow["STT"] = iSTT;
fgRow["ID_VatTu"] = dr["ID_VatTu"];
fgRow["Ten_VatTu"] = dr["Ten_VatTu"];
fgRow["SoLuongNhap"] = dr["SoLuongNhap"];
fgRow["SoLuongXuat"] = dr["SoLuongXuat"];
fgRow["SoLuongTon"] = (int)fgRow["SoLuongNhap"] - (int)fgRow["SoLuongXuat"];
sumN += int.Parse(fgRow["SoLuongNhap"].ToString());
sumX += int.Parse(fgRow["SoLuongXuat"].ToString());
sumT += int.Parse(fgRow["SoLuongTon"].ToString());
}
fgVatTu[fgVatTu.Rows.Fixed, "SoLuongNhap"] = sumN;
fgVatTu[fgVatTu.Rows.Fixed, "SoLuongXuat"] = sumX;
fgVatTu[fgVatTu.Rows.Fixed, "SoLuongTon"] = sumT;
fgVatTu.Row = -1;
fgVatTu.AutoSizeRows();
DeleteRowFgChiTiet();
fgVatTu.EndUpdate();
fgVatTu.Tag = 1;
}
//Cach 2
private void CapNhatSLVatTuKhoVer2(int ID_QuyetDinh, byte trangthai)
{
clsKho_VatTu clsKVT = new clsKho_VatTu();
clsKVT.Update_SoLuong(ID_QuyetDinh, trangthai);
}
