private void setMatetielInfoToDataGridView(double pkey) { MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey); if (pkey != record.pkey || record.pkey == 0) { MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() + "]不存在,请重新输入或选择"); m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex); } else { dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = "0"; } }
private void setMatetielInfoToDataGridView(string id) { /* 如果是物料编码列,需要判断该物料编码是否存在 * 如果存在读取相应的值填充DataGridView中对应的其他列,如果不存在该物料编码,则清空该行 * */ double pkey = Convert.ToDouble(id.ToString()); //使用这个输入的值,匹配物料编号 MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id)); if (id != record.num || record.pkey == 0) { //使用这个输入的值,匹配物料key record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey); if (pkey != record.pkey || record.pkey == 0) { MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[m_rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() + "]不存在,请重新输入或选择"); m_dateGridVeiwListDataList.clearDataGridViewRow(m_rowIndex); return; } } InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID((int)pkey); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.pkey; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Unit].Value = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitSale); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Price].Value = Convert.ToString(MaterielCountdata.price); dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0"; dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0"; }
private void updateDataGridView(SortedDictionary <int, MaterielTable> materielList) { m_materielRecordCount = materielList.Count; SortedDictionary <int, ArrayList> materiels = new SortedDictionary <int, ArrayList>(); for (int i = 0; i < materielList.Count; i++) { MaterielTable materiel = new MaterielTable(); materiel = (MaterielTable)materielList[i]; ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.name); temp.Add(materiel.nameShort); temp.Add(materiel.model); temp.Add(materiel.brand); InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID(materiel.pkey); temp.Add(MaterielCountdata.value); temp.Add(MaterielCountdata.price); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitStorage)); temp.Add(materiel.max); temp.Add(materiel.min); temp.Add(materiel.warramty); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", materiel.storage)); materiels.Add(i, temp); } m_dataGridViewExtend.initDataGridViewData(materiels, 5); //this.dataGridViewMaterielList.Columns[1].DefaultCellStyle.BackColor = System.Drawing.Color.LightGray; //this.dataGridViewMaterielList.Columns[4].DefaultCellStyle.BackColor = System.Drawing.Color.LightGray; //this.dataGridViewMaterielList.Columns[5].DefaultCellStyle.BackColor = System.Drawing.Color.LightGray; }
private void updateDataGridView(SortedDictionary <int, MaterielTable> materielList) { double sum = 0; m_materielRecordCount = materielList.Count; SortedDictionary <int, ArrayList> materiels = new SortedDictionary <int, ArrayList>(); for (int i = 0; i < materielList.Count; i++) { MaterielTable materiel = new MaterielTable(); materiel = (MaterielTable)materielList[i]; ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.name); temp.Add(materiel.model); InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID(materiel.pkey); temp.Add(MaterielCountdata.value); if (m_isDisplayJG) { temp.Add(MaterielCountdata.price); temp.Add((double)(Math.Round(MaterielCountdata.value * MaterielCountdata.price * 100)) / 100); } if (m_materielProlist.ContainsKey(materiel.pkey)) { MaterielProOccupiedInfo proOccupiedRecord = new MaterielProOccupiedInfo(); proOccupiedRecord = (MaterielProOccupiedInfo)m_materielProlist[materiel.pkey]; temp.Add(proOccupiedRecord.sum); temp.Add(proOccupiedRecord.applyStaffName); temp.Add(MaterielCountdata.value - proOccupiedRecord.sum); } else { temp.Add(0); temp.Add("-"); temp.Add(MaterielCountdata.value); } temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitStorage)); temp.Add(materiel.max); temp.Add(materiel.min); temp.Add(materiel.warramty); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", materiel.storage)); if (m_displayDataType == (int)DisplayDataType.Materiel) { string materielAttributeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_MATERIEL_ATTRIBUTE", materiel.materielAttribute); if (materielAttributeName.IndexOf("外购") != -1) { materiels.Add(materiels.Count, temp); sum += MaterielCountdata.value * MaterielCountdata.price; } } else if (m_displayDataType == (int)DisplayDataType.Product) { string materielAttributeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_MATERIEL_ATTRIBUTE", materiel.materielAttribute); if (materielAttributeName.IndexOf("外购") == -1) { materiels.Add(materiels.Count, temp); sum += MaterielCountdata.value * MaterielCountdata.price; } } else { materiels.Add(materiels.Count, temp); sum += MaterielCountdata.value * MaterielCountdata.price; } } // 金额信息保留2位小数儿 sum = (double)(Math.Round(sum * 100)) / 100; if (m_isDisplayJG) { m_dataGridViewExtend.initDataGridViewData(materiels, 8); } else { m_dataGridViewExtend.initDataGridViewData(materiels, 6); } this.dataGridViewMaterielList.Columns[1].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.dataGridViewMaterielList.Columns[3].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; if (m_isDisplayJG) { this.dataGridViewMaterielList.Columns[4].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.dataGridViewMaterielList.Columns[5].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.dataGridViewMaterielList.Columns[8].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.labelCountInfo.Text += " 累计金额[" + Convert.ToString(sum) + "]"; } else { this.dataGridViewMaterielList.Columns[6].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; } this.labelCountInfo.Text = "[" + m_materielGroupName + "]类材料总计[" + Convert.ToString(materiels.Count) + "]条"; }
private void updateDataGridView(SortedDictionary <int, MaterielTable> materielList) { m_materielRecordCount = materielList.Count; this.labelMaterielGroupName.Text = "[" + m_materielGroupName + "]物料共计[" + Convert.ToString(m_materielRecordCount) + "]条记录"; SortedDictionary <int, ArrayList> materiels = new SortedDictionary <int, ArrayList>(); SortedDictionary <int, AuxiliaryMaterialDataTable> AuxiliaryMaterialList = AuxiliaryMaterial.getInctance().getAuxiliaryListFromTableName("BASE_UNIT_LIST"); SortedDictionary <int, AuxiliaryMaterialDataTable> AuxiliaryStorelList = AuxiliaryMaterial.getInctance().getAuxiliaryListFromTableName("BASE_STORAGE_LIST"); for (int i = 0; i < materielList.Count; i++) { MaterielTable materiel = new MaterielTable(); materiel = (MaterielTable)materielList[i]; ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.materielType); temp.Add(materiel.name); temp.Add(materiel.num); temp.Add(MaterielType.getInctance().getMaterielTypeNameFromPkey(materiel.materielType)); temp.Add(materiel.nameShort); temp.Add(materiel.mnemonicCode); temp.Add(materiel.model); temp.Add(materiel.brand); temp.Add(materiel.materielParameter); if (AuxiliaryStorelList.ContainsKey(materiel.storage)) { temp.Add(AuxiliaryStorelList[materiel.storage].name); } else { temp.Add(""); } temp.Add("移动加权平均"); if (AuxiliaryMaterialList.ContainsKey(materiel.unit)) { temp.Add(AuxiliaryMaterialList[materiel.unit].name); } else { temp.Add(""); } temp.Add(materiel.CZ); temp.Add(materiel.max); temp.Add(materiel.min); temp.Add(materiel.warramty); temp.Add(materiel.note); materiels.Add(materiels.Count, temp); } m_dataGridViewExtend.initDataGridViewData(materiels, 4); }
private void initUserInterfaceValue() { if (m_isBankBill) { m_bankRecord = BankCashsubLedger.getInctance().getBankCashsubLedgerInfoFromOrderNumber(m_billNumber); // 如果单据已审核,则允许用户修改此单据 if (m_bankRecord.isReview == "1") { setAllActiveEnableAttribute(false); } this.textBoxPaymentOrderNumber.Text = m_bankRecord.billNumber; this.textBoxVouchersNumber.Text = m_bankRecord.vouchersNumber; this.dateTime.Text = m_bankRecord.tradingDate; this.comboBoxPaymentType.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", m_bankRecord.billTypeID); comboBoxPaymentType_SelectedIndexChanged(this.comboBoxPaymentType, null); if (this.comboBoxPaymentType.Text.IndexOf("采购入库") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.sourceBillNumber; } else if (this.comboBoxPaymentType.Text.IndexOf("应付") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.exchangesUnitName; } else if (this.comboBoxPaymentType.Text.IndexOf("其他") != -1 || this.comboBoxPaymentType.Text.IndexOf("其它") != -1) { this.textBoxSourceOrderNumber.Text = m_bankRecord.note; } this.comboBoxPaymentObject.Text = "银行存款"; this.comboBoxBank.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_BANK_LIST", m_bankRecord.bankID); comboBoxPaymentObject_SelectedIndexChanged(this.comboBoxPaymentObject, null); this.textBoxTransactionAmount.Text = Convert.ToString(m_bankRecord.turnover); this.textBoxMakeOrderStaff.Text = m_bankRecord.makeOrderStaffName; this.textBoxOrderReview.Text = m_bankRecord.orderReviewName; } else { m_cashRecord = CashCashsubLedger.getInctance().getCashCashsubLedgerInfoFromOrderNumber(m_billNumber); // 如果单据已审核,则允许用户修改此单据 if (m_cashRecord.isReview == "1") { setAllActiveEnableAttribute(false); } this.textBoxPaymentOrderNumber.Text = m_cashRecord.billNumber; this.textBoxVouchersNumber.Text = m_cashRecord.vouchersNumber; this.dateTime.Text = m_cashRecord.tradingDate; this.comboBoxPaymentType.Text = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", m_cashRecord.billTypeID); comboBoxPaymentType_SelectedIndexChanged(this.comboBoxPaymentType, null); if (this.comboBoxPaymentType.Text.IndexOf("采购入库") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.sourceBillNumber; } else if (this.comboBoxPaymentType.Text.IndexOf("应付") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.exchangesUnitName; } else if (this.comboBoxPaymentType.Text.IndexOf("其他") != -1 || this.comboBoxPaymentType.Text.IndexOf("其它") != -1) { this.textBoxSourceOrderNumber.Text = m_cashRecord.note; } this.comboBoxPaymentObject.Text = "库存现金"; this.textBoxTransactionAmount.Text = Convert.ToString(m_cashRecord.turnover); this.textBoxMakeOrderStaff.Text = m_cashRecord.makeOrderStaffName; this.textBoxOrderReview.Text = m_cashRecord.orderReviewName; } }
private void updateDataGridView(SortedDictionary <int, MaterielTable> materielList) { m_materielRecordCount = materielList.Count; this.labelMaterielGroupName.Text = "[" + m_materielGroupName + "]物料共计[" + Convert.ToString(m_materielRecordCount) + "]条记录"; SortedDictionary <int, ArrayList> materiels = new SortedDictionary <int, ArrayList>(); for (int i = 0; i < materielList.Count; i++) { MaterielTable materiel = new MaterielTable(); materiel = (MaterielTable)materielList[i]; if (!m_isStorageAgeCount) { ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.name); temp.Add(materiel.model); temp.Add(materiel.brand); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unit)); temp.Add(materiel.max); temp.Add(materiel.min); double materielCurrentStorageValue = InitMateriel.getInctance().getMarerielCountInfoFromMaterielID(materiel.pkey); temp.Add(materielCurrentStorageValue); if (m_isNeedFilterData) { if (materiel.min - materielCurrentStorageValue > m_filterValue) { temp.Add("当前库存与预设的物料下限差值大于" + Convert.ToString(m_filterValue)); materiels.Add(materiels.Count, temp); } if (materielCurrentStorageValue - materiel.max > m_filterValue) { temp.Add("当前库存与预设的物料上限差值大于" + Convert.ToString(m_filterValue)); materiels.Add(materiels.Count, temp); } } else { materiels.Add(materiels.Count, temp); } m_dataGridViewExtend.initDataGridViewData(materiels, 3); } else { // 库存账龄分析 ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.name); temp.Add(materiel.model); temp.Add(materiel.brand); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unit)); // 计算当前物料的账龄 double materielCurrentStorageValue = InitMateriel.getInctance().getMarerielCountInfoFromMaterielID(materiel.pkey); ArrayList materielAgeValueList = StorageStockDetail.getInctance().getMaterielAgeValue(materiel.pkey, materielCurrentStorageValue); temp.Add(materielCurrentStorageValue); temp.Add(materielAgeValueList[0]); temp.Add(materielAgeValueList[1]); temp.Add(materielAgeValueList[2]); temp.Add(materielAgeValueList[3]); materiels.Add(materiels.Count, temp); m_dataGridViewExtend.initDataGridViewData(materiels, 4); } } }
private void updateDataGridView(SortedDictionary <int, MaterielTable> materielList) { double sum = 0; m_materielRecordCount = materielList.Count; SortedDictionary <int, ArrayList> materiels = new SortedDictionary <int, ArrayList>(); //分别代表数量和单价 double materielCountdataPrice = 0, materielCountdataValue = 0; for (int i = 0; i < materielList.Count; i++) { MaterielTable materiel = new MaterielTable(); materiel = (MaterielTable)materielList[i]; ArrayList temp = new ArrayList(); temp.Add(materiel.pkey); temp.Add(materiel.name); temp.Add(materiel.num); temp.Add(materiel.nameShort); temp.Add(materiel.model); temp.Add(materiel.brand); StorageStockDetailTable MaterielHistoryInfo = getMaterielHistoryInfoFromMaterielID(materiel.pkey); materielCountdataPrice = MaterielHistoryInfo.price; materielCountdataValue = MaterielHistoryInfo.value; temp.Add(materielCountdataValue); if (m_isDisplayJG) { temp.Add(materielCountdataPrice); temp.Add((double)(Math.Round(materielCountdataValue * materielCountdataPrice * 100)) / 100); } temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitStorage)); temp.Add(materiel.max); temp.Add(materiel.min); temp.Add(materiel.warramty); temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", materiel.storage)); if (m_displayDataType == (int)DisplayDataType.Materiel) { string materielAttributeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_MATERIEL_ATTRIBUTE", materiel.materielAttribute); if (materielAttributeName.IndexOf("外购") != -1) { materiels.Add(materiels.Count, temp); sum += materielCountdataValue * materielCountdataPrice; } } else if (m_displayDataType == (int)DisplayDataType.Product) { string materielAttributeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_MATERIEL_ATTRIBUTE", materiel.materielAttribute); if (materielAttributeName.IndexOf("外购") == -1) { materiels.Add(materiels.Count, temp); sum += materielCountdataValue * materielCountdataPrice; } } else { materiels.Add(materiels.Count, temp); sum += materielCountdataValue * materielCountdataPrice; } } // 金额信息保留2位小数儿 sum = (double)(Math.Round(sum * 100)) / 100; m_dataGridViewExtend.initDataGridViewData(materiels, 7); this.dataGridViewMaterielList.Columns[1].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.dataGridViewMaterielList.Columns[6].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; if (m_isDisplayJG) { this.dataGridViewMaterielList.Columns[7].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; this.dataGridViewMaterielList.Columns[8].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; } this.labelCountInfo.Text = "[" + m_materielGroupName + "]类材料总计[" + Convert.ToString(materiels.Count) + "]条"; if (m_isDisplayJG) { this.labelCountInfo.Text += " 累计金额[" + Convert.ToString(sum) + "]"; } }
private MaterielTable getPageMaterielActiveData() { MaterielTable materiel = new MaterielTable(); materiel.materielType = m_materielGroupPkey; materiel.name = this.textBoxName.Text.ToString(); materiel.num = this.textBoxNum.Text.ToString(); materiel.nameShort = this.textBoxShortName.Text.ToString(); materiel.model = this.textBoxModel.Text.ToString(); materiel.mnemonicCode = this.textBoxMnemonicCode.Text.ToString(); materiel.brand = this.textBoxBrand.Text.ToString(); if (this.textBoxMIN.Text.Length > 0) { materiel.min = Convert.ToInt32(this.textBoxMIN.Text.ToString()); } else { materiel.min = 0; } if (this.textBoxMAX.Text.Length > 0) { materiel.max = Convert.ToInt32(this.textBoxMAX.Text.ToString()); } else { materiel.max = 0; } if (this.textBoxWarranty.Text.Length > 0) { materiel.warramty = Convert.ToInt32(this.textBoxWarranty.Text.ToString()); } else { materiel.warramty = 0; } if (this.comboBoxMaterielAttribut.Text.Length > 0) { materiel.materielAttribute = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(MATERIEL_ATTRIBUTE_TABLE_NAME, this.comboBoxMaterielAttribut.Text); } if (this.comboBoxValuationType.Text.Length > 0) { materiel.valuation = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(VALUATION_TYPE_LIST_TABLE_NAME, this.comboBoxValuationType.Text); } if (this.comboBoxStorage.Text.Length > 0) { materiel.storage = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(STORAGE_LIST_TABLE_NAME, this.comboBoxStorage.Text); } if (this.comboBoxUnit.Text.Length > 0) { materiel.unit = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnit.Text); } if (this.comboBoxUnitPurchase.Text.Length > 0) { materiel.unitPurchase = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitPurchase.Text); } if (this.comboBoxUnitSale.Text.Length > 0) { materiel.unitSale = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitSale.Text); } if (this.comboBoxUnit.Text.Length > 0) { materiel.unitStorage = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnit.Text); } materiel.note = this.textBoxNote.Text.ToString(); return(materiel); }
private void exportMaterielOutData() { // 生产领料单数据导出 MaterielOutOrderTable table = new MaterielOutOrderTable(); table = MaterielOutOrder.getInctance().getMaterielOutOrderInfoFromBillNumber(m_billNubmber); FormProjectMaterielTable projectInfo = FormProject.getInctance().getProjectInfoFromBillNumber(table.srcOrderNum); stringReplace(projectInfo.projectName, "[1]"); stringReplace(table.billNumber, "[2]"); stringReplace(table.srcOrderNum, "[3]"); stringReplace(table.makeNo, "[4]"); stringReplace(table.exchangesUnit, "[5]"); stringReplace(projectInfo.projectNum, "[6]"); stringReplace(table.makeOrderStaffName, "[7]"); stringReplace(projectInfo.deviceMode, "[9]"); stringReplace(projectInfo.subName, "[10]"); double sum = 0.0; for (int row = 0; row < m_dataGridView.RowCount; row++) { if (m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0) { break; } int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.MatetielNumber].Value.ToString()); MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(materielID); ProjectManagerDetailsTable tmp = new ProjectManagerDetailsTable(); string xxMatetielTableRowNum = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.xxMatetielTableRowNum].Value.ToString(); if (xxMatetielTableRowNum.Length > 0) { tmp = ProjectManagerDetails.getInctance().getMaterielInfoFromRowNum(table.srcOrderNum, Convert.ToInt32(xxMatetielTableRowNum)); } else { tmp = ProjectManagerDetails.getInctance().getMaterielInfoFromBillNumber(table.srcOrderNum, materielID); } m_excelApp.Cells[row + 6, 1] = tmp.no; m_excelApp.Cells[row + 6, 2] = tmp.sequence; m_excelApp.Cells[row + 6, 3] = record.brand; m_excelApp.Cells[row + 6, 4] = record.name; m_excelApp.Cells[row + 6, 5] = record.model; m_excelApp.Cells[row + 6, 6] = tmp.cl; m_excelApp.Cells[row + 6, 7] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.Unit].Value.ToString().Trim(); m_excelApp.Cells[row + 6, 8] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.Value].Value.ToString().Trim(); m_excelApp.Cells[row + 6, 9] = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", record.storage); m_excelApp.Cells[row + 6, 10] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.Note].Value.ToString().Trim(); sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOrder.DataGridColumnName.Value].Value.ToString()); } stringReplace(Convert.ToString(sum), "[8]"); }