public IEnumerable <trxDetailPekerjaanAS_3M> GetByRekananXLS(System.Guid idRekanan, string strFilterExpre1, string strFilterExpre2)
        {
            string[] arrReturn = new string[] { };
            arrReturn = XLSExportHelper.ParseQueryPekerjaan(strFilterExpre1, strFilterExpre2);
            var rekananCollection = _repDetailPek.GetByRekananXLS(idRekanan, arrReturn[0], arrReturn[1]);

            return(rekananCollection);
        }
        public IEnumerable <fPekerjaanAS_3MByTypeOfRekanan_Result> XLS_PekerjaanByTypeOfRekAS(int intTypeOfRekanan, string strFilterExpre1, string strFilterExpre2)
        {
            string[] arrReturn = new string[] { };
            arrReturn = XLSExportHelper.ParseQueryPekerjaan(strFilterExpre1, strFilterExpre2);
            var rekananCollection = _repDetailPek.XLS_PekerjaanByTypeOfRek(intTypeOfRekanan, arrReturn[0], arrReturn[1]);

            return(rekananCollection);
        }
        public IEnumerable <fPekerjaanAS_1MByTypeOfRekanan_Result> XLS_PekerjaanByTypeOfRekAS(int intTypeOfRekanan, string strFilterExpre1, string strFilterExpre2)
        {
            trxDetailPekerjaanAS_1MMulti myDataMulti = new trxDetailPekerjaanAS_1MMulti();

            string[] arrReturn = new string[] { };
            arrReturn = XLSExportHelper.ParseQueryPekerjaan(strFilterExpre1, strFilterExpre2);
            var pekerjaanColl = _repDetail.XLS_PekerjaanByTypeOfRek(intTypeOfRekanan, arrReturn[0], arrReturn[1]);

            return(pekerjaanColl);
        }
示例#4
0
        public IEnumerable <fPekerjaanByTypeOfRekanan_Result> XLS_PekerjaanByTypeOfRek(int intTypeOfRekanan, string strFilterExpre1, string strFilterExpre2)
        {
            //string strTemp2 = strFilterExpre2.Replace(" ME ", " >= ");
            //strTemp2 = strTemp2.Replace(" LE ", " <= ");
            //strTemp2 = strTemp2.Replace(" NN ", " && ");
            //string strFilterExp1 = CustomCriteriaToLinqWhereParser.Process(CriteriaOperator.Parse(strFilterExpre1) as CriteriaOperator);
            //string strFilterExp2 = strFilterExpre2;

            //strFilterExp1 = "TanggalSelesaiPekerjaan >= 2001-01-01 && TanggalSelesaiPekerjaan <= 2017-09-09";
            string[] arrReturn = new string[] { };

            arrReturn = XLSExportHelper.ParseQueryPekerjaan(strFilterExpre1, strFilterExpre2);
            var rekananCollection = _repDetailPek.XLS_PekerjaanByTypeOfRek(intTypeOfRekanan, arrReturn[0], arrReturn[1]);

            return(rekananCollection);
        }