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; }
public RepositoryADO(string name, string primarykey, SqlConnection conn, int gINTProjectId) { _table = new dsTable <TEntity>(name, conn, gINTProjectId); _primarykey = primarykey; }
public RepositoryADO(string name, string primarykey, SqlConnection conn) { _table = new dsTable <TEntity>(name, conn); _primarykey = primarykey; }
public RepositoryADO(dsTable <TEntity> t) { _table = t; }