using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CoreSavingLibrary;
using System.Data;

namespace Saving.Applications.shrlon.ws_sl_payoutslip_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.DataTable1DataTable DATA { get;  set; }

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

        public void Retrieve()
        {
            string sql = @"  SELECT   
         MBUCFPRENAME.PRENAME_DESC,   
         MBMEMBMASTER.MEMB_NAME,   
         MBMEMBMASTER.MEMB_SURNAME,   
         MBUCFMEMBGROUP.MEMBGROUP_DESC,   
         SLSLIPPAYOUT.COOP_ID,   
         SLSLIPPAYOUT.PAYOUTSLIP_NO,   
         SLSLIPPAYOUT.MEMCOOP_ID,   
         SLSLIPPAYOUT.MEMBER_NO,   
         SLSLIPPAYOUT.DOCUMENT_NO,   
         SLSLIPPAYOUT.POSTSLIP_NO,   
         SLSLIPPAYOUT.SLIPTYPE_CODE,   
         SLSLIPPAYOUT.SLIP_DATE,   
         SLSLIPPAYOUT.OPERATE_DATE,   
         SLSLIPPAYOUT.SHRLONTYPE_CODE,   
         SLSLIPPAYOUT.CONCOOP_ID,   
         SLSLIPPAYOUT.LOANCONTRACT_NO,   
         SLSLIPPAYOUT.RCVPERIOD_FLAG,   
         SLSLIPPAYOUT.RCV_PERIOD,   
         SLSLIPPAYOUT.PAYOUT_AMT,   
         SLSLIPPAYOUT.PAYOUTCLR_AMT,   
         SLSLIPPAYOUT.PAYOUTNET_AMT,   
         SLSLIPPAYOUT.BFPERIOD,   
         SLSLIPPAYOUT.BFSHRCONT_BALAMT,   
         SLSLIPPAYOUT.BFLASTRECEIVE_DATE,   
         SLSLIPPAYOUT.BFCONTLAW_STATUS,   
         SLSLIPPAYOUT.MONEYTYPE_CODE,   
         SLSLIPPAYOUT.EXPENSE_BANK,   
         SLSLIPPAYOUT.EXPENSE_BRANCH,   
         SLSLIPPAYOUT.EXPENSE_ACCID,   
         SLSLIPPAYOUT.BANKFEE_AMT,   
         SLSLIPPAYOUT.BANKSRV_AMT,   
         SLSLIPPAYOUT.ACCID_FLAG,   
         SLSLIPPAYOUT.TOFROM_ACCID,   
         SLSLIPPAYOUT.SLIP_STATUS,   
         SLSLIPPAYOUT.SLIPCLEAR_NO,   
         SLSLIPPAYOUT.MEMBGROUP_CODE,   
         SLSLIPPAYOUT.ENTRY_ID,   
         SLSLIPPAYOUT.ENTRY_DATE,   
         SLSLIPPAYOUT.ENTRY_BYCOOPID  
    FROM SLSLIPPAYOUT,   
         MBMEMBMASTER,   
         MBUCFPRENAME,   
         MBUCFMEMBGROUP  
   WHERE ( SLSLIPPAYOUT.MEMCOOP_ID = MBMEMBMASTER.COOP_ID ) and  
         ( SLSLIPPAYOUT.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and  
         ( MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE ) and  
         ( MBMEMBMASTER.COOP_ID = MBUCFMEMBGROUP.COOP_ID ) and  
         ( MBMEMBMASTER.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE ) and  
         ( ( slslippayout.coop_id = {0} ) AND  
         ( slslippayout.payoutslip_no = {1} ) )  ";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl, this.DATA[0].DOCUMENT_NO);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
    }
}