Esempio n. 1
0
        private void btnGhiTheKho_Click(object sender, EventArgs e)
        {
            if (fgQD.Row < 0)
            {
                BaseMessages.ShowInformationMessage("Chưa chọn quyết định.");
                return;
            }
            if (int.Parse(fgQD[fgQD.Row, "TrangThai"].ToString()) == 5)
            {
                clsTheKho cls = new clsTheKho();
                cls.ID_PhieuNhap = Convert.ToInt32(fgQD.GetDataDisplay(fgQD.Row, "ID_QuyetDinh"));
                cls.TonTai       = true;
                for (int i = fgChiTiet.Rows.Fixed; i < fgChiTiet.Rows.Count; i++)
                {
                    if (fgChiTiet.GetBoolValue(i, "Chon"))
                    {
                        cls.ID_VatTu       = fgChiTiet.GetIntValue(i, "ID_VatTu");
                        cls.ID_Kho         = fgChiTiet.GetIntValue(i, "ID_Kho");
                        cls.SoLuong_BanDau = cls.SoLuong_HienTai = fgChiTiet.GetIntValue(i, "SoLuong");
                        cls.Insert();
                    }
                }

                Duyet("Bạn có chắc chắn muốn ghi thẻ kho?", 6, "Ghi thành công!");
                //BaseMessages.ShowInformationMessage("Cập nhật thành công!");
                Loadfg();
            }
            else
            {
                BaseMessages.ShowWarningMessage("Phiếu chưa được phê duyệt");
                return;
            }
        }
Esempio n. 2
0
        private void LoadfgChiTietPhieuXuat(int ID_Kho)
        {
            fgChiTietXuat.BeginUpdate();
            clsTheKho cls  = new clsTheKho();
            DataTable dt   = cls.SelectVatTuWithID_Xuat(ID_Kho);
            int       iSTT = 1;
            int       sum  = 0;

            fgChiTietXuat.Rows.Count = fgChiTietXuat.Rows.Fixed + 1;
            fgChiTietXuat[fgChiTietXuat.Rows.Count - 1, "Ten_VatTu"]   = "Tổng";
            fgChiTietXuat[fgChiTietXuat.Rows.Count - 1, "SoLuongXuat"] = 0;
            fgChiTietXuat.Rows[fgChiTietXuat.Rows.Count - 1].Style     = cs;
            foreach (DataRow dr in dt.Rows)
            {
                Row fgRow = fgChiTietXuat.Rows.Add();
                fgRow["STT"] = iSTT;
                iSTT++;
                fgRow["ID_VatTu"]       = dr["ID_VatTu"];
                fgRow["Ten_VatTu"]      = dr["Ten_VatTu"];
                fgRow["SoLuongHienTai"] = dr["SoLuongHienTai"];
                fgRow["SoLuongXuat"]    = 0;
                sum += int.Parse(dr["SoLuongHienTai"].ToString());
                fgChiTietXuat.SetCellStyle(iSTT, 4, cs1);
            }
            fgChiTietXuat[fgChiTietXuat.Rows.Fixed, "SoLuongHienTai"] = sum;

            fgChiTietXuat.EndUpdate();
        }
Esempio n. 3
0
        private void LoadTheKhoSoLuongKhac()
        {
            int       sum  = 0;
            clsTheKho clss = new clsTheKho();
            DataTable dtt  = clss.SelectSoLuongPhieuKhac(int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()), int.Parse(cboKhoXuat.EditValue.ToString()));

            foreach (DataRow dr in dtt.Rows)
            {
                for (int j = fgChiTietTheKho.Rows.Fixed + 1; j < fgChiTietTheKho.Rows.Count; j++)
                {
                    if (int.Parse(dr["ID_TheKho"].ToString()) == int.Parse(fgChiTietTheKho.GetDataDisplay(j, "ID_TheKho")))
                    {
                        if (GlobalVariables.m_Flag == 0 || m_iTrangThai == (int)GlobalVariables.TrangThai.GhiTheKho)
                        {
                            fgChiTietTheKho[j, "SoLuongKhac"] = dr["SoLuongXuatOPhieuKhac"];
                        }
                        else
                        {
                            fgChiTietTheKho[j, "SoLuongKhac"] = int.Parse(dr["SoLuongXuatOPhieuKhac"].ToString()) - int.Parse(fgChiTietTheKho[j, "SoLuongXuat"].ToString());
                        }
                        sum += int.Parse(fgChiTietTheKho[j, "SoLuongKhac"].ToString());
                    }
                }
            }
            fgChiTietTheKho[fgChiTietTheKho.Rows.Fixed, "SoLuongKhac"] = sum;
        }
