form1.cs

在VS2005下写的把SQLCE上的数据库数据导出为XML的应用程序

                    aipacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }


                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "EPACK" + '"' + "]");
                epackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                epacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                epackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    epacksavelast = DateTime.Now.Date;
                }
                else
                {
                    epacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SETIP" + '"' + "]");
                ippackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                ippacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                ippackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    ippacksavelast = DateTime.Now.Date;
                }
                else
                {
                    ippacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "FPACK" + '"' + "]");
                fpackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                fpacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                fpackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    fpacksavelast = DateTime.Now.Date;
                }
                else
                {
                    fpacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SPACK" + '"' + "]");
                spackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                spacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                spackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    spacksavelast = DateTime.Now.Date;
                }
                else
                {
                    spacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlDoc.Save(XMLpathname);
            }
            catch (Exception e1)
            {
                listBox1.Items.Insert(0, "5 " + e1.Message);
            }

        }
        private void inputpack()
        {
            try
            {
                XmlDocument xmlDoc = new XmlDocument();
                xmlDoc.Load(XMLpathname);


                XmlNode xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "VPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText=vpackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText=vpacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText=vpackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText=vpacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "FIPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = fipackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = fipacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = fipackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = fipacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SIPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = sipackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = sipacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = sipackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = sipacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "DIPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = dipackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = dipacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = dipackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = dipacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "AIPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = aipackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = aipacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = aipackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = aipacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);
                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "EPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = epackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = epacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = epackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = epacksavelast.ToString();

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SETIP" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = ippackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = ippacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = ippackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = ippacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);
                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "FPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = fpackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = fpacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = fpackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = fpacksavelast.ToString();
                //xmlDoc.Save(XMLpathname);


                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SPACK" + '"' + "]");
                xmlnode.SelectSingleNode("PackContent").InnerText = spackcontent;
                xmlnode.SelectSingleNode("PackTime").InnerText = spacktime.ToString();
                xmlnode.SelectSingleNode("PackDaySave").InnerText = spackdaysave.ToString();
                xmlnode.SelectSingleNode("PackSaveLast").InnerText = spacksavelast.ToString();


                xmlDoc.Save(XMLpathname);
            }
            catch (Exception e1)
            {

                //MessageBox.Show(e1.Message + " 6");
                listBox1.Items.Insert(0, "61 " + e1.Message);
            }

        }

        private void btnstart_Click(object sender, EventArgs e)
        {
            start();
        }
        private void start()
        {
            try
            {
                CodePath = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
                CodePath = CodePath.Substring(0, CodePath.LastIndexOf(@"\"));
                Dbname = "MyDatabase.SDF";
                //Dateold = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                //XMLname = "XMLDCM.xml";
                XMLname = "DCM_Config.xml";
                XMLname = "www\\XML\\" + XMLname;
                XMLpathname = CodePath + "\\" + XMLname;
                if (!System.IO.File.Exists(XMLpathname))
                {
                    listBox1.Items.Insert(0, "XML file is not exist.");
                }
                outputpack();
                inputpack();
                listBox1.Items.Insert(0, "DCMAutoSave Start.");
            }
            catch
            {
            }
        }
        public void WriteRegistry()
        {
            RegistryKey hklm = Registry.LocalMachine;
            RegistryKey init = hklm.OpenSubKey("init", true);
            string CodePath1 = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
            init.SetValue("Launch120", CodePath1);
            init.Close();
            hklm.Close();

            hklm = Registry.LocalMachine;
            init = hklm.CreateSubKey("DCMSYSTEM");
            init.SetValue("DCMAutoSave", "open");
            init.Close();
            hklm.Close();
        }
        private void btnclose_Click(object sender, EventArgs e)
        {
            listBox1.Items.Insert(0, "DCMAutoSave Close.");
            Close();
        }

        private void usbupdate()
        {
            Process p;//= new Process();

            string filetxt = "USB Hard Disk\\DCMupdate" + "\\" + "DCMautoupdate.txt";

            try
            {

                if (!File.Exists(filetxt))
                {
                    FileStream fs = File.Create(filetxt);
                    fs.Close();

                    p = new Process();
                    p.StartInfo.FileName = "USB Hard Disk\\DCMupdate" + "\\" + "DCMautoupdate.exe";
                    p.Start();
                }
            }
            catch
            {
                //listBox1.Items.Insert(0, "usbupdate error.");
            }
        }

        private void update()
        {
            string temp;
            RegistryKey hklm = Registry.LocalMachine;
            RegistryKey init = hklm.OpenSubKey("DCMSYSTEM", true);

            //string CodePath1 = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;
            temp = init.GetValue("DCMAutoSave").ToString();
            if (temp == "close")
            {
                init.SetValue("DCMAutoSave", "update");
                Close();
            }
            init.Close();
            hklm.Close();
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
        }

        private void menuItem2_Click(object sender, EventArgs e)
        {
            MessageBox.Show(strversion);
        }
    }
}