/// <summary>
/// 增加一条收款数据
/// </summary>
public int AddBllReceiptMatch(BllReceiptMatchTable model)
{
int maxSlipNumber = CConvert.ToInt32(GetReceiptMatchMaxSlipNumber(model.COMPANY_CODE));
model.SLIP_NUMBER = model.COMPANY_CODE + "-" + CConvert.ToString(++maxSlipNumber).PadLeft(4, '0');
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BLL_RECEIPT_MATCH(");
strSql.Append("SLIP_NUMBER,SLIP_DATE,SALES_SLIP_NUMBER,SALES_LINE_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,@SALES_SLIP_NUMBER,@SALES_LINE_NUMBER,@TOTAL_AMOUNT,@DEPOSIT_AMOUNT,@OTHER_AMOUNT,@STATUS_FLAG,@CREATE_USER,@CREATE_DATE_TIME,@LAST_UPDATE_TIME,@LAST_UPDATE_USER,@COMPANY_CODE)");
SqlParameter[] parameters =
{
new SqlParameter("@SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@SLIP_DATE", SqlDbType.DateTime),
new SqlParameter("@SALES_SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@SALES_LINE_NUMBER", SqlDbType.Int, 4),
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("@CREATE_DATE_TIME", SqlDbType.DateTime),
new SqlParameter("@LAST_UPDATE_TIME", SqlDbType.DateTime),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.SLIP_NUMBER;
parameters[1].Value = model.SLIP_DATE;
parameters[2].Value = model.SALES_SLIP_NUMBER;
parameters[3].Value = model.SALES_LINE_NUMBER;
parameters[4].Value = model.TOTAL_AMOUNT;
parameters[5].Value = model.DEPOSIT_AMOUNT;
parameters[6].Value = model.OTHER_AMOUNT;
parameters[7].Value = model.STATUS_FLAG;
parameters[8].Value = model.CREATE_USER;
parameters[9].Value = model.CREATE_DATE_TIME;
parameters[10].Value = model.LAST_UPDATE_TIME;
parameters[11].Value = model.LAST_UPDATE_USER;
parameters[12].Value = model.COMPANY_CODE;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
private void btnSave_Click(object sender, EventArgs e)
{
int result = 0;
// 保存成功件数
int successCount = 0;
// 保存失败件数
int erroeCount = 0;
//信息保存
foreach (DataGridViewRow dgvr in dgvData.Rows)
{
// 预付款金额
decimal depositAmount = CConvert.ToDecimal(CConvert.ToString(dgvr.Cells["DEPOSIT_AMOUNT"].Value));
//其他金额
decimal otherAmount = CConvert.ToDecimal(CConvert.ToString(dgvr.Cells["OTHER_AMOUNT"].Value));
//收款总金额
decimal totalAmount = depositAmount + otherAmount;
if (totalAmount == 0)
{
continue;
}
BllReceiptMatchTable bllReceiptMatchTable = new BllReceiptMatchTable();
//收款单据内部编号
//后台更新
//bllReceiptMatchTable.SLIP_NUMBER = 0;
//收款时间
bllReceiptMatchTable.SLIP_DATE = CConvert.ToDateTime(dgvr.Cells["SLIP_DATE"].Value);
//销售内部编号
bllReceiptMatchTable.SALES_SLIP_NUMBER = CConvert.ToString(dgvr.Cells["SALES_SLIP_NUMBER"].Value);
//销售内部明细编号（暂不使用，默认更新为：1）
bllReceiptMatchTable.SALES_LINE_NUMBER = 1;
//合计收款金额
bllReceiptMatchTable.TOTAL_AMOUNT = totalAmount;
//预付款金额
bllReceiptMatchTable.DEPOSIT_AMOUNT = depositAmount;
//其他金额
bllReceiptMatchTable.OTHER_AMOUNT = otherAmount;
//状态
bllReceiptMatchTable.STATUS_FLAG = CConstant.INIT;
// 公司
bllReceiptMatchTable.COMPANY_CODE = UserTable.COMPANY_CODE;
try
{
result = bSales.AddBllReceiptMatch(bllReceiptMatchTable);
if (result <= 0)
{
erroeCount = erroeCount + 1;
}
else
{
successCount = successCount + 1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Logger.Error("收款金额输入保存失败!!!!!", ex);
}
}
//
if (successCount == 0 && erroeCount == 0)
{
MessageBox.Show("请输入收款金额。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
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();
}
else if (successCount == 0 && erroeCount > 0)
{
MessageBox.Show("收款保存失败！请与系统管理员联系！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
initPage();
}
}
/// <summary>
/// 增加一条收款数据
/// </summary>
public int AddBllReceiptMatch(BllReceiptMatchTable model)
{
return(dal.AddBllReceiptMatch(model));
}
