private void load() { SortedDictionary <int, CustomerOrgStructTable> customerGroupList = new SortedDictionary <int, CustomerOrgStructTable>(); string customerQuery = "SELECT PKEY, VALUE, PARENT_PKEY FROM BASE_CUSTOMER_ORG_STRUCT ORDER BY PKEY"; if (m_CustomerOrgList.Count > 0) { m_CustomerOrgList.Clear(); } using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, customerQuery)) { foreach (DataRow row in dataTable.Rows) { CustomerOrgStructTable record = new CustomerOrgStructTable(); record.pkey = DbDataConvert.ToInt32(row[0]); record.value = DbDataConvert.ToInt32(row[1]); record.parentPkey = DbDataConvert.ToInt32(row[2]); customerGroupList.Add(record.pkey, record); } } m_CustomerOrgList = customerGroupList; }
private void getACustomerOrgValue(int parentID, int value) { ArrayList nodeList = getNodesFormParentID(parentID); if (nodeList.Count == 0) { if (!m_childNodes.ContainsKey(value)) { m_childNodes.Add(value, value); } } else { for (int i = 0; i < nodeList.Count; i++) { CustomerOrgStructTable record = (CustomerOrgStructTable)nodeList[i]; if (!m_childNodes.ContainsKey(record.value)) { m_childNodes.Add(record.value, record.value); } getACustomerOrgValue(record.pkey, record.value); } } }
public int getNoteValueFromPkey(int pkey) { int noteValue = 0; if (m_CustomerOrgList.ContainsKey(pkey)) { CustomerOrgStructTable record = (CustomerOrgStructTable)m_CustomerOrgList[pkey]; noteValue = record.value; } return(noteValue); }
public ArrayList getNodesFormParentID(int parentID) { ArrayList nodes = new ArrayList(); CustomerOrgStructTable record = new CustomerOrgStructTable(); foreach (KeyValuePair <int, CustomerOrgStructTable> index in m_CustomerOrgList) { record = index.Value; if (record.parentPkey == parentID) { nodes.Add(record); } } return(nodes); }
public int getRootNodePkey() { int rootNodeID = 0; CustomerOrgStructTable record = new CustomerOrgStructTable(); foreach (KeyValuePair <int, CustomerOrgStructTable> index in m_CustomerOrgList) { record = index.Value; if (record.parentPkey == 0) { rootNodeID = record.pkey; } } return(rootNodeID); }
public int getPkeyFromValue(int value) { int peky = 0; ArrayList nodes = new ArrayList(); CustomerOrgStructTable record = new CustomerOrgStructTable(); foreach (KeyValuePair <int, CustomerOrgStructTable> index in m_CustomerOrgList) { record = index.Value; if (record.value == value) { peky = record.pkey; } } return(peky); }
public void insert(CustomerOrgStructTable customerOrgStruct) { string insert = "INSERT INTO [dbo].[BASE_CUSTOMER_ORG_STRUCT] ([VALUE],[PARENT_PKEY]) VALUES ("; insert += "'" + customerOrgStruct.value + "',"; insert += Convert.ToString(customerOrgStruct.parentPkey); insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void update(int pkey, CustomerOrgStructTable customerOrgStruct) { string update = "UPDATE [dbo].[BASE_CUSTOMER_ORG_STRUCT] SET "; update += "[VALUE] = '" + customerOrgStruct.value + "',"; update += "[PARENT_PKEY] = " + Convert.ToString(customerOrgStruct.parentPkey) + " "; update += "WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("数据修改成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }