public void download()
        {
            AccessCmd cmd = new AccessCmd();
            AccessCmd comd = new AccessCmd(0);
            //下载界面元素信息
            try
            {
                request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/TemplateParam?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
                XmlDocument doc = new XmlDocument();
                string strXml = request.HtmlDocument;
                Console.WriteLine(strXml);
                if (strXml.IndexOf("<templates>") >= 0)
                {
                    //加载服务器信息
                    doc.LoadXml(strXml);
                    //加载顶部框架信息
                    XmlNodeList xnlTop = doc.GetElementsByTagName("top").Item(0).ChildNodes;
                    XmlNodeList xnlBottom = doc.GetElementsByTagName("bottom").Item(0).ChildNodes;
                    XmlNodeList xnlMiddle = doc.GetElementsByTagName("middle").Item(0).ChildNodes;

                    List<XmlNodeList> lst_xnl = new List<XmlNodeList>();
                    lst_xnl.Add(xnlTop);
                    for (int j = 0; j < xnlMiddle.Count; j++)
                    {
                        lst_xnl.Add(xnlMiddle[j].ChildNodes);
                    }
                    lst_xnl.Add(xnlBottom);

                    //加载本地信息
                    string strSql = "select * from t_bz_templates order by strId asc";
                    OleDbDataReader reader = comd.ExecuteReader(strSql);
                    List<Element> lstLocal = new List<Element>();
                    while (reader.Read())
                    {
                        Element element = new Element(reader);
                        lstLocal.Add(element);
                    }
                    reader.Close();

                    int index = 0;
                    //依次对比服务器与本地信息,保证两者一致
                    for (int t = 0; t < lst_xnl.Count; t++)
                    {
                        XmlNodeList xnlTemp = lst_xnl[t];
                        for (int i = 0; i < xnlTemp.Count; i++)
                        {
                            try
                            {
                                //获得服务器记录信息
                                XmlElement  xe = (XmlElement)xnlTemp[i];
                                String strLocation, strSize, strBgImage, strFontFamily, strContent, strFontSize, strFontColor, strSort;
                                getTemplateProps(xe, out strLocation, out strSize, out strBgImage, out strFontFamily, out strContent, out strFontSize, out strFontColor, out strSort);
                                //比对本地信息
                                Element localtemplate = lstLocal.ElementAt(Convert.ToInt16(strSort) - 1);

                                //找到本地信息,先更新图片
                                bool bolImg = true;
                                bolImg = createImg("template", strBgImage);

                                //图片操作正常,删除原图片并更新数据库
                                if (bolImg)
                                {
                                    comd.ExecuteNonQuery("update t_bz_templates set strLocation='" + strLocation + "',strSize='" + strSize + "',strFontFamily='" + strFontFamily +
                                        "',strContent='" + strContent + "',intFontSize=" + Convert.ToInt16(strFontSize) + ",strFontColor='" + strFontColor + "' where strName='"+localtemplate.strName+"'");
                                }
                                index++;
                                continue;
                            }
                            catch (Exception e)
                            {
                                ErrorLog.log(e);
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);

            }
            comd.Close();

            //下载商家信息
            try
            {
                request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/ShopDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
                XmlDocument doc = new XmlDocument();
                string strXml = request.HtmlDocument;
                if (strXml.IndexOf("<shops>") > 0)
                {
                    //加载服务器信息
                    doc.LoadXml(strXml);
                    XmlNodeList xnlShop = doc.GetElementsByTagName("shop");
                    //加载本地信息
                    string strSql = "select strId,strSmallImg,strLargeImg from t_bz_shop";
                    OleDbDataReader reader = cmd.ExecuteReader(strSql);
                    List<Shop> lstShop = new List<Shop>();
                    while (reader.Read())
                    {
                        Shop shop = new Shop(reader);
                        lstShop.Add(shop);
                    }
                    reader.Close();
                    //依次对比服务器与本地信息,保证两者一致
                    for (int i = 0; i < xnlShop.Count; i++)
                    {
                        try
                        {
                            //获得服务器记录信息
                            XmlElement xeShop = (XmlElement)xnlShop.Item(i);
                            String strId, strBizName, strShopName, strTrade, strAddr, strIntro, strSmallImg, strLargeImg, intType, intSort;
                            getShopProps(xeShop, out strId, out strBizName, out strShopName, out strTrade, out strAddr, out strIntro, out strSmallImg, out strLargeImg, out intType, out intSort);
                            //比对本地信息
                            for (int j = 0; j < lstShop.Count; j++)
                            {
                                Shop localShop = lstShop.ElementAt(j);
                                if (localShop.StrId.Equals(strId))
                                {
                                    //找到本地信息,先更新图片
                                    bool bolImg = true;
                                    if (strSmallImg.Length > 0 && !strSmallImg.Equals(localShop.StrSmallImg))
                                    {
                                        bolImg = createImg("shop", strSmallImg);
                                    }
                                    if (bolImg && strLargeImg.Length > 0 && !strLargeImg.Equals(localShop.StrLargeImg))
                                    {
                                        bolImg = createImg("shop", strLargeImg);
                                    }
                                    //考虑数据库中有记录,但图片不存在的情况
                                    if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\shop\\" + strSmallImg))
                                    {
                                        bolImg = bolImg && createImg("shop", strSmallImg);
                                    }
                                    if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\shop\\" + strLargeImg))
                                    {
                                        bolImg = bolImg && createImg("shop", strLargeImg);
                                    }
                                    //图片操作正常,删除原图片并更新数据库
                                    if (bolImg)
                                    {
                                        cmd.ExecuteNonQuery("update t_bz_shop set strBizName='" + strBizName + "',strShopName='" + strShopName + "',strTrade='" + strTrade + "',strAddr='" + strAddr +
                                            "',strIntro='" + strIntro + "',strSmallImg='" + strSmallImg + "',strLargeImg='" + strLargeImg + "',intType=" + intType + ",intSort=" + intSort +
                                            " where strId='" + strId + "'");
                                        if (!strSmallImg.Equals(localShop.StrSmallImg))
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrSmallImg);
                                        if (!strLargeImg.Equals(localShop.StrLargeImg))
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrLargeImg);
                                    }
                                    strId = "";
                                    lstShop.Remove(localShop);
                                    break;
                                }
                            }
                            if (strId.Length > 0)
                            {
                                //本地没有找到,先增加图片
                                bool bolImg = true;
                                if (strSmallImg.Length > 0)
                                {
                                    bolImg = createImg("shop", strSmallImg);
                                }
                                if (bolImg && strLargeImg.Length > 0)
                                {
                                    bolImg = createImg("shop", strLargeImg);
                                }
                                //图片操作正常,更新数据库
                                if (bolImg)
                                {
                                    cmd.ExecuteNonQuery("insert into t_bz_shop(strId,strBizName,strShopName,strTrade,strAddr,strIntro,strSmallImg,strLargeImg,intType,intSort) values('" +
                                        strId + "','" + strBizName + "','" + strShopName + "','" + strTrade + "','" + strAddr + "','" + strIntro + "','" + strSmallImg + "','" + strLargeImg +
                                        "'," + intType + "," + intSort + ")");
                                }
                            }
                        }
                        catch (Exception e)
                        {
                            ErrorLog.log(e);
                        }
                    }
                    //删除本地没有匹配的记录
                    for (int i = 0; i < lstShop.Count; i++)
                    {
                        Shop localShop = lstShop.ElementAt(i);
                        cmd.ExecuteNonQuery("delete from t_bz_shop where strId='" + localShop.StrId + "'");
                        if (localShop.StrSmallImg.Length > 0)
                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrSmallImg);
                        if (localShop.StrLargeImg.Length > 0)
                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrLargeImg);
                    }
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);
            }

            //下载优惠券信息
            try
            {
                request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/CouponDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
                XmlDocument doc = new XmlDocument();
                string strXml = request.HtmlDocument;
                if (strXml.IndexOf("<coupons>") > 0)
                {
                    //加载服务器信息
                    doc.LoadXml(strXml);
                    XmlNodeList xnlCoupon = doc.GetElementsByTagName("coupon");
                    //加载本地信息
                    string strSql = "select strId,strSmallImg,strLargeImg,strPrintImg from t_bz_coupon";
                    OleDbDataReader reader = cmd.ExecuteReader(strSql);
                    List<Coupon> lstCoupon = new List<Coupon>();
                    while (reader.Read())
                    {
                        Coupon coupon = new Coupon(reader);
                        lstCoupon.Add(coupon);
                    }
                    reader.Close();
                    //依次对比服务器与本地信息,保证两者一致
                    for (int i = 0; i < xnlCoupon.Count; i++)
                    {
                        try
                        {
                            //获得服务器记录信息
                            XmlElement xeCoupon = (XmlElement)xnlCoupon.Item(i);
                            String strId, strName, dtActiveTime, dtExpireTime, strShopId, strSmallImg, strLargeImg, strPrintImg, strIntro, strInstruction;
                            int intVip, intRecommend, intSendBySM;
                            float flaPrice;
                            getCouponProps(xeCoupon, out strId, out strName, out dtActiveTime, out dtExpireTime, out strShopId, out intVip, out flaPrice, out intRecommend,
                                out strSmallImg, out strLargeImg, out strPrintImg, out strIntro, out strInstruction,out intSendBySM);

                            //比对本地信息
                            for (int j = 0; j < lstCoupon.Count; j++)
                            {
                                Coupon localCoupon = lstCoupon.ElementAt(j);
                                if (localCoupon.StrId.Equals(strId))
                                {
                                    //找到本地信息,先更新图片
                                    bool bolImg = true;
                                    if (strSmallImg.Length > 0 && !strSmallImg.Equals(localCoupon.StrSmallImg))
                                    {
                                        bolImg = createImg("coupon", strSmallImg);
                                    }
                                    if (bolImg && strLargeImg.Length > 0 && !strLargeImg.Equals(localCoupon.StrLargeImg))
                                    {
                                        bolImg = createImg("coupon", strLargeImg);
                                    }
                                    if (bolImg && strPrintImg.Length > 0 && !strPrintImg.Equals(localCoupon.StrPrintImg))
                                    {
                                        bolImg = createImg("coupon", strPrintImg);
                                    }
                                    //考虑数据库中有记录,但图片不存在的情况
                                    if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strSmallImg))
                                    {
                                        bolImg = bolImg && createImg("coupon", strSmallImg);
                                    }
                                    if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strLargeImg))
                                    {
                                        bolImg = bolImg && createImg("coupon", strLargeImg);
                                    }
                                    if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strPrintImg))
                                    {
                                        bolImg = bolImg && createImg("coupon", strPrintImg);
                                    }
                                    //图片操作正常,删除原图片并更新数据库
                                    if (bolImg)
                                    {
                                        cmd.ExecuteNonQuery("update t_bz_coupon set strName='" + strName + "',dtActiveTime='" + dtActiveTime + "',dtExpireTime='" + dtExpireTime +
                                            "',strShopId='" + strShopId + "',intVip=" + intVip + ",intRecommend=" + intRecommend + ",flaPrice=" + flaPrice + ",strSmallImg='" + strSmallImg +
                                            "',strLargeImg='" + strLargeImg + "',strPrintImg='" + strPrintImg + "',strIntro='" + strIntro + "',strInstruction='" + strInstruction + "',intSendBySM=" + intSendBySM +
                                            " where strId='" + strId + "'");
                                        if (!strSmallImg.Equals(localCoupon.StrSmallImg))
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrSmallImg);
                                        if (!strLargeImg.Equals(localCoupon.StrLargeImg))
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrLargeImg);
                                        if (!strPrintImg.Equals(localCoupon.StrPrintImg))
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrPrintImg);
                                    }
                                    strId = "";
                                    lstCoupon.Remove(localCoupon);
                                    break;
                                }
                            }
                            if (strId.Length > 0)
                            {
                                //本地没有找到,先增加图片
                                bool bolImg = true;
                                if (strSmallImg.Length > 0)
                                {
                                    bolImg = createImg("coupon", strSmallImg);
                                }
                                if (bolImg && strLargeImg.Length > 0)
                                {
                                    bolImg = createImg("coupon", strLargeImg);
                                }
                                if (bolImg && strPrintImg.Length > 0)
                                {
                                    bolImg = createImg("coupon", strPrintImg);
                                }
                                //图片操作正常,更新数据库
                                if (bolImg)
                                {
                                    cmd.ExecuteNonQuery("insert into t_bz_coupon(strId,strName,dtActiveTime,dtExpireTime,strShopId,intVip,intRecommend,flaPrice,strSmallImg,strLargeImg," +
                                        "strPrintImg,strIntro,strInstruction) values('" + strId + "','" + strName + "','" + dtActiveTime + "','" + dtExpireTime + "','" + strShopId + "'," +
                                        intVip + "," + intRecommend + "," + flaPrice + ",'" + strSmallImg + "','" + strLargeImg + "','" + strPrintImg + "','" + strIntro + "','" +
                                        strInstruction + "')");
                                }
                            }
                        }
                        catch (Exception e)
                        {
                            ErrorLog.log(e);
                        }
                    }
                    //删除本地没有匹配的记录
                    for (int i = 0; i < lstCoupon.Count; i++)
                    {
                        Coupon localCoupon = lstCoupon.ElementAt(i);
                        cmd.ExecuteNonQuery("delete from t_bz_coupon where strId='" + localCoupon.StrId + "'");
                        if (localCoupon.StrSmallImg.Length > 0)
                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrSmallImg);
                        if (localCoupon.StrLargeImg.Length > 0)
                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrLargeImg);
                        if (localCoupon.StrPrintImg.Length > 0)
                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrPrintImg);
                    }
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);
            }

            //下载广告信息
            try
            {
                request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/AdDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
                XmlDocument doc = new XmlDocument();
                string strXml = request.HtmlDocument;
                if (strXml.IndexOf("<ads>") > 0)
                {
                    //加载服务器信息
                    doc.LoadXml(strXml);
                    XmlNodeList xnlAd = doc.GetElementsByTagName("ad");
                    //加载本地信息
                    string strSql = "select strId,intType,strContent from t_bz_advertisement";
                    OleDbDataReader reader = cmd.ExecuteReader(strSql);
                    List<Advertisement> lstAd = new List<Advertisement>();
                    while (reader.Read())
                    {
                        Advertisement ad = new Advertisement(reader);
                        lstAd.Add(ad);
                    }
                    reader.Close();
                    //依次对比服务器与本地信息,保证两者一致
                    for (int i = 0; i < xnlAd.Count; i++)
                    {
                        try
                        {
                            //获得服务器记录信息
                            XmlElement xeAd = (XmlElement)xnlAd.Item(i);
                            String strId, strName, strContent, dtStartTime, dtEndTime;
                            int intType;
                            getAdProps(xeAd, out strId, out strName, out intType, out strContent, out dtStartTime, out dtEndTime);
                            //比对本地信息
                            for (int j = 0; j < lstAd.Count; j++)
                            {
                                Advertisement localAd = lstAd.ElementAt(j);
                                if (localAd.StrId.Equals(strId))
                                {
                                    //找到本地信息,先更新图片
                                    bool bolImg = true;
                                    if (intType < 3 && strContent.Length > 0 && !strContent.Equals(localAd.StrContent))
                                    {
                                        if (intType == 1)
                                        {
                                            bolImg = createImg("ad", strContent);
                                        }
                                        else if (intType == 2)
                                        {
                                            string[] aryFile = strContent.Split(new char[] { ',' });
                                            for (int k = 0; k < aryFile.Length; k++)
                                            {
                                                bolImg = bolImg && createImg("ad", aryFile[k]);
                                            }
                                        }
                                    }
                                    //考虑数据库中有记录,但图片不存在的情况
                                    if (intType == 1 && !File.Exists(System.Windows.Forms.Application.StartupPath + "\\ad\\" + strContent))
                                    {
                                        bolImg = bolImg && createImg("ad", strContent);
                                    }
                                    else if (intType == 2)
                                    {
                                        string[] aryFile = strContent.Split(new char[] { ',' });
                                        for (int k = 0; k < aryFile.Length; k++)
                                        {
                                            if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]))
                                            {
                                                bolImg = bolImg && createImg("ad", aryFile[k]);
                                            }
                                        }

                                    }
                                    //图片操作正常,删除原图片并更新数据库
                                    if (bolImg)
                                    {
                                        cmd.ExecuteNonQuery("update t_bz_advertisement set strName='" + strName + "',intType=" + intType + ",strContent='" + strContent +
                                            "',dtStartTime='" + dtStartTime + "',dtEndTime='" + dtEndTime + "' where strId='" + strId + "'");
                                        if (localAd.IntType == 1 && !strContent.Equals(localAd.StrContent))
                                        {
                                            File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + localAd.StrContent);
                                        }
                                        else if (localAd.IntType == 2 && !strContent.Equals(localAd.StrContent))
                                        {
                                            string[] aryFile = localAd.StrContent.Split(new char[] { ',' });
                                            for (int k = 0; k < aryFile.Length; k++)
                                            {
                                                File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]);
                                            }
                                        }
                                    }
                                    strId = "";
                                    lstAd.Remove(localAd);
                                    break;
                                }
                            }
                            if (strId.Length > 0)
                            {
                                //本地没有找到,先增加图片
                                bool bolImg = true;
                                if (intType < 3 && strContent.Length > 0)
                                {
                                    if (intType == 1)
                                    {
                                        bolImg = createImg("ad", strContent);
                                    }
                                    else if (intType == 2)
                                    {
                                        string[] aryFile = strContent.Split(new char[] { ',' });
                                        for (int k = 0; k < aryFile.Length; k++)
                                        {
                                            bolImg = bolImg && createImg("ad", aryFile[k]);
                                        }
                                    }
                                }
                                //图片操作正常,更新数据库
                                if (bolImg)
                                {
                                    cmd.ExecuteNonQuery("insert into t_bz_advertisement(strId,strName,intType,strContent,dtStartTime,dtEndTime) values('" + strId + "','" + strName + "'," +
                                        intType + ",'" + strContent + "','" + dtStartTime + "','" + dtEndTime + "')");
                                }
                            }
                        }
                        catch (Exception e)
                        {
                            ErrorLog.log(e);
                        }
                    }
                    //删除本地没有匹配的记录
                    for (int i = 0; i < lstAd.Count; i++)
                    {
                        Advertisement localAd = lstAd.ElementAt(i);
                        cmd.ExecuteNonQuery("delete from t_bz_advertisement where strId='" + localAd.StrId + "'");
                        if (localAd.StrContent.Length > 0)
                        {
                            if (localAd.IntType == 1)
                            {
                                File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + localAd.StrContent);
                            }
                            else if (localAd.IntType == 2)
                            {
                                string[] aryFile = localAd.StrContent.Split(new char[] { ',' });
                                for (int k = 0; k < aryFile.Length; k++)
                                {
                                    File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);
            }
            cmd.Close();
        }
