/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BllDepositTable depositTable)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BLL_DEPOSIT(");
strSql.Append("SLIP_NUMBER,SLIP_DATE,SLIP_TYPE,CUSTOMER_CLAIM_CODE,AMOUNT,MEMO,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_TIME,LAST_UPDATE_USER,COMPANY_CODE)");
strSql.Append(" values (");
strSql.Append("@SLIP_NUMBER,@SLIP_DATE,@SLIP_TYPE,@CUSTOMER_CLAIM_CODE,@AMOUNT,@MEMO,@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("@SLIP_TYPE", SqlDbType.Int, 4),
new SqlParameter("@CUSTOMER_CLAIM_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@AMOUNT", SqlDbType.Decimal, 9),
new SqlParameter("@MEMO", SqlDbType.NVarChar, 255),
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 = depositTable.SLIP_NUMBER;
parameters[1].Value = depositTable.SLIP_DATE;
parameters[2].Value = depositTable.SLIP_TYPE;
parameters[3].Value = depositTable.CUSTOMER_CLAIM_CODE;
parameters[4].Value = depositTable.AMOUNT;
parameters[5].Value = depositTable.MEMO;
parameters[6].Value = depositTable.STATUS_FLAG;
parameters[7].Value = depositTable.CREATE_USER;
parameters[8].Value = depositTable.LAST_UPDATE_USER;
parameters[9].Value = depositTable.COMPANY_CODE;
int i = 0;
while (true)
{
try
{
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
catch (Exception ex)
{
i++;
if (i > 10)
{
throw ex;
}
parameters[0].Value = CConvert.ToInt32(GetMaxID()) + 1;
}
}
}
/// <summary>
/// 输入保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
BllDepositTable depositTable = new BllDepositTable();
depositTable.SLIP_NUMBER = this.txtSlipNumber.Text;
depositTable.SLIP_DATE = this.txtSlipDate.Value;
depositTable.CUSTOMER_CLAIM_CODE = this.txtCustomerCode.Text;
depositTable.COMPANY_CODE = UserTable.COMPANY_CODE;
depositTable.MEMO = this.txtMemo.Text;
depositTable.STATUS_FLAG = CConstant.NORMAL_STATUS;
depositTable.CREATE_USER = UserTable.CODE;
depositTable.LAST_UPDATE_USER = UserTable.CODE;
if (rdoDeposit.Checked)
{
depositTable.AMOUNT = CConvert.ToDecimal(this.txtAmount.Text);
depositTable.SLIP_TYPE = CConstant.DEPOSIT;
}
else
{
depositTable.AMOUNT = -CConvert.ToDecimal(this.txtAmount.Text);
depositTable.SLIP_TYPE = CConstant.RE_DEPOSIT;
}
try
{
if (bDeposit.Add(depositTable) > 0)
{
MessageBox.Show("保存成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
InitPage();
}
else
{
MessageBox.Show("保存失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("保存失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Logger.Error("预收款输入保存失败。", ex);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BllDepositTable depositTable)
{
return(dal.Add(depositTable));
}
