示例#1
0
 public bool CouponPrint()
 {
     AccessCmd cmd = new AccessCmd();
     try
     {
         //读取数据库
         string strSql = "select * from t_bz_coupon_print";
         OleDbDataReader reader = cmd.ExecuteReader(strSql);
         StringBuilder sbPrintInfo = new StringBuilder();
         StringBuilder sbId = new StringBuilder();
         while (reader.Read())
         {
             sbId.Append("'").Append(reader.GetString(0)).Append("',");
             sbPrintInfo.Append(reader.GetString(1)).Append("$").Append(reader.GetString(2)).Append("$").Append(reader.GetDateTime(3).ToString()).Append("$")
                 .Append(reader.GetString(4)).Append("@");
         }
         reader.Close();
         if (sbPrintInfo.Length > 0)
         {
             string strPrintInfo = sbPrintInfo.ToString(0, sbPrintInfo.Length - 1);
             string strIds = sbId.ToString(0, sbId.Length - 1);
             //上传数据
             request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/CouponPrint?strTerminalNo=" + GlobalVariables.StrTerminalNo + "&strPrintContent=" +
                 strPrintInfo, "");
             XmlDocument doc = new XmlDocument();
             string strXml = request.HtmlDocument;
             doc.LoadXml(strXml);
             string strReturn = doc.GetElementsByTagName("return").Item(0).InnerText.Trim();
             if (strReturn.Equals("OK"))
             {
                 //删除数据库记录
                 strSql = "delete from t_bz_coupon_print where strId in (" + strIds + ")";
                 cmd.ExecuteNonQuery(strSql);
             }
         }
         return true;
     }
     catch (Exception e)
     {
         ErrorLog.log(e);
         return false;
     }
     finally
     {
         cmd.Close();
     }
 }
 internal void SynParam()
 {
     //下载参数信息
     request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/TerminalParam?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
     string strXml = request.HtmlDocument;
     if (strXml.IndexOf("<params>") > 0)
     {
         XmlDocument doc = new XmlDocument();
         doc.LoadXml(strXml);
         //删除原纪录
         AccessCmd cmd = new AccessCmd();
         string strSql = "delete from t_bz_terminal_param where strParamName<>'strTerminalNo' and strParamName<>'strServerUrl'";
         cmd.ExecuteNonQuery(strSql);
         //增加新纪录
         XmlNodeList xnl = doc.GetElementsByTagName("param");
         for (int i = 0; i < xnl.Count; i++)
         {
             XmlElement xe = (XmlElement)xnl.Item(i);
             //获取信息
             string strId = xe.ChildNodes.Item(0).InnerText.Trim();
             string strParamName = xe.ChildNodes.Item(1).InnerText.Trim();
             string strParamValue = xe.ChildNodes.Item(2).InnerText.Trim();
             //更新数据库
             strSql = "insert into t_bz_terminal_param (strId,strParamName,strParamValue) values ('" + strId + "','" + strParamName + "','" + strParamValue + "')";
             cmd.ExecuteNonQuery(strSql);
         }
         cmd.Close();
     }
 }
        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();
        }
