public void AddClient(Client GW2Client) { if (!clientList.ContainsValue(GW2Client) && !clientList.ContainsKey(GW2Client.ID)) { clientList.Add(GW2Client.ID, GW2Client); } }
public static bool IsIsomorphic(string s, string t) { int size = s.Length; Dictionary <char, char> d = new System.Collections.Generic.Dictionary <char, char>(); for (int i = 0; i < size; i++) { if (d.ContainsKey(s[i])) { if (d[s[i]] != t[i]) { return(false); } } else { if (d.ContainsValue(t[i])) { return(false); } d.Add(s[i], t[i]); } } return(true); }
/*public TestCollections(int elements) * { * people = new List<Person>(elements); * vs = new List<string>(elements); * pairs = new Dictionary<Person, GraduateStudent>(elements); * keys = new Dictionary<string, GraduateStudent>(elements); * for (int i = 0; i < elements; i++) * { * GraduateStudent grs1 = Generator(i); * } * }*/ public string Search(int index) { string result = ""; bool cont; GraduateStudent graduate = new GraduateStudent(); graduate.Name = index.ToString(); Person p = (Person)graduate; //graduate.Name += string.Format(" #{0}", index); // graduate = Generator(index); //Person p = (Person)graduate; Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); cont = people.Contains(graduate.Person); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в списке List<Person> составило: {0}\n", stopwatch.Elapsed); stopwatch.Restart(); cont = vs.Contains(graduate.ToString()); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в списке List<string> составило: {0}\n", stopwatch.Elapsed); stopwatch.Restart(); cont = pairs.ContainsKey(graduate.Person); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в словаре Dictionary<Person, GraduateStudent> по ключу составило: {0}\n", stopwatch.Elapsed); stopwatch.Restart(); cont = pairs.ContainsValue(graduate); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в словаре Dictionary<Person, GraduateStudent> по значению составило: {0}\n", stopwatch.Elapsed); stopwatch.Restart(); cont = keys.ContainsKey(graduate.ToString()); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в словаре Dictionary<string, GraduateStudent> по ключу составило: {0}\n", stopwatch.Elapsed); stopwatch.Restart(); cont = keys.ContainsValue(graduate); Console.WriteLine(cont); stopwatch.Stop(); result = result + String.Format("Время поиска в словаре Dictionary<string, GraduateStudent> по значению составило: {0}\n", stopwatch.Elapsed); return(result); }
public string SearchTime(int num) { string answ = null; Student st = new Student(); Person p = (Person)st; p.NM = num.ToString(); bool yn; Stopwatch t = new Stopwatch(); //1 t.Start(); yn = list1.Contains(st.P); t.Stop(); Console.WriteLine(yn); answ = "For <Pesron>list passed:" + t.Elapsed + "\n"; //2 t.Restart(); yn = list2.Contains(st.ToString()); t.Stop(); Console.WriteLine(yn); answ += "For <string>list passed " + t.Elapsed + "\n"; //3 t.Restart(); yn = dict1.ContainsKey(st.P); t.Stop(); Console.WriteLine(yn); answ += "For <Person, Student>list by key passed " + t.Elapsed + "\n"; //4 t.Restart(); yn = dict2.ContainsKey(st.ToString()); t.Stop(); Console.WriteLine(yn); answ += "For <string, Student>list by key passed " + t.Elapsed + "\n"; //5 t.Restart(); yn = dict1.ContainsValue(st); t.Stop(); Console.WriteLine(yn); answ += "For <Person, Student>list by value passed " + t.Elapsed + "\n"; //6 t.Restart(); yn = dict2.ContainsValue(st); t.Stop(); Console.WriteLine(yn); answ += "For <string, Student>list by value passed " + t.Elapsed + "\n"; return(answ); }
static int _m_ContainsValue(RealStatePtr L) { ObjectTranslator translator = ObjectTranslatorPool.Instance.Find(L); System.Collections.Generic.Dictionary <int, object> __cl_gen_to_be_invoked = (System.Collections.Generic.Dictionary <int, object>)translator.FastGetCSObj(L, 1); try { { object value = translator.GetObject(L, 2, typeof(object)); bool __cl_gen_ret = __cl_gen_to_be_invoked.ContainsValue(value); LuaAPI.lua_pushboolean(L, __cl_gen_ret); return(1); } } catch (System.Exception __gen_e) { return(LuaAPI.luaL_error(L, "c# exception:" + __gen_e)); } }
private void button6_Click(object sender, EventArgs e) { Dictionary <string, int> population = new System.Collections.Generic.Dictionary <string, int>(); population.Clear(); population.Add("Russia", 1707); population.Add("Candana", 233); population.Add("China", 960); population.Add("America", 122); population.Add("Brazil", 854); population.Remove("Candana"); int cnt = population.Count; bool hasKey = population.ContainsKey("China"); bool hasValue = population.ContainsValue(850); foreach (KeyValuePair <string, int> kvp in population) { MessageBox.Show(kvp.Key + kvp.Value); } //遍历所有键名 foreach (string key in population.Keys) { MessageBox.Show(key); } //遍历所有值 foreach (int val in population.Values) { MessageBox.Show(val.ToString()); } }
public bool ContainsStudent(Student st) { return(dict.ContainsValue(st)); }
public bool ImportTextToDataTableUsingKeys(string rawImportText, DataTable destinationTable, char[] rowDelimiters, char[] columnDelimiters, out int badRows, out int missingRows, LookupTables lookupTables, AppSettings appSettings) { string replacementTextForEmbeddedNewLines = "<br>"; if (!string.IsNullOrEmpty(appSettings.GetAppSettingValue("GrinGlobalClient_replacementTextForEmbeddedNewLines"))) { replacementTextForEmbeddedNewLines = appSettings.GetAppSettingValue("GrinGlobalClient_replacementTextForEmbeddedNewLines"); } string scrubbedRawImportText = ""; // Attempting to remove new lines with no matching carriage return (ex. \n with no leading \r) and vice versa (ex. \r with no trailing \n)... // First protect the well-formed carriage return line feed (\r\n) by temp. removing it and substituting a placeholder (to aid in weeding out lone \n and \r)... scrubbedRawImportText = rawImportText.Replace("\r\n", "***well-formed carriage return line feed***").Replace("\n\r", "***well-formed carriage return line feed***"); // Now remove any remaining lone \n or \r that cannot be processed properly... scrubbedRawImportText = scrubbedRawImportText.Replace("\r", replacementTextForEmbeddedNewLines).Replace("\n", replacementTextForEmbeddedNewLines); // Next return the well-formed carriage return line feeds back where they belong... scrubbedRawImportText = scrubbedRawImportText.Replace("***well-formed carriage return line feed***", "\r\n"); //string[] rawImportRows = rawImportText.Split(rowDelimiters, StringSplitOptions.RemoveEmptyEntries); string[] rawImportRows = scrubbedRawImportText.Split(rowDelimiters, StringSplitOptions.RemoveEmptyEntries); string[] uniqueKeyColumnNames = null; bool primaryKeyFound = false; System.Collections.Generic.List<DataColumn> uniqueKeys = new System.Collections.Generic.List<DataColumn>(); bool processedImportSuccessfully = false; badRows = 0; missingRows = 0; // Make sure there is text to process - if not bail out now... if (rawImportRows == null || rawImportRows.Length <= 0) return false; // Begin looking for a row of raw text that contains the column headers for the destination datatable... // This is a 2 phase approach that first looks for a row that contains all of the primary key column names // But if that is not found - try again to find a row of raw text that contains all of the column names for the unique compound key int columnHeaderRowIndex = -1; // PHASE 1: // Look for a raw text line that contains the full text name of the primary key columns (they must all be on the same line of raw text)... if (destinationTable.PrimaryKey.Length > 0) { // Look through all of the rows of raw text for a single row that contains all of the primary key column names for (int i = 0; i < rawImportRows.Length && columnHeaderRowIndex == -1; i++) { columnHeaderRowIndex = i; // Start out ASSUMING this is the 'right' row... foreach (DataColumn pKeyColumn in destinationTable.PrimaryKey) { if (!FindText(GetFriendlyFieldName(pKeyColumn, pKeyColumn.ColumnName), rawImportRows[i], false, rowDelimiters, columnDelimiters)) { // If the column header was not matched using case sensitive - try matching again (case insensitive)... if (!FindText(GetFriendlyFieldName(pKeyColumn, pKeyColumn.ColumnName), rawImportRows[i], true, rowDelimiters, columnDelimiters)) { // If the column header was still not matched - try the raw table field name... if (!FindText(pKeyColumn.ColumnName, rawImportRows[i], true, rowDelimiters, columnDelimiters)) { // The ASSUMPTION was wrong because the header text for one of the required primary key columns is missing in this raw text row... columnHeaderRowIndex = -1; } } } } } if (columnHeaderRowIndex != -1) primaryKeyFound = true; // Check to see if we need to move on to PHASE 2... if (!primaryKeyFound) { // PHASE 2: // Didn't find the primary key column in any text row in the import data - so try again, but this time looking for the alternate unique key... if (destinationTable.PrimaryKey[0].ExtendedProperties.Contains("alternate_key_fields") && destinationTable.PrimaryKey[0].ExtendedProperties["alternate_key_fields"].ToString().Length > 0) { uniqueKeyColumnNames = destinationTable.PrimaryKey[0].ExtendedProperties["alternate_key_fields"].ToString().Split(','); // Make sure the destination datatable has all of the columns specified in the alternate_key_fields ext. prop... foreach (string uniqueColumnName in uniqueKeyColumnNames) { if (destinationTable.Columns.Contains(uniqueColumnName.Trim().ToLower())) { uniqueKeys.Add(destinationTable.Columns[uniqueColumnName.Trim().ToLower()]); } } // The destination datatable does not have all of the columns specified in the compound unique key so bail out now... if (uniqueKeys.Count != uniqueKeyColumnNames.Length) return false; // Look through all of the rows of raw text for a single row that contains all of the unique key column names for (int i = 0; i < rawImportRows.Length && columnHeaderRowIndex == -1; i++) { columnHeaderRowIndex = i; // Start out assuming the row has all of the unique key column headers... foreach (DataColumn uKeyColumn in uniqueKeys) { if (!FindText(GetFriendlyFieldName(uKeyColumn, uKeyColumn.ColumnName), rawImportRows[i], false, rowDelimiters, columnDelimiters)) { // If the column header was not matched using case sensitive - try matching again (case insensitive)... if (!FindText(GetFriendlyFieldName(uKeyColumn, uKeyColumn.ColumnName), rawImportRows[i], true, rowDelimiters, columnDelimiters)) { // If the column header was still not matched - try the raw table field name... if (!FindText(uKeyColumn.ColumnName, rawImportRows[i], true, rowDelimiters, columnDelimiters)) { // The ASSUMPTION was wrong because the header text for one of the required unique key columns is missing in this raw text row... columnHeaderRowIndex = -1; } } } } } } } // Check to see if a column header was found for the psuedo-primary key of the destinationTable... if (columnHeaderRowIndex == -1) { // Still cannot find an import row with column text that contains a collection of unique key columns - ask the user if they want to bail out now... string uniqueKeyColumnFriendlyNames = ""; foreach (DataColumn dc in uniqueKeys) { uniqueKeyColumnFriendlyNames += GetFriendlyFieldName(dc, dc.ColumnName) + ", "; } uniqueKeyColumnFriendlyNames = uniqueKeyColumnFriendlyNames.Trim().TrimEnd(','); //SharedUtils sharedUtils = new SharedUtils(lookupTables.WebServiceURL, lookupTables.Username, lookupTables.Password_ClearText, true); SharedUtils sharedUtils = new SharedUtils(_webServices.Url, _webServices.Username, _webServices.Password_ClearText, true, ""); GRINGlobal.Client.Common.GGMessageBox ggMessageBox = new GRINGlobal.Client.Common.GGMessageBox("WARNING!!! You are pasting data in to this dataview without column headers that include: \n 1) The primary key column ({0}) OR \n 2) A combination of all of the columns ({1}) that will uniquely identify a single record in this dataview.\n\nWould you like to paste the data directly to the dataview starting at the selected cell?", "Missing Columns", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button1); ggMessageBox.Name = "UserInterfaceUtils_ImportTextToDataTableUsingKeysMessage1"; if (sharedUtils != null && sharedUtils.IsConnected) sharedUtils.UpdateControls(ggMessageBox.Controls, ggMessageBox.Name); //if (ggMessageBox.MessageText.Contains("{0}") && // ggMessageBox.MessageText.Contains("{1}")) //{ // ggMessageBox.MessageText = string.Format(ggMessageBox.MessageText, GetFriendlyFieldName(destinationTable.PrimaryKey[0], destinationTable.PrimaryKey[0].ColumnName), uniqueKeyColumnFriendlyNames); //} //else if (ggMessageBox.MessageText.Contains("{0}")) //{ // ggMessageBox.MessageText = string.Format(ggMessageBox.MessageText, GetFriendlyFieldName(destinationTable.PrimaryKey[0], destinationTable.PrimaryKey[0].ColumnName)); //} //else if (ggMessageBox.MessageText.Contains("{1}")) //{ // ggMessageBox.MessageText = string.Format(ggMessageBox.MessageText, uniqueKeyColumnFriendlyNames); //} string[] argsArray = new string[100]; argsArray[0] = GetFriendlyFieldName(destinationTable.PrimaryKey[0], destinationTable.PrimaryKey[0].ColumnName); argsArray[1] = uniqueKeyColumnFriendlyNames; ggMessageBox.MessageText = string.Format(ggMessageBox.MessageText, argsArray); // Ask the user if they wish to perform a 'block paste' of the data... if (DialogResult.Yes == ggMessageBox.ShowDialog()) { return false; } else { return true; } } // Since we made it here, it looks like we found a row in the import text that contains the column names for the destination tables primary/unique key... string[] importColumnNames = rawImportRows[columnHeaderRowIndex].Split(columnDelimiters, StringSplitOptions.None); System.Collections.Generic.Dictionary<string, int> columnNameMap = new System.Collections.Generic.Dictionary<string, int>(); // So now we need to build a map of datatable columns in import text columns (because they may not be in the same order)... for (int i = 0; i < importColumnNames.Length; i++) { // Map the friendly field name from the incoming text to the matching column in the datatable (case sensitive)... foreach (DataColumn dc in destinationTable.Columns) { if (GetFriendlyFieldName(dc, dc.ColumnName) == importColumnNames[i]) { columnNameMap.Add(dc.ColumnName, i); } } // If the column header was not matched - try matching again (case insensitive)... if (!columnNameMap.ContainsValue(i)) { // Map the friendly field name from the incoming text to the matching column in the datatable (case insensitive)... foreach (DataColumn dc in destinationTable.Columns) { if (GetFriendlyFieldName(dc, dc.ColumnName).ToLower() == importColumnNames[i].ToLower()) { columnNameMap.Add(dc.ColumnName, i); } } } // If the column header was still not matched - try the raw table field name... if (!columnNameMap.ContainsValue(i)) { // Map the friendly field name from the incoming text to the matching column in the datatable (case insensitive)... foreach (DataColumn dc in destinationTable.Columns) { if (dc.ColumnName.ToLower() == importColumnNames[i].ToLower()) { columnNameMap.Add(dc.ColumnName, i); } } } } // Now that we have the column map, start processing the rows (starting with the one right after the column header row)... for (int i = columnHeaderRowIndex + 1; i < rawImportRows.Length; i++) { DataRow dr = null; string[] rawFieldData = rawImportRows[i].Split(columnDelimiters, StringSplitOptions.None); if (primaryKeyFound) { System.Collections.Generic.List<object> rowKeys = new System.Collections.Generic.List<object>(); // Build the primary key to get the row to edit... foreach (DataColumn pKeyColumn in destinationTable.PrimaryKey) { object keyValue; if (string.IsNullOrEmpty(rawFieldData[columnNameMap[pKeyColumn.ColumnName]].ToString())) { keyValue = DBNull.Value; } else { keyValue = rawFieldData[columnNameMap[pKeyColumn.ColumnName]]; } rowKeys.Add(keyValue); } // Get the row to update (or create a new one for insert if an existing one is not found)... // First - attempt to find a row in the DataTable that matches the primary key(s)... try { dr = destinationTable.Rows.Find(rowKeys.ToArray()); } catch { // There was an error in the row key data - so bail out and do nothing... } if (dr == null) { // No row exists in this DataTable for the given primary key(s), so create a new blank row to fill... dr = destinationTable.NewRow(); // and add it to the DataTable... destinationTable.Rows.Add(dr); } } else // Find the row using the unique keys... { DataRow[] matchingRows = null; string rowFilter = ""; foreach (DataColumn uKeyColumn in uniqueKeys) { if (columnNameMap[uKeyColumn.ColumnName] >= 0 && columnNameMap[uKeyColumn.ColumnName] <= (rawFieldData.Length - 1) && !string.IsNullOrEmpty(rawFieldData[columnNameMap[uKeyColumn.ColumnName]])) { string newValue = ""; // Perform a reverse lookup to get the key if this is a ForeignKey field... if (lookupTables.IsValidFKField(uKeyColumn)) { if (!string.IsNullOrEmpty(rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString().Trim())) { newValue = lookupTables.GetPKeyValueMember(dr, uKeyColumn.ExtendedProperties["foreign_key_dataview_name"].ToString(), rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString().Trim(), -1).ToString(); // If the lookup attempt returned the default value - indicate to the user that the lookup failed... if (newValue.Equals("-1")) { dr.SetColumnError(uKeyColumn.ColumnName, "\tCould not find lookup value: " + rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString()); } } } // Perform a reverse lookup to get the value if this is a Code_Value field... else if (lookupTables.IsValidCodeValueField(uKeyColumn)) { if (!string.IsNullOrEmpty(rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString().Trim())) { newValue = lookupTables.GetCodeValueValueMember(rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString(), uKeyColumn.ExtendedProperties["group_name"].ToString(), "!Error! - GetValueMember method failed to find display member"); // If the lookup attempt returned the default value - indicate to the user that the lookup failed... if (newValue.Equals("!Error! - GetValueMember method failed to find display member")) { dr.SetColumnError(uKeyColumn.ColumnName, "\tCould not find lookup value: " + rawFieldData[columnNameMap[uKeyColumn.ColumnName]].ToString()); } } } // Doesn't require a lookup... else { newValue = rawFieldData[columnNameMap[uKeyColumn.ColumnName]]; } if (uKeyColumn.DataType == typeof(string)) { rowFilter += uKeyColumn.ColumnName + "='" + newValue + "' AND "; } else { rowFilter += uKeyColumn.ColumnName + "=" + newValue + " AND "; } } else { rowFilter += uKeyColumn.ColumnName + " IS NULL AND "; } } rowFilter = rowFilter.Substring(0, rowFilter.LastIndexOf(" AND ")); try { matchingRows = destinationTable.Select(rowFilter); } catch { matchingRows = new DataRow[] { }; } if (matchingRows.Length > 0) { dr = matchingRows[0]; } else { // Could not find a matching row, so set the dr to null (this will effectively ignore this import record) //dr = null; // No row exists in this DataTable for the given primary key(s), so create a new blank row to fill... dr = destinationTable.NewRow(); // and add it to the DataTable... destinationTable.Rows.Add(dr); } } if (dr != null) { populateRowWithImportData(dr, rawFieldData, columnNameMap, lookupTables); } else { missingRows++; } } } processedImportSuccessfully = true; return processedImportSuccessfully; }