using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//using CoreSavingLibrary.WcfNShrlon;
using CoreSavingLibrary.WcfNShrlon;
using Sybase.DataWindow;
using System.Web.Services.Protocols;
using DataLibrary;
using System.Data;
using System.Globalization;

namespace Saving.Applications.shrlon
{
    public partial class w_sheet_sl_approve_loan : PageWebSheet, WebSheet
    {
        private n_shrlonClient shrlonService;
        private DwThDate thDwMaster;
        private DwThDate tDwMain;

        CultureInfo th = System.Globalization.CultureInfo.GetCultureInfo("th-TH");
        protected String jsgenReqDocNo = "";
        protected String postmember = "";
        protected String postloantype = "";
        protected String postallflag = "";
        protected string jsPostEntryid = "";
        protected string jspostdate = "";
        protected string jsPostSetFilter = "";
        static string apvlist = "";
        static string loan = "";
        #region WebSheet Members
       
        void WebSheet.InitJsPostBack()
        {


            jsgenReqDocNo = WebUtil.JsPostBack(this, "jsgenReqDocNo");
            postmember = WebUtil.JsPostBack(this, "postmember");
            postloantype = WebUtil.JsPostBack(this, "postloantype");
            jsPostEntryid = WebUtil.JsPostBack(this, "jsPostEntryid");
            postallflag = WebUtil.JsPostBack(this, "postallflag");
            jspostdate = WebUtil.JsPostBack(this, "jspostdate");
            jsPostSetFilter = WebUtil.JsPostBack(this, "jsPostSetFilter");
            thDwMaster = new DwThDate(dw_master, this);
            thDwMaster.Add("approve_date", "approve_tdate");

            tDwMain = new DwThDate(dw_cri, this);
            tDwMain.Add("loanreq_start", "loanreq_tstart");
            tDwMain.Add("loanreq_end", "loanreq_tend");
            //thDwMaster.Add("loanrcvfix_date", "loanrcvfix_tdate");
        }

        void WebSheet.WebSheetLoadBegin()
        {
            try
            {
                shrlonService = wcf.NShrlon;
            }
            catch
            {
                LtServerMessage.Text = WebUtil.ErrorMessage("ติดต่อ Web Service ไม่ได้");
                return;
            }
            this.ConnectSQLCA();

            if (IsPostBack)
            {
                if (dw_cri.RowCount > 1)
                {
                    dw_cri.DeleteRow(dw_cri.RowCount);
                }
                dw_master.RestoreContext();
                dw_cri.RestoreContext();
               
            }
            else
            {
                Londbegin();
                DateTime sdate = state.SsWorkDate;
                dw_cri.SetItemDateTime(1, "loanreq_start", state.SsWorkDate.AddYears(-70));
                dw_cri.SetItemDateTime(1, "loanreq_end", state.SsWorkDate.AddMonths(2));
                //dw_master.SetItemString(1, "loanreq_tstart", (state.SsWorkDate.AddYears(-70)).ToString("ddMMyyyy", th));
                //dw_master.SetItemString(1, "loanreq_tend", (state.SsWorkDate).ToString("ddMMyyyy", th));
                // this.InitLnReqList();
            }
            if (dw_master.RowCount < 1)
            {
                this.InitLnReqList();

            }

        }

        private void Londbegin()
        {

            string loantype2 = @"select loantype_code,loantype_desc from lnloantype where coop_id= {0}";

            loantype2 = WebUtil.SQLFormat(loantype2,state.SsCoopId);
            Sdt dtIns = WebUtil.QuerySdt(loantype2);

            dw_cri.InsertRow(0);
            dw_cri.SetItemDecimal(1, "all_flag", 1);
            DwUtil.RetrieveDDDW(dw_cri, "loantype_code", "sl_approve_loan.pbl", null);
            DwUtil.RetrieveDDDW(dw_cri, "entry_id", "sl_approve_loan.pbl", null);

            try
            {
                int i = 1;
                while (dtIns.Next())
                {
                    dw_cri.SetItemString(i, "loantype_code", dtIns.GetString("loantype_code") + " " + dtIns.GetString("loantype_desc"));
                    i++;
                }
            }
            catch { }
            dw_cri.SetItemString(1, "member_no", "");
            //dw_cri.SetItemString(1, "loanreq_start", "");
            //dw_cri.SetItemString(1, "loanreq_end", "");
        }

        void WebSheet.CheckJsPostBack(string eventArg)
        {
            if (eventArg == "jsgenReqDocNo")
            {
                this.GenReqDocNo();
            }
            else if (eventArg == "postmember")
            {
                this.JsPostMember();
            }
            else if (eventArg == "postloantype")
            {
                this.JsPostLoantype();
            }
            else if (eventArg == "postallflag")
            {
                this.JsPostAllflag();
            }
            else if (eventArg == "jsPostEntryid")
            {
                JsPostEntryid();
            }
            else if (eventArg == "jspostdate")
            {
                this.JsPostLoanDate();
            }
            else if (eventArg == "jsPostSetFilter")
            {
                this.PostSetFilter();
            }
        }

        private void InitLnReqList()
        {
            try
            {
                String reqListXML = shrlonService.of_initlist_lnreqapv(state.SsWsPass, state.SsCoopId, state.SsCoopId);

                dw_master.Reset();
                DwUtil.ImportData(reqListXML, dw_master, null, FileSaveAsType.Xml);

                dw_master.SetSort(" loanrequest_docno asc , loantype_code asc ,loancontract_no asc");
                dw_master.Sort();

            }

            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage("ไม่มีข้อมูลรอทำรายการ");
            }
        }

        private void PostSetFilter()
        {
            int entry_id =0;
           
            try {
             entry_id = Convert.ToInt32(dw_cri.GetItemString(1, "entry_id"));
            }catch (Exception ex) { entry_id =8; }
            //String type = dw_cri.GetItemString(1, "loantype_code");
            String memno = dw_cri.GetItemString(1, "member_no");
            String type = "%%";
            //if (type == "")
            //{
            //    type = "'%%'";
            //}

            DateTime a = dw_cri.GetItemDateTime(1, "loanreq_start");
            DateTime b = dw_cri.GetItemDateTime(1, "loanreq_end");

            try { DwUtil.RetrieveDataWindow(dw_master, "sl_loanreq_ksmk.pbl", null, "%" + memno, type, entry_id, state.SsCoopControl, dw_cri.GetItemDateTime(1, "loanreq_start"), dw_cri.GetItemDateTime(1, "loanreq_end")); }
            catch (Exception ex) { ex.ToString(); }
           

        }

