public string getAuxiliaryMaterialNameFromPkey(string tableName, int pkey) { string name = ""; SortedDictionary <int, AuxiliaryMaterialDataTable> materialList = new SortedDictionary <int, AuxiliaryMaterialDataTable>(); if (tableName.Length > 0) { if (!m_materialList.ContainsKey(tableName)) { load(tableName); } materialList = m_materialList[tableName]; } foreach (KeyValuePair <int, AuxiliaryMaterialDataTable> index in materialList) { AuxiliaryMaterialDataTable record = new AuxiliaryMaterialDataTable(); record = index.Value; if (record.pkey == pkey) { name = record.name; break; } } return(name); }
public int getAuxiliaryMaterialPkeyFromName(string tableName, string name) { int pkey = 0; SortedDictionary <int, AuxiliaryMaterialDataTable> materialList = new SortedDictionary <int, AuxiliaryMaterialDataTable>(); if (tableName.Length > 0) { if (!m_materialList.ContainsKey(tableName)) { load(tableName); } materialList = m_materialList[tableName]; } foreach (KeyValuePair <int, AuxiliaryMaterialDataTable> index in materialList) { AuxiliaryMaterialDataTable record = new AuxiliaryMaterialDataTable(); record = index.Value; if (record.name == name) { pkey = record.pkey; break; } } return(pkey); }
private void load(string tableName) { if (tableName.Length > 0) { string sql = "SELECT [PKEY],[NAME],[DESC],[IS_ALLOW_DELETE] FROM [dbo].[" + tableName + "] ORDER BY PKEY"; m_materialList.Clear(); using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql)) { SortedDictionary <int, AuxiliaryMaterialDataTable> materialList = new SortedDictionary <int, AuxiliaryMaterialDataTable>(); foreach (DataRow row in dataTable.Rows) { AuxiliaryMaterialDataTable record = new AuxiliaryMaterialDataTable(); record.pkey = DbDataConvert.ToInt32(row[0]); record.name = DbDataConvert.ToString(row[1]); record.desc = DbDataConvert.ToString(row[2]); record.isAllowDelete = DbDataConvert.ToInt32(row[3]); materialList.Add(materialList.Count, record); } if (m_materialList.ContainsKey(tableName)) { m_materialList[tableName] = materialList; } else { m_materialList.Add(tableName, materialList); } } } }
public void insert(string tableName, AuxiliaryMaterialDataTable material) { string insert = "INSERT INTO [dbo].[" + tableName + "]([NAME],[DESC],[IS_ALLOW_DELETE]) VALUES("; insert += "'" + material.name + "',"; insert += "'" + material.desc + "',"; insert += "1"; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(tableName); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }