/// <summary>
/// 执行脚本
/// </summary>
/// <param name="scriptPath"></param>
public static void ExcuteScript(string scriptPath)
{
// 遍历所有的脚本文件
string[] fileList = System.IO.Directory.GetFiles(scriptPath);
foreach (string file in fileList)
{
if (Path.GetExtension(file).ToLower() != ".sql")
{
continue;
}
FileStream fileStream = new FileStream(file, FileMode.Open);
StreamReader streamReader = new StreamReader(fileStream, Encoding.Default);
string cmdText = streamReader.ReadToEnd();
streamReader.Close();
fileStream.Close();
if (cmdText.Trim().Length == 0)
{
continue;
}
//执行脚本
UpdScriptDao.ExcuteScript(cmdText);
}
}
/// <summary>
/// 更新版本号
/// </summary>
/// <param name="model"></param>
public static void UpdateParam(ParamModel model)
{
UpdScriptDao.UpdateParam(model);
}
/// <summary>
/// 插入版本号
/// </summary>
/// <param name="model"></param>
public static void InsertParam(ParamModel model)
{
UpdScriptDao.InsertParam(model);
}
/// <summary>
/// 获取版本号
/// </summary>
/// <param name="model"></param>
public static ParamModel GetParamByCode(string paramCode)
{
return(UpdScriptDao.GetParamByCode(paramCode));
}
/// <summary>
/// 连接数据库
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
public static void ChkConnectSetting()
{
UpdScriptDao.ChkConnectSetting();
}