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