        private void GenReqDocNo()
        {
            //JsChklastDocno();
            int k = 0;
            int count = dw_master.RowCount;
            for (int i = 0; i < count; i++)
            {
                string req_coopid = dw_master.GetItemString(i + 1, "coop_id");

                String lncont_no = "";
                try { lncont_no = dw_master.GetItemString(i + 1, "loancontract_no"); }
                catch { lncont_no = ""; }

                String lncont_status = dw_master.GetItemString(i + 1, "loanrequest_status");
                if (lncont_status == "1")
                {
                    if (lncont_no == "")
                    {
                        String loantype_code = dw_master.GetItemString(i + 1, "loantype_code").Trim();
                        String newReqDocNo = shrlonService.of_getnextcontractno(state.SsWsPass, req_coopid, loantype_code);// of_gennewcontractno(state.SsWsPass, req_coopid, loantype_code);

                         
                        dw_master.SetItemString(i + 1, "loancontract_no", newReqDocNo);
                        dw_master.SetItemString(i + 1, "approve_tdate", (state.SsWorkDate).ToString("ddMMyyyy", th));
                        dw_master.SetItemDate(i + 1, "approve_date", state.SsWorkDate);
                        //  dw_master.SetItemDateTime(i + 1, "approve_date", state.SsWorkDate);
                    }
                }
            }

        }
        private int Jschklastdocnonew(string as_contno, string as_loantype_code)
        {

            try
            {
                string lncont_no = as_contno, last_condocno = "", ls_lastdocnonew = "";// dw_master.GetItemString(i, "loancontract_no");
                int lendocno = lncont_no.Substring(4, 6).Length;//lncont_no.Length - 4
                double lastdocno = Convert.ToDouble(lncont_no.Substring(4, Convert.ToInt16(lendocno)));
                string coop_id = state.SsCoopId;
                lastdocno--;
                string ls_lastdocno = "00000000000" + lastdocno.ToString();
                ls_lastdocnonew = ls_lastdocno.Substring(ls_lastdocno.Length - lendocno, lendocno);
                String documentcode = wcf.NBusscom.of_getattribloantype(state.SsWsPass, as_loantype_code, "document_code");
                //a.document_code,
                string ls_sql = @"select   max( a.document_code || substr(  b.loancontract_no,3,2)||' ' || substr( b.loancontract_no,5,6) ) as lastdocno
                        from lncontmaster b , lnloantype a 
                        where a.loantype_code = b.loantype_code and  a.coop_id = b.coop_id and a.coop_id = '" + coop_id + "' and a.document_code = '" + documentcode + "'";
                try
                {
                    Sdt dt2 = WebUtil.QuerySdt(ls_sql);

                    if (dt2.Next())
                    {
                        last_condocno = dt2.GetString("lastdocno");

                    }
                    // last_condocno = ls_lastdocno.Substring(ls_lastdocno.Length - lendocno, lendocno);
                    string lastcontno22 = lncont_no.Substring(0, 3) + ls_lastdocno + lncont_no.Substring(8, 2);
                    string last_condocno4 = last_condocno.Substring(last_condocno.Length - 4, 4);

                    if (Convert.ToDouble(last_condocno4) != lastdocno)
                    {
                       // LtServerMessage.Text = WebUtil.WarningMessage("การอนุมัติเลขสัญญาเงินกู้ เลขสัญญา " + as_contno + " ไม่เป็นเลขต่อจากเลขที่ล่าสุดของก่อนหน้านั้น(เลขล่าสุด = " + last_condocno + " ) <br />กรุณาตรวจสอบด้วย");
                    }
                }
                catch
                {
                  //  LtServerMessage.Text = WebUtil.WarningMessage("การอนุมัติเลขสัญญาเงินกู้ เลขสัญญา " + as_contno + " ไม่พบเลขที่ล่าสุดของก่อนหน้านั้น <br />กรุณาตรวจสอบด้วย");
                }
            }
            catch
            {

            }
            return 1;
        }
        //เพิ่ม function
        private int JsChklastDocno()
        {
            int count = dw_master.RowCount;

            for (int i = 1; i <= count; i++)
            {

                String lncont_status = dw_master.GetItemString(i, "loanrequest_status");

                String lncont_no = "";
                try
                {
                    lncont_no = dw_master.GetItemString(i, "loancontract_no");
                }
                catch
                {
                }
                //if (lncont_status == "1" && lncont_no != "")
                //{
                //    int lendocno = lncont_no.Substring(3, 6).Length;//lncont_no.Length - 4
                //    double lastdocno = Convert.ToDouble(lncont_no.Substring(3, Convert.ToInt16(lendocno)));

                //    lastdocno--;
                //    string ls_lastdocno = "00000000000" + lastdocno.ToString();
                //    ls_lastdocno = ls_lastdocno.Substring(ls_lastdocno.Length - lendocno, lendocno);
                //    string lastcontno = lncont_no.Substring(0, 3) + ls_lastdocno + lncont_no.Substring(8, 2);

                //    string ls_sql = " select * from lncontmaster where loancontract_no = '" + lastcontno + "'";
                //    Sdt dt = WebUtil.QuerySdt(ls_sql);
                //    if (dt.GetRowCount() <= 0)
                //    {
                //        LtServerMessage.Text = WebUtil.WarningMessage("การอนุมัติเลขสัญญาเงินกู้ เลขสัญญาของคนแรก ไม่เป็นเลขต่อจากเลข่ที่ล่าสุดของก่อนหน้านั้น กรุณาตรวจสอด้วย");
                //        return 1;
                //    }
                //    else
                //    {
                //        return 1;
                //    }
                //}
            }
            return 1;
        }
        private void JsPostMember()
        {
            int entry_id = Convert.ToInt32(dw_cri.GetItemString(1, "entry_id"));
            String type = "%";
            String memno = dw_cri.GetItemString(1, "member_no");
            if (type == "")
            {
                type = "%";
            }
           
            //string[] arg2 = new string[2] {  };
            try { DwUtil.RetrieveDataWindow(dw_master, "sl_loanreq_ksmk.pbl", null, "%" + memno, "%", entry_id, state.SsCoopControl, dw_cri.GetItemDate(1, "loanreq_start"), dw_cri.GetItemDate(1, "loanreq_start")); }
            catch (Exception ex) { ex.ToString(); }
        }
        private void JsPostLoanDate()
        {
            String member_no = WebUtil.MemberNoFormat(dw_cri.GetItemString(1, "member_no"));
            String loanreq_start = dw_cri.GetItemString(1, "loanreq_start");
            String loanreq_end = dw_cri.GetItemString(1, "loanreq_end");
            string[] arrloanstart = loanreq_start.Split('/');
            string[] arrloanend = loanreq_end.Split('/');
            string tmpstart = (Convert.ToDecimal(arrloanstart[2]) - 543) + arrloanstart[1] + arrloanstart[0];
            string tmpend = (Convert.ToDecimal(arrloanend[2]) - 543) + arrloanend[1] + arrloanend[0];
            string filter = "string(approve_date,'yyyymmdd') >= '" + tmpstart + "'";
            filter += " AND string(approve_date,'yyyymmdd') <= '" + tmpend + "'";
            dw_master.SetFilter(filter);
            dw_master.Filter();
            dw_cri.SetItemString(1, "member_no", member_no);
            dw_cri.SetItemString(1, "loantype_code", "");
            dw_cri.SetItemDecimal(1, "all_flag", 0);
            dw_cri.SetItemString(1, "loanreq_start", loanreq_start);
            dw_cri.SetItemString(1, "loanreq_end", loanreq_end);
        }
        private void JsPostEntryid()
        {
            int entry_id =  Convert.ToInt32(dw_cri.GetItemString(1, "entry_id"));
            String type = dw_cri.GetItemString(1, "loantype_code");
            if(type==""){
                type = "%";
            }
            //string[] arg2 = new string[2] {  };
            try { DwUtil.RetrieveDataWindow(dw_master, "sl_loanreq_ksmk.pbl", null, "%%", type, entry_id, state.SsCoopControl, dw_cri.GetItemDate(1, "loanreq_start"), dw_cri.GetItemDate(1, "loanreq_start")); }
            catch (Exception ex) { ex.ToString(); }

        }
        private void JsPostLoantype()
        {
            String loantype_code = dw_cri.GetItemString(1, "loantype_code");
            dw_master.SetFilter("loantype_code = '" + loantype_code + "'");
            dw_master.Filter();
            dw_master.SetSort("loanrequesc_docno asc , loancontract_no asc ");
            dw_master.Sort();
            dw_cri.SetItemString(1, "loantype_code", loantype_code);
            dw_cri.SetItemString(1, "member_no", "");
            dw_cri.SetItemDecimal(1, "all_flag", 0);
        }
        private void JsPostAllflag()
        {
            dw_cri.SetItemDecimal(1, "all_flag", Convert.ToDecimal(HfAllFlag.Value));
            InitLnReqList();
            dw_cri.SetItemString(1, "member_no", "");
            dw_cri.SetItemString(1, "loantype_code", "");
        }

