using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace Saving.Applications.admin.dlg.w_dlg_dialogadd_ctrl
{
    public partial class DsApp : DataSourceRepeater
    {
        public DataSet1.amappstatusDataTable DATA { get; set; }

        public void InitDsApp(PageWeb pw)
        {

            DataSet1 ds = new DataSet1();
            this.DATA = ds.amappstatus;
            this.EventItemChanged = "OnDsAppItemChanged";
            this.EventClicked = "OnDsAppClicked";
            this.InitDataSource(pw, RepeaterUserG, this.DATA, "dsApp");
            this.Button.Add("b_1");
            this.Register();
        }
        public void Retrieve()
        {
            string sql = @"  SELECT  amappstatus.application, amappstatus.description
                             FROM amappstatus      
                             WHERE ( AMAPPSTATUS.USED_FLAG = 1 )   and amappstatus.coop_id ='500001'";
            sql = WebUtil.SQLFormat(sql);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
     

    }
}