public int AddpaymentMatch(BllPaymentMatchTable payment)
{
int maxSlipNumber = CConvert.ToInt32(GetPaymentMatchMaxSlipNumber(payment.COMPANY_CODE));
payment.SLIP_NUMBER = payment.COMPANY_CODE + "-" + CConvert.ToString(++maxSlipNumber).PadLeft(4, '0');
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BLL_PAYMENT_MATCH(");
strSql.Append("SLIP_NUMBER,SLIP_DATE,PURCHASE_SLIP_NUMBER,TOTAL_AMOUNT,DEPOSIT_AMOUNT,OTHER_AMOUNT,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_TIME,LAST_UPDATE_USER, COMPANY_CODE)");
strSql.Append(" values (");
strSql.Append("@SLIP_NUMBER,@SLIP_DATE,@PURCHASE_SLIP_NUMBER,@TOTAL_AMOUNT,@DEPOSIT_AMOUNT,@OTHER_AMOUNT,@STATUS_FLAG,@CREATE_USER,GETDATE(),GETDATE(),@LAST_UPDATE_USER, @COMPANY_CODE)");
SqlParameter[] parameters =
{
new SqlParameter("@SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@SLIP_DATE", SqlDbType.DateTime),
new SqlParameter("@PURCHASE_SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@TOTAL_AMOUNT", SqlDbType.Decimal, 9),
new SqlParameter("@DEPOSIT_AMOUNT", SqlDbType.Decimal, 9),
new SqlParameter("@OTHER_AMOUNT", SqlDbType.Decimal, 9),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 20)
};
parameters[0].Value = payment.SLIP_NUMBER;
parameters[1].Value = payment.SLIP_DATE;
parameters[2].Value = payment.PURCHASE_SLIP_NUMBER;
parameters[3].Value = payment.TOTAL_AMOUNT;
parameters[4].Value = payment.DEPOSIT_AMOUNT;
parameters[5].Value = payment.OTHER_AMOUNT;
parameters[6].Value = payment.STATUS_FLAG;
parameters[7].Value = payment.CREATE_USER;
parameters[8].Value = payment.LAST_UPDATE_USER;
parameters[9].Value = payment.COMPANY_CODE;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (saveCheck())
{
int result = 0;
// 保存成功件数
int successCount = 0;
// 保存失败件数
int erroeCount = 0;
BllPaymentMatchTable payment = null;
foreach (DataGridViewRow row in dgvData.Rows)
{
// 预付款金额
decimal depositAmount = CConvert.ToDecimal(CConvert.ToString(row.Cells["DEPOSIT_AMOUNT"].Value));
//其他金额
decimal otherAmount = CConvert.ToDecimal(CConvert.ToString(row.Cells["OTHER_AMOUNT"].Value));
//收款总金额
decimal totalAmount = depositAmount + otherAmount;
payment = new BllPaymentMatchTable();
payment.SLIP_DATE = CConvert.ToDateTime(row.Cells["SLIP_DATE"].Value);
payment.PURCHASE_SLIP_NUMBER = CConvert.ToString(row.Cells["SLIP_NUMBER"].Value);
payment.TOTAL_AMOUNT = totalAmount;
payment.DEPOSIT_AMOUNT = depositAmount;
payment.OTHER_AMOUNT = otherAmount;
payment.COMPANY_CODE = _userInfo.COMPANY_CODE;
payment.STATUS_FLAG = CConstant.INIT;
payment.CREATE_USER = _userInfo.CODE;
payment.CREATE_DATE_TIME = DateTime.Now;
payment.LAST_UPDATE_USER = _userInfo.CODE;
payment.LAST_UPDATE_TIME = DateTime.Now;
try
{
result = bPayemntMatch.AddpaymentMatch(payment);
if (result > 0)
{
successCount = successCount + 1;
}
else
{
erroeCount = erroeCount + 1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error("收款金额输入保存失败!!!!!", ex);
}
}
if (successCount > 0 && erroeCount == 0)
{
MessageBox.Show("付款输入保存成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
initPage();
}
else if (successCount > 0 && erroeCount > 0)
{
MessageBox.Show("付款保存部分失败！请与系统管理员联系！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
initPage();
}
else if (successCount == 0 && erroeCount > 0)
{
MessageBox.Show("付款保存失败！请与系统管理员联系！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
initPage();
}
}
}
public int AddpaymentMatch(BllPaymentMatchTable payment)
{
return(dal.AddpaymentMatch(payment));
}
