/// <summary> /// 削除 /// </summary> /// <param name="id"></param> public void Del(int id) { monitorFileListen monitorFileListen = db.monitorFileListens.Find(id); db.monitorFileListens.Remove(monitorFileListen); db.SaveChanges(); }
/// <summary> /// 删除事件 /// </summary> /// <param name="ms"></param> /// <param name="item"></param> /// <returns></returns> private monitorFileListen GetWhenDeletedType(monitorServer ms, FileSystemEventArgs item) { monitorFileListen mflinfo = new monitorFileListen(); mflinfo.monitorServerID = ms.id; mflinfo.monitorType = "削除"; mflinfo.monitorStatus = "削除済"; mflinfo.monitorFileRelativeFullPath = "\\" + item.Name; mflinfo.deleteDate = DateTime.Now; mflinfo.deleteFlg = 1; return(mflinfo); }
/// <summary> /// 更新事件 /// </summary> /// <param name="ms"></param> /// <param name="item"></param> /// <returns></returns> private monitorFileListen GetWhenChangedType(monitorServer ms, FileSystemEventArgs item) { monitorFileListen mflinfo = new monitorFileListen(); FileInfoStruct fi = FSUtil.FindSpecialFileInfo(item.FullPath); mflinfo.monitorServerID = ms.id; mflinfo.monitorType = "更新"; mflinfo.monitorFileRelativeFullPath = "\\" + item.Name; mflinfo.monitorFileSize = fi.Length.ToString(); mflinfo.updateDate = DateTime.Now; return(mflinfo); }
/// <summary> /// 監視対象 /// </summary> /// <param name="monitorServerID"></param> /// <param name="monitorFileLocalPath"></param> /// <param name="deleteFlg"></param> /// <returns></returns> public monitorFileListen GetByMonitorObject(int id) { monitorFileListen _monitorFileListen = null; try { string sql = @"select * from monitorFileListen where id = @id"; SqlParameter paraId = new SqlParameter("@id", id); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql, paraId)) { while (reader.Read()) { _monitorFileListen = new monitorFileListen(); _monitorFileListen.id = int.Parse(reader["id"].ToString()); _monitorFileListen.monitorServerID = int.Parse(reader["monitorServerID"].ToString()); _monitorFileListen.monitorFileName = reader["monitorFileName"].ToString(); _monitorFileListen.monitorType = reader["monitorType"].ToString(); _monitorFileListen.monitorServerIP = reader["monitorServerIP"].ToString(); _monitorFileListen.sharePoint = reader["sharePoint"].ToString(); _monitorFileListen.monitorLocalPath = reader["monitorLocalPath"].ToString(); _monitorFileListen.monitorFileRelativeDirectory = reader["monitorFileRelativeDirectory"].ToString(); _monitorFileListen.monitorFileRelativeFullPath = reader["monitorFileRelativeFullPath"].ToString(); _monitorFileListen.monitorFileLastWriteTime = DateTime.Parse(reader["monitorFileLastWriteTime"].ToString()); _monitorFileListen.monitorFileSize = reader["monitorFileSize"].ToString(); _monitorFileListen.monitorFileExtension = reader["monitorFileExtension"].ToString(); _monitorFileListen.monitorFileCreateTime = DateTime.Parse(reader["monitorFileCreateTime"].ToString()); _monitorFileListen.monitorFileLastAccessTime = DateTime.Parse(reader["monitorFileLastAccessTime"].ToString()); _monitorFileListen.monitorStatus = reader["monitorStatus"].ToString(); _monitorFileListen.monitorFileStartTime = DateTime.Parse(reader["monitorFileStartTime"].ToString()); _monitorFileListen.monitorFileEndTime = DateTime.Parse(reader["monitorFileEndTime"].ToString()); _monitorFileListen.deleteFlg = short.Parse(reader["deleteFlg"].ToString()); _monitorFileListen.deleter = reader["deleter"].ToString(); _monitorFileListen.deleteDate = DateTime.Parse(reader["deleteDate"].ToString()); _monitorFileListen.creater = reader["creater"].ToString(); _monitorFileListen.createDate = DateTime.Parse(reader["createDate"].ToString()); _monitorFileListen.updater = reader["updater"].ToString(); _monitorFileListen.updateDate = DateTime.Parse(reader["updateDate"].ToString()); } } } catch (Exception ex) { logger.Error(MessageUtil.GetExceptionMsg(ex, "")); } return(_monitorFileListen); }
/// <summary> /// 更新事件 /// </summary> /// <param name="ms"></param> /// <param name="item"></param> /// <returns></returns> private monitorFileListen GetWhenChangedType(monitorServer ms, FileSystemEventArgs item) { monitorFileListen mflinfo = new monitorFileListen(); Alphaleonis.Win32.Filesystem.FileInfo fi = new Alphaleonis.Win32.Filesystem.FileInfo(item.FullPath); if (fi == null) { return(null); } mflinfo.monitorServerID = ms.id; mflinfo.monitorType = "更新"; mflinfo.monitorFileRelativeFullPath = "\\" + item.Name; mflinfo.monitorFileSize = fi.Length.ToString(); mflinfo.updateDate = DateTime.Now; return(mflinfo); }
/// <summary> /// 创建事件 /// </summary> /// <param name="ms"></param> /// <param name="item"></param> /// <returns></returns> private monitorFileListen GetWhenCreatedType(monitorServer ms, FileSystemEventArgs item) { monitorFileListen mflinfo = new monitorFileListen(); FileInfoStruct fi = FSUtil.FindSpecialFileInfo(item.FullPath); mflinfo.monitorServerID = ms.id; mflinfo.monitorFileName = fi.Name; mflinfo.monitorType = "新規"; mflinfo.monitorServerIP = ms.monitorServerIP; mflinfo.sharePoint = ms.startFile; mflinfo.monitorLocalPath = ms.monitorLocalPath; if (item.Name.Contains('\\')) { mflinfo.monitorFileRelativeDirectory = "\\" + item.Name.Substring(0, item.Name.LastIndexOf('\\')); } else { mflinfo.monitorFileRelativeDirectory = ""; } mflinfo.monitorFileRelativeFullPath = "\\" + item.Name; mflinfo.monitorFileLastWriteTime = fi.LastWriteTime; mflinfo.monitorFileSize = fi.Length.ToString(); mflinfo.monitorFileExtension = fi.Extension; mflinfo.monitorFileCreateTime = fi.CreationTime; mflinfo.monitorFileLastAccessTime = fi.LastAccessTime; mflinfo.monitorStatus = "転送済"; mflinfo.monitorFileStartTime = DateTime.Now; mflinfo.monitorFileEndTime = DateTime.Now; mflinfo.deleteFlg = DefaultValue.DEFAULTINT_VALUE; mflinfo.deleter = DefaultValue.DEFAULTCHAR_VALUE; mflinfo.deleteDate = DefaultValue.DEFAULTDATETIME_VALUE; mflinfo.creater = "admin"; mflinfo.createDate = DateTime.Now; mflinfo.updater = "admin"; mflinfo.updateDate = DateTime.Now; return(mflinfo); }
/// <summary> /// 将monitorFileListen对象转换成sql字符串 xiecongwen 20140705 /// </summary> /// <param name="log"></param> /// <returns></returns> private void GetSql(monitorFileListen mFL, StringBuilder sb) { try { string sql = string.Empty; if ("新規".Equals(mFL.monitorType)) { #region 新規 //判断是否已经存在 //string check = string.Format(@" if exists(select id from [monitorFileListen] where deleteFlg=0 and monitorServerID={0} and monitorFileRelativeFullPath='{1}')", // mFL.monitorServerID,mFL.monitorFileRelativeFullPath.Replace("'","''")); sql = string.Format(@" INSERT INTO monitorFileListen (monitorServerID ,monitorFileName ,monitorType ,monitorServerIP ,sharePoint ,monitorLocalPath ,monitorFileRelativeDirectory ,monitorFileRelativeFullPath ,monitorFileLastWriteTime ,monitorFileSize ,monitorFileExtension ,monitorFileCreateTime ,monitorFileLastAccessTime ,monitorStatus ,monitorFileStartTime ,monitorFileEndTime ,deleteFlg ,deleter ,deleteDate ,creater ,createDate ,updater ,updateDate ,[synchronismFlg] ) VALUES ('{0}' ,N'{1}' ,'{2}' ,'{3}' ,N'{4}' ,N'{5}' ,N'{6}' ,N'{7}' ,'{8}' ,'{9}' ,'{10}' ,'{11}' ,'{12}' ,'{13}' ,'{14}' ,'{15}' ,'{16}' ,'{17}' ,'{18}' ,'{19}' ,'{20}' ,'{21}' ,'{22}',0);", mFL.monitorServerID , mFL.monitorFileName.Replace("'", "''") , mFL.monitorType , mFL.monitorServerIP , mFL.sharePoint.Replace("'", "''") , mFL.monitorLocalPath , mFL.monitorFileRelativeDirectory.Replace("'", "''") , mFL.monitorFileRelativeFullPath.Replace("'", "''") , mFL.monitorFileLastWriteTime , mFL.monitorFileSize , mFL.monitorFileExtension , mFL.monitorFileCreateTime , mFL.monitorFileLastAccessTime , mFL.monitorStatus , mFL.monitorFileStartTime , mFL.monitorFileEndTime , mFL.deleteFlg , mFL.deleter , mFL.deleteDate , mFL.creater , mFL.createDate , mFL.updater , mFL.updateDate); #endregion goto append; } if ("削除".Equals(mFL.monitorType)) { #region 削除 sql = string.Format(@"update [monitorFileListen] set [monitorType]='{0}',monitorStatus='{1}',deleteDate='{2}',deleteFlg={3},synchronismFlg=0 where deleteFlg=0 and monitorServerID={4} and monitorFileRelativeFullPath='{5}'; ", mFL.monitorType, mFL.monitorStatus, mFL.deleteDate, mFL.deleteFlg, mFL.monitorServerID, mFL.monitorFileRelativeFullPath.Replace("'", "''")); #endregion goto append; } if ("更新".Equals(mFL.monitorType)) { #region 更新 sql = string.Format(@"update [monitorFileListen] set [monitorType]='{0}',monitorFileSize='{1}',updateDate='{2}',synchronismFlg=0 where deleteFlg=0 and monitorServerID={3} and monitorFileRelativeFullPath='{4}'; ", mFL.monitorType, mFL.monitorFileSize, mFL.updateDate, mFL.monitorServerID, mFL.monitorFileRelativeFullPath.Replace("'", "''")); #endregion } append : sb.Append(sql); } catch (Exception ex) { logger.Error(ex.Message); } }