/// <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); }