/// <summary> /// 增加一条数据 /// </summary> public int Add(BllSupplierDepositTable depositTable) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BLL_SUPPLIER_DEPOSIT("); strSql.Append("SLIP_NUMBER,SLIP_DATE,SLIP_TYPE,SUPPLIER_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,@SUPPLIER_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("@SUPPLIER_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.SUPPLIER_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; } BllSupplierDepositTable depositTable = new BllSupplierDepositTable(); depositTable.SLIP_NUMBER = this.txtSlipNumber.Text; depositTable.SLIP_DATE = this.txtSlipDate.Value; depositTable.SUPPLIER_CODE = this.txtSupplierCode.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(BllSupplierDepositTable depositTable) { return(dal.Add(depositTable)); }