private MaterielInOtherOrderTable getMaterielInOtherOrderValue()
{
MaterielInOtherOrderTable record = new MaterielInOtherOrderTable();
record.tradingDate = this.labelTradingDate.Text;
record.billNumber = this.labelBillNumber.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.staffSaveId = m_staffSavePkey;
record.orderReviewStaffId = m_materielOutStaffPkey;
if (m_billNumber.Length == 0)
{
record.makeOrderStaff = DbPublic.getInctance().getCurrentLoginUserID();
}
else
{
record.makeOrderStaff = m_materieInOrder.makeOrderStaff;
}
if (m_isRedBill)
{
record.isRedBill = 1;
}
else
{
record.isRedBill = 0;
}
return(record);
}
private void save_Click(object sender, EventArgs e)
{
// 得到详细的销售信息
ArrayList dataList = getMaterielInOtherOrderDetailsValue();
if (dataList.Count > 0)
{
// 销售订单表头和表尾信息
MaterielInOtherOrderTable record = getMaterielInOtherOrderValue();
if (orderInfoIsFull(record) && orderDetailsIsFull(dataList))
{
MaterielInOtherOrder.getInctance().insert(record, false);
MaterielInOtherOrderDetails.getInctance().insert(dataList);
BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelTradingDate.Text, this.labelBillNumber.Text.ToString());
if (m_billNumber.Length == 0)
{
MessageBoxExtend.messageOK("数据保存成功");
}
this.Close();
}
}
else
{
MessageBoxExtend.messageWarning("此单据不包含任何交易信息，单据保存失败.");
}
}
private bool orderInfoIsFull(MaterielInOtherOrderTable record)
{
if (record.tradingDate.Length == 0)
{
MessageBoxExtend.messageWarning("日期不完整，单据保存失败");
return(false);
}
if (record.orderReviewStaffId == -1)
{
MessageBoxExtend.messageWarning("领料人信息不完整，单据保存失败");
return(false);
}
return(true);
}
private void save_Click(object sender, EventArgs e)
{
m_isSaveSuccess = false;
if ((sender.ToString() == "保存" || sender.ToString() == "审核") &&
MaterielInOtherOrder.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString()))
{
MessageBoxExtend.messageWarning("单据已被审核，所有数据无法进行更改，无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情");
return;
}
this.ActiveControl = this.toolStrip1;
// 得到详细的销售信息
ArrayList dataList = getMaterielInOtherOrderDetailsValue();
if (dataList.Count > 0)
{
// 销售订单表头和表尾信息
MaterielInOtherOrderTable record = getMaterielInOtherOrderValue();
if (orderInfoIsFull(record) && orderDetailsIsFull(dataList))
{
MaterielInOtherOrder.getInctance().insert(record, false);
MaterielInOtherOrderDetails.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 exportOtherInData()
{
int startRowIndex = 6;
// 采购入库单数据导出
MaterielInOtherOrderTable table = new MaterielInOtherOrderTable();
table = MaterielInOtherOrder.getInctance().getMaterielInOtherOrderInfoFromBillNumber(m_billNubmber);
stringReplace(table.billNumber, "[1]");
stringReplace(table.exchangesUnit, "[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)FormMaterielInOtherOrder.DataGridColumnName.MatetielNumber].Value.ToString().Length == 0)
{
break;
}
int materielID = Convert.ToInt32(m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.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)FormMaterielInOtherOrder.DataGridColumnName.MatetielName].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 5] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.Model].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 6] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.Unit].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 7] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.CZ].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 8] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.Value].Value.ToString().Trim();
m_excelApp.Cells[row + startRowIndex, 9] = m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.Note].Value.ToString().Trim();
sum += Convert.ToDouble(m_dataGridView.Rows[row].Cells[(int)FormMaterielInOtherOrder.DataGridColumnName.Value].Value.ToString().Trim());
}
stringReplace(Convert.ToString(sum), "[4]");
}
private void readBillInfoToUI()
{
// 单据表头表尾信息
m_materieInOrder = MaterielInOtherOrder.getInctance().getMaterielInOtherOrderInfoFromBillNumber(m_billNumber);
m_staffSavePkey = m_materieInOrder.staffSaveId;
m_materielOutStaffPkey = m_materieInOrder.orderReviewStaffId;
this.labelTradingDate.Visible = true;
this.labelBillNumber.Visible = true;
this.labelMakeBillStaff.Visible = true;
this.labelReviewBillStaff.Visible = true;
this.labelReviewDate.Visible = true;
this.labelSave.Visible = true;
this.labelVerify.Visible = true;
this.labelSummary.Visible = true;
this.labelTradingDate.Text = m_materieInOrder.tradingDate;
this.labelBillNumber.Text = m_materieInOrder.billNumber;
this.labelMakeBillStaff.Text = m_materieInOrder.makeOrderStaffName;
this.labelSave.Text = m_materieInOrder.staffSaveName;
this.labelVerify.Text = m_materieInOrder.orderReviewStaffName;
this.labelSummary.Text = m_materieInOrder.exchangesUnit;
// DataGridView 赋值
writeBillDetailsInfoFromBillNumber(m_billNumber);
// 如果单据已审核，则禁用页面所有控件
if (m_materieInOrder.isReview == "1")
{
this.labelReviewBillStaff.Text = m_materieInOrder.orderrReviewName;
this.labelReviewDate.Text = m_materieInOrder.reviewDate;
this.panelIsReview.Visible = true;
this.save.Enabled = false;
this.toolStripButtonReview.Enabled = false;
this.panelTradingDate.Visible = false;
this.dateTimePickerTradingDate.Visible = false;
this.textBoxSummary.Visible = false;
this.dataGridViewDataList.Enabled = false;
this.dataGridViewDataCount.Enabled = false;
this.redBill.Enabled = false;
this.blueBill.Enabled = false;
this.registerInLedger.Enabled = true;
}
else
{
this.labelReviewBillStaff.Visible = false;
this.labelReviewDate.Visible = false;
}
// 如果单据已经记账，则出来红字已记账提示
if (m_materieInOrder.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_materieInOrder.isRedBill == 1)
{
m_isRedBill = true;
this.panelRed.Visible = true;
}
}
private void updateDataGridView()
{
SortedDictionary <int, ArrayList> sortedDictionaryList = new SortedDictionary <int, ArrayList>();
if (m_orderType == OrderType.PurchaseOrder)
{
SortedDictionary <int, PurchaseOrderTable> list = new SortedDictionary <int, PurchaseOrderTable>();
list = PurchaseOrder.getInctance().getAllPurchaseOrderInfo();
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
PurchaseOrderTable record = new PurchaseOrderTable();
record = (PurchaseOrderTable)list[index];
if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0))
{
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.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>();
list = PurchaseInOrder.getInctance().getAllPurchaseInOrderInfo();
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
PurchaseInOrderTable record = new PurchaseInOrderTable();
record = (PurchaseInOrderTable)list[index];
if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0))
{
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.contractNum);
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.PurchaseInvoice)
{
}
else if (m_orderType == OrderType.PurchaseOrderExcute)
{
SortedDictionary <int, PurchaseOrderTable> list = new SortedDictionary <int, PurchaseOrderTable>();
list = PurchaseOrder.getInctance().getAllPurchaseOrderInfo();
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.deliveryDate);
temp.Add(record.sumValue);
if (record.isInStorage == "0")
{
temp.Add("否");
}
else
{
temp.Add("是");
}
temp.Add(record.actualValue);
temp.Add(record.businessPeopleName);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.PurchaseInOrderExcute)
{
SortedDictionary <int, PurchaseInOrderTable> list = new SortedDictionary <int, PurchaseInOrderTable>();
list = PurchaseInOrder.getInctance().getAllPurchaseInOrderInfo();
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.paymentDate);
temp.Add(record.totalMoney);
temp.Add(record.paymentOk);
temp.Add(record.paymentNoOk);
temp.Add(record.businessPeopleName);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
else if (m_orderType == OrderType.StorageProductIn)
{
// 仓存管理-产品入库
SortedDictionary <int, MaterielInOrderTable> list = new SortedDictionary <int, MaterielInOrderTable>();
list = MaterielInOrder.getInctance().getAllMaterielInOrderInfo();
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
bool isDisplayRecord = false;
MaterielInOrderTable record = new MaterielInOrderTable();
record = (MaterielInOrderTable)list[index];
if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0))
{
// 等于0代表只显示已审核单据
if (m_filter.allReview == "0")
{
if (record.isReview == "1")
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
else
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
if (isDisplayRecord)
{
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.departmentName);
temp.Add(record.tradingDate);
temp.Add(record.billNumber);
temp.Add(record.sumValue);
temp.Add(record.sumMoney);
temp.Add(record.orderReviewStaffName);
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.StorageInCheck)
{
// 仓存管理-盘盈入库
SortedDictionary <int, MaterielInEarningsOrderTable> list = new SortedDictionary <int, MaterielInEarningsOrderTable>();
list = MaterielInEarningsOrder.getInctance().getAllMaterielInEarningsOrderInfo();
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
bool isDisplayRecord = false;
MaterielInEarningsOrderTable record = new MaterielInEarningsOrderTable();
record = (MaterielInEarningsOrderTable)list[index];
if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0))
{
// 等于0代表只显示已审核单据
if (m_filter.allReview == "0")
{
if (record.isReview == "1")
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
else
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
if (isDisplayRecord)
{
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.tradingDate);
temp.Add("");
temp.Add(record.billNumber);
temp.Add(record.sumValue);
temp.Add(record.sumMoney);
temp.Add(record.orderReviewStaffName);
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.StorageInOther)
{
// 仓存管理-其他入库
SortedDictionary <int, MaterielInOtherOrderTable> list = new SortedDictionary <int, MaterielInOtherOrderTable>();
list = MaterielInOtherOrder.getInctance().getAllMaterielInOtherOrderInfo();
m_dataGridRecordCount = list.Count;
for (int index = 0; index < list.Count; index++)
{
bool isDisplayRecord = false;
MaterielInOtherOrderTable record = new MaterielInOtherOrderTable();
record = (MaterielInOtherOrderTable)list[index];
if (m_filter.startDate == null || (record.tradingDate.CompareTo(m_filter.startDate) >= 0 && record.tradingDate.CompareTo(m_filter.endDate) <= 0))
{
// 等于0代表只显示已审核单据
if (m_filter.allReview == "0")
{
if (record.isReview == "1")
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
else
{
if (m_filter.billColor == "0") // 需要显示蓝字单据
{
if (record.isRedBill == 0)
{
isDisplayRecord = true;
}
}
else if (m_filter.billColor == "1") // 需要显示红字单据
{
if (record.isRedBill == 1)
{
isDisplayRecord = true;
}
}
else // 需要显示全部颜色单据
{
isDisplayRecord = true;
}
}
}
if (isDisplayRecord)
{
ArrayList temp = new ArrayList();
temp.Add(record.pkey);
temp.Add(record.tradingDate);
temp.Add("");
temp.Add(record.billNumber);
temp.Add(record.sumValue);
temp.Add(record.sumMoney);
temp.Add(record.orderReviewStaffName);
temp.Add(record.makeOrderStaffName);
temp.Add(record.orderrReviewName);
temp.Add(record.reviewDate);
sortedDictionaryList.Add(sortedDictionaryList.Count, temp);
}
}
m_dateGridViewExtend.initDataGridViewData(sortedDictionaryList, 3);
}
}
