private SortedDictionary <int, ArrayList> getSaleCostDetailsData(out double sumTotleValue, out double sumTotleMoney) { SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>(); SortedDictionary <int, SaleProfitCounInfoStruct> list = new SortedDictionary <int, SaleProfitCounInfoStruct>(); list = SaleOutOrderDetails.getInctance().getSaleOutOrderDetailsInfo(m_countStartDate, m_countEndDate, m_isCountAllBill); m_dataGridRecordCount = list.Count; sumTotleValue = 0; sumTotleMoney = 0; for (int index = 0; index < list.Count; index++) { SaleProfitCounInfoStruct record = new SaleProfitCounInfoStruct(); record = (SaleProfitCounInfoStruct)list[index]; ArrayList temp = new ArrayList(); temp.Add(index + 1); temp.Add(record.materielID); temp.Add(record.materielName); temp.Add(record.materielUnitSale); temp.Add(record.priceCost); temp.Add(record.value); temp.Add(record.costSum); sumTotleValue += record.valueSum; sumTotleMoney += record.costSum; sortedDictionaryList.Add(index, temp); } return(sortedDictionaryList); }
private void save_Click(object sender, EventArgs e) { // 得到详细的销售信息 ArrayList dataList = getSaleOutOrderDetailsValue(); if (dataList.Count > 0) { // 销售订单表头和表尾信息 SaleOutOrderTable record = getSaleOutOrderValue(); if (saleOrderIsFull(record) && saleOrderDetailsIsFull(dataList)) { SaleOutOrder.getInctance().insert(record, false); SaleOutOrderDetails.getInctance().insert(dataList); BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelTradingDate.Text, this.labelBillNumber.Text.ToString()); if (m_billNumber.Length == 0) { MessageBoxExtend.messageOK("数据保存成功"); } this.Close(); } } else { MessageBoxExtend.messageWarning("此单据不包含任何交易信息,单据保存失败."); } }
private SortedDictionary <int, ArrayList> getSaleHistoryPriceData() { SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>(); SortedDictionary <int, SaleOutOrderTable> list = new SortedDictionary <int, SaleOutOrderTable>(); list = SaleOutOrderDetails.getInctance().getSalePriceCountInfo(m_materielID, m_countStartDate, m_countEndDate); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { SaleOutOrderTable record = new SaleOutOrderTable(); record = (SaleOutOrderTable)list[index]; ArrayList temp = new ArrayList(); temp.Add(index + 1); temp.Add(record.billNumber); temp.Add(record.customerId); temp.Add(record.customerName); temp.Add(record.tradingDate); temp.Add(record.totalMoney); temp.Add(record.sumValue); sortedDictionaryList.Add(index, temp); } return(sortedDictionaryList); }
private SortedDictionary <int, ArrayList> getSaleMaterielData(out double sumTotleMoney) { SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>(); SortedDictionary <int, SaleOutOrderDetailsTable> list = new SortedDictionary <int, SaleOutOrderDetailsTable>(); list = SaleOutOrderDetails.getInctance().getSaleOutOrderCountInfo(m_countStartDate, m_countEndDate, m_isCountAllBill); m_dataGridRecordCount = list.Count; sumTotleMoney = getSumTotleMoney(list); for (int index = 0; index < list.Count; index++) { SaleOutOrderDetailsTable record = new SaleOutOrderDetailsTable(); record = (SaleOutOrderDetailsTable)list[index]; ArrayList temp = new ArrayList(); temp.Add(index + 1); temp.Add(record.materielID); temp.Add(record.materielName); temp.Add(record.materielModel); temp.Add(record.totalMoney); temp.Add(getPercentValue(record.totalMoney, sumTotleMoney)); sortedDictionaryList.Add(index, temp); } return(sortedDictionaryList); }
private void toolStripButtonRefresh_Click(object sender, EventArgs e) { // 刷新按钮逻辑 if (m_orderType == OrderType.SaleQuotation) { // 销售管理-销售报价单序时簿 SaleQuotationOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.SaleOrder) { // 销售管理-销售订单序时簿 SaleOrder.getInctance().refreshRecord(); SaleOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.SaleOut) { // 销售管理-销售出库单序时簿 SaleOutOrder.getInctance().refreshRecord(); SaleOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.SaleInvoice) { // 销售管理-销售发票序时簿(暂时为空就可以) } else if (m_orderType == OrderType.SaleOrderExcute) { // 销售管理-销售订单执行情况 SaleOrder.getInctance().refreshRecord(); SaleOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.SaleOutOrderExcute) { // 销售管理-销售出库单收款情况 SaleOutOrder.getInctance().refreshRecord(); SaleOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageMaterielOut) { // 仓存管理-生产领料 MaterielOutOrder.getInctance().refreshRecord(); MaterielOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageOutCheck) { // 仓存管理-盘亏亏损 MaterielOutEarningsOrder.getInctance().refreshRecord(); MaterielOutEarningsOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageOutOther) { // 仓存管理-其他出库 MaterielOutOtherOrder.getInctance().refreshRecord(); MaterielOutOtherOrderDetails.getInctance().refreshRecord(); } updateDataGridView(); }
private void toolStripButtonRefreshHS_Click(object sender, EventArgs e) { if (m_orderType == CountType.PurchaseMateriel) { PurchaseInOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == CountType.PurchasePeople) { PurchaseInOrder.getInctance().refreshRecord(); } else if (m_orderType == CountType.PurchaseSupplier) { PurchaseInOrder.getInctance().refreshRecord(); } else if (m_orderType == CountType.PurchaseHistoryPrice) { PurchaseInOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == CountType.SaleMateriel) { SaleOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == CountType.SalePeople) { SaleOutOrder.getInctance().refreshRecord(); } else if (m_orderType == CountType.SaleCustomer) { SaleOutOrder.getInctance().refreshRecord(); } else if (m_orderType == CountType.SaleHistoryPrice) { SaleOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == CountType.StorageMaterielOut) { MaterielOutOrderDetails.getInctance().refreshRecord(); } else if (m_orderType == CountType.StorageManagerMaterielCount) { StorageStockDetail.getInctance().refreshRecord(); } else if (m_orderType == CountType.MaterielInOutCount) { StorageStockDetail.getInctance().refreshRecord(); } else if (m_orderType == CountType.StorageManagerProduceIn) { MaterielInOrderDetails.getInctance().refreshRecord(); } updateDataGridView(); }
private void save_Click(object sender, EventArgs e) { m_isSaveSuccess = false; if ((sender.ToString() == "保存" || sender.ToString() == "审核") && SaleOutOrder.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString())) { MessageBoxExtend.messageWarning("单据已被审核,所有数据无法进行更改,无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情"); return; } this.ActiveControl = this.toolStrip1; // 得到详细的销售信息 ArrayList dataList = getSaleOutOrderDetailsValue(); if (dataList.Count > 0) { // 销售订单表头和表尾信息 SaleOutOrderTable record = getSaleOutOrderValue(); if (saleOrderIsFull(record) && saleOrderDetailsIsFull(dataList)) { SaleOutOrder.getInctance().insert(record, false); SaleOutOrderDetails.getInctance().insert(dataList); BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelTradingDate.Text, this.labelBillNumber.Text.ToString()); m_isSaveSuccess = true; if (m_billNumber.Length == 0) { MessageBoxExtend.messageOK("数据保存成功"); } this.Close(); } } else { MessageBoxExtend.messageWarning("此单据不包含任何交易信息,单据保存失败."); } }
private void readBillInfoToUI() { // 单据表头表尾信息 m_saleOutOrder = SaleOutOrder.getInctance().getSaleInfoFromBillNumber(m_billNumber); m_customerPkey = m_saleOutOrder.customerId; m_staffSavePkey = m_saleOutOrder.staffSaveId; m_staffCheckPkey = m_saleOutOrder.staffCheckId; this.labelSaleName.Visible = true; this.labelTradingDate.Visible = true; this.labelBillNumber.Visible = true; this.labelSaleType.Visible = true; this.labelPaymentDate.Visible = true; this.labelSummary.Visible = true; this.labelBusinessPeople.Visible = true; this.labelMakeBillStaff.Visible = true; this.labelReviewBillStaff.Visible = true; this.labelReviewDate.Visible = true; this.labelSourceOrderType.Visible = true; this.labelSourceOrderNumber.Visible = true; this.labelSave.Visible = true; this.labelVerify.Visible = true; this.labelSaleName.Text = m_saleOutOrder.customerName; this.labelTradingDate.Text = m_saleOutOrder.tradingDate; this.labelBillNumber.Text = m_saleOutOrder.billNumber; this.labelSaleType.Text = m_saleOutOrder.saleType; this.labelPaymentDate.Text = m_saleOutOrder.paymentDate; this.labelSummary.Text = m_saleOutOrder.exchangesUnit; m_staffPkey = m_saleOutOrder.businessPeopleId; this.labelBusinessPeople.Text = m_saleOutOrder.businessPeopleName; this.labelMakeBillStaff.Text = m_saleOutOrder.makeOrderStaffName; this.labelSourceOrderType.Text = m_saleOutOrder.sourceBillType; this.labelSourceOrderNumber.Text = m_saleOutOrder.sourceBillNumber; this.labelSave.Text = m_saleOutOrder.staffSaveName; this.labelVerify.Text = m_saleOutOrder.staffCheckName; // DataGridView 赋值 SortedDictionary <int, SaleOutOrderDetailsTable> saleOrderDetails = SaleOutOrderDetails.getInctance().getSaleOutInfoFromBillNumber(m_billNumber); foreach (KeyValuePair <int, SaleOutOrderDetailsTable> index in saleOrderDetails) { SaleOutOrderDetailsTable record = new SaleOutOrderDetailsTable(); record = index.Value; int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitSale; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.costApportionments; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.noCostApportionments; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney; } // 如果单据已审核,则禁用页面所有控件 if (m_saleOutOrder.isReview == "1") { this.labelReviewBillStaff.Text = m_saleOutOrder.orderrReviewName; this.labelReviewDate.Text = m_saleOutOrder.reviewDate; this.panelIsReview.Visible = true; this.save.Enabled = false; this.toolStripButtonReview.Enabled = false; this.panelSaleName.Visible = false; this.panelTradingDate.Visible = false; this.panelSaleType.Visible = false; this.panelPaymentDate.Visible = false; this.panelSummary.Visible = false; this.textBoxSaleName.Visible = false; this.dateTimePickerTradingDate.Visible = false; this.comboBoxSaleType.Visible = false; this.dateTimePickerPaymentDate.Visible = false; this.textBoxSummary.Visible = false; this.panelBusinessPeople.Visible = false; // 如果单据已经审核则入账按钮是好用的 this.registerInLedger.Enabled = true; } else { this.labelReviewBillStaff.Visible = false; this.labelReviewDate.Visible = false; this.registerInLedger.Enabled = false; } // 如果单据已经记账,则出来红字已记账提示 if (m_saleOutOrder.isInLedger == 1) { this.panelInLedger.Visible = true; this.registerInLedger.Enabled = false; this.dataGridViewDataList.Enabled = false; this.dataGridViewDataCount.Enabled = false; } else { this.dataGridViewDataList.Enabled = true; this.dataGridViewDataCount.Enabled = true; } if (m_saleOutOrder.isRedBill == 1) { m_isRedBill = true; this.panelRed.Visible = true; } }