示例#4
0
        private void Option_MouseUp(object sender, MouseEventArgs e)
        {
            Button btn = (Button)sender;

            switch (btn.Name)
            {
                case "Button_ModifyID":
                    btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\修改参数.jpg");
                    if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
                    {
                        if (this.ID.Text.Trim().Equals(""))
                        {
                            this.Label_Warning.Text = "请输入本机编码!";
                        }
                        else if (this.URL.Text.Trim().Equals(""))
                        {
                            this.Label_Warning.Text = "请输入远程URL!";
                        }
                        else
                        {
                            AccessCmd cmd = new AccessCmd();
                            cmd.ExecuteNonQuery("delete from t_bz_terminal_param where strParamName='strTerminalNo' or strParamName='strServerUrl'");
                            cmd.ExecuteNonQuery("insert into t_bz_terminal_param(strId,strParamName,strParamValue) values('" + 99 + "','strTerminalNo','" + this.ID.Text.Trim() + "')");
                            cmd.ExecuteNonQuery("insert into t_bz_terminal_param(strId,strParamName,strParamValue) values('" + 99 + "','strServerUrl','" + this.URL.Text.Trim() + "')");
                            cmd.Close();
                            GlobalVariables.StrTerminalNo = this.ID.Text.Trim();
                            GlobalVariables.StrServerUrl = this.URL.Text.Trim();
                            this.Label_Warning.Text = "操作成功!";
                        }
                    }
                    else
                    {
                        this.Label_Warning.Text = "密码错误,请重新输入!";
                    }
                    return;
                case "Button_Exit":
                    btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\退出系统.jpg");
                    if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
                    {
                        Program.Exit();
                    }
                    else
                    {
                        this.Label_Warning.Text = "密码错误,请重新输入!";
                    }
                    return;
                case "Buttom_Close":
                    btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\关闭.jpg");
                    this.Close();
                    return;
                case "Button_Paper":
                    btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\换纸结束.jpg");
                    if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
                    {
                        AccessCmd cmd = new AccessCmd();
                        cmd.ExecuteNonQuery("update t_bz_print_total set intPrintTotal=0");
                        cmd.Close();
                        this.Label_Warning.Text = "操作成功!";
                    }
                    else
                    {
                        this.Label_Warning.Text = "密码错误,请重新输入!";
                    }
                    return;
            }
        }
示例#5
0
        private void Btn_NewCouponList_Click(object sender, EventArgs e)
        {
            ChangeExternThreeButtonForeColor(sender as Button);
            MyMsgBox mb = new MyMsgBox();
            try
            {
                String time = DateTime.Now.ToString("yyyy/M/d H:m:s");
                string strSql = "select top 24 strId from t_bz_coupon where #" + time + "#>dtActiveTime and #" + time + "#< dtExpireTime order by dtActiveTime desc";
                AccessCmd cmd = new AccessCmd();
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                String strId = "";
                while (reader.Read())
                {
                    if (!reader.IsDBNull(0))
                    {
                        strId += reader.GetString(0) + ",";
                    }
                }

                reader.Close();
                cmd.Close();
                if (strId != "")
                {
                    LP_ctype[0] = FindCouponById(strId.Substring(0, strId.Length - 1).Split(','));
                }
                else
                {
                    LP_ctype[0] = new List<CouponPicInfo>();
                }
                curPage = 1;
                curType = 0;
                theCouponNum = 0;

                ShowCoupon();

            }
            catch (Exception e1)
            {
                mb.ShowMsg(e1.Message + "\n正在修复", 1);
            }
        }
示例#6
0
        private void Panel_Ad_VisibleChanged(object sender, EventArgs e)
        {
            if (Panel_Ad.Visible == false)
            {
                showContinue = false;
                Panel_Ad.Controls.Clear();
                if (Ad_PB1 != null)
                {
                    Ad_PB1.Dispose();
                }
                if (Ad_PB2 != null)
                {
                    Ad_PB2.Dispose();
                }
                if (Ad_MediaPlayer1 != null)
                {
                    try
                    {
                        Panel_Ad.Controls.Remove(Ad_MediaPlayer1);
                        Ad_MediaPlayer1.Ctlcontrols.stop();
                        Ad_MediaPlayer1.close();
                        Ad_MediaPlayer1.Dispose();
                    }
                    catch (Exception e1)
                    {
                        ErrorLog.log(e1);
                    }
                }
                if (Ad_MediaPlayer2 != null)
                {
                    try
                    {
                        Panel_Ad.Controls.Remove(Ad_MediaPlayer2);
                        Ad_MediaPlayer2.Ctlcontrols.stop();
                        Ad_MediaPlayer2.close();
                        Ad_MediaPlayer2.Dispose();
                    }
                    catch (Exception e2)
                    {
                        ErrorLog.log(e2);
                    }
                }
                if (PicThread != null)
                {
                    try
                    {
                        if (PicThread.IsAlive)
                        {
                            PicThread.Abort();
                            PicThread.Join();
                        }
                    }
                    catch (Exception e1)
                    {
                        ErrorLog.log(e1);
                    }
                }

            }

            if (Panel_Ad.Visible == true)
            {
                string time = DateTime.Now.ToString("H:m:s");
                string strSql = "select top 2 * from t_bz_advertisement where #" + time + "#>=dtStartTime And #" + time + "#<dtEndTime And (intType=1 or intType=2)";
                AccessCmd cmd = new AccessCmd();
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                Ad_type = new List<int>();
                Ad_str = new List<string>();

                while (reader.Read())
                {
                    Ad_type.Add(reader.GetInt32(2));
                    Ad_str.Add(reader.GetString(3));
                }

                reader.Close();
                cmd.Close();

                Panel_Ad.Controls.Add(Label_AdClick);
                ShowAd();
            }
        }
