/// <summary>
/// 读取销售业绩表
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
public DataSet ReadSalesTarget(SalesTargetOption option)
{
string sql = " select * from view_SalesTarget where 1=1 ";
if (option.BranchId > 0)
{
sql += string.Format(" and BranchId={0}", option.BranchId);
}
if (option.SalesId > 0)
{
sql += string.Format(" and SalesId={0} ", option.SalesId);
}
if (option.DeptId > 0)
{
sql += string.Format(" and DeptId={0} ", option.DeptId);
}
if (option.StartMonth != new DateTime(1900, 1, 1))
{
sql += string.Format(" and YearMonth >= '{0}' ", option.StartMonth.ToShortDateString());
}
if (option.EndMonth != new DateTime(1900, 1, 1))
{
sql += string.Format(" and YearMonth <='{0}' ", option.EndMonth.AddDays(1).ToShortDateString());
}
sql += " order by SalesId,YearMonth ";
return(m_dbo.GetDataSet(sql));
}
/// <summary>
/// 读取逾期账款
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
public DataSet ReadOverdue(SalesTargetOption option)
{
//标准：按照月度计算
return(null);
}
