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