public List <FileUploadInfo> QueryFileUploadInfo(QueryConditionBase queryInfo)
{
int res = 0;
List <FileUploadInfo> tempFileUploadInfoList = new List <FileUploadInfo>();
String quserSql = GenerateQuerySql(queryInfo);
MySqlConnectHelper mysqlCnn = MySqlConnectPoolHelper.getPool().getConnection();
res = mysqlCnn.SelectDB(dbName);
MySqlDataReader dataReader = mysqlCnn.ExecuteReader(CommandType.Text, quserSql, null);
while (dataReader.Read())
{
FileUploadInfo tempFileUploadInfo = new FileUploadInfo();
tempFileUploadInfo.ID = (int)dataReader["ID"];
tempFileUploadInfo.DateTime = (string)dataReader["DateTime"];
tempFileUploadInfo.Content = (string)dataReader["Content"];
tempFileUploadInfo.UserName = (string)dataReader["UserName"];
string tempDeviceList = (string)dataReader["FilePathList"];
tempFileUploadInfo.FilePathList = tempDeviceList.Split(',');
tempFileUploadInfoList.Add(tempFileUploadInfo);
}
dataReader.Close();
MySqlConnectPoolHelper.getPool().closeConnection(mysqlCnn);
mysqlCnn = null;
return(tempFileUploadInfoList);
}
public bool DeleteFileUploadInfo(FileUploadInfo deleteFileUploadInfo)
{
int res = 0;
String deleteSql = $"delete from {tableName} where id={deleteFileUploadInfo.ID}";
MySqlConnectHelper mysqlCnn = MySqlConnectPoolHelper.getPool().getConnection();
res = mysqlCnn.SelectDB(dbName);
res = mysqlCnn.ExecuteNonQuery(CommandType.Text, deleteSql, null);
MySqlConnectPoolHelper.getPool().closeConnection(mysqlCnn);
mysqlCnn = null;
if (res > 0)
{
return(true);
}
return(false);
}
public bool InsertFileUploadInfo(FileUploadInfo newFileUploadInfo)
{
int res = 0;
String currentDate = DateTime.Now.ToLocalTime().ToString();
String FilePathList = string.Join(",", newFileUploadInfo.FilePathList);
String deleteSql = $"insert into {tableName} VALUES(NULL,'{currentDate}','{newFileUploadInfo.Content}','{newFileUploadInfo.UserName}','{FilePathList}')";
MySqlConnectHelper mysqlCnn = MySqlConnectPoolHelper.getPool().getConnection();
res = mysqlCnn.SelectDB(dbName);
res = mysqlCnn.ExecuteNonQuery(CommandType.Text, deleteSql, null);
MySqlConnectPoolHelper.getPool().closeConnection(mysqlCnn);
mysqlCnn = null;
if (res > 0)
{
return(true);
}
return(false);
}
