public List <CustomerTransactionEntity> GetList(Pagination pagination, string keyword, DateTime?beginTime, DateTime?endTime, bool?tranStatus)
{
var expression = ExtLinq.True <CustomerTransactionEntity>();
//非管理员只可查看自己的客户
var loginInfo = OperatorProvider.Provider.GetCurrent();
if (!"admin".Equals(loginInfo.UserCode))
{
expression = expression.And(t => t.SalesmanCode.Contains(loginInfo.UserCode));
}
if (beginTime != null)
{
expression = expression.And(t => t.BillDate >= beginTime);
}
if (endTime != null)
{
DateTime?e = endTime.Value.AddDays(1);
expression = expression.And(t => t.BillDate < endTime);
}
if (tranStatus != null)
{
expression = expression.And(t => t.TradStatus == tranStatus);
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.CustomerName.Contains(keyword));
expression = expression.Or(t => t.Salesman.Contains(keyword));
}
return(service.FindList(expression, pagination));
}
public List <CustomerEntity> GetList(Pagination pagination, string keyword, bool?tranStatus)
{
var lst = tranService.FindList("select * from Buz_CustomerTransaction");
string customerids = string.Empty;
foreach (var item in lst)
{
if (!customerids.Contains(item.CustomerId))
{
customerids += item.CustomerId + ",";
}
}
var expression = ExtLinq.True <CustomerEntity>();
//非管理员只可查看自己的客户
var loginInfo = OperatorProvider.Provider.GetCurrent();
if (!"admin".Equals(loginInfo.UserCode))
{
expression = expression.And(t => t.SalesmanCode.Contains(loginInfo.UserCode));
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.Name.Contains(keyword));
expression = expression.Or(t => t.Telphone.Contains(keyword));
expression = expression.Or(t => t.Address.Contains(keyword));
}
if (tranStatus != null)
{
if (tranStatus == true)
{
expression = expression.And(t => customerids.Contains(t.Id));
}
else
{
expression = expression.And(t => !customerids.Contains(t.Id));
}
}
return(service.FindList(expression, pagination));
}