コード例 #1
0
 private static void ConfigureASheet(
     string sLocalName
     , ref ArrayList allProducts
     , string sProductName
     , string sQueryEnd
     , NameValueCollection nParms
     , DocDetails dt
     , ref PcId pc
     )
 {
     /*
      * Sub to Call config on the Sheet with the Method
      *
      *
      */
     try
     {
         foreach (object o in allProducts)
         {
             Products pd = (Products)o;
             if (pd.sProduct == sProductName && pd.sQueryEnd == sQueryEnd)
             {  // Got It
                 // Marshall the Parms
                 try
                 {
                     pc.LogEvent(sUnid
                                 , "At dt.CallXlConfigure for " + sLocalName
                                 , 0
                                 , pc.IBatchNo);
                     dt.sTarget   = sTarget;
                     dt.sOfficesw = sOfficeSw;
                     dt.CallXlConfigure(pd, sLocalName, nParms);
                 }
                 catch (Exception ex)
                 {
                     if (bWebLog)
                     {
                         pc.LogEvent(sUnid
                                     , ex.Message + "Results from Configure on  " + sLocalName
                                     , -1
                                     , pc.IBatchNo);
                     }
                     else
                     {
                         pc.FileLog(sUnid
                                    , ex.Message + "Results from Configure on  " + sLocalName
                                    , -1
                                    , pc.IBatchNo);
                     }
                 }
                 finally
                 {
                     FileInfo fi = new FileInfo(sLocalName);
                     fi.Delete();
                     if (bWebLog)
                     {
                         pc.LogEvent(sUnid
                                     , "Success Results w/Delete from Configure on  " + sLocalName
                                     , 0
                                     , pc.IBatchNo);
                     }
                     else
                     {
                         pc.FileLog(sUnid
                                    , "Success Results w/Delete from Configure on  " + sLocalName
                                    , 0
                                    , pc.IBatchNo);
                     }
                 }
                 break;
             }
         }
     }
     catch (Exception ex)
     {
     }
 }
コード例 #2
0
        static void Main(string[] args)
        {
            // Initialize the program
            // Set starting conditions
            bool bError = false;



            //string url = sHost + "Sheets/Version/070110/";
            //   HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
            //   using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
            //   {
            //       using (StreamReader reader = new StreamReader(response.GetResponseStream()))
            //       {
            //           string html = reader.ReadToEnd();

            //       }

            //   }


            /* Arguments
             * 0 Install Location  \\server\share\    -  Install
             * 1 target directory  \\server\share\  - tied to unid
             * 2 unid
             *
             */
            PcId pc;

            try
            {
                if (File.Exists("Clients.xml"))
                // We will drive via file. Do the config
                {
                    XmlDocument xmld = new XmlDocument();
                    xmld.Load(@"Clients.xml");
                    XmlNodeList nodesl = xmld.SelectNodes("//Client");

                    string sFileName = "";
                    sFileName = sHost + @"\Install\Xml\Products.xml";


                    Console.WriteLine("Getting file {0}", sFileName);
                    DownLoadASheet(sFileName, sTarget + @"\Products.Xml");

                    //if (bWebLog)
                    //    pc.LogEvent(sUnid, "File Download Complete on "
                    //       + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                    //else
                    //    pc.FileLog(sUnid, "File Download Complete on "
                    //        + sTarget + @"Products.Xml", 0, pc.IBatchNo);


                    foreach (XmlNode n in nodesl)
                    {
                        sHost     = n.Attributes["Host"].Value;
                        sUnid     = n.Attributes["Unid"].Value;
                        sTarget   = n.Attributes["Target"].Value;
                        sEmail    = n.Attributes["Email"].Value;
                        sOfficeSw = n.Attributes["Office"].Value;

                        // call the main config class
                        Config_Process.ProcessMain(sHost, sUnid, sTarget, sEmail, sOfficeSw);


                        // reset the logger object
                    }
                    goto Done;
                }
                else
                {
                    sHost = args[0];
                    if (sHost.Contains("$"))
                    {
                        sHost = sHost.Replace("$", "");
                    }

                    sTarget = args[1];
                    if (sTarget.Contains("$"))
                    {
                        sTarget = sTarget.Replace("$", "");
                    }


                    sUnid     = args[2];
                    sEmail    = args[3];
                    sOfficeSw = args[4];
                }
            }
            catch
            {
                sHost     = @"Server Error";
                sTarget   = @"Drive Error";
                sUnid     = "";
                sEmail    = "*****@*****.**";
                sOfficeSw = "2007";
            }
            iBatchCl = -999;
            // Lets Id the box
            pc = new PcId(sUnid, sTarget, sEmail);
            // 21 Jan 2011 - Added support for godaddy webservice and Id on box
            try
            {
                pc.LogEvent();
                iBatchCl = pc.IBatchNo;
                bWebLog  = true;
                if (iBatchCl == -1)
                {
                    // logging is not available
                    bWebLog = false;
                    pc.CreateLogFile(sTarget);
                }
            }
            catch (Exception ex)
            {
                bWebLog = false;
                pc.CreateLogFile(sTarget);
            }

            try
            {
                Directory.CreateDirectory(sTarget);
            }
            catch { }

            ArrayList nProd = new ArrayList();

            //if (args.GetUpperBound(0) > 0)
            //    sUnid = args[0];

            // make sure our work directory exists
            // Clear out old sheets
            string[] sFiles = Directory.GetFiles(sTarget);
            foreach (string f in sFiles)
            {
                FileInfo fd = new FileInfo(f);

                if (fd.Extension == ".xls" || fd.Extension == ".xlsm")
                {
                    fd.IsReadOnly = false;
                    fd.Delete();
                }
            }


            if (!Directory.Exists(sTarget))
            {
            }
            else
            {
                sFiles = Directory.GetFiles(sTarget);
                foreach (string f in sFiles)
                {
                    FileInfo fd = new FileInfo(f);
                    if (fd.Extension == ".xls" || fd.Extension == ".xlsm")
                    {
                        fd.IsReadOnly = false;
                        fd.Delete();
                    }
                }
            }
            try
            {
                string sFileName = "";
                sFileName = sHost + @"\Install\Xml\Products.xml";


                Console.WriteLine("Getting file {0}", sFileName);
                DownLoadASheet(sFileName, sTarget + @"\Products.Xml");

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }

                sFileName = sHost + @"\Install\Xml\" + sUnid + @"\Cust.Xml";
                Console.WriteLine("Getting file {0}", sFileName);
                DownLoadASheet(sFileName, sTarget + @"\Cust.Xml");

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
            }
            catch (Exception ex)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                try
                {
                    pc.Close();
                }
                catch { }

                Console.WriteLine("Program Stopping - " + ex.Message);
                return;
            }
            if (bWebLog)
            {
                pc.LogEvent(sUnid, "File Download Complete", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "File Download Complete", 0, pc.IBatchNo);
            }



            // Process the xmlDoc

            XmlDocument xmldoc         = new XmlDocument();
            XmlDocument xmldocProducts = new XmlDocument();

            xmldocProducts.Load(sTarget + @"\Products.Xml");


            System.Text.UTF8Encoding str = new System.Text.UTF8Encoding();

            string       sContents;
            StreamReader sr = new StreamReader(sTarget + @"\Cust.Xml");

            sContents = sr.ReadToEnd();

            sr.Close();
            sr.Dispose();

            byte[] b = Convert.FromBase64String(sContents);


            sContents = System.Text.Encoding.UTF8.GetString(b);

            //Byte[] sb1 = str.GetBytes(sContents);
            //sContents = Convert.ToBase64String(sb1);
            //sContents = Convert.ToString(sb1);
            StreamWriter sw = new StreamWriter(sTarget + @"\Cust.Xml", false);

            sw.Write(sContents);
            sw.Close();
            sw.Dispose();



            xmldoc.Load(sTarget + @"\Cust.Xml");

            NameValueCollection nMethods = new NameValueCollection();
            //       LoadMethods(ref nMethods, xmldocMethods);

            //  Call the Config Clas
            DocDetails dt = new DocDetails(xmldocProducts);

            dt.SetProducts(nProd);

            NameValueCollection nParms = new NameValueCollection();

            XmlNode root;

            root = xmldoc.DocumentElement;

            XmlNodeList nodes;


            //  nodes = root.SelectNodes("Customer/Parms[@Sheet='Y']");
            nodes = root.SelectNodes("Customer/Parms");
            // Build all the nodes, mark which are sheets, which are parms.
            // Match it by queryand and sheet to determine the parms.

            string sQry = "";

            foreach (XmlNode n in nodes)
            {
                if (n.Name == "Parms")
                {
                    try
                    {
                        if (sQry == "")
                        {
                            sQry = n.Attributes["queryend"].Value;
                        }
                    }
                    catch (Exception ex)
                    { }
                }



                foreach (XmlAttribute att in n.Attributes)
                {
                    Debug.Print("att value={0} Attribute Name{1}", att.Value, att.Name);

                    if (att.Name == "Product" && att.Value == "Y")
                    {
                        Debug.Print("Got a Product{0}", n.Attributes["Value"].Value);

                        //     string sRemoteName = "http://localhost/sheets/" + n.Attributes["Value"].Value + ".xls";
                        //     string sLocalName = @"C:\cci\" + n.Attributes["Value"].Value + ".xls";
                        try
                        {
                            char[]   delimiterChars = { ',' };
                            string[] sqrysplit;
                            try
                            {
                                sQry      = nParms.Get("queryend").ToString();
                                sqrysplit = sQry.Split(delimiterChars);
                                sQry      = sqrysplit[0];
                            }
                            catch (Exception ex)
                            {
                                sQry = @"070110";
                            }

                            NameValueCollection tParms = FindParmSet(n.Attributes["Value"].Value, sQry, dt.cSheetColl, nParms);
                            string sFile       = FindLiveFile(n.Attributes["Value"].Value, sQry, dt.cSheetColl);
                            string sRemoteName = sHost + @"\Install\sheets\version\" + sQry + @"\" + sFile;
                            //HttpUtility.UrlPathEncode(sFile);
                            string sLocalName = sTarget + @"\" + sFile;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Downloading Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Downloading Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }

                            iDotCount = 0;

                            sCurrentFile = sRemoteName;


                            if (File.Exists(sLocalName))
                            {
                                FileInfo fi2 = new FileInfo(sLocalName);
                                fi2.IsReadOnly = false;
                                fi2.Delete();
                            }


// Added 26 August 2011
// Purpose
// Retry 3 times
                            int iTries = 0;

ftpRetry:

                            Console.WriteLine("Getting file {0}", sRemoteName);

                            try
                            {
                                iTries += 1;
                                DownLoadASheet(sRemoteName, sLocalName);
                            }
                            catch (Exception x)
                            {
                                if (iTries > 3)
                                {
                                    throw x;
                                }
                                else
                                {
                                    Console.WriteLine("Retrying file {0}", sLocalName);

                                    goto ftpRetry;
                                }
                            }

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Download Complete Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Download Complete Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }

                            //    Call Configure on it!
                            //       ConfigureASheet(sLocalName, ref  dt.cSheetColl, n.Value, sQry, nParms, dt);
                            FileInfo fi;

                            bool bProcess = false;

                            fi = new FileInfo(sLocalName);


                            if (File.Exists(sLocalName) && fi.Length > 0)
                            {
                                try
                                {
                                    // inc the logger
                                    iLogCount += 1;

                                    if (!pc.bCust)
                                    {
                                        pc.LogEvent(sUnid, "", 10000, pc.IBatchNo);
                                        pc.bCust = true;
                                    }

                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Trying to configure" + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Trying to configure" + sLocalName, 0, pc.IBatchNo);
                                    }

                                    ConfigureASheet(sLocalName, ref dt.cSheetColl, n.Attributes["Value"].Value, sQry, tParms, dt, ref pc);
                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }



                                    sQry = "";
                                }

                                catch (Exception ex)
                                {
                                    pc.LogEvent(sUnid, ex.Message + " - Configuring Sheet Fails", -1, pc.IBatchNo);
                                }
                                if (bWebLog)
                                {
                                    pc.LogEvent(sUnid, "Processing Completed", 0, pc.IBatchNo);
                                }
                                else
                                {
                                    pc.FileLog(sUnid, "Processing Completed", 0, pc.IBatchNo);
                                }



                                if (bWebLog)
                                {
                                    pc.LogEvent(sUnid, " Installer Closing", 11000, pc.IBatchNo);
                                }
                                else
                                {
                                    pc.FileLog(sUnid, " Installer Closing", 11000, pc.IBatchNo);
                                }
                                pc.Close();
                            }
                            else
                            {
                                fi.Delete();
                            }
                            break;
                        }
                        catch (Exception ex)
                        {
                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }

                            Console.WriteLine("Error - " + ex.Message);
                        }
                    }
                    else
                    { // it is not a sheet
                        try
                        {
                            if (nParms.Get(n.Attributes["LkeyName"].Value) != null)
                            {//skip it
                                string sKeyName    = n.Attributes["LkeyName"].Value;
                                string sKeyValue   = n.Attributes["Value"].Value;
                                string sCurrentVal = nParms.Get(n.Attributes["LkeyName"].Value);
                                Debug.Print("Atrib {0} ", n.Attributes["Value"].Value);
                                //       if (sKeyValue == sCurrentVal) goto Lp1;
                                switch (sKeyName)
                                {
                                //salariedcodes
                                //salariedwithsupp
                                //certifiedcodes
                                //princodes
                                //suppcodes


                                case "suppcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "princodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "certifiedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedwithsupp":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "otherdepts":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "budgetind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "specialind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                default:
                                    break;
                                }
                                goto Lp1;
                            }

                            else
                            {
                                nParms.Add(n.Attributes["LkeyName"].Value, n.Attributes["Value"].Value);
                            }
                        }
                        catch (ArgumentOutOfRangeException ex)
                        { // is missing
                        }
                        catch
                        { }
                    }

                    Lp1 :;
                }
                ;
            }

            // Calling Configuration Class
            //  dt = new DocDetails(xmldocProducts );
            //  dt.SetProducts(nProd);
            //   dt.CallBudgetMethod(new sTheProducts());



Done:
            if (bError)
            {
            }



            FileInfo
                fi1 = new FileInfo(sTarget + @"\Cust.xml");

            fi1.Delete();
            fi1 = new FileInfo(sTarget + @"\Products.xml");
            fi1.Delete();

            Console.WriteLine("Installer Processing Completed!");
        }
コード例 #3
0
        static void Main(string[] args)
        {
            /* Arguments
             * 0 host
             * 1 target directory
             * 2 unid
             *
             */
            bError = false;



            int iCnt = 0;

            Console.WriteLine("Installer Begins. {0}", System.Reflection.Assembly.GetExecutingAssembly().GetName().Version);
            string sQuote = "\"";

            string sCmdLine = "";

            try
            {
                sHost   = args[0];
                sUnid   = args[1];
                sEmail  = args[2];
                sTarget = args[3];
                sTarget = sTarget.Replace(sQuote, "");

                Console.WriteLine("Email is {0}", sEmail);
                string currentAssemblyDirectoryName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
            }

            catch (Exception ex)
            {
                sTarget = sTarget.Replace(sQuote, "");
                sHost   = @"http://ccisupportsite.com";
                //      sTarget = @"c:\As400da\";
                //       sUnid = "4621E8E7157912B185257829006ECFC0";
                //      sEmail = "*****@*****.**";
                Console.WriteLine("Error - Parameter Signature Invalid " + ex.Message);
                // throw ex;

                // fix the install directory
                if (!Directory.Exists(sTarget))
                {
                    iCnt = 0;
                    bool bValid = false;
                    while (iCnt <= 2 && !bValid)
                    {
                        Console.WriteLine("Problem with Target Location");
                        Console.WriteLine("The target {0} cannot be Validated Please Reenter:", sTarget);
                        sTarget = Console.ReadLine();
                        Console.WriteLine("");
                        sTarget = sTarget.Trim();
                        iCnt   += 1;

                        if (Directory.Exists(sTarget))
                        {
                            bValid = true;
                        }
                    }
                    if (iCnt > 2 && !bValid)
                    {
                        bError = true;
                    }
                }


                // fix the email address

                Console.WriteLine("Problem with Email Address");
                Console.WriteLine("The email address {0} cannot be Validated Please Reenter:", sEmail);
                sEmail = Console.ReadLine();
                Console.WriteLine("");
                sEmail = sEmail.Trim();
            }



            iBatchCl = -999;
            // Lets Id the box
            PcId pc = new PcId(sUnid, sTarget, sEmail);

            pc.sEmail = sEmail;

            if (bError)
            {
                goto Done;
            }


            // 21 Jan 2011 - Added support for godaddy webservice and Id on box
            try
            {
                if (sEmail.Contains(@"cookconsulting.net"))
                {
                    goto Next;
                }

                if (pc.ChkInstall(sUnid) == "stop")
                {
                    Console.WriteLine("This install is terminated - This license code has been previously installed");
                    bError = true;
                    goto Done;
                }
Next:
                pc.LogEvent();
                iBatchCl = pc.IBatchNo;
                bWebLog  = true;
                if (iBatchCl == -1)
                {
                    // logging is not available
                    bWebLog = false;
                    pc.CreateLogFile(sTarget);
                }
            }
            catch (Exception ex)
            {
                bWebLog = false;
                //   pc.CreateLogFile(sTarget);
            }

            //sUnid = sUnid.Trim();

            while (iCnt <= 2 && sUnid.Length != 32)
            {
                Console.Write("Problem with the Customer License Code Check your Cut and Past");
                Console.Write("The unid {0} cannot be Validated Please Reenter:", sUnid);
                sUnid = Console.ReadLine();
                Console.WriteLine("");
                sUnid = sUnid.Trim();
                iCnt += 1;
            }
            if (sUnid.Length != 32)
            {
                Console.WriteLine("The unid {0} cannot be Validated.", sUnid);
                bError = true;
                goto Done;
            }

            Console.WriteLine("Installer is running Batch ID -> {0} for UNID -> {1}.", iBatchCl, sUnid);

            // Removed
            // 31 Jan 2012

            if (sTarget.EndsWith("\\"))
            {
            }
            else
            {
                sTarget += "\\";
            }

            ArrayList nProd = new ArrayList();

            //if (args.GetUpperBound(0) > 0)
            //    sUnid = args[0];

            // make sure our work directory exists

            FileInfo fi;

            try
            {
                if (!Directory.Exists(sTarget))
                {
                    Directory.CreateDirectory(sTarget);
                }
            }
            catch (Exception ex) { }

            ;
            // 23 Juin 2011
            // MJ Moen
            // added to replace kill switch in script
            try
            {
                DirectoryInfo di = new DirectoryInfo(sTarget);
                foreach (FileInfo tfi in di.GetFiles())
                {
                    if (tfi.Extension == ".xls" || tfi.Extension == ".xlsm")
                    {
                        tfi.IsReadOnly = false;
                        tfi.Delete();
                    }
                }

                di = new DirectoryInfo(@"c:\as400da\");

                foreach (FileInfo tfi in di.GetFiles())
                {
                    if (tfi.Extension == ".xls" || tfi.Extension == ".xlsm")
                    {
                        tfi.IsReadOnly = false;
                        tfi.Delete();
                    }
                }
                string sDesktop = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\AS400 SpreadSheets";
                di = new DirectoryInfo(sDesktop);
                foreach (FileInfo tfi in di.GetFiles())
                {
                    if (tfi.Extension == ".lnk")
                    {
                        tfi.IsReadOnly = false;
                        tfi.Delete();
                    }
                }
                // Clear CCI Sheets Short Cuts
                // 31 Jan 2012
                sDesktop = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\CCI SpreadSheets";
                di       = new DirectoryInfo(sDesktop);
                foreach (FileInfo tfi in di.GetFiles())
                {
                    if (tfi.Extension == ".lnk")
                    {
                        tfi.IsReadOnly = false;
                        tfi.Delete();
                    }
                }
                di = new DirectoryInfo(sTarget);

                foreach (FileInfo tfi in di.GetFiles())
                {
                    if (tfi.Extension == ".lnk")
                    {
                        tfi.IsReadOnly = false;
                        tfi.Delete();
                    }
                }
            }
            catch (Exception ex)
            { Console.WriteLine(ex.Message); }

            try
            {
                fi            = new FileInfo(sTarget + @"Products.xml");
                fi.IsReadOnly = false;
                File.Delete(sTarget + @"Products.xml");
            }
            catch { }


            try
            {
                fi            = new FileInfo(sTarget + @"Cust.xml");
                fi.IsReadOnly = false;
                File.Delete(sTarget + @"Cust.xml");
            }
            catch { }



            try
            {
                string sFileName = "";
                sFileName = sHost + @"/Xml/Products.xml";


                DownLoadASheet(sFileName, sTarget + @"Products.Xml");



                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }


                dws.GetFullCustomersService customersService  = new dws.GetFullCustomersService();
                NetworkCredential           networkCredential = new NetworkCredential("mmoen", "bobbob1", "");

                customersService.Credentials = (ICredentials)networkCredential;
                try
                {
                    SxmlRet = customersService.GETFULLCUSTOMERS("changeor.nsf", "XMLOUTPUT", sUnid);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }


                sFileName = sHost + @"/Xml/" + sUnid + @"/Cust.Xml";
                DownLoadASheet(sFileName, sTarget + @"Cust.Xml");

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
            }
            catch (Exception ex)
            {
                bError = bError || true;

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + "Program Abort", 11000, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + "Program Abort", 11000, pc.IBatchNo);
                }

                // test
                try
                {
                    pc.Close();
                }
                catch { }

                Console.WriteLine("Program Stopping - " + ex.Message);
                goto Done;
            }


            fi = new FileInfo(sTarget + @"Products.Xml");
            if (File.Exists(sTarget + @"Products.Xml") && fi.Length == 0)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "Products File did not Download", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "Products File did not Download", -1, pc.IBatchNo);
                }

                bError = bError || true;

                goto Done;
            }

            fi = new FileInfo(sTarget + @"Cust.Xml");

            if (File.Exists(sTarget + @"Cust.Xml") && fi.Length == 0)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "Customer File did not Download", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "Customer File did not Download", -1, pc.IBatchNo);
                }
                bError = bError || true;

                goto Done;
            }

            if (bWebLog)
            {
                pc.LogEvent(sUnid, "File Download Complete ", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "File Download Complete ", 0, pc.IBatchNo);
            }
            // Process the xmlDoc

            XmlDocument xmldoc         = new XmlDocument();
            XmlDocument xmldocProducts = new XmlDocument();

            xmldocProducts.Load(sTarget + @"Products.Xml");


            System.Text.UTF8Encoding str = new System.Text.UTF8Encoding();

            string       sContents;
            StreamReader sr = new StreamReader(sTarget + @"Cust.Xml");

            sContents = sr.ReadToEnd();

            sr.Close();
            sr.Dispose();

            byte[] b = Convert.FromBase64String(sContents);


            sContents = System.Text.Encoding.UTF8.GetString(b);


            StreamWriter sw = new StreamWriter(sTarget + @"Cust.Xml", false);

            sw.Write(sContents);
            sw.Close();
            sw.Dispose();

            if (bWebLog)
            {
                pc.LogEvent(sUnid, sContents, 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, sContents, 0, pc.IBatchNo);
            }


            xmldoc.Load(sTarget + @"Cust.Xml");

            NameValueCollection nMethods = new NameValueCollection();
            //       LoadMethods(ref nMethods, xmldocMethods);

            //  Call the Config Clas
            DocDetails dt = new DocDetails(xmldocProducts);

            dt.SetProducts(nProd);

            NameValueCollection nParms = new NameValueCollection();

            XmlNode root;

            root = xmldoc.DocumentElement;

            XmlNodeList nodes;


            //  nodes = root.SelectNodes("Customer/Parms[@Sheet='Y']");
            nodes = root.SelectNodes("Customer/Parms");
            // Build all the nodes, mark which are sheets, which are parms.
            // Match it by queryand and sheet to determine the parms.

            string sQryP = "", sQry = "";

            foreach (XmlNode n in nodes)
            {
                if (n.Name == "Parms")
                {
                    try
                    {
                        if (sQry == "")
                        {
                            sQryP = n.Attributes["queryend"].Value;
                        }
                    }
                    catch (Exception ex)
                    { }
                }



                foreach (XmlAttribute att in n.Attributes)
                {
                    Debug.Print("att value={0} Attribute Name{1}", att.Value, att.Name);

                    if (att.Name == "Product" && att.Value == "Y")
                    {
                        Debug.Print("Got a Product{0}", n.Attributes["Value"].Value);

                        //     string sRemoteName = "http://localhost/sheets/" + n.Attributes["Value"].Value + ".xls";
                        //     string sLocalName = @"C:\cci\" + n.Attributes["Value"].Value + ".xls";


                        //try to get the attribute based queryend
                        try
                        {
                            if (sQry == "")
                            {
                                sQry = n.Attributes["queryend"].Value;
                            }
                        }
                        catch (Exception ex)
                        { }


                        try
                        {
                            char[]   delimiterChars = { ',' };
                            string[] sqrysplit;
                            try
                            {
                                if (sQryP == "")
                                {
                                    sQryP     = nParms.Get("queryend").ToString();
                                    sqrysplit = sQryP.Split(delimiterChars);
                                    sQryP     = sqrysplit[0];
                                }
                            }
                            catch (Exception ex)
                            {
                                sQryP = @"070110";
                            }


                            string sQueryEnd;
                            // logic is there is a node queryend attribute use it
                            // else use the file queryend

                            // 16 July 2012
                            // Resolve the correct queryend only from cust.xml
                            //if (sQry == "")
                            //    sQueryEnd = sQryP;
                            //else
                            sQueryEnd = sQry;



                            NameValueCollection tParms = FindParmSet(n.Attributes["Value"].Value, sQueryEnd, dt.cSheetColl, nParms);
                            string sFile       = FindLiveFile(n.Attributes["Value"].Value, sQueryEnd, dt.cSheetColl);
                            string sRemoteName = sHost + @"/sheets/version/" + sQueryEnd + @"/" + HttpUtility.UrlPathEncode(sFile);
                            string sLocalName  = sTarget + sFile;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Downloading Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Downloading Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }

                            sCurrentFile = sRemoteName;
                            iDotCount    = 0;

                            if (File.Exists(sLocalName))
                            {
                                FileInfo fi2 = new FileInfo(sLocalName);
                                fi2.IsReadOnly = false;
                                fi2.Delete();
                            }

                            DownLoadASheet(sRemoteName, sLocalName);

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Download Complete Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Download Complete Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }



                            bool bProcess = false;

                            fi = new FileInfo(sLocalName);



                            if (File.Exists(sLocalName) && fi.Length > 0)
                            {
                                try
                                {
                                    // inc the logger
                                    iLogCount += 1;

                                    if (!pc.bCust)
                                    {
                                        pc.LogEvent(sUnid, "", 10000, pc.IBatchNo);
                                        pc.bCust = true;
                                    }
                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Trying to configure " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Trying to configure " + sLocalName, 0, pc.IBatchNo);
                                    }


                                    ConfigureASheet(sLocalName, ref dt.cSheetColl, n.Attributes["Value"].Value, sQueryEnd, tParms, dt, ref pc);

                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }



                                    sQry = "";
                                }

                                catch (Exception ex)
                                {
                                    bError = bError || true;

                                    pc.LogEvent(sUnid, ex.Message + " - Configuring Sheet Fails", -1, pc.IBatchNo);
                                }
                            }
                            else
                            {
                                fi.Delete();
                            }
                            break;
                        }
                        catch (Exception ex)
                        {
                            bError = bError || true;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }

                            Console.WriteLine("Error - " + ex.Message);
                        }
                    }
                    else
                    { // it is not a sheet
                        try
                        {
                            if (nParms.Get(n.Attributes["LkeyName"].Value) != null)
                            {//skip it
                                string sKeyName = n.Attributes["LkeyName"].Value;
                                Debug.Print("Key name is {0}", sKeyName);

                                if (sKeyName == "queryend" && sQryP == "")
                                {
                                    sQryP = n.Attributes["Value"].Value;
                                }



                                string sKeyValue   = n.Attributes["Value"].Value;
                                string sCurrentVal = nParms.Get(n.Attributes["LkeyName"].Value);
                                Debug.Print("Atrib {0} ", n.Attributes["Value"].Value);
                                //       if (sKeyValue == sCurrentVal) goto Lp1;
                                switch (sKeyName)
                                {
                                //salariedcodes
                                //salariedwithsupp
                                //certifiedcodes
                                //princodes
                                //suppcodes


                                case "suppcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "princodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "certifiedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedwithsupp":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "otherdepts":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "budgetind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "specialind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "username":
                                    pc.setUser(n.Attributes["Value"].Value);
                                    break;

                                case "customername":
                                    pc.setCust(n.Attributes["Value"].Value);
                                    break;

                                default:
                                    break;
                                }
                                goto Lp1;
                            }

                            else
                            {
                                nParms.Add(n.Attributes["LkeyName"].Value, n.Attributes["Value"].Value);
                            }
                        }
                        catch (ArgumentOutOfRangeException ex)
                        { // is missing
                        }
                        catch
                        { }
                    }

                    Lp1 :;
                }
                ;
            }

            // Calling Configuration Class
            //  dt = new DocDetails(xmldocProducts );
            //  dt.SetProducts(nProd);
            //   dt.CallBudgetMethod(new sTheProducts());
            if (bWebLog)
            {
                pc.LogEvent(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            pc.Close();

            FileInfo
                fi1 = new FileInfo(sTarget + "Cust.xml");

            fi1.Delete();
            fi1 = new FileInfo(sTarget + "Products.xml");
            fi1.Delete();


Done:
            if (bError)
            {
                Console.WriteLine("An Install Error has Occurred! Please Contact Support desk @ 800 425 0720 or email [email protected]");
                Console.WriteLine("Please note the following information Batch ID -> {0} and UNID -> {1}.", iBatchCl, sUnid);
                Console.WriteLine("Press Enter key to continue.");
                Console.ReadLine();
            }



            Console.WriteLine("Installer Processing Completed!");

            if (bWebLog)
            {
                pc.LogEvent(sUnid, " Installer Closing", 11000, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, " Installer Closing", 11000, pc.IBatchNo);
            }
            return;
        }
コード例 #4
0
        static void Main(string[] args)
        {
            // Initialize the program
            // Set starting conditions



            //string url = sHost + "Sheets/Version/070110/";
            //   HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
            //   using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
            //   {
            //       using (StreamReader reader = new StreamReader(response.GetResponseStream()))
            //       {
            //           string html = reader.ReadToEnd();

            //       }

            //   }


            /* Arguments
             * 0 host
             * 1 target directory
             * 2 unid
             *
             */
            // Current Build 28 Jan 2012
            bError = false;
            int   iCnt      = 0;
            short iSheetCnt = 0;

            Console.WriteLine("Installer Begins.");
            string sCmdLine = "";


            string currentAssemblyDirectoryName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);

            //if (File.Exists(currentAssemblyDirectoryName + @"\Clients.xml"))
            //// We will drive via file. Do the config
            //{
            //    XmlDocument xmld = new XmlDocument();
            //    xmld.Load(currentAssemblyDirectoryName + @"\Clients.xml");
            //    XmlNodeList nodesl = xmld.SelectNodes("//Client[@Install='Y']");



            //    foreach (XmlNode n in nodesl)
            //    {


            //        sHost = PartialInstaller.Properties.Settings.Default.Host;
            //        sUnid = n.Attributes["unid"].Value;
            //        sTarget = n.Attributes["target"].Value;
            //        sEmail = n.Attributes["email"].Value;
            //        Console.WriteLine("Unid = {0}", sUnid);
            //        Console.WriteLine("Target= {0}", sTarget);
            //        Console.WriteLine("Email = {0}", sEmail);
            //        Console.ReadLine();



            //    }
            //    // 3 October 2011
            //    // I have read the Class file
            //    // Just start normally
            //    goto setParms;
            //}



            try
            {
                string sQuote = "\"";

                sHost   = args[0];
                sUnid   = args[1];
                sUnid   = sUnid.Trim();
                sEmail  = args[2];
                sTarget = args[3];


                sTarget = sTarget.Replace(sQuote, "");
            }

            catch (Exception ex)
            {
                sHost = @"http://ccisupportsite.com";
                //      sTarget = @"c:\As400da\";
                //       sUnid = "4621E8E7157912B185257829006ECFC0";
                //      sEmail = "*****@*****.**";
                Console.WriteLine("Error - Parameter Signature Invalid " + ex.Message);
                // throw ex;

// fix the install directory
                if (!Directory.Exists(sTarget))
                {
                    iCnt = 0;
                    bool bValid = false;
                    while (iCnt <= 2 && !bValid)
                    {
                        Console.WriteLine("Problem with Target Location");
                        Console.WriteLine("The target {0} cannot be Validated Please Reenter:", sTarget);
                        sTarget = Console.ReadLine();
                        Console.WriteLine("");
                        sTarget = sTarget.Trim();
                        iCnt   += 1;

                        if (Directory.Exists(sTarget))
                        {
                            bValid = true;
                        }
                    }
                    if (iCnt > 2 && !bValid)
                    {
                        bError = true;
                    }
                }


                // fix the email address

                Console.WriteLine("Problem with Email Address");
                Console.WriteLine("The email address {0} cannot be Validated Please Reenter:", sEmail);
                sEmail = Console.ReadLine();
                Console.WriteLine("");
                sEmail = sEmail.Trim();
            }



setParms:



            iBatchCl = -999;
            // Lets Id the box
            PcId pc = new PcId(sUnid, sTarget, sEmail);

            pc.sEmail = sEmail;

            if (bError)
            {
                goto Done;
            }


            // 21 Jan 2011 - Added support for godaddy webservice and Id on box
            try
            {
                if (sEmail.Contains(@"cookconsulting.net"))
                {
                    goto Next;
                }

                //if (pc.ChkInstall(sUnid)  == "stop"  )
                //{
                //    Console.WriteLine("This install is terminated - This license code has been previously installed");
                //    bError = true;
                //    goto Done;
                //}


Next:


                pc.LogEvent();
                iBatchCl = pc.IBatchNo;
                bWebLog  = true;
                if (iBatchCl == -1)
                {
                    // logging is not available
                    bWebLog = false;
                    pc.CreateLogFile(sTarget);
                }
            }
            catch (Exception ex)
            {
                bWebLog = false;
                pc.CreateLogFile(sTarget);
            }

            //sUnid = sUnid.Trim();

            while (iCnt <= 2 && sUnid.Length != 32)
            {
                Console.Write("Problem with the Customer License Code Check your Cut and Past");
                Console.Write("The unid {0} cannot be Validated Please Reenter:", sUnid);
                sUnid = Console.ReadLine();
                Console.WriteLine("");
                sUnid = sUnid.Trim();
                iCnt += 1;
            }
            if (sUnid.Length != 32)
            {
                Console.WriteLine("The unid {0} cannot be Validated.", sUnid);
                bError = true;
                goto Done;
            }

            Console.WriteLine("Installer is running Batch ID -> {0} for UNID -> {1}.", iBatchCl, sUnid);


            ArrayList nProd = new ArrayList();

            //if (args.GetUpperBound(0) > 0)
            //    sUnid = args[0];

            // make sure our work directory exists

            FileInfo fi;

            try
            {
                if (!Directory.Exists(sTarget))
                {
                    Directory.CreateDirectory(sTarget);
                }
            }
            catch (Exception ex) {  }



            try
            {
                fi            = new FileInfo(sTarget + @"\Products.xml");
                fi.IsReadOnly = false;
                File.Delete(sTarget + @"\Products.xml");
            }
            catch { }


            try
            {
                fi            = new FileInfo(sTarget + @"\Cust.xml");
                fi.IsReadOnly = false;
                File.Delete(sTarget + @"\Cust.xml");
            }
            catch { }



            try
            {
                string sFileName = "";
                sFileName = sHost + @"/Xml/Products.xml";


                DownLoadASheet(sFileName, sTarget + @"\Products.Xml");



                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }

                //sFileName = sHost + @"/Xml/" + sUnid + @"/Cust.Xml";
                //DownLoadASheet(sFileName, sTarget + @"Cust.Xml");

                PartialInstaller.WSCustomer.GetCustomersPartialService gcp = new PartialInstaller.WSCustomer.GetCustomersPartialService();
                NetworkCredential cc = new NetworkCredential(@"mmoen", @"bobbob1", "");
                gcp.Credentials = cc;
                string sXmlOut = gcp.GETCUSTOMERSPARTIAL("changeor.nsf", "XMLOUTPUT", sUnid);

                StreamWriter swcust = new StreamWriter(sTarget + @"\Cust.Xml", false);

                swcust.Write(pc.PackXml(sXmlOut, sUnid));

                swcust.Close();
                swcust.Dispose();


                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"\Cust.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"\Cust.Xml", 0, pc.IBatchNo);
                }
            }
            catch (Exception ex)
            {
                bError = bError || true;

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + "Program Abort", 11000, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + "Program Abort", 11000, pc.IBatchNo);
                }

                // test
                try
                {
                    pc.Close();
                }
                catch { }

                Console.WriteLine("Program Stopping - " + ex.Message);
                goto Done;
            }


            fi = new FileInfo(sTarget + @"\Products.Xml");
            if (File.Exists(sTarget + @"\Products.Xml") && fi.Length == 0)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "Products File did not Download", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "Products File did not Download", -1, pc.IBatchNo);
                }

                bError = bError || true;

                goto Done;
            }

            fi = new FileInfo(sTarget + @"\Cust.Xml");

            if (File.Exists(sTarget + @"\Cust.Xml") && fi.Length == 0)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "Customer File did not Download", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "Customer File did not Download", -1, pc.IBatchNo);
                }
                bError = bError || true;

                goto Done;
            }

            if (bWebLog)
            {
                pc.LogEvent(sUnid, "File Download Complete ", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "File Download Complete ", 0, pc.IBatchNo);
            }
            // Process the xmlDoc

            XmlDocument xmldoc         = new XmlDocument();
            XmlDocument xmldocProducts = new XmlDocument();

            xmldocProducts.Load(sTarget + @"\Products.Xml");


            System.Text.UTF8Encoding str = new System.Text.UTF8Encoding();

            string       sContents;
            StreamReader sr = new StreamReader(sTarget + @"\Cust.Xml");

            sContents = sr.ReadToEnd();

            sr.Close();
            sr.Dispose();

            //byte[] b = Convert.FromBase64String(sContents);


            //sContents = System.Text.Encoding.UTF8.GetString(b);

            ////Byte[] sb1 = str.GetBytes(sContents);
            ////sContents = Convert.ToBase64String(sb1);
            ////sContents = Convert.ToString(sb1);
            //StreamWriter sw = new StreamWriter(sTarget + @"Cust.Xml", false);

            //sw.Write(sContents);
            //sw.Close();
            //sw.Dispose();



            xmldoc.Load(sTarget + @"\Cust.Xml");

            NameValueCollection nMethods = new NameValueCollection();
            //       LoadMethods(ref nMethods, xmldocMethods);

            //  Call the Config Clas
            DocDetails dt = new DocDetails(xmldocProducts);

            dt.SetProducts(nProd);

            NameValueCollection nParms = new NameValueCollection();

            XmlNode root;

            root = xmldoc.DocumentElement;

            XmlNodeList nodes;


            //  nodes = root.SelectNodes("Customer/Parms[@Sheet='Y']");
            nodes = root.SelectNodes("Customer/Parms");
            // Build all the nodes, mark which are sheets, which are parms.
            // Match it by queryand and sheet to determine the parms.

            string sQry = "";

            foreach (XmlNode n in nodes)
            {
                if (n.Name == "Parms")
                {
                    try
                    {
                        if (sQry == "")
                        {
                            sQry = n.Attributes["queryend"].Value;
                        }
                    }
                    catch (Exception ex)
                    { }
                }



                foreach (XmlAttribute att in n.Attributes)
                {
                    Debug.Print("att value={0} Attribute Name{1}", att.Value, att.Name);

                    if (att.Name == "Product" && att.Value == "Y")
                    {
                        iSheetCnt += 1;
                        Debug.Print("Got a Product{0}", n.Attributes["Value"].Value);

                        //     string sRemoteName = "http://localhost/sheets/" + n.Attributes["Value"].Value + ".xls";
                        //     string sLocalName = @"C:\cci\" + n.Attributes["Value"].Value + ".xls";
                        try
                        {
                            char[]   delimiterChars = { ',' };
                            string[] sqrysplit;
                            try
                            {
                                sQry      = nParms.Get("queryend").ToString();
                                sqrysplit = sQry.Split(delimiterChars);
                                sQry      = sqrysplit[0];
                            }
                            catch (Exception ex)
                            {
                                sQry = @"070110";
                            }

                            NameValueCollection tParms = FindParmSet(n.Attributes["Value"].Value, sQry, dt.cSheetColl, nParms);
                            string sFile       = FindLiveFile(n.Attributes["Value"].Value, sQry, dt.cSheetColl);
                            string sRemoteName = sHost + @"/sheets/version/" + sQry + @"/" + HttpUtility.UrlPathEncode(sFile);
                            string sLocalName  = sTarget + @"\" + sFile;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Downloading Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Downloading Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }

                            sCurrentFile = sRemoteName;
                            iDotCount    = 0;

                            if (File.Exists(sLocalName))
                            {
                                FileInfo fi2 = new FileInfo(sLocalName);
                                fi2.IsReadOnly = false;
                                fi2.Delete();
                            }

                            DownLoadASheet(sRemoteName, sLocalName);

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Download Complete Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Download Complete Sheet " + sRemoteName, 0, pc.IBatchNo);
                            }

                            //    Call Configure on it!
                            //       ConfigureASheet(sLocalName, ref  dt.cSheetColl, n.Value, sQry, nParms, dt);


                            bool bProcess = false;

                            fi = new FileInfo(sLocalName);



                            if (File.Exists(sLocalName) && fi.Length > 0)
                            {
                                try
                                {
                                    // inc the logger
                                    iLogCount += 1;

                                    if (!pc.bCust)
                                    {
                                        pc.LogEvent(sUnid, "", 10000, pc.IBatchNo);
                                        pc.bCust = true;
                                    }
                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Trying to configure " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Trying to configure " + sLocalName, 0, pc.IBatchNo);
                                    }


                                    ConfigureASheet(sLocalName, ref dt.cSheetColl, n.Attributes["Value"].Value, sQry, tParms, dt, ref pc);

                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }


                                    // System.Text.UTF8Encoding str = new System.Text.UTF8Encoding();

                                    //string sContents;
                                    //StreamReader sr = new StreamReader(sLocalName);
                                    //sContents = sr.ReadToEnd();

                                    //sr.Close();
                                    //sr.Dispose();

                                    //Byte[] sb1 = str.GetBytes(sContents);
                                    //sContents = Convert.ToBase64String(sb1);
                                    //sContents = Convert.ToString(sb1);
                                    //StreamWriter sw = new StreamWriter(sLocalName,false);

                                    //sw.Write(sContents);
                                    //sw.Close();
                                    //sw.Dispose();

                                    sQry = "";
                                }

                                catch (Exception ex)
                                {
                                    bError = bError || true;

                                    pc.LogEvent(sUnid, ex.Message + " - Configuring Sheet Fails", -1, pc.IBatchNo);
                                }
                            }
                            else
                            {
                                fi.Delete();
                            }
                            break;
                        }
                        catch (Exception ex)
                        {
                            bError = bError || true;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }

                            Console.WriteLine("Error - " + ex.Message);
                        }
                    }
                    else
                    { // it is not a sheet
                        try
                        {
                            if (nParms.Get(n.Attributes["LkeyName"].Value) != null)
                            {//skip it
                                string sKeyName    = n.Attributes["LkeyName"].Value;
                                string sKeyValue   = n.Attributes["Value"].Value;
                                string sCurrentVal = nParms.Get(n.Attributes["LkeyName"].Value);
                                Debug.Print("Atrib {0} ", n.Attributes["Value"].Value);
                                //       if (sKeyValue == sCurrentVal) goto Lp1;
                                switch (sKeyName)
                                {
                                //salariedcodes
                                //salariedwithsupp
                                //certifiedcodes
                                //princodes
                                //suppcodes


                                case "suppcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "princodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "certifiedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedwithsupp":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "otherdepts":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "budgetind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "specialind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "username":
                                    pc.setUser(n.Attributes["Value"].Value);
                                    break;

                                case "customername":
                                    pc.setCust(n.Attributes["Value"].Value);
                                    break;

                                default:
                                    break;
                                }
                                goto Lp1;
                            }

                            else
                            {
                                nParms.Add(n.Attributes["LkeyName"].Value, n.Attributes["Value"].Value);
                            }
                        }
                        catch (ArgumentOutOfRangeException ex)
                        { // is missing
                        }
                        catch
                        { }
                    }

                    Lp1 :;
                }
                ;
            }

            // Calling Configuration Class
            //  dt = new DocDetails(xmldocProducts );
            //  dt.SetProducts(nProd);
            //   dt.CallBudgetMethod(new sTheProducts());
            if (bWebLog)
            {
                pc.LogEvent(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            pc.Close();

            FileInfo
                fi1 = new FileInfo(sTarget + "Cust.xml");

            fi1.Delete();
            fi1 = new FileInfo(sTarget + "Products.xml");
            fi1.Delete();


Done:
            if (iSheetCnt == 0)
            {
                bError = true;
                Console.WriteLine("No Sheets were retrieved from WebService - Check Domino Sheet Selections");
            }

            if (bError)
            {
                Console.WriteLine("An Install Error has Occurred! Please Contact Support desk @ 800 425 0720 or email [email protected]");
                Console.WriteLine("Please note the following information Batch ID -> {0} and UNID -> {1}.", iBatchCl, sUnid);
                Console.WriteLine("Press Enter key to continue.");
                Console.ReadLine();
            }

            if (!bError)
            {
                try
                {
                    PartialInstaller.WSPartials.RemovePartialFlagsService rp = new PartialInstaller.WSPartials.RemovePartialFlagsService();
                    NetworkCredential cc = new NetworkCredential(@"mmoen", @"bobbob1", "");
                    rp.Credentials = cc;
                    rp.REMOVEPARTIALFLAGS("Changeor.nsf", "XMLOUTPUT", sUnid);
                }
                catch { }
            }

            Console.WriteLine("Installer Processing Completed!");

            if (bWebLog)
            {
                pc.LogEvent(sUnid, " Installer Closing", 11000, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, " Installer Closing", 11000, pc.IBatchNo);
            }
            return;
        }
コード例 #5
0
        static void Main(string[] args)
        {
            // Initialize the program
            // Set starting conditions
            bool bError = false;
            int  iCnt   = 0;

            Console.WriteLine("Installer Begins. {0}", System.Reflection.Assembly.GetExecutingAssembly().GetName().Version);
            string sQuote   = "\"";
            string sCmdLine = "";



            /* Arguments
             * 0 Install Location  \\server\share\    -  Install
             * 1 target directory  \\server\share\  - tied to unid
             * 2 unid
             * 3 email
             * 4 officesw
             */
            try
            {
                sHost = args[0];
                if (sHost.Contains("$"))
                {
                    sHost = sHost.Replace("$", "");
                }

                sTarget = args[1];
                if (sTarget.Contains("$"))
                {
                    sTarget = sTarget.Replace("$", "");
                }

                if (sTarget.EndsWith("\\"))
                {
                }
                else
                {
                    sTarget += "\\";
                }

                sUnid     = args[2];
                sEmail    = args[3];
                sOfficeSw = args[4];

                Console.WriteLine("Email is {0}", sEmail);
                string currentAssemblyDirectoryName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
            }

            catch
            {
                sHost     = @"\\Unknown";
                sTarget   = @"C:\AS400DA\";
                sUnid     = "";
                sEmail    = "*****@*****.**";
                sOfficeSw = "2007";
            }
            iBatchCl = -999;
            // Lets Id the box
            PcId pc = new PcId(sUnid, sTarget, sEmail);

            // 21 Jan 2011 - Added support for godaddy webservice and Id on box
            try
            {
                pc.LogEvent();
                iBatchCl = pc.IBatchNo;
                bWebLog  = true;
                if (iBatchCl == -1)
                {
                    // logging is not available
                    bWebLog = false;
                    pc.CreateLogFile(sTarget);
                }
            }
            catch (Exception ex)
            {
                bWebLog = false;
                pc.CreateLogFile(sTarget);
            }

            try
            {
                Directory.CreateDirectory(sTarget);
            }
            catch { }

            ArrayList nProd = new ArrayList();

            //if (args.GetUpperBound(0) > 0)
            //    sUnid = args[0];

            // make sure our work directory exists
            // Clear out old sheets
            string[] sFiles = Directory.GetFiles(sTarget);
            foreach (string f in sFiles)
            {
                FileInfo fd = new FileInfo(f);

                if (fd.Extension == ".xls" || fd.Extension == ".xlsm")
                {
                    fd.IsReadOnly = false;
                    fd.Delete();
                }
            }


            if (!Directory.Exists(sTarget))
            {
                Directory.CreateDirectory(sTarget);
            }
            else
            {
                sFiles = Directory.GetFiles(sTarget);
                foreach (string f in sFiles)
                {
                    FileInfo fd = new FileInfo(f);
                    if (fd.Extension == ".xls" || fd.Extension == ".xlsm")
                    {
                        fd.IsReadOnly = false;
                        fd.Delete();
                    }
                }
            }
            try
            {
                string sFileName = "";
                sFileName = sHost + @"Install\Xml\Products.xml";


                Console.WriteLine("Getting file {0}", sFileName);
                DownLoadASheet(sFileName, sTarget + @"Products.Xml");

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Products.Xml", 0, pc.IBatchNo);
                }

                sFileName = sHost + @"Install\Xml\" + sUnid + @"\Cust.Xml";
                Console.WriteLine("Getting file {0}", sFileName);
                DownLoadASheet(sFileName, sTarget + @"Cust.Xml");

                if (bWebLog)
                {
                    pc.LogEvent(sUnid, "File Download Complete on "
                                + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, "File Download Complete on "
                               + sTarget + @"Cust.Xml", 0, pc.IBatchNo);
                }
            }
            catch (Exception ex)
            {
                if (bWebLog)
                {
                    pc.LogEvent(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                else
                {
                    pc.FileLog(sUnid, ex.Message + " - Program Abort", -1, pc.IBatchNo);
                }
                try
                {
                    pc.Close();
                }
                catch { }

                Console.WriteLine("Program Stopping - " + ex.Message);
                return;
            }
            if (bWebLog)
            {
                pc.LogEvent(sUnid, "File Download Complete", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "File Download Complete", 0, pc.IBatchNo);
            }
            // Process the xmlDoc

            XmlDocument xmldoc         = new XmlDocument();
            XmlDocument xmldocProducts = new XmlDocument();

            xmldocProducts.Load(sTarget + @"\Products.Xml");


            System.Text.UTF8Encoding str = new System.Text.UTF8Encoding();

            string       sContents;
            StreamReader sr = new StreamReader(sTarget + @"Cust.Xml");

            sContents = sr.ReadToEnd();

            sr.Close();
            sr.Dispose();

            byte[] b = Convert.FromBase64String(sContents);


            sContents = System.Text.Encoding.UTF8.GetString(b);

            //Byte[] sb1 = str.GetBytes(sContents);
            //sContents = Convert.ToBase64String(sb1);
            //sContents = Convert.ToString(sb1);
            StreamWriter sw = new StreamWriter(sTarget + @"Cust.Xml", false);

            sw.Write(sContents);
            sw.Close();
            sw.Dispose();



            xmldoc.Load(sTarget + @"Cust.Xml");

            NameValueCollection nMethods = new NameValueCollection();
            //       LoadMethods(ref nMethods, xmldocMethods);

            //  Call the Config Clas
            DocDetails dt = new DocDetails(xmldocProducts);

            dt.SetProducts(nProd);

            NameValueCollection nParms = new NameValueCollection();

            XmlNode root;

            root = xmldoc.DocumentElement;

            XmlNodeList nodes;


            //  nodes = root.SelectNodes("Customer/Parms[@Sheet='Y']");
            nodes = root.SelectNodes("Customer/Parms");
            // Build all the nodes, mark which are sheets, which are parms.
            // Match it by queryand and sheet to determine the parms.

            string sQryP = "", sQry = "";

            foreach (XmlNode n in nodes)
            {
                if (n.Name == "Parms")
                {
                    try
                    {
                        if (sQry == "")
                        {
                            sQryP = n.Attributes["queryend"].Value;
                        }
                    }
                    catch (Exception ex)
                    { }
                }



                foreach (XmlAttribute att in n.Attributes)
                {
                    Debug.Print("att value={0} Attribute Name{1}", att.Value, att.Name);

                    if (att.Name == "Product" && att.Value == "Y")
                    {
                        Debug.Print("Got a Product{0}", n.Attributes["Value"].Value);

                        //     string sRemoteName = "http://localhost/sheets/" + n.Attributes["Value"].Value + ".xls";
                        //     string sLocalName = @"C:\cci\" + n.Attributes["Value"].Value + ".xls";
                        try
                        {
                            char[]   delimiterChars = { ',' };
                            string[] sqrysplit;
                            try
                            {
                                if (sQryP == "")
                                {
                                    sQryP     = nParms.Get("queryend").ToString();
                                    sqrysplit = sQryP.Split(delimiterChars);
                                    sQryP     = sqrysplit[0];
                                }
                            }
                            catch (Exception ex)
                            {
                                sQryP = @"070110";
                            }


                            string sQueryEnd;
                            // logic is there is a node queryend attribute use it
                            // else use the file queryend

                            if (sQry == "")
                            {
                                sQueryEnd = sQryP;
                            }
                            else
                            {
                                sQueryEnd = sQry;
                            }

                            NameValueCollection tParms = FindParmSet(n.Attributes["Value"].Value, sQueryEnd, dt.cSheetColl, nParms);
                            string sFile       = FindLiveFile(n.Attributes["Value"].Value, sQueryEnd, dt.cSheetColl);
                            string sRemoteName = sHost + @"Install\sheets\version\" + sQueryEnd + @"\" + sFile;
                            //HttpUtility.UrlPathEncode(sFile);
                            string sLocalName = sTarget + sFile;

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Downloading Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Downloading Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }

                            iDotCount = 0;

                            sCurrentFile = sRemoteName;
                            if (File.Exists(sLocalName))
                            {
                                FileInfo fi2 = new FileInfo(sLocalName);

                                fi2.Delete();
                            }
                            Console.WriteLine("Getting file {0}", sRemoteName);
                            DownLoadASheet(sRemoteName, sLocalName);

                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, "Download Complete Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, "Download Complete Sheet" + sRemoteName, 0, pc.IBatchNo);
                            }

                            //    Call Configure on it!
                            //       ConfigureASheet(sLocalName, ref  dt.cSheetColl, n.Value, sQry, nParms, dt);
                            FileInfo fi;

                            bool bProcess = false;

                            fi = new FileInfo(sLocalName);



                            if (File.Exists(sLocalName) && fi.Length > 0)
                            {
                                try
                                {
                                    // inc the logger
                                    iLogCount += 1;

                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Trying to configure" + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Trying to configure" + sLocalName, 0, pc.IBatchNo);
                                    }

                                    ConfigureASheet(sLocalName, ref dt.cSheetColl, n.Attributes["Value"].Value, sQueryEnd, tParms, dt, ref pc);
                                    if (bWebLog)
                                    {
                                        pc.LogEvent(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }
                                    else
                                    {
                                        pc.FileLog(sUnid, "Configuring " + sLocalName, 0, pc.IBatchNo);
                                    }



                                    sQry = "";
                                }

                                catch (Exception ex)
                                {
                                    pc.LogEvent(sUnid, ex.Message + " - Configuring Sheet Fails", -1, pc.IBatchNo);
                                }
                            }
                            else
                            {
                                fi.Delete();
                            }
                            break;
                        }
                        catch (Exception ex)
                        {
                            if (bWebLog)
                            {
                                pc.LogEvent(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }
                            else
                            {
                                pc.FileLog(sUnid, ex.Message + " - Downloading Sheet", -1, pc.IBatchNo);
                            }

                            Console.WriteLine("Error - " + ex.Message);
                        }
                    }
                    else
                    { // it is not a sheet
                        try
                        {
                            if (nParms.Get(n.Attributes["LkeyName"].Value) != null)
                            {//skip it
                                string sKeyName    = n.Attributes["LkeyName"].Value;
                                string sKeyValue   = n.Attributes["Value"].Value;
                                string sCurrentVal = nParms.Get(n.Attributes["LkeyName"].Value);
                                Debug.Print("Atrib {0} ", n.Attributes["Value"].Value);
                                Debug.Print("Key name is {0}", sKeyName);

                                if (sKeyName == "queryend" && sQryP == "")
                                {
                                    sQryP = n.Attributes["Value"].Value;
                                }

                                switch (sKeyName)
                                {
                                //salariedcodes
                                //salariedwithsupp
                                //certifiedcodes
                                //princodes
                                //suppcodes


                                case "suppcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "princodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "certifiedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedwithsupp":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "salariedcodes":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "otherdepts":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "budgetind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                case "specialind":
                                    nParms.Remove(n.Attributes["LkeyName"].Value);
                                    nParms.Add(n.Attributes["LkeyName"].Value
                                               , sCurrentVal
                                               + "," + sKeyValue);
                                    break;

                                default:
                                    break;
                                }
                                goto Lp1;
                            }

                            else
                            {
                                nParms.Add(n.Attributes["LkeyName"].Value, n.Attributes["Value"].Value);
                            }
                        }
                        catch (ArgumentOutOfRangeException ex)
                        { // is missing
                        }
                        catch
                        { }
                    }

                    Lp1 :;
                }
                ;
            }

            // Calling Configuration Class
            //  dt = new DocDetails(xmldocProducts );
            //  dt.SetProducts(nProd);
            //   dt.CallBudgetMethod(new sTheProducts());



Done:
            if (bError)
            {
            }


            if (bWebLog)
            {
                pc.LogEvent(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            else
            {
                pc.FileLog(sUnid, "Processing Completed", 0, pc.IBatchNo);
            }
            pc.Close();

            FileInfo
                fi1 = new FileInfo(sTarget + @"\Cust.xml");

            fi1.Delete();
            fi1 = new FileInfo(sTarget + @"\Products.xml");
            fi1.Delete();

            Console.WriteLine("Installer Processing Completed!");
        }
コード例 #6
0
        public void CallXlConfigure(Products pd, string sFileName, NameValueCollection nParms, string sQry, ref PcId pc)
        {
            Microsoft.Office.Interop.Excel.Workbook         wb;
            Microsoft.Office.Interop.Excel.ApplicationClass xl;
            xl = new Microsoft.Office.Interop.Excel.ApplicationClass();

            xl.DisplayAlerts = false;

            //  sFileName = @"C:\cci\";  // + sp.sFileName;

            // Build the call to setset the Excel Sheet
            try
            {
                // 2 August Late open excel after parm binding

                //if (pd.sVisible == "Y") xl.Visible = true;
                //else xl.Visible = false;


                //xl.Interactive = false;
                ////Microsoft.Office.Core.MsoAutomationSecurity secAuto = (MsoAutomationSecurity)MsoAutomationSecurity.msoAutomationSecurityLow;

                ////xl.Application.AutomationSecurity = secAuto;



                //wb = xl.Workbooks.Open(

                //              sFileName
                //              , 2
                //              , false,
                //              5,
                //              "",
                //              "",
                //              true,
                //              Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
                //              "\t",
                //              false,
                //              false,
                //              0,
                //              true,
                //              1,
                //              0);

                int iSize = nParms.Count + 1;

                System.Threading.AutoResetEvent waiter = new System.Threading.AutoResetEvent(false);

                while (xl.Ready != true)
                {
                    waiter.WaitOne(60 * 1000);
                }
                ;
                object[] oParms = new object[]
                {
                    pd.sMethodCall
                };
                //     ,"Hello World!"
                //     ,nvpKeys.Get("SystemNm")
                //     ,nvpKeys.Get("FinanceType")
                //     , null

                //  };
                int ix = 1;
                Array.Resize(ref oParms, iSize);
                foreach (string skey in nParms.Keys)
                {
                    string sVal = "";
                    sVal = nParms.Get(Convert.ToString(skey));
                    if (sVal != null)
                    {
                        if (sVal.Contains(","))
                        {// is an array
                            object[] sTarget;

                            sTarget    = processstring(sVal);
                            oParms[ix] = sTarget;
                        }
                        else
                        {
                            oParms[ix] = nParms.Get(skey);

                            if (skey == "queryend")
                            {
                                oParms[ix] = sQry;
                            }

                            // oParms[ix] = nParms.Get(skey);
                        }
                    }
                    else
                    {
                        oParms[ix] = nParms.Get(skey) == null ? "" : nParms.Get(skey);

                        if (
                            skey == "specialind" ||
                            skey == "budgetind" ||
                            skey == "otherdepts" ||
                            skey == "salariedcodes" ||
                            skey == "salariedwithsupp" ||
                            skey == "certifiedcodes" ||
                            skey == "princodes" ||
                            skey == "suppcodes"

                            )
                        {
                            oParms[ix] = new object[] { "" };
                        }
                    }
                    ix += 1;
                }


                if (oParms[0].ToString().Length + oParms[1].ToString().Length + oParms[2].ToString().Length == 0)
                {
                    //    pc.LogEvent(
                    throw new Exception("The parms are empty from cust.xml");
                }

                // 2 august 2012
                if (pd.sVisible == "Y")
                {
                    xl.Visible = true;
                }
                else
                {
                    xl.Visible = false;
                }


                xl.Interactive = false;
                //Microsoft.Office.Core.MsoAutomationSecurity secAuto = (MsoAutomationSecurity)MsoAutomationSecurity.msoAutomationSecurityLow;

                //xl.Application.AutomationSecurity = secAuto;



                wb = xl.Workbooks.Open(

                    sFileName
                    , 2
                    , false,
                    5,
                    "",
                    "",
                    true,
                    Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
                    "\t",
                    false,
                    false,
                    0,
                    true,
                    1,
                    0);

                // 2 august 2012



                // Sub SetSheet(ConnectionNm As String, SystemNm As String, SystemType As String, FinanceType As String, UserType As String, ProcPrefix As String, QueryEnd As String)

                //
                //tcookcci: Added another tag called Maintenance in the XML
                //(Y or N) - if they are not on Maintenance, it will be blank for now.
                //    The current QueryEnd is 070109 - once we are ready to update, it will change to 070110

                try
                {
                    if (pd.sMethodCall.Length > 0 && pd.sMethodCall != "None")
                    {
                        RunMacro(xl, oParms);
                    }
                }
                catch (Exception ex)
                { xl.Quit(); throw ex; }

                Debug.Print(xl.Version);


                try
                {
                    Type type = xl.GetType();


                    PropertyInfo prop = type.GetProperty("CheckCompatibility");
                    Console.WriteLine("Retrieved Xl Property");
                    prop.SetValue(xl, false, null);
                }
                catch { }

                string sFTarget = this.sTarget + pd.sProduct;

                if (String.Compare(xl.Version, "11.0") > 0)
                {
                    if (File.Exists(sFTarget + ".xlsm"))
                    {
                        FileInfo fi2 = new FileInfo(sFTarget + ".xlsm");
                        fi2.IsReadOnly = false;
                        fi2.Delete();
                    }



                    string sPth1 = sTarget + pd.sProduct + ".xlsm";
                    Console.WriteLine("Path to XL file is {0}", sPth1);

                    wb.SaveAs(sTarget + pd.sProduct + ".xlsm"
                              , 52, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                }
                else
                {
                    string sPth1 = sTarget + pd.sProduct + ".xlsm";
                    Console.WriteLine("Path to XL file is {0}", sPth1);

                    if (File.Exists(sFTarget + ".xls"))
                    {
                        FileInfo fi2 = new FileInfo(sFTarget + ".xls");
                        fi2.IsReadOnly = false;
                        fi2.Delete();
                    }



                    wb.SaveAs(sTarget + pd.sProduct + ".xls"
                              , XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                }


                xl.Quit();
            }
            catch (Exception ex)
            {
                if (xl != null)
                {
                    xl.Quit();
                }
                throw ex;
            }
            finally
            {
                try
                {
                    xl.Quit();
                }
                catch { }
            }
        }