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;
using DataLibrary;

namespace Saving.Applications.shrlon.w_sheet_setconference_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet2.DataTable1DataTable DATA { get; set; }
        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            css2.Visible = false;
            DataSet2 ds = new DataSet2();
            this.DATA = ds.DataTable1;
            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 ,membgroup_code 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");
        }


        public void DdCon(int account_year, string member_no)
        {
            try
            {
                decimal con = 9;
                string sql21 = @"select conference_mark as con from mbmarkconference where member_no={0} and account_year={1}";
                sql21 = WebUtil.SQLFormat(sql21, member_no, account_year);
                Sdt dt21 = WebUtil.QuerySdt(sql21);
                if (dt21.Next())
                {
                    con = dt21.GetDecimal("con");
                }
                if (con == 9)
                {
                    string sql = @"select  '1' as orders,'9' as value,'กรุณาเลือก' as display from  lnloantype union
select '2' as orders,'1' as value,'เข้าร่วม' as display   from  lnloantype union 
select '3' as orders,'0' as value,'ขาด' as display from  lnloantype order by orders asc";
                    sql = WebUtil.SQLFormat(sql);
                    DataTable dt = WebUtil.Query(sql);
                    this.DropDownDataBind(dt, "mbmark_amount", "display", "value");
            
                }
                else if (con == 1)
                {
                    string sql = @"
select '1' as orders,'1' as value,'เข้าร่วม' as display   from  lnloantype union 
select '2' as orders,'0' as value,'ขาด' as display from  lnloantype order by orders asc";
                    sql = WebUtil.SQLFormat(sql);
                    DataTable dt = WebUtil.Query(sql);
                    this.DropDownDataBind(dt, "mbmark_amount", "display", "value");
                }
                else if (con == 0)
                {
                    string sql = @"
select '2' as orders,'1' as value,'เข้าร่วม' as display   from  lnloantype union 
select '1' as orders,'0' as value,'ขาด' as display from  lnloantype order by orders asc";
                    sql = WebUtil.SQLFormat(sql);
                    DataTable dt = WebUtil.Query(sql);
                    this.DropDownDataBind(dt, "mbmark_amount", "display", "value");
                }

            }
            catch (Exception) { }
        }
    }
}