public Result Get(string spName, string extractType, DateTime dateStart, DateTime dateEnd) { var con = new DapperConnectionManager(); var query = new QueryEntity { Query = spName, Entity = new { ExtractType = extractType, DateStart = dateStart.Date.ToString("yyyyMMdd"), DateEnd = dateEnd.Date.ToString("yyyyMMdd") } }; return(con.ExecuteStoredProcedure(query)); }