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.ws_sl_reqloan_law_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.LNLAWMBMASTERDataTable DATA { get; set; }

        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            css2.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.LNLAWMBMASTER;
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");

             this.Button.Add("b_memsearch");

            this.Register();
        }

    
        public void RetrieveMemberno(string docno)
        {
            string sql = @"select member_no, (prename_desc||memb_name||'  '||memb_surname) as memb_name,
(trim(mbucfmembgroup.membgroup_code)||' : '||mbucfmembgroup.membgroup_desc) as membgroup_code,card_person,mbucfmembtype.membtype_desc as membtype_code  from lnlawmbmaster inner join mbucfprename on 
mbucfprename.prename_code = lnlawmbmaster.prename_code inner join mbucfmembgroup on mbucfmembgroup.membgroup_code = lnlawmbmaster.membgroup_code inner join mbucfmembtype on
mbucfmembtype.membtype_code = lnlawmbmaster.membtype_code
            where  
                  ( ( lnlawmbmaster.coop_id = {0} )
		    and ( lnlawmbmaster.member_no like {1} ) )";

            sql = WebUtil.SQLFormat(sql, state.SsCoopId, "%"+docno);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
        public void RetrieveMembernoOld(string docno)
        {
            string sql = @"select lnlawmbmaster.member_no, (prename_desc||memb_name||'  '||memb_surname) as memb_name,
(trim(mbucfmembgroup.membgroup_code)||' : '||mbucfmembgroup.membgroup_desc) as membgroup_code,card_person,mbucfmembtype.membtype_desc as membtype_code
,lnlawmaster.startcont_date  from lnlawmaster inner join  lnlawmbmaster on lnlawmaster.member_no =lnlawmbmaster.member_no  inner join mbucfprename on 
mbucfprename.prename_code = lnlawmbmaster.prename_code inner join mbucfmembgroup 
on mbucfmembgroup.membgroup_code = lnlawmbmaster.membgroup_code inner join mbucfmembtype on
mbucfmembtype.membtype_code = lnlawmbmaster.membtype_code
            where  
                  ( ( lnlawmaster.coop_id = {0} )
		    and ( lnlawmaster.loancontract_no like {1} ) )";

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

    }
}