Exemplo n.º 1
0
        public void ReadColumn(string sColName)
        {
            if (m_oWorksheetFeed == null)
            {
                throw new System.Exception("The sheet is unselected");
            }
            if (m_oWorksheetFeed.Entries.Count != 1)
            {
                return;
            }

            string sChecked = "checked";

            m_oCurrentColumn.sName  = sColName;
            m_oCurrentColumn.nIndex = ObtainIndexByName(sColName);

            m_oSelectedList.StartNewList(sColName);
            m_oValidationDataTable.Reset();
            m_oValidationDataTable.Columns.Add(new System.Data.DataColumn(sChecked, typeof(bool)));
            m_oValidationDataTable.AddColumn(sColName);

            foreach (ListEntry worksheetRow in m_oListFeed.Entries)
            {
                string scanData = worksheetRow.Elements[m_oCurrentColumn.nIndex].Value.ToString();
                m_oSelectedList.PushBack(scanData);

                System.Data.DataRow dr = m_oValidationDataTable.NewRow();
                dr[sColName] = scanData;
                dr[sChecked] = false;
                m_oValidationDataTable.Rows.Add(dr);
            }
        }
Exemplo n.º 2
0
        public void OnSubmit()
        {
            pList oList = new pList();

            oList.StartNewList("items");

            foreach (System.Data.DataRow row in m_oValidationDataTable.Rows)
            {
                if ((bool)row[0] == true)
                {
                    oList.PushBack(row[1].ToString());
                }
            }

            if (oList.Rows.Count > 0)
            {
                forms.SubmitForm oSub = new forms.SubmitForm();
                oSub.AddList(oList);

                if (oSub.ShowDialog() == DialogResult.OK)
                {
                    int i = 0;

                    foreach (System.Data.DataRow row in m_oValidationDataTable.Rows)
                    {
                        if ((bool)row[0] == true)
                        {
                            RemoveRow(i);
                        }
                        i++;
                    }
                    System.Windows.Forms.MessageBox.Show("items cleared:)");
                }
                else
                {
                    System.Windows.Forms.MessageBox.Show("action canceled");
                }
            }
            ReadColumn(m_oCurrentColumn.sName);
        }