示例#7
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);
                }
            }
        }
示例#8
0
        /// <summary>
        /// 走马灯线程函数
        /// </summary>
        private void LoadMarquee()
        {
            while (true)
            {
                String dtime = DateTime.Now.ToString("H:mm:ss");
                string strSql = "select * from t_bz_advertisement where intType=3 and #" + dtime + "#>=dtStartTime and #" + dtime + "#<dtEndTime";
                AccessCmd cmd = new AccessCmd();
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                string strText = "";
                if (reader != null)
                {
                    if (reader.Read())
                    {
                        if (!reader.IsDBNull(3))
                        {
                            strText = reader.GetString(3);
                        }
                    }
                }
                reader.Close();
                cmd.Close();

                if (strText == "")
                {
                    strText = "此处广告未招租,有意向请拨打" + GlobalVariables.StrPhone;
                }

                if (Label_ScrollText.InvokeRequired)
                {
                    this.Label_ScrollText.Invoke((MethodInvoker)delegate
                    {
                        this.Label_ScrollText.Stop();
                        this.Label_ScrollText.strContent = strText;
                        this.Label_ScrollText.Start();
                    }, null);
                }
                else
                {
                    this.Label_ScrollText.Stop();
                    this.Label_ScrollText.strContent = strText;
                    this.Label_ScrollText.Start();
                }
                Thread.Sleep(1800 * 1000);
            }
        }
示例#9
0
        /// <summary>
        /// 加载商家详细页面的数据
        /// </summary>
        private void InitShopInfoData(String shopid)
        {
            if (LP_ctype != null)
            {
                for (int i = 0; i < LP_ctype.Length; i++)
                {
                    if (LP_ctype[i] != null && LP_ctype[i].Count > 0)
                    {
                        LP_ctype[i].Clear();
                    }
                }
            }

            string strSql = "select * from t_bz_shop where strId ='" + shopid + "'";
            AccessCmd cmd = new AccessCmd();
            OleDbDataReader reader = cmd.ExecuteReader(strSql);
            FileStream pFileStream;

            String lPath, name, address, info, id = null;

            LP_ctype = new List<CouponPicInfo>[1];

            if (reader.Read())
            {
                lPath = reader.GetString(9);
                if (lPath != "" && lPath != null)
                {
                    if (!File.Exists(path + "\\shop\\" + lPath))
                    {
                        pFileStream = new FileStream(path + "\\shop\\null.jpg", FileMode.Open, FileAccess.Read);
                    }
                    else
                    {
                        pFileStream = new FileStream(path + "\\shop\\" + lPath, FileMode.Open, FileAccess.Read);
                    }
                }
                else
                {
                    pFileStream = new FileStream(path + "\\shop\\null.jpg", FileMode.Open, FileAccess.Read);
                }
                PB_ShopInfo_Shop.Image = new Bitmap(Image.FromStream(pFileStream), 760, 397);
                pFileStream.Close();
                pFileStream.Dispose();

                if (!reader.IsDBNull(1))
                {
                    name = reader.GetString(1);
                    if (name != "" && name != null)
                    {
                        Label_ShopInfo_Name.Text = "商家名称: " + name;
                    }
                }

                id = reader.GetString(0);

                if (!reader.IsDBNull(4))
                {
                    address = reader.GetString(4);
                    if (address != "" && address != null)
                    {
                        Label_ShopInfo_Address.Text = "地址: " + address;
                    }
                    else
                    {
                        Label_ShopInfo_Address.Text = "地址: ";
                    }
                }

                if (!reader.IsDBNull(7))
                {
                    info = reader.GetString(7);
                    if (info != "" && info != null)
                    {
                        Label_ShopInfo_Detail.Text = "简介: " + info;
                    }
                    else
                    {
                        Label_ShopInfo_Detail.Text = "简介: ";
                    }
                }
            }

            if (this.PB_ShopInfo_Coupons.Image != null)
            {
                this.PB_ShopInfo_Coupons.Image.Dispose();
                this.PB_ShopInfo_Coupons.Image = null;
            }

            LP_ctype[0] = FindCouponByShopId(id);
            if (LP_ctype[0] == null)
            {
                LP_ctype[0] = new List<CouponPicInfo>();
            }

            reader.Close();
            cmd.Close();

            curPage = 1;
            curType = 0;
            theCouponNum = 0;
        }
