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 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 updateDataGridView(SortedDictionary <int, StaffTable> staffList)
{
m_staffRecordCount = staffList.Count;
this.labelStaffGroupName.Text = "[" + m_staffGroupName + "]员工共计[" + Convert.ToString(m_staffRecordCount) + "]条记录";
SortedDictionary <int, ArrayList> staffs = new SortedDictionary <int, ArrayList>();
for (int i = 0; i < staffList.Count; i++)
{
StaffTable staff = new StaffTable();
staff = (StaffTable)staffList[i];
ArrayList temp = new ArrayList();
temp.Add(staff.pkey);
temp.Add(staff.number);
temp.Add(staff.name);
temp.Add(staff.sex);
temp.Add(staff.eduBackground);
temp.Add(staff.NO);
temp.Add(staff.tel);
temp.Add(staff.address);
temp.Add(staff.email);
temp.Add(staff.enterDate);
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_ROLE", staff.prifileID));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_DEPARTMENT_LIST", staff.departmentID));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STAFF_TYPE", staff.staffType));
temp.Add(staff.remarks);
staffs.Add(i, temp);
}
m_dataGridViewExtend.initDataGridViewData(staffs, 3);
}
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]");
}
