public static void SaveAV(AV av, JavLibraryLog _logger)
{
var pool = ConnectionPool.getPool();
try
{
mycon = pool.getConnection();
var sql = string.Format("insert into av values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', {8}, '{9}', '{10}', '{11}')", av.ID.Trim(), av.Name.Trim(), av.Company.Trim(), av.Directory.Trim(), av.Publisher.Trim(), av.Category.Trim(), av.Actress.Trim(), av.ReleaseDate, av.AvLength, av.CreateTime, av.PictureURL, av.URL);
ExecuteQuery(sql);
pool.closeConnection(mycon);
Console.WriteLine(string.Format("Save AV {0} success", av.ID));
_logger.WriteLog("download", string.Format("Save AV {0} success", av.ID));
UpdateScanURL(av.URL, _logger);
}
catch (Exception e)
{
pool.closeConnection(mycon);
_logger.WriteExceptionLog("", string.Format("Save AV {0} failed, {1}", av.ID, e.ToString()));
Console.WriteLine(string.Format("Save AV {0} failed, {1}", av.ID, e.ToString()));
}
}
public static void WriteLog(JavLibraryLog log)
{
var pool = ConnectionPool.getPool();
try
{
mycon = pool.getConnection();
var sql = string.Format("Insert into JavLibraryLog values ('{0}', '{1}', '{2}', {3}, '{4}', {5})", log.Logger.Trim(), log.URL.Trim(), log.Content.Trim(), log.IsException == true ? 1 : 0, DateTime.Now, log.BatchID);
ExecuteQuery(sql);
pool.closeConnection(mycon);
}
catch (Exception e)
{
pool.closeConnection(mycon);
}
}
public static int WriteSecondTry(JavLibraryLog log)
{
var sql = @"INSERT INTO SecondTry (Logger, URL, CreateTime)
VALUES (@logger, @url, @createTime)";
SqlParameter[] paras =
{
new SqlParameter("@logger", SqlDbType.NVarChar, 100),
new SqlParameter("@url", SqlDbType.NVarChar, 1000),
new SqlParameter("@createTime", SqlDbType.DateTime)
};
paras[0].Value = log.Logger;
paras[1].Value = log.URL;
paras[2].Value = log.CreateTime;
return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, paras));
}
public static void UpdateScanURL(string url, JavLibraryLog _logger)
{
var pool = ConnectionPool.getPool();
try
{
mycon = pool.getConnection();
var sql = string.Format("update scanurl set isdownload = 1 where url = '{0}'", url);
ExecuteQuery(sql);
pool.closeConnection(mycon);
Console.WriteLine(string.Format("Update ScanUrl {0} success", url));
_logger.WriteLog("update", string.Format("Update ScanUrl {0} success", url));
}
catch (Exception e)
{
pool.closeConnection(mycon);
_logger.WriteExceptionLog("", string.Format("Update ScanUrl {0} failed, {1}", url, e.ToString()));
Console.WriteLine(string.Format("Update ScanUrl {0} failed, {1}", url, e.ToString()));
}
}
public static int WriteLog(JavLibraryLog log)
{
var sql = @"INSERT INTO JavLibraryLog (Logger, URL, Content, IsException, CreateTime, BatchID)
VALUES (@logger, @url, @content, @isException, @createTime, @batchId)";
SqlParameter[] paras =
{
new SqlParameter("@logger", SqlDbType.NVarChar, 100),
new SqlParameter("@url", SqlDbType.NVarChar, 1000),
new SqlParameter("@content", SqlDbType.NVarChar, 4000),
new SqlParameter("@isException", SqlDbType.Int),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@batchId", SqlDbType.Int),
};
paras[0].Value = log.Logger;
paras[1].Value = log.URL;
paras[2].Value = log.Content;
paras[3].Value = log.IsException;
paras[4].Value = log.CreateTime;
paras[5].Value = log.BatchID;
return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql, paras));
}
public static void WriteLog(JavLibraryLog log)
{
DataBaseHelper.DataBaseManager.WriteLog(log);
}
public static void SaveScanUrl(ScanURL scanUrl, string page, int totalPage, int currentPage, int total, JavLibraryLog _logger)
{
var pool = ConnectionPool.getPool();
try
{
mycon = pool.getConnection();
var sql = string.Format("Insert into ScanURL values ('{0}', '{1}', '{2}', '{3}', {4}, '{5}')", scanUrl.Category.Trim(), scanUrl.URL.Trim(), scanUrl.ID.Trim(), scanUrl.Title.Trim(), scanUrl.IsDownload == true ? 1 : 0, scanUrl.CreateTime);
ExecuteQuery(sql);
pool.closeConnection(mycon);
Console.WriteLine("Processing {0} - {1} - {2}/{3} - {4}/{5} success", scanUrl.Title, scanUrl.Category, page, totalPage, currentPage, total);
_logger.WriteLog(scanUrl.URL, string.Format("Save ScanURL {0} success", scanUrl.Title));
}
catch (Exception e)
{
pool.closeConnection(mycon);
var ts = e.ToString();
if (e.ToString().Contains("Error Number:2601"))
{
Console.WriteLine("Processing {0} - {1} - {2}/{3} - {4}/{5} successfailed duplicated", scanUrl.Title, scanUrl.Category, page, totalPage, currentPage, total);
_logger.WriteExceptionLog(scanUrl.URL, string.Format("Save ScanURL {0} failed duplicated", scanUrl.Title));
}
else
{
Console.WriteLine(e.ToString());
_logger.WriteExceptionLog(scanUrl.URL, string.Format("Save ScanURL {0} falied {1}", scanUrl.Title, e.ToString()));
}
}
}
