예제 #1
0
        public Form1()
        {
            InitializeComponent();
            oConfig = new clsConfig(XML_CONFIG_FILE);
            oSQL    = new clsSQL(oConfig);
            di      = new DirectoryInfo(sFileInputLoc);

            fi = di.GetFiles().Where(x => x.Extension != ".db").ToArray();
            //foreach (var f in fi)
            //{
            //    if (f.Extension==(".db"))
            //    {

            //    }
            //}
            lWindow.Items.Add("There are " + fi.Count() + " files to sort in " + sFileInputLoc);
            writeLog("******There are " + fi.Count() + " files to sort in " + sFileInputLoc, 0);
            foreach (var s in fi)
            {
                if (s.Name.Contains(".pdf"))
                {
                    iPdfCount++;
                }
                if (s.Name.Contains(".tif"))
                {
                    iTifCount++;
                }
            }
            lWindow.Items.Add("");
            lWindow.Items.Add("There are " + iPdfCount + " pdfs.");
            lWindow.Items.Add("There are " + iTifCount + " tifs.");
        }
예제 #2
0
        public clsSQL(clsConfig myConfig)
        {
            oConfig = myConfig;

            cnSQLData = new SqlConnection("Server=" + oConfig.sDataServer +
                                          ";DataBase=" + oConfig.sDataDBName +
                                          ";UID=" + oConfig.sUID +
                                          ";PWD=" + oConfig.sPWD +
                                          ";Application Name=AppointmentProviderList");
        }