示例#10
0
        /// <summary>
        /// 预加载所有的图片信息
        /// </summary>
        private void InitData()
        {
            AccessCmd cmd = new AccessCmd();
            OleDbDataReader reader;

            //初始化参数
            tradeName = GetTradeName();
            //加载参数
            string strSql = "select * from t_bz_terminal_param";
            reader = cmd.ExecuteReader(strSql);
            while (reader.Read())
            {
                try
                {
                    string strParamName = reader.GetString(1);
                    if (strParamName.Equals("strExitPwd"))
                        GlobalVariables.StrExitPwd = reader.GetString(2);
                    else if (strParamName.Equals("intMemberSec"))
                        GlobalVariables.UserWaitTime = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("intRefreshSec"))
                        GlobalVariables.IntRefreshSec = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("strPhone"))
                        GlobalVariables.StrPhone = reader.GetString(2);
                    else if (strParamName.Equals("intAdSec"))
                        GlobalVariables.WindowWaitTime = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("intAdImg"))
                        GlobalVariables.IntAdImg = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("intHistory"))
                        GlobalVariables.IntHistory = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("intCouponPrint"))
                        GlobalVariables.IntCouponPrint = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("strTerminalNo"))
                        GlobalVariables.StrTerminalNo = reader.GetString(2);
                    else if (strParamName.Equals("strServerUrl"))
                        GlobalVariables.StrServerUrl = reader.GetString(2);
                    else if (strParamName.Equals("intPrintLimit"))
                        GlobalVariables.PrintLimit = Int16.Parse(reader.GetString(2));
                    else if (strParamName.Equals("intSmsReceive"))
                        GlobalVariables.MessageRegetTime = reader.GetInt32(2);
                }
                catch (Exception)
                {
                    continue;
                }
            }
            reader.Close();

            //读取数据库
            strSql = "select * from t_bz_shop order by intType desc,intSort asc";
            try
            {
                reader = cmd.ExecuteReader(strSql);
            }
            catch (Exception e0)
            {
                ErrorLog.log(e0);
                cmd.Close();
                return;
            }

            FileStream pFileStream;
            LP_shop = new List<PicInfo>();

            String lPath, sPath, pPath, name, id, trade, shopid;
            double flaPrice;
            int intVip, intType;

            while (reader.Read())
            {
                try
                {
                    PicInfo pi = new PicInfo();

                    if (!reader.IsDBNull(9))
                    {
                        lPath = reader.GetString(9);
                        if (lPath != "")
                        {
                            pi.lpath = path + "\\shop\\" + lPath;
                            if (!File.Exists(pi.lpath))
                            {
                                pi.lpath = path + "\\shop\\null.jpg";
                            }
                        }
                        else
                        {
                            pi.lpath = path + "\\shop\\null.jpg";
                        }
                    }
                    else
                    {
                        pi.lpath = path + "\\shop\\null.jpg";
                    }

                    if (!reader.IsDBNull(8))
                    {
                        sPath = reader.GetString(8);
                        if (sPath != "")
                        {
                            pi.spath = path + "\\shop\\" + sPath;
                            if (!File.Exists(pi.spath))
                            {
                                pi.spath = path + "\\shop\\null.jpg";
                            }
                        }
                        else
                        {
                            pi.spath = path + "\\shop\\null.jpg";
                        }
                    }
                    else
                    {
                        pi.spath = path + "\\shop\\null.jpg";
                    }
                    pFileStream = new FileStream(pi.spath, FileMode.Open, FileAccess.Read);
                    pi.image = new Bitmap(Image.FromStream(pFileStream), 119, 138);
                    pFileStream.Close();
                    pFileStream.Dispose();

                    if (!reader.IsDBNull(0))
                    {
                        id = reader.GetString(0);
                        if (id != "")
                        {
                            pi.id = id;
                        }
                        else
                        {
                            pi.id = "000000000000";
                        }
                    }
                    else
                    {
                        pi.id = "000000000000";
                    }

                    if (!reader.IsDBNull(1))
                    {
                        name = reader.GetString(1);
                        if (name != "")
                        {
                            pi.name = name;
                        }
                        else
                        {
                            pi.name = "无名称";
                        }
                    }
                    else
                    {
                        pi.name = "无名称";
                    }

                    trade = reader.GetString(3);
                    if (trade != "" && trade != null)
                    {
                        pi.trade = trade;
                    }

                    intType = reader.GetInt32(10);
                    pi.intType = intType;

                    LP_shop.Add(pi);
                }
                catch (Exception)
                {
                    continue;
                }
            }
            reader.Close();

            string date = DateTime.Now.ToString("yyyy/M/d H:mm:ss");
            strSql = "select * from t_bz_coupon where #" + date + "#>=dtActiveTime and #" + date + "#<dtExpireTime";
            reader = cmd.ExecuteReader(strSql);
            LP_coupon = new List<CouponPicInfo>();

            while (reader.Read())
            {
                try
                {
                    CouponPicInfo pi = new CouponPicInfo();

                    if (!reader.IsDBNull(13))
                    {
                        pi.intSendBySM = reader.GetInt32(13);
                    }

                    if (!reader.IsDBNull(9))
                    {
                        lPath = reader.GetString(9);
                        if (lPath != "")
                        {
                            pi.lpath = path + "\\coupon\\" + lPath;
                            if (!File.Exists(pi.lpath))
                            {
                                pi.lpath = path + "\\coupon\\null.jpg";
                            }
                        }
                        else
                        {
                            pi.lpath = path + "\\coupon\\null.jpg";
                        }
                    }
                    else
                    {
                        pi.lpath = path + "\\coupon\\null.jpg";
                    }

                    if (!reader.IsDBNull(10))
                    {
                        pPath = reader.GetString(10);
                        if (pPath != "")
                        {
                            pi.pPath = path + "\\coupon\\" + pPath;
                            if (!File.Exists(pi.pPath))
                            {
                                pi.pPath = path + "\\coupon\\null.jpg";
                            }
                        }
                        else
                        {
                            pi.pPath = path + "\\coupon\\null.jpg";
                        }
                    }
                    else
                    {
                        pi.pPath = path + "\\coupon\\null.jpg";
                    }

                    if (!reader.IsDBNull(8))
                    {
                        sPath = reader.GetString(8);
                        if (sPath != "")
                        {
                            pi.spath = path + "\\coupon\\" + sPath;
                            if (!File.Exists(pi.spath))
                            {
                                pi.spath = path + "\\coupon\\null.jpg";
                            }
                        }
                        else
                        {
                            pi.spath = path + "\\coupon\\null.jpg";
                        }
                    }
                    else
                    {
                        pi.spath = path + "\\coupon\\null.jpg";
                    }
                    pFileStream = new FileStream(pi.spath, FileMode.Open, FileAccess.Read);
                    pi.image = new Bitmap(Image.FromStream(pFileStream), 240, 120);
                    pFileStream.Close();
                    pFileStream.Dispose();

                    if (!reader.IsDBNull(1))
                    {
                        name = reader.GetString(1);
                        if (name != "")
                        {
                            pi.name = name;
                        }
                        else
                        {
                            pi.name = "null";
                        }
                    }
                    else
                    {
                        pi.name = "null";
                    }

                    if (!reader.IsDBNull(0))
                    {
                        id = reader.GetString(0);
                        if (id != "")
                        {
                            pi.id = id;
                        }
                        else
                        {
                            pi.id = "00000000";
                        }
                    }
                    else
                    {
                        pi.id = "00000000";
                    }

                    if (!reader.IsDBNull(4))
                    {
                        shopid = reader.GetString(4);
                        if (shopid != "")
                        {
                            pi.shopId = shopid;
                            strSql = "select strTrade from t_bz_shop where strId='" + shopid + "'";
                            OleDbDataReader oddr = cmd.ExecuteReader(strSql);

                            if (oddr.Read())
                            {
                                if (!reader.IsDBNull(0))
                                {
                                    pi.trade = oddr.GetString(0);
                                }
                            }
                            oddr.Close();
                        }
                    }

                    if (!reader.IsDBNull(5))
                    {
                        intVip = reader.GetInt32(5);
                        pi.vip = intVip;
                    }
                    else
                    {
                        pi.vip = 0;
                    }

                    if (!reader.IsDBNull(7))
                    {
                        flaPrice = reader.GetDouble(7);
                        pi.flaPrice = flaPrice;
                    }
                    else
                    {
                        pi.flaPrice = 0;
                    }

                    LP_coupon.Add(pi);
                }
                catch (Exception)
                {
                    continue;
                }
            }
            reader.Close();
            cmd.Close();
            InitParam();
        }
