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