public List<RestaurantAbstract> getImageRst(string id) { List<RestaurantAbstract> list = null; try { IParameterMapper ipmapper = new getRestaurantListInfoDataParameterMapper(); DataAccessor<RestaurantAbstract> tableAccessor; string strSql = @"select ro.photo from ReceiveOrder ro where ro.RstId=@SourceAccountId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<RestaurantAbstract>.MapAllProperties() .DoNotMap(t => t.Id) .DoNotMap(t => t.isAcceptOrder) .DoNotMap(t => t.MapUrl) .DoNotMap(t => t.MaxTime) //.DoNotMap(t => t.TypeId) .DoNotMap(t => t.Name) .DoNotMap(t => t.RstType) .DoNotMap(t => t.VirtualUrl) .DoNotMap(t => t.Address) .DoNotMap(t => t.BusinessEndtDate) .DoNotMap(t => t.BusinessStartDate) .DoNotMap(t => t.ContactPhone) .DoNotMap(t=>t.name) .Map(t => t.Photo).ToColumn("Photo") .Build()); list = tableAccessor.Execute(new string[] { id }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }
// public List<Restaurant> getRestaurantListInfoData(string companyid) // { // List<Restaurant> list = null; // try // { // DataAccessor<Restaurant> tableAccessor; // string strSql = @"select a.Id // ,a.Name // ,a.CompanyId // ,a.Address // ,a.ContactPhone // ,a.Description // ,a.BankId // ,a.BankAccount // ,a.OpenDate // ,a.BusinessStartDate // ,a.BusinessEndtDate // ,a.RegSN // ,a.ReserveModel // ,a.UseState // ,a.PublicKey // ,a.PrivateKey from Restaurant a where a.CompanyId='"+companyid+"'"; // tableAccessor = db.CreateSqlStringAccessor(strSql, MapBuilder<Restaurant>.MapAllProperties() // .Map(t => t.Id).ToColumn("Id") // .Map(t => t.Name).ToColumn("Name") // .Map(t => t.CompanyId).ToColumn("CompanyId") // .Map(t => t.Address).ToColumn("Address") // .Map(t => t.ContactPhone).ToColumn("ContactPhone") // .Map(t => t.Description).ToColumn("Description") // .Map(t => t.BankId).ToColumn("BankId") // .Map(t => t.BankAccount).ToColumn("BankAccount") // .Map(t => t.OpenDate).ToColumn("OpenDate") // .Map(t => t.BusinessStartDate).ToColumn("BusinessStartDate") // .Map(t => t.BusinessEndtDate).ToColumn("BusinessEndtDate") // .Map(t => t.RegSN).ToColumn("RegSN") // .Map(t => t.ReserveModel).ToColumn("ReserveModel") // .Map(t => t.UseState).ToColumn("UseState") // .Map(t => t.PublicKey).ToColumn("PublicKey") // .Map(t => t.PrivateKey).ToColumn("PrivateKey") // .Build()); // list = tableAccessor.Execute().ToList(); // return list; // } // catch (Exception ex) // { // return null; // } // } #endregion #region getImageRst public List <RestaurantAbstract> getImageRst(string id) { List <RestaurantAbstract> list = null; try { IParameterMapper ipmapper = new getRestaurantListInfoDataParameterMapper(); DataAccessor <RestaurantAbstract> tableAccessor; string strSql = @"select ro.photo from ReceiveOrder ro where ro.RstId=@SourceAccountId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <RestaurantAbstract> .MapAllProperties() .DoNotMap(t => t.Id) .DoNotMap(t => t.isAcceptOrder) .DoNotMap(t => t.MapUrl) .DoNotMap(t => t.MaxTime) //.DoNotMap(t => t.TypeId) .DoNotMap(t => t.Name) .DoNotMap(t => t.RstType) .DoNotMap(t => t.VirtualUrl) .DoNotMap(t => t.Address) .DoNotMap(t => t.BusinessEndtDate) .DoNotMap(t => t.BusinessStartDate) .DoNotMap(t => t.ContactPhone) .DoNotMap(t => t.name) .Map(t => t.Photo).ToColumn("Photo") .Build()); list = tableAccessor.Execute(new string[] { id }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }