public List <SODiscountMaster> GetSODiscountBySOSysNo(int sosysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSODiscountBySOSysNo"); //DataCommand cmd = new DataCommand("GetSODiscountBySOSysNo"); cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno); DataSet ds = cmd.ExecuteDataSet(); List <SODiscountMaster> dmList = null; if (ds != null && ds.Tables.Count > 1) { dmList = DataMapperHelper.GetEntityList <SODiscountMaster, List <SODiscountMaster> >(ds.Tables[0].Rows); if (dmList != null && dmList.Count > 0) { List <SODiscountDetail> ddList = DataMapperHelper.GetEntityList <SODiscountDetail, List <SODiscountDetail> >(ds.Tables[1].Rows); foreach (var dm in dmList) { dm.Details = ddList.FindAll(dd => dd.MasterSysNo == dm.SysNo); } } } return(dmList); }