public List<RestaurantAbstract> getRestaurentState(string CompanyId) { try { IParameterMapper ipmapper = new getRestaurentStateParameterMapper(); DataAccessor<RestaurantAbstract> tableAccessor; string strSql = @" select rst.Id,rst.Name,rst.ContactPhone,rst.Address,rst.BusinessStartDate, rst.BusinessEndtDate,rst.RstType,ro.MapUrl,ro.VirtualUrl, null as Photo ,p.Name, isnull(ro.MaxTime,0) as MaxTime ,case when (ro.Reven=1 or ro.Rnoon=1) then 1 else 0 end as isAcceptOrder from Restaurant rst left join ReceiveOrder ro on rst.Id=ro.RstId ,Province p where rst.CompanyId=@CompanyId and rst.usestate='01' and rst.CityId=p.Id and p.IsUse='1'"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper,MapBuilder<RestaurantAbstract>.MapAllProperties() .Build()); return tableAccessor.Execute(new string[] { CompanyId }).ToList(); ; } catch (Exception ex) { Logger.Log(ex); return null; } }
public List <RestaurantAbstract> getRestaurentState(string CompanyId) { try { IParameterMapper ipmapper = new getRestaurentStateParameterMapper(); DataAccessor <RestaurantAbstract> tableAccessor; string strSql = @" select rst.Id,rst.Name,rst.ContactPhone,rst.Address,rst.BusinessStartDate, rst.BusinessEndtDate,rst.RstType,ro.MapUrl,ro.VirtualUrl, null as Photo ,p.Name, isnull(ro.MaxTime,0) as MaxTime ,case when (ro.Reven=1 or ro.Rnoon=1) then 1 else 0 end as isAcceptOrder from Restaurant rst left join ReceiveOrder ro on rst.Id=ro.RstId ,Province p where rst.CompanyId=@CompanyId and rst.usestate='01' and rst.CityId=p.Id and p.IsUse='1'"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <RestaurantAbstract> .MapAllProperties() .Build()); return(tableAccessor.Execute(new string[] { CompanyId }).ToList());; } catch (Exception ex) { Logger.Log(ex); return(null); } }