private void FormMaterielEdit_Load(object sender, EventArgs e)
{
// 初始化下拉框值
ComboBoxExtend.initComboBox(this.comboBoxMaterielAttribut, MATERIEL_ATTRIBUTE_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxValuationType, VALUATION_TYPE_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnit, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnitPurchase, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxUnitSale, UNIT_LIST_TABLE_NAME, true);
ComboBoxExtend.initComboBox(this.comboBoxStorage, STORAGE_LIST_TABLE_NAME, true);
if (!m_isAdd)
{
this.buttonAdd.Enabled = false;
this.buttonMaterielGroup.Enabled = false;
if (m_isEditMateriel)
{
m_materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
}
else
{
m_materielType = MaterielType.getInctance().getMaterielTypeInfoFromPkey(m_materielGroupPkey);
m_isMaterielGroup = true;
}
setPageActiveState();
setPageActiveValue();
}
m_isInit = true;
}
private void FormInitMaterielEdit_Load(object sender, EventArgs e)
{
if (m_isEditMaterielData)
{
this.buttonEdit.Enabled = true;
this.buttonSelect.Enabled = false;
this.textBoxPrice.Enabled = false;
this.textBoxValue.Enabled = false;
this.buttonEnter.Enabled = false;
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = Convert.ToString(materiel.pkey) + "-" + materiel.name;
m_materielName = materiel.name;
if (InitMateriel.getInctance().checkMaterielIsExist(m_materielPkey))
{
InitMaterielTable materielStock = InitMateriel.getInctance().getMaterielInfoFromMaterielID(m_materielPkey);
this.textBoxValue.Text = Convert.ToString(materielStock.value);
this.textBoxPrice.Text = Convert.ToString(materielStock.price);
}
else
{
this.textBoxValue.Text = "0";
this.textBoxPrice.Text = "0";
}
}
}
private bool modifyMateriel()
{
MaterielTable materiel = getPageMaterielActiveData();
if (materiel.name.Length == 0)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 物料名称不能为空，请重新输入");
return(false);
}
if (materiel.num.Length == 0)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 物料编号不能为空，请重新输入");
return(false);
}
if (materiel.mnemonicCode.Length > 10)
{
MessageBoxExtend.messageWarning("物料信息保存失败, 助记码长度应小于10，请重新输入");
return(false);
}
Materiel.getInctance().update(m_materielPkey, materiel);
return(true);
}
private void buttonSelect_Click(object sender, EventArgs e)
{
if (m_selectedTextboxIndex <= 0 || m_selectedTextboxIndex > 3)
{
MessageBoxExtend.messageWarning("请将光标移动到指定输入框中后再重新选择物料");
this.buttonSelect.Enabled = false;
return;
}
FormBaseMateriel fbs = new FormBaseMateriel(true);
fbs.ShowDialog();
m_materielPkey = fbs.getSelectRecordPkey();
if (m_materielPkey != 0)
{
if (m_selectedTextboxIndex == 1)
{
this.textBoxStartID.Text = Convert.ToString(m_materielPkey);
}
else if (m_selectedTextboxIndex == 2)
{
this.textBoxEndID.Text = Convert.ToString(m_materielPkey);
}
else
{
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = materiel.name;
}
}
this.buttonSelect.Enabled = false;
m_selectedTextboxIndex = 0;
}
private void writeBillDetailsInfoFromBillNumber(string billNumber)
{
// DataGridView 赋值
SortedDictionary <int, SaleOrderDetailsTable> saleOrderDetails =
SaleOrderDetails.getInctance().getSaleInfoFromBillNumber(billNumber);
foreach (KeyValuePair <int, SaleOrderDetailsTable> index in saleOrderDetails)
{
SaleOrderDetailsTable record = new SaleOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID);
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.Brand].Value = materielInfo.brand;
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.transportationCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney;
}
}
private void setMatetielInfoToDataGridView(string id)
{
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;
}
}
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 = "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 updateStatusLable(int ID)
{
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(ID);
string countInfoToStatusLable = "当前数据过滤条件： ";
string materielName = "物料名称：" + record.name;
string startDate = " 开始日期: ";
string endDate = " 结束日期: ";
string isReview = " 是否审核: ";
startDate += m_countStartDate.Substring(0, 4) + "年";
startDate += m_countStartDate.Substring(4, 2) + "月";
startDate += m_countStartDate.Substring(6) + "日";
endDate += m_countEndDate.Substring(0, 4) + "年";
endDate += m_countEndDate.Substring(4, 2) + "月";
endDate += m_countEndDate.Substring(6) + "日";
isReview += "已审核单据";
countInfoToStatusLable += materielName;
countInfoToStatusLable += startDate;
countInfoToStatusLable += endDate;
countInfoToStatusLable += isReview;
this.toolStripStatusLabelCountInfo.Text = countInfoToStatusLable;
}
private void setMatetielInfoToDataGridView(double pkey)
{
/* 如果是物料编码列，需要判断该物料编码是否存在
* 如果存在读取相应的值填充DataGridView中对应的其他列，如果不存在该物料编码，则清空该行
* */
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
{
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID((int)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 writeBillDetailsInfoFromBillNumber(string billNumber)
{
// DataGridView 赋值
SortedDictionary <int, MaterielInOtherOrderDetailsTable> orderDetails =
MaterielInOtherOrderDetails.getInctance().getMaterielInOtherInfoFromBillNumber(billNumber);
foreach (KeyValuePair <int, MaterielInOtherOrderDetailsTable> index in orderDetails)
{
MaterielInOtherOrderDetailsTable record = new MaterielInOtherOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID);
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.Parameter].Value = materielInfo.materielParameter;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = materielInfo.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materielInfo.unitSale);
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.CZ].Value = materielInfo.CZ;
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.Note].Value = record.note;
}
}
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);
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 FormMaterielDetailed_Load(object sender, EventArgs e)
{
// 物料基本信息
this.labelMaterielID.Text = Convert.ToString(m_materielID);
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(m_materielID);
this.labelMaterielName.Text = record.name;
// 实际库存+预占
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID(m_materielID);
this.labelCount.Text = Convert.ToString(MaterielCountdata.value);
this.labelProCount.Text = Convert.ToString(MaterielProOccupiedOrderDetails.getInctance().getMaterielProCountInfoFromProject(m_materielID));
// 材料表情况
if (m_xxMaterielTablebillNubmber.Length > 0)
{
this.labelxxMaterielTableNum.Text = m_xxMaterielTablebillNubmber;
FormProjectMaterielTable projectInfo = FormProject.getInctance().getProjectInfoFromBillNumber(m_xxMaterielTablebillNubmber);
this.labelProjectNum.Text = projectInfo.projectNum;
this.labelProName.Text = projectInfo.projectName;
this.labelDevMode.Text = projectInfo.deviceMode;
SortedDictionary <int, ProjectManagerDetailsTable> list =
ProjectManagerDetails.getInctance().getPurchaseInfoFromBillNumber(m_xxMaterielTablebillNubmber);
foreach (KeyValuePair <int, ProjectManagerDetailsTable> index in list)
{
if (index.Value.materielID == m_materielID)
{
this.labelSub.Text = index.Value.deviceName;
this.labelNum.Text = index.Value.no;
this.labelSquence.Text = index.Value.sequence;
this.label1Value.Text = Convert.ToString(index.Value.value);
this.labelUseDate.Text = index.Value.useDate;
break;
}
}
}
else
{
this.labelxxMaterielTableNum.Text = " ";
this.labelProjectNum.Text = " ";
this.labelProName.Text = " ";
this.labelDevMode.Text = " ";
this.labelSub.Text = " ";
this.label1Value.Text = " ";
this.labelUseDate.Text = " ";
this.labelNum.Text = " ";
this.labelSquence.Text = " ";
this.labelUseDate.Text = " ";
}
}
private void buttonSelect_Click(object sender, EventArgs e)
{
FormBaseMateriel fbs = new FormBaseMateriel(true);
fbs.ShowDialog();
m_materielPkey = fbs.getSelectRecordPkey();
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = materiel.name;
}
private void setMatetielInfoToDataGridView(string id)
{
/* 如果是物料编码列，需要判断该物料编码是否存在
* 如果存在读取相应的值填充DataGridView中对应的其他列，如果不存在该物料编码，则清空该行
* */
//使用这个输入的值，匹配物料编号
double pkey = 0;
MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id));
if (record == null || id.ToLower() != record.num.ToLower() || record.pkey == 0)
{
try
{
//使用这个输入的值，匹配物料key
pkey = Convert.ToDouble(id.ToString());
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;
}
}
catch
{
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.Parameter].Value = record.materielParameter;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.Brand].Value = record.brand;
dataGridViewDataList.Rows[m_rowIndex].Cells[(int)DataGridColumnName.CZ].Value = record.CZ;
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 addMateriel()
{
MaterielTable materiel = getPageMaterielActiveData();
if (materiel.name.Length == 0)
{
MessageBoxExtend.messageWarning("物料名称不能为空，请重新输入");
return;
}
Materiel.getInctance().insert(materiel);
}
public FormMaterielPriceSheet(int materielID, bool isQuerySupplierPrice = true)
{
InitializeComponent();
m_materielID = materielID;
m_isQuerySupplierPrice = isQuerySupplierPrice;
MaterielTable record = Materiel.getInctance().getMaterielInfoFromPkey(materielID);
if (m_isQuerySupplierPrice)
{
this.Text = "物料 [" + record.name + "] 供应商报价信息";
}
else
{
this.Text = "商品 [" + record.name + "] 销售指导价格";
}
}
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 setMatetielInfoToDataGridView(string id, int rowIndex)
{
//使用这个输入的值，匹配物料编号
MaterielTable record = Materiel.getInctance().getMaterielInfoFromNum(Convert.ToString(id));
if (record == null || id.ToLower() != record.num.ToLower() || record.pkey == 0)
{
try
{
//使用这个输入的值，匹配物料key
double pkey = Convert.ToDouble(id.ToString());
record = Materiel.getInctance().getMaterielInfoFromPkey((int)pkey);
if (pkey != record.pkey || record.pkey == 0)
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(rowIndex);
return;
}
}
catch
{
MessageBoxExtend.messageWarning("[" + dataGridViewDataList.Rows[rowIndex].Cells[m_columnIndex].EditedFormattedValue.ToString() +
"]不存在，请重新输入或选择");
m_dateGridVeiwListDataList.clearDataGridViewRow(rowIndex);
return;
}
}
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.pkey;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.name;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = record.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.model;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Parameter].Value = record.materielParameter;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value =
AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", record.unitPurchase);
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = "0";
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = "0";
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = "0";
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = "0";
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = "0";
}
private void exportPurchaseApplyData()
{
int startRowIndex = 4;
// 采购入库单数据导出
PurchaseApplyOrderTable table = new PurchaseApplyOrderTable();
table = PurchaseApplyOrder.getInctance().getPurchaseInfoFromBillNumber(m_billNubmber);
FormProjectMaterielTable projectInfo = FormProject.getInctance().getProjectInfoFromBillNumber(table.srcOrderNum);
stringReplace(table.billNumber, "[1]");
stringReplace(table.srcOrderNum, "[2]");
stringReplace(table.exchangesUnit, "[3]");
double sum = 0.0;
for (int row = 0; row < m_dataGridView.RowCount; row++)
{
if (m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0)
{
break;
}
int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.MatetielNumber].Value.ToString());
MaterielTable tmp = Materiel.getInctance().getMaterielInfoFromPkey(materielID);
m_excelApp.Cells[row + startRowIndex, 2] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.MatetielNumber].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 3] = projectInfo.projectName;
m_excelApp.Cells[row + startRowIndex, 4] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Brand].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 5] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.MatetielName].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 6] = "";
m_excelApp.Cells[row + startRowIndex, 7] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Model].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 8] = tmp.CZ;
m_excelApp.Cells[row + startRowIndex, 9] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Parameter].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 10] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Unit].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 11] = m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Value].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 12] = table.paymentDate;
m_excelApp.Cells[row + startRowIndex, 13] = "";
m_excelApp.Cells[row + startRowIndex, 14] = "";
sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormPurchaseApply.DataGridColumnName.Value].Value.ToString().Trim());
}
stringReplace(Convert.ToString(sum), "[4]");
}
private bool addMateriel(int materielGroupPkey)
{
MaterielTable materiel = new MaterielTable();
materiel.materielType = materielGroupPkey;
materiel.name = "name-" + Convert.ToString(materielGroupPkey);
materiel.num = "1";
materiel.nameShort = "2";
materiel.model = "3";
materiel.mnemonicCode = "4";
materiel.brand = "5";
materiel.materielParameter = "6";
Materiel.getInctance().insert(materiel, false);
return(true);
}
private void noForbid_Click(object sender, EventArgs e)
{
SortedDictionary <int, MaterielTable> forbidMaterielList = Materiel.getInctance().getAllForbidMaterielInfo();
ArrayList forbidMateriels = new ArrayList();
foreach (KeyValuePair <int, MaterielTable> index in forbidMaterielList)
{
MaterielTable materiel = new MaterielTable();
materiel = index.Value;
forbidMateriels.Add(Convert.ToString(materiel.pkey));
forbidMateriels.Add(Convert.ToString(materiel.name));
}
FormNoForbid fnfs = new FormNoForbid(forbidMateriels, "物料反禁用", ForbidDataType.Materiel);
fnfs.ShowDialog();
updateDataGridView(getCurrentNodeAllChildNodesMateriel());
}
private void FormInitMaterielEdit_Load(object sender, EventArgs e)
{
if (m_isEditMaterielData)
{
this.buttonEdit.Enabled = true;
this.buttonSelect.Enabled = false;
this.textBoxPrice.Enabled = false;
this.textBoxValue.Enabled = false;
this.buttonEnter.Enabled = false;
InitMaterielTable materielStock = InitMateriel.getInctance().getMaterielInfoFromPkey(m_storageStockTablePkey);
m_materielPkey = materielStock.materielID;
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromPkey(m_materielPkey);
this.textBoxName.Text = Convert.ToString(materiel.pkey) + "-" + materiel.name;
this.textBoxValue.Text = Convert.ToString(materielStock.value);
this.textBoxPrice.Text = Convert.ToString(materielStock.price);
m_materielName = materiel.name;
}
}
private void exportOtherOutData()
{
int startRowIndex = 6;
// 采购入库单数据导出
MaterielOutOtherOrderTable table = new MaterielOutOtherOrderTable();
table = MaterielOutOtherOrder.getInctance().getMaterielOutOtherOrderInfoFromBillNumber(m_billNubmber);
stringReplace(table.billNumber, "[1]");
stringReplace(table.exchangesUnit, "[2]");
stringReplace(table.makeOrderStaffName, "[3]");
stringReplace(table.projectNo, "[5]");
stringReplace(table.makeNo, "[6]");
double sum = 0.0;
for (int row = 0; row < m_dataGridView.RowCount; row++)
{
if (m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0)
{
break;
}
int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.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)FormMaterielOutOtherOrder.DataGridColumnName.MatetielName].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 5] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.Model].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 7] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.Unit].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 8] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.Value].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 9] = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", record.storage);
m_excelApp.Cells[row + startRowIndex, 10] = m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.Note].Value.ToString().Trim();
sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormMaterielOutOtherOrder.DataGridColumnName.Value].Value.ToString().Trim());
}
stringReplace(Convert.ToString(sum), "[4]");
}
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];
ArrayList temp = new ArrayList();
temp.Add(materiel.pkey);
temp.Add(materiel.materielType);
temp.Add(materiel.name);
temp.Add(materiel.num);
temp.Add(materiel.nameShort);
temp.Add(materiel.mnemonicCode);
temp.Add(materiel.model);
temp.Add(materiel.brand);
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_STORAGE_LIST", materiel.storage));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_MATERIEL_ATTRIBUTE", materiel.materielAttribute));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_VALUATION_TYPE_LIST", materiel.valuation));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unit));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitPurchase));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitSale));
temp.Add(AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_UNIT_LIST", materiel.unitStorage));
temp.Add(materiel.max);
temp.Add(materiel.min);
temp.Add(materiel.warramty);
temp.Add(materiel.note);
materiels.Add(i, temp);
}
m_dataGridViewExtend.initDataGridViewData(materiels, 4);
}
private void updateDataGridView(SortedDictionary <int, MaterielTable> settlmentWayList)
{
m_dataGridRecordCount = settlmentWayList.Count;
SortedDictionary <int, ArrayList> settlmentWayLArrary = new SortedDictionary <int, ArrayList>();
SortedDictionary <int, AuxiliaryMaterialDataTable> AuxiliaryStorelList =
AuxiliaryMaterial.getInctance().getAuxiliaryListFromTableName("BASE_STORAGE_LIST");
for (int i = 0; i < settlmentWayList.Count; i++)
{
MaterielTable record = new MaterielTable();
record = (MaterielTable)settlmentWayList[i];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.num);
temp.Add(record.name);
if (AuxiliaryStorelList.ContainsKey(record.storage))
{
temp.Add(AuxiliaryStorelList[record.storage].name);
}
else
{
temp.Add("");
}
InitMaterielTable MaterielCountdata = InitMateriel.getInctance().getMaterielInfoFromMaterielID(record.pkey);
temp.Add(MaterielCountdata.price);
temp.Add(MaterielCountdata.value);
settlmentWayLArrary.Add(i, temp);
}
m_dateGridViewExtend.initDataGridViewData(settlmentWayLArrary);
}
private SortedDictionary <int, MaterielTable> getCurrentNodeAllChildNodesMateriel()
{
SortedDictionary <int, MaterielTable> materielList = new SortedDictionary <int, MaterielTable>();
SortedDictionary <int, int> childNodeValues = MaterielOrgStruct.getInctance().getAllChildNodeValue(m_materielGroupPkey);
if (!childNodeValues.ContainsKey(m_materielGroupPkey))
{
childNodeValues.Add(m_materielGroupPkey, m_materielGroupPkey);
}
foreach (KeyValuePair <int, int> index in childNodeValues)
{
SortedDictionary <int, MaterielTable> temp = Materiel.getInctance().getMaterielInfoFromMaterielType(index.Value);
foreach (KeyValuePair <int, MaterielTable> i in temp)
{
MaterielTable materiel = new MaterielTable();
materielList.Add(materielList.Count, (MaterielTable)i.Value);
}
}
return(materielList);
}
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.unitPurchase);
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 buttonEnter_Click(object sender, EventArgs e)
{
m_startDate = this.dateTimePickerStartDate.Value.ToString("yyyyMMdd");
m_endDate = this.dateTimePickerEndDate.Value.ToString("yyyyMMdd");
m_allReview = Convert.ToString(this.comboBoxReview.SelectedIndex);
if (radioButtonMateriel.Checked)
{
string materielName = this.textBoxName.Text;
MaterielTable materiel = Materiel.getInctance().getMaterielInfoFromMaterielName(materielName);
if (materiel != null)
{
m_materielPkey = materiel.pkey;
this.Close();
}
else
{
m_materielPkey = -1;
MessageBoxExtend.messageWarning("输出的物料名称: " + materielName + ", 查询不到对应的物料信息, 请重新输出或点击物料选择按钮");
this.textBoxName.Text = "";
}
}
}
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 readBillInfoToUI()
{
// 单据表头表尾信息
m_purchaseOrder = SaleOrder.getInctance().getSaleInfoFromBillNumber(m_billNumber);
m_customerPkey = m_purchaseOrder.customerId;
this.labelSaleName.Visible = true;
this.labelTradingDate.Visible = true;
this.labelBillNumber.Visible = true;
this.labelSaleType.Visible = true;
this.labelDeliveryDate.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.labelSaleName.Text = m_purchaseOrder.customerName;
this.labelTradingDate.Text = m_purchaseOrder.tradingDate;
this.labelBillNumber.Text = m_purchaseOrder.billNumber;
this.labelSaleType.Text = m_purchaseOrder.saleType;
this.labelDeliveryDate.Text = m_purchaseOrder.deliveryDate;
this.labelPaymentDate.Text = m_purchaseOrder.paymentDate;
this.labelSummary.Text = m_purchaseOrder.exchangesUnit;
m_staffPkey = m_purchaseOrder.businessPeopleId;
this.labelBusinessPeople.Text = m_purchaseOrder.businessPeopleName;
this.labelMakeBillStaff.Text = m_purchaseOrder.makeOrderStaffName;
// DataGridView 赋值
SortedDictionary <int, SaleOrderDetailsTable> purchaseOrderDetails =
SaleOrderDetails.getInctance().getSaleInfoFromBillNumber(m_billNumber);
foreach (KeyValuePair <int, SaleOrderDetailsTable> index in purchaseOrderDetails)
{
SaleOrderDetailsTable record = new SaleOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
MaterielTable materielInfo = Materiel.getInctance().getMaterielInfoFromPkey(record.materielID);
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.Brand].Value = materielInfo.brand;
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.transportationCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney;
}
// 如果单据已审核，则禁用页面所有控件
if (m_purchaseOrder.isReview == "1")
{
this.labelReviewBillStaff.Text = m_purchaseOrder.orderrReviewName;
this.labelReviewDate.Text = m_purchaseOrder.reviewDate;
this.panelIsReview.Visible = true;
this.save.Enabled = false;
this.toolStripButtonReview.Enabled = false;
this.dataGridViewDataList.ReadOnly = true;
this.dataGridViewDataCount.ReadOnly = true;
this.panelSaleName.Visible = false;
this.panelTradingDate.Visible = false;
this.panelSaleType.Visible = false;
this.panelDeliveryDate.Visible = false;
this.panelPaymentDate.Visible = false;
this.panelSummary.Visible = false;
this.textBoxSaleName.Visible = false;
this.dateTimePickerTradingDate.Visible = false;
this.comboBoxSaleType.Visible = false;
this.dateTimePickerDeliveryDate.Visible = false;
this.dateTimePickerPaymentDate.Visible = false;
this.textBoxSummary.Visible = false;
this.panelBusinessPeople.Visible = false;
}
else
{
this.labelReviewBillStaff.Visible = false;
this.labelReviewDate.Visible = false;
}
}
