Example #1
0
        /// <summary>
        /// SolutionDetail.aspx 显示html
        /// </summary>
        /// <param name="SlnSysNo">solution sysno</param>
        /// <param name="PrjTypeOrderNum">project type ordernum</param>
        /// <param name="ProjectPicPath">project pic path</param>
        /// <returns></returns>
        public string GetDIYSolutionDetail(int SlnSysNo, int PrjTypeOrderNum, string ProjectPicPath, int InputPrjSysNo, int Is53KF)
        {
            StringBuilder sbTotal  = new StringBuilder();  //
            StringBuilder sbHeader = new StringBuilder();  //项目类型导航
            StringBuilder sbLeft   = new StringBuilder();  //项目导航
            StringBuilder sbMain   = new StringBuilder();  //具体项目

            //找出第一个valid的prjtypeordernum
            string sql = "select top 1 ordernum as prjtypeordernum from prj_type where slnsysno=@slnsysno and status=0 order by ordernum";

            sql = sql.Replace("@slnsysno", SlnSysNo.ToString());
            int FirstPrjTypeOrderNum = Int32.Parse(SqlHelper.ExecuteScalar(sql).ToString());

            if (PrjTypeOrderNum == 0)
            {
                PrjTypeOrderNum = FirstPrjTypeOrderNum;
            }
            bool IsFirstPrjTypeOrderNum = false;

            if (PrjTypeOrderNum == FirstPrjTypeOrderNum)
            {
                IsFirstPrjTypeOrderNum = true;
            }

            PrjTypeInfo oPrjTypeInfo = PrjManager.GetInstance().LoadPrjType(SlnSysNo, PrjTypeOrderNum);

            if (oPrjTypeInfo == null)
            {
                return("");
            }
            int PrjTypeSysNo = oPrjTypeInfo.SysNo;

            sbHeader.Append("<table width=100% border=0 cellspacing=0 cellpadding=0>");
            sbHeader.Append("    <tr>");
            if (IsFirstPrjTypeOrderNum)
            {
                sbHeader.Append("    <td><img src='images/diyimages/diytitle01.jpg' width=251 height=54></td>");
            }
            else
            {
                sbHeader.Append("    <td><img src='images/diyimages/diytitle07.jpg' width=251 height=54></td>");
            }

            SortedList slType = PrjManager.GetInstance().GetPrjTypeList(SlnSysNo);  //获得solution下project type list => 导航

            foreach (PrjTypeInfo oTypeInfo in slType.Keys)
            {
                if (oTypeInfo.Status == (int)AppEnum.BiStatus.Valid)
                {
                    bool IsCurrentPrjTypeOrderNum = false;
                    if (PrjTypeOrderNum == oTypeInfo.OrderNum)
                    {
                        IsCurrentPrjTypeOrderNum = true;
                    }

                    if (IsFirstPrjTypeOrderNum)
                    {
                        if (!IsCurrentPrjTypeOrderNum)
                        {
                            sbHeader.Append("<td><img src='images/diyimages/diytitle03.jpg' width=10 height=54 border=0></td>");
                        }
                    }
                    else
                    {
                        if (FirstPrjTypeOrderNum != oTypeInfo.OrderNum)
                        {
                            if (IsCurrentPrjTypeOrderNum)
                            {
                                sbHeader.Append("<td><img src='images/diyimages/diytitle08.jpg' width=10 height=54 border=0></td>");
                            }
                            else
                            {
                                sbHeader.Append("<td><img src='images/diyimages/diytitle03.jpg' width=10 height=54 border=0></td>");
                            }
                        }
                    }

                    if (IsCurrentPrjTypeOrderNum)
                    {
                        sbHeader.Append("<td valign=top background='images/diyimages/diytitle02bg.jpg'>");
                    }
                    else
                    {
                        sbHeader.Append("<td valign=top background='images/diyimages/diytitle03bg.jpg'>");
                    }

                    sbHeader.Append("    <table width=150 height=40 border=0 cellpadding=0 cellspacing=0>");
                    sbHeader.Append("        <tr>");
                    sbHeader.Append("            <td height=14></td>");
                    sbHeader.Append("        </tr>");
                    sbHeader.Append("        <tr>");
                    sbHeader.Append("            <td align=center><a href=SolutionDetail.aspx?ID=" + SlnSysNo.ToString() + "&Order=" + oTypeInfo.OrderNum.ToString() + "><strong style='font-size: 14px;'><font color='#FFFFFF'>" + Util.TrimNull(oTypeInfo.Name) + "</font></strong></a></td>");
                    sbHeader.Append("        </tr>");
                    sbHeader.Append("    </table>");
                    sbHeader.Append("</td>");
                    if (IsCurrentPrjTypeOrderNum)
                    {
                        sbHeader.Append("<td><img src='images/diyimages/diytitle02.jpg' width=10 height=54 border=0></td>");
                    }
                    else
                    {
                        sbHeader.Append("<td><img src='images/diyimages/diytitle04.jpg' width=10 height=54 border=0></td>");
                    }
                }
            }
            sbHeader.Append("        <td width=100% align=right background='images/diyimages/diytitle05.jpg'><img src='images/diyimages/diytitle06.jpg' width=8 height=54></td>");
            sbHeader.Append("    </tr>");
            sbHeader.Append("</table>");

            DataSet dsLeft = SlnManager.GetInstance().GetSlnLeftNavDs(SlnSysNo);

            sbLeft.Append("<table valign=top width=100% border=0 cellspacing=0 cellpadding=0>");
            sbLeft.Append("    <tr>");
            sbLeft.Append("        <td><img src='images/diyimages/diyside01.jpg' width=158 height=29></td>");
            sbLeft.Append("        <td width=100% align=right background='images/diyimages/diyside02.jpg'><img src='images/diyimages/diyside03.jpg' width=7 height=29></td>");
            sbLeft.Append("    </tr>");
            int i = 1;

            foreach (DataRow drPrjType in dsLeft.Tables[0].Rows)
            {
                if (Util.HasMoreRow(dsLeft.Tables[i]))
                {
                    sbLeft.Append("    <tr>");
                    sbLeft.Append("        <td colspan=2 style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 10px;'>");
                    sbLeft.Append("             <table width=100% border=0 cellspacing=0 cellpadding=2>");
                    sbLeft.Append("                 <tr>");
                    sbLeft.Append("                    <td style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><strong><font color='#5fb2cf'>" + Util.TrimNull(drPrjType["prjtypename"]) + "</font></strong></td>");
                    sbLeft.Append("                 </tr>");

                    foreach (DataRow drPrj in dsLeft.Tables[i].Rows)
                    {
                        if (Util.TrimIntNull(drPrj["prjsysno"].ToString()) == InputPrjSysNo)
                        {
                            sbLeft.Append("         <tr style='background-color:InfoBackground'>");
                        }
                        else
                        {
                            sbLeft.Append("         <tr>");
                        }
                        sbLeft.Append("                 <td style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><img src='images/diyimages/arrow.jpg' width=14 height=16><a href='../DIY/SolutionDetail.aspx?ID=" + SlnSysNo.ToString() + "&Order=" + Util.TrimNull(drPrjType["PrjTypeOrderNum"]) + "&PID=" + Util.TrimNull(drPrj["prjsysno"]) + "#P" + Util.TrimNull(drPrj["prjsysno"]) + "'>" + Util.TrimNull(drPrj["prjname"]) + "</a></td>");
                        sbLeft.Append("             </tr>");
                    }
                    sbLeft.Append("             </table>");
                    sbLeft.Append("        </td>");
                    sbLeft.Append("    </tr>");
                }
                i++;
            }
            sbLeft.Append("    <tr>");
            sbLeft.Append("         <td height=2 background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline01.jpg' width=9 height=9></td>");
            sbLeft.Append("         <td height=2 align=right background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline03.jpg' width=9 height=9></td>");
            sbLeft.Append("    </tr>");
            sbLeft.Append("</table>");

            DataSet dsMain = new DataSet();

            if (InputPrjSysNo == 0)
            {
                dsMain = PrjManager.GetInstance().GetPrjListDefaultDetailDs(PrjTypeSysNo);
            }
            else
            {
                dsMain = PrjManager.GetInstance().GetPrjDetailDsBySysNo(InputPrjSysNo);
            }

            if (Util.HasMoreRow(dsMain))
            {
                sbMain.Append("<table width=100% border=0 cellspacing=0 cellpadding=2 valign=top>");
                int RowCount   = dsMain.Tables[0].Rows.Count;
                int PageSize   = 3;
                int PageCount  = 1;
                int CurrentRow = 1;
                //decimal widthPercent = 0;
                //if (PageSize < RowCount)
                //{
                //    PageCount = (RowCount / PageSize) + 1;
                //    widthPercent = Util.TrimDecimalNull(100) / Util.TrimDecimalNull(PageSize);
                //}
                //else
                //{
                //    widthPercent = Util.TrimDecimalNull(100) / Util.TrimDecimalNull(RowCount);
                //}

                for (int m = 1; m <= PageCount; m++)
                {
                    sbMain.Append("    <tr>");
                    for (int n = 1; n <= PageSize; n++)
                    {
                        if (CurrentRow > RowCount)
                        {
                            //sbMain.Append("    <td valign=top width=" + widthPercent.ToString("##") + "%></td>");
                            CurrentRow++;
                            continue;
                        }
                        int           PrjSysNo   = Util.TrimIntNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjsysno"].ToString());
                        decimal       TotalPrice = 0;
                        StringBuilder sbImage    = new StringBuilder();

                        sbMain.Append("        <td valign=top width=50%>");
                        sbMain.Append("            <table width=100% valign=top border=0 cellspacing=0 cellpadding=0>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td width=100% background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline04.jpg' width=9 height=9></td>");
                        sbMain.Append("                    <td align=right background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline06.jpg' width=9 height=9></td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td colspan=2 align=center bgcolor='#f1f1f1' style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 8px;'>");
                        if (PrjSysNo == InputPrjSysNo)
                        {
                            sbMain.Append("<a name='#P" + Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjsysno"]) + "'><strong style='font-size: 16px;color:red;'>" + Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjname"].ToString()) + "</strong></a>");
                        }
                        else
                        {
                            sbMain.Append("<strong style='font-size: 14px;'><a name='#P" + Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjsysno"]) + "'>" + Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjname"].ToString()) + "</a></strong>");
                        }
                        sbMain.Append("                    </td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td height=105 colspan=2 align=center style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 2px;'>");
                        bool   PrjectPicExist = false;
                        string ProjectPicFile = ProjectPicPath + PrjSysNo.ToString() + ".jpg";
                        if (File.Exists(ProjectPicFile))
                        {
                            PrjectPicExist = true;
                        }
                        if (PrjectPicExist)  //project pic 存在就显示其project的图片,不存在就显示商品组合图片
                        {
                            ProjectPicFile = AppConfig.PicturePath + "project/" + PrjSysNo.ToString() + ".jpg";
                            sbMain.Append("<img src='" + ProjectPicFile + "' />");
                        }
                        else
                        {
                            sbMain.Append("##Image##");
                        }
                        sbMain.Append("                    </td>");
                        sbMain.Append("                </tr>");
                        if (Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjdescription"]).Length > 0)
                        {
                            sbMain.Append("            <tr>");
                            sbMain.Append("                <td bgcolor='#f1f1f1' colspan=2 style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 10px;'>");
                            sbMain.Append("                    <table valign=top height=150 width=100% border=0 cellspacing=0 cellpadding=2>");
                            sbMain.Append("                        <tr>");
                            sbMain.Append("                            <td>");
                            sbMain.Append(Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjdescription"]));
                            sbMain.Append("                            </td>");
                            sbMain.Append("                        </tr>");
                            sbMain.Append("                    </table>");
                            sbMain.Append("                </td>");
                            sbMain.Append("            </tr>");
                        }
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td colspan=2 style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 10px;'>");
                        sbMain.Append("                        <table valign=top height=900 width=100% border=0 cellspacing=0 cellpadding=2>");
                        foreach (DataRow dr in dsMain.Tables[CurrentRow].Rows)
                        {
                            sbMain.Append("                        <tr>");
                            sbMain.Append("                            <td colspan=2 style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><strong><font color='#FF6600'>" + Util.TrimNull(dr["slnitemname"].ToString()) + "</font></strong><br>" + "<a target='_blank' href='../Items/ItemDetail.aspx?ItemID=" + Util.TrimNull(dr["productsysno"]) + "'>" + Util.TrimNull(dr["productname"].ToString()) + "<font color=red>" + Util.TrimNull(dr["PromotionWord"]) + "</font>" + "</a>");

                            if (Util.TrimIntNull(dr["defaultqty"].ToString()) > 1)
                            {
                                sbMain.Append(" <strong>(*" + dr["defaultqty"].ToString() + ")</strong>");
                            }
                            sbMain.Append("                            </td>");
                            sbMain.Append("                        </tr>");
                            if (!PrjectPicExist && Util.TrimIntNull(dr["isshowpic"].ToString()) == 0)
                            {
                                sbImage.Append("<img src=" + AppConfig.PicturePath + "small/" + Util.TrimNull(dr["productid"]) + ".jpg />");
                            }
                            TotalPrice += Util.ToMoney(dr["currentprice"].ToString()) * Util.ToMoney(dr["defaultqty"].ToString());
                        }
                        if (!PrjectPicExist)
                        {
                            sbMain.Replace("##Image##", sbImage.ToString());
                        }
                        sbMain.Append("                            <tr>");
                        sbMain.Append("                                <td colspan=2 align=center style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><strong><font color='#FF6600'>推荐标配总价: ¥" + TotalPrice.ToString() + " </font></strong></td>");
                        sbMain.Append("                            </tr>");
                        sbMain.Append("                            <tr>");
                        sbMain.Append("                                <td width=49% align=right style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><a href='../DIY/ProjectBuy.aspx?ID=" + PrjSysNo.ToString() + "'><img style='CURSOR: hand' border=0 src='images/diyimages/buynowbt.jpg' width=74 height=23></a></td>");
                        sbMain.Append("                                <td width=51% height=40 style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><a href='../DIY/ProjectDetail.aspx?ID=" + PrjSysNo.ToString() + "'><img style='CURSOR: hand' border=0 src='images/diyimages/choicebt.jpg' width=68 height=23></a></td>");
                        sbMain.Append("                            </tr>");
                        sbMain.Append("                        </table>");
                        sbMain.Append("                    </td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td height=2 background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline01.jpg' width=9 height=9></td>");
                        sbMain.Append("                    <td height=2 align=right background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline03.jpg' width=9 height=9></td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("            </table>");
                        sbMain.Append("        </td>");


                        //客户评论
                        sbMain.Append("        <td valign=top width=50%>");

                        if (Is53KF == 1)
                        {
                            sbMain.Append("            <table width=100%  text-align=center border=0 cellspacing=0 cellpadding=0 >");
                            sbMain.Append("                <tr><td align=center>");
                            sbMain.Append("<div id='c_53kf_diy' style='padding-bottom:3px;'> ");
                            sbMain.Append("<div class='c_53kf'> ");
                            sbMain.Append("<span id='c_53kf2_diy'>");
                            sbMain.Append("<!--script>document.write(\"<scr\"+\"ipt language=\"javascript\" src=\"http://www.53kf.com/kf.php?arg=stonebu&style=1&keyword='+escape(document.referrer)+'\'></scr'+'ipt>');</script--><a href='#' onclick=\"window.open('http://www.53kf.com/company.php?arg=stonebu&style=2','_blank','height=473,width=703,fullscreen=3,top=200,left=200,status=no,toolbar=no,menubar=no,resizable=no,scrollbars=no,location=no,titlebar=no,fullscreen=no');\"><img src=\" http://www.53kf.com/kfimg.php?arg=stonebu&style=2&on_img=http://www.icson.com/items/image/online_diy2.jpg&off_img=http://www.icson.com/items/image/offline_diy2.jpg \" border=\"0\"></a>");

                            sbMain.Append("</span>");
                            sbMain.Append("</div>");
                            sbMain.Append("</div>");
                            sbMain.Append("                </td></tr>");
                            sbMain.Append("                </table>");
                        }


                        sbMain.Append("            <table width=100% valign=top border=0 cellspacing=0 cellpadding=0>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td width=100% background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline04.jpg' width=9 height=9></td>");
                        sbMain.Append("                    <td align=right background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline06.jpg' width=9 height=9></td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td colspan=2 align=center bgcolor='#f1f1f1' style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 8px; font-size:14px;'>");
                        sbMain.Append("                     <strong>客户评论</strong></td>");
                        sbMain.Append("                </tr>");

                        sbMain.Append("            <tr>");
                        sbMain.Append("                <td height=20 colspan=2 align=right style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 2px;'>");
                        sbMain.Append("                    <table valign=top height=20 width=100% border=0 cellspacing=0 cellpadding=2>");
                        sbMain.Append("                        <tr>");
                        sbMain.Append("                            <td>");
                        sbMain.Append("<tr><td><a href='../Review/Remark.aspx?PID=" + Util.TrimNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjsysno"]) + "'><font color=green>发表评论</font></a></td><tr>");
                        sbMain.Append("                            </td>");
                        sbMain.Append("                        </tr>");
                        sbMain.Append("                    </table>");
                        sbMain.Append("                </td>");
                        sbMain.Append("            </tr>");

                        sbMain.Append("                        <tr>");
                        sbMain.Append("                            <td colspan=2 style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 2px;'>");
                        sbMain.Append("                              <table  valign=top width=100% border=0 cellspacing=0 cellpadding=2>");
                        sbMain.Append(ReviewManager.GetInstance().GetDIYReviewDiv(Util.TrimIntNull(dsMain.Tables[0].Rows[CurrentRow - 1]["prjsysno"])));
                        sbMain.Append("                              </table>");
                        sbMain.Append("</td>");
                        sbMain.Append("</tr>");


                        sbMain.Append("                <tr>");
                        sbMain.Append("                    <td height=2 background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline01.jpg' width=9 height=9></td>");
                        sbMain.Append("                    <td height=2 align=right background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline03.jpg' width=9 height=9></td>");
                        sbMain.Append("                </tr>");
                        sbMain.Append("            </table>");
                        sbMain.Append("        </td>");



                        CurrentRow++;
                    }
                    sbMain.Append("</tr>");
                    if (m < PageCount)
                    {
                        sbMain.Append("<tr>");
                        sbMain.Append("    <td colspan=" + PageSize.ToString() + "><hr style='border: dotted;' color=black size=1></td>");
                        sbMain.Append("</tr>");
                    }
                }

                //    sbMain.Append("    <tr>");
                //    for (int j = 0; j < dsMain.Tables[0].Rows.Count; j++)
                //    {
                //        decimal widthPercent = Util.TrimDecimalNull(100) / Util.TrimDecimalNull(dsMain.Tables[0].Rows.Count);

                //        int PrjSysNo = Util.TrimIntNull(dsMain.Tables[0].Rows[j]["prjsysno"].ToString());
                //        decimal TotalPrice = 0;
                //        StringBuilder sbImage = new StringBuilder();

                //        sbMain.Append("        <td valign=top width="+ widthPercent.ToString("##") +"%>");
                //        sbMain.Append("            <table width=100% valign=top border=0 cellspacing=0 cellpadding=0>");
                //        sbMain.Append("                <tr>");
                //        sbMain.Append("                    <td width=100% background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline04.jpg' width=9 height=9></td>");
                //        sbMain.Append("                    <td align=right background='images/diyimages/diyline05.jpg'><img src='images/diyimages/diyline06.jpg' width=9 height=9></td>");
                //        sbMain.Append("                </tr>");
                //        sbMain.Append("                <tr>");
                //        sbMain.Append("                    <td colspan=2 align=center bgcolor='#f1f1f1' style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 10px;'><strong style='font-size: 14px;'>" + Util.TrimNull(dsMain.Tables[0].Rows[j]["prjname"].ToString()) + "</strong></td>");
                //        sbMain.Append("                </tr>");
                //        sbMain.Append("                <tr>");
                //        sbMain.Append("                    <td height=110 colspan=2 align=center style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 2px;'>");
                //        bool PrjectPicExist = false;
                //        string ProjectPicFile = ProjectPicPath + PrjSysNo.ToString() + ".jpg";
                //        if (File.Exists(ProjectPicFile))
                //        {
                //            PrjectPicExist = true;
                //        }
                //        if (PrjectPicExist)  //project pic 存在就显示其project的图片,不存在就显示商品组合图片
                //        {
                //            ProjectPicFile = AppConfig.PicturePath + "project/" + PrjSysNo.ToString() + ".jpg";
                //            sbMain.Append("<img src='" + ProjectPicFile + "' />");
                //        }
                //        else
                //        {
                //            sbMain.Append("##Image##");
                //        }
                //        sbMain.Append("                    </td>");
                //        sbMain.Append("                </tr>");
                //        sbMain.Append("                <tr>");
                //        sbMain.Append("                    <td colspan=2 style='border-top-width: 1px;border-right-width: 1px;border-left-width: 1px;border-right-style: solid;border-left-style: solid;border-right-color: #b6b6b6;border-left-color: #b6b6b6;padding: 10px;'>");
                //        sbMain.Append("                        <table width=100% border=0 cellspacing=0 cellpadding=2>");
                //        foreach (DataRow dr in dsMain.Tables[j + 1].Rows)
                //        {
                //            sbMain.Append("                            <tr>");
                //            sbMain.Append("                                <td colspan=2 style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><strong><font color='#FF6600'>" + Util.TrimNull(dr["slnitemname"].ToString()) + "</font></strong><br>" + "<a target='_blank' href='../Items/ItemDetail.aspx?ItemID=" + Util.TrimNull(dr["productsysno"]) + "'>" + Util.TrimNull(dr["productname"].ToString()) + "</a>");

                //            if (Util.TrimIntNull(dr["defaultqty"].ToString()) > 1)
                //            {
                //                sbMain.Append(" <strong>(*" + dr["defaultqty"].ToString() + ")</strong>");
                //            }
                //            sbMain.Append("                   </td>");
                //            sbMain.Append("               </tr>");
                //            if (!PrjectPicExist && Util.TrimIntNull(dr["isshowpic"].ToString()) == 0)
                //            {
                //                sbImage.Append("<img src=" + AppConfig.PicturePath + "small/" + Util.TrimNull(dr["productid"]) + ".jpg />");
                //            }
                //            TotalPrice += Util.ToMoney(dr["currentprice"].ToString()) * Util.ToMoney(dr["defaultqty"].ToString());
                //        }
                //        if (!PrjectPicExist)
                //        {
                //            sbMain.Replace("##Image##", sbImage.ToString());
                //        }
                //        sbMain.Append("                            <tr>");
                //        sbMain.Append("                                <td colspan=2 align=center style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><strong><font color='#FF6600'>推荐标配总价: ¥"+ TotalPrice.ToString() +" </font></strong></td>");
                //        sbMain.Append("                            </tr>");
                //        sbMain.Append("                            <tr>");
                //        sbMain.Append("                                <td width=49% align=right style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><a href='../DIY/ProjectBuy.aspx?ID=" + PrjSysNo.ToString() + "'><img style='CURSOR: hand' border=0 src='images/diyimages/buynowbt.jpg' width=74 height=23></a></td>");
                //        sbMain.Append("                                <td width=51% height=40 style='border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: b0b3b5;'><a href='../DIY/ProjectDetail.aspx?ID=" + PrjSysNo.ToString() + "'><img style='CURSOR: hand' border=0 src='images/diyimages/choicebt.jpg' width=68 height=23></a></td>");
                //        sbMain.Append("                            </tr>");
                //        sbMain.Append("                        </table>");
                //        sbMain.Append("                    </td>");
                //        sbMain.Append("                </tr>");
                //        sbMain.Append("                <tr>");
                //        sbMain.Append("                    <td height=2 background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline01.jpg' width=9 height=9></td>");
                //        sbMain.Append("                    <td height=2 align=right background='images/diyimages/diyline02.jpg'><img src='images/diyimages/diyline03.jpg' width=9 height=9></td>");
                //        sbMain.Append("                </tr>");
                //        sbMain.Append("            </table>");
                //        sbMain.Append("        </td>");
                //    } //project end
            }

            //sbMain.Append("    </tr>");
            sbMain.Append("</table>");

            sbTotal.Append(sbHeader.ToString());
            sbTotal.Append("<TABLE width=100% border=0 align=center cellpadding=5 cellspacing=0>");
            sbTotal.Append("    <TR>");
            sbTotal.Append("        <TD width=160 valign=top>");
            sbTotal.Append(sbLeft.ToString());
            sbTotal.Append("        </TD>");
            sbTotal.Append("        <TD valign=top>");
            sbTotal.Append(sbMain.ToString());
            sbTotal.Append("        </TD>");
            sbTotal.Append("    </TR>");
            sbTotal.Append("<TABLE>");
            return(sbTotal.ToString());
        }