Beispiel #1
0
 //列印
 private void tsbPrint_Click(object sender, EventArgs e)
 {
     if (CheckField())
     {
         SIS.DBClass.DBClassPurchaseMaster DBCPM = new DBClass.DBClassPurchaseMaster();
         bool result = DBCPM.QueryData(txtPurchaseID.Text);
         if (result)
         {
             FrmReportPrint FRP = new FrmReportPrint("PurchaseID", txtPurchaseID.Text, "rptPurchaseMaster");
             FRP.ShowDialog();
         }
         else
         {
             MessageBox.Show("沒有找到採購單號:[" + txtPurchaseID.Text + "]資料,無法列印!", "列印結果");
         }
     }
 }
Beispiel #2
0
        //查詢
        private void tsbQuery_Click(object sender, EventArgs e)
        {
            string Msg = "是否要進行採購單[" + txtPurchaseID.Text + "]查詢動作?\r\n";


            DialogResult DR;

            DR = MessageBox.Show(Msg, "查詢採購單", MessageBoxButtons.YesNo, MessageBoxIcon.Information);

            if (DR == DialogResult.Yes)
            {
                if (CheckField())
                {
                    SIS.DBClass.DBClassPurchaseMaster   DBCPM = new DBClass.DBClassPurchaseMaster();
                    SIS.Configuration.ClsPurchaseConfig CPC   = new Configuration.ClsPurchaseConfig();

                    bool result = DBCPM.QueryData(txtPurchaseID.Text, CPC);
                    if (result)
                    {
                        MessageBox.Show("有找到採購單號:[" + txtPurchaseID.Text + "]資料!\r\n是否將採購單資料載入?", "搜尋結果", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                        if (DR == DialogResult.Yes)
                        {
                            txtPurchaseID.Text              = CPC.PurchaseID;
                            dtpPurchaseDate.Text            = CPC.PurchaseDate;
                            dtpDeliveryDate.Text            = CPC.DeliveryDate;
                            cboManufacturer.Text            = My.MyMethod.SearchComboBoxItems(cboManufacturer, CPC.ManufacturerID);
                            cboPurchaseStaff.Text           = CPC.PurchaseStaff;
                            mtbPurchasePhone.Text           = CPC.PurchasePhone;
                            cboDeliveryAddress.Text         = CPC.DeliveryAddress;
                            cboPaymentType.Text             = My.MyMethod.SearchComboBoxItems(cboPaymentType, CPC.PaymentType);
                            txtBusinessTaxStockTaxRate.Text = CPC.BusinessTaxStockTaxRate.ToString();
                            txtTotalPreTax.Text             = CPC.TotalPreTax.ToString();
                            txtTax.Text           = CPC.Tax.ToString();
                            txtTotalAfterTax.Text = CPC.TotalAfterTax.ToString();
                            rtbNotes.Text         = CPC.Notes;

                            if (dgvPurchaseDetails.Rows.Count > 1)
                            {
                                btnRemoveItems_Click(sender, e);
                            }

                            for (int i = 0; i < CPC.PurchaseItems.Length; i++)
                            {
                                var index = dgvPurchaseDetails.Rows.Add();
                                dgvPurchaseDetails.Rows[index].Cells["ItemsID"].Value   = CPC.PurchaseItems[i].ItemsID;
                                dgvPurchaseDetails.Rows[index].Cells["NAME"].Value      = CPC.PurchaseItems[i].NAME;
                                dgvPurchaseDetails.Rows[index].Cells["Quantity"].Value  = CPC.PurchaseItems[i].Quantity.ToString();
                                dgvPurchaseDetails.Rows[index].Cells["ItemsUnit"].Value = CPC.PurchaseItems[i].ItemsUnit;
                                dgvPurchaseDetails.Rows[index].Cells["CostPrice"].Value = CPC.PurchaseItems[i].Price.ToString();
                                dgvPurchaseDetails.Rows[index].Cells["Totals"].Value    = CPC.PurchaseItems[i].Totals.ToString();
                                dgvPurchaseDetails.Rows[index].Cells["Notes"].Value     = CPC.PurchaseItems[i].Notes;
                            }
                            getTaxTotals();
                        }
                    }
                    else
                    {
                        MessageBox.Show("沒有找到採購單號:[" + txtPurchaseID.Text + "]資料!", "搜尋結果");
                    }
                }
            }
            else
            {
                MessageBox.Show("取消採購單查詢動作!!", "查詢採購單");
            }

            //if (DV.Count == 0)
            //{
            //    MessageBox.Show("搜尋條件並未找到任何符合資料", "搜尋結果", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
            //}
            //else
            //{
            //    MessageBox.Show("共找到資料筆數" + DV.Count.ToString(), "搜尋結果");
            //}
        }