public void CreateCachData() { DataSet ds = JCBase.Utility.Util.DsCach; using (OleDbConnection conn = new OleDbConnection(_dao.GetConnString())) { conn.Open(); DataTable tb = conn.GetSchema("Tables"); Parallel.ForEach(tb.AsEnumerable(), new ParallelOptions { MaxDegreeOfParallelism = Environment.ProcessorCount }, row => { string tableName = row["table_name"].ToString(); if (!ds.Tables.Contains(tableName)) { if (tableName.IndexOf("MSys") == -1 && tableName.IndexOf("~TMP") == -1) { DataTable t = _dao.GetDataTable("select * from " + tableName); t.TableName = tableName; ds.Tables.Add(t); } } }); //foreach (DataRow row in tb.Rows) //{ // string tableName = row["table_name"].ToString(); // if (tableName.IndexOf("MSys") == -1 && tableName.IndexOf("~TMP") == -1) // { // DataTable t = _dao.GetDataTable("select * from " + tableName); // t.TableName = tableName; // ds.Tables.Add(t); // } //} } if (!ds.Tables.Contains("T_PipingKitTable") || ds.Tables["T_PipingKitTable"] == null) { DataTable tb = new DataTable(); tb.Columns.Add("Type"); tb.Columns.Add("System"); tb.Columns.Add("Model"); tb.Columns.Add("Qty"); tb.Columns.Add("Id"); tb.TableName = "T_PipingKitTable"; ds.Tables.Add(tb); //DataRow row = tb.NewRow(); //row["Type"] = "PipingConnectionKit"; //row["System"] = "H1"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "PipingConnectionKit"; //row["System"] = "H1"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "BranchKit"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "BranchKit"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "BranchKit"; //row["System"] = "H2"; //row["Model"] = "H2"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "BranchKit"; //row["System"] = "H2"; //row["Model"] = "H2"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "CHBox"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "CHBox"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "CHBox"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); //row = tb.NewRow(); //row["Type"] = "CHBox"; //row["System"] = "H2"; //row["Model"] = "H1"; //row["Qty"] = "0"; //tb.Rows.Add(row); } }