/// <summary>
/// 查询发票
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
public DataSet ReadInvoice(InvoiceOption option)
{
string sql = " select * from view_Invoice where 1=1 ";
if (option.BranchId > 0)
{
sql += string.Format(" and BranchId={0} ", option.BranchId);
}
if (option.InvoiceContent != "")
{
sql += string.Format(" and InvoiceContent = '{0}' ", option.InvoiceContent);
}
if (option.InvoiceDateS != new DateTime(1900, 1, 1))
{
sql += string.Format(" and InvoiceDate >= '{0}' ", option.InvoiceDateS.ToShortDateString());
}
if (option.InvoiceDateE != new DateTime(1900, 1, 1))
{
sql += string.Format(" and InvoiceDate < '{0}' ", option.InvoiceDateE.AddDays(1).ToShortDateString());
}
if (option.InvoiceMemo != "")
{
sql += string.Format(" and InvoiceMemo like '%{0}%' ", option.InvoiceMemo);
}
if (option.InvoiceMoneyS > 0)
{
sql += string.Format(" and InvoiceMoney >={0} ", option.InvoiceMoneyS);
}
if (option.InvoiceMoneyE > 0)
{
sql += string.Format(" and InvoiceMoney <={0} ", option.InvoiceMoneyE);
}
if (option.InvoiceName != "")
{
sql += string.Format(" and InvoiceName like '%{0}%' ", option.InvoiceName);
}
if (option.InvoiceNo != "")
{
sql += string.Format(" and InvoiceNo like '%{0}%' ", option.InvoiceNo);
}
if (option.InvoiceRequireId > 0)
{
sql += string.Format(" and InvoiceRequierId = {0} ", option.InvoiceRequireId);
}
if (option.InvoiceType != "")
{
sql += string.Format(" and InvoiceType = '{0}' ", option.InvoiceType);
}
if (option.OrderStatementId > 0)
{
sql += string.Format(" and OrderStatementId = {0} ", option.OrderStatementId);
}
if (option.Company != "")
{
sql += string.Format(" and Company like '%{0}%' ", option.Company);
}
sql += " order by UpdateTime desc ";
return(m_dbo.GetDataSet(sql));
}
public InvoiceManager()
{
m_Option = new InvoiceOption();
m_dbo = new DBOperate();
}