{\rtf1\fbidis\ansi\ansicpg874\deff0\nouicompat\deflang1054{\fonttbl{\f0\fnil\fcharset0 Calibri;}{\f1\fnil\fcharset222 CordiaUPC;}{\f2\fnil\fcharset222 Calibri;}{\f3\fnil\fcharset0 CordiaUPC;}{\f4\fnil Consolas;}{\f5\fnil\fcharset0 Consolas;}}
{\colortbl ;\red255\green255\blue0;\red0\green0\blue255;\red43\green145\blue175;\red163\green21\blue21;\red255\green0\blue0;\red0\green128\blue0;}
{\*\generator Riched20 6.3.9600}\viewkind4\uc1 
\pard\sa200\sl240\slmult1\f0\fs24\lang9 17/06/2558\par
////\f1\lang1054\'e4\'c1\'e8\'e0\'aa\'e7\'a4\'a8\'d3\'b9\'c7\'b9\'a4\'e9\'d3\f2  \f1\'e0\'be\'c3\'d2\'d0\f2  \f1\'a9\'a9\f2  \f1\'b7\'d5\'e8\'b9\'e8\'d2\'b9\'e4\'c1\'e8\'b5\'e9\'cd\'a7\'c1\'d5\'cd\'d0\'e4\'c3\'a4\'e9\'d3\f2  \f1\'e0\'cd\'d2\'cd\'cd\'a1\f2  \f0\lang1033 //\tab\tab\tab\par
//\f1\lang1054\'e0\'aa\'e7\'a4\'c2\'cd\'b4\'a4\'e9\'d3\'bb\'c3\'d0\'a1\'d1\'b9\f0\lang1033\tab\tab\tab\par
// sum_use_amt = parseFloat(sum_use_amt.toFixed(2));\tab\tab\tab\par
// if (sum_use_amt != loanrequest_amt) \{\tab\tab\tab\par
// check = false;\tab\tab\tab\par
// alert("\f1\lang1054\'a1\'c3\'d8\'b3\'d2\'e3\'ca\'e8\'a2\'e9\'cd\'c1\'d9\'c5\'cb\'c5\'d1\'a1\'bb\'c3\'d0\'a1\'d1\'b9\'e3\'cb\'e9\'a4\'c3\'ba\'b6\'e9\'c7\'b9\'b4\'e9\'c7\'c2\f0\lang1033 ");\tab\tab\tab\par
// \}\tab\tab\tab\par
\tab\tab\tab\par
\f1\lang1054\'e0\'be\'d4\'e8\'c1\f2  \f0\lang1033\tab\tab\tab\par
SLSLIPPPOST\tab\tab\tab\par
cmdocumentcontol \f1\lang1054\'e4\'c1\'e8\'a7\'d1\'e9\'b9\f2  \f0\lang1033 error \f1\lang1054\'b5\'cd\'b9\f2  \f1\'a8\'e8\'d2\'c2\'e0\'a7\'d4\'b9\'a1\'d9\'e9\f2  \f1\'cb\'b9\'e9\'d2\'a8\'e8\'d2\'c2\f0\lang1033\par
.............................................................................................\par
//\par
\f1\lang1054\'c3\'d2\'c2\'a1\'d2\'c3\'b7\'d5\'e8\'c2\'e9\'d2\'c2\f2  \f1\'c1\'d2\f2  \f0\lang1033 Exten \f1\lang1054\'e1\'c5\'e9\'c7\'e1\'a1\'e9\'e4\'a2\f2  \f1\'cb\'b9\'e9\'d2\'a8\'cd\f0\lang1033\par
\par
\f1\lang1054\'cb\'b9\'e9\'d2\'a8\'cd\f2  \f0\lang1033 ws_mbshr_req_mbnew\par
public void NewClear()\par
\f1\lang1054\'e0\'be\'d4\'e8\'c1\f2  \f1\'b5\'e8\'cd\'a1\'d1\'ba\'cd\'d1\'e9\'b9\'cd\'d7\'e8\'b9\'e6\f0\lang1033\par
   dsMain.DATA[0].APPLTYPE_CODE = "10";\par
   dsMain.DATA[0].MEMBTYPE_CODE = "10";\par
\par
..............................................................................................\par
//w_sheet_mbshr_apv_mbnew\par
\f1\lang1054\'e0\'be\'d4\'e8\'c1\'a1\'d2\'c3\'c3\'d1\'b9\'e0\'c5\'a2\f2  \f1\'ca\'c1\'d2\'aa\'d4\'a1\'ca\'c1\'b7\'ba\f2  \f1\'e0\'b5\'d4\'c1\f2  \f0\lang1033 S \f1\lang1054\'b9\'d3\'cb\'b9\'e9\'d2\f0\lang1033\par
 else if (state.SsCoopControl == "018001")\par
                            \{\par
                                // \f1\lang1054\'ca\'c1\'d2\'aa\'d4\'a1\f2  \f1\'ca\'c1\'b7\'ba\f2  \f1\'a4\'c3\'d9\'b9\'e8\'d2\'b9\f0\lang1033\par
                                if (member_type == 2)\par
                                \{\par
                                    ls_memberno =  "S" + ls_memberno;\par
                                \}\par
                            \}\par
\par
................................................................................................\par
18/06/2558\par
//w_sheet_sl_approve_loan\par
//\f1\lang1054\'e1\'a1\'e9\'e4\'a2\'e0\'be\'d4\'e8\'c1\f2  \f1\'e4\'c1\'e8\'e3\'cb\'e9\f2  \f0\lang1033 error \f1\lang1054\'b5\'cd\'b9\f2  \f1\'cd\'b9\'d8\'c1\'d1\'b5\'d4\'b7\'d5\'c5\'e8\'d0\'cb\'c5\'d2\'c2\'e6\f2  \f1\'a4\'b9\f0\lang1033\par
void WebSheet.SaveWebSheet()\par
        \{\par
            try\par
            \{\par
                int count = dw_master.RowCount + 1;\par
                for (int i = 1; i < count; i++)\par
                \{\par
                    Decimal choose_flag;\par
                    try \{ choose_flag = dw_master.GetItemDecimal(i, "choose_flag"); \}\par
                    catch \{ choose_flag = 0; \}\par
\par
                    string loanrequest_docno;\par
                    try \{ loanrequest_docno = dw_master.GetItemString(i, "loanrequest_docno"); \}\par
                    catch \{ loanrequest_docno = ""; \}\par
\par
                    if (choose_flag == 1)\par
                    \{\par
                        string request_status = dw_master.GetItemString(i, "loanrequest_status");\par
                        if (request_status == "1" || request_status == "0")\par
                        \{\par
                            try\par
                            \{\par
                                //string as_apvid = state.SsUsername;\par
                                // GenReqDocNo();\par
                                //\f1\lang1054\'e0\'be\'d4\'e8\'c1\f2  \f1\'b7\'d5\'e8\f2  \f0\lang1033 function  SaveWebSheet()  \par
                                // Oh \f1\lang1054\'c1\'a7\'ba\'cd\'a1\'c7\'e8\'d2\'ca\'e8\'a7\'cb\'c1\'b4\'c1\'d1\'b9\'e0\'c2\'cd\'d0\f2  \f0\lang1033 XML \f1\lang1054\'a4\'a7\'e0\'b5\'e7\'c1\f0\lang1033\par
                                // \f1\lang1054\'e0\'c5\'c2\f2  \f0\lang1033 filter \f1\lang1054\'e3\'cb\'e9\'e0\'cb\'c5\'d7\'cd\'b9\'e9\'cd\'c2\'e6\'a1\'e8\'cd\'b9\'e1\'c5\'e9\'c7\'ca\'e8\'a7\'e4\'bb\f0\lang1033\par
                                dw_master.SetFilter("loanrequest_status <> 8");\par
                                dw_master.Filter();\par
                                //String ls_xml_main = dw_master.Describe("DataWindow.Data.XML");\par
                                //String ls_xml = shrlonService.SaveLnReqRpv(state.SsWsPass, ls_xml_main, as_apvid, state.SsCoopControl, state.SsWorkDate);\par
\par
                            \}\par
                            catch (Exception ex)\par
                            \{\par
                                LtServerMessage.Text = WebUtil.ErrorMessage(ex);\par
                                return;\par
                            \}\par
                        \}\par
                        else if (request_status == "11")\par
                        \{\par
                            Decimal loanrequest = dw_master.GetItemDecimal(i, "loanrequest_amt");\par
                            string sql = "update lnreqloan set loanrequest_status='11',approve_id='" + state.SsUsername + "',loanapprove_amt='" + loanrequest + "'  where loanrequest_docno = '" + loanrequest_docno + "' ";\par
                            sql = WebUtil.SQLFormat(sql);\par
                            int sql_q = WebUtil.ExeSQL(sql);\par
\par
                        \}\par
                    \}\par
                \}\par
\par
                string as_apvid = state.SsUsername;\par
                String ls_xml_main = dw_master.Describe("DataWindow.Data.XML");\par
                String ls_xml = shrlonService.SaveLnReqRpv(state.SsWsPass, ls_xml_main, as_apvid, state.SsCoopControl, state.SsWorkDate);\par
\par
                LtServerMessage.Text = WebUtil.CompleteMessage("\f1\lang1054\'ba\'d1\'b9\'b7\'d6\'a1\'ca\'d3\'e0\'c3\'e7\'a8\f0\lang1033 ");\par
                InitLnReqList();\par
            \}\par
            catch (SoapException ex)\par
            \{\par
                LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex));\par
            \}\par
        \}\tab\par
