public int GetMonitorFileListenListCount(string monitorFileName, string monitorServerID, string dirname)
{
OdbcConnection conn;
int count = 0;
//simplify sql——2014-07-03 wjd modified
string where = "";//deleteFlg = 0 AND monitorType<>'削除'
//monitorServerId format: DBServerIP|monitorServerId Id——2014-07-06 wjd modified
string DBServerIP = "";
string msId = "";
if (monitorServerID.Trim('|').IndexOf('|') > 0)
{
string[] array = monitorServerID.Trim('|').Split('|');
DBServerIP = "'" + array[0] + "'";
msId = array[1];
}
else
{
DBServerIP = Common.CommonUtil.GetLoginIPWithQuote();
msId = monitorServerID;
}
//file or folder
if (monitorFileName != "")
{
if (dirname == "0")
{
where += " monitorFileName like '%" + monitorFileName + "%'";// AND monitorFileRelativeDirectory not like '%\\" + monitorFileName + "%'
}
else
{
where += " monitorFileRelativeDirectory like '%\\" + monitorFileName + "%'";//id IN(select min(id) from (SELECT min(id) as id,min(CHARINDEX('\\" + monitorFileName + "', monitorFileRelativeDirectory)) AS patindexs FROM monitorFileListen where deleteFlg=0 and monitorType<>'削除' group by monitorFileRelativeDirectory) as a group by a.patindexs) AND
}
where += " AND ";
}
//one or all monitorServers
if (msId != "-1")
{
where += " monitorServerID = " + msId + " AND ";
}
//add condition DBServerIP——2014-06-04 wjd modified
where += " DBServerIP in (" + DBServerIP + ") ";
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
count = MonitorFileListenDal.GetMonitorFileListenListCount(where, conn);
conn.Close();
return(count);
}
}
public int InsertManualBackupServer(ManualBackupServer ManualBackupServer)
{
OdbcConnection conn;
int count = 0;
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
count = ManualBackupServerDal.InsertManualBackupServer(ManualBackupServer, conn);
conn.Close();
}
return(count);
}
public int DeleteManualBackupServer(int BackupServerId, string loginID)
{
OdbcConnection conn;
int count = 0;
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
count = ManualBackupServerDal.DeleteManualBackupServerById(BackupServerId, loginID, conn);
conn.Close();
}
return(count);
}
/// <summary>
/// 転送容量の取得
/// </summary>
/// <param name="groupId">グループid</param>
/// <param name="dtStart">開始日付</param>
/// <param name="dtEnd">終了日付</param>
/// <param name="tmStart">開始時間</param>
/// <param name="tmEnd">終了時間</param>
/// <param name="displayFlg">表示フラグ</param>
/// <param name="tranferLfg">0:転送中-完了両方；1:転送中のみ</param>
/// <param name="stateFlg">0:OK-NG両方；1:NGのみ</param>
/// <param name="logFlg">0:ログ表示；1:転送容量表示</param>
/// <returns></returns>
public IList <TransferLog> GetTransferLogListByProc(int pindex, int pagesize, string groupId, string dtStart, string dtEnd, string tmStart, string tmEnd, int displayFlg, int tranferFlg, int stateFlg, int logFlg, string name)
{
IList <TransferLog> LogList;
//groupId format: DBServerIP|group Id——2014-07-02 wjd modified
string DBServerIP = "";
string group = "";
if (groupId.Trim('|').IndexOf('|') > 0)
{
string[] array = groupId.Trim('|').Split('|');
DBServerIP = "'" + array[0] + "'";
group = array[1];
}
else
{
DBServerIP = Common.CommonUtil.GetLoginIPWithQuote();
group = groupId;
}
OdbcParameter[] parameters =
{
new OdbcParameter("@DBServerIP", DBServerIP),
new OdbcParameter("@groupId", group),
new OdbcParameter("@StartDate", dtStart),
new OdbcParameter("@EndDate", dtEnd),
new OdbcParameter("@StartTime", tmStart),
new OdbcParameter("@EndTime", tmEnd),
new OdbcParameter("@TranferFlg", tranferFlg),
new OdbcParameter("@StateFlg", stateFlg),
new OdbcParameter("@LogFlg", logFlg),
new OdbcParameter("@backupServerFileName", name),
new OdbcParameter("@Pindex", pindex),
new OdbcParameter("@Psize", pagesize)
};
OdbcConnection conn;
//2014-06-03 wjd modified
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
//sqlcommand ストアド実行方法
//LogList = TransferLogDal.GetTransferLogListByProc(conn, parameters, "sp_GetTranferList");
//odbccommand ストアド実行方法
LogList = TransferLogDal.GetTransferLogListByProc(conn, parameters, "{call sp_GetTransferList2(?,?,?,?,?,?,?,?,?,?,?,?)}");
conn.Close();
return(LogList);
}
}
/// <summary>
/// Get MonitorServerList from All DB
/// </summary>
/// 2014-06-04 wjd add
/// <returns></returns>
public IList <MonitorServer> GetMonitorServerListAll()
{
OdbcConnection conn;
IList <MonitorServer> MonitorServer;
IList <SearchCondition> condition = new List <SearchCondition>();
condition.Add(new SearchCondition {
con = "deleteFlg=?", param = "@deleteFlg", value = "0"
});
condition = CommonUtil.GetLoginIPCondition(condition);
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
MonitorServer = MonitorServerDal.GetMonitorServerAll(condition, conn);
conn.Close();
return(MonitorServer);
}
}
public IList <ManualBackupServer> GetManualBackupServerList()
{
OdbcConnection conn;
IList <ManualBackupServer> ManualBackupServer;
//add condition DBServerIP——2014-06-04 wjd modified
IList <SearchCondition> condition = new List <SearchCondition>();
condition.Add(new SearchCondition {
con = "deleteFlg=?", param = "@deleteFlg", value = "0"
});
//condition = CommonUtil.GetLoginIPCondition(condition);
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
ManualBackupServer = ManualBackupServerDal.GetManualBackupServer(condition, conn);
conn.Close();
return(ManualBackupServer);
}
}
/// <summary>
/// Get lists from BackupServerGroup of the All DB
/// </summary>
/// 2014-06-04 wjd add
/// <returns></returns>
public IList <BackupServerGroup> GetBackupServerGroupListAll()
{
OdbcConnection conn;
IList <BackupServerGroup> BackupServerGroup;
IList <SearchCondition> condition = new List <SearchCondition>();
condition.Add(new SearchCondition {
con = "deleteFlg=?", param = "@deleteFlg", value = "0"
});
condition = CommonUtil.GetLoginIPCondition(condition);
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
BackupServerGroup = BackupServerGroupDal.GetBackupServerGroupAll(condition, conn);
conn.Close();
return(BackupServerGroup);
}
}
public ManualBackupServer GetManualBackupServerById(int BackupServerId)
{
OdbcConnection conn;
IList <ManualBackupServer> ManualBackupServer;
//add condition DBServerIP——2014-06-04 wjd modified
IList <SearchCondition> condition = new List <SearchCondition>();
condition.Add(new SearchCondition {
con = "id=?", param = "@id", value = BackupServerId.ToString()
});
//condition = CommonUtil.GetLoginIPCondition(condition);
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
ManualBackupServer = ManualBackupServerDal.GetManualBackupServer(condition, conn);
if (ManualBackupServer.Count > 0)
{
return(ManualBackupServer[0]);
}
conn.Close();
return(null);
}
}
public IList <MonitorFileListen> GetMonitorFileListenListByPage(string fileName, string monitorServerId, string dirname, int pindex, int psize)
{
OdbcConnection conn;
IList <MonitorFileListen> MonitorFileListen;
//simplify sql——2014-07-03 wjd modified
string where = "";//deleteFlg = 0 AND monitorType<>'削除'
//monitorServerId format: DBServerIP|monitorServerId Id——2014-07-06 wjd modified
string DBServerIP = "";
string msId = "";
if (monitorServerId.Trim('|').IndexOf('|') > 0)
{
string[] array = monitorServerId.Trim('|').Split('|');
DBServerIP = "'" + array[0] + "'";
msId = array[1];
}
else
{
DBServerIP = Common.CommonUtil.GetLoginIPWithQuote();
msId = monitorServerId;
}
string sql = string.Empty;
//file or folder
if (fileName != "")
{
if (dirname == "0")
{
sql = @"select *,ROW_NUMBER() over(order by createDate) as row from MonitorFileListen ";
sql += " where monitorFileName like '%" + fileName + "%'";// AND monitorFileRelativeDirectory not like '%\\" + fileName + "%'
}
else
{
sql = @"select *,ROW_NUMBER() over(order by createDate) as row
from (select *,ROW_NUMBER() over (PARTITION by monitorFileRelativeDirectory order by monitorFileRelativeDirectory) rowno FROM MonitorFileListen ";
sql += "where monitorFileRelativeDirectory like '%\\" + fileName + "%'";// id IN(select min(id) from (SELECT min(id) as id,min(CHARINDEX('\\" + fileName + "', monitorFileRelativeDirectory)) AS patindexs FROM monitorFileListen where deleteFlg=0 and monitorType<>'削除' group by monitorFileRelativeDirectory) as a group by a.patindexs) AND
}
sql += " AND ";
}
//one or all monitorServers
if (msId != "-1")
{
sql += " monitorServerID = " + msId + " AND ";
}
//add condition DBServerIP——2014-06-04 wjd modified
sql += " DBServerIP in (" + DBServerIP + ") ";
if (dirname == "1")
{
sql += " ) as b where rowno=1 ";
}
using (conn = OdbcHelper.CreateConntionAll())
{
conn.Open();
MonitorFileListen = MonitorFileListenDal.GetMonitorFileListenPage(sql, pindex, psize, conn);
conn.Close();
return(MonitorFileListen);
}
}