        void WebSheet.SaveWebSheet()
        {
            string loanrequest_docno="";
            try
            {
                // Oh มงบอกว่าส่งหมดมันเยอะ XML คงเต็ม
                // เลย filter ให้เหลือน้อยๆก่อนแล้วส่งไป
                dw_master.SetFilter("loanrequest_status <> 8");
                dw_master.Filter();


                int count = dw_master.RowCount + 1;
                apvlist = "";
                loan = "";

                string as_apvid = state.SsUsername;

                for (int i = 1; i < count; i++)
                {

                    string request_status = dw_master.GetItemString(i, "loanrequest_status");
                    Decimal choose_flag;
                    try { choose_flag = dw_master.GetItemDecimal(i, "choose_flag"); }
                    catch { choose_flag = 0; }
                   
                    try { loanrequest_docno = dw_master.GetItemString(i, "loanrequest_docno"); }
                    catch { loanrequest_docno = ""; }


                    if (choose_flag == 1)
                    {
                        if (request_status == "0")
                        {
                            dw_master.SetItemDateTime(i, "approve_date", state.SsWorkDate);

                        }
                        else
                        {
                            try
                            {
                                dw_master.SetItemDateTime(i, "approve_date", DateTime.ParseExact(dw_master.GetItemString(1, "approve_tdate"), "ddMMyyyy", th));
                            }
                            catch (Exception e)
                            {
                                dw_master.SetItemDateTime(i, "approve_date", DateTime.ParseExact(dw_master.GetItemString(1, "approve_tdate"), "dd/MM/yyyy", th));

                            }
                        }
                      
                        if (request_status == "1" || request_status == "0" || request_status == "11")
                        {
                            try
                            {
                                // GenReqDocNo();
                                //เพิ่ม ที่ function  SaveWebSheet()  
                                //Edit By BankCM
                                if (i == 1)
                                {
                                    Decimal loanrequest = dw_master.GetItemDecimal(i, "loanrequest_amt");
                                    string status = dw_master.GetItemString(i, "loanrequest_status");
                                    string loancontract = dw_master.GetItemString(i, "loancontract_no");

                                    loan = "'" + loanrequest + "','" + status + "','" + loancontract + "'";

                                    apvlist = "'" + dw_master.GetItemString(i, "loanrequest_docno").Trim() + "'";



                                }
                                else
                                {
                                    Decimal loanrequest = dw_master.GetItemDecimal(i, "loanrequest_amt");
                                    string status = dw_master.GetItemString(i, "loanrequest_status");
                                    string loancontract = dw_master.GetItemString(i, "loancontract_no");

                                    loan = loan + ";'" + loanrequest + "','" + status + "','" + loancontract + "'";

                                    apvlist = apvlist + ",'" + dw_master.GetItemString(i, "loanrequest_docno").Trim() + "'";
                                }
                            }
                            catch (Exception ex)
                            {
                                LtServerMessage.Text = WebUtil.ErrorMessage(ex);
                                return;
                            }
                        }
                        //else if (request_status == "11")
                        //{
                        //    Decimal loanrequest = dw_master.GetItemDecimal(i, "loanrequest_amt");
                        //    string sql = "update lnreqloan set loanrequest_status='11',approve_id='" + state.SsUsername + "',loanapprove_amt='" + loanrequest + "'  where loanrequest_docno = '" + loanrequest_docno + "' ";
                        //    sql = WebUtil.SQLFormat(sql);
                        //    int sql_q = WebUtil.ExeSQL(sql);
                        //}

                    }
                }


                String ls_xml_main = dw_master.Describe("DataWindow.Data.XML");
                Int16 ls_xml = shrlonService.of_saveapv_lnreq(state.SsWsPass, ls_xml_main, as_apvid, state.SsCoopControl, state.SsWorkDate);//SaveLnReqRpv
                if (ls_xml > 0)
                {
                   //for (int i = 1; i < count; i++)
                   // {
                   //     Decimal choose_flag;
                   //     try { choose_flag = dw_master.GetItemDecimal(i, "choose_flag"); }
                   //     catch { choose_flag = 0; }
                   //    // string loanrequest_docno;
                   //     try { loanrequest_docno = dw_master.GetItemString(i, "loanrequest_docno"); }
                   //     catch { loanrequest_docno = ""; }


                   //     if (choose_flag == 1)
                   //     {
                   //         //string loancontract = dw_master.GetItemString(i, "loancontract_no");
                   //         //string loan_docno = dw_master.GetItemString(i, "loanrequest_docno");
                   //         //string coop = state.SsCoopControl;
                   //         //savePeriodpaydet(loan_docno, coop, loancontract); //ส่งไป บันทึกตารางชำระเงิน
                             

                   //           //  DateTime loanrcvfix_date = DateTime.Today;
                   //           //  string Updateexpirecont_date = @" select loanrcvfix_date from lnreqloan where loancontract_no={0} and coop_id={1}";
                   //           //  Updateexpirecont_date = WebUtil.SQLFormat(Updateexpirecont_date, loancontract, state.SsCoopId);
                   //           //  Sdt d = WebUtil.QuerySdt(Updateexpirecont_date);
                   //           //  if (d.Next())
                   //           //  {
                   //           //      loanrcvfix_date = d.GetDate("loanrcvfix_date");
                   //           //  }


                   //           //  decimal Contract_interest = -1;
                   //           ////  interest_rate = interest_rate / 100;
                   //           //  string UpdateContract_interrest = @"update lncontmaster set contract_interest= {0},expirecont_date={3}  where loancontract_no={1} and coop_id={2}";
                   //           //  UpdateContract_interrest = WebUtil.SQLFormat(UpdateContract_interrest, Contract_interest, loancontract, state.SsCoopId, loanrcvfix_date);
                   //           //  WebUtil.QuerySdt(UpdateContract_interrest);

                   //             //update ครั้งที่ percent    , ชุดที่    cost_amt  
                   //          //string   sql33 = "select cost_percent , cost_amt,loanobjective_code from lnreqloan where loanrequest_docno = '" + loan_docno + "' and coop_id = '" + state.SsCoopControl + "'";
                   //          //   Sdt sf = WebUtil.QuerySdt(sql33);
                   //          //   if (sf.Next())
                   //          //   {
                   //          //       //update ครั้งที่ contcount    , ชุดที่    contcount_end
                   //          //       string sqlUpdateContcountMaster = @"update lncontmaster set contcount = {0} , contcount_end ={1} , loanobjective_code = '" + sf.GetString("loanobjective_code") + "' where coop_id={2} and loancontract_no={3} ";

                   //          //       sqlUpdateContcountMaster = WebUtil.SQLFormat(sqlUpdateContcountMaster, sf.GetDecimal("cost_percent"), sf.GetDecimal("cost_amt"), state.SsCoopId, loancontract);
                   //          //       WebUtil.QuerySdt(sqlUpdateContcountMaster);
                   //          //   }
                             

                   //     }
                   // }

                 
                    LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกสำเร็จ");
                    InitLnReqList();

                }

                // ตัด single quotes ตัวแรกและตัวสุดท้ายเพื่อส่งเป็น string argument ให้ ireport
                //apvlist = apvlist.Substring(1, apvlist.Length - 2);
            }
            catch (SoapException ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex.ToString());
            }
        }

        public void savePeriodpaydet(String loan_docno, String coop_id, String loancontract_no)
        {
            string sql = @"insert into  lncontperiodpaydet( loancontract_no,   coop_id,	period, 	period_payment,
                         prinpaid_amt,principal_arrear,	expireperiod_date,lastcalfine_date )
                          select  {0}  ,  {1}  ,	period, 	principal_payment, 0,	0,	expireperiod_date,null
	            from lnreqloanperiodpaydet where loanrequest_docno = {2} and coop_id  = {3}  ";

            try
            {
                sql = WebUtil.SQLFormat(sql,
                   loancontract_no, coop_id, loan_docno, coop_id);
                Sdt dtIns = WebUtil.QuerySdt(sql);

            }
            catch
            {

            }

        }


        void WebSheet.WebSheetLoadEnd()
        {
            if (dw_cri.RowCount > 1)
            {
                dw_cri.DeleteRow(dw_cri.RowCount);
            }
            DwUtil.RetrieveDDDW(dw_master, "loantype_code", "sl_approve_loan.pbl", null);
            dw_master.SaveDataCache();
            dw_cri.SaveDataCache();

            dw_master.PageNavigationBarSettings.Visible = (dw_master.RowCount > 20);
        }

        #endregion

