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); }