private void btnCheckSQL_Click(object sender, EventArgs e)
{
//遍历文件夹下的所有文件
int conStrId = ((ConStrInfo)cbDatabase.SelectedItem).ID;
var strModel = new ConStrDao().GetModel(conStrId);
string conStr = strModel.ConStrContent;
var dBFileInfo = new DatabaseDao().GetFileInfo(conStrId);
string dbCurrentName = dBFileInfo.Name;
string sqlDBName = tbDBReplaceDBName.Text;
string folderPath = tbFolderPath.Text;
DirectoryInfo theFolder = new DirectoryInfo(folderPath);
foreach (FileInfo file in theFolder.GetFiles().OrderBy(m => m.Name))
{
FileStream fileStream = file.OpenRead();
StreamReader streamReader = new StreamReader(fileStream);
string strFirstLine = streamReader.ReadLine();
//string strSQL = streamReader.ReadToEnd().ToString();
string strOtherLine = streamReader.ReadToEnd().ToString();
//string strOtherLine = strSQL.Substring(0, strFirstLine.Length);
if (strFirstLine.IndexOf(sqlDBName) < 0)
{
rtbResultContent.Text = rtbResultContent.Text + file.Name + "[数据库名称不一致]" + Environment.NewLine;
break;
}
else
{
strFirstLine = strFirstLine.Replace(sqlDBName, dbCurrentName) + Environment.NewLine;
string strSQL = strFirstLine + strOtherLine;
string resultCheck = SqlHelper.ValidateSQL(conStr, strSQL.Split("GO".ToCharArray()));
try
{
SqlHelper.ExecuteNonQuery(conStr, CommandType.Text, strSQL);
}
catch (Exception ex)
{
string aa = ex.Message;
}
if (resultCheck == "OK")
{
rtbResultContent.Text = rtbResultContent.Text + file.Name + "[成功]" + Environment.NewLine;
}
else
{
rtbResultContent.Text = rtbResultContent.Text + file.Name + "[失败]" + Environment.NewLine + resultCheck;
break;
}
}
}
}
public static void Reset()
{
_dataApi = null;
_administratorDao = null;
_administratorsInRolesDao = null;
_areaDao = null;
_channelDao = null;
_channelGroupDao = null;
_configDao = null;
_contentCheckDao = null;
_contentDao = null;
_contentGroupDao = null;
_countDao = null;
_databaseDao = null;
_dbCacheDao = null;
_departmentDao = null;
_errorLogDao = null;
_keywordDao = null;
_logDao = null;
_permissionsInRolesDao = null;
_pluginConfigDao = null;
_pluginDao = null;
_recordDao = null;
_relatedFieldDao = null;
_relatedFieldItemDao = null;
_roleDao = null;
_siteDao = null;
_siteLogDao = null;
_sitePermissionsDao = null;
_specialDao = null;
_tableDao = null;
_tableMatchDao = null;
_tableMetadataDao = null;
_tableStyleDao = null;
_tableStyleItemDao = null;
_tagDao = null;
_templateDao = null;
_templateLogDao = null;
_templateMatchDao = null;
_userDao = null;
_userLogDao = null;
}
public static void Reset()
{
_databaseApi = null;
_accessTokenDao = null;
_administratorDao = null;
_administratorsInRolesDao = null;
_channelDao = null;
_channelGroupDao = null;
_configDao = null;
_contentCheckDao = null;
_contentDao = null;
_contentGroupDao = null;
_databaseDao = null;
_dbCacheDao = null;
_errorLogDao = null;
_keywordDao = null;
_libraryGroupDao = null;
_libraryImageDao = null;
_libraryTextDao = null;
_logDao = null;
_permissionsInRolesDao = null;
_pluginConfigDao = null;
_pluginDao = null;
_relatedFieldDao = null;
_relatedFieldItemDao = null;
_roleDao = null;
_siteDao = null;
_siteLogDao = null;
_sitePermissionsDao = null;
_specialDao = null;
_tableStyleDao = null;
_tableStyleItemDao = null;
_tagDao = null;
_templateDao = null;
_templateLogDao = null;
_templateMatchDao = null;
_userDao = null;
_userGroupDao = null;
_userLogDao = null;
_userMenuDao = null;
}
