public static DOBarcodeOption load() { IDataReader reader = null; try { DataSet ds = HelpDB.getDatabase().LoadDataSet("SELECT * FROM FW_BARCODE WHERE ID = 1"); if (ds == null || ds.Tables.Count == 0) { if (DBScriptExec.RunStringSQLScript( @"CREATE TABLE FW_BARCODE ( ID A_BIG_ID NOT NULL /* A_BIG_ID = BIGINT */, COUNTRY A_STR_SHORT /* A_STR_SHORT = VARCHAR(100) */, PROVIDER A_STR_SHORT /* A_STR_SHORT = VARCHAR(100) */, PRODUCT A_STR_SHORT /* A_STR_SHORT = VARCHAR(100) */, STAMP_WIDTH A_DOUBLE /* A_DOUBLE = NUMERIC(15,2) default 0 */, STAMP_HEIGHT A_DOUBLE /* A_DOUBLE = NUMERIC(15,2) default 0 */, BARCODE_WIDTH A_DOUBLE /* A_DOUBLE = NUMERIC(15,2) default 0 */, BARCODE_HEIGHT A_DOUBLE /* A_DOUBLE = NUMERIC(15,2) default 0 */, BARCODE_MODULE A_DOUBLE /* A_DOUBLE = NUMERIC(15,2) default 0 */, UNIT_USING A_STR_MEDIUM /* A_STR_MEDIUM = VARCHAR(200) */, UNIT_POS A_INTEGER /* A_INTEGER = INTEGER */, UNIT_ALIGHT A_INTEGER /* A_INTEGER = INTEGER */, NAME_USING A_STR_MEDIUM /* A_STR_MEDIUM = VARCHAR(200) */, NAME_POS A_INTEGER /* A_INTEGER = INTEGER */, NAME_ALIGHT A_INTEGER /* A_INTEGER = INTEGER */, BARCODE_USING A_STR_MEDIUM /* A_STR_MEDIUM = VARCHAR(200) */, BARCODE_POS A_INTEGER /* A_INTEGER = INTEGER */, BARCODE_ALIGHT A_INTEGER /* A_INTEGER = INTEGER */, PRICE_USING A_STR_MEDIUM /* A_STR_MEDIUM = VARCHAR(200) */, PRICE_POS A_INTEGER /* A_INTEGER = INTEGER */, PRICE_ALIGHT A_INTEGER /* A_INTEGER = INTEGER */, SYM_BARCODE A_INTEGER /* A_INTEGER = INTEGER */, CHAR_NUMBER A_INTEGER /* A_INTEGER = INTEGER */, BARCODE_PARAM A_STR_MEDIUM /* A_STR_MEDIUM = VARCHAR(200) */ ); ALTER TABLE FW_BARCODE ADD CONSTRAINT PK_FW_BARCODE PRIMARY KEY (ID); ")) { if (DBScriptExec.RunStringSQLScript("INSERT INTO FW_BARCODE (ID, COUNTRY, PROVIDER, PRODUCT, STAMP_WIDTH, STAMP_HEIGHT, BARCODE_WIDTH, BARCODE_HEIGHT, BARCODE_MODULE, UNIT_USING, UNIT_POS, UNIT_ALIGHT, NAME_USING, NAME_POS, NAME_ALIGHT, BARCODE_USING, BARCODE_POS, BARCODE_ALIGHT, PRICE_USING, PRICE_POS, PRICE_ALIGHT, SYM_BARCODE, CHAR_NUMBER, BARCODE_PARAM) VALUES (1, '893', '111', '123456', 200, 120, 200, 50, 1, 'Y', 1, 0, 'Y', 2, 0, 'Y', 3, 0, 'Y', 4, 0, -1, 5, '');") == false) { return new DOBarcodeOption(); } } } reader = DatabaseFB.LoadRecord("FW_BARCODE", "ID", 1); using (reader) { if (reader.Read()) { DataTypeBuilder dt = new DataTypeBuilder(FIELD_MAP); return (DOBarcodeOption)dt.CreateFilledObjectExt(typeof(DOBarcodeOption), reader); } } } catch { } finally { if (reader != null) reader.Close(); } return new DOBarcodeOption(); }