public List<Product> getOrginalImageProductListInfoData(string id)
{
List<Product> list = null;
try
{
IParameterMapper ipmapper = new getImageProductListInfoDataParameterMapper();
DataAccessor<Product> tableAccessor;
string strSql = @"select b.OriginalImage
from Product b where 1=1 and b.Status=1 and b.Id=@Id";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<Product>.MapAllProperties()
.DoNotMap(t => t.ProductTypeName1)
.DoNotMap(t => t.ProductTypeName2)
.DoNotMap(t => t.OrderNo)
.DoNotMap(t => t.Id)
//.DoNotMap(t => t.TypeId)
.DoNotMap(t => t.ProductName)
.DoNotMap(t => t.ProductType)
.DoNotMap(t => t.Code)
.DoNotMap(t => t.PinYin)
.DoNotMap(t => t.Unit)
.DoNotMap(t => t.MinUnit)
.DoNotMap(t => t.MinCount)
.DoNotMap(t => t.Price)
.Map(t => t.OriginalImage).ToColumn("OriginalImage")
.DoNotMap(t => t.ThumbImage)
.DoNotMap(t => t.BarCode)
.DoNotMap(t => t.Status)
.DoNotMap(t => t.RestaurantId)
.DoNotMap(t => t.Type)
.DoNotMap(t => t.MaterialId)
.DoNotMap(t => t.IsDiscount)
.DoNotMap(t => t.IsServiceType)
.DoNotMap(t => t.OrderCount)
.DoNotMap(t => t.FavCount)
.Build());
list = tableAccessor.Execute(new object[] { Guid.Parse(id) }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log("ID: " + id + "\r\n" + ex);
return null;
}
}
public List <Product> getThumbImageProductListInfoData(string id)
{
List <Product> list = null;
try
{
IParameterMapper ipmapper = new getImageProductListInfoDataParameterMapper();
DataAccessor <Product> tableAccessor;
string strSql = @"select b.ThumbImage
from Product b where 1=1 and b.Status=1 and b.Id=@Id";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <Product> .MapAllProperties()
.DoNotMap(t => t.ProductTypeName1)
.DoNotMap(t => t.ProductTypeName2)
.DoNotMap(t => t.OrderNo)
.DoNotMap(t => t.Id)
//.DoNotMap(t => t.TypeId)
.DoNotMap(t => t.ProductName)
.DoNotMap(t => t.ProductType)
.DoNotMap(t => t.Code)
.DoNotMap(t => t.PinYin)
.DoNotMap(t => t.Unit)
.DoNotMap(t => t.MinUnit)
.DoNotMap(t => t.MinCount)
.DoNotMap(t => t.Price)
.Map(t => t.ThumbImage).ToColumn("ThumbImage")
.DoNotMap(t => t.OriginalImage)
.DoNotMap(t => t.BarCode)
.DoNotMap(t => t.Status)
.DoNotMap(t => t.RestaurantId)
.DoNotMap(t => t.Type)
.DoNotMap(t => t.MaterialId)
.DoNotMap(t => t.IsDiscount)
.DoNotMap(t => t.IsServiceType)
.DoNotMap(t => t.OrderCount)
.DoNotMap(t => t.FavCount)
.Build());
list = tableAccessor.Execute(new object[] { Guid.Parse(id) }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log("ID: " + id + "\r\n" + ex);
return(null);
}
}
public List<ReceiveOrder1> getDefauleImage(string id)
{
List<ReceiveOrder1> list = null;
try
{
IParameterMapper ipmapper = new getImageProductListInfoDataParameterMapper();
DataAccessor<ReceiveOrder1> tableAccessor;
string strSql = @"select ro.DefaultImg from Product p ,
ReceiveOrder ro where p.RestaurantId=ro.RstId and p.Id=@Id";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ReceiveOrder1>.MapAllProperties()
.Map(t => t.DefaultImg).ToColumn("DefaultImg")
.Build());
list = tableAccessor.Execute(new object[] { Guid.Parse(id) }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log("ID: " + id + "\r\n" + ex);
return null;
}
}
public List <ReceiveOrder1> getDefauleImage(string id)
{
List <ReceiveOrder1> list = null;
try
{
IParameterMapper ipmapper = new getImageProductListInfoDataParameterMapper();
DataAccessor <ReceiveOrder1> tableAccessor;
string strSql = @"select ro.DefaultImg from Product p ,
ReceiveOrder ro where p.RestaurantId=ro.RstId and p.Id=@Id";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <ReceiveOrder1> .MapAllProperties()
.Map(t => t.DefaultImg).ToColumn("DefaultImg")
.Build());
list = tableAccessor.Execute(new object[] { Guid.Parse(id) }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log("ID: " + id + "\r\n" + ex);
return(null);
}
}