public bool UpdLoadLog(UploadClause logIds) { try { return Dal.UpLoadLog(logIds); } catch (Exception e) { LogManager.Instance.Log.Info(e.ToString()); } return false; }
public bool UpLoadLog(UploadClause logIds) { return Bll.UpdLoadLog(logIds); }
private bool UpLoadLogFile(UploadClause clause) { if (clause.LogIds.Count == 0) { LogManager.Instance.Log.Info("没有符合条件的log!"); return false; } LogManager.Instance.Log.Info("开始上传log!"); string sql = string.Format( "select t.auid,t.node_id,t.log_path,t.province_id from log_file_info t where t.auid in ({0})", string.Join(",", clause.LogIds.Select(d => d.Value))); var logs = HelperDal.ExecuteAndGetInstanceList(sql, null, dr => { return new LogEntity { LogId = Convert.ToInt32(dr["auid"]), NodeId = Convert.ToInt32(dr["node_id"]), ProvinceId = Convert.ToInt32(dr["province_id"]), UpLoadPath = dr["log_path"].ToString() }; },ConfigureManager.Logsever.DbConnection); if (logs.Count == 0) { LogManager.Instance.Log.Info("log表里没有相关log"); return false; } GC.Collect(); GC.WaitForPendingFinalizers(); GetLogContent(logs); try { MoveFile(logs); } catch (Exception e) { LogManager.Instance.Log.Info(e.ToString()); return false; } LogManager.Instance.Log.Info("上传成功!"); return true; }
private bool ProcessDb(UploadClause clause) { #region string logIds = string.Join(",", clause.LogIds); string update = string.Format( "update {0}.work_sub_items t set t.is_upload=1 where t.ITEMS_ID in (select d.items_id from log_file_info d where d.auid in ({1}))", GetSchem(), logIds); HelperDal.ExcecuteNoQureyWithoutTrans(update); string clientId = Guid.NewGuid().ToString(); using (var con = HelperDal.GetConnection(clientId)) { HelperDal.BeginTrans(clientId); try { // HelperDal.ExcecuteNoQurey(del, con); string checkSubItem = string.Format( "select count(t.log_id) from {2}.work_sub_items t where t.work_id={0} and t.sub_group_id ={1} and t.is_upload=0", clause.WorkId, clause.SubGroupId, GetSchem()); if (Convert.ToInt32(HelperDal.ExcecuteSalar(checkSubItem)) == 0) { DeleteReleatedWorkItems(clause.WorkId, clause.SubGroupId, clientId); } else { var delLog = string.Format(@"delete from work_report_log d where d.floors_code in (select distinct(t.floors_code) from work_report_log t where t.log_id in ({0}) )", logIds); // var delLog = string.Format("delete from work_report_log t where t.log_id in ({0}) ", logIds); var deLogKpi = string.Format( "delete from work_report_log_kpi t where t.log_id in ({0})", logIds ); HelperDal.ExcecuteNoQurey(delLog, con); HelperDal.ExcecuteNoQurey(deLogKpi, con); } HelperDal.CommitTrans(clientId); } catch (Exception e) { LogHelper.GetInstance().Error("清除数据出错", e); HelperDal.RollBackTrans(clientId); } finally { con.Close(); } } return true; #endregion }
private bool AutoUpLoadLog(UploadClause clause) { if (!UpLoadLogFile(clause)) { return false; } if (!ProcessDb(clause)) { return false; } return true; }
public bool UpLoadLog(UploadClause clause) { LogManager.Instance.Log.Info("开始手动上传log"); if (!UpLoadLogFile(clause)) { LogManager.Instance.Log.Info("手动上传log失败"); return false; } LogManager.Instance.Log.Info("手动上传log成功"); ProcessDb(clause); return true; }