示例#2
0
        /// <summary>
        /// 加载界面元素
        /// </summary>
        private void LoadTemplates()
        {
            string sql = "select * from t_bz_templates order by strId asc";
            AccessCmd cmd = new AccessCmd(0);
            OleDbDataReader reader = cmd.ExecuteReader(sql);
            List<Element> lstlocal = new List<Element>();

            while (reader.Read())
            {
                Element element = new Element(reader);
                lstlocal.Add(element);
            }

            reader.Close();
            cmd.Close();
            for (int i = 0; i < lstlocal.Count; i++)
            {
                Element element = lstlocal.ElementAt(i);
                if (element.strCtlName == "PB_Shop_Type2_NextPage")
                {
                    Console.WriteLine("");
                }
                Control ctl = GetControl(element.strCtlName);
                if (ctl == null)
                    continue;

                try
                {
                    if (!element.strLocation.Equals(""))
                    {
                        Point old_P = ctl.Location;
                        try
                        {
                            ctl.Location = new Point(Convert.ToInt32(element.strLocation.Split(',')[0]), Convert.ToInt32(element.strLocation.Split(',')[1]));
                        }
                        catch
                        {
                            ctl.Location = old_P;
                        }

                        Size old_S = ctl.Size;
                        try
                        {
                            ctl.Size = new Size(Convert.ToInt32(element.strSize.Split(',')[0]), Convert.ToInt32(element.strSize.Split(',')[1]));
                        }
                        catch
                        {
                            ctl.Size = old_S;
                        }

                        if (!element.strBgImage.Equals(""))
                        {
                            if ((ctl is PictureBox) && (ctl as PictureBox).Image == null)
                                continue;
                            FileStream pFileStream;
                            try
                            {
                                pFileStream = new FileStream(path + "\\template\\" + element.strBgImage, FileMode.Open, FileAccess.Read);
                                if (ctl is Label)
                                {
                                    Label lb = ctl as Label;
                                    lb.Image = new Bitmap(Image.FromStream(pFileStream), ctl.Size);

                                }
                                else
                                {
                                    ctl.BackgroundImage = new Bitmap(Image.FromStream(pFileStream), ctl.Size);
                                }
                                pFileStream.Close();
                                pFileStream.Dispose();
                            }
                            catch
                            {
                                pFileStream = new FileStream(path + "\\defalut\\" + element.strBgImage, FileMode.Open, FileAccess.Read);
                                if (ctl is Label)
                                    (ctl as Label).Image = new Bitmap(Image.FromStream(pFileStream), ctl.Size);
                                else
                                    ctl.BackgroundImage = new Bitmap(Image.FromStream(pFileStream), ctl.Size);
                                pFileStream.Close();
                                pFileStream.Dispose();
                            }
                        }

                        if (!element.strFontFamily.Equals(""))
                        {
                            //if (ctl.Name == "Label_Countdown")
                            //    Console.WriteLine("get it");
                            if (ctl is Panel || ctl is PictureBox)
                                continue;

                            Font old_F = ctl.Font;
                            Label lb = ctl as Label;

                            if (element.strContent != "")
                                lb.Text = element.strContent;
                            if (element.strFontFamily != "" & element.intFontSize != 0)
                                lb.Font = new Font(new FontFamily(element.strFontFamily), element.intFontSize, old_F.Style);

                            if (element.strFontColor != "")
                            {
                                try
                                {
                                    string[] color = element.strFontColor.Split(',');
                                    int[] intcolor = { Convert.ToInt32(color[0]), Convert.ToInt32(color[1]), Convert.ToInt32(color[2]) };

                                    for (int t = 0; t < 3; t++)
                                    {
                                        if (intcolor[t] < 0)
                                            intcolor[t] = 0;
                                        if (intcolor[t] > 255)
                                            intcolor[t] = 255;
                                    }

                                    lb.ForeColor = Color.FromArgb(intcolor[0], intcolor[1], intcolor[2]);
                                }
                                catch
                                {
                                    lb.ForeColor = Color.FromArgb(255, 255, 255);
                                }
                            }
                        }
                    }
                }
                catch (Exception e)
                {
                    ErrorLog.log(e);
                }
            }
        }