<%@ Control Language="c#" Inherits="QP7.Site43.Template78.InsFondChildren_ChildrenRightPart" ClassName="InsFondChildren_ChildrenRightPart_Presentation" EnableViewState="True" CompilerOptions='"C:\QP7_VS_Files_2_User\Health\Sites\Site43\template_controls__Main_Template\InsFondChildren_ChildrenRightPart.ascx_partial.cs"' CodeFile="InsFondChildren_ChildrenRightPart.ascx.cs" %>
<%@ import NameSpace="Quantumart.QPublishing" %>
<%@ import NameSpace="System.IO" %>
<%@ import NameSpace="System.Data" %>
<%@ Register TagPrefix="qp" NameSpace="Quantumart.QPublishing" Assembly="Quantumart" %>
<div class="block_title_new">
    <asp:Repeater ID="container" runat="server">
        <HeaderTemplate>
            <div class="help_cap">
                <span>Им нужна помощь</span>
            </div>
        </HeaderTemplate>
        <ItemTemplate>
            <div class="help">
                <div class="help_l">
                    <a href="<%# Navigation.Main["help_childrens"].NavigateUrl + (String.IsNullOrEmpty(Eval("Alias").ToString()) ? Eval("Content_item_id") : Eval("Alias")) %>">
                        <img src='<%# GetContentUploadUrl("Фонды Дети")+"/"+  Eval("ImageOrigin")%>' width="120"
                            height="89" alt=""></a></div>
                <div class="help_r">
                    <a href="<%# Navigation.Main["help_childrens"].NavigateUrl + (String.IsNullOrEmpty(Eval("Alias").ToString()) ? Eval("Content_item_id") : Eval("Alias")) %>">
                        <%# Eval("FirstName")%> <%# Eval("LastName")%>
                    </a><span class="hr_span">Осталось собрать:</span> <span class="hr_sum">
                        <%# (Convert.ToInt32(String.IsNullOrEmpty(Eval("NeedMoney").ToString()) ? 0 : Eval("NeedMoney"))
                        - Convert.ToInt32(String.IsNullOrEmpty(Eval("SumMoney").ToString()) ? 0 : Eval("SumMoney"))).ToString()
                        %>
                        руб.</span> <a href="<%#Eval("UrlSite")%>" <%# (String.IsNullOrEmpty(Eval("UrlSite").ToString())) ? dispBlock : "" %>>
                            <img src="/upload/images/fonds/fonds_2_12.png" width="98" height="28" alt="">
                        </a>
                </div>
            </div>
        </ItemTemplate>
        <FooterTemplate>
        </FooterTemplate>
    </asp:Repeater>
    <div class="help_g">
        <div style="margin-left: 7px; padding-top: 5px">
            <span class="help_g_span"><a href="<%#Navigation.Main["help_childrens"].NavigateUrl%>">Все дети</a></span> 
            <span class="num"><%# ChildrensCount %> </span>
        </div>
    </div>
</div>





-----------------------------------------------------------------------
=================================================================
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
using Quantumart.QPublishing;
using System;
using System.Configuration;
using System.Web.Caching;
using System.Web.UI.WebControls;
using System.Data;
using System.Text.RegularExpressions;
using System.Text;
using System.Collections;
using System.Web.UI;
using System.Data.SqlClient;
using QPUtilities.Navigation;
using QPUtilities;
using QPUtilities.Navigation;
using QPUtilities;

namespace QP7.Site43.Template78
{
	public partial class InsFondChildren_ChildrenRightPart : QPYafControls.QUserControl
	{

		
		
		
		        public int ChildrensCount; // кол-во записей детей
		                public string dispBlock = "style=\"display: none\"";
		
		        protected void LoadGeneric(Object sender, EventArgs e)
		        {
		            string cmdSQL = String.Format(@" select [Fields]
		                                            from content_{1}_{0} C 
		                                                        order by Position "
		                                                      , IsStage ? "stage" : "live"
		                                                      , GetContentID("Фонды Дети"));
		
		            DataTable dataChild = GetData(cmdSQL.Replace("[Fields]", "top 3 C.*"));
		            container.DataSource = dataChild;
		
		            DataTable dataCnt = GetData(cmdSQL.Replace("[Fields]", " * "));
		                    ChildrensCount = dataCnt.Rows.Count;
		           // ChildrensCount = dataCnt.Columns.Count;
		
		        }
		
		        override public void InitUserHandlers(EventArgs e)
		        {
		            LoadGeneric(this, e);
		        }
		
		
		
		
		
		    
			
			
			
	}
}