public int updateAll(string _basepath) { basepath = _basepath; localcommonlib com = new localcommonlib(); int ret = 0; SYSTEMPARAMETER_BUS bus = new SYSTEMPARAMETER_BUS(); SYSTEMPARAMETER_OBJ obj = bus.GetByKey(new fieldpara("CODEVIEW", "VERSION")); if (obj == null) { obj = new SYSTEMPARAMETER_OBJ(); obj.UNIVERSITYCODE = "HVKTQS"; obj.CODEVIEW = "VERSION"; obj.NAME = "Phiên bản"; obj.VALUE = "0"; } int version = 0; version = com.convert2Int(obj.VALUE, 0); int thenext = 20; if (ret >= 0 && version < thenext) { ret = doUpate("20171128_ver20.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 21; if (ret >= 0 && version < thenext) { ret = doUpate("20171129_ver21.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 22; if (ret >= 0 && version < thenext) { ret = doUpate("20171130_ver22.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 23; if (ret >= 0 && version < thenext) { ret = doUpate("20171205_ver23.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 24; if (ret >= 0 && version < thenext) { ret = doUpate("20171205_ver24.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 25; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver25.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 26; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver26.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 27; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver27.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 28; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver28.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 29; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver29.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 30; if (ret >= 0 && version < thenext) { ret = doUpate("20171206_ver30.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 31; if (ret >= 0 && version < thenext) { ret = doUpate("20171208_ver31.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 32; if (ret >= 0 && version < thenext) { ret = doUpate("20171209_ver32.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 33; if (ret >= 0 && version < thenext) { ret = doUpate("20171212_ver33.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 34; if (ret >= 0 && version < thenext) { ret = doUpate("20171218_ver34.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 35; if (ret >= 0 && version < thenext) { ret = doUpate("20171218_ver35.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 36; if (ret >= 0 && version < thenext) { ret = doUpate("20171218_ver36.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 37; if (ret >= 0 && version < thenext) { ret = doUpate("20171221_ver37.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 38; if (ret >= 0 && version < thenext) { ret = doUpate("20171221_ver38.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 39; if (ret >= 0 && version < thenext) { ret = doUpate("20171224_ver39.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 40; if (ret >= 0 && version < thenext) { ret = doUpate("20171225_ver40.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 41; if (ret >= 0 && version < thenext) { ret = doUpate("20171226_ver41.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 42; if (ret >= 0 && version < thenext) { ret = doUpate("20171226_ver42.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 43; if (ret >= 0 && version < thenext) { ret = doUpate("20180102_ver43.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 44; if (ret >= 0 && version < thenext) { ret = doUpate("20180102_ver44.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 45; if (ret >= 0 && version < thenext) { ret = doUpate("20180102_ver45.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 46; if (ret >= 0 && version < thenext) { ret = doUpate("20180102_ver46.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 47; if (ret >= 0 && version < thenext) { ret = doUpate("20180103_ver47.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 48; if (ret >= 0 && version < thenext) { ret = doUpate("20180105_ver48.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } thenext = 49; if (ret >= 0 && version < thenext) { ret = doUpate("20180105_ver49.sql"); if (ret >= 0) { obj.VALUE = thenext.ToString(); } } int ret2 = 0; if (string.IsNullOrEmpty(obj.CODE)) { //thêm mới obj.CODE = bus.genNextCode(obj); ret2 = bus.Insert(obj); } else { //cập nhật obj._ID.CODE = obj.CODE; ret2 = bus.Update(obj); } return(ret2); }