.....................................................................................................................................\tab\tab\par
//update \f1\lang1054\'cd\'d2\'c2\'d8\'e0\'a1\'c9\'d5\'c2\'b3\f2  \f1\'cd\'d2\'c2\'d8\f0\lang1033\par
//UPDATE mbmembmaster \par
//SET retry_date = add_months(birth_date,+720) \par
// where retry_date is null;\par
//;commit;\par
..............................................................................................................................................................................\par
\highlight1\f1\lang1054\'cd\'d2\'a8\'e4\'c1\'e8\'a8\'d3\'e0\'bb\'e7\'b9\'b5\'e9\'cd\'a7\'e0\'aa\'e7\'a4\f2  \f1\'e0\'be\'c3\'d2\'d0\'ba\'d2\'a7\'b7\'d5\'e8\'e4\'c1\'e8\'e4\'b4\'e9\f2  \f1\'b5\'c3\'c7\'a8\'ca\'cd\'ba\f0\lang1033\par
\cf2 private\cf0  \cf2 void\cf0  CheckCollPermiss()\par
\f1\lang1054\'b7\'e8\'cd\'b9\f0\lang1033\par
\cf2 int\cf0  li_periodpay = \cf3 Convert\cf0 .ToInt32(dw_main.GetItemDecimal(1, \cf4 "period_payamt"\cf0 ));\par
                                \cf2 if\cf0  (li_retryage < li_periodpay)\par
                                \{\par
                                    LtServerMessagecoll.Text = \cf3 WebUtil\cf0 .ErrorMessage(\cf4 "\f1\lang1054\'bc\'d9\'e9\'a4\'e9\'d3\'a4\'b9\'b9\'d5\'e9\f2  \f1\'a4\'e9\'d3\'bb\'c3\'d0\'a1\'d1\'b9\'e4\'b4\'e9\'ca\'d9\'a7\'ca\'d8\'b4\f2  \f0\lang1033 "\cf0  + li_retryage + \cf4 " \f1\lang1054\'a7\'c7\'b4\f2  \f1\'ab\'d7\'e8\'a7\'b9\'e9\'cd\'c2\'a1\'c7\'e8\'d2\'a7\'c7\'b4\'a2\'cd\'a1\'d9\'e9\f0\lang1033 "\cf0 );\par
                                \}\par
