Пример #1
0
 private void initVariable()
 {
     try
     {
         OfficeDB.fillOfficeComboNew(cmbOfficeID);
         ProjectHeaderDB.fillprojectCombo(cmbProjectID);
         CustomerDB.fillCustomerComboNew(cmbCustomer);
         CurrencyDB.fillCurrencyComboNew(cmbCurrency);
         CatalogueValueDB.fillCatalogValueComboNew(cmbPaymentMode, "PaymentMode");
         CatalogueValueDB.fillCatalogValueComboNew(cmbFreightTerms, "Freight");
         dtDeliveryDate.Format       = DateTimePickerFormat.Custom;
         dtDeliveryDate.CustomFormat = "dd-MM-yyyy";
         dtPODate.Format             = DateTimePickerFormat.Custom;
         dtPODate.CustomFormat       = "dd-MM-yyyy";
         dtTrackingDate.Format       = DateTimePickerFormat.Custom;
         dtTrackingDate.CustomFormat = "dd-MM-yyyy";
         dtValidateDate.Format       = DateTimePickerFormat.Custom;
         dtValidateDate.CustomFormat = "dd-MM-yyyy";
         ShowAllDetails();
         btnClose.Focus();
     }
     catch (Exception ex)
     {
         MessageBox.Show("initVariable() : Error");
     }
 }
Пример #2
0
 private void initVariable()
 {
     try
     {
         //OfficeDB.fillOfficeComboNew(cmbOfficeID);
         ProjectHeaderDB.fillprojectCombo(cmbProject);
         CustomerDB.fillCustomerComboNew(cmbCustomer);
         CurrencyDB.fillCurrencyComboNew(cmbCurrency);
         CatalogueValueDB.fillCatalogValueComboNew(cmbTransportationMode, "TransportationMode");
         CustomerDB.fillLedgerTypeComboNew(cmbTransporter, "Transporter");
         //CatalogueValueDB.fillCatalogValueCombo(cmbPaymentTerms, "TermsOfPayment");
         CatalogueValueDB.fillCatalogValueComboNew(cmbOriginCountryID, "Country");
         // CatalogueValueDB.fillCatalogValueCombo(cmbInvoiceType, "POType");
         CatalogueValueDB.fillCatalogValueComboNew(cmbFinalDestinationCountryID, "Country");
         CatalogueValueDB.fillCatalogValueComboNew(cmbPreCarriageTransMode, "TransportationMode");
         // CatalogueValueDB.fillCatalogValueCombo(cmbFinalDestinationCountryID, "Country");
         //CatalogueValueDB.fillCatalogValueCombo(cmbPreCarriageTransMode, "TransportationMode");
         CatalogueValueDB.fillCatalogValueComboNew(cmbADCode, "ADCODES");
         //dtDeliveryDate.Format = DateTimePickerFormat.Custom;
         //dtDeliveryDate.CustomFormat = "dd-MM-yyyy";
         dtInvoiceDate.Format       = DateTimePickerFormat.Custom;
         dtInvoiceDate.CustomFormat = "dd-MM-yyyy";
         //dtTrackingDate.Format = DateTimePickerFormat.Custom;
         //dtTrackingDate.CustomFormat = "dd-MM-yyyy";
         //dtValidateDate.Format = DateTimePickerFormat.Custom;
         //dtValidateDate.CustomFormat = "dd-MM-yyyy";
         ShowAllDetails();
         btnClose.Focus();
     }
     catch (Exception ex)
     {
         MessageBox.Show("initVariable() : Error");
     }
 }
Пример #3
0
        public void creategrid()
        {
            frmPopup.Controls.Remove(grdEmpList);
            ProjectHeaderDB phdb = new ProjectHeaderDB();

            grdEmpList = phdb.getProjectlistGrid(prjstat);

            grdEmpList.Bounds = new Rectangle(new Point(0, 27), new Size(850, 300));
            frmPopup.Controls.Add(grdEmpList);
            grdEmpList.Columns["RowID"].Visible                         = false;
            grdEmpList.Columns["DocumentID"].Visible                    = false;
            grdEmpList.Columns["DocumentStatus"].Visible                = false;
            grdEmpList.Columns["DocumentName"].Visible                  = false;
            grdEmpList.Columns["TemporaryNo"].Visible                   = false;
            grdEmpList.Columns["TemporaryDate"].Visible                 = false;
            grdEmpList.Columns["TrackingNo"].Visible                    = false;
            grdEmpList.Columns["TrackingDate"].Visible                  = false;
            grdEmpList.Columns["ProjectManager"].Visible                = false;
            grdEmpList.Columns["CustomerID"].Visible                    = false;
            grdEmpList.Columns["Status"].Visible                        = false;
            grdEmpList.Columns["DocumentStatus"].Visible                = false;
            grdEmpList.Columns["CreateTime"].Visible                    = false;
            grdEmpList.Columns["CreateUser"].Visible                    = false;
            grdEmpList.Columns["ForwardUser"].Visible                   = false;
            grdEmpList.Columns["ApproveUser"].Visible                   = false;
            grdEmpList.Columns["CreatorName"].Visible                   = false;
            grdEmpList.Columns["ForwarderName"].Visible                 = false;
            grdEmpList.Columns["ApproverName"].Visible                  = false;
            grdEmpList.Columns["ForwarderList"].Visible                 = false;
            grdEmpList.Columns["OfficeID"].Visible                      = false;
            grdEmpList.Columns["OfficeName"].Visible                    = false;
            grdEmpList.Columns["ShortDescription"].Visible              = false;
            grdEmpList.Columns["ProjectStatus"].Visible                 = false;
            grdEmpList.Columns["ProjectID"].Width                       = 200;
            grdEmpList.Columns["CustomerName"].Width                    = 250;
            grdEmpList.Columns["ProjectManagerName"].Width              = 131;
            grdEmpList.Columns["StartDate"].DefaultCellStyle.Alignment  = DataGridViewContentAlignment.MiddleCenter;
            grdEmpList.Columns["TargetDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            foreach (DataGridViewColumn column in grdEmpList.Columns)
            {
                column.SortMode = DataGridViewColumnSortMode.Automatic;
            }
        }
Пример #4
0
 private void initVariable()
 {
     try
     {
         OfficeDB.fillOfficeComboNew(cmbOfficeID);
         CurrencyDB.fillCurrencyComboNew(cmbCurrencyID);
         ProjectHeaderDB.fillprojectCombo(cmbProjectID);
         CatalogueValueDB.fillCatalogValueComboNew(cmbBankTransMode, "BankTransactionMode");
         CatalogueValueDB.fillCatalogValueComboNew(cmbBookType, "DayBookType");
         dtTempDate.Format          = DateTimePickerFormat.Custom;
         dtTempDate.CustomFormat    = "dd-MM-yyyy";
         dtVoucherDate.Format       = DateTimePickerFormat.Custom;
         dtVoucherDate.CustomFormat = "dd-MM-yyyy";
         ShowAllDetails();
         btnClose.Focus();
     }
     catch (Exception ex)
     {
         MessageBox.Show("initVariable() : Error");
     }
 }