/// <summary>
/// 平台费用
/// </summary>
/// <param name="PlatformTypeId">平台Id</param>
/// <param name="YearStr">年份</param>
/// <param name="MonthStr">月份</param>
/// <returns></returns>
public List <CWPlatformSpending> GetCWPlatformSpendingSearchList(int PlatformTypeId, string YearStr, string MonthStr)
{
//月份集合
List <string> MonthStrList = new List <string>();
if (MonthStr != "")
{
if (MonthStr.IndexOf(",") > -1)
{
string[] OrderCodestr = MonthStr.Split(',');
MonthStrList = new List <string>(OrderCodestr);
}
else if (MonthStr.IndexOf("，") > -1)
{
string[] OrderCodestr = MonthStr.Split('，');
MonthStrList = new List <string>(OrderCodestr);
}
else
{
MonthStrList.Add(MonthStr);
}
}
var query = from p in this._context.CWPlatformSpendings
where (PlatformTypeId == -1 || p.PlatformTypeId == PlatformTypeId) &&
p.YearStr.Equals(YearStr) &&
MonthStrList.Contains(p.MonthStr) &&
p.IsEnable == false
select p;
return(query.ToList());
}
/// <summary>
/// 根据条件查询 人员开支费用
/// </summary>
/// <param name="ProfitProjectId">利润项目Id</param>
/// <param name="NickProjectId">店铺项目Id</param>
/// <param name="YearStr">年份</param>
/// <param name="MonthStr">月份</param>
/// <returns></returns>
public List <CWStaffSpending> GetCWStaffSpendingList(int ProjectId, int NickId, string YearStr, string MonthStr)
{
//月份集合
List <string> MonthStrList = new List <string>();
if (MonthStr != "")
{
if (MonthStr.IndexOf(",") > -1)
{
string[] OrderCodestr = MonthStr.Split(',');
MonthStrList = new List <string>(OrderCodestr);
}
else if (MonthStr.IndexOf("，") > -1)
{
string[] OrderCodestr = MonthStr.Split('，');
MonthStrList = new List <string>(OrderCodestr);
}
else
{
MonthStrList.Add(MonthStr);
}
}
var query = from p in this._context.CWStaffSpendings
where (ProjectId == -1 || p.ProjectId == ProjectId) &&
(NickId == -1 || p.NickId == NickId) &&
p.YearStr.Equals(YearStr) &&
MonthStrList.Contains(p.MonthStr) &&
p.IsEnable == false
orderby p.FinancialFieldId
select p;
return(query.ToList());
}
