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); }
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); }
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); }
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); }