//        protected void PrintCont_Click(object sender, EventArgs e)
//        {
//            //apvlist = "'Q580001066','Q580001814','Q580001017','Q580001028'";

//            if (apvlist != "")
//            {
//                try
//                {
//                    string sql = @"SELECT  mn.PRENAME_DESC||''||mb.MEMB_NAME||' '||mb.MEMB_SURNAME as fullname,
//trunc(months_between(sysdate,mb.BIRTH_DATE)/12) as age,
//         lr.MEMBER_NO,
//         lr.LOANTYPE_CODE,
//         lr.LOANCREDIT_AMT,
//         lr.LOANPERMISS_AMT,
//         lr.LOANREQUEST_AMT,
//ftreadtbaht(lr.LOANREQUEST_AMT) as thbathloan,
//ftreadtbaht(lr.PERIOD_PAYMENT) as thbathpayment,
//         lr.PERIOD_PAYMENT,
//         lr.LOANPAYMENT_TYPE,
//         mb.MEMB_NAME,
//         mb.MEMB_SURNAME,
//         mb.MEMBGROUP_CODE,
//         mg.MEMBGROUP_DESC,
//         cc.COOP_NAME,
//         cc.MANAGER,
//TO_CHAR(lr.approve_date, 'dd MON yyyy', 'NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') as datethai,
//         lr.approve_date,
//         lr.LOANCONTRACT_NO,
//         lr.PERIOD_LASTPAYMENT,
//         lr.SALARY_AMT,
//         lr.SHARE_LASTPERIOD,
//         lr.SHARE_PERIODVALUE,
//         mb.ADDR_NO,
//         mb.ADDR_MOO,
//         mb.ADDR_SOI,
//         mb.ADDR_VILLAGE,
//         mb.ADDR_ROAD,
//         md.DISTRICT_DESC,
//         mp.PROVINCE_DESC,
//         mt.TAMBOL_DESC,
//         mb.TAMBOL_CODE,
//         mb.AMPHUR_CODE,
//         mb.PROVINCE_CODE,
//         mb.ADDR_POSTCODE,
//mb.POSITION_DESC,
//NVL(mb.POSITION_DESC,'   ') as POSDESC ,
//TO_CHAR(lr.approve_date, 'Month', 'NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') as monththai,
//         lr.PERIOD_PAYAMT,
//		mb.ADDR_PHONE,
//		lr.PERIOD_LASTPAYMENT,
//		li.INTEREST_RATE,
//		lo.LOANOBJECTIVE_DESC,
//		 FT_CALAGEMTH(mb.BIRTH_DATE,SYSDATE) AS BIRTH_DATE
//    FROM LNREQLOAN lr,
//         MBMEMBMASTER mb,
//         MBUCFMEMBGROUP mg,
//         MBUCFPRENAME mn,
//         CMCOOPCONSTANT cc,
//		LNLOANTYPE lt,
//		LNUCFLOANOBJECTIVE lo,
//		LNCFLOANINTRATEDET li,
//         MBUCFDISTRICT md,
//         MBUCFPROVINCE mp,
//         MBUCFTAMBOL mt
//   WHERE ( mp.province_code (+) = md.province_code) and
//         ( mb.amphur_code = md.district_code (+)) and
//         ( trim(mb.province_code) = md.province_code (+)) and
//         ( mb.tambol_code = mt.tambol_code (+)) and
//         ( mb.amphur_code = mt.district_code (+)) and
//         ( lr.COOP_ID = mb.COOP_ID ) and
//		(lr.LOANTYPE_CODE = lt.LOANTYPE_CODE) and
//(lr.LOANTYPE_CODE = lo.LOANTYPE_CODE) and
//		(lr.LOANOBJECTIVE_CODE = lo.LOANOBJECTIVE_CODE) and
//         ( mg.COOP_ID = mb.COOP_ID ) and
//         ( mg.MEMBGROUP_CODE = mb.MEMBGROUP_CODE ) and
//         ( mn.PRENAME_CODE = mb.PRENAME_CODE ) and
//         ( lr.MEMBER_NO = mb.MEMBER_NO )  and
//		(li.LOANINTRATE_CODE = lt.INTTABRATE_CODE )and
//		(lr.APPROVE_DATE between li.EFFECTIVE_DATE and li.EXPIRE_DATE ) and
//		(lr.LOANREQUEST_STATUS=11) and
//		(lr.COOP_ID = {0}) and
//		( lr.LOANREQUEST_DOCNO in (" + apvlist + @")  )
//    ORDER By lr.LOANREQUEST_DOCNO";

