Пример #1
0
        private void LoadQuery()
        {
            DateTime dteDateTimeCutoff = DateTime.Now;

            string strSQL = DynamicQueryBuilder.GetDynamicManagedServiceOrdersQuery(dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff);

            strSQL        = strSQL.Replace(Environment.NewLine, "<br/>");
            lblQuery.Text = strSQL;
        }
        public void Test_GetRecsFromDB_Changeset_DYNAMIC()
        {
            DateTime dteDateTimeCutoff = new DateTime(2018, 04, 01, 13, 59, 59);

            string strSQL = DynamicQueryBuilder.GetDynamicManagedServiceOrdersQuery(dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff);

            DAL.CDWOrderAddressRecord    objCDWChangesetQuery = new CDWOrderAddressRecord();
            List <CDWOrderAddressRecord> lstResults           = objCDWChangesetQuery.GetRecords(strSQL);

            Assert.IsTrue(lstResults.Count > 0);
        }