/// <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);
}
}
