Example #1
0
        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);
        }