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
}
}
