public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 EveryDayConsume_Vendor_KeyWord 向 temp_EveryDayConsume_Vendor_KeyWord 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_EveryDayConsume_Vendor_KeyWord", "EveryDayConsume_Vendor_KeyWord");

            LogService.LogService.Instance.Logger("从 EveryDayConsume_Vendor_KeyWord 向 temp_EveryDayConsume_Vendor_KeyWord 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute("Insert into EveryDayConsume_Vendor_KeyWord(VendorID,YearMonthDay,KeyWordId,KeyWordTitle,viewnum,clicknum,viewIpnum,clickIpnum) select * from temp_EveryDayConsume_Vendor_KeyWord");
            LogService.LogService.Instance.Logger("从 temp_EveryDayConsume_Vendor_KeyWord 向 EveryDayConsume_Vendor_KeyWord 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }
예제 #2
0
        public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 EveryDayConsume_AdPutReportInfo 向 temp_EveryDayConsume_AdPutReportInfo 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_EveryDayConsume_AdPutReportInfo", "EveryDayConsume_AdPutReportInfo");

            LogService.LogService.Instance.Logger("从 EveryDayConsume_AdPutReportInfo 向 temp_EveryDayConsume_AdPutReportInfo 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute("Insert into EveryDayConsume_AdPutReportInfo(AdtxtId,YearMonthDay,AdTxtTraceId,viewnum,clicknum,viewIpnum,clickIpnum) select * from temp_EveryDayConsume_AdPutReportInfo");
            LogService.LogService.Instance.Logger("从 temp_EveryDayConsume_AdPutReportInfo 向 EveryDayConsume_AdPutReportInfo 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }
예제 #3
0
        public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 EveryDayConsume_Vendor 向 temp_EveryDayConsume_Vendor 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_EveryDayConsume_Vendor", "EveryDayConsume_Vendor");

            LogService.LogService.Instance.Logger("从 EveryDayConsume_Vendor 向 temp_EveryDayConsume_Vendor 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute("Insert into EveryDayConsume_Vendor(VendorID,YearMonthDay,viewnum,clicknum,viewIpnum,clickIpnum) select * from temp_EveryDayConsume_Vendor");
            LogService.LogService.Instance.Logger("从 temp_MemberSiteEveryDaySummary 向 EveryDayConsume_Vendor 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }
        public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 EveryDayConsume_Dealer_Keyword_L1 向 temp_EveryDayConsume_Dealer_Keyword_L1 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_EveryDayConsume_Dealer_Keyword_L1", "EveryDayConsume_Dealer_Keyword_L1");

            LogService.LogService.Instance.Logger("从 EveryDayConsume_Dealer_Keyword_L1 向 temp_EveryDayConsume_Dealer_Keyword_L1 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute("Insert into EveryDayConsume_Dealer_Keyword_L1(ReportDate,DealerId,KeywordPId,ViewNum,ClickNum,ViewIpNum,ClickIpNum) select * from temp_EveryDayConsume_Dealer_Keyword_L1");
            LogService.LogService.Instance.Logger("从 temp_EveryDayConsume_Dealer_Keyword_L1 向 EveryDayConsume_Dealer_Keyword_L1 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }
예제 #5
0
        public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 MemberSiteEveryDaySummary 向 temp_MemberSiteEveryDaySummary 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_MemberSiteEveryDaySummary", "MemberSiteEveryDaySummary");

            LogService.LogService.Instance.Logger("从 MemberSiteEveryDaySummary 向 temp_MemberSiteEveryDaySummary 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute1("Insert into MemberSiteEveryDaySummary(UnionMemberId,AdSiteId,ymd,viewnum,ClickNum,Ratio,Income,Status) select * from temp_MemberSiteEveryDaySummary");
            LogService.LogService.Instance.Logger("从 temp_MemberSiteEveryDaySummary 向 MemberSiteEveryDaySummary 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }
        public string Export(DateTime statisticsdate)
        {
            LogService.LogService.Instance.Logger("从 everydayconsume_ad_area 向 temp_EveryDayConsume_AD_Area 导数据.\n", "sqoop");
            var feedback = _daoInstance.ExportData("temp_EveryDayConsume_AD_Area", "everydayconsume_ad_area");

            LogService.LogService.Instance.Logger("从 everydayconsume_ad_area 向 temp_EveryDayConsume_AD_Area 导数据操作完成!\n", "sqoop");
            DatabaseDao.execute("Insert into EveryDayConsume_AD_Area(VendorID,AdTxtID,YearMonthDay,AreaTitle,viewnum,clicknum,viewIpnum,clickIpnum) select * from temp_EveryDayConsume_AD_Area");
            LogService.LogService.Instance.Logger("从 temp_EveryDayConsume_AD_Area 向 everydayconsume_ad_area 导数据操作完成!\n", "sqoop");
            LogService.LogService.Instance.Logger(feedback + "\n", "sqoop");
            return(feedback);
        }