/// <summary>
/// インサート
/// </summary>
/// <param name="monitorServerFolder"></param>
public void Insert(Entities.monitorFileListen monitorFileListen)
{
this.monitorFileListenService.Insert(monitorFileListen);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="monitorServerFolder"></param>
public void Edit(Entities.monitorFileListen monitorFileListen)
{
this.monitorFileListenService.Edit(monitorFileListen);
}
/// <summary>
/// バックアップ設定のキー検索
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public Entities.monitorFileListen GetById(int id)
{
Entities.monitorFileListen monitorFileListen = db.monitorFileListens.Find(id);
return(monitorFileListen);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="monitorserverfolder"></param>
public void Edit(Entities.monitorFileListen monitorFileListen)
{
db.Entry(monitorFileListen).State = EntityState.Modified;
db.SaveChanges();
}
/// <summary>
/// インサート
/// </summary>
/// <param name="monitorserverfolder"></param>
public void Insert(Entities.monitorFileListen monitorFileListen)
{
db.monitorFileListens.Add(monitorFileListen);
db.SaveChanges();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="monitorserverfolder"></param>
public int Edit(Entities.monitorFileListen mFL)
{
SqlTransaction trans = null;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
try
{
string sql = string.Empty;
SqlParameter[] paras = null;
sql = @"UPDATE monitorFileListen
SET
monitorServerID =@monitorServerID
,monitorFileName = @monitorFileName
,monitorType = @monitorType
,monitorServerIP = @monitorServerIP
,sharePoint = @sharePoint
,monitorLocalPath = @monitorLocalPath
,monitorFileRelativeDirectory = @monitorFileRelativeDirectory
,monitorFileRelativeFullPath = @monitorFileRelativeFullPath
,monitorFileLastWriteTime =@monitorFileLastWriteTime
,monitorFileSize = @monitorFileSize
,monitorFileExtension = @monitorFileExtension
,monitorFileCreateTime = @monitorFileCreateTime
,monitorFileLastAccessTime = @monitorFileLastAccessTime
,monitorStatus = @monitorStatus
,monitorFileStartTime = @monitorFileStartTime
,monitorFileEndTime = @monitorFileEndTime
,deleteFlg = @deleteFlg
,deleter =@deleter
,deleteDate =@deleteDate
,creater = @creater
,createDate = @createDate
,updater =@updater
,updateDate =@updateDate
WHERE id = @id";
paras = new SqlParameter[] {
new SqlParameter("@monitorServerID", mFL.monitorServerID),
new SqlParameter("@monitorFileName", mFL.monitorFileName),
new SqlParameter("@monitorType", mFL.monitorType),
new SqlParameter("@monitorServerIP", mFL.monitorServerIP),
new SqlParameter("@sharePoint", mFL.sharePoint),
new SqlParameter("@monitorLocalPath", mFL.monitorLocalPath),
new SqlParameter("@monitorFileRelativeDirectory", mFL.monitorFileRelativeDirectory),
new SqlParameter("@monitorFileRelativeFullPath", mFL.monitorFileRelativeFullPath),
new SqlParameter("@monitorFileLastWriteTime", CommonUtil.DateTimeToString(mFL.monitorFileLastWriteTime)),
new SqlParameter("@monitorFileSize", mFL.monitorFileSize),
new SqlParameter("@monitorFileExtension", mFL.monitorFileExtension),
new SqlParameter("@monitorFileCreateTime", CommonUtil.DateTimeToString(mFL.monitorFileCreateTime)),
new SqlParameter("@monitorFileLastAccessTime", CommonUtil.DateTimeToString(mFL.monitorFileLastAccessTime)),
new SqlParameter("@monitorStatus", mFL.monitorStatus),
new SqlParameter("@monitorFileStartTime", CommonUtil.DateTimeToString(mFL.monitorFileStartTime)),
new SqlParameter("@monitorFileEndTime", CommonUtil.DateTimeToString(mFL.monitorFileEndTime)),
new SqlParameter("@deleteFlg", mFL.deleteFlg),
new SqlParameter("@deleter", mFL.deleter),
new SqlParameter("@deleteDate", CommonUtil.DateTimeToString(mFL.deleteDate)),
new SqlParameter("@creater", mFL.creater),
new SqlParameter("@createDate", CommonUtil.DateTimeToString(mFL.createDate)),
new SqlParameter("@updater", mFL.updater),
new SqlParameter("@updateDate", CommonUtil.DateTimeToString(mFL.updateDate)),
new SqlParameter("@id", mFL.id)
};
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(paras);
int iret = cmd.ExecuteNonQuery();
if (iret > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
logger.Error(MessageUtil.GetExceptionMsg(ex, ""));
trans.Rollback();
return(0);
}
}
}
/// <summary>
/// インサート
/// </summary>
/// <param name="monitorserverfolder"></param>
public int Insert(Entities.monitorFileListen mFL)
{
SqlTransaction trans = null;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
try
{
string 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
, mFL.monitorType
, mFL.monitorServerIP
, mFL.sharePoint
, mFL.monitorLocalPath
, mFL.monitorFileRelativeDirectory
, mFL.monitorFileRelativeFullPath
, CommonUtil.DateTimeToString(mFL.monitorFileLastWriteTime)
, mFL.monitorFileSize
, mFL.monitorFileExtension
, CommonUtil.DateTimeToString(mFL.monitorFileCreateTime)
, CommonUtil.DateTimeToString(mFL.monitorFileLastAccessTime)
, mFL.monitorStatus
, CommonUtil.DateTimeToString(mFL.monitorFileStartTime)
, CommonUtil.DateTimeToString(mFL.monitorFileEndTime)
, mFL.deleteFlg
, mFL.deleter
, CommonUtil.DateTimeToString(mFL.deleteDate)
, mFL.creater
, CommonUtil.DateTimeToString(mFL.createDate)
, mFL.updater
, CommonUtil.DateTimeToString(mFL.updateDate));
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int iret = cmd.ExecuteNonQuery();
if (iret > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
logger.Error(MessageUtil.GetExceptionMsg(ex, ""));
trans.Rollback();
return(0);
}
}
}