\highlight0\par
.......................................................................................................................................\par
19/06/2558\par
\f1\lang1054\'e0\'cd\'d2\'b7\'e8\'cd\'b9\'ab\'d7\'e9\'cd\'cb\'d8\'e9\'b9\'e0\'be\'d4\'e8\'c1\'a8\'d2\'a1\f2  \f0\lang1033 BAAC \f1\lang1054\'c1\'d2\'e3\'ca\'e8\f2  \f0\lang1033 exten \f1\lang1054\'b7\'d3\'e3\'cb\'e9\'ab\'d7\'e9\'cd\'cb\'d8\'e9\'b9\'e0\'be\'d4\'e8\'c1\'b5\'c3\'a7\'a1\'d1\'ba\'a1\'d2\'c3\'a4\'d3\'b9\'c7\'b9\'ab\'d7\'e9\'cd\'cb\'d8\'e9\'b9\'b7\'d5\'e8\'b9\'e8\'d2\'b9\f0\lang1033\par
\f1\lang1054\'e3\'cb\'e9\'e3\'aa\'e9\'cb\'b9\'e9\'d2\'a2\'cd\'a1\'d9\'e9\f2    \cf2\f0\lang1033 w_sheet_sl_loan_requestment_dol     // \f1\lang1054\'e3\'aa\'e9\f2  \f0\lang1033 GSB \f1\lang1054\'e1\'c5\'e9\'c7\f2  \f0\lang1033 error \par
\cf0\f1\lang1054\'e0\'be\'d4\'e8\'c1\'b7\'cd\'b9 \'a1\'d2\'c3\'ab\'d7\'e9\'cd\'cb\'d8\'e9\'b9\'e0\'be\'d4\'e8\'c1\'a8\'d2\'a1 \f3\lang1033 baac \f1\lang1054\'c1\'d2\'e3\'ca\'e8\'a4\'c3\'d9\'b9\'e8\'d2\'b9  \f3\lang1033 fc \f1\lang1054\'b9\'d5\'e9\'b7\'d1\'e9\'a7\'cb\'c1\'b4 \f4\fs19 of_initclearshare();\par
\f1\'e0\'bb\'c5\'d5\'e8\'c2\'b9\'aa\'d7\'e8\'cd\'e4\'ab\'b5\'ec \'a8\'d2\'a1 \cf2\f4\lang1033 w_sheet_sl_loan_requestment_\f5 dol \f1\lang1054\'e0\'bb\'e7\'b9 \f4 w_sheet_sl_loan_requestment_nan\par