//                    //LtServerMessage.Text = apvlist;

//                    sql = WebUtil.SQLFormat(sql, state.SsCoopId);

//                    iReportArgument args = new iReportArgument(sql);
//                    //args.Add("as_coop_id", iReportArgumentType.String, state.SsCoopId);
//                    //args.Add("as_loanreqdocno", iReportArgumentType.String, apvlist);
//                    iReportBuider report = new iReportBuider(this, "กำลังสร้างใบปะหน้าพิจารณาการขอกู้");
//                    report.AddCriteria("r_ln_print_loan_req_doc_gsb", "ใบปะหน้าพิจารณาการขอกู้", ReportType.pdf, args);
//                    report.AutoOpenPDF = true;
//                    report.Retrieve();

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

//        protected void PrintColl_Click(object sender, EventArgs e)
//        {
//            //apvlist = "'Q580000207','Q580000208'";
//            if (apvlist != "")
//            {
//                try
//                {

//                    string sql = @"select ft_getmbname(lc.coop_id,lr.member_no) as full_name,
//mb.member_no,
//lr.approve_date,
//TO_CHAR(lr.approve_date,'dd') as day,
//TO_CHAR(lr.approve_date,'fmMonth') as month,
//TO_CHAR(lr.approve_date,'yyyy')+543 as year,
//mb.card_person,
//mb.Addr_No,
//mb.Addr_Moo,
//mb.Addr_Soi,
//mb.Addr_Village,
//mb.Addr_Road,
//mb.Tambol_Code,
//tb.tambol_desc,
//mb.Amphur_Code,
//dt.district_desc,
//mb.Province_Code,
//mb.Addr_Postcode,
//mb.Addr_Mobilephone,
//lr.loanapprove_amt,
//ftreadtbaht(lr.loanapprove_amt) as loanapprove_tbaht,
//ft_getmbname(lc.coop_id,trim(lc.ref_collno)) as coll_name ,
//lc.ref_collno,
//ft_memgrp(lc.coop_id,mb.membgroup_code) as membgroup_desc,
//lc.collactive_amt,
//ftreadtbaht(lc.collactive_amt) as collactive_tbaht,
//trunc(Ft_Calage( birth_date , sysdate , 4 )) as birth,
//pr.province_desc
//from
//lnreqloan lr,
//lnreqloancoll  lc,
//mbmembmaster mb,
//mbucfprovince pr,
//mbucfdistrict dt,
//mbucftambol tb
//where  lr.loanrequest_docno = lc.loanrequest_docno
//and mb.province_code = pr.province_code
//and mb.amphur_code = dt.district_code
//and mb.tambol_code = tb.tambol_code
//and lr.coop_id = lc.coop_id
//and lr.coop_id = mb.coop_id
//and trim(lc.ref_collno) = mb.member_no
//and lr.loanrequest_docno in (" + apvlist + @")
//and lr.coop_id = {0}
//and lc.loancolltype_code='01'";
//                    sql = WebUtil.SQLFormat(sql, state.SsCoopId);
//                    iReportArgument args = new iReportArgument(sql);
//                    //args.Add("as_coop_id", iReportArgumentType.String, state.SsCoopId);
//                    //args.Add("as_loanrequest_docno", iReportArgumentType.String, apvlist);

