public List <ProductMenuType> getProductMenuType(string RstId) { List <ProductMenuType> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor <ProductMenuType> tableAccessor; string strSql = @"select p.CompanyId,p.IsServiceType,p.OrderNo,p.ParentType,p.PrintId,p.TypeId,p.TypeName from ProductMenuType p where IsServiceType='0' order by p.OrderNo "; // tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ProductMenuType>.MapAllProperties() tableAccessor = db.CreateSqlStringAccessor(strSql, MapBuilder <ProductMenuType> .MapAllProperties() .Map(t => t.CompanyId).ToColumn("CompanyId") .Map(t => t.IsServiceType).ToColumn("IsServiceType") .Map(t => t.OrderNo).ToColumn("OrderNo") .Map(t => t.ParentType).ToColumn("ParentType") .Map(t => t.PrintId).ToColumn("PrintId") .Map(t => t.TypeId).ToColumn("TypeId") .Map(t => t.TypeName).ToColumn("TypeName") .Build()); // list = tableAccessor.Execute(new string[] { RstId }).ToList(); list = tableAccessor.Execute().ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List<SelTableCount> SelTableInfo(string RstId) { List<SelTableCount> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor<SelTableCount> tableAccessor; string strSql = @"select s.RstId, (s.TableCount*s.MaxTime*(cast(s.Rnoon as int)+cast(s.Reven as int))-(select SUM(isnull(o.TableCount,0)) from Orders o left join OrderStatus os on os.OrderId = o.Id where (os.OrderStatus='Paid' or os.OrderStatus='Confirmed') and o.RstId=s.RstId)) as total from ReceiveOrder s where s.RstId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql,ipmapper, MapBuilder<SelTableCount>.MapAllProperties() .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.total).ToColumn("total") //.Map(t => t.MaxTime).ToColumn("MaxTime") //.Map(t => t.Reven).ToColumn("Reven") //.Map(t => t.Rnoon).ToColumn("Rnoon") //.Map(t => t.Status).ToColumn("Status") //.Map(t => t.TableCount).ToColumn("TableCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }
public List<SelTableInfo> getTableInfo(string RstId) { List<SelTableInfo> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor<SelTableInfo> tableAccessor; string strSql = @"exec TableConfing @RstId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<SelTableInfo>.MapAllProperties() .Map(t => t.RstName).ToColumn("RstName") .Map(t => t.Times).ToColumn("Times") .Map(t => t.Counts).ToColumn("Counts") .Map(t => t.DiningDate).ToColumn("DiningDate") //.Map(t => t.Rnoon).ToColumn("Rnoon") //.Map(t => t.Status).ToColumn("Status") //.Map(t => t.TableCount).ToColumn("TableCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }
public List<ProductMenuType> getProductMenuType(string RstId) { List<ProductMenuType> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor<ProductMenuType> tableAccessor; string strSql = @"select p.CompanyId,p.IsServiceType,p.OrderNo,p.ParentType,p.PrintId,p.TypeId,p.TypeName from ProductMenuType p where IsServiceType='0' order by p.OrderNo "; // tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ProductMenuType>.MapAllProperties() tableAccessor = db.CreateSqlStringAccessor(strSql, MapBuilder<ProductMenuType>.MapAllProperties() .Map(t => t.CompanyId).ToColumn("CompanyId") .Map(t => t.IsServiceType).ToColumn("IsServiceType") .Map(t => t.OrderNo).ToColumn("OrderNo") .Map(t => t.ParentType).ToColumn("ParentType") .Map(t => t.PrintId).ToColumn("PrintId") .Map(t => t.TypeId).ToColumn("TypeId") .Map(t => t.TypeName).ToColumn("TypeName") .Build()); // list = tableAccessor.Execute(new string[] { RstId }).ToList(); list = tableAccessor.Execute().ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }
public List <SelTableInfo> getTableInfo(string RstId) { List <SelTableInfo> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor <SelTableInfo> tableAccessor; string strSql = @"exec TableConfing @RstId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <SelTableInfo> .MapAllProperties() .Map(t => t.RstName).ToColumn("RstName") .Map(t => t.Times).ToColumn("Times") .Map(t => t.Counts).ToColumn("Counts") .Map(t => t.DiningDate).ToColumn("DiningDate") //.Map(t => t.Rnoon).ToColumn("Rnoon") //.Map(t => t.Status).ToColumn("Status") //.Map(t => t.TableCount).ToColumn("TableCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List <SelTableCount> SelTableInfo(string RstId) { List <SelTableCount> list = null; try { IParameterMapper ipmapper = new SelTableInfoParameterMapper(); DataAccessor <SelTableCount> tableAccessor; string strSql = @"select s.RstId, (s.TableCount*s.MaxTime*(cast(s.Rnoon as int)+cast(s.Reven as int))-(select SUM(isnull(o.TableCount,0)) from Orders o left join OrderStatus os on os.OrderId = o.Id where (os.OrderStatus='Paid' or os.OrderStatus='Confirmed') and o.RstId=s.RstId)) as total from ReceiveOrder s where s.RstId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <SelTableCount> .MapAllProperties() .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.total).ToColumn("total") //.Map(t => t.MaxTime).ToColumn("MaxTime") //.Map(t => t.Reven).ToColumn("Reven") //.Map(t => t.Rnoon).ToColumn("Rnoon") //.Map(t => t.Status).ToColumn("Status") //.Map(t => t.TableCount).ToColumn("TableCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }