//Grid数据源
protected void GridDataBind()
{
var erpFilialeId = ConfigManage.GetConfigValue("RECKONING_ELSE_FILIALEID");
//未付款：待审核，已审核，未通过，已执行； 已付款：完成打款；
//已审核过的单据(排除ERP公司的单据)
var list = _companyFundReceipt.GetAllCompanyFundReceiptList().Where(p => (new int?[] { (int)CompanyFundReceiptState.NoAuditing, (int)CompanyFundReceiptState.Audited, (int)CompanyFundReceiptState.Executed, (int)CompanyFundReceiptState.Finish }).Contains(p.ReceiptStatus) && p.ReceiptType.Equals(1) && !p.FilialeId.ToString().Contains(erpFilialeId.ToLower())).OrderBy(p => p.ApplyDateTime).AsQueryable();
#region 查询条件
if (!string.IsNullOrEmpty(ddl_SaleFiliale.SelectedValue))
{
list = list.Where(p => p.FilialeId.Equals(new Guid(ddl_SaleFiliale.SelectedValue)));
}
if (!string.IsNullOrEmpty(rcb_CompanyList.SelectedValue))
{
list = list.Where(p => p.CompanyID.Equals(new Guid(rcb_CompanyList.SelectedValue)));
}
if (!string.IsNullOrEmpty(txt_ApplyDateTimeStart.Text))
{
var startTime = DateTime.Parse(txt_ApplyDateTimeStart.Text);
list = list.Where(p => p.ApplyDateTime >= startTime);
}
if (!string.IsNullOrEmpty(txt_ApplyDateTimeEnd.Text))
{
var endtime = DateTime.Parse(txt_ApplyDateTimeEnd.Text);
list = list.Where(p => p.ApplyDateTime < endtime.AddDays(1));
}
if (!string.IsNullOrEmpty(txt_ReceipNo.Text))
{
list = list.Where(p => p.ReceiptNo.Equals(txt_ReceipNo.Text));
}
if (!string.IsNullOrEmpty(ddl_ReceiptStatus.SelectedValue))
{
list = list.Where(p => p.ReceiptStatus.Equals(int.Parse(ddl_ReceiptStatus.SelectedValue)));
}
if (!string.IsNullOrEmpty(dll_InvoiceType.SelectedValue))
{
list = list.Where(p => p.InvoiceType.Equals(int.Parse(dll_InvoiceType.SelectedValue)));
if (!String.IsNullOrWhiteSpace(txtBillingUnit.Text))
{
var invoiceId = _companyFundReceiptInvoice.GetAlllmshop_CompanyFundReceiptInvoice()
.Where(ent => ent.BillingUnit.Contains(txtBillingUnit.Text)).Select(ent => ent.ReceiptID);
list = list.Where(ent => invoiceId.Contains(ent.ReceiptID));
}
}
#endregion
RG_ReceiptInvoice.DataSource = list.OrderByDescending(p => p.ApplyDateTime);
}
/// <summary>
/// 返回lmshop_CompanyFundReceiptInvoice表的所有数据
/// </summary>
/// <returns></returns>
public List <CompanyFundReceiptInvoiceInfo> GetAlllmshop_CompanyFundReceiptInvoice()
{
return(_companyFundReceiptInvoiceDao.GetAlllmshop_CompanyFundReceiptInvoice());
}