//                    iReportBuider report = new iReportBuider(this, "กำลังสร้างใบปะหน้าพิจารณาการขอกู้");
//                    report.AddCriteria("r_ln_print_loan_coll_doc_gsb", "ใบปะหน้าพิจารณาการขอกู้", ReportType.pdf, args);
//                    report.AutoOpenPDF = true;
//                    report.Retrieve();

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

//        protected void PrintIns_Click(object sender, EventArgs e)
//        {
//            if (apvlist != "")
//            {
//                try
//                {
//                    string sql = @"SELECT mp.PRENAME_DESC||''||mb.MEMB_NAME||' '|| mb.MEMB_SURNAME as fullname,
//         lr.MEMBER_NO,
//TO_CHAR(lr.approve_date, 'dd MON yyyy', 'NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') as datethai,
//         lr.LOANTYPE_CODE,
//         lr.LOANREQUEST_DOCNO,
//         lr.LOANPERMISS_AMT,
//         lr.LOANREQUEST_AMT,
//         lr.LOANPAYMENT_TYPE,
//         lr.PERIOD_PAYMENT,
//         mb.MEMB_NAME,
//         mb.MEMB_SURNAME,
//         mb.MEMBGROUP_CODE,
//         mg.MEMBGROUP_DESC,
//         cc.COOP_NAME,
//         cc.MANAGER,
//         lr.approve_date,
//         lr.LOANCONTRACT_NO,
//         mb.MEMBER_NO,
//         mb.SALARY_ID,
//         mb.POSITION_DESC,
//TO_CHAR(lr.APPROVE_DATE, 'dd MON yyyy', 'NLS_CALENDAR=''THAI BUDDHA'' NLS_DATE_LANGUAGE=THAI') as dateAPP,
//         lr.APPROVE_DATE,
//         lr.LOANAPPROVE_AMT,
//ftreadtbaht( lr.LOANAPPROVE_AMT) as LOANAPPROVE_TBAHT
//    FROM LNREQLOAN lr,
//         MBMEMBMASTER mb,
//         MBUCFMEMBGROUP mg,
//         MBUCFPRENAME mp,
//         CMCOOPCONSTANT cc,
//         LNLOANTYPE lt,
//         LNUCFLOANOBJECTIVE lo,
//         LNCFLOANINTRATEDET li
//   WHERE ( lr.COOP_ID = mb.COOP_ID ) and
//         ( lr.LOANTYPE_CODE = lt.LOANTYPE_CODE ) and
//         ( lr.LOANOBJECTIVE_CODE = lo.LOANOBJECTIVE_CODE ) and
//         ( mg.COOP_ID = mb.COOP_ID ) and
//         ( mg.MEMBGROUP_CODE = mb.MEMBGROUP_CODE ) and
//         ( mp.PRENAME_CODE = mb.PRENAME_CODE ) and
//         ( lr.MEMBER_NO = mb.MEMBER_NO ) and
//         ( li.LOANINTRATE_CODE = lt.INTTABRATE_CODE ) and
//	(lr.APPROVE_DATE between li.EFFECTIVE_DATE and li.EXPIRE_DATE) and
//	(lo.LOANTYPE_CODE  =lr.LOANTYPE_CODE ) and
//         ( lr.COOP_ID = {0}) AND
//         ( lr.LOANREQUEST_DOCNO in (" + apvlist + @"))
//    ORDER By lr.LOANREQUEST_DOCNO";

