/// <summary> /// 修改一条发票内容 /// </summary> /// <param name="configInvoiceContent"> /// 需修改的发票内容 /// </param> public void Modify(Config_Invoice_Content configInvoiceContent) { this.configInvoiceContentDA.Update(configInvoiceContent); }
/// <summary> /// 新增一条发票内容 /// </summary> /// <param name="invoiceContent"> /// 要新增的发票内容 /// </param> /// <returns> /// 新增的Id /// </returns> /// <exception cref="Exception"> /// </exception> public int Insert(Config_Invoice_Content invoiceContent) { var parameters = new List<SqlParameter>() { this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, invoiceContent.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Description", SqlDbType.NVarChar, invoiceContent.Description, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, DateTime.Now, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; try { this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Config_Invoice_Content_Insert", parameters, null); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; } catch (Exception exception) { throw new Exception("Exception - ConfigInvoiceContentDA - Insert", exception); } }
/// <summary> /// 新增发票内容 /// </summary> /// <param name="invoiceContent"> /// 需新增的发票内容 /// </param> /// <returns> /// 新增的ID /// </returns> public int Add(Config_Invoice_Content invoiceContent) { return configInvoiceContentDA.Insert(invoiceContent); }
/// <summary> /// 更新发票内容 /// </summary> /// <param name="invoiceContent"> /// 要更新的发票内容 /// </param> /// <exception cref="Exception"> /// </exception> public void Update(Config_Invoice_Content invoiceContent) { var paraList = new List<SqlParameter>() { this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, invoiceContent.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Description", SqlDbType.NVarChar, invoiceContent.Description, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, DateTime.Now, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ID", SqlDbType.Int, invoiceContent.ID, ParameterDirection.Input) }; try { this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Config_Invoice_Content_Update", paraList, null); } catch (Exception exception) { throw new Exception("Exception - ConfigInvoiceContentDA - Update", exception); } }