public string CheckHsCode(string hsCode, string title)
{
if (hsCode == null || "".Equals(hsCode))
{
return(title + ERROR_NULL);
}
BHsCode bHsCode = new BHsCode();
if (bHsCode.Exists(hsCode))
{
return("");
}
return(title + ERROR_EXIST);
}
//#region 包装费用
//private void btnDivPackAmount_Click(object sender, EventArgs e)
//{
// if (txtPackAmount.Text != "")
// {
// if (CConvert.ToDecimal(txtPackAmount.Text) > 0 && hashTable.Count > 0 && total_un_invoice_amount > 0)
// {
// decimal total = CConvert.ToDecimal(txtPackAmount.Text);
// decimal other = 0;
// int i = 1;
// foreach (DataGridViewRow row in dgvData.Rows)
// {
// if (i < dgvData.Rows.Count)
// {
// if (row.Cells["PO_SLIP_NUMBER"].Value != null && row.Cells["PO_SLIP_NUMBER"].Value.ToString() != "")
// {
// row.Cells["PACKAGE_AMOUNT"].Value = Math.Round((CConvert.ToDecimal(row.Cells["UN_INVOICE_AMOUNT"].Value) / total_un_invoice_amount) * total, 2);
// other += CConvert.ToDecimal(row.Cells["PACKAGE_AMOUNT"].Value);
// i++;
// }
// }
// else if (i == dgvData.Rows.Count)
// {
// if (row.Cells["PO_SLIP_NUMBER"].Value != null && row.Cells["PO_SLIP_NUMBER"].Value.ToString() != "")
// {
// row.Cells["PACKAGE_AMOUNT"].Value = total - other;
// }
// }
// }
// }
// else
// {
// MessageBox.Show("包装费用不能小于0!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// }
// }
// else
// {
// MessageBox.Show("包装费用不能为空!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
// }
//}
//#endregion
#region dgvData单元格验证
private void dgvData_CellValidated(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow dr = dgvData.Rows[e.RowIndex];
string suppliercode = CConvert.ToString(dr.Cells["SUPPLIER_CODE"].Value);
if (!string.IsNullOrEmpty(suppliercode))
{
if (e.ColumnIndex == dgvData.Columns["AMOUNT"].Index)
{
if (CConvert.ToDecimal(dr.Cells["AMOUNT"].Value) > CConvert.ToDecimal(dr.Cells["AMOUNT_INCLUDED_TAX"].Value))
{
MessageBox.Show("开票金额不能大于金额!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dr.Cells["AMOUNT"].Value = "";
dr.Cells["AMOUNT"].Selected = true;
}
if (new BSupplier().GetModel(suppliercode).TYPE == 1)
{
string productcode = CConvert.ToString(dr.Cells["PRODUCT_CODE"].Value);
if (!string.IsNullOrEmpty(productcode))
{
string hscode = new BProduct().GetModel(productcode).HS_CODE;
decimal exch = 0;
DateTime date = CConvert.ToDateTime(txtPurchaseDate.Value.Year + "/" + txtPurchaseDate.Value.Month + "/" + 1);
try
{
exch = new BExchange().GetModel(date, dr.Cells["CURRENCY_CODE"].Value.ToString()).EXCHANGE_RATE;
}
catch { exch = 1; }
if (!string.IsNullOrEmpty(hscode))
{
decimal tax = new BHsCode().GetModel(hscode).TAX_RATE;
dr.Cells["TAX_AMOUNT"].Value = CConvert.ToDecimal(dr.Cells["AMOUNT"].Value) * (tax / 100) * (exch / 100);
}
else
{
dr.Cells["TAX_AMOUNT"].Value = 0;
}
}
else
{
dr.Cells["TAX_AMOUNT"].Value = 0;
}
}
}
}
}
private void txtHsCode_Leave(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.txtHsCode.Text.Trim()))
{
BaseHsCodeTable HsCode = new BaseHsCodeTable();
BHsCode bHsCode = new BHsCode();
HsCode = bHsCode.GetModel(this.txtHsCode.Text);
if (HsCode == null || "".Equals(HsCode))
{
txtHsCode.Focus();
txtHsCode.Text = "";
txtHsName.Text = "";
MessageBox.Show("海关编号不存在，请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
txtHsName.Text = HsCode.HS_NAME;
}
}
}