\pard\sl240\slmult1\cf0\f3\fs24\lang1033 ..........................................................................................................................\par
15/7/ 2558\par
\cf5\f1\lang1054\'cb\'b9\'e9\'d2\'a8\'cd\'ca\'c1\'d1\'a4\'c3\'ca\'c1\'d2\'aa\'d4\'a1 \'e0\'ab\'bf\'bc\'d9\'e9\'c3\'d1\'ba\'bc\'c5\'bb\'c3\'d0\'e2\'c2\'aa\'b9\'ec\'e4\'c1\'e4\'e8\'b4\'e9 \f3\lang1033 (\f1\lang1054\'e1\'c1\'e8\'ce\'e8\'cd\'a7\'ca\'cd\'b9 \f3\lang1033 , \f1\lang1054\'cd\'cd\'c1\'ca\'d4\'b9\'e4\'c1\'e8\'c3\'d9\'e9\'e0\'bb\'e7\'b9\'cb\'c3\'d7\'cd\'e0\'bb\'c5\'e8\'d2\f3\lang1033 )\cf0\par
\par
\f1\lang1054\'e1\'a1\'e9\'e4\'a2 \f3\lang1033 datawindow dlg \f1\lang1054\'bb\'d8\'e8\'c1\'a4\'e9\'b9\'cb\'d2\'cb\'b9\'e9\'d2\'a2\'cd\'a1\'d9\'e9 \f3\lang1033 where member_status = 1\par
\par
\cf5\f1\lang1054\'cb\'b9\'e9\'d2\'a2\'cd\'a1\'d9\'e9 \'a9\'a9 \'e0\'ab\'bf \'cd\'b9\'d8\'c1\'d1\'b5\'d4 \'ca\'c3\'e9\'d2\'a7\'e0\'c5\'a2 \'e1\'b5\'e8\'e4\'c1\'e8\'a8\'e8\'d2\'c2\'e0\'a7\'d4\'b9\'a1\'d9\'e9\'e0\'c5\'c2 \'e1\'ba\'ba \f3\lang1033 auto \f1\lang1054\'cb\'b9\'e9\'d2\'a8\'e8\'d2\'c2\'c1\'d2\'e3\'cb\'e9\'e0\'c5\'c2\cf0\f3\lang1033\par
\par
\f1\lang1054\'e0\'a7\'d4\'b9\'bd\'d2\'a1\'cd\'cd\'c1\'b7\'c3\'d1\'be\'c2\'ec \'a4\'d3\'b9\'c7\'b9\'b4\'cd\'a1\'e0\'ba\'d5\'e9\'c2\'e4\'c1\'e8\'b6\'d9\'a1 \f3\lang1033 //\f1\lang1054\'bb\'d2\'c2 \'e1\'a1\'e9\'e4\'a2\'e1\'c5\'e9\'c7\f3\lang1033\par
.............................................................................................................................\par
16/7/2558\par
\par
\f1\lang1054\'e0\'a7\'d4\'b9\'bd\'d2\'a1\f3\lang1033\par
//alter table dpdeptstatement add intwait_amt number(12,2) default 0 ;commit;\par
//intwait_amt\par
//select * from dpdeptstatement ;\par
\f1\lang1054\'e3\'cb\'e9\'e0\'a7\'d4\'b9\'bd\'d2\'a1\'a4\'d3\'b9\'c7\'b3\'b4\'cd\'a1\'e0\'ba\'d5\'e9\'c2\'bb\'d4\'b4\'bb\'d1\'ad\'aa\'d5\'b6\'d9\'a1 \f3\lang1033 //\f1\lang1054\'bb\'d2\'c2\f3\lang1033\par
\par
\f1\lang1054\'cb\'d8\'e9\'b9 \f3\lang1033\par
\f1\lang1054\'e0\'be\'d4\'e8\'c1\'a2\'e9\'cd\'c1\'d9\'c5 \f3\lang1033 shsharetypemthrate //\f1\lang1054\'e4\'c1\'b7\'ec\f3\lang1033\par
\par
\f1\lang1054\'cb\'b9\'d5\'e9\f3\lang1033\par
//update lncontmaster\par
//set loanpay_code = 'KEP'\par
//;\par
//commit;\par
\par
\f1\lang1054\'b6\'e9\'d2\'e4\'c1\'e8\'c1\'d5 \'e3\'cb\'e9\'cd\'d1\'be\'b4\'e9\'c7\'c2\f3\lang1033\par
//select * from mbmembmaster where retry_date is null and member_status = 1;\par
//select * from mbmembmaster where retry_date is null;\par
//UPDATE mbmembmaster \par
//SET retry_date = add_months(birth_date,+720) \par
// where retry_date is null\par
//;commit;\par
//\par
//select * from mbmembmaster where work_date is null;\par
//UPDATE mbmembmaster \par
//SET work_date =  member_date\par
//;commit;\par
\par
//delete  from shsharetypemthrate\par
//where member_type = '2'\par
//;commit;\f1\lang1054\'e3\'cb\'e9 \'a1\'d2\'c3\'a4\'d3\'b9\'c7\'b3\'e0\'a7\'d4\'b9\'e0\'b4\'d7\'cd\'b9\'a4\'a7\'e0\'cb\'c5\'d7\'cd\'b6\'d9\'a1\f3\lang1033\par
\par
\f1\lang1054\'e1\'a1\'e9\'e4\'a2\'e2\'a4\'e9\'b4 \'a1\'d2\'c3\'a4\'d3\'b9\'c7\'b3\'ab\'d7\'e9\'cd\'cb\'d8\'e9\'b9\'e0\'be\'d4\'e8\'c1\f3\lang1033\par
\f1\lang1054\'e1\'a1\'e9\'e4\'a2 \'cb\'b9\'e9\'d2\'a8\'cd \'a1\'d2\'c3\'a4\'d3\'b9\'c7\'b3\'e0\'a7\'d4\'b9\'e0\'b4\'d7\'cd\'b9\'a4\'a7\'e0\'cb\'c5\'d7\'cd\f3\lang1033\par
\f1\lang1054\'e1\'a1\'e9\'e4\'a2 \'cb\'b9\'e9\'d2\'a8\'cd \'e1\'ca\'b4\'a7\'c3\'d2\'c2\'c5\'d0\'e0\'cd\'d5\'c2\'b4\'ca\'d1\'ad\'ad\'d2\'cb\'d1\'a1\'a1\'c5\'ba\f3\lang1033\par
\par
update \f1\lang1054\'cd\'d2\'c2\'d8\'e0\'a1\'c9\'d5\'c2\'b3 \'a1\'d2\'c3\'a4\'d3\'b9\'c7\'b3\'cd\'d2\'c2\'d8\'a1\'e7\'a8\'d0\'b6\'d9\'a1\'b5\'e9\'cd\'a7 \f3\lang1033 (\f1\lang1054\'be\'c8\f3\lang1033 ) (\f1\lang1054\'c3\'cd\'b5\'c3\'c7\'a8\'ca\'cd\'ba \'ca\'c1 \'a4\'d3\'b9\'c7\'b3\'e1\'ba\'ba\'e0\'b4\'d5\'c2\'c7\'a1\'d1\'b9\'cb\'c3\'d7\'cd\'e0\'bb\'c5\'e8\'d2\f3\lang1033 )\par
\par
\cf5 convert \f1\lang1054\'e3\'cb\'e9\'e0\'cd\'d2\'c7\'d1\'b9\'e0\'a1\'c9\'d5\'c2\'b3 \'c1\'d2\'b4\'e9\'c7\'c2 //\'be\'d5\'e8\'b9\'d2\'b7\par
\'cb\'b9\'e9\'d2\'a8\'e8\'d2\'c2 \'e4\'c1\'e8\'a1\'d1\'b9\'c2\'cd\'b4\'e0\'c3\'d5\'c2\'a1\'e0\'a1\'e7\'ba //\'b6\'d2\'c1\'be\'d5\'e8\'c1\'a7\'a4\'ec \'e2\'b7\'c3\'e4\'c1\'e8\'b5\'d4\'b4\par
\'ca\'c1\'b7\'ba\'e4\'c1\'e8\'b5\'e9\'cd\'a7\'cb\'d1\'a1\'a4\'e8\'d2\'cb\'d8\'e9\'b9\'b5\'e8\'cd\'e0\'b4\'d7\'cd\'b9\par
\'b6\'cd\'b9\'cb\'d8\'e9\'b9\'c5\'d2\'cd\'cd\'a1 \'e0\'ab\'bf\'e4\'c1\'e8\'c5\'a7\par
\'aa\'d3\'c3\'d0\'be\'d4\'e0\'c8\'c9 \'b5\'d4\'b4 \'e0\'c5\'d7\'cd\'a1 PX PMP \'e1\'c5\'e9\'c7\'e4\'c1\'e8\'e0\'ab\'bf\'a4\'e8\'d2\par
\'b7\'d5\'e8\'cd\'c2\'d9\'e8\'cb\'d2\'c2 \'e3\'cb\'e9 covert \'b7\'d5\'e8\'cd\'c2\'d9\'e8 \'c1\'d2\'b4\'e9\'c7\'c2\cf0\par
\f3\lang1033 ................................................................................................................................\par
\cf5\par
\par
\f1\lang1054\'b5\'c3\'c7\'a8\'ca\'cd\'ba \par
\par
//select * from kptempreceivedet where loancontract_no like '\'ca\'cd%';  //827  //937\par
///select * from kptempreceivedet where loancontract_no is not null;\par
//select * from kptempreceivedet where keepitemtype_code like 'S%';\par
//select * from lncontmaster  where loancontract_no like '\'ca\'cd%' and contract_status = 1 and payment_status = 1 ; \par
\par
\'e0\'c3\'d5\'c2\'a1\'e0\'a1\'e7\'ba \'b5\'e9\'cd\'a7\'e0\'c5\'d7\'cd\'a1 \'cb\'b9\'e9\'d2\'a8\'cd\'bb\'c3\'d0\'c1\'c7\'c5\'bc\'c5   \'e0\'c5\'d7\'cd\'a1\'c7\'d1\'b9\'bb\'c3\'d0\'c1\'c7\'c5\'bc\'c5\'e0\'c3\'d4\'e8\'c1\'ca\'d1\'ad\'ad\'d2 \'e0\'bb\'e7\'b9 \'c7\'d1\'b9 \f3\lang1033 10 /7 /2558 \f1\lang1054\'e0\'be\'c3\'d2\'d0 \'c1\'d1\'b9\'a8\'d0\'b5\'c3\'c7\'a8\'ca\'cd\'ba\'ca\'d1\'ad\'ad\'d2 \'c1\'d5\'e8\'e0\'a1\'d4\'b4\'a2\'d6\'e9\'b9\'a1\'e8\'cd\'b9 \'c7\'d1\'b9\'b7\'d5\'e8 \f3\lang1033 10 /7 /2558 \par

