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.dlg
{
    public partial class w_dlg_sl_member_search_lite : PageWebDialog, WebDialog
    {
        public void InitJsPostBack()
        {
            dsCriteria.InitDsCriteria(this);
            dsList.InitDsList(this);
        }

        public void WebDialogLoadBegin()
        {
            if (!IsPostBack)
            {
                dsCriteria.DdMembGroup();
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
        }

        public void WebDialogLoadEnd()
        {
        }

        protected void BtSearch_Click(object sender, EventArgs e)
        {
            try
            {
                String ls_memno = "", ls_memname = "", ls_memsurname = "";
                String ls_memgroup = "", ls_contno = "";

                string ls_sqlext = "";

                string coop_id = state.SsCoopControl;

                string ls_sql1 = "and mbmembmaster.coop_id ='" + coop_id + "'";

                ls_memno = dsCriteria.DATA[0].member_no.Trim();
                ls_memname = dsCriteria.DATA[0].memb_name.Trim();
                ls_memsurname = dsCriteria.DATA[0].memb_surname.Trim();
                ls_memgroup = dsCriteria.DATA[0].membgroup_no.Trim();
                ls_contno = dsCriteria.DATA[0].loancontract_no.Trim();

                if (ls_memno.Length > 0)
                {
                    ls_sqlext = " and (  mbmembmaster.member_no like '%" + ls_memno + "%') ";
                }
                if (ls_memname.Length > 0)
                {
                    ls_sqlext += " and ( mbmembmaster.memb_name like '%" + ls_memname + "%') ";
                }
                if (ls_memsurname.Length > 0)
                {
                    ls_sqlext += " and ( mbmembmaster.memb_surname like '%" + ls_memsurname + "%') ";
                }
                if (ls_memgroup.Length > 0)
                {
                    ls_sqlext += " and ( mbmembmaster.membgroup_code = '" + ls_memgroup + "' )";
                }
                if (ls_contno.Length > 0)
                {
                    ls_sqlext += " and ( mbmembmaster.member_no in( select lncontmaster.member_no from lncontmaster where lncontmaster.loancontract_no like '%" + ls_contno + "%')) ";
                }
                string sql = sql = @"
                SELECT DISTINCT
                    MBMEMBMASTER.MEMBER_NO, 
                    MBUCFPRENAME.PRENAME_DESC, 
                    MBMEMBMASTER.MEMB_NAME, 
                    MBMEMBMASTER.MEMB_SURNAME, 
                    MBMEMBMASTER.MEMBGROUP_CODE, 
                    MBUCFMEMBGROUP.MEMBGROUP_DESC
                FROM         
                    MBMEMBMASTER, MBUCFMEMBGROUP, MBUCFPRENAME
                WHERE     
                    MBMEMBMASTER.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE AND 
                    MBMEMBMASTER.COOP_ID = MBUCFMEMBGROUP.COOP_ID AND 
                    MBMEMBMASTER.PRENAME_CODE = MBUCFPRENAME.PRENAME_CODE AND 
                    ROWNUM <= 300 AND
                    MBMEMBMASTER.COOP_ID = '" + coop_id + "' " + ls_sqlext;
                DataTable dt = WebUtil.Query(sql);
                dsList.ImportData(dt);
                LbCount.Text = "ดึงข้อมูล" + (dt.Rows.Count >= 300 ? "แบบสุ่ม" : "ได้") + " " + dt.Rows.Count + " รายการ";

            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            }
        }
    }
}