CCN.Modules.Car.DataAccess.CarDataAccess.GetTotalByCarid C# (CSharp) Method

        public CustomerTotalModel GetTotalByCarid(string carid)
        {
            const string sql = "select b.refreshnum,b.topnum from car_info as a inner join cust_total_info as b on a.custid=b.custid where a.innerid=@carid;";
            try
            {
                return Helper.Query<CustomerTotalModel>(sql, new { carid }).FirstOrDefault();
            }
            catch (Exception ex)
            {
                return null;
            }
        }