//                    sql = WebUtil.SQLFormat(sql, state.SsCoopId);
//                    iReportArgument args = new iReportArgument(sql);
//                    //args.Add("as_coop_id", iReportArgumentType.String, state.SsCoopId);
//                    //args.Add("as_loanrequest_docno", iReportArgumentType.String, apvlist);

//                    iReportBuider report = new iReportBuider(this, "");
//                    report.AddCriteria("r_ln_print_loan_ins_doc_gsb", "ใบปะหน้าพิจารณาการขอกู้", ReportType.pdf, args);
//                    report.AutoOpenPDF = true;
//                    report.Retrieve();

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

//        protected void PrintContSpc_Click(object sender, EventArgs e)
//        {

//            if (apvlist != "")
//            {
//                try
//                {

//                    string sql = @"select ft_getmbname(lr.coop_id,lr.member_no) as full_name,
//mb.member_no,
//mb.salary_id,
//lr.approve_date,
//TO_CHAR(lr.approve_date,'dd') as day,
//TO_CHAR(lr.approve_date,'fmMonth') as month,
//TO_CHAR(lr.approve_date,'yyyy')+543 as year,
//mb.card_person,
//lr.loanrequest_docno,
//lr.coop_id,
//mb.Addr_No,
//mb.Addr_Moo,
//mb.Addr_Soi,
//mb.Addr_Village,
//mb.Addr_Road,
//mb.Tambol_Code,
//mb.Amphur_Code,
//mb.Province_Code,
//mb.Addr_Postcode,
//mb.Addr_Mobilephone,
//lr.loanapprove_amt,
//ftreadtbaht(lr.loanapprove_amt) as loanapprove_tbaht,
//ft_memgrp(lr.coop_id,mb.membgroup_code) as membgroup_desc,
//trunc(Ft_Calage( birth_date , sysdate , 4 )) as birth,
//pr.province_desc,
//mt.tambol_desc,
//md.district_desc,
//lr.period_payment,
//ftreadtbaht(lr.period_payment) as tperiod_payment,
//lr.period_payamt,
//lo.loanobjective_desc,
//ld.interest_rate
//from
//lnreqloan lr,
//mbmembmaster mb,
//mbucfprovince pr,
//mbucfdistrict md,
//mbucftambol mt,
//lnucfloanobjective lo,
//lncfloanintratedet ld,
//lnloantype lc
//where
//lr.member_no = mb.member_no
//and lr.loantype_code = lc.loantype_code
//and lc.inttabrate_code = ld.loanintrate_code
//and lr.approve_date between ld.effective_date and ld.expire_date
//and trim(mb.province_code) = trim(pr.province_code)
//and trim(mb.Amphur_Code) = trim(md.district_code)
//and trim(mb.Tambol_Code) = trim(mt.tambol_code)
//and lr.loantype_code = lo.loantype_code
//and lr.loanobjective_code = lo.loanobjective_code
//and lr.coop_id = mb.coop_id
//and lr.loanrequest_docno in (" + apvlist + @")
//and lr.coop_id = {0}";

//                    sql = WebUtil.SQLFormat(sql, state.SsCoopId);
//                    iReportArgument args = new iReportArgument(sql);
//                    iReportBuider report = new iReportBuider(this, "กำลังสร้างใบปะหน้าพิจารณาการขอกู้เงินกู้พิเศษ");
//                    report.AddCriteria("r_ln_print_loan_req_doc_spc_gsb", "ใบปะหน้าพิจารณาการขอกู้เงินกู้พิเศษ", ReportType.pdf, args);
//                    report.AutoOpenPDF = true;
//                    report.Retrieve();

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

    }
}