Пример #1
0
        public string CreateDonHangTraNCC()
        {
            string PhieuNhapHang, Temp_BH, Number_PC;

            PhieuNhapHang = "TH_" + objuser.UserName + "_000001"; //Trả về số phiếu thu
            Temp_BH       = "";                                   //Số phiếu tạm
            Number_PC     = "";                                   // Number phiếu thu
            string _stockout_PC = new PURCHASE_RETURNController().PURCHASE_RETURN_Search(objuser.UserName);

            Temp_BH = _stockout_PC;
            if (Temp_BH != "")
            {
                Number_PC     = Temp_BH.Substring(Temp_BH.Length - 6, 6);
                Number_PC     = (long.Parse(Number_PC.ToString()) + 1).ToString();
                PhieuNhapHang = Number_PC;
                for (int i = 0; i < 6 - Number_PC.Length; i++)
                {
                    PhieuNhapHang = "0" + PhieuNhapHang;
                }
                PhieuNhapHang = Temp_BH.Substring(0, Temp_BH.Length - 6) + PhieuNhapHang;
            }
            return(PhieuNhapHang);
        }
Пример #2
0
        private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            int rsstock = 1;

            objinbound.ID      = txtPhieuN.Text;
            objinbound.RefDate = DateTime.Now;
            objinbound.RefType = 1;
            //if (lookUpdieukhoan.GetColumnValue("Code").ToString() == "TM")
            objinbound.RefStatus = 0;
            //else
            //    objpurchaseorder.RefStatus = 1;
            objinbound.Status          = 0;
            objinbound.PaymentMethod   = new Guid(lookUpthanhtoan.GetColumnValue("ID").ToString());
            objinbound.TermID          = lookUpdieukhoan.GetColumnValue("Code").ToString();
            objinbound.PaymentDate     = dateNgayNhap.DateTime;
            objinbound.DeliveryDate    = dateEdithan.DateTime;
            objinbound.Barcode         = txtPhieuN.Text;
            objinbound.Employee_ID     = lookUpNVBH.GetColumnValue("Employee_ID").ToString();
            objinbound.Customer_ID     = txtMaNPP.Text;
            objinbound.CustomerName    = lookUpTenNPP.Text;
            objinbound.CustomerAddress = txtDiaChi.Text;
            objinbound.Currency_ID     = "VND";
            objinbound.DiscountDate    = DateTime.Now;
            objinbound.User_ID         = objuser.UserID;
            objinbound.Reason          = "Đơn Hàng Trả";
            objinbound.Active          = true;
            objinbound.ExchangeRate    = 1;
            objinbound.Amount          = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
            objinbound.FAmount         = double.Parse(gridView1.Columns["Amount"].SummaryItem.SummaryValue.ToString());
            PURCHASE_RETURNController test = new PURCHASE_RETURNController();

            objinbound_detail.Return_ID = txtPhieuN.Text;
            objinbound_detail.RefType   = 1;
            {
                if (gridView1.RowCount > 1)
                {
                    rsstock = test.PURCHASE_RETURN_Insert(objinbound);
                    for (int i = 0; i < gridView1.RowCount - 1; i++)
                    {
                        int rsstockdetail = -1;
                        objinbound_detail.ID       = Guid.NewGuid();
                        objinbound_detail.Stock_ID = repositoryItemLookUpEdit3.GetDataSourceValue(repositoryItemLookUpEdit3.Columns["Stock_ID"], repositoryItemLookUpEdit3.GetDataSourceRowIndex(repositoryItemLookUpEdit3.Columns["Stock_ID"], gridView1.GetRowCellValue(i, gridView1.Columns[2]).ToString())).ToString();
                        //objinbound.Stock_ID = lookUpKhoNhap.GetColumnValue("Stock_ID").ToString();
                        objinbound_detail.Product_ID     = gridView1.GetRowCellValue(i, gridView1.Columns[0]).ToString();
                        objinbound_detail.ProductName    = gridView1.GetRowCellValue(i, gridView1.Columns[1]).ToString();
                        objinbound_detail.Unit           = repositoryItemLookUpEdit4.GetDataSourceValue(repositoryItemLookUpEdit4.Columns["Unit_ID"], repositoryItemLookUpEdit4.GetDataSourceRowIndex(repositoryItemLookUpEdit4.Columns["Unit_ID"], gridView1.GetRowCellValue(i, gridView1.Columns[3]).ToString())).ToString();
                        objinbound_detail.UnitConvert    = 1;
                        objinbound_detail.CurrentQty     = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
                        objinbound_detail.Quantity       = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
                        objinbound_detail.UnitPrice      = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[5]).ToString());
                        objinbound_detail.Amount         = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[7]).ToString());
                        objinbound_detail.QtyConvert     = double.Parse(gridView1.GetRowCellValue(i, gridView1.Columns[4]).ToString());
                        objinbound_detail.RefPurchase_ID = gridView1.GetRowCellValue(i, gridView1.Columns["PO_ID"]).ToString();
                        objinbound_detail.RefInward_ID   = "";
                        if (gridView1.GetRowCellValue(i, gridView1.Columns["PN_ID"]).Equals(null))
                        {
                            objinbound_detail.RefInward_ID = "";
                        }
                        else
                        {
                            objinbound_detail.RefInward_ID = gridView1.GetRowCellValue(i, gridView1.Columns["PN_ID"]).ToString();
                        }
                        //objinbound_detail.Active = true;
                        //objpurchaseorder_detail.Batch = "LOT21112013";
                        objinbound_detail.Description = lookUpTenNPP.Text;
                        rsstockdetail = new PURCHASE_RETURN_DETAILController().PURCHASE_RETURN_DETAIL_Insert(objinbound_detail);
                        if (rsstockdetail == -1)
                        {
                            XtraMessageBox.Show("Lưu Thất Bại", "Thông Báo");
                            break;
                        }
                    }
                    _sys_log.MChine      = new MobilityNetwork().GetComputerName();
                    _sys_log.IP          = new MobilityNetwork().GetIP();
                    _sys_log.UserID      = objuser.UserID;
                    _sys_log.Created     = DateTime.Now;
                    _sys_log.Action_Name = "Thêm";
                    _sys_log.Description = "Thêm Đơn Hàng Trả" + "-" + txtPhieuN.Text;
                    _sys_log.Reference   = txtPhieuN.Text;
                    _sys_log.Module      = "Đơn Hàng Trả";
                    _sys_log.Active      = true;
                    SYS_LOGController insertlog = new SYS_LOGController();
                    insertlog.SYS_LOG_Insert(_sys_log);
                }
                else
                {
                    XtraMessageBox.Show("Chưa nhập hàng hóa", "Thông Báo");
                }
            }
            if (rsstock > -1)
            {
                XtraMessageBox.Show("Lưu Thành công", "Thông Báo");
                txtPhieuN.Text = CreateDonHangTraNCC();
                InitLookUp_dieukhoan();
                InitLookUp_thanhtoan();
                InitLookUpTenKH();
                //InitLookUpMaKH();
                InitLookUp_NhanVien();
                ReadXml_User();
                InitLookUpKhoHang();
                dtable.Rows.Clear();
            }
            else
            {
                XtraMessageBox.Show("Lưu Thất bại", "Thông Báo");
            }
        }