private bool purchaseOrderDetailsIsFull(ArrayList list)
{
bool isRet = true;
for (int rowIndex = 0; rowIndex < list.Count; rowIndex++)
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record = (PurchaseInOrderDetailsTable)list[rowIndex];
//string price = Convert.ToString(record.price);
//string value = Convert.ToString(record.value);
if (record.price == 0)
{
MessageBoxExtend.messageWarning("第[" + record.rowNumber + "]信息中物料单价不能为空");
isRet = false;
break;
}
if (record.value == 0)
{
MessageBoxExtend.messageWarning("第[" + record.rowNumber + "]信息中物料数量不能为空");
isRet = false;
break;
}
}
return(isRet);
}
private ArrayList getPurchaseInOrderDetailsValue()
{
ArrayList list = new ArrayList();
for (int rowIndex = 0; rowIndex < DateGridVeiwListDataListRowCount; rowIndex++)
{
if (this.dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value.ToString().Length == 0)
{
break;
}
else
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record.rowNumber = dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.RowNum].Value.ToString();
record.materielID = Convert.ToInt32(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value.ToString());
record.price = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value.ToString());
record.value = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value.ToString());
record.costApportionments = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value.ToString());
record.noCostApportionments = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value.ToString());
record.billNumber = this.labelBillNumber.Text;
list.Add(record);
}
}
return(list);
}
private SortedDictionary <int, ArrayList> getPurchaseMaterielData(out double sumTotleMoney)
{
SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>();
SortedDictionary <int, PurchaseInOrderDetailsTable> list = new SortedDictionary <int, PurchaseInOrderDetailsTable>();
list = PurchaseInOrderDetails.getInctance().getPurchaseInOrderCountInfo(m_countStartDate, m_countEndDate, m_isCountAllBill);
m_dataGridRecordCount = list.Count;
sumTotleMoney = getSumTotleMoney(list);
for (int index = 0; index < list.Count; index++)
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record = (PurchaseInOrderDetailsTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(index + 1);
temp.Add(record.materielID);
temp.Add(record.materielName);
temp.Add(record.materielModel);
temp.Add(record.totalMoney);
temp.Add(getPercentValue(record.totalMoney, sumTotleMoney));
sortedDictionaryList.Add(index, temp);
}
return(sortedDictionaryList);
}
private double getSumTotleMoney(SortedDictionary <int, PurchaseInOrderDetailsTable> list)
{
double sumTotleMoney = 0.0;
for (int index = 0; index < list.Count; index++)
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record = (PurchaseInOrderDetailsTable)list[index];
sumTotleMoney += record.totalMoney;
}
return(sumTotleMoney);
}
private void readBillInfoToUI()
{
// 单据表头表尾信息
m_purchaseInOrder = PurchaseInOrder.getInctance().getPurchaseInfoFromBillNumber(m_billNumber);
m_supplierPkey = m_purchaseInOrder.supplierId;
m_staffSavePkey = m_purchaseInOrder.staffSaveId;
m_staffCheckPkey = m_purchaseInOrder.staffCheckId;
this.labelPurchaseName.Visible = true;
this.labelTradingDate.Visible = true;
this.labelBillNumber.Visible = true;
this.labelPurchaseType.Visible = true;
this.labelPaymentDate.Visible = true;
this.labelSummary.Visible = true;
this.labelBusinessPeople.Visible = true;
this.labelMakeBillStaff.Visible = true;
this.labelReviewBillStaff.Visible = true;
this.labelReviewDate.Visible = true;
this.labelSourceOrderType.Visible = true;
this.labelSourceOrderNumber.Visible = true;
this.labelSave.Visible = true;
this.labelVerify.Visible = true;
this.labelContractNum.Visible = true;
this.labelPurchaseName.Text = m_purchaseInOrder.supplierName;
this.labelTradingDate.Text = m_purchaseInOrder.tradingDate;
this.labelBillNumber.Text = m_purchaseInOrder.billNumber;
this.labelContractNum.Text = m_purchaseInOrder.contractNum;
this.labelPurchaseType.Text = m_purchaseInOrder.purchaseType;
this.labelPaymentDate.Text = m_purchaseInOrder.paymentDate;
this.labelSummary.Text = m_purchaseInOrder.exchangesUnit;
m_staffPkey = m_purchaseInOrder.businessPeopleId;
this.labelBusinessPeople.Text = m_purchaseInOrder.businessPeopleName;
this.labelMakeBillStaff.Text = m_purchaseInOrder.makeOrderStaffName;
this.labelSourceOrderType.Text = m_purchaseInOrder.sourceBillType;
this.labelSourceOrderNumber.Text = m_purchaseInOrder.sourceBillNumber;
this.labelSave.Text = m_purchaseInOrder.staffSaveName;
this.labelVerify.Text = m_purchaseInOrder.staffCheckName;
this.labelContractNum.Text = m_purchaseInOrder.contractNum;
// DataGridView 赋值
SortedDictionary <int, PurchaseInOrderDetailsTable> purchaseOrderDetails =
PurchaseInOrderDetails.getInctance().getPurchaseInfoFromBillNumber(m_billNumber);
foreach (KeyValuePair <int, PurchaseInOrderDetailsTable> index in purchaseOrderDetails)
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record = index.Value;
int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = record.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitPurchase;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.costApportionments;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.noCostApportionments;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney;
}
// 如果单据已审核，则禁用页面所有控件
if (m_purchaseInOrder.isReview == "1")
{
this.labelReviewBillStaff.Text = m_purchaseInOrder.orderrReviewName;
this.labelReviewDate.Text = m_purchaseInOrder.reviewDate;
this.panelIsReview.Visible = true;
this.save.Enabled = false;
this.toolStripButtonReview.Enabled = false;
this.panelPurchaseName.Visible = false;
this.panelTradingDate.Visible = false;
this.panelPurchaseType.Visible = false;
this.panelPaymentDate.Visible = false;
this.panelSummary.Visible = false;
this.textBoxPurchaseName.Visible = false;
this.dateTimePickerTradingDate.Visible = false;
this.comboBoxPurchaseType.Visible = false;
this.dateTimePickerPaymentDate.Visible = false;
this.textBoxSummary.Visible = false;
this.panelBusinessPeople.Visible = false;
this.registerInLedger.Enabled = true;
this.redBill.Enabled = false;
this.blueBill.Enabled = false;
}
else
{
this.labelReviewBillStaff.Visible = false;
this.labelReviewDate.Visible = false;
this.registerInLedger.Enabled = false;
}
// 如果单据已经记账，则出来红字已记账提示
if (m_purchaseInOrder.isInLedger == 1)
{
this.panelInLedger.Visible = true;
this.registerInLedger.Enabled = false;
this.dataGridViewDataList.ReadOnly = true;
this.dataGridViewDataCount.ReadOnly = true;
}
else
{
this.dataGridViewDataList.Enabled = true;
this.dataGridViewDataCount.Enabled = true;
}
if (m_purchaseInOrder.isRedBill == 1)
{
m_isRedBill = true;
this.panelRed.Visible = true;
}
}
private void updateDataGridView()
{
double sumTotleMoney = 0;
SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>();
int index = 0;
if (m_orderType == CountType.Materiel)
{
SortedDictionary <int, PurchaseInOrderDetailsTable> list = new SortedDictionary <int, PurchaseInOrderDetailsTable>();
list = PurchaseInOrderDetails.getInctance().getPurchaseInOrderCountInfo(m_countStartDate, m_countEndDate, m_isCountAllBill);
m_dataGridRecordCount = list.Count;
sumTotleMoney = getSumTotleMoney(list);
for (index = 0; index < list.Count; index++)
{
PurchaseInOrderDetailsTable record = new PurchaseInOrderDetailsTable();
record = (PurchaseInOrderDetailsTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(index + 1);
temp.Add(record.materielID);
temp.Add(record.materielName);
temp.Add(record.materielModel);
temp.Add(record.totalMoney);
temp.Add(getPercentValue(record.totalMoney, sumTotleMoney));
sortedDictionaryList.Add(index, temp);
}
}
else if (m_orderType == CountType.People)
{
SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>();
list = PurchaseInOrder.getInctance().getPurchaseInOrderCountInfo(m_countStartDate, m_countEndDate, m_isCountAllBill, 2);
m_dataGridRecordCount = list.Count;
sumTotleMoney = getSumTotleMoney(list);
for (index = 0; index < list.Count; index++)
{
PurchaseInOrderTable record = new PurchaseInOrderTable();
record = (PurchaseInOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(index + 1);
temp.Add(record.businessPeopleId);
temp.Add(record.businessPeopleName);
temp.Add(record.totalMoney);
temp.Add(getPercentValue(Convert.ToDouble(record.totalMoney.ToString()), sumTotleMoney));
sortedDictionaryList.Add(index, temp);
}
}
else if (m_orderType == CountType.Supplier)
{
SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>();
list = PurchaseInOrder.getInctance().getPurchaseInOrderCountInfo(m_countStartDate, m_countEndDate, m_isCountAllBill, 1);
m_dataGridRecordCount = list.Count;
sumTotleMoney = getSumTotleMoney(list);
for (index = 0; index < list.Count; index++)
{
PurchaseInOrderTable record = new PurchaseInOrderTable();
record = (PurchaseInOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(index + 1);
temp.Add(record.supplierId);
temp.Add(record.supplierName);
temp.Add(record.totalMoney);
temp.Add(getPercentValue(Convert.ToDouble(record.totalMoney.ToString()), sumTotleMoney));
sortedDictionaryList.Add(index, temp);
}
}
// 添加合计行
ArrayList sumRow = new ArrayList();
sumRow.Add(index + 1);
sumRow.Add("合计");
sumRow.Add("");
if (m_orderType == CountType.Materiel)
{
sumRow.Add("");
}
sumRow.Add(sumTotleMoney);
sumRow.Add("100%");
sortedDictionaryList.Add(index, sumRow);
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList);
dataGridViewList.Rows[index].DefaultCellStyle.BackColor = System.Drawing.Color.LightBlue;
// 更新状态栏信息
updateStatusLable();
}
