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;
}
}
