form1.cs

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

        //        listBox1.Items.Insert(0, pack + "-" + dtdateold.Year.ToString().PadLeft(4, '0') + dtdateold.Month.ToString().PadLeft(2, '0') + dtdateold.Day.ToString().PadLeft(2, '0') + "-" + dtdatenew.Year.ToString().PadLeft(4, '0') + dtdatenew.Month.ToString().PadLeft(2, '0') + dtdatenew.Day.ToString().PadLeft(2, '0') + ".xml Create error.");
        //        listBox1.Items.Insert(0, ex.Message);
        //    }
        //    finally
        //    {
        //        oDA.Dispose();
        //    }

        //    try
        //    {
        //        objCom.CommandText = "delete from mytable" + StrText;
        //        objCom.Parameters.Add("@dtdatenew", dtdatenew);
        //        objCom.ExecuteNonQuery();
        //        objCon.Close();
        //    }
        //    catch (System.Exception e1)
        //    {
        //        listBox1.Items.Insert(0, "3 " + e1.Message);
        //    }
        //}

        private void timersave_Tick(object sender, EventArgs e)
        {
            update();
            usbupdate();
            try
            {
                //Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                //if (vpacktime != 0)
                //{
                //    if ((Datenew.AddDays(-vpackdaysave).CompareTo(vpacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                //    {
                //        timersave.Enabled = false;
                //        CreatXml("v", vpacksavelast, Datenew);
                //        //CreatTxt("v", vpacksavelast, Datenew);
                //        vpacksavelast = DateTime.Now.Date;
                //        timersave.Enabled = true;
                //        inputpack();
                //    }
                //}
                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (fipacktime != 0)
                {
                    if ((Datenew.AddDays(-fipackdaysave).CompareTo(fipacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                    {
                        timersave.Enabled = false;

                        Xmlfile ThreadProc = new Xmlfile("fi", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread fithread = new Thread(ThreadProc.CreatXml);
                        fithread.Start();

                        //CreatXml("fi", fipacksavelast, Datenew);
                        //CreatTxt("fi", fipacksavelast, Datenew);
                        fipacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }
                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (sipacktime != 0)
                {
                    if ((Datenew.AddDays(-sipackdaysave).CompareTo(sipacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                    {
                        timersave.Enabled = false;

                        Xmlfile ThreadProc = new Xmlfile("si", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread sithread = new Thread(ThreadProc.CreatXml);
                        sithread.Start();
                        //CreatXml("si", sipacksavelast, Datenew);
                        //CreatTxt("si", sipacksavelast, Datenew);
                        sipacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }
                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (dipacktime != 0)
                {
                    if ((Datenew.AddDays(-dipackdaysave).CompareTo(dipacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                    {
                        timersave.Enabled = false;
                        Xmlfile ThreadProc = new Xmlfile("di", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread dithread = new Thread(ThreadProc.CreatXml);
                        dithread.Start();
                        //CreatXml("di", dipacksavelast, Datenew);
                        //CreatTxt("di", dipacksavelast, Datenew);
                        dipacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }
                //Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                //if (aipacktime != 0)
                //{
                //    if ((Datenew.AddDays(-aipackdaysave).CompareTo(aipacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                //    {
                //        timersave.Enabled = false;
                //        CreatXml("A", aipacksavelast, Datenew);
                //        //CreatTxt("ai", aipacksavelast, Datenew);
                //        aipacksavelast = DateTime.Now.Date;
                //        timersave.Enabled = true;
                //        inputpack();
                //    }
                //}

                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (epacktime != 0)
                {
                    if ((Datenew.AddDays(-epackdaysave).CompareTo(epacksavelast) >= 0) && (DateTime.Now.Hour >= 1) && (DateTime.Now.Minute >= 10))
                    {
                        timersave.Enabled = false;
                        Xmlfile ThreadProc = new Xmlfile("W", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread wthread = new Thread(ThreadProc.CreatXml);
                        wthread.Start();
                        //CreatXml("W", epacksavelast, Datenew);
                        //CreatTxt("ai", aipacksavelast, Datenew);
                        epacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }

                //Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                //if (ippacktime != 0)
                //{
                //    if ((Datenew.AddDays(-ippackdaysave).CompareTo(ippacksavelast) >= 0) && (DateTime.Now.Hour >= 1))
                //    {
                //        timersave.Enabled = false;
                //        CreatXml("ip", ippacksavelast, Datenew);
                //        //CreatTxt("ip", ippacksavelast, Datenew);
                //        ippacksavelast = DateTime.Now.Date;
                //        timersave.Enabled = true;
                //        inputpack();
                //    }
                //}
                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (fpacktime != 0)
                {
                    if ((Datenew.AddDays(-fpackdaysave).CompareTo(fpacksavelast) >= 0) && (DateTime.Now.Hour >= 1) && (DateTime.Now.Minute >= 20))
                    {
                        timersave.Enabled = false;
                        Xmlfile ThreadProc = new Xmlfile("f", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread fthread = new Thread(ThreadProc.CreatXml);
                        fthread.Start();
                        //CreatXml("f", fpacksavelast, Datenew);
                        //CreatTxt("f", fpacksavelast, Datenew);
                        fpacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }
                Datenew = DateTime.Now.Date;//.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                if (spacktime != 0)
                {
                    if ((Datenew.AddDays(-spackdaysave).CompareTo(spacksavelast) >= 0) && (DateTime.Now.Hour >= 1) && (DateTime.Now.Minute >= 30))
                    {
                        timersave.Enabled = false;

                        Xmlfile ThreadProc = new Xmlfile("s", fipacksavelast, Datenew, CodePath, Dbname);
                        Thread sthread = new Thread(ThreadProc.CreatXml);
                        sthread.Start();
                        //CreatXml("s", spacksavelast, Datenew);
                        //CreatTxt("s", spacksavelast, Datenew);
                        spacksavelast = DateTime.Now.Date;
                        timersave.Enabled = true;
                        inputpack();
                    }
                }
            }
            catch (System.Exception e1)
            {
                //MessageBox.Show(e1.Message + " 4");
                listBox1.Items.Insert(0, "4 " + e1.Message);
            }

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


                XmlNode xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "VPACK" + '"' + "]");
                vpackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                vpacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                vpackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    vpacksavelast = DateTime.Now.Date;
                }
                else
                {
                    vpacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "FIPACK" + '"' + "]");
                fipackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                fipacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                fipackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    fipacksavelast = DateTime.Now.Date;
                }
                else
                {
                    fipacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "SIPACK" + '"' + "]");
                sipackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                sipacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                sipackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    sipacksavelast = DateTime.Now.Date;
                }
                else
                {
                    sipacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "DIPACK" + '"' + "]");
                dipackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                dipacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                dipackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    dipacksavelast = DateTime.Now.Date;
                }
                else
                {
                    dipacksavelast = DateTime.Parse(xmlnode.SelectSingleNode("PackSaveLast").InnerText);
                }

                xmlnode = xmlDoc.SelectSingleNode("XMLDCM/XMLPack/Pack[PackName=" + '"' + "AIPACK" + '"' + "]");
                aipackcontent = xmlnode.SelectSingleNode("PackContent").InnerText;
                aipacktime = int.Parse(xmlnode.SelectSingleNode("PackTime").InnerText);
                aipackdaysave = int.Parse(xmlnode.SelectSingleNode("PackDaySave").InnerText);
                if (xmlnode.SelectSingleNode("PackSaveLast").InnerText == "0")
                {
                    aipacksavelast = DateTime.Now.Date;
                }
                else
                {