예제 #1
0
        //재원씨---------------------------------------------------------------------------------------------------------------------
        private void btnOpenFile_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog();

            openFileDialog.Filter      = "Excel (*.xlsx)|*.xlsx|Excel 97-2003 (*.xls)|*.xls| Excel Files(*.xlsm)|*.xlsm";
            openFileDialog.Multiselect = true;


            if (openFileDialog.ShowDialog() == false)
            {
                return;
            }
            ///

            List <string> clientNames = new List <string>();

            try
            {
                using (StreamReader file = new StreamReader(path, Encoding.GetEncoding("UTF-8")))
                    using (JsonTextReader reader = new JsonTextReader(file))
                    {
                        JObject        fullObj    = (JObject)JToken.ReadFrom(reader);
                        List <JObject> clientList = fullObj["회사목록"].ToObject <List <JObject> >();

                        foreach (JObject client in clientList)
                        {
                            clientNames.Add(client["회사명"].ToString());
                        }

                        reader.Close();
                    }
            }
            catch (System.IO.FileNotFoundException)
            {
                return;
            }


            foreach (string filename in openFileDialog.FileNames)
            {
                if (ExcelListView.Items.Contains(filename))
                {
                    continue;
                }
                ExcelWorkQueueDataStruct dataStructObj = new ExcelWorkQueueDataStruct(filename, clientNames);

                AddToWorkQueueAndList(ExcelListView, ExcelWorkQueue, dataStructObj);
            }
        }
예제 #2
0
 private void AddToWorkQueueAndList(ListView ExcelListView, List <ExcelWorkQueueDataStruct> ExcelWorkQueue, ExcelWorkQueueDataStruct dataStructObj)
 {
     ExcelListView.Items.Add(dataStructObj);
     ExcelWorkQueue.Add(dataStructObj);
 }