Esempio n. 4
0
        private void LoadTheKho()
        {
            var cbo = cboTheKho;

            cbo.Tag = 0;
            clsTheKho cls = new clsTheKho();
            DataTable dt  = cls.SelectAll();

            dt = dt.DefaultView.ToTable();
            cbo.Properties.DataSource    = dt;
            cbo.Properties.DisplayMember = "ID_TheKho";
            cbo.Properties.ValueMember   = "ID_TheKho";
            cbo.Tag = 1;
        }
Esempio n. 5
0
        private void LoadFgTheKho()
        {
            DataTable dt = new DataTable();

            if (GlobalVariables.m_Flag == 0)
            {
                clsTheKho cls = new clsTheKho();
                dt = cls.SelectVatTuWithID_XuatTheKho(int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()), int.Parse(cboKhoXuat.EditValue.ToString()));
            }
            else
            {
                clsTheKho cls = new clsTheKho();
                cls.ID_VatTu = int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString());
                cls.ID_Kho   = m_iID_Kho;
                dt           = cls.Select_TheKho_PX_PhieuNhap_SoLuong(m_iID_PX);
            }
            int iSTT = 1;

            fgChiTietTheKho.Rows.Count = fgChiTietTheKho.Rows.Fixed + 1;
            fgChiTietTheKho[fgChiTietTheKho.Rows.Count - 1, "ID_TheKho"] = "Tổng";
            fgChiTietTheKho.Rows[fgChiTietTheKho.Rows.Count - 1].Style   = cs;
            foreach (DataRow dr in dt.Rows)
            {
                Row fgRow = fgChiTietTheKho.Rows.Add();
                fgRow["STT"] = iSTT;
                iSTT++;
                fgRow["ID_TheKho"]       = dr["ID_TheKho"];
                fgRow["ID_PhieuNhap"]    = dr["ID_PhieuNhap"];
                fgRow["So_PhieuNhap"]    = dr["So_QuyetDinh"];
                fgRow["SoLuongTrongKho"] = dr["SoLuong_HienTai"];
                fgRow["Ngay_NhapKho"]    = dr["Ngay_QuyetDinh"];
                fgRow["SoLuongXuat"]     = 0;
                fgRow["SoLuongKhac"]     = 0;
                if (GlobalVariables.m_Flag != 0)
                {
                    fgRow["SoLuongXuat"] = dr["SoLuong"];
                }
                fgChiTietTheKho.SetCellStyle(iSTT, 7, cs1);
            }
        }
Esempio n. 6
0
        private void fgChiTietTheKho_AfterEdit(object sender, RowColEventArgs e)
        {
            int sl = 0;

            if (fgChiTietTheKho[fgChiTietTheKho.Row, "SoLuongXuat"] != null)
            {
                DataRow dr = m_dtTmp.NewRow();
                ThemMoiDataTableTmp(dr);
                m_dtTmp.Rows.Add(dr);
                UpdateSoLuongDataTableTmp(dr); // update số lượng vật tư trong thẻ kho khi thay đổi số lượng
            }
            clsTheKho cls = new clsTheKho();
            DataTable dt  = cls.SelectVatTuWithID_XuatTheKho(int.Parse(fgChiTietXuat[fgChiTietXuat.Row, "ID_VatTu"].ToString()), m_iID_Kho);

            for (int i = fgChiTietTheKho.Rows.Fixed + 1; i < fgChiTietTheKho.Rows.Count; i++)
            {
                if (fgChiTietTheKho[i, "SoLuongXuat"] != null)
                {
                    sl += int.Parse(fgChiTietTheKho[i, "SoLuongXuat"].ToString());
                }
            }
            UpdateFgPhieuXuatChiTiet(sl);
            UpdateFgPhieuXuat(sl);
        }