private bool purchaseOrderIsFull(PurchaseApplyOrderTable record)
{
if (record.applyId == -1)
{
MessageBoxExtend.messageWarning("申请人信息不完整，单据保存失败");
return(false);
}
if (record.tradingDate.Length == 0)
{
MessageBoxExtend.messageWarning("日期不完整，单据保存失败");
return(false);
}
if (record.billNumber.Length == 0)
{
MessageBoxExtend.messageWarning("单据号信息不完整，单据保存失败");
return(false);
}
if (record.srcOrderNum.Length > 60)
{
MessageBoxExtend.messageWarning("项目编号信息最大长度为60字符,目前输入的项目编号信息太长，请重新输入");
return(false);
}
return(true);
}
private PurchaseApplyOrderTable getPurchaseApplyOrderValue()
{
PurchaseApplyOrderTable record = new PurchaseApplyOrderTable();
record.applyId = m_applyStaffPkey;
record.tradingDate = this.labelTradingDate.Text;
record.billNumber = this.labelBillNumber.Text;
record.srcOrderNum = this.labelProject.Text;
record.paymentDate = this.labelDeliveryDate.Text;
record.exchangesUnit = this.labelSummary.Text;
record.sumValue = this.dataGridViewDataCount.Rows[0].Cells[(int)DataGridColumnName.Value].Value.ToString();
record.sumMoney = this.dataGridViewDataCount.Rows[0].Cells[(int)DataGridColumnName.Turnover].Value.ToString();
record.sumOtherCost = this.dataGridViewDataCount.Rows[0].Cells[(int)DataGridColumnName.OtherCost].Value.ToString();
record.totalMoney = this.dataGridViewDataCount.Rows[0].Cells[(int)DataGridColumnName.SumTurnover].Value.ToString();
if (m_billNumber.Length == 0)
{
record.makeOrderStaff = DbPublic.getInctance().getCurrentLoginUserID();
}
else
{
record.makeOrderStaff = m_purchaseOrder.makeOrderStaff;
}
return(record);
}
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 void save_Click(object sender, EventArgs e)
{
m_isSaveSuccess = false;
if ((sender.ToString() == "保存" || sender.ToString() == "审核") &&
PurchaseApplyOrder.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString()))
{
MessageBoxExtend.messageWarning("单据已被审核，所有数据无法进行更改，无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情");
return;
}
this.ActiveControl = this.toolStrip1;
// 得到详细的采购信息
ArrayList dataList = getPurchaseOrderDetailsValue();
if (dataList.Count > 0)
{
// 采购订单表头和表尾信息
PurchaseApplyOrderTable record = getPurchaseApplyOrderValue();
if (purchaseOrderIsFull(record) && purchaseOrderDetailsIsFull(dataList))
{
PurchaseApplyOrder.getInctance().insert(record, false);
PurchaseApplyOrderDetails.getInctance().insert(dataList);
BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelTradingDate.Text, this.labelBillNumber.Text.ToString());
m_isSaveSuccess = true;
if (m_billNumber.Length == 0)
{
MessageBoxExtend.messageOK("数据保存成功");
}
this.Close();
}
}
else
{
MessageBoxExtend.messageWarning("此单据不包含任何交易信息，单据保存失败.");
}
}
private void readBillInfoToUI()
{
// 单据表头表尾信息
m_purchaseOrder = PurchaseApplyOrder.getInctance().getPurchaseInfoFromBillNumber(m_billNumber);
m_applyStaffPkey = m_purchaseOrder.applyId;
this.labelPurchaseName.Visible = true;
this.labelTradingDate.Visible = true;
this.labelBillNumber.Visible = true;
this.labelProject.Visible = true;
this.labelDeliveryDate.Visible = true;
this.labelSummary.Visible = true;
this.labelMakeBillStaff.Visible = true;
this.labelReviewBillStaff.Visible = true;
this.labelReviewDate.Visible = true;
this.labelPurchaseName.Text = m_purchaseOrder.applyName;
this.labelTradingDate.Text = m_purchaseOrder.tradingDate;
this.labelBillNumber.Text = m_purchaseOrder.billNumber;
this.labelDeliveryDate.Text = m_purchaseOrder.paymentDate;
this.labelProject.Text = m_purchaseOrder.srcOrderNum;
this.labelSummary.Text = m_purchaseOrder.exchangesUnit;
this.labelMakeBillStaff.Text = m_purchaseOrder.makeOrderStaffName;
// DataGridView 赋值
SortedDictionary <int, PurchaseApplyOrderDetailsTable> purchaseOrderDetails =
PurchaseApplyOrderDetails.getInctance().getPurchaseInfoFromBillNumber(m_billNumber);
foreach (KeyValuePair <int, PurchaseApplyOrderDetailsTable> index in purchaseOrderDetails)
{
PurchaseApplyOrderDetailsTable record = new PurchaseApplyOrderDetailsTable();
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.Brand].Value = record.brand;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Parameter].Value = record.parameter;
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.OtherCost].Value = record.otherCost;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney;
dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.xxMatetielTableRowNum].Value = record.xxMatetielTableRowNum;
}
// 如果单据已审核，则禁用页面所有控件
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.panelPurchaseName.Visible = false;
this.panelTradingDate.Visible = false;
this.panelProjectNum.Visible = false;
this.panelDeliveryDate.Visible = false;
this.panelSummary.Visible = false;
this.textBoxPApplyName.Visible = false;
this.textBoxProject.Visible = false;
this.dateTimePickerTradingDate.Visible = false;
this.dateTimePickerDeliveryDate.Visible = false;
this.textBoxSummary.Visible = false;
}
else
{
this.labelReviewBillStaff.Visible = false;
this.labelReviewDate.Visible = false;
}
}
private void updateDataGridView()
{
SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>();
if (m_orderType == OrderType.PurchaseApplyOrder)
{
SortedDictionary <int, PurchaseApplyOrderTable> list = new SortedDictionary <int, PurchaseApplyOrderTable>();
SortedDictionary <int, PurchaseApplyOrderTable> listOrderList = new SortedDictionary <int, PurchaseApplyOrderTable>();
listOrderList = PurchaseApplyOrder.getInctance().getAllPurchaseOrderInfoFromProjectNum(m_xxMaterielTableNum);
for (int indexOrderList = 0; indexOrderList < listOrderList.Count; indexOrderList++)
{
PurchaseApplyOrderTable recordOrder = new PurchaseApplyOrderTable();
recordOrder = (PurchaseApplyOrderTable)listOrderList[indexOrderList];
if (PurchaseApplyOrderDetails.getInctance().getPurchaseValueFromMaterielID(recordOrder.billNumber, m_materielID) > 0)
{
list.Add(list.Count, recordOrder);
}
}
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
PurchaseApplyOrderTable record = new PurchaseApplyOrderTable();
record = (PurchaseApplyOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.applyName);
temp.Add(record.tradingDate);
temp.Add(record.billNumber);
temp.Add(record.srcOrderNum);
temp.Add(record.paymentDate);
temp.Add(record.totalMoney);
temp.Add(record.makeOrderStaffName);
if (record.isReview == "0")
{
temp.Add("否");
}
else
{
temp.Add("是");
}
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.PurchaseOrder)
{
SortedDictionary <int, PurchaseOrderTable> list = new SortedDictionary <int, PurchaseOrderTable>();
SortedDictionary <int, PurchaseOrderTable> listOrderList = new SortedDictionary <int, PurchaseOrderTable>();
listOrderList = PurchaseOrder.getInctance().getAllPurchaseOrderInfoFromProjectNum(m_xxMaterielTableNum);
for (int indexOrderList = 0; indexOrderList < listOrderList.Count; indexOrderList++)
{
PurchaseOrderTable recordOrder = new PurchaseOrderTable();
recordOrder = (PurchaseOrderTable)listOrderList[indexOrderList];
if (PurchaseOrderDetails.getInctance().getPurchaseValueFromBillNumber(recordOrder.billNumber, m_materielID) > 0)
{
list.Add(list.Count, recordOrder);
}
}
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
PurchaseOrderTable record = new PurchaseOrderTable();
record = (PurchaseOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.supplierName);
temp.Add(record.tradingDate);
temp.Add(record.billNumber);
temp.Add(record.xxMaterielTableNum);
temp.Add(record.deliveryDate);
temp.Add(record.paymentDate);
temp.Add(record.sumMoney);
temp.Add(record.sumTransportationCost);
temp.Add(record.sumOtherCost);
temp.Add(record.totalMoney);
temp.Add(record.businessPeopleName);
temp.Add(record.makeOrderStaffName);
if (record.isReview == "0")
{
temp.Add("否");
}
else
{
temp.Add("是");
}
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.PurchaseIn)
{
SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>();
SortedDictionary <int, PurchaseInOrderTable> listOrderList = new SortedDictionary <int, PurchaseInOrderTable>();
listOrderList = PurchaseInOrder.getInctance().getAllPurchaseOrderInfoFromProjectNum(m_xxMaterielTableNum);
for (int indexOrderList = 0; indexOrderList < listOrderList.Count; indexOrderList++)
{
PurchaseInOrderTable recordOrder = new PurchaseInOrderTable();
recordOrder = (PurchaseInOrderTable)listOrderList[indexOrderList];
if (PurchaseInOrderDetails.getInctance().getPurchaseValueFromBillNumber(recordOrder.billNumber, m_materielID) > 0)
{
list.Add(list.Count, recordOrder);
}
}
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
PurchaseInOrderTable record = new PurchaseInOrderTable();
record = (PurchaseInOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.supplierName);
temp.Add(record.tradingDate);
temp.Add(record.billNumber);
temp.Add(record.purchaseType);
temp.Add(record.srcOrderNum);
temp.Add(record.paymentDate);
temp.Add(record.sourceBillNumber);
temp.Add(record.sumMoney);
temp.Add(record.sumTransportationCost);
temp.Add(record.sumOtherCost);
temp.Add(record.totalMoney);
temp.Add(record.staffSaveName);
temp.Add(record.staffCheckName);
temp.Add(record.businessPeopleName);
temp.Add(record.makeOrderStaffName);
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
temp.Add(record.orderInLedgerName);
temp.Add(record.inLedgerDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.StorageMaterielOut)
{
SortedDictionary <int, MaterielOutOrderTable> list = new SortedDictionary <int, MaterielOutOrderTable>();
SortedDictionary <int, MaterielOutOrderTable> listOrderList = new SortedDictionary <int, MaterielOutOrderTable>();
listOrderList = MaterielOutOrder.getInctance().getAllPurchaseOrderInfoFromProjectNum(m_xxMaterielTableNum);
for (int indexOrderList = 0; indexOrderList < listOrderList.Count; indexOrderList++)
{
MaterielOutOrderTable recordOrder = new MaterielOutOrderTable();
recordOrder = (MaterielOutOrderTable)listOrderList[indexOrderList];
if (MaterielOutOrderDetails.getInctance().getPurchaseValueFromMaterielID(recordOrder.billNumber, m_materielID) > 0)
{
list.Add(list.Count, recordOrder);
}
}
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
MaterielOutOrderTable record = new MaterielOutOrderTable();
record = (MaterielOutOrderTable)list[index];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.departmentName);
temp.Add(record.tradingDate);
temp.Add(record.billNumber);
temp.Add(record.srcOrderNum);
temp.Add(record.makeNo);
temp.Add(record.sumValue);
temp.Add(record.sumMoney);
temp.Add(record.materielOutStaffName);
temp.Add(record.makeOrderStaffName);
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.ChangeApply)
{
//m_dateGridViewExtend.addDataGridViewColumn("ID", 30);
//m_dateGridViewExtend.addDataGridViewColumn("源单据号", 150);
//m_dateGridViewExtend.addDataGridViewColumn("设计人", 80);
//m_dateGridViewExtend.addDataGridViewColumn("单据号", 150);
//m_dateGridViewExtend.addDataGridViewColumn("变更原因", 300);
//m_dateGridViewExtend.addDataGridViewColumn("制单员", 80);
//m_dateGridViewExtend.addDataGridViewColumn("审核员", 80);
//m_dateGridViewExtend.addDataGridViewColumn("审核日期", 80);
// 根据源单据号，得到订单详细单据
if (m_srcChangeOrderBillNumber.Length > 0)
{
SortedDictionary <int, FormProjectMaterielChangeTable> changtList = FormProjectInfoChange.getInctance().getChangeListFromSrcBillNumber(m_srcChangeOrderBillNumber);
m_dataGridRecordCount = changtList.Count;
for (int index = 0; index < changtList.Count; index++)
{
FormProjectMaterielChangeTable record = new FormProjectMaterielChangeTable();
record = (FormProjectMaterielChangeTable)changtList[index];
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.srcBillNumber);
temp.Add(record.designStaffName);
temp.Add(record.billNumber);
temp.Add(record.changeReason);
temp.Add(record.makeOrderStaffName);
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
}
}