示例#11
0
        /// <summary>
        /// 获取当前登录用户打印的次数
        /// </summary>
        /// <returns>返回打印的次数</returns>
        private int GetUserPrintTimes()
        {
            string userId = GlobalVariables.LoginUserId;
            string strSql = "select count(*) from t_bz_coupon_print where strMemberCardNo='" + userId + "'";
            AccessCmd cmd = new AccessCmd();
            OleDbDataReader reader = cmd.ExecuteReader(strSql);

            if (reader.Read())
            {
                int times = reader.GetInt32(0);
                reader.Close();
                cmd.Close();
                return times;
            }
            else
            {
                reader.Close();
                cmd.Close();
                return 0;
            }
        }
示例#12
0
        /// <summary>
        /// 获取商家种类的个数
        /// </summary>
        /// <returns>返回商家种类的个数</returns>
        private string[] GetTradeName()
        {
            try
            {
                string strSql = "select strTrade from t_bz_shop group by strTrade order by count(strTrade) desc";
                //select strTrade from t_bz_shop b group by strTrade order by count(strTrade) desc
                AccessCmd cmd = new AccessCmd();
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                String tradeName = "";
                while (reader.Read())
                {
                    tradeName += reader.GetString(0) + ",";
                    count++;
                }
                reader.Close();
                cmd.Close();
                if (tradeName != "")
                {
                    return tradeName.Substring(0, tradeName.Length - 1).Split(',');
                }
                else
                {
                    return null;
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);
            }
            return null;
        }
