private void detach_ImportCompletedEmailNoticeStatus(ImportCompletedEmailNoticeStatus entity) { this.SendPropertyChanging(); entity.Hotel = null; }
partial void InsertImportCompletedEmailNoticeStatus(ImportCompletedEmailNoticeStatus instance);
partial void DeleteImportCompletedEmailNoticeStatus(ImportCompletedEmailNoticeStatus instance);
private void UpdateEmailNoticeStatus(int yearCode, int? monthCode, int hotelId) { using (var context = Helper.GetDataContext()) { var r = context.ExecuteQuery<ImportReport>(@" select top 1 r.* from ImportReport r left join( select * from dbo.DataImportBudgetTracking where issuccess = 'true' and YearCode={0} and HotelId={1} ) dt on r.ImportReportName=dt.InputTableName where dt.Id is null and r.Kind='预算类'", yearCode, hotelId); if (r.Count() == 0) //已经导入完全部报表 { var en = context.ImportCompletedEmailNoticeStatus.FirstOrDefault(i => i.HotelId == hotelId && i.YearCode == yearCode && i.MonthCode == monthCode); if (en == null) { en = new ImportCompletedEmailNoticeStatus() { YearCode = yearCode, MonthCode = monthCode, MonthDate = new DateTime(yearCode, 1, 1), HotelId = hotelId, EmailSendStatus = 0, Kind = "实际类" }; context.ImportCompletedEmailNoticeStatus.InsertOnSubmit(en); context.SubmitChanges(); } } } }