public List <Order> selOrderByOrderId(Guid orderId) { List <Order> list = null; try { IParameterMapper ipmapper = new selOrderIdParameterMapper(); DataAccessor <Order> tableAccessor; string strSql = @" select b.ContactName, b.ContactPhone,b.CreateDate, b.DiningDate,b.MemberCardNo,b.Id,b.OperatorId,b.OperatorName,b.PersonCount,b.PrepayPrice,b.Remark,b.ReserveType, b.Status, os.OrderStatus, b.TableCount, c.sex ,b.RstId, '01' as RstType from Orders b left join OrderStatus os on os.OrderId = b.Id, crmmember c where b.id=@OrderId and b.MemberCardNo=c.Uid"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <Order> .MapAllProperties() .Map(t => t.Id).ToColumn("Id") .Map(t => t.Status).ToColumn("OrderStatus") .Map(t => t.ContactName).ToColumn("ContactName") .Map(t => t.ContactPhone).ToColumn("ContactPhone") .Map(t => t.CreateDate).ToColumn("CreateDate") .Map(t => t.DiningDate).ToColumn("DiningDate") .Map(t => t.MemberCardNo).ToColumn("MemberCardNo") .Map(t => t.OperatorId).ToColumn("OperatorId") .Map(t => t.OperatorName).ToColumn("OperatorName") .Map(t => t.PersonCount).ToColumn("PersonCount") .Map(t => t.PrepayPrice).ToColumn("PrepayPrice") .Map(t => t.Remark).ToColumn("Remark") .Map(t => t.ReserveType).ToColumn("ReserveType") .Map(t => t.TableCount).ToColumn("TableCount") .Map(t => t.Sex).ToColumn("Sex") .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.RstType).ToColumn("RstType") .Build()); list = tableAccessor.Execute(new string[] { orderId.ToString() }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List<Order> selOrderByOrderId(Guid orderId) { List<Order> list = null; try { IParameterMapper ipmapper = new selOrderIdParameterMapper(); DataAccessor<Order> tableAccessor; string strSql = @" select b.ContactName, b.ContactPhone,b.CreateDate, b.DiningDate,b.MemberCardNo,b.Id,b.OperatorId,b.OperatorName,b.PersonCount,b.PrepayPrice,b.Remark,b.ReserveType, b.Status, os.OrderStatus, b.TableCount, c.sex ,b.RstId, '01' as RstType from Orders b left join OrderStatus os on os.OrderId = b.Id, crmmember c where b.id=@OrderId and b.MemberCardNo=c.Uid"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<Order>.MapAllProperties() .Map(t => t.Id).ToColumn("Id") .Map(t => t.Status).ToColumn("OrderStatus") .Map(t => t.ContactName).ToColumn("ContactName") .Map(t => t.ContactPhone).ToColumn("ContactPhone") .Map(t => t.CreateDate).ToColumn("CreateDate") .Map(t => t.DiningDate).ToColumn("DiningDate") .Map(t => t.MemberCardNo).ToColumn("MemberCardNo") .Map(t => t.OperatorId).ToColumn("OperatorId") .Map(t => t.OperatorName).ToColumn("OperatorName") .Map(t => t.PersonCount).ToColumn("PersonCount") .Map(t => t.PrepayPrice).ToColumn("PrepayPrice") .Map(t => t.Remark).ToColumn("Remark") .Map(t => t.ReserveType).ToColumn("ReserveType") .Map(t => t.TableCount).ToColumn("TableCount") .Map(t => t.Sex).ToColumn("Sex") .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.RstType).ToColumn("RstType") .Build()); list = tableAccessor.Execute(new string[] { orderId.ToString() }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }