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