private void save_Click(object sender, EventArgs e) { // 得到详细的销售信息 ArrayList dataList = getMaterielInEarningsOrderDetailsValue(); if (dataList.Count > 0) { // 销售订单表头和表尾信息 MaterielInEarningsOrderTable record = getMaterielInEarningsOrderValue(); if (orderInfoIsFull(record) && orderDetailsIsFull(dataList)) { MaterielInEarningsOrder.getInctance().insert(record, false); MaterielInEarningsOrderDetails.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 void registerInLedger_Click(object sender, EventArgs e) { try { save_Click(sender, e); MaterielInEarningsOrder.getInctance().registerInLedger(m_billNumber, m_isRedBill); } catch (Exception exp) { MessageBoxExtend.messageError(exp.ToString()); } }
private void toolStripButtonReview_Click(object sender, EventArgs e) { try { save_Click(sender, e); MaterielInEarningsOrder.getInctance().billReview(m_billNumber); } catch (Exception exp) { MessageBoxExtend.messageError(exp.ToString()); } }
private void exportEarningsOrderData() { int startRowIndex = 6; // 采购入库单数据导出 MaterielInEarningsOrderTable table = new MaterielInEarningsOrderTable(); table = MaterielInEarningsOrder.getInctance().getMaterielInEarningsOrderInfoFromBillNumber(m_billNubmber); stringReplace(table.billNumber, "[1]"); if (table.isRedBill == 1) { stringReplace("(红字单据)", "[2]"); } else { stringReplace("", "[2]"); } stringReplace(table.makeOrderStaffName, "[3]"); double sum = 0.0; for (int row = 0; row < m_dataGridView.RowCount; row++) { if (m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0) { break; } int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielNumber].Value.ToString().Trim()); MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(materielID); m_excelApp.Cells[row + startRowIndex, 2] = materielID; m_excelApp.Cells[row + startRowIndex, 3] = record.brand; m_excelApp.Cells[row + startRowIndex, 4] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.MatetielName].Value.ToString().Trim(); m_excelApp.Cells[row + startRowIndex, 5] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Model].Value.ToString().Trim(); m_excelApp.Cells[row + startRowIndex, 6] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Unit].Value.ToString().Trim(); m_excelApp.Cells[row + startRowIndex, 7] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Value].Value.ToString().Trim(); m_excelApp.Cells[row + startRowIndex, 8] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Note].Value.ToString().Trim(); sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormMaterielInEarningsOrder.DataGridColumnName.Value].Value.ToString().Trim()); } stringReplace(Convert.ToString(sum), "[4]"); }
private void save_Click(object sender, EventArgs e) { m_isSaveSuccess = false; if ((sender.ToString() == "保存" || sender.ToString() == "审核") && MaterielInEarningsOrder.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString())) { MessageBoxExtend.messageWarning("单据已被审核,所有数据无法进行更改,无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情"); return; } this.ActiveControl = this.toolStrip1; // 得到详细的销售信息 ArrayList dataList = getMaterielInEarningsOrderDetailsValue(); if (dataList.Count > 0) { // 销售订单表头和表尾信息 MaterielInEarningsOrderTable record = getMaterielInEarningsOrderValue(); if (orderInfoIsFull(record) && orderDetailsIsFull(dataList)) { MaterielInEarningsOrder.getInctance().insert(record, false); MaterielInEarningsOrderDetails.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 toolStripButtonRefresh_Click(object sender, EventArgs e) { // 刷新按钮逻辑 if (m_orderType == OrderType.PurchaseOrder) { PurchaseOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.PurchaseIn) { PurchaseInOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.PurchaseInvoice) { } else if (m_orderType == OrderType.PurchaseOrderExcute) { PurchaseOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.PurchaseInOrderExcute) { PurchaseInOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageProductIn) { // 仓存管理-产品入库 MaterielInOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageInCheck) { // 仓存管理-盘盈入库 MaterielInEarningsOrder.getInctance().refreshRecord(); } else if (m_orderType == OrderType.StorageInOther) { // 仓存管理-其他入库 MaterielInOtherOrder.getInctance().refreshRecord(); } updateDataGridView(); }
private void readBillInfoToUI() { // 单据表头表尾信息 m_materieInOrder = MaterielInEarningsOrder.getInctance().getMaterielInEarningsOrderInfoFromBillNumber(m_billNumber); m_staffSavePkey = m_materieInOrder.staffSaveId; m_materielOutStaffPkey = m_materieInOrder.orderReviewStaffId; this.labelTradingDate.Visible = true; this.labelBillNumber.Visible = true; this.labelMakeBillStaff.Visible = true; this.labelReviewBillStaff.Visible = true; this.labelReviewDate.Visible = true; this.labelSave.Visible = true; this.labelVerify.Visible = true; this.labelTradingDate.Text = m_materieInOrder.tradingDate; this.labelBillNumber.Text = m_materieInOrder.billNumber; this.labelMakeBillStaff.Text = m_materieInOrder.makeOrderStaffName; this.labelSave.Text = m_materieInOrder.staffSaveName; this.labelVerify.Text = m_materieInOrder.orderReviewStaffName; // DataGridView 赋值 writeBillDetailsInfoFromBillNumber(m_billNumber); // 如果单据已审核,则禁用页面所有控件 if (m_materieInOrder.isReview == "1") { this.labelReviewBillStaff.Text = m_materieInOrder.orderrReviewName; this.labelReviewDate.Text = m_materieInOrder.reviewDate; this.panelIsReview.Visible = true; this.save.Enabled = false; this.toolStripButtonReview.Enabled = false; this.panelTradingDate.Visible = false; this.dateTimePickerTradingDate.Visible = false; this.dataGridViewDataList.Enabled = false; this.dataGridViewDataCount.Enabled = false; this.redBill.Enabled = false; this.blueBill.Enabled = false; this.registerInLedger.Enabled = true; } else { this.labelReviewBillStaff.Visible = false; this.labelReviewDate.Visible = false; } // 如果单据已经记账,则出来红字已记账提示 if (m_materieInOrder.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_materieInOrder.isRedBill == 1) { m_isRedBill = true; this.panelRed.Visible = true; } }
private void updateDataGridView() { SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>(); if (m_orderType == OrderType.PurchaseOrder) { SortedDictionary <int, PurchaseOrderTable> list = new SortedDictionary <int, PurchaseOrderTable>(); list = PurchaseOrder.getInctance().getAllPurchaseOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { PurchaseOrderTable record = new PurchaseOrderTable(); record = (PurchaseOrderTable)list[index]; if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0)) { ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.supplierName); temp.Add(record.tradingDate); temp.Add(record.billNumber); temp.Add(record.purchaseType); temp.Add(record.deliveryDate); temp.Add(record.paymentDate); temp.Add(record.sumMoney); temp.Add(record.sumTransportationCost); temp.Add(record.sumOtherCost); temp.Add(record.totalMoney); temp.Add(record.businessPeopleName); temp.Add(record.makeOrderStaffName); if (record.isReview == "0") { temp.Add("否"); } else { temp.Add("是"); } temp.Add(record.orderrReviewName); temp.Add(record.reviewDate); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.PurchaseIn) { SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>(); list = PurchaseInOrder.getInctance().getAllPurchaseInOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { PurchaseInOrderTable record = new PurchaseInOrderTable(); record = (PurchaseInOrderTable)list[index]; if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0)) { ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.supplierName); temp.Add(record.tradingDate); temp.Add(record.billNumber); temp.Add(record.purchaseType); temp.Add(record.contractNum); temp.Add(record.paymentDate); temp.Add(record.sourceBillNumber); temp.Add(record.sumMoney); temp.Add(record.sumTransportationCost); temp.Add(record.sumOtherCost); temp.Add(record.totalMoney); temp.Add(record.staffSaveName); temp.Add(record.staffCheckName); temp.Add(record.businessPeopleName); temp.Add(record.makeOrderStaffName); temp.Add(record.orderrReviewName); temp.Add(record.reviewDate); temp.Add(record.orderInLedgerName); temp.Add(record.inLedgerDate); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.PurchaseInvoice) { } else if (m_orderType == OrderType.PurchaseOrderExcute) { SortedDictionary <int, PurchaseOrderTable> list = new SortedDictionary <int, PurchaseOrderTable>(); list = PurchaseOrder.getInctance().getAllPurchaseOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { PurchaseOrderTable record = new PurchaseOrderTable(); record = (PurchaseOrderTable)list[index]; ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.supplierName); temp.Add(record.tradingDate); temp.Add(record.billNumber); temp.Add(record.deliveryDate); temp.Add(record.sumValue); if (record.isInStorage == "0") { temp.Add("否"); } else { temp.Add("是"); } temp.Add(record.actualValue); temp.Add(record.businessPeopleName); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.PurchaseInOrderExcute) { SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>(); list = PurchaseInOrder.getInctance().getAllPurchaseInOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { PurchaseInOrderTable record = new PurchaseInOrderTable(); record = (PurchaseInOrderTable)list[index]; ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.supplierName); temp.Add(record.tradingDate); temp.Add(record.billNumber); temp.Add(record.purchaseType); temp.Add(record.paymentDate); temp.Add(record.totalMoney); temp.Add(record.paymentOk); temp.Add(record.paymentNoOk); temp.Add(record.businessPeopleName); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.StorageProductIn) { // 仓存管理-产品入库 SortedDictionary <int, MaterielInOrderTable> list = new SortedDictionary <int, MaterielInOrderTable>(); list = MaterielInOrder.getInctance().getAllMaterielInOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { bool isDisplayRecord = false; MaterielInOrderTable record = new MaterielInOrderTable(); record = (MaterielInOrderTable)list[index]; if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0)) { // 等于0代表只显示已审核单据 if (m_filter.allReview == "0") { if (record.isReview == "1") { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } else { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } if (isDisplayRecord) { ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.departmentName); temp.Add(record.tradingDate); temp.Add(record.billNumber); temp.Add(record.sumValue); temp.Add(record.sumMoney); temp.Add(record.orderReviewStaffName); temp.Add(record.makeOrderStaffName); temp.Add(record.orderrReviewName); temp.Add(record.reviewDate); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.StorageInCheck) { // 仓存管理-盘盈入库 SortedDictionary <int, MaterielInEarningsOrderTable> list = new SortedDictionary <int, MaterielInEarningsOrderTable>(); list = MaterielInEarningsOrder.getInctance().getAllMaterielInEarningsOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { bool isDisplayRecord = false; MaterielInEarningsOrderTable record = new MaterielInEarningsOrderTable(); record = (MaterielInEarningsOrderTable)list[index]; if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0)) { // 等于0代表只显示已审核单据 if (m_filter.allReview == "0") { if (record.isReview == "1") { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } else { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } if (isDisplayRecord) { ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.tradingDate); temp.Add(""); temp.Add(record.billNumber); temp.Add(record.sumValue); temp.Add(record.sumMoney); temp.Add(record.orderReviewStaffName); temp.Add(record.makeOrderStaffName); temp.Add(record.orderrReviewName); temp.Add(record.reviewDate); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } else if (m_orderType == OrderType.StorageInOther) { // 仓存管理-其他入库 SortedDictionary <int, MaterielInOtherOrderTable> list = new SortedDictionary <int, MaterielInOtherOrderTable>(); list = MaterielInOtherOrder.getInctance().getAllMaterielInOtherOrderInfo(); m_dataGridRecordCount = list.Count; for (int index = 0; index < list.Count; index++) { bool isDisplayRecord = false; MaterielInOtherOrderTable record = new MaterielInOtherOrderTable(); record = (MaterielInOtherOrderTable)list[index]; if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0)) { // 等于0代表只显示已审核单据 if (m_filter.allReview == "0") { if (record.isReview == "1") { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } else { if (m_filter.billColor == "0") // 需要显示蓝字单据 { if (record.isRedBill == 0) { isDisplayRecord = true; } } else if (m_filter.billColor == "1") // 需要显示红字单据 { if (record.isRedBill == 1) { isDisplayRecord = true; } } else // 需要显示全部颜色单据 { isDisplayRecord = true; } } } if (isDisplayRecord) { ArrayList temp = new ArrayList(); temp.Add(record.pkey); temp.Add(record.tradingDate); temp.Add(""); temp.Add(record.billNumber); temp.Add(record.sumValue); temp.Add(record.sumMoney); temp.Add(record.orderReviewStaffName); temp.Add(record.makeOrderStaffName); temp.Add(record.orderrReviewName); temp.Add(record.reviewDate); sortedDictionaryList.Add(sortedDictionaryList.Count, temp); } } m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3); } }