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.shrlon.w_sl_oil_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.mbmembmasterDataTable DATA { get; set; }
        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            css2.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.mbmembmaster;            
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.Register();
            this.Button.Add("b_memsearch");
        }
        public void RetrieveMain()
        {
            String sql = @"select member_no,(prename_desc||memb_name||' '|| memb_surname)as nameb from mbmembmaster m left join mbucfprename p on m.prename_code = p.prename_code where m.coop_id={0}";

            sql = WebUtil.SQLFormat(sql, state.SsCoopId);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }

        public void myear()
        {
            string sql = @"
select  0 as myear from  accaccountyear union
SELECT  account_year+543 as myear from accaccountyear where coop_id=  '" + state.SsCoopControl + "'  order by myear";
            sql = WebUtil.SQLFormat(sql);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "myear", "myear", "myear");
        }

    }
}