/// <summary>
/// 更新
/// </summary>
/// <param name="monitorserverfolder"></param>
public int Edit(Entities.monitorServerFile monitorserverfile)
{
SqlTransaction trans = null;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
try
{
string sql = string.Empty;
SqlParameter[] paras = null;
sql = @"UPDATE [dbo].[monitorServerFile]
SET [monitorServerID] = @monitorServerID
,[monitorFileName] = @monitorFileName
,[monitorFileDirectory] = @monitorFileDirectory
,[monitorFilePath] = @monitorFilePath
,[monitorFileType] = @monitorFileType
,[monitorFileSize] = @monitorFileSize
,[monitorStartTime] = @monitorStartTime
,[monitorEndTime] = @monitorEndTime
,[monitorFileStatus] = @monitorFileStatus
,[transferFlg] = @transferFlg
,[transferNum] = @transferNum
,[deleteFlg] = @deleteFlg
,[deleter] = @deleter
,[deleteDate] = @deleteDate
,[creater] = @creater
,[createDate] = @createDate
,[updater] = @updater
,[updateDate] = @updateDate
,[restorer] = @restorer
,[restoreDate] = @restoreDate
WHERE id = @id";
paras = new SqlParameter[] {
new SqlParameter("@monitorServerID", monitorserverfile.monitorServerID),
new SqlParameter("@monitorFileName", monitorserverfile.monitorFileName),
new SqlParameter("@monitorFileDirectory", monitorserverfile.monitorFileDirectory),
new SqlParameter("@monitorFilePath", monitorserverfile.monitorFilePath),
new SqlParameter("@monitorFileType", monitorserverfile.monitorFileType),
new SqlParameter("@monitorFileSize", monitorserverfile.monitorFileSize),
new SqlParameter("@monitorStartTime", CommonUtil.DateTimeToString(monitorserverfile.monitorStartTime)),
new SqlParameter("@monitorEndTime", CommonUtil.DateTimeToString(monitorserverfile.monitorEndTime)),
new SqlParameter("@monitorFileStatus", monitorserverfile.monitorFileStatus),
new SqlParameter("@transferFlg", monitorserverfile.transferFlg),
new SqlParameter("@transferNum", monitorserverfile.transferNum),
new SqlParameter("@deleteFlg", monitorserverfile.deleteFlg),
new SqlParameter("@deleter", monitorserverfile.deleter),
new SqlParameter("@deleteDate", CommonUtil.DateTimeToString(monitorserverfile.deleteDate)),
new SqlParameter("@creater", monitorserverfile.creater),
new SqlParameter("@createDate", CommonUtil.DateTimeToString(monitorserverfile.createDate)),
new SqlParameter("@updater", monitorserverfile.updater),
new SqlParameter("@updateDate", CommonUtil.DateTimeToString(monitorserverfile.updateDate)),
new SqlParameter("@restorer", monitorserverfile.updater),
new SqlParameter("@restoreDate", CommonUtil.DateTimeToString(monitorserverfile.updateDate)),
new SqlParameter("@id", monitorserverfile.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(ex.Message);
trans.Rollback();
return(0);
}
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="monitorserverfolder"></param>
public void Edit(Entities.monitorServerFile monitorserverfile)
{
db.Entry(monitorserverfile).State = EntityState.Modified;
db.SaveChanges();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="monitorServerFolder"></param>
public void Edit(Entities.monitorServerFile monitorServerFile)
{
this.monitorServerFileService.Edit(monitorServerFile);
}
/// <summary>
/// インサート
/// </summary>
/// <param name="monitorserverfolder"></param>
public void Insert(Entities.monitorServerFile monitorserverfile)
{
db.monitorServerFiles.Add(monitorserverfile);
db.SaveChanges();
}
/// <summary>
/// インサート
/// </summary>
/// <param name="monitorServerFolder"></param>
public void Insert(Entities.monitorServerFile monitorServerFile)
{
this.monitorServerFileService.Insert(monitorServerFile);
}