示例#13
0
        /// <summary>
        /// 查找推荐优惠劵
        /// </summary>
        /// <returns>返回查找到的优惠劵List</returns>
        private List<CouponPicInfo> FindRecCoupon(int type)
        {
            List<CouponPicInfo> temp = null;
            try
            {
                String time = DateTime.Now.ToString("yyyy/M/d H:mm:ss");
                string strSql;
                //0表示首页的推荐优惠劵,是所有的;其他的表示优惠卷页面的推荐优惠劵,是前24个
                if (type == 0)
                    strSql = "select strId from t_bz_coupon where intRecommend=1 order by dtActiveTime desc";
                else
                    strSql = "select top 24 strId from t_bz_coupon where intRecommend=1 order by dtActiveTime desc";
                AccessCmd cmd = new AccessCmd();
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                String strId = "";
                while (reader.Read())
                {
                    if (!reader.IsDBNull(0))
                    {
                        strId += reader.GetString(0) + ",";
                    }
                }
                if (strId != "")
                    temp = FindCouponById(strId.Substring(0, strId.Length - 1).Split(','));
                else
                    temp = new List<CouponPicInfo>();

                reader.Close();
                cmd.Close();

                return temp;
            }
            catch (Exception e1)
            {
                ErrorLog.log(e1);
                return new List<CouponPicInfo>();
            }
        }
        /// <summary>
        /// 发送短信
        /// </summary>
        private void SendMessage()
        {
            MyMsgBox mb = new MyMsgBox();
            mb.ShowMsg("是否发送此优惠劵的信息到您的手机上?\n(信息不收取任何费用)", '1');
            if (mb.DialogResult == DialogResult.Yes)
            {
                string strSql = "select strIntro from t_bz_coupon where strId='" + pi.id + "'";
                AccessCmd cmd = new AccessCmd(); ;
                OleDbDataReader reader = cmd.ExecuteReader(strSql);

                if (reader.Read())
                {
                    if (!reader.IsDBNull(0))
                    {
                        strMesContent = reader.GetString(0).Trim();
                    }
                    else
                    {
                        strMesContent = "";
                    }
                }
                reader.Close();
                cmd.Close();

                if (strMesContent != "")
                {
                    if (thSendMes != null)
                    {
                        if (thSendMes.IsAlive)
                        {
                            mb.ShowMsg("短信服务器忙,请稍后再试!", 1);
                            thSendMes.Abort();
                            thSendMes.Join();
                            return;
                        }
                    }

                    thSendMes = new Thread(new ThreadStart(SendMes));
                    thSendMes.Start();
                    mb.ShowMsg("短信已发送!", 1);
                }
                else
                {
                    mb.ShowMsg("该优惠劵暂无优惠信息", 1);
                    return;
                }
            }
        }
        private void DoWork()
        {
            try
            {
                printQueue pq = new printQueue();
                Dictionary<string, int> myprinter;
                string defaultPrinterName = Printer.GetDeaultPrinterName();
                //       MessageBox.Show(defaultPrinterName);

                if (pq.CanelAllPrintJob() == false)
                {
                    MyMsgBox mb = new MyMsgBox();
                    mb.ShowMsg("打印纸已用尽!暂停服务!", 3);
                    wait.CloseScrollBar();
                    return;
                }

                myprinter = pq.GetAllPrinterQueues();
                if (0 == myprinter[defaultPrinterName])
                {
                    if (!pd.PrinterSettings.IsValid)
                    {
                        MyMsgBox mb = new MyMsgBox();
                        mb.ShowMsg("打印机不可用!暂停服务!", 3);
                        wait.CloseScrollBar();
                        return;
                    }
                    pd.Print();
                    Application.DoEvents();
                    Thread.Sleep(500);
                    myprinter = pq.GetAllPrinterQueues();
                    if (myprinter[defaultPrinterName] == 0)
                    {
                        MyMsgBox mb = new MyMsgBox();
                        mb.ShowMsg("打印纸已用尽!暂停服务!", 3);
                        wait.CloseScrollBar();
                        return;
                    }

                    for (int i = 0; i <= 60; i += 1)
                    {
                        wait.SetProgressBarPositionP(i);//设置进度条当前位置
                        System.Threading.Thread.Sleep(100);//sleep一下减缓进度条进度,实际代码中,此处应该是实际的工作
                    }

                    myprinter = pq.GetAllPrinterQueues();
                    if (myprinter[defaultPrinterName] == 0)
                    {
                        string tempId = DateTime.Now.ToString("yyyyMMddHHmmss");
                        //   long tempId = DateTime.Now.Ticks;
                        if (MD5code == "")
                        {
                            MD5code = "00000000";
                        }
                        string strSql = "insert into t_bz_coupon_print values('" + tempId + "','" + GlobalVariables.LoginUserId + "','" + pi.id + "',#" + DateTime.Now.ToString("yyyy-M-d H:m:s") + "#,'" + MD5code + "')";
                        AccessCmd cmd = new AccessCmd();
                        //    MessageBox.Show(strSql);
                        cmd.ExecuteNonQuery(strSql);
                        strSql = "update t_bz_print_total set intPrintTotal=intPrintTotal+1";
                        cmd.ExecuteNonQuery(strSql);
                        strSql = "select * from t_bz_print_total";
                        OleDbDataReader reader = cmd.ExecuteReader(strSql);
                        int printNum = 0;
                        if (reader.Read())
                        {
                            printNum = reader.GetInt32(0);
                        }

                        if (printNum >= GlobalVariables.IntCouponPrint)
                        {
                            UploadInfo ui = new UploadInfo();
                            ui.PrintAlert(printNum);
                        }
                        reader.Close();
                        cmd.Close();

                        for (int i = 60; i <= 100; i += 1)
                        {
                            wait.SetProgressBarPositionP(i);//设置进度条当前位置
                            System.Threading.Thread.Sleep(50);//sleep一下减缓进度条进度,实际代码中,此处应该是实际的工作
                        }
                    }
                    else
                    {
                        MyMsgBox mb = new MyMsgBox();
                        mb.ShowMsg("打印纸已用尽!暂停服务!", 3);
                        wait.CloseScrollBar();
                        return;
                    }
                }
                else
                {
                    MyMsgBox mb = new MyMsgBox();
                    mb.ShowMsg("打印纸已用尽!暂停服务!", 3);
                    wait.CloseScrollBar();
                    return;
                }
            }
            catch (Exception e)
            {
                ErrorLog.log(e);
                wait.CloseScrollBar();
                return;
            }
        }
        private void CouponPop_OnLoad(object sender, EventArgs e)
        {
            this.FormBorderStyle = FormBorderStyle.None;
            this.Height = 780;
            AccessCmd cmd = new AccessCmd(); ;
            OleDbDataReader reader;
            string strSql = "";

            if (pi.pPath.CompareTo(path + "\\coupon\\null.jpg") == 0)
            {
                strSql = "select * from t_bz_shop where strId='" + pi.shopId + "'";
                reader = cmd.ExecuteReader(strSql);
                try
                {
                    FileStream pFileStream;
                    if (reader.Read())
                    {
                        if (!reader.IsDBNull(8))
                        {
                            pFileStream = new FileStream(path + "\\shop\\" + reader.GetString(8), FileMode.Open, FileAccess.Read);

                        }
                        else
                        {
                            pFileStream = new FileStream(path + "\\shop\\null.jpg", FileMode.Open, FileAccess.Read);
                        }
                    }
                    else
                    {
                        pFileStream = new FileStream(path + "\\shop\\null.jpg", FileMode.Open, FileAccess.Read);
                    }
                    this.PB_Couponpop.Image = new Bitmap(Image.FromStream(pFileStream), 150, 100);
                    pFileStream.Close();
                    pFileStream.Dispose();

                    reader.Close();
                }
                catch (Exception)
                {
                    reader.Close();
                }
            }
            else
            {
                FileStream pFileStream = new FileStream(pi.pPath, FileMode.Open, FileAccess.Read);
                this.PB_Couponpop.Image = new Bitmap(Image.FromStream(pFileStream), 150, 100);
                pFileStream.Close();
                pFileStream.Dispose();
            }

            strSql = "select * from t_bz_coupon where strId='" + pi.id + "'";
            reader = cmd.ExecuteReader(strSql);
            try
            {
                if (reader.Read())
                {
                    if (!reader.IsDBNull(11))
                    {
                        Intro = reader.GetString(11);
                    }
                    else
                    {
                        Intro = "暂无介绍";
                    }

                    if (!reader.IsDBNull(12))
                    {
                        Instruction = reader.GetString(12);
                    }
                    else
                    {
                        Instruction = "暂无说明";
                    }
                }
                reader.Close();

                strSql = "select * from t_bz_terminal_param where strParamName='strPrintBottom'";
                reader = cmd.ExecuteReader(strSql);

                if (reader.Read())
                {
                    if (!reader.IsDBNull(2))
                    {
                        bottomText = reader.GetString(2);
                    }
                    else
                    {
                        bottomText = "";
                    }
                }

                reader.Close();
                cmd.Close();
            }
            catch (Exception)
            {
                reader.Close();
                cmd.Close();
            }

            Label_Into.Text = Intro;
            Label_Instruction.Text = Instruction;
            Label_phone.Text = bottomText + "\n" + GlobalVariables.StrPhone;

            if (pi.flaPrice != 0)
            {
                MD5code = this.ReturnCode();
                this.Code.Text = "验证码:" + MD5code;
            }
        }