Esempio n. 1
0
        private string getAGS404Table(dsTable <MOND> ds)
        {
            string table_name     = "\"GROUP\",\"MOND\"";
            string table_headings = "\"HEADING\",\"LOCA_ID\",\"MONG_ID\",\"MONG_DIS\",\"MOND_DTIM\",\"MOND_TYPE\",\"MOND_REF\",\"MOND_INST\",\"MOND_RDNG\",\"MOND_UNIT\",\"MOND_METH\",\"MOND_LIM\",\"MOND_ULIM\",\"MOND_NAME\",\"MOND_CRED\",\"MOND_CONT\",\"MOND_REM\",\"FILE_FSET\"";
            string table_units    = "\"UNIT\",\"\",\"\",\"m\",\"yyyy-mm-ddThh:mm:ss\",\"m\",\"\",\"\",\"m\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"";
            string table_types    = "\"TYPE\",\"ID\",\"X\",\"2DP\",\"DT\",\"PA\",\"X\",\"X\",\"XN\",\"PU\",\"X\",\"U\",\"U\",\"X\",\"X\",\"X\",\"X\",\"X\"";

            StringBuilder sb = new StringBuilder();

            sb.Append(table_name);
            sb.AppendLine();
            sb.Append(table_headings);
            sb.AppendLine();
            sb.Append(table_units);
            sb.AppendLine();
            sb.Append(table_types);
            sb.AppendLine();

            if (ds.tableName == "MOND")
            {
                foreach (DataRow item in ds.dataTable.Rows)
                {
                    string line = "\"DATA\",\"" + item["PointId"] + "\",\"" + item["ItemKey"] + "\",\"" + item["MONG_DIS"] + "\",\"" + Convert.ToDateTime(item["DateTime"]).ToString(DATE_FORMAT_AGS) + "\",\"" + item["MOND_TYPE"] + "\",\"" + item["MOND_REF"] + "\",\"" + item["MOND_INST"] + "\",\"" + item["MOND_RDNG"] + "\",\"" + item["MOND_UNIT"] + "\",\"" + item["MOND_METH"] + "\",\"" + item["MOND_LIM"] + "\",\"" + item["MOND_ULIM"] + "\",\"" + item["MOND_NAME"] + "\",\"" + item["MOND_CRED"] + "\",\"" + item["MOND_CONT"] + "\",\"" + item["MOND_REM"] + "\",\"" + item["FILE_FSET"] + "\"";
                    sb.Append(line);
                    sb.AppendLine();
                }
            }

            return(sb.ToString());
        }
 public RepositoryADOParentChild(string parentTable,
                                 string parentKeyField,
                                 string childTable,
                                 string childForeignKeyField,
                                 SqlConnection conn)
 {
     _parent               = new dsTable <TParent>(parentTable, conn);
     _parentKeyField       = parentKeyField;
     _child                = new dsTable <TChild>(childTable, conn);
     _childForeignKeyField = childForeignKeyField;
 }
 public LoggerFileRepositoryADO(dsTable <ge_log_file> log_file, dsTable <ge_log_reading> log_reading)
     : base(log_file, log_reading)
 {
 }
 public RepositoryADOParentChild(dsTable <TParent> p, dsTable <TChild> c)
 {
     _parent = p;
     _child  = c;
 }
Esempio n. 5
0
 public RepositoryADO(string name, string primarykey, SqlConnection conn, int gINTProjectId)
 {
     _table      = new dsTable <TEntity>(name, conn, gINTProjectId);
     _primarykey = primarykey;
 }
Esempio n. 6
0
 public RepositoryADO(string name, string primarykey, SqlConnection conn)
 {
     _table      = new dsTable <TEntity>(name, conn);
     _primarykey = primarykey;
 }
Esempio n. 7
0
 public RepositoryADO(dsTable <TEntity> t)
 {
     _table = t;
 }