/// <summary>
/// 更新一条发票类型
/// </summary>
/// <param name="configInvoiceType">
/// 需更新的发票类型
/// </param>
public void Modify(Config_Invoice_Type configInvoiceType)
{
this.configInvoiceTypeDA.Update(configInvoiceType);
}
/// <summary>
/// 新增一条发票类别
/// </summary>
/// <param name="invoiceType">
/// 新增的类别
/// </param>
/// <returns>
/// 增加的Id
/// </returns>
/// <exception cref="Exception">
/// </exception>
public int Insert(Config_Invoice_Type invoiceType)
{
var paraList = new List<SqlParameter>()
{
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
invoiceType.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
invoiceType.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_Type_Insert",
paraList,
null);
return (int)paraList.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
catch (Exception exception)
{
throw new Exception("Exception - ConfigInvoiceTypeDA - Insert", exception);
}
}
/// <summary>
/// 增加一条发票类型记录
/// </summary>
/// <param name="invoiceType">
/// 增加的发票类型
/// </param>
/// <returns>
/// 增加的对象的Id
/// </returns>
public int Add(Config_Invoice_Type invoiceType)
{
return configInvoiceTypeDA.Insert(invoiceType);
}
/// <summary>
/// 更新发票类别
/// </summary>
/// <param name="invoiceType">
/// 要更新的发票类别
/// </param>
/// <exception cref="Exception">
/// </exception>
public void Update(Config_Invoice_Type invoiceType)
{
var paraList = new List<SqlParameter>()
{
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
invoiceType.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Description",
SqlDbType.NVarChar,
invoiceType.Description,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
DateTime.Now,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
invoiceType.ID,
ParameterDirection.Input)
};
try
{
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Config_Invoice_Type_Update",
paraList,
null);
}
catch (Exception exception)
{
throw new Exception("Exception - ConfigInvoiceTypeDA - Update", exception);
}
}
