コード例 #1
0
        private void btnDoiLinhKien_Click(object sender, EventArgs e)
        {
            try
            {
                throw new ManagedException("Chức năng này chưa được thực hiện.");

                if (dgvMaVach.CurrentRow == null)
                {
                    throw new ManagedException("Bạn chưa chọn serial cần đổi.");
                }

                ChungTuNhapNccChiTietHangHoaInfo chiTietHangHoaInfo =
                    (ChungTuNhapNccChiTietHangHoaInfo)dgvMaVach.CurrentRow.DataBoundItem;

                //frmDoiMaLinhKien frmDoiMaLinhKien = new frmDoiMaLinhKien(chiTietHangHoaInfo);
            }
            catch (Exception ex)
            {
#if DEBUG
                MessageBox.Show(ex.ToString());
#else
                MessageBox.Show(ex.Message);
#endif
            }
        }
コード例 #2
0
 public void UpdateChiTietHangHoaNhapNcc(ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo)
 {
     ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuChiTietHangHoaUpdate,
                    chungTuNhapNccChiTietHangHoaInfo.IdChungTuChiTiet,
                    chungTuNhapNccChiTietHangHoaInfo.IdChiTietHangHoa,
                    chungTuNhapNccChiTietHangHoaInfo.SoLuong);
 }
コード例 #3
0
        private void btnXoa_Click(object sender, EventArgs e)
        {
            try
            {
                if (clsUtils.MsgXoa("Bạn có chắc chắn xóa không ?") == System.Windows.Forms.DialogResult.Yes)
                {
                    if (dgvMaVach.CurrentRow != null)
                    {
                        int idsanpham     = liMaVach[dgvMaVach.CurrentRow.Index].IdSanPham;
                        int soluongdaxuat = liMaVach[dgvMaVach.CurrentRow.Index].SoLuong;
                        for (int i = 0; i < lisx.Count; i++)
                        {
                            if (lisx[i].IdLinhKien == idsanpham)
                            {
                                lisx[i].SoLuongDaQuet = lisx[i].SoLuongTrenTPham - soluongdaxuat;
                            }
                        }
                        ChungTuNhapNccChiTietHangHoaInfo ct =
                            XLKBussiness.ListChiTietHangHoa.Find(delegate(ChungTuNhapNccChiTietHangHoaInfo math)
                        {
                            return(math.MaVach == liMaVach[dgvMaVach.CurrentRow.Index].MaVach &&
                                   math.IdSanPham == liMaVach[dgvMaVach.CurrentRow.Index].
                                   IdSanPham);
                        });
                        XLKBussiness.ListChiTietHangHoa.Remove(ct);
                        liMaVach.RemoveAt(dgvMaVach.CurrentRow.Index);
                    }
                    //dgvMaVach.DataSource = null;
                    //dgvMaVach.DataSource = liMaVach;
                    //if (dgvMaVach.DataSource != null)
                    //    (dgvMaVach.DataSource as BindingList<ChungTuNhapNccChiTietHangHoaInfo>).ResetBindings();
                    dgvMaVach.DataSource = null;
                    dgvMaVach.DataSource = liMaVach;

                    CheckMaThanhPham();
                }
            }
            catch (Exception ex)
            {
#if DEBUG
                MessageBox.Show(ex.ToString());
#else
                MessageBox.Show(ex.Message);
#endif
                EventLogProvider.Instance.WriteLog(ex.ToString()
                                                   + "\nUser: "******"\nKho: " + Declare.IdKho,
                                                   this.Name);
            }
        }
コード例 #4
0
        protected override void DeleteInstance()
        {
            if (dgvList.CurrentRow == null)
            {
                return;
            }

            ChungTuNhapNccChiTietHangHoaInfo chiTietHangHoaInfo =
                (ChungTuNhapNccChiTietHangHoaInfo)dgvList.CurrentRow.DataBoundItem;

            if (TblHangHoaChiTietDataProvider.DaDungChoGiaoDichKhac(chiTietHangHoaInfo.IdChiTietHangHoa))
            {
                throw new ManagedException("Mã vạch đã được sử dụng. Không thể thay đổi!");
            }

            dgvList.Rows.Remove(dgvList.CurrentRow);
            count--;
            SoLuongTong = count * HangHoa.DonGia;
            //btnXoaDong.Enabled = false;
            lblTongSoLuong.Text = "";
            lblthanhtien.Text   = "";
            lblTongSoLuong.Text = count.ToString();
            lblthanhtien.Text   = SoLuongTong.ToString();
        }
コード例 #5
0
        private void AutoGenAllChungTu()
        {
            try
            {
                NhapNccBusiness  khoBusiness;
                int              code    = 0;
                List <DMKhoInfo> listKho = DMKhoDataProvider.GetListDMKhoInfor();
                frmProgress.Instance.MaxValue = listKho.Count;
                frmProgress.Instance.Value    = 0;
                foreach (DMKhoInfo dmKhoInfo in listKho)
                {
                    currentKho      = dmKhoInfo;
                    currentTrungTam = DMTrungTamDataProvider.GetTrungTamByIdInfo(dmKhoInfo.IdTrungTam);
                    frmProgress.Instance.PushStatus();
                    TryLock();
                    frmProgress.Instance.PopStatus();
                    frmProgress.Instance.PushStatus();
                    frmProgress.Instance.MaxValue    = 5;
                    frmProgress.Instance.Value       = 0;
                    frmProgress.Instance.Description = currentKho.MaKho + ": Đang đồng bộ số liệu ... ";
                    isComplete = false;
                    SynsChungTuNhap();
                    frmProgress.Instance.PopStatus();
                    frmProgress.Instance.PushStatus();
                    frmProgress.Instance.Description = currentKho.MaKho + ": Đang import số liệu ...";
                    lstDataSource = tmp_NhapHang_UserProvider.GetNhapHangUserInfor(dmKhoInfo.IdKho);
                    frmProgress.Instance.MaxValue = lstDataSource.Count;
                    frmProgress.Instance.Value    = 0;
                    foreach (tmp_NhapHang_UserInfo tmpNhapHangUserInfo in lstDataSource)
                    {
                        frmProgress.Instance.Value += 1;
                        ChungTuXuatNhapNccInfo chungTuXuatNhapNccInfo = tblChungTuDataProvider.GetChungTuNhapNCCFromSoPO(
                            tmpNhapHangUserInfo.SoPO, tmpNhapHangUserInfo.SoPhieuNhap, Convert.ToInt32(TransactionType.NHAP_PO),
                            currentKho.IdKho, NgayLap, tmpNhapHangUserInfo.IdChungTu);

                        if (chungTuXuatNhapNccInfo == null)
                        {
                            chungTuXuatNhapNccInfo = new ChungTuXuatNhapNccInfo
                            {
                                SoChungTu   = CommonProvider.Instance.GetSoPhieu(Declare.Prefix.PhieuNhapHangMua),
                                NgayLap     = tmpNhapHangUserInfo.NgayNhap,
                                SoPO        = tmpNhapHangUserInfo.SoPO,
                                SoPhieuNhap = tmpNhapHangUserInfo.SoPhieuNhap,
                                LoaiChungTu = Convert.ToInt32(TransactionType.NHAP_PO),
                                IdDoiTuong  = tmpNhapHangUserInfo.IdDoiTuong,
                                IdKho       = currentKho.IdKho
                            };
                        }

                        khoBusiness = new NhapNccBusiness(chungTuXuatNhapNccInfo);

                        if (chungTuXuatNhapNccInfo.IdChungTu == 0)
                        {
                            khoBusiness.ListChiTietChungTu = KeToanNhapNccDataProvider.Instance.GetListNhapHangUserInfoFromOid(khoBusiness.ChungTu.SoPO, khoBusiness.ChungTu.SoPhieuNhap, Convert.ToInt32(LoaiGiaoDichPO.NHAP_HANG_NHA_CUNG_CAP), currentKho.IdKho);

                            foreach (ChungTuXuatNhapNccChiTietInfo chungTuXuatNhapNccChiTietInfo in khoBusiness.ListChiTietChungTu)
                            {
                                if (khoBusiness.ListChiTietHangHoa.Exists(delegate(ChungTuNhapNccChiTietHangHoaInfo match)
                                {
                                    return(match.IdSanPham == chungTuXuatNhapNccChiTietInfo.IdSanPham &&
                                           match.TransactionID == chungTuXuatNhapNccChiTietInfo.TransactionID);
                                }))
                                {
                                    continue;
                                }

                                //import ma vach tu file

                                dvFillter.RowFilter = String.Format("SoPO='{0}' and SoPhieuNhap='{1}' and MaSanPham='{2}' and MaKho='{3}'",
                                                                    chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, chungTuXuatNhapNccChiTietInfo.MaSanPham, dmKhoInfo.MaKho);

                                DataTable dtTemp = dvFillter.ToTable();
                                foreach (DataRow dataRow in dtTemp.Rows)
                                {
                                    ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo =
                                        new ChungTuNhapNccChiTietHangHoaInfo
                                    {
                                        DonGia           = 0,
                                        IdChungTuChiTiet = 0,
                                        IdSanPham        = chungTuXuatNhapNccChiTietInfo.IdSanPham,
                                        TransactionID    =
                                            chungTuXuatNhapNccChiTietInfo.TransactionID
                                    };
                                    chungTuNhapNccChiTietHangHoaInfo.MaVach  = Convert.ToString(dataRow["MaVach"]);
                                    chungTuNhapNccChiTietHangHoaInfo.SoLuong = Convert.ToInt32(dataRow["SoLuong"]);
                                    khoBusiness.ListChiTietHangHoa.Add(chungTuNhapNccChiTietHangHoaInfo);
                                }
                            }
                            try
                            {
                                if (khoBusiness.ListChiTietHangHoa.Count > 0)
                                {
                                    khoBusiness.SaveChungTu();
                                }
                                else
                                {
                                    File.AppendAllText(Application.StartupPath + "\\ChuaNhapMaVachResult.txt", "\n"
                                                       + " - SoChungTu: " + chungTuXuatNhapNccInfo.SoChungTu
                                                       + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                                }
                            }
                            catch (Exception ex)
                            {
                                File.AppendAllText(Application.StartupPath + "\\ImportResult.txt", "\n" + ex.Message
                                                   + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                            }
                        }
                        else //if (khoBusiness.ListChiTietHangHoa.Count == 0)
                        {
                            DataTable dtTemp = null;
                            foreach (ChungTuXuatNhapNccChiTietInfo chungTuXuatNhapNccChiTietInfo in khoBusiness.ListChiTietChungTu)
                            {
                                if (khoBusiness.GetListChiTietHangHoaByIdSanPham(chungTuXuatNhapNccChiTietInfo.IdSanPham).Count < chungTuXuatNhapNccChiTietInfo.SoLuong)
                                {
                                    dvFillter.RowFilter = String.Format("SoPO='{0}' and SoPhieuNhap='{1}' and MaSanPham='{2}' and MaKho='{3}'",
                                                                        chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, chungTuXuatNhapNccChiTietInfo.MaSanPham, dmKhoInfo.MaKho);

                                    dtTemp = dvFillter.ToTable();
                                    foreach (DataRow dataRow in dtTemp.Rows)
                                    {
                                        string maVach = Convert.ToString(dataRow["MaVach"]);
                                        if (khoBusiness.ListChiTietHangHoa.Exists(delegate(ChungTuNhapNccChiTietHangHoaInfo match)
                                        {
                                            return(match.MaVach == maVach);
                                        }))
                                        {
                                            continue;
                                        }
                                        ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo =
                                            new ChungTuNhapNccChiTietHangHoaInfo
                                        {
                                            DonGia           = 0,
                                            IdChungTuChiTiet = 0,
                                            IdSanPham        = chungTuXuatNhapNccChiTietInfo.IdSanPham,
                                            TransactionID    =
                                                chungTuXuatNhapNccChiTietInfo.TransactionID
                                        };
                                        chungTuNhapNccChiTietHangHoaInfo.MaVach  = maVach;
                                        chungTuNhapNccChiTietHangHoaInfo.SoLuong = Convert.ToInt32(dataRow["SoLuong"]);

                                        khoBusiness.ListChiTietHangHoa.Add(chungTuNhapNccChiTietHangHoaInfo);
                                    }
                                }
                            }
                            try
                            {
                                if (dtTemp != null && dtTemp.Rows.Count > 0 && khoBusiness.ListChiTietHangHoa.Count > 0)
                                {
                                    khoBusiness.SaveChungTu();
                                }
                                else
                                {
                                    //try
                                    //{
                                    //    khoBusiness.DeleteChungTu();
                                    //    tmp_NhapHang_LogDataProvider.Delete(chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, Convert.ToInt32(LoaiGiaoDichPO.NHAP_HANG_NHA_CUNG_CAP), Declare.IdKho);
                                    //}
                                    //catch (Exception)
                                    //{
                                    //    File.AppendAllText(Application.StartupPath + "\\ChuaNhapMaVachResult.txt", "\n"
                                    //        + " - SoChungTu: " + chungTuXuatNhapNccInfo.SoChungTu
                                    //        + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                                    //}
                                }
                            }
                            catch (Exception ex)
                            {
                                File.AppendAllText(Application.StartupPath + "\\ImportResult.txt", "\n" + ex.Message
                                                   + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                            }
                        }
                    }
                    frmProgress.Instance.PopStatus();
                    frmProgress.Instance.Value += 1;
                }

                frmProgress.Instance.Description = "Đã hoàn thành.";
                frmProgress.Instance.Value       = frmProgress.Instance.MaxValue;
                frmProgress.Instance.IsCompleted = true;
            }
            catch (Exception ex)
            {
#if DEBUG
                if (isComplete)
                {
                    MessageBox.Show(ex.ToString());
                }
#else
                if (isComplete)
                {
                    MessageBox.Show(ex.Message);
                }
#endif
                EventLogProvider.Instance.WriteLog(ex.ToString()
                                                   + "\nUser: "******"\nKho: " + Declare.IdKho,
                                                   this.Name);
            }
        }
コード例 #6
0
        private void AutoGenChungTu1()
        {
            NhapNccBusiness khoBusiness;
            int             code      = 0;
            DMKhoInfo       dmKhoInfo = DMKhoDataProvider.GetKhoByIdInfo(Declare.IdKho);

            foreach (tmp_NhapHang_UserInfo tmpNhapHangUserInfo in lstDataSource)
            {
                frmProgress.Instance.Value += 1;
                ChungTuXuatNhapNccInfo chungTuXuatNhapNccInfo = tblChungTuDataProvider.GetChungTuNhapNCCFromSoPO(
                    tmpNhapHangUserInfo.SoPO, tmpNhapHangUserInfo.SoPhieuNhap,
                    Convert.ToInt32(TransactionType.NHAP_PO), Declare.IdKho, NgayLap, tmpNhapHangUserInfo.IdChungTu);

                if (chungTuXuatNhapNccInfo == null)
                {
                    chungTuXuatNhapNccInfo = new ChungTuXuatNhapNccInfo
                    {
                        SoChungTu   = CommonProvider.Instance.GetSoPhieu(Declare.Prefix.PhieuNhapHangMua),
                        NgayLap     = tmpNhapHangUserInfo.NgayNhap,
                        SoPO        = tmpNhapHangUserInfo.SoPO,
                        SoPhieuNhap = tmpNhapHangUserInfo.SoPhieuNhap,
                        LoaiChungTu = Convert.ToInt32(TransactionType.NHAP_PO),
                        IdDoiTuong  = tmpNhapHangUserInfo.IdDoiTuong,
                        IdKho       = Declare.IdKho
                    };
                }

                khoBusiness = new NhapNccBusiness(chungTuXuatNhapNccInfo);

                if (chungTuXuatNhapNccInfo.IdChungTu == 0)
                {
                    khoBusiness.ListChiTietChungTu = KeToanNhapNccDataProvider.Instance.GetListNhapHangUserInfoFromOid(khoBusiness.ChungTu.SoPO, khoBusiness.ChungTu.SoPhieuNhap, Convert.ToInt32(LoaiGiaoDichPO.NHAP_HANG_NHA_CUNG_CAP),
                                                                                                                       khoBusiness.ChungTu.NgayLap, chungTuXuatNhapNccInfo.IdChungTu);

                    foreach (ChungTuXuatNhapNccChiTietInfo chungTuXuatNhapNccChiTietInfo in khoBusiness.ListChiTietChungTu)
                    {
                        if (khoBusiness.ListChiTietHangHoa.Exists(delegate(ChungTuNhapNccChiTietHangHoaInfo match)
                        {
                            return(match.IdSanPham == chungTuXuatNhapNccChiTietInfo.IdSanPham &&
                                   match.TransactionID == chungTuXuatNhapNccChiTietInfo.TransactionID);
                        }))
                        {
                            continue;
                        }

                        //import ma vach tu file

                        dvFillter.RowFilter = String.Format("SoPO='{0}' and SoPhieuNhap='{1}' and MaSanPham='{2}' and MaKho='{3}'",
                                                            chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, chungTuXuatNhapNccChiTietInfo.MaSanPham, dmKhoInfo.MaKho);

                        DataTable dtTemp = dvFillter.ToTable();
                        foreach (DataRow dataRow in dtTemp.Rows)
                        {
                            ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo =
                                new ChungTuNhapNccChiTietHangHoaInfo
                            {
                                DonGia           = 0,
                                IdChungTuChiTiet = 0,
                                IdSanPham        = chungTuXuatNhapNccChiTietInfo.IdSanPham,
                                TransactionID    =
                                    chungTuXuatNhapNccChiTietInfo.TransactionID
                            };
                            chungTuNhapNccChiTietHangHoaInfo.MaVach  = Convert.ToString(dataRow["MaVach"]);
                            chungTuNhapNccChiTietHangHoaInfo.SoLuong = Convert.ToInt32(dataRow["SoLuong"]);
                            khoBusiness.ListChiTietHangHoa.Add(chungTuNhapNccChiTietHangHoaInfo);
                        }
                        #region Auto gen mavach
                        //tu sinh ma vach

                        //for (int i = 0; i < chungTuXuatNhapNccChiTietInfo.SoLuong; i++)
                        //{
                        //    ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo =
                        //        new ChungTuNhapNccChiTietHangHoaInfo
                        //            {
                        //                DonGia = 0,
                        //                IdChungTuChiTiet = 0,
                        //                IdSanPham = chungTuXuatNhapNccChiTietInfo.IdSanPham,
                        //                TransactionID =
                        //                    chungTuXuatNhapNccChiTietInfo.TransactionID,
                        //                SoLuong =
                        //                    chungTuXuatNhapNccChiTietInfo.TrungMaVach == 0
                        //                        ? 1
                        //                        : chungTuXuatNhapNccChiTietInfo.SoLuong,
                        //                MaVach =
                        //                    chungTuXuatNhapNccChiTietInfo.MaSanPham + Declare.IdKho + DateTime.Now.Day +
                        //                    code.ToString().PadLeft(5, '0')
                        //            };

                        //    khoBusiness.ListChiTietHangHoa.Add(chungTuNhapNccChiTietHangHoaInfo);

                        //code += 1;

                        //if (chungTuXuatNhapNccChiTietInfo.TrungMaVach == 1)
                        //{
                        //    break;
                        //}
                        //else
                        //{
                        //    HangHoa_ChiTietInfo hangHoaChiTietInfo = TblHangHoaChiTietDataProvider.GetHangHoaChiTietByMaVach(Declare.IdKho,
                        //                                                            chungTuXuatNhapNccChiTietInfo.
                        //                                                                IdSanPham,
                        //                                                            chungTuNhapNccChiTietHangHoaInfo
                        //                                                                .MaVach, 0);
                        //    if (hangHoaChiTietInfo != null)
                        //    {
                        //        chungTuNhapNccChiTietHangHoaInfo.MaVach =
                        //            chungTuXuatNhapNccChiTietInfo.MaSanPham + Declare.IdKho + DateTime.Now.Day +
                        //            code.ToString().PadLeft(5, '0');
                        //        code += 1;
                        //    }
                        //}
                        //}
                        #endregion
                    }
                    try
                    {
                        if (khoBusiness.ListChiTietHangHoa.Count > 0)
                        {
                            khoBusiness.SaveChungTu();
                        }
                        else
                        {
                            File.AppendAllText(Application.StartupPath + "\\ChuaNhapMaVachResult.txt", "\n"
                                               + " - SoChungTu: " + chungTuXuatNhapNccInfo.SoChungTu
                                               + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                        }
                    }
                    catch (Exception ex)
                    {
                        File.AppendAllText(Application.StartupPath + "\\ImportResult.txt", "\n" + ex.Message
                                           + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                    }
                }
                else //if (khoBusiness.ListChiTietHangHoa.Count == 0)
                {
                    DataTable dtTemp = null;
                    foreach (ChungTuXuatNhapNccChiTietInfo chungTuXuatNhapNccChiTietInfo in khoBusiness.ListChiTietChungTu)
                    {
                        if (khoBusiness.GetListChiTietHangHoaByIdSanPham(chungTuXuatNhapNccChiTietInfo.IdSanPham).Count < chungTuXuatNhapNccChiTietInfo.SoLuong)
                        {
                            dvFillter.RowFilter = String.Format("SoPO='{0}' and SoPhieuNhap='{1}' and MaSanPham='{2}' and MaKho='{3}'",
                                                                chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, chungTuXuatNhapNccChiTietInfo.MaSanPham, dmKhoInfo.MaKho);

                            dtTemp = dvFillter.ToTable();
                            foreach (DataRow dataRow in dtTemp.Rows)
                            {
                                string maVach = Convert.ToString(dataRow["MaVach"]);
                                if (khoBusiness.ListChiTietHangHoa.Exists(delegate(ChungTuNhapNccChiTietHangHoaInfo match)
                                {
                                    return(match.MaVach == maVach);
                                }))
                                {
                                    continue;
                                }
                                ChungTuNhapNccChiTietHangHoaInfo chungTuNhapNccChiTietHangHoaInfo =
                                    new ChungTuNhapNccChiTietHangHoaInfo
                                {
                                    DonGia           = 0,
                                    IdChungTuChiTiet = 0,
                                    IdSanPham        = chungTuXuatNhapNccChiTietInfo.IdSanPham,
                                    TransactionID    =
                                        chungTuXuatNhapNccChiTietInfo.TransactionID
                                };
                                chungTuNhapNccChiTietHangHoaInfo.MaVach  = maVach;
                                chungTuNhapNccChiTietHangHoaInfo.SoLuong = Convert.ToInt32(dataRow["SoLuong"]);

                                khoBusiness.ListChiTietHangHoa.Add(chungTuNhapNccChiTietHangHoaInfo);
                            }
                        }
                    }
                    try
                    {
                        if (dtTemp != null && dtTemp.Rows.Count > 0 && khoBusiness.ListChiTietHangHoa.Count > 0)
                        {
                            khoBusiness.SaveChungTu();
                        }
                        else
                        {
                            //try
                            //{
                            //    khoBusiness.DeleteChungTu();
                            //    tmp_NhapHang_LogDataProvider.Delete(chungTuXuatNhapNccInfo.SoPO, chungTuXuatNhapNccInfo.SoPhieuNhap, Convert.ToInt32(LoaiGiaoDichPO.NHAP_HANG_NHA_CUNG_CAP), Declare.IdKho);
                            //}
                            //catch (Exception)
                            //{
                            //    File.AppendAllText(Application.StartupPath + "\\ChuaNhapMaVachResult.txt", "\n"
                            //        + " - SoChungTu: " + chungTuXuatNhapNccInfo.SoChungTu
                            //        + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                            //}
                        }
                    }
                    catch (Exception ex)
                    {
                        File.AppendAllText(Application.StartupPath + "\\ImportResult.txt", "\n" + ex.Message
                                           + " - PO: " + chungTuXuatNhapNccInfo.SoPO + " - PN: " + chungTuXuatNhapNccInfo.SoPhieuNhap);
                    }
                }
            }
            frmProgress.Instance.Description = "Đã hoàn thành.";
            frmProgress.Instance.Value       = frmProgress.Instance.MaxValue;
            frmProgress.Instance.IsCompleted = true;
        }
コード例 #7
0
        private void checkLinhKien()
        {
            ChungTu_ChiTietInfo chungtu =
                SanXuatLenhProvier.ChungTuCTGetByMaVach(Convert.ToInt32(TransactionType.XUAT_LINK_KIEN_SX),
                                                        txtMaVach.Text.Trim());

            sanpham = BangGiaReportDataProvider.Instance.SanPhamGetByMaVach(txtMaVach.Text.Trim());
            if (sanpham != null)
            {
                if (chungtu != null && sanpham.TrungMaVach == 0)
                {
                    ChungTuNhapNccChiTietHangHoaInfo ct = SanXuatLenhProvier.ChungTuGetSoChungTuGoc(chungtu.IdChungTu);
                    if (ct != null)
                    {
                        if (ct.SoChungTugoc.Equals(txtMaLenh.Text.Trim()))
                        {
                            ChungTuNhapNccChiTietHangHoaInfo mv = SanXuatLenhProvier.CheckMaVach(txtMaVach.Text.Trim());
                            if (mv != null)
                            {
                                if (clsUtils.MsgXoa("Mã vạch linh kiện đã tồn tại trong 1 thành phẩm ! bạn có muốn hiện thị thành phẩm này không ?") == DialogResult.Yes)
                                {
                                    isXuatLoi = true;
                                    liMaVach.Clear();
                                    liMaVach             = SanXuatLenhProvier.GetLinhKiemSXbyIdChungTu(chungtu.IdChungTu);
                                    dgvMaVach.DataSource = null;
                                    dgvMaVach.DataSource = liMaVach;
                                    txtMaVachTP.Text     = liMaVach[0].MaVachThanhPham;
                                    for (int i = 0; i < lisx.Count; i++)
                                    {
                                        for (int j = 0; j < liMaVach.Count; j++)
                                        {
                                            if (lisx[i].IdLinhKien == liMaVach[j].IdSanPham)
                                            {
                                                lisx[i].SoLuongDaQuet = lisx[i].SoLuongDaQuet + liMaVach[j].SoLuong;
                                            }
                                        }
                                    }
                                }
                                else
                                {
                                    txtMaVach.Text = "";
                                    txtMaVach.Focus();
                                }
                            }
                            else
                            {
                                txtMaVach.Text = "";
                                txtMaVach.Focus();
                                throw new ManagedException("Mã vạch đã hết tồn trong kho !");
                            }
                        }
                        else
                        {
                            Them();
                        }
                    }
                    else
                    {
                        Them();
                    }
                }
                else
                {
                    Them();
                }
            }
            else
            {
                Them();
            }
        }
コード例 #8
0
        private void Them()
        {
            string MaVach = "";

            if (HangHoa == null)
            {
                throw new ManagedException("Xin hãy chọn linh kiện để nhập mã vạch !");
            }
            if (txtMaVach.Text == "")
            {
                throw new ManagedException("Mã vạch không được để trống !");
            }
            else
            {
                sanpham = BangGiaReportDataProvider.Instance.SanPhamGetByMaVach(txtMaVach.Text.Trim());
                //if (sanpham != null)
                //{
                //    if (sanpham.TrungMaVach == 1)
                //    {
                //        colSoLuong.ReadOnly = false;
                //    }
                //}
                MaVach = txtMaVach.Text.Trim();
                if (liMaVach.Count > 0)
                {
                    foreach (ChungTuNhapNccChiTietHangHoaInfo pt in liMaVach)
                    {
                        SanXuatCTietLenhInfo info = lisx.Find(
                            delegate(SanXuatCTietLenhInfo match)
                        {
                            return(match.MaLinhKien == pt.MaSanPham);
                        });

                        if (pt.SoLuong < info.SoLuongTrenTPham && pt.MaVach == txtMaVach.Text.Trim() && pt.TrungMaVach == 1)
                        {
                            pt.SoLuong         = pt.SoLuong + 1;
                            info.SoLuongDaQuet = info.SoLuongDaQuet + 1;
                            ChungTuNhapNccChiTietHangHoaInfo ct = XLKBussiness.ListChiTietHangHoa.Find(delegate(ChungTuNhapNccChiTietHangHoaInfo marth)
                            {
                                return(marth.MaVach == pt.MaVach &&
                                       marth.IdSanPham == pt.IdSanPham);
                            });
                            XLKBussiness.ListChiTietHangHoa[XLKBussiness.ListChiTietHangHoa.IndexOf(ct)].SoLuong =
                                XLKBussiness.ListChiTietHangHoa[XLKBussiness.ListChiTietHangHoa.IndexOf(ct)].SoLuong + 1;
                            CheckMaThanhPham();
                            txtMaVach.Text = "";
                            txtMaVach.Focus();
                            return;
                        }
                        if (pt.MaVach == txtMaVach.Text.Trim() && pt.TrungMaVach == 0)
                        {
                            throw new ManagedException("Mã vạch không được trùng nhau !");
                        }
                    }
                }
                if (sanpham != null)
                {
                    int check = 0;
                    for (int i = 0; i < lisx.Count; i++)
                    {
                        if (sanpham.IdSanPham == lisx[i].IdLinhKien)
                        {
                            check = 1;
                            Check(i);
                            liMaVach.Add(new ChungTuNhapNccChiTietHangHoaInfo
                            {
                                MaVach       = txtMaVach.Text.Trim(),
                                TenDonViTinh = lisx[i].DonViTinh,
                                SoLuong      = 1,
                                IdSanPham    = lisx[i].IdLinhKien,
                                TenSanPham   = lisx[i].TenLinhKien,
                                MaSanPham    = lisx[i].MaLinhKien,
                                TrungMaVach  = lisx[i].TrungMaVach,
                                ThoiHanBH    = lisx[i].thoiHanBH
                            });
                            XLKBussiness.ListChiTietHangHoa.Add(new ChungTuNhapNccChiTietHangHoaInfo
                            {
                                MaVach       = txtMaVach.Text.Trim(),
                                TenDonViTinh = lisx[i].DonViTinh,
                                SoLuong      = 1,
                                IdSanPham    = lisx[i].IdLinhKien,
                                TenSanPham   = lisx[i].TenLinhKien,
                                MaSanPham    = lisx[i].MaLinhKien,
                                TrungMaVach  = lisx[i].TrungMaVach,
                                ThoiHanBH    = lisx[i].thoiHanBH
                            });
                            lisx[i].SoLuongDaQuet = lisx[i].SoLuongDaQuet + 1;
                        }
                    }
                    if (check == 0)
                    {
                        txtMaVach.Text = "";
                        txtMaVach.Focus();
                        throw new ManagedException("Không tồn tại linh kiện nào trong thành phẩm có mã vạch là : " + MaVach + " !");
                    }
                    txtMaVach.Text = "";
                    txtMaVach.Focus();
                }
                else
                {
                    txtMaVach.Text = "";
                    txtMaVach.Focus();
                    throw new ManagedException("Không tồn tại mã vạch : " + MaVach + " hoặc mã vạch đã hết tồn !");
                }
            }
            dgvMaVach.DataSource = null;
            dgvMaVach.DataSource = liMaVach;
            //if (dgvMaVach.DataSource != null)
            //    (dgvMaVach.DataSource as BindingList<ChungTuNhapNccChiTietHangHoaInfo>).ResetBindings();

            dgvChiTiet.DataSource = null;
            dgvChiTiet.DataSource = lisx;
            CheckMaThanhPham();
        }
コード例 #9
0
 internal void DeleteHangHoaChiTietNhapNcc(ChungTuNhapNccChiTietHangHoaInfo chiTietHanghoa)
 {
     ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuChiTietHangHoaDelete, chiTietHanghoa.IdChungTuChiTiet, chiTietHanghoa.IdChiTietHangHoa);
 }
コード例 #10
0
 internal void InsertChungTuChiTietHangHoaNhapNcc(ChungTuNhapNccChiTietHangHoaInfo Info)
 {
     ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuChiTietHangHoaNhapNCCInsert, Info.IdChungTuChiTiet,
                    Info.IdChiTietHangHoa,
                    Info.SoLuong);
 }