/// <summary>
/// 获取所有票据
/// </summary>
/// <returns></returns>
public IList <CostReportInvoiceInfo> GetAllInvoiceList()
{
IList <CostReportInvoiceInfo> list = new List <CostReportInvoiceInfo>();
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_GET_INVOICE, null))
{
while (dr.Read())
{
var info = new CostReportInvoiceInfo(dr.GetGuid(0), dr.GetString(1), dr.GetInt32(2), dr[3] == DBNull.Value ? 0 : dr.GetDecimal(3), dr[4] == DBNull.Value ? "" : dr.GetString(4));
list.Add(info);
}
}
return(list);
}
/// <summary>
/// 添加票据
/// </summary>
/// <param name="info">票据模型</param>
public void InsertInvoice(CostReportInvoiceInfo info)
{
SqlParameter[] parms = GetParameter();
parms[0].Value = info.InvoiceId;
parms[1].Value = info.ImagePath;
parms[2].Value = info.State;
parms[3].Value = info.RealityCost;
parms[4].Value = info.Memo;
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT_INVOICE, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>
/// 修改票据状态
/// </summary>
/// <param name="info">票据模型</param>
public void UpdateInvoiceState(CostReportInvoiceInfo info)
{
var parms = new[] {
new SqlParameter(PARM_INVOICE_ID, SqlDbType.UniqueIdentifier),
new SqlParameter(PARM_STATE, SqlDbType.Int)
};
parms[0].Value = info.InvoiceId;
parms[1].Value = info.State;
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_INVOICE_STATE, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>
/// 修改票据
/// </summary>
/// <param name="info">票据模型</param>
public void UpdateInvoice(CostReportInvoiceInfo info)
{
var parms = new[] {
new SqlParameter("@InvoiceId", info.InvoiceId),
new SqlParameter("@ImagePath", info.ImagePath),
new SqlParameter("@State", info.State),
new SqlParameter("@RealityCost", info.RealityCost),
new SqlParameter("@Memo", info.Memo)
};
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_INVOICE, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>
/// 根据票据ID获取待审核票据
/// </summary>
/// <param name="invoiceId">票据ID</param>
/// <returns></returns>
public CostReportInvoiceInfo GetInvoice(Guid invoiceId)
{
var info = new CostReportInvoiceInfo();
var sql = new StringBuilder(SQL_GET_INVOICE);
sql.Append(" WHERE InvoiceId=@InvoiceId");
var parm = new SqlParameter(PARM_INVOICE_ID, SqlDbType.UniqueIdentifier)
{
Value = invoiceId
};
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql.ToString(), parm))
{
if (dr.Read())
{
info = new CostReportInvoiceInfo(dr.GetGuid(0), dr.GetString(1), dr.GetInt32(2), dr[3] == DBNull.Value ? 0 : dr.GetDecimal(3), dr[4] == DBNull.Value ? "" : dr.GetString(4));
}
}
return(info);
}
/// <summary>
/// 获取待审核票据
/// </summary>
/// <returns></returns>
public IList <CostReportInvoiceInfo> GetInvoiceList()
{
IList <CostReportInvoiceInfo> list = new List <CostReportInvoiceInfo>();
var sql = new StringBuilder(SQL_GET_INVOICE);
sql.Append(" WHERE State=@State");
var parm = new SqlParameter(PARM_STATE, SqlDbType.Int)
{
Value = (int)CostReportInvoiceState.NoAuditing
};
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql.ToString(), parm))
{
while (dr.Read())
{
var info = new CostReportInvoiceInfo(dr.GetGuid(0), dr.GetString(1), dr.GetInt32(2), dr[3] == DBNull.Value ? 0 : dr.GetDecimal(3), dr[4] == DBNull.Value ? "" : dr.GetString(4));
list.Add(info);
}
}
return(list);
}