\pard\sa200\sl240\slmult1\cf0\f0\lang9\par
\f2\lang1054\'e0\'cd\'d2\'a4\'cd\'c1\'e0\'c1\'e9\'b9 \'cd\'cd\'a1\f0\lang9\par
\cf3\f4\fs19 w_dlg_sl_loanrequest_monthpay\par
\cf6 // \f1\lang1054\'b4\'d6\'a7\'c3\'d2\'c2\'a1\'d2\'c3\'cb\'d8\'e9\'b9\cf0\f4\lang9\par
ldc_shrperiod = \cf3 Convert\cf0 .ToDecimal(Request[\cf4 "share_periodvalue"\cf0 ].ToString());\par
\par
\f3\fs24\lang1033 4/8/2558\par
\f1\lang1054\'cb\'b9\'e9\'d2\'a8\'cd\'cd\'b9\'d8\'c1\'d1\'b5\'d4 \'e0\'c5\'a2\'ca\'d1\'ad\'ad\'d2  \'e0\'c3\'d5\'c2\'a7\'b5\'d2\'c1\'bb\'c3\'d0\'e0\'c0\'b7\'ca\'d1\'ad\'ad\'d2 \'cb\'b9\'e8\'c7\'c2\'b5\'d2\'c1 \'e0\'c5\'a2\'ca\'c1\'d2\'aa\'d4\'a1 \'e0\'c5\'a2\'a2\'cd\'a1\'d9\'e9\par
\f3\lang9 10 - 14 /8/2558\par
\cf5\f1\lang1054\'e0\'aa\'e7\'a4\'e0\'c5\'a2\'e0\'cd\'a1\'ca\'d2\'c3\f3\lang9\par
\cf0\f4\fs19 //select b.depttype_code,b.document_code, max(a.deptaccount_no) \par
//from dpdeptmaster a ,dpdepttype b  \par
//where a.depttype_code = b.depttype_code \par
//group by b.depttype_code, b.document_code\par
//order by b.depttype_code, b.document_code\par
//;\par
\par
//select * from dpdeptmaster where depttype_code = '30' order by deptaccount_no;\par
\par
//select b.loantype_code,b.document_code, max(a.loancontract_no) \par
//from lncontmaster a ,lnloantype b  \par
//where a.loantype_code = b.loantype_code \par
//group by b.loantype_code, b.document_code\par
//order by b.loantype_code, b.document_code\par
//;\par
\par
//select * from lncontmaster where loantype_code = '10' order by loancontract_no;\par
\par
\cf5\f3\fs22 // (\f1\lang1054\'e1\'a1\'e9 \f3\lang1033 pipeline \f1\lang1054\'e1\'c5\'e9\'c7\f3\lang1033 )\par
update \f1\lang1054\'e3\'cb\'e9\'cb\'b9\'e9\'d2\'a2\'cd\'a1\'d9\'e9\'c1\'cd\'a7\'e0\'cb\'e7\'b9\f3\lang1033\par
\cf0 //update lncontmaster\par
//set loanpay_code = 'KEP'\par
//;\par
//commit;\par
\par
\cf5\f1\lang1054\'b6\'e9\'d2\'e4\'c1\'e8\'c1\'d5 \'e3\'cb\'e9\'cd\'d1\'be\'b4\'e9\'c7\'c2\f3\lang1033\par
\cf0 //select * from mbmembmaster where retry_date is null and member_status = 1;\par
//select * from mbmembmaster where retry_date is null;\par
//UPDATE mbmembmaster \par
//SET retry_date = add_months(birth_date,+720) \par
// where retry_date is null\par
//;commit;\par
//\par
//select * from mbmembmaster where work_date is null  and member_status = 1;; \par
//select * from mbmembmaster where work_date is null;\par
//UPDATE mbmembmaster \par
//SET work_date =  member_date\par
// where work_date is null\par
//;commit;\par
\par
\cf5\par
\f1\lang1054\'e0\'aa\'e7\'a4\'e0\'a7\'d4\'b9\'a1\'d9\'e9\f3\lang1033\par
\cf0 select a.principal_balance,a.loancontract_no,c.principal_balance,c.loancontract_no,c.contract_status from lncontstatement a,lncontmaster c where a.seq_no = (\par
\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab select max(b.seq_no) from lncontstatement b  where\par
\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab\tab a.loancontract_no = b.loancontract_no )\par
\tab\tab\tab\tab\tab and a.loancontract_no = c.loancontract_no\par
\tab\tab\tab\tab\tab //and c.contract_status = '-1'\par
\tab\tab\tab\tab\tab and a.principal_balance > 0 ;\par
\cf5 //\f1\lang1054\'e0\'be\'d4\'e8\'c1  \f3\lang1033 (\f1\lang1054\'e1\'a1\'e9 \f3\lang1033 pipeline \f1\lang1054\'e1\'c5\'e9\'c7\f3\lang1033 )\par
\cf0 update lncontmaster\par
set int_contintincrease = 0\par
;commit;\cf5\par
// (\f1\lang1054\'e1\'a1\'e9 \f3\lang1033 pipeline \f1\lang1054\'e1\'c5\'e9\'c7\f3\lang1033 )\par
\cf0 update lncontmaster \par
set int_intsteptype = 0 \par
;commit;\par
\cf5 //\f1\lang1054\'e0\'a7\'d4\'b9\'bd\'d2\'a1 \'e0\'be\'d4\'e8\'c1  \f3\lang1033 (\f1\lang1054\'e1\'a1\'e9 \f3\lang1033 pipeline \f1\lang1054\'e1\'c5\'e9\'c7\f3\lang1033 )\par
\cf0 update dpdeptstatement \par
set FORPRNBK_FLAG = 1\par
;commit;\par
\cf5 //\f1\lang1054\'e0\'aa\'e7\'a4 \'e0\'c3\'d5\'c2\'a1\'e0\'a1\'e7\'ba \f3\lang1033\par
\cf0 //lastcalint_date is null \par
//select * from lncontmaster where contract_status = 1 and principal_balance > 0 and lastcalint_date is null order by lastcalint_date ;\par
//\f1\lang1054\'e0\'aa\'e7\'a4 \f3\lang1033 puasekeep_flag = 1 and deptmonth_status = 1\par
\cf5 // \f1\lang1054\'e0\'aa\'e7\'a4\'a1\'e8\'cd\'b9\'cb\'c3\'d7\'cd\'cb\'c5\'d1\'a7\'e0\'c3\'d5\'c2\'a1\'e0\'a1\'e9\'ba\f3\lang1033\par
\cf0 update lnloantype\par
set pxaftermthkeep_type = 1 \par
;commit;\par
\cf5 //\f1\lang1054\'e0\'bb\'d4\'b4\'bb\'c3\'d0\'e0\'c0\'b7 \'e0\'a7\'d4\'b9\'bd\'d2\'a1 \f3\lang1033\par
\cf0 update DPUCFACCTYPE set persongrp_code='01';commit;\lang9\par
\f0\fs24\par
}