protected void insert(String pcode, frmStock load, TextBox[] textStocks, String date, String id) { try { DialogResult result = MessageBox.Show("Do you want to save this data?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); conn = new MySqlConnection(this.connection()); if (result == DialogResult.Yes) { conn.Open(); command = new MySqlCommand("INSERT INTO stocks (referenceNo, products_id, stockDate, stockInBy, vendor_id) VALUES (@referenceNo ,@id, @Date, @stockBy, @vendors)", conn); command.Parameters.AddWithValue("@referenceNo", textStocks[0].Text); command.Parameters.AddWithValue("@id", pcode); command.Parameters.AddWithValue("@Date", date); command.Parameters.AddWithValue("@stockBy", textStocks[1].Text); command.Parameters.AddWithValue("@vendors", id); bool checkResult = (int)command.ExecuteNonQuery() > 0; if (checkResult == true) { MessageBox.Show("You data save successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); load.loadStocks(); } } else { MessageBox.Show("You data is safe", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } command.Dispose(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// еще методы??? public stockSubsystem(dbProvider currentDbProvider) // конструктор { // создаем форму myFormStock // создаем myStatsComponent myDbProvider = currentDbProvider; // передаем ссылку на БД коннектор myFormStock = new frmStock(); }
protected void notOutofOrder(String id, frmStock load) { try { conn = new MySqlConnection(this.connection()); conn.Open(); using (command = new MySqlCommand("UPDATE stocks INNER JOIN product ON product.products_id = stocks.products_id SET status = 'Functioning' WHERE product.quantity > 0 AND stock_id = '" + id + "'", conn)) { bool check = (int)command.ExecuteNonQuery() > 0; if (check == true) { load.loadStocks(); } else { command = new MySqlCommand("UPDATE stocks INNER JOIN product ON product.products_id = stocks.products_id SET status = 'Out of order' WHERE product.quantity = 0 AND stock_id = '" + id + "'", conn); command.ExecuteNonQuery(); load.loadStocks(); } command.Dispose(); } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
protected void Delete(String id, frmStock load) { try { conn = new MySqlConnection(this.connection()); conn.Open(); DialogResult result = MessageBox.Show("Do you want to delete your data?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { using (command = new MySqlCommand("DELETE FROM stocks WHERE stock_id = @id", conn)) { command.Parameters.AddWithValue("@id", id); bool checkResult = (int)command.ExecuteNonQuery() > 0; if (checkResult == true) { MessageBox.Show("Deleted Successfully", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information); load.loadStocks(); } command.Dispose(); } } else { MessageBox.Show("Your Data is safe", "Safe", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Vendor events public void insertProduct(String pcode, frmStock load, TextBox[] textStocks, String date, String id) { bool isNum = error.checkNum(textStocks[0].Text); String isExist = this.isExist(pcode); if (isNum == true) { if (pcode == isExist) { MessageBox.Show("This Data is already exist please try again", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { foreach (TextBox isEmpty in textStocks) { if (string.IsNullOrEmpty(isEmpty.Text)) { MessageBox.Show("Dont leave the field empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } else { this.insert(pcode, load, textStocks, date, id); break; } } } } else { MessageBox.Show("Error Reference Number", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void stockToolStripMenuItem_Click(object sender, EventArgs e) { frmStock obj = new frmStock(); obj.MdiParent = this; obj.Show(); }
private void newProductToolStripMenuItem_Click(object sender, EventArgs e) { frmStock frm = new frmStock(); frm.TopLevel = false; panelParent.Controls.Add(frm); frm.BringToFront(); frm.Show(); }
private void btnStock_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (fr11 == null) { fr11 = new frmStock(); fr11.MdiParent = this; fr11.Show(); } }
private void stockToolStripMenuItem_Click(object sender, EventArgs e) { if (stock.IsDisposed) { stock = new frmStock(); } stock.MdiParent = this; stock.Show(); stock.BringToFront(); }
private void btnStock_Click(object sender, EventArgs e) { if (dgvList.Rows.Count > 0) { this.Visible = false; frmStock stock = new frmStock(Convert.ToInt32(dgvList.SelectedRows[0].Cells[0].Value)); stock.ShowDialog(); this.Visible = true; } }
private void tsbStock_Click(object sender, EventArgs e) { if (m_frmStock == null || m_frmStock.IsDisposed) { m_frmStock = new frmStock(this._SystemUser); m_frmStock.MdiParent = this; } this._SearchGood = m_frmStock.ISearchGood; m_frmStock.Visible = false; m_frmStock.Activate(); m_frmStock.WindowState = FormWindowState.Maximized; m_frmStock.Show(); this.tsslCurrent.Text = "当前操作:库存管理"; m_iOutput = m_frmStock.IOutput; }
public void updateDataStocks(String qty, String REF, String stockInBy, String id, frmStock update) { this.updateQuantity(qty, REF, stockInBy, id, update); }
protected void updateQuantity(String QTY, String REF, String stockInBy, String id, frmStock update) { try { conn = new MySqlConnection(this.connection()); conn.Open(); command = new MySqlCommand("UPDATE stocks INNER JOIN product ON product.products_id = stocks.products_id SET quantity = @qty, referenceNo = @ref, stockInBy = @stockby WHERE stock_id = @id ", conn); command.Parameters.AddWithValue("@qty", QTY); command.Parameters.AddWithValue("@ref", REF); command.Parameters.AddWithValue("@stockby", stockInBy); command.Parameters.AddWithValue("@id", id); bool result = (int)command.ExecuteNonQuery() > 0; if (result == true) { MessageBox.Show("Data Updated Successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); update.loadStocks(); update.getDataProducts(); } conn.Close(); command.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn1_Click(object sender, EventArgs e) { Form frmObj = null; Form open = null; SettingsSP spSettings = new SettingsSP(); try { string str = ((Button)sender).Text; btnFocus.Focus(); switch (str) { case "Contra Voucher": formMDI.MDIObj.ContraVoucherClick(); break; case "Payment Voucher": formMDI.MDIObj.PaymentVoucherClick(); break; case "Receipt Voucher": formMDI.MDIObj.ReceiptVoucherClick(); break; case "Journal Voucher": formMDI.MDIObj.JournalVoucherClick(); break; case "Sales Invoice": formMDI.MDIObj.SalesInvoiceClick(); break; case "Purchase Invoice": formMDI.MDIObj.PurchaseInvoiceClick(); break; case "POS": formMDI.MDIObj.POSClick(); break; case "PDC Payable": formMDI.MDIObj.PDCPayableClick(); break; case "PDC Receivable": formMDI.MDIObj.PDCReceivableClick(); break; case "PDC Clearance": formMDI.MDIObj.PDCClearenceClick(); break; case "Bank Reconciliation": frmObj = new frmBankReconciliation(); open = (Application.OpenForms["frmBankReconciliation"] as frmBankReconciliation); break; case "Purchase Order": formMDI.MDIObj.PurchaseOrderClick(); break; case "Material Reciept": formMDI.MDIObj.MaterialReceiptClick(); break; case "Rejection Out": formMDI.MDIObj.RejectionOutClick(); break; case "Purchase Return": formMDI.MDIObj.PurchaseReturnClick(); break; case "Sales Quotation": formMDI.MDIObj.SalesQuotationClick(); break; case "Sales Order": formMDI.MDIObj.SalesOrderClick(); break; case "Delivery Note": formMDI.MDIObj.DeliveryNoteClick(); break; case "Rejection In": formMDI.MDIObj.RejectionInClick(); break; case "Sales Return": formMDI.MDIObj.SalesReturnClick(); break; case "Physical Stock": formMDI.MDIObj.PhysicalStockClick(); break; case "Service Voucher": formMDI.MDIObj.ServiceVoucherClick(); break; case "Credit Note": formMDI.MDIObj.CreditNoteClick(); break; case "Debit Note": formMDI.MDIObj.DebitNoteClick(); break; case "Stock Journal": formMDI.MDIObj.StockJournalClick(); break; case "Bill Allocation": frmObj = new frmBillallocation(); open = (Application.OpenForms["frmBillallocation"] as frmBillallocation); break; case "Account Group": frmObj = new frmAccountGroup(); open = (Application.OpenForms["frmAccountGroup"] as frmAccountGroup); break; case "Account Ledger": frmObj = new frmAccountLedger(); open = (Application.OpenForms["frmAccountLedger"] as frmAccountLedger); break; case "Multiple Account Ledgers": frmObj = new frmmultipleAccountLedger(); open = (Application.OpenForms["frmmultipleAccountLedger"] as frmmultipleAccountLedger); break; case "Product Group": frmObj = new frmProductGroup(); open = (Application.OpenForms["frmProductGroup"] as frmProductGroup); break; case "Product Creation": frmObj = new frmProductCreation(); open = (Application.OpenForms["frmProductCreation"] as frmProductCreation); break; case "Multiple Product Creation": frmObj = new frmMultipleProductCreation(); open = (Application.OpenForms["frmMultipleProductCreation"] as frmMultipleProductCreation); break; case "Batch": if (spSettings.SettingsStatusCheck("AllowBatch") == "Yes") { frmObj = new frmBatch(); open = (Application.OpenForms["frmBatch"] as frmBatch); } break; case "Brand": frmObj = new frmBrand(); open = (Application.OpenForms["frmBrand"] as frmBrand); break; case "Model Number": if (spSettings.SettingsStatusCheck("AllowModelNo") == "Yes") { frmObj = new frmModalNo(); open = (Application.OpenForms["frmModalNo"] as frmModalNo); } break; case "Size": if (spSettings.SettingsStatusCheck("AllowSize") == "Yes") { frmObj = new frmSize(); open = (Application.OpenForms["frmSize"] as frmSize); } break; case "Unit": frmObj = new frmUnit(); open = (Application.OpenForms["frmUnit"] as frmUnit); break; case "Godown": if (spSettings.SettingsStatusCheck("AllowGodown") == "Yes") { frmObj = new frmGodown(); open = (Application.OpenForms["frmGodown"] as frmGodown); } break; case "Rack": if (spSettings.SettingsStatusCheck("AllowRack") == "Yes") { frmObj = new frmRack(); open = (Application.OpenForms["frmRack"] as frmRack); } break; case "Pricing Level": frmObj = new frmPricingLevel(); open = (Application.OpenForms["frmPricingLevel"] as frmPricingLevel); break; case "Price List": frmObj = new frmPriceList(); open = (Application.OpenForms["frmPriceList"] as frmPriceList); break; case "Standard Rate": frmObj = new frmStandardRate(); open = (Application.OpenForms["frmStandardRate"] as frmStandardRate); break; case "Tax": if (spSettings.SettingsStatusCheck("Tax") == "Yes") { frmObj = new frmTax(); open = (Application.OpenForms["frmTax"] as frmTax); } break; case "Currency": if (spSettings.SettingsStatusCheck("MultiCurrency") == "Yes") { frmObj = new frmCurrency(); open = (Application.OpenForms["frmCurrency"] as frmCurrency); } break; case "Exchange Rate": frmObj = new frmExchangeRate(); open = (Application.OpenForms["frmExchangeRate"] as frmExchangeRate); break; case "Service Category": frmObj = new frmServiceCategory(); open = (Application.OpenForms["frmServiceCategory"] as frmServiceCategory); break; case "Services": frmObj = new frmServices(); open = (Application.OpenForms["frmServices"] as frmServices); break; case "Voucher Type": frmObj = new frmVoucherType(); open = (Application.OpenForms["frmVoucherType"] as frmVoucherType); break; case "Area": frmObj = new frmArea(); open = (Application.OpenForms["frmArea"] as frmArea); break; case "Route": frmObj = new frmRoute(); open = (Application.OpenForms["frmRoute"] as frmRoute); break; case "Counter": frmObj = new frmCounter(); open = (Application.OpenForms["frmCounter"] as frmCounter); break; case "Product Register": frmObj = new frmProductRegister(); open = (Application.OpenForms["frmProductRegister"] as frmProductRegister); break; case "Salesman": frmObj = new frmSalesman(); open = (Application.OpenForms["frmSalesman"] as frmSalesman); break; case "Contra Register": frmObj = new frmContraRegister(); open = (Application.OpenForms["frmContraRegister"] as frmContraRegister); break; case "Payment Register": frmObj = new frmPaymentRegister(); open = (Application.OpenForms["frmPaymentRegister"] as frmPaymentRegister); break; case "Receipt Register": frmObj = new frmReceiptRegister(); open = (Application.OpenForms["frmReceiptRegister"] as frmReceiptRegister); break; case "Journal Register": frmObj = new frmJournalRegister(); open = (Application.OpenForms["frmJournalRegister"] as frmJournalRegister); break; case "PDC Payable Register": frmObj = new frmPDCPayableRegister(); open = (Application.OpenForms["frmPDCPayableRegister"] as frmPDCPayableRegister); break; case "PDC Receivable Register": frmObj = new frmPDCReceivableRegister(); open = (Application.OpenForms["frmPDCReceivableRegister"] as frmPDCReceivableRegister); break; case "PDC Clearance Register": frmObj = new frmPdcClearanceRegister(); open = (Application.OpenForms["frmPdcClearanceRegister"] as frmPdcClearanceRegister); break; case "Purchase Order Register": frmObj = new frmPurchaseOrderRegister(); open = (Application.OpenForms["frmPurchaseOrderRegister"] as frmPurchaseOrderRegister); break; case "Material Receipt Register": frmObj = new frmMaterialReceiptRegister(); open = (Application.OpenForms["frmMaterialReceiptRegister"] as frmMaterialReceiptRegister); break; case "Rejection Out Register": frmObj = new frmRejectionOutRegister(); open = (Application.OpenForms["frmRejectionOutRegister"] as frmRejectionOutRegister); break; case "Purchase Invoice Register": frmObj = new frmPurchaseInvoiceRegister(); open = (Application.OpenForms["frmPurchaseInvoiceRegister"] as frmPurchaseInvoiceRegister); break; case "Purchase Return Register": frmObj = new frmPurchaseReturnRegister(); open = (Application.OpenForms["frmPurchaseReturnRegister"] as frmPurchaseReturnRegister); break; case "Sales Quotation Register": frmObj = new frmSalesQuotationRegister(); open = (Application.OpenForms["frmSalesQuotationRegister"] as frmSalesQuotationRegister); break; case "Sales Order Register": frmObj = new frmSalesOrderRegister(); open = (Application.OpenForms["frmSalesOrderRegister"] as frmSalesOrderRegister); break; case "Delivery Note Register": frmObj = new frmDeliveryNoteRegister(); open = (Application.OpenForms["frmDeliveryNoteRegister"] as frmDeliveryNoteRegister); break; case "Rejection In Register": frmObj = new frmRejectionInRegister(); open = (Application.OpenForms["frmRejectionInRegister"] as frmRejectionInRegister); break; case "Sales Invoice Register": frmObj = new frmSalesInvoiceRegister(); open = (Application.OpenForms["frmSalesInvoiceRegister"] as frmSalesInvoiceRegister); break; case "Sales Return Register": frmObj = new frmSalesReturnRegister(); open = (Application.OpenForms["frmSalesReturnRegister"] as frmSalesReturnRegister); break; case "Physical Stock Register": frmObj = new frmPhysicalStockRegister(); open = (Application.OpenForms["frmPhysicalStockRegister"] as frmPhysicalStockRegister); break; case "Service Voucher Register": frmObj = new frmServiceVoucherRegister(); open = (Application.OpenForms["frmServiceVoucherRegister"] as frmServiceVoucherRegister); break; case "Credit Note Register": frmObj = new frmCreditNoteRegister(); open = (Application.OpenForms["frmCreditNoteRegister"] as frmCreditNoteRegister); break; case "Debit Note Register": frmObj = new frmDebitNoteRegister(); open = (Application.OpenForms["frmDebitNoteRegister"] as frmDebitNoteRegister); break; case "Stock Journal Register": frmObj = new frmStockJournalRegister(); open = (Application.OpenForms["frmStockJournalRegister"] as frmStockJournalRegister); break; case "Designation": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmDesignation(); open = (Application.OpenForms["frmDesignation"] as frmDesignation); } break; case "Pay Head": frmObj = new frmPayHead(); open = (Application.OpenForms["frmPayHead"] as frmPayHead); break; case "Salary Package Creation": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmSalaryPackageCreation(); open = (Application.OpenForms["frmSalaryPackageCreation"] as frmSalaryPackageCreation); } break; case "Salary Package Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmSalaryPackageRegister(); open = (Application.OpenForms["frmSalaryPackageRegister"] as frmSalaryPackageRegister); } break; case "Employee Creation": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmEmployeeCreation(); open = (Application.OpenForms["frmEmployeeCreation"] as frmEmployeeCreation); } break; case "Employee Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmEmployeeRegister(); open = (Application.OpenForms["frmEmployeeRegister"] as frmEmployeeRegister); } break; case "Holiday Settings": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmHolydaySettings(); open = (Application.OpenForms["frmHolydaySettings"] as frmHolydaySettings); } break; case "Monthly Salary Settings": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmMonthlySalarySettings(); open = (Application.OpenForms["frmMonthlySalarySettings"] as frmMonthlySalarySettings); } break; case "Attendance": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmAttendance(); open = (Application.OpenForms["frmAttendance"] as frmAttendance); } break; case "Advance Payment": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmAdvancePayment(); open = (Application.OpenForms["frmAdvancePayment"] as frmAdvancePayment); } break; case "Advance Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmAdvanceRegister(); open = (Application.OpenForms["frmAdvanceRegister"] as frmAdvanceRegister); } break; case "Bonus Deduction": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmBonusDeduction(); open = (Application.OpenForms["frmBonusDeduction"] as frmBonusDeduction); } break; case "Bonus Deduction Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmBonusDeductionRegister(); open = (Application.OpenForms["frmBonusDeductionRegister"] as frmBonusDeductionRegister); } break; case "Monthly Salary Voucher": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmMonthlySalaryVoucher(); open = (Application.OpenForms["frmMonthlySalaryVoucher"] as frmMonthlySalaryVoucher); } break; case "Monthly Salary Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmMonthlySalaryRegister(); open = (Application.OpenForms["frmMonthlySalaryRegister"] as frmMonthlySalaryRegister); } break; case "Daily Salary Voucher": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmDailySalaryVoucher(); open = (Application.OpenForms["frmDailySalaryVoucher"] as frmDailySalaryVoucher); } break; case "Daily Salary Register": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmDailySalaryRegister(); open = (Application.OpenForms["frmDailySalaryRegister"] as frmDailySalaryRegister); } break; case "Pay Slip": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmPaySlip(); open = (Application.OpenForms["frmPaySlip"] as frmPaySlip); } break; case "Budget": if (spSettings.SettingsStatusCheck("Budget") == "Yes") { frmObj = new frmBudget(); open = (Application.OpenForms["frmBudget"] as frmBudget); } break; case "Budget Variance": if (spSettings.SettingsStatusCheck("Budget") == "Yes") { frmObj = new frmBudgetVariance(); open = (Application.OpenForms["frmBudgetVariance"] as frmBudgetVariance); } break; case "Change Current Date": frmObj = new frmChangeCurrentDate(); open = (Application.OpenForms["frmChangeCurrentDate"] as frmChangeCurrentDate); break; case "Settings": frmObj = new frmSettings(); open = (Application.OpenForms["frmSettings"] as frmSettings); break; case "Role": frmObj = new frmRole(); open = (Application.OpenForms["frmRole"] as frmRole); break; case "Role Privilege Settings": frmObj = new frmRolePrivilegeSettings(); open = (Application.OpenForms["frmRolePrivilegeSettings"] as frmRolePrivilegeSettings); break; case "User Creation": frmObj = new frmUserCreation(); open = (Application.OpenForms["frmUserCreation"] as frmUserCreation); break; case "Change Password": frmObj = new frmChangePassword(); open = (Application.OpenForms["frmChangePassword"] as frmChangePassword); break; case "New Financial Year": frmObj = new frmNewFinancialYear(); open = (Application.OpenForms["frmNewFinancialYear"] as frmNewFinancialYear); break; case "Change Financial Year": frmObj = new frmChangeFinancialYear(); open = (Application.OpenForms["frmChangeFinancialYear"] as frmChangeFinancialYear); break; case "Barcode Settings": frmObj = new frmBarcodeSettings(); open = (Application.OpenForms["frmBarcodeSettings"] as frmBarcodeSettings); break; case "Barcode Printing": frmObj = new frmBarcodePrinting(); open = (Application.OpenForms["frmBarcodePrinting"] as frmBarcodePrinting); break; case "Suffix Prefix Settings": frmObj = new frmSuffixPrefixSettings(); open = (Application.OpenForms["frmSuffixPrefixSettings"] as frmSuffixPrefixSettings); break; case "Change Product Tax": frmObj = new frmChangeProductTax(); open = (Application.OpenForms["frmChangeProductTax"] as frmChangeProductTax); break; case "Product Search": frmObj = new frmProductSearch(); open = (Application.OpenForms["frmProductSearch"] as frmProductSearch); break; case "Voucher Search": frmObj = new frmVoucherSearch(); open = (Application.OpenForms["frmVoucherSearch"] as frmVoucherSearch); break; case "Voucher Wise Product Search": frmObj = new frmVoucherWiseProductSearch(); open = (Application.OpenForms["frmVoucherWiseProductSearch"] as frmVoucherWiseProductSearch); break; case "Personal Reminder": frmObj = new frmPersonalReminder(); open = (Application.OpenForms["frmPersonalReminder"] as frmPersonalReminder); break; case "Overdue Purchase Order": frmObj = new frmOverduePurchaseOrder(); open = (Application.OpenForms["frmOverduePurchaseOrder"] as frmOverduePurchaseOrder); break; case "Overdue Sales Order": frmObj = new frmOverdueSalesOrder(); open = (Application.OpenForms["frmOverdueSalesOrder"] as frmOverdueSalesOrder); break; case "Short Expiry": frmObj = new frmShortExpiry(); open = (Application.OpenForms["frmShortExpiry"] as frmShortExpiry); break; case "Stock": frmObj = new frmStock(); open = (Application.OpenForms["frmStock"] as frmStock); break; case "Trial Balance": frmObj = new frmTrialBalance(); open = (Application.OpenForms["frmTrialBalance"] as frmTrialBalance); break; case "Balance Sheet": frmObj = new frmBalanceSheet(); open = (Application.OpenForms["frmBalanceSheet"] as frmBalanceSheet); break; case "Profit and Loss": frmObj = new frmProfitAndLoss(); open = (Application.OpenForms["frmProfitAndLoss"] as frmProfitAndLoss); break; case "Cash Flow": frmObj = new frmCashFlow(); open = (Application.OpenForms["frmCashFlow"] as frmCashFlow); break; case "Fund Flow": frmObj = new frmFundFlow(); open = (Application.OpenForms["frmFundFlow"] as frmFundFlow); break; case "Chart of Account": frmObj = new frmChartOfAccount(); open = (Application.OpenForms["frmChartOfAccount"] as frmChartOfAccount); break; case "Contra Report": frmObj = new frmContraReport(); open = (Application.OpenForms["frmContraReport"] as frmContraReport); break; case "Payment Report": frmObj = new frmPaymentReport(); open = (Application.OpenForms["frmPaymentReport"] as frmPaymentReport); break; case "Receipt Report": frmObj = new frmReceiptReport(); open = (Application.OpenForms["frmReceiptReport"] as frmReceiptReport); break; case "Journal Report": frmObj = new frmJournalReport(); open = (Application.OpenForms["frmJournalReport"] as frmJournalReport); break; case "PDC Payable Report": frmObj = new frmPDCPayableReport(); open = (Application.OpenForms["frmPDCPayableReport"] as frmPDCPayableReport); break; case "PDC Receivable Report": frmObj = new frmPDCRecievableReport(); open = (Application.OpenForms["frmPDCRecievableReport"] as frmPDCRecievableReport); break; case "PDC Clearance Report": frmObj = new frmPDCClearanceReport(); open = (Application.OpenForms["frmPDCClearanceReport"] as frmPDCClearanceReport); break; case "Purchase Order Report": frmObj = new frmPurchaseOrderReport(); open = (Application.OpenForms["frmPurchaseOrderReport"] as frmPurchaseOrderReport); break; case "Material Receipt Report": frmObj = new frmMaterialReceiptReport(); open = (Application.OpenForms["frmMaterialReceiptReport"] as frmMaterialReceiptReport); break; case "Rejection Out Report": frmObj = new frmRejectionOutReport(); open = (Application.OpenForms["frmRejectionOutReport"] as frmRejectionOutReport); break; case "Purchase Invoice Report": frmObj = new frmPurchaseReport(); open = (Application.OpenForms["frmPurchaseReport"] as frmPurchaseReport); break; case "Purchase Return Report": frmObj = new frmPurchaseReturnReport(); open = (Application.OpenForms["frmPurchaseReturnReport"] as frmPurchaseReturnReport); break; case "Sales Quotation Report": frmObj = new frmSalesQuotationReport(); open = (Application.OpenForms["frmSalesQuotationReport"] as frmSalesQuotationReport); break; case "Sales Order Report": frmObj = new frmSalesOrderReport(); open = (Application.OpenForms["frmSalesOrderReport"] as frmSalesOrderReport); break; case "Delivery Note Report": frmObj = new frmDeliveryNoteReport(); open = (Application.OpenForms["frmDeliveryNoteReport"] as frmDeliveryNoteReport); break; case "Rejection In Report": frmObj = new frmRejectionInReport(); open = (Application.OpenForms["frmRejectionInReport"] as frmRejectionInReport); break; case "Sales Invoice Report": frmObj = new frmSalesReport(); open = (Application.OpenForms["frmSalesReport"] as frmSalesReport); break; case "Sales Return Report": frmObj = new frmSalesReturnReport(); open = (Application.OpenForms["frmSalesReturnReport"] as frmSalesReturnReport); break; case "Physical Stock Report": frmObj = new frmPhysicalStockReport(); open = (Application.OpenForms["frmPhysicalStockReport"] as frmPhysicalStockReport); break; case "Service Report": frmObj = new frmServiceReport(); open = (Application.OpenForms["frmServiceReport"] as frmServiceReport); break; case "Credit Note Report": frmObj = new frmCreditNoteReport(); open = (Application.OpenForms["frmCreditNoteReport"] as frmCreditNoteReport); break; case "Debit Note Report": frmObj = new frmDebitNoteReport(); open = (Application.OpenForms["frmDebitNoteReport"] as frmDebitNoteReport); break; case "Stock Journal Report": frmObj = new frmStockJournelReport(); open = (Application.OpenForms["frmStockJournelReport"] as frmStockJournelReport); break; case "Employee Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmEmployeeReport(); open = (Application.OpenForms["frmEmployeeReport"] as frmEmployeeReport); } break; case "Daily Attendance Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmDailyAttendanceReport(); open = (Application.OpenForms["frmDailyAttendanceReport"] as frmDailyAttendanceReport); } break; case "Monthly Attendance Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmMonthlyAttendanceReport(); open = (Application.OpenForms["frmMonthlyAttendanceReport"] as frmMonthlyAttendanceReport); } break; case "Daily Salary Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmDailySalaryReport(); open = (Application.OpenForms["frmDailySalaryReport"] as frmDailySalaryReport); } break; case "Monthly Salary Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmMonthlySalaryReport(); open = (Application.OpenForms["frmMonthlySalaryReport"] as frmMonthlySalaryReport); } break; case "Payhead Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmPayHeadReport(); open = (Application.OpenForms["frmPayHeadReport"] as frmPayHeadReport); } break; case "Salary Package Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmSalaryPackageReport(); open = (Application.OpenForms["frmSalaryPackageReport"] as frmSalaryPackageReport); } break; case "Advance Payment Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmAdvancePaymentReport(); open = (Application.OpenForms["frmAdvancePaymentReport"] as frmAdvancePaymentReport); } break; case "Bonus Deduction Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmBonusDeductionReport(); open = (Application.OpenForms["frmBonusDeductionReport"] as frmBonusDeductionReport); } break; case "Employee Address Book Report": if (spSettings.SettingsStatusCheck("Payroll") == "Yes") { frmObj = new frmEmployeeAddressBook(); open = (Application.OpenForms["frmEmployeeAddressBook"] as frmEmployeeAddressBook); } break; case "Day Book": frmObj = new frmDayBook(); open = (Application.OpenForms["frmDayBook"] as frmDayBook); break; case "Cash/Bank Book": frmObj = new frmCashBankBookReport(); open = (Application.OpenForms["frmCashBankBookReport"] as frmCashBankBookReport); break; case "Account Groupwise Report": frmObj = new frmAccountGroupwiseReport(); open = (Application.OpenForms["frmAccountGroupwiseReport"] as frmAccountGroupwiseReport); break; case "Account Ledger Report": frmObj = new frmAccountLedgerReport(); open = (Application.OpenForms["frmAccountLedgerReport"] as frmAccountLedgerReport); break; case "Outstanding Report": frmObj = new frmOutstandingReport(); open = (Application.OpenForms["frmOutstandingReport"] as frmOutstandingReport); break; case "Ageing Report": frmObj = new frmAgeingReport(); open = (Application.OpenForms["frmAgeingReport"] as frmAgeingReport); break; case "Party's Address Book": frmObj = new frmPartyAddressBook(); open = (Application.OpenForms["frmPartyAddressBook"] as frmPartyAddressBook); break; case "Stock Report": frmObj = new frmStockReport(); open = (Application.OpenForms["frmStockReport"] as frmStockReport); break; case "Short Expiry Report": frmObj = new frmShortExpiryReport(); open = (Application.OpenForms["frmShortExpiryReport"] as frmShortExpiryReport); break; case "Product Statistics": frmObj = new frmProductStatistics(); open = (Application.OpenForms["frmProductStatistics"] as frmProductStatistics); break; case "Price List Report": frmObj = new frmPriceListReport(); open = (Application.OpenForms["frmPriceListReport"] as frmPriceListReport); break; case "Tax Report": frmObj = new frmTaxReport(); open = (Application.OpenForms["frmTaxReport"] as frmTaxReport); break; case "VAT Report": frmObj = new frmVatReturnReport(); open = (Application.OpenForms["frmVatReturnReport"] as frmVatReturnReport); break; case "Cheque Report": frmObj = new frmChequeReport(); open = (Application.OpenForms["frmChequeReport"] as frmChequeReport); break; case "Free Sale Report": frmObj = new frmFreeSaleReport(); open = (Application.OpenForms["frmFreeSaleReport"] as frmFreeSaleReport); break; case "Product Vs Batch Report": frmObj = new frmProductVsBatchReport(); open = (Application.OpenForms["frmProductVsBatchReport"] as frmProductVsBatchReport); break; case "Customer": frmObj = new frmCustomer(); open = (Application.OpenForms["frmCustomer"] as frmCustomer); break; case "Supplier": frmObj = new frmSupplier(); open = (Application.OpenForms["frmSupplier"] as frmSupplier); break; } if (frmObj != null) { if (open == null) { frmObj.MdiParent = formMDI.MDIObj; frmObj.Show(); } else { open.Activate(); if (open.WindowState == FormWindowState.Minimized) { open.WindowState = FormWindowState.Normal; } } } } catch (Exception ex) { MessageBox.Show("QL:4" + ex.Message, "Openmiracle", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
public void notOrder(String id, frmStock load) { this.notOutofOrder(id, load); }
private void btnLogin_Click(object sender, EventArgs e) { // ตรวจสอบการป้อนข้อมูล if (txtUsername.Text == "" || txtPassword.Text == "") { MessageBox.Show("ป้อนข้อมูลให้ครับก่อน", "ผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // มีการป้อนข้อมูลแล้ว นำ username, password ไปตรวจสอบกับข้อมูลในตาราง string connectionString = "server=.\\sqlexpress;database=dbBookShop;integrated security=true"; using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); // MessageBox.Show("connect ok"); // คลาสที่ใช้งานในการ SELECT ข้อมูล sqlDataAdapter, DataTable, คำสั่ง SQL // string sql = "SELECT * FROM tbEmployee WHERE Username='******' AND Password='******' "; string sql = "SELECT * FROM tbEmployee WHERE Username=@Username AND Password=@Password"; SqlDataAdapter da = new SqlDataAdapter(sql, con); da.SelectCommand.Parameters.AddWithValue("@Username", txtUsername.Text); da.SelectCommand.Parameters.AddWithValue("@Password", txtPassword.Text); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count < 1) { MessageBox.Show("ไม่พบข้อมูล", "ผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // กรณีพบข้อมูล ตรวจสอบสถานะผู้ใช้งาน if (dt.Rows[0]["PosID"].ToString() == "1") { // MessageBox.Show("พนักงานขาย"); frmSaleMenu frm = new frmSaleMenu(dt.Rows[0]["EmpName"].ToString(), dt.Rows[0]["EmpID"].ToString()); frm.Show(); this.Hide(); } else if (dt.Rows[0]["PosID"].ToString() == "2") { // MessageBox.Show("พนักงานคลังสินค้า"); int EmpID = int.Parse(dt.Rows[0]["EmpID"].ToString()); frmStock frm = new frmStock(EmpID); frm.Show(); this.Hide(); } else if (dt.Rows[0]["PosID"].ToString() == "3") { // MessageBox.Show("ผู้จัดการร้าน"); frmManager frm = new frmManager(); frm.Show(); } else if (dt.Rows[0]["PosID"].ToString() == "4") { /// MessageBox.Show("ผู้ดูแลระบบ"); frmAdmin frm = new frmAdmin(dt.Rows[0]["EmpName"].ToString()); frm.Show(); } } }
private void tsbLock_Click(object sender, EventArgs e) { this.toolStripTop.Visible = false; this.MainMenuStrip.Visible = false; this.StatusBarBottom.Visible = false; if (m_frmPurchas != null && !m_frmPurchas.IsDisposed) { m_frmPurchas.Visible = !m_frmPurchas.Visible; } if (m_frmSell != null && !m_frmSell.IsDisposed) { m_frmSell.Visible = !m_frmSell.Visible; } if (m_frmStock != null && !m_frmStock.IsDisposed) { m_frmStock.Visible = !m_frmStock.Visible; } if (m_frmProviders != null && !m_frmProviders.IsDisposed) { m_frmProviders.Visible = !m_frmProviders.Visible; } if (m_frmUserManage != null && !m_frmUserManage.IsDisposed) { m_frmUserManage.Visible = !m_frmUserManage.Visible; } if (m_frmRecodrd != null && !m_frmRecodrd.IsDisposed) { m_frmRecodrd.Visible = !m_frmRecodrd.Visible; } Login l = new Login(); l._CurrentState = CurrentState.Lock; if (l.ShowDialog(this) == DialogResult.OK) { this.toolStripTop.Visible = true; this.StatusBarBottom.Visible = true; this.MainMenuStrip.Visible = true; CheckRight(l._SystemUser); if (this._SystemUser.UserNO == l._SystemUser.UserNO) { #region 一用户 if (m_frmPurchas != null && !m_frmPurchas.IsDisposed) { m_frmPurchas.Visible = !m_frmPurchas.Visible; } if (m_frmSell != null && !m_frmSell.IsDisposed) { m_frmSell.Visible = !m_frmSell.Visible; } if (m_frmStock != null && !m_frmStock.IsDisposed) { m_frmStock.Visible = !m_frmStock.Visible; } if (m_frmProviders != null && !m_frmProviders.IsDisposed) { m_frmProviders.Visible = !m_frmProviders.Visible; } if (m_frmUserManage != null && !m_frmUserManage.IsDisposed) { m_frmUserManage.Visible = !m_frmUserManage.Visible; } if (m_frmRecodrd != null && !m_frmRecodrd.IsDisposed) { m_frmRecodrd.Visible = !m_frmRecodrd.Visible; } #endregion } else { #region 其它用户 m_frmPurchas = null; m_frmSell = null; m_frmStock = null; m_frmProviders = null; m_frmUserManage = null; m_frmRecodrd = null; #endregion this._SystemUser = l._SystemUser; } } }
private void btnProfitloss_Click(object sender, EventArgs e) { frmStock frm = new frmStock(); frm.ShowDialog(); }
public void isDelete(String id, frmStock load) { this.Delete(id, load); }