/// <summary>
/// 根据供货收货单位名称或首字母模糊查询数据
/// </summary>
/// <param name="name"></param>
/// <param name="sqlWhere">条件语句</param>
/// <returns></returns>
public List <CmcsSupplyReceive> GetSupplyReceiveByNameOrChs(string name, string sqlWhere)
{
List <CmcsSupplyReceive> res = SelfDber.Entities <CmcsSupplyReceive>(sqlWhere);
if (!string.IsNullOrEmpty(name))
{
return(res.Where(a =>
{
if (a.UnitName.ToUpper().Contains(name.ToUpper()))
{
return true;
}
if (ChsSpeller.GetFirst(a.UnitName).ToUpper().Contains(name.ToUpper()))
{
return true;
}
return false;
}).ToList());
}
else
{
return(res);
}
}
/// <summary>
/// 根据运输单位名称或首字母模糊查询数据
/// </summary>
/// <param name="name"></param>
/// <param name="sqlWhere">条件语句</param>
/// <returns></returns>
public List <CmcsTransportCompany> GetTransportCompanyByNameOrChs(string name, string sqlWhere)
{
List <CmcsTransportCompany> res = SelfDber.Entities <CmcsTransportCompany>(sqlWhere);
if (!string.IsNullOrEmpty(name))
{
return(res.Where(a =>
{
if (a.Name.ToUpper().Contains(name.ToUpper()))
{
return true;
}
if (ChsSpeller.GetFirst(a.Name).ToUpper().Contains(name.ToUpper()))
{
return true;
}
return false;
}).ToList());
}
else
{
return(res);
}
}
