/// <summary>
/// 增加一条数据
/// </summary>
public void Add(RegPaymentInvoice model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RegPaymentInvoice(");
strSql.Append("regID,invoiceID,invoiceNum,remark");
strSql.Append(") values (");
strSql.Append("@regID,@invoiceID,@invoiceNum,@remark");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@regID", SqlDbType.VarChar, 50),
//new SqlParameter("@regID", SqlDbType.VarChar,50) ,
new SqlParameter("@invoiceID", SqlDbType.Int, 4),
new SqlParameter("@invoiceNum", SqlDbType.VarChar, 50),
new SqlParameter("@remark", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.id;
//parameters[1].Value = model.regID;
parameters[1].Value = model.invoiceID;
parameters[2].Value = model.invoiceNum;
parameters[3].Value = model.remark;
DBHelper.ExecuteCommand(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(RegPaymentInvoice model)
{
dal.Add(model);
}