private void initDta() { BllReReceiptTable RRTable = bReceipt.GetReModel(_slip_number); if (RRTable != null) { try { SlipDate.Value = CConvert.ToDateTime(RRTable.SLIP_DATE); txtSupplierCode.Text = RRTable.SUPPLIER_CODE; if (bCommon.GetBaseMaster("SUPPLIER", RRTable.SUPPLIER_CODE) != null) { txtSupplierName.Text = bCommon.GetBaseMaster("SUPPLIER", RRTable.SUPPLIER_CODE).Name; } txtPurchaseNumber.Text = RRTable.PO_SLIP_NUMBER; foreach (DataRow dr in CCacheData.Taxation.Rows) { if (CConvert.ToDecimal(dr["TAX_RATE"]) == CConvert.ToDecimal(RRTable.TAX_RATE) * 100) { this.cboTax.SelectedValue = dr["CODE"]; break; } } cboReturn.SelectedValue = RRTable.RERECEIPT_FLAG; foreach (BllReReceiptLineTable RRLTable in RRTable.Items) { int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow row = dgvData.Rows[currentRowIndex]; row.Cells[1].Selected = false; row.Cells["NO"].Value = RRLTable.LINE_NUMBER; row.Cells["PRODUCT_CODE"].Value = RRLTable.PRODUCT_CODE; BaseProductTable product = bProduct.GetModel(RRLTable.PRODUCT_CODE); if (product != null) { row.Cells["NAME"].Value = product.NAME; row.Cells["SPEC"].Value = product.SPEC + " " + product.MODEL_NUMBER; } row.Cells["QUANTITY"].Value = RRLTable.QUANTITY; if (bCommon.GetBaseMaster("UNIT", RRLTable.UNIT_CODE) != null) { row.Cells["UNIT_NAME"].Value = bCommon.GetBaseMaster("UNIT", RRLTable.UNIT_CODE).Name; } row.Cells["PRICE"].Value = RRLTable.PRICE; row.Cells["AMOUNT"].Value = RRLTable.PRICE * RRLTable.QUANTITY; row.Cells["AMOUNT_INCLUDED_TAX"].Value = RRLTable.PRICE * RRLTable.QUANTITY * (1 + RRTable.TAX_RATE); row.Cells["MEMO"].Value = RRLTable.MEMO; } } catch (Exception ex) { } } }
public int AddReReceipt(BllReReceiptTable rereceiptList) { return(dal.AddReReceipt(rereceiptList)); }
private void btnSave_Click(object sender, EventArgs e) { if (InputCheck()) { #region 返品 decimal taxAmount = 0; decimal AmountWithoutTax = 0; decimal AmountIncludedTax = 0; BllReReceiptTable reReceiptTable = new BllReReceiptTable(); BllReReceiptLineTable reReceiptLineTable = null; //reReceiptTable.SLIP_NUMBER = bCommon.GetSeqNumber(CConstant.SEQ_RECEIPT_RETURN); reReceiptTable.PO_SLIP_NUMBER = txtPurchaseNumber.Text; reReceiptTable.SLIP_DATE = DateTime.Now; reReceiptTable.RECEIPT_WAREHOUSE_CODE = CConstant.DEFAULT_WAREHOUSE_CODE; reReceiptTable.CURRENCY_CODE = CConstant.DEFAULT_CURRENCY_CODE; reReceiptTable.SUPPLIER_CODE = txtSupplierCode.Text.Trim(); reReceiptTable.TAX_RATE = CConvert.ToDecimal(cboTax.Text.Replace("%", "")) / 100; reReceiptTable.RERECEIPT_FLAG = CConvert.ToInt32(cboReturn.SelectedValue); reReceiptTable.STATUS_FLAG = CConstant.INIT; reReceiptTable.COMPANY_CODE = UserTable.COMPANY_CODE; reReceiptTable.CREATE_USER = UserTable.CODE; reReceiptTable.LAST_UPDATE_USER = UserTable.CODE; int i = 1; foreach (DataGridViewRow dgvr in dgvData.Rows) { reReceiptLineTable = new BllReReceiptLineTable(); //返品数量 decimal receiptQuantity = CConvert.ToDecimal(dgvr.Cells["QUANTITY"].Value); //ReReceipt_Line 表中数据 //reReceiptLineTable.SLIP_NUMBER = reReceiptTable.SLIP_NUMBER; reReceiptLineTable.LINE_NUMBER = i++; reReceiptLineTable.PRODUCT_CODE = CConvert.ToString(dgvr.Cells["PRODUCT_CODE"].Value); reReceiptLineTable.QUANTITY = receiptQuantity; reReceiptLineTable.UNIT_CODE = CConvert.ToString(dgvr.Cells["UNIT_CODE"].Value); reReceiptLineTable.PRICE = CConvert.ToDecimal(dgvr.Cells["PRICE"].Value); reReceiptTable.AddItem(reReceiptLineTable); AmountWithoutTax += CConvert.ToDecimal(reReceiptLineTable.QUANTITY * reReceiptLineTable.PRICE); taxAmount += CConvert.ToDecimal(reReceiptLineTable.QUANTITY * reReceiptLineTable.PRICE * reReceiptTable.TAX_RATE); AmountIncludedTax = AmountWithoutTax + taxAmount; } reReceiptTable.TAX_AMOUNT = taxAmount; reReceiptTable.AMOUNT_WITHOUT_TAX = AmountWithoutTax; reReceiptTable.AMOUNT_INCLUDED_TAX = AmountIncludedTax; if (reReceiptTable.Items.Count > 0) { DateTime time = DateTime.Now; if (bRerceipt.AddReReceipt(reReceiptTable) > 0) { MessageBox.Show("返品成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); setInit(); } else { MessageBox.Show("返品失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("请添加明细商品。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } #endregion } }