/// <summary>
/// Thông tin về các giá trị chung
/// </summary>
/// <returns></returns>
private int getGlobalParameter()
{
int ret = 0;
SYSTEMPARAMETER_BUS bus = new SYSTEMPARAMETER_BUS();
ret = bus.loadParameter();
bus.CloseConnection();
return(ret);
}
int doUpate(string thefile)
{
SYSTEMPARAMETER_BUS bus = new SYSTEMPARAMETER_BUS();
string filename = basepath + "sqlupdate\\" + thefile;
FileInfo file = new FileInfo(filename);
StreamReader filereader = file.OpenText();
string script = filereader.ReadToEnd();
filereader.Close();
filereader.Dispose();
string[] ir = new string[] { "GO\t", "GO ", "GO\r\n", "\r\nGO" };
string[] ac = script.Split(ir, StringSplitOptions.RemoveEmptyEntries);
int ret = 0;
ret = bus.BeginTransaction();
string sql;
foreach (string i in ac)
{
if (ret >= 0 && (!string.IsNullOrWhiteSpace(i)))
{
sql = i;
//sql = i.Replace("\r\n", " ");
//sql = sql.Replace("\\r\\n", " ");
//sql = sql.Replace("\t", " ");
//sql = sql.Replace("\\t", " ");
ret = bus.doSql(sql);
if (ret < 0)
{
break;
}
}
}
if (ret >= 0)
{
bus.CommitTransaction();
}
else
{
bus.RollbackTransaction();
}
bus.CloseConnection();
return(ret);
}
