Пример #1
0
        private void load()
        {
            SortedDictionary <int, MaterielOrgStructTable> materielGroupList = new SortedDictionary <int, MaterielOrgStructTable>();
            string materielQuery = "SELECT PKEY, VALUE, PARENT_PKEY FROM  BASE_MATERIEL_ORG_STRUCT ORDER BY PKEY";

            if (m_MaterielOrgList.Count > 0)
            {
                m_MaterielOrgList.Clear();
            }

            using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, materielQuery))
            {
                foreach (DataRow row in dataTable.Rows)
                {
                    MaterielOrgStructTable record = new MaterielOrgStructTable();
                    record.pkey       = DbDataConvert.ToInt32(row[0]);
                    record.value      = DbDataConvert.ToInt32(row[1]);
                    record.parentPkey = DbDataConvert.ToInt32(row[2]);

                    materielGroupList.Add(record.pkey, record);
                }
            }

            m_MaterielOrgList = materielGroupList;
        }
Пример #2
0
        private void getAMaterielOrgValue(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++)
                {
                    MaterielOrgStructTable record = (MaterielOrgStructTable)nodeList[i];

                    if (!m_childNodes.ContainsKey(record.value))
                    {
                        m_childNodes.Add(record.value, record.value);
                    }

                    getAMaterielOrgValue(record.pkey, record.value);
                }
            }
        }
Пример #3
0
        public int getNoteValueFromPkey(int pkey)
        {
            int noteValue = 0;

            if (m_MaterielOrgList.ContainsKey(pkey))
            {
                MaterielOrgStructTable record = (MaterielOrgStructTable)m_MaterielOrgList[pkey];
                noteValue = record.value;
            }

            return(noteValue);
        }
Пример #4
0
        public ArrayList getNodesFormParentID(int parentID)
        {
            ArrayList nodes = new ArrayList();

            MaterielOrgStructTable record = new MaterielOrgStructTable();

            foreach (KeyValuePair <int, MaterielOrgStructTable> index in m_MaterielOrgList)
            {
                record = index.Value;
                if (record.parentPkey == parentID)
                {
                    nodes.Add(record);
                }
            }

            return(nodes);
        }
Пример #5
0
        public int getRootNodePkey()
        {
            int rootNodeID = 0;

            MaterielOrgStructTable record = new MaterielOrgStructTable();

            foreach (KeyValuePair <int, MaterielOrgStructTable> index in m_MaterielOrgList)
            {
                record = index.Value;
                if (record.parentPkey == 0)
                {
                    rootNodeID = record.pkey;
                }
            }

            return(rootNodeID);
        }
Пример #6
0
        public int getPkeyFromValue(int value)
        {
            int       peky  = 0;
            ArrayList nodes = new ArrayList();

            MaterielOrgStructTable record = new MaterielOrgStructTable();

            foreach (KeyValuePair <int, MaterielOrgStructTable> index in m_MaterielOrgList)
            {
                record = index.Value;
                if (record.value == value)
                {
                    peky = record.pkey;
                }
            }

            return(peky);
        }
Пример #7
0
        public void insert(MaterielOrgStructTable materielOrgStruct)
        {
            string insert = "INSERT INTO [dbo].[BASE_MATERIEL_ORG_STRUCT] ([VALUE],[PARENT_PKEY]) VALUES (";

            insert += "'" + materielOrgStruct.value + "',";
            insert += Convert.ToString(materielOrgStruct.parentPkey);
            insert += ")";

            try
            {
                DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert);
                MessageBoxExtend.messageOK("数据保存成功");
                load();
            }
            catch (Exception error)
            {
                MessageBoxExtend.messageWarning(error.Message);
                return;
            }
        }
Пример #8
0
        public void update(int pkey, MaterielOrgStructTable materielOrgStruct)
        {
            string update = "UPDATE [dbo].[BASE_MATERIEL_ORG_STRUCT] SET ";

            update += "[VALUE] = '" + materielOrgStruct.value + "',";
            update += "[PARENT_PKEY] = " + Convert.ToString(materielOrgStruct.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;
            }
        }