public void Execute(XmlNode node) { try { DateTime now = DateTime.Now; List <WXMenuClickInfo> list = (List <WXMenuClickInfo>)HiCache.Get("DataCache-WXMenuClickRecords"); if (list != null && list.Count > 0) { HiCache.Remove("DataCache-WXMenuClickRecords"); Database database = DatabaseFactory.CreateDatabase(); StringBuilder stringBuilder = new StringBuilder(); foreach (WXMenuClickInfo item in list) { stringBuilder.AppendFormat("INSERT INTO [Hishop_MenuClickRecords] (MenuId,WXOpenId,ClickDate) VALUES({0},'{1}','{2}');", item.MenuId, item.WXOpenId, item.ClickDate.ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(stringBuilder.ToString())) { database.ExecuteNonQuery(CommandType.Text, stringBuilder.ToString()); } } WXFansJob.SynchroWXFansData(now); } catch (Exception ex) { Globals.WriteExceptionLog(ex, null, "WXFansJob"); } }
public static void SynchroWXFansData(DateTime dt) { if (dt.Hour == 2 || dt.Hour == 4 || dt.Hour == 6 || dt.Hour == 8) { object obj = HiCache.Get("DataCache-WXDataSynchroDateKey"); if (obj == null) { WXFansJob.SynchroWXFansDataAction(); } else if (Convert.ToDateTime(obj).Date < dt.Date) { WXFansJob.SynchroWXFansDataAction(); } } }