C# (CSharp) crm_sales_order_dal.FindListBySql Examples

Example #1

File: SaleOrderBLL.cs Project: evelh/Done

 /// <summary>
 /// 获取员工本年的销售目标
 /// </summary>
 public List <sys_resource_sales_quota> GetResYearQuota(long resourceId, int year)
 {
     return(_dal.FindListBySql <sys_resource_sales_quota>($"SELECT * from sys_resource_sales_quota where  resource_id = {resourceId} and year = {year} and delete_time =0"));
 }