public void DoIntervalSync(string connDBString) { //SqlCmdHelper help = new SqlCmdHelper() { SqlConnString = connDBString }; string[] dbArr = connDBString.Split(';'); string waitSyncDB = string.Empty; foreach (var item in dbArr) { if (item.Contains("Initial Catalog")) { waitSyncDB = item.Split('=')[1].Trim(); } } string sql = SyncToCodeDB(10, waitSyncDB); string time = DateTime.Now.ToString(CommonFormat.DateTimeFormat); LogHelperExt.WriteLog("will Sync uin in " + waitSyncDB + ".dbo.tecentqqdata data,time=" + time); try { if (ConfigurationItems.OupputSql) { LogHelperExt.WriteLog("will exucte sql= " + sql); } //help.ExcuteNoQuery(sql, null); string endTime = DateTime.Now.ToString(CommonFormat.DateTimeFormat); LogHelperExt.WriteLog("end Sync uin data,time=" + endTime); } catch (Exception ex) { string endTime = DateTime.Now.ToString(CommonFormat.DateTimeFormat); LogHelperExt.WriteLog("Sync uin data error \r\n" + endTime + " \r\n" + ex.Message); } }
private void TecentDataFrm_Load(object sender, EventArgs e) { try { InitBaseConfig(); } catch (Exception ex) { /* * 未能加载文件或程序集“EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”或它的某一个依赖项。系统找不到指定的文件。 */ LogHelperExt.WriteLog(ex.ToString()); } }
private void QueryTodayPickUp(object data) { try { if (this.InvokeRequired) { DelegateData.BaseDelegate bd = new DelegateData.BaseDelegate(QueryTodayPickUp); this.Invoke(bd, data); return; } PickUpStatic pc = data as PickUpStatic; lsbStatic.Items.Clear(); lsbStatic.Items.Add("时间戳" + DateTime.Now.ToString()); lsbStatic.Items.Add("库\t" + pc.DBTotal); lsbStatic.Items.Add("库唯一\t" + pc.DBPrimaryTotal); lsbStatic.Items.Add("日期\t" + pc.StaticDay); lsbStatic.Items.Add("今日总计\t" + pc.Total); lsbStatic.Items.Add("今日QQ号\t" + pc.IdTotal); } catch (Exception ex) { LogHelperExt.WriteLog("Query pick up number\r\n" + ex.Message); } }