/// <summary>
/// 削除
/// </summary>
/// <param name="cust_no"></param>
public void Del(int monitorServerID)
{
monitorServerFile monitorserverfile = db.monitorServerFiles.Find(monitorServerID);
db.monitorServerFiles.Remove(monitorserverfile);
db.SaveChanges();
}
/// <summary>
/// インサート
/// </summary>
/// <param name="monitorserverfolder"></param>
public int Insert(monitorServerFile monitorserverfile)
{
SqlTransaction trans = null;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
try
{
string sql = string.Format(@"INSERT INTO [dbo].[monitorServerFile] ([monitorServerID]
,[monitorFileName]
,[monitorFileDirectory]
,[monitorFilePath]
,[monitorFileType]
,[monitorFileSize]
,[monitorStartTime]
,[monitorEndTime]
,[monitorFileStatus]
,[transferFlg]
,[transferNum]
,[deleteFlg]
,[deleter]
,[deleteDate]
,[creater]
,[createDate]
,[updater]
,[updateDate]
,[restorer]
,[restoreDate]
,[synchronismFlg])
VALUES
('{0}'
,N'{1}'
,N'{2}'
,N'{3}'
,'{4}'
,'{5}'
,'{6}'
,'{7}'
,'{8}'
,'{9}'
,'{10}'
,'{11}'
,'{12}'
,'{13}'
,'{14}'
,'{15}'
,'{16}'
,'{17}'
,'{18}'
,'{19}',0)",
monitorserverfile.monitorServerID
, monitorserverfile.monitorFileName
, monitorserverfile.monitorFileDirectory
, monitorserverfile.monitorFilePath
, monitorserverfile.monitorFileType
, monitorserverfile.monitorFileSize
, CommonUtil.DateTimeToString(monitorserverfile.monitorStartTime)
, CommonUtil.DateTimeToString(monitorserverfile.monitorEndTime)
, monitorserverfile.monitorFileStatus
, monitorserverfile.transferFlg
, monitorserverfile.transferNum
, monitorserverfile.deleteFlg
, monitorserverfile.deleter
, CommonUtil.DateTimeToString(monitorserverfile.deleteDate)
, monitorserverfile.creater
, CommonUtil.DateTimeToString(monitorserverfile.createDate)
, monitorserverfile.updater
, CommonUtil.DateTimeToString(monitorserverfile.updateDate)
, monitorserverfile.restorer
, CommonUtil.DateTimeToString(monitorserverfile.restoreDate));
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(ex.Message);
trans.Rollback();
return(0);
}
}
}
