public List <PresentProduct> getPresentProductListData(string RstId) { List <PresentProduct> list = null; try { IParameterMapper ipmapper = new getPresentProductListDataParameterMapper(); DataAccessor <PresentProduct> tableAccessor; string strSql = @" select pp.ProductId, pp.ProductName,pp.Unit,pp.MinUnit,pp.RstId ,c.CodeTypeListName ,pp.ProductCount from PresentProduct pp,s_codelist c where c.codetype='ProductUnit' and pp.unit=c.codetypelistvalue and pp.Status=1 and pp.RstId=@RstId "; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <PresentProduct> .MapAllProperties() .Map(t => t.ProductId).ToColumn("ProductId") .Map(t => t.MinUnit).ToColumn("MinUnit") .Map(t => t.ProductName).ToColumn("ProductName") .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.CodeTypeListName).ToColumn("CodeTypeListName") .Map(t => t.Unit).ToColumn("Unit") .Map(t => t.ProductCount).ToColumn("ProductCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List<PresentProduct> getPresentProductListData(string RstId) { List<PresentProduct> list = null; try { IParameterMapper ipmapper = new getPresentProductListDataParameterMapper(); DataAccessor<PresentProduct> tableAccessor; string strSql = @" select pp.ProductId, pp.ProductName,pp.Unit,pp.MinUnit,pp.RstId ,c.CodeTypeListName ,pp.ProductCount from PresentProduct pp,s_codelist c where c.codetype='ProductUnit' and pp.unit=c.codetypelistvalue and pp.Status=1 and pp.RstId=@RstId "; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<PresentProduct>.MapAllProperties() .Map(t => t.ProductId).ToColumn("ProductId") .Map(t => t.MinUnit).ToColumn("MinUnit") .Map(t => t.ProductName).ToColumn("ProductName") .Map(t => t.RstId).ToColumn("RstId") .Map(t => t.CodeTypeListName).ToColumn("CodeTypeListName") .Map(t => t.Unit).ToColumn("Unit") .Map(t => t.ProductCount).ToColumn("ProductCount") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }