Exemple #1
0
        public void GetUnitLists()
        {
            if (string.IsNullOrEmpty(FileName.Trim()))
            {
                return;
            }
            SqlHelper sqlHelper = new SqlHelper();
            string    sql       = "select * from MCA_ACE_TYPE2_DATA where FileName = '" + FileName + "' and ImportDateTime ='" + ImportDateTime + "' order by AcqDateTime";

            sqlHelper.getSomeDate(sql);
            if (sqlHelper.dt.DefaultView.Count <= 0)
            {
                return;
            }
            IList <ReportModelUnitType2> ilist = ModelConvertHelper <ReportModelUnitType2> .ConvertToModel(sqlHelper.dt);

            List <ReportModelUnitType2> list = ModelConvertHelper <ReportModelUnitType2> .ConvertIListToList <ReportModelUnitType2>(ilist);

            this.repotunits = list;
        }
Exemple #2
0
        public void GetUnitLists()
        {
            if (string.IsNullOrEmpty(SampleComment.Trim()))
            {
                return;
            }

            SqlHelper sqlHelper = new SqlHelper();
            string    sql       = "select * from AMS_MCA_RPT_DATA where SampleComment = '" + SampleComment + "' order by IndexNo";

            sqlHelper.getSomeDate(sql);
            if (sqlHelper.dt.DefaultView.Count <= 0)
            {
                return;
            }
            IList <ReportModelUnit> ilist = ModelConvertHelper <ReportModelUnit> .ConvertToModel(sqlHelper.dt);

            List <ReportModelUnit> list = ModelConvertHelper <ReportModelUnit> .ConvertIListToList <ReportModelUnit>(ilist);

            this.repotunits = list;
        }