using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using Saving.WcfCommon; using Saving.WcfShrlon; using Sybase.DataWindow; using System.Web.Services.Protocols; namespace Saving.Applications.shrlon { public partial class w_sheet_sl_loan_requestment_gun : PageWebSheet, WebSheet { private DwThDate tDwMain; private ShrlonClient shrlonService; private CommonClient commonService; protected String calLoanrequestAMT; protected String cancelRequest; protected String collCondition; protected String collInitP; protected String jsPostMember; protected String jsPostColl; protected String jsPostClear; protected String loadDwCollR; protected String openNew; protected String openOldDocNo; protected String genJs = ""; protected String visibleChange; protected String resendStr; protected String resetColl; protected String refreshDW; protected String refresh; protected String regenLoanClear; protected String resumLoanClear; protected String setData; protected String setDWOthClr; protected String setLoanType; protected String setOldData; protected String setOthClr; protected String showBranch; public void InitJsPostBack() { calLoanrequestAMT = WebUtil.JsPostBack(this, "calLoanrequestAMT"); cancelRequest = WebUtil.JsPostBack(this, "cancelRequest"); collCondition = WebUtil.JsPostBack(this, "collCondition"); collInitP = WebUtil.JsPostBack(this, "collInitP"); jsPostMember = WebUtil.JsPostBack(this, "jsPostMember"); jsPostColl = WebUtil.JsPostBack(this, "jsPostColl"); jsPostClear = WebUtil.JsPostBack(this, "jsPostClear"); loadDwCollR = WebUtil.JsPostBack(this, "loadDwCollR"); openNew = WebUtil.JsPostBack(this, "openNew"); openOldDocNo = WebUtil.JsPostBack(this, "openOldDocNo"); resendStr = WebUtil.JsPostBack(this, "resendStr"); refresh = WebUtil.JsPostBack(this, "refresh"); refreshDW = WebUtil.JsPostBack(this, "refreshDW"); resetColl = WebUtil.JsPostBack(this, "resetColl"); regenLoanClear = WebUtil.JsPostBack(this, "regenLoanClear"); resumLoanClear = WebUtil.JsPostBack(this, "resumLoanClear"); setData = WebUtil.JsPostBack(this, "setData"); setDWOthClr = WebUtil.JsPostBack(this, "setDWOthClr"); setLoanType = WebUtil.JsPostBack(this, "setLoanType"); setOldData = WebUtil.JsPostBack(this, "setOldData"); setOthClr = WebUtil.JsPostBack(this, "setOthClr"); visibleChange = WebUtil.JsPostBack(this, "visibleChange"); showBranch = WebUtil.JsPostBack(this, "showBranch"); tDwMain = new DwThDate(dw_main, this); tDwMain.Add("loanrequest_date", "loanrequest_tdate"); tDwMain.Add("loanrcvfix_date", "loanrcvfix_tdate"); tDwMain.Add("startkeep_date", "startkeep_tdate"); } public void WebSheetLoadBegin() { String loantype = ""; try { shrlonService = wcf.Shrlon; commonService = wcf.Common; } catch { LtServerMessage.Text = WebUtil.ErrorMessage("ติดต่อ Web Service ไม่ได้"); return; } if (IsPostBack) { this.RestoreContextDw(dw_main); this.RestoreContextDw(dw_coll); this.RestoreContextDw(dw_clear); this.RestoreContextDw(dw_keeping); this.RestoreContextDw(dw_otherclr); } if (dw_main.RowCount < 1) { dw_main.DisplayOnly = false; dw_clear.DisplayOnly = false; dw_coll.DisplayOnly = false; dw_keeping.DisplayOnly = false; dw_reqloop.DisplayOnly = false; dw_message.DisplayOnly = false; dw_otherclr.DisplayOnly = false; dw_main.InsertRow(0); LtXmlOtherlr.Text = ""; LtXmlKeeping.Text = ""; LtXmlReqloop.Text = ""; Session["requestopen"] = ""; Session["strItemchange"] = ""; try { loantype = Session["loantype"].ToString(); Session.Remove("loantype"); } catch { loantype = "28"; Session.Remove("loantype"); } //ประกาศ dddw try { DwUtil.RetrieveDDDW(dw_main, "loantype_code_1", "sl_loan_requestment.pbl", null); if (loantype == "") { dw_main.SetItemString(1, "loantype_code", "28"); //กำหนดค่าเริ่มต้น เป็นกู้ปืน } else { dw_main.SetItemString(1, "loantype_code", loantype); } DwUtil.RetrieveDDDW(dw_main, "expense_code", "sl_loan_requestment.pbl", null); dw_main.SetItemDateTime(1, "loanrequest_date", state.SsWorkDate); dw_main.SetItemDateTime(1, "loanrcvfix_date", state.SsWorkDate); dw_main.SetItemDateTime(1, "startkeep_date", state.SsWorkDate); tDwMain.Eng2ThaiAllRow(); HdColumnName.Value = "loantype_code"; JsPostMember(); DwUtil.RetrieveDDDW(dw_main, "paytoorder_desc_1", "sl_loan_requestment.pbl", null); DwUtil.RetrieveDDDW(dw_coll, "loancolltype_code", "sl_loan_requestment.pbl", null); DwUtil.RetrieveDDDW(dw_main, "loanobjective_code", "sl_loan_requestment.pbl", null); DwUtil.RetrieveDDDW(dw_otherclr, "clrothertype_code", "sl_loan_requestment.pbl", null); //DwUtil.RetrieveDDDW(dw_main, "expense_branch_1", "sl_loan_requestment.pbl", null); //ShowBranch(); } catch (Exception ex) {LtServerMessage.Text = WebUtil.ErrorMessage(ex);} } if (dw_main.RowCount > 1) { dw_main.DeleteRow(dw_main.RowCount); } } public void CheckJsPostBack(string eventArg) { if (eventArg == "jsPostMember") { JsPostMember(); }else if (eventArg == "jsPostColl") { JsPostColl(); } else if (eventArg == "resendStr") { ResendStr(); } else if (eventArg == "refreshDW") { RefreshDW(); } else if (eventArg == "setOldData") { SetOldData(); } else if (eventArg == "resetColl") { ResetColl(); } else if (eventArg == "jsPostClear") { JsPostClear(); } else if (eventArg == "showBranch") { ShowBranch(); } else if (eventArg == "loadDwCollR") { LoadDwCollR(); } else if (eventArg == "openOldDocNo") { OpenOldDocNo(); } else if (eventArg == "openNew") { OpenNew(); } else if (eventArg == "setOthClr") { SetOthClr(); } else if (eventArg == "collInitP") { CollInitP(); } else if (eventArg == "collCondition") { CollCondition(); } else if (eventArg == "cancelRequest") { CancelRequest(); } else if (eventArg == "refresh") { Refresh(); } else if (eventArg == "setLoanType") { SetLoanType(); } else if (eventArg == "setData") { SetData(); } else if (eventArg == "setDWOthClr") { SetDWOthClr(); } else if (eventArg == "regenLoanClear") { RegenLoanClear(); } else if (eventArg == "resumLoanClear") { ResumLoanClear(); } else if (eventArg == "calLoanrequestAMT") { CalLoanrequestAMT(); } } public void SaveWebSheet() { try { String dwMain_XML = dw_main.Describe("DataWindow.Data.XML"); String loancolltype_code = ""; if (dw_coll.RowCount > 0) { loancolltype_code = dw_coll.GetItemString(1, "loancolltype_code"); } String dwColl_XML = ""; if ((loancolltype_code != null)&&(loancolltype_code != "")) { dwColl_XML = dw_coll.Describe("DataWindow.Data.XML"); } String loancontract_no = ""; String dwClear_XML = ""; try { if (dw_clear.RowCount > 0) { loancontract_no = dw_clear.GetItemString(dw_clear.RowCount, "loancontract_no"); } } catch { loancontract_no = ""; } if ((loancontract_no != "")&&(loancontract_no != null)) { dwClear_XML = dw_clear.Describe("DataWindow.Data.XML"); } str_itemchange strList = new str_itemchange(); str_savereqloan strSave = new str_savereqloan(); strList = WebUtil.str_itemchange_session(this); String xmlOtherClr = ""; String xmlIntspc = ""; try { xmlOtherClr = strList.xml_otherclr; } catch { xmlOtherClr = null; } try { xmlIntspc = strList.xml_intspc; } catch { xmlIntspc = null; } strSave.xml_clear = dwClear_XML; strSave.xml_guarantee = dwColl_XML; strSave.xml_main = dwMain_XML; strSave.xml_otherclr = xmlOtherClr; strSave.xml_intspc = xmlIntspc; // ตารางดอกเบี้ย strSave.xml_reqperiod = LtXmlReqloop.Text; strSave.format_type = "CAT"; strSave.entry_id = state.SsUsername; strSave.coop_id = state.SsCoopId; String runningNo = shrlonService.LoanRightSaveReqloan(state.SsWsPass,ref strSave); //LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกข้อมูลเรียบร้อยแล้ว"); //OpenNew(); //HdMsg.Value = dw_message.GetItemString(1, "msgtext"); HdReturn.Value = "11"; // กำหนดค่าเพื่อให้เรียก OpenNew() ใหม่อีกครั้ง หลังจากแสดง DLG ใน SheetLoadComplete() } catch (Exception ex) {LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } public void WebSheetLoadEnd() { VisibleChange(); dw_main.SaveDataCache(); dw_coll.SaveDataCache(); dw_clear.SaveDataCache(); dw_keeping.SaveDataCache(); dw_reqloop.SaveDataCache(); dw_otherclr.SaveDataCache(); } private void CalLoanrequestAMT() { Decimal gunPrice = dw_main.GetItemDecimal(1, "gunprice_amt"); Decimal manageAMT = dw_main.GetItemDecimal(1, "manage_amt"); Decimal loanrequestAMT; loanrequestAMT = gunPrice + manageAMT; dw_main.SetItemDecimal(1, "loanrequest_amt", loanrequestAMT); HdColumnName.Value = "loanrequest_amt"; JsPostMember(); } private void CancelRequest() { String dwXmlMain = dw_main.Describe("DataWindow.Data.XML"); String dwXmlMessage = ""; String cancelID = "isocare"; String branch = state.SsCoopId ; try { int result = shrlonService.CancelRequest(state.SsWsPass, ref dwXmlMain, ref dwXmlMessage, cancelID, branch ); if (result <= 1) { dw_main.Reset(); dw_main.ImportString(dwXmlMain, FileSaveAsType.Xml); //DwUtil.ImportData(dwXmlMain, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } if ((dwXmlMessage != "") && (dwXmlMessage != null)) { dw_message.Reset(); dw_message.ImportString(dwXmlMessage, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } } private void CollCondition() { String dwXmlMain = dw_main.Describe("DataWindow.Data.XML"); String dwXmlColl = dw_coll.Describe("DataWindow.Data.XML"); String dwXmlMessage =""; dwXmlColl = shrlonService .CollPercCondition (state.SsWsPass , dwXmlMain , dwXmlColl , ref dwXmlMessage ); try { if ((dwXmlColl != "") && (dwXmlColl != null)) { dw_coll.Reset(); dw_coll.ImportString(dwXmlColl, FileSaveAsType.Xml); } } catch { dw_coll.Reset(); //dw_coll.InsertRow(0); } if ((dwXmlMessage != "") && (dwXmlMessage != null)) { dw_message.Reset(); dw_message.ImportString(dwXmlMessage, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } } private void CollInitP() { String dwXmlMain = dw_main.Describe("DataWindow.Data.XML"); String dwXmlColl = dw_coll.Describe("DataWindow.Data.XML"); dwXmlColl = shrlonService.CollInitPrecent(state.SsWsPass, dwXmlMain, dwXmlColl); try { if ((dwXmlColl != "") && (dwXmlColl != null)) { dw_coll.Reset(); dw_coll.ImportString(dwXmlColl, FileSaveAsType.Xml); } } catch { dw_coll.Reset(); //dw_coll.InsertRow(0); } } //private void JsPostMember() //{ // try // { // String columnName = HdColumnName.Value; // String dwMainXML = dw_main.Describe("DataWindow.Data.XML"); // String dwCollXML = dw_coll.Describe("DataWindow.Data.XML"); // String dwClearXML = dw_clear.Describe("DataWindow.Data.XML"); // String t = "28"; // t = dw_main.GetItemString(1, "loantype_code"); // String dwkeepingXML = null ; // String dwreqloopXML = null ; // str_itemchange strList = new str_itemchange(); // strList.column_name = columnName; // strList.xml_main = dwMainXML; // strList.xml_guarantee = dwCollXML; // strList.xml_clear = dwClearXML; // strList.import_flag = true; // strList.format_type = "CAT"; // int result = shrlonService.LoanRightItemChangeMain(state.SsWsPass, ref strList); // if ((columnName == "loantype_code") || (columnName == "loantype_code_1")) // { // LtXmlKeeping.Text = ""; // LtXmlOtherlr.Text = ""; // LtXmlReqloop.Text = ""; // try // { // dwkeepingXML = shrlonService.GetLastKeeping(state.SsWsPass, strList.xml_main); // if (dw_reqloop.RowCount > 0) dwreqloopXML = dw_reqloop.Describe("DataWindow.Data.XML"); // else dwreqloopXML = ""; // dwreqloopXML = shrlonService.ItemChangeReqLoop(state.SsWsPass, strList.xml_main, dwreqloopXML); // Session["xml_reqloop"] = dwreqloopXML; // } // catch(Exception ex) // {LtServerMessage.Text = WebUtil.ErrorMessage(ex);} // } // else if (columnName == "member_no") { // LtXmlKeeping.Text = ""; // LtXmlOtherlr.Text = ""; // LtXmlReqloop.Text = ""; // try // { // dwkeepingXML = shrlonService.GetLastKeeping(state.SsWsPass, strList.xml_main); // dwreqloopXML = shrlonService.ReqLoopOpen(state.SsWsPass, strList.xml_main); // dw_reqloop.Reset(); // if (dwreqloopXML.Trim() != "") dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); // dwreqloopXML = shrlonService.ItemChangeReqLoop(state.SsWsPass, strList.xml_main, dwreqloopXML); // if ((dwkeepingXML != "") && (dwkeepingXML != null)) // { // dw_keeping.Reset(); // dw_keeping.ImportString(dwkeepingXML, FileSaveAsType.Xml); // } // if ((dwreqloopXML != "")&&(dwreqloopXML != null)) { // dw_reqloop.Reset(); // dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); // } // } // catch (Exception ex) // { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } // } // else if (columnName == "loanrequest_amt") // { // if (dw_reqloop.RowCount > 0) dwreqloopXML = dw_reqloop.Describe("DataWindow.Data.XML"); // else dwreqloopXML = ""; // strList.xml_main = shrlonService.ReCalFee(state.SsWsPass, strList.xml_main); // dwreqloopXML = shrlonService.ItemChangeReqLoop(state.SsWsPass, strList.xml_main, dwreqloopXML); // if ((dwreqloopXML != "") && (dwreqloopXML != null)) // { // dw_reqloop.Reset(); // dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); // } // dw_main.Reset(); // dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); // //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); // if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); // } // LtXmlKeeping.Text = dwkeepingXML; // LtXmlReqloop.Text = dwreqloopXML; // Session["strItemchange"] = strList; // if ((strList.xml_message != null)&&(strList.xml_message !="")) // { // dw_message.Reset(); // dw_message.ImportString(strList.xml_message, FileSaveAsType.Xml); // HdMsg.Value = dw_message.GetItemString(1, "msgtext"); // } // if ((strList.column_name == "expense_code")) // { // LtServerMessage.Text = strList.column_data; // } // if (result == 8) // { // HdReturn.Value = result.ToString(); // HdColumnName.Value = strList.column_name; // DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); // if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); // HdMemberNo.Value = dw_main.GetItemString(1, "member_no"); // } // else { // dw_main.Reset(); // dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); // //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); // if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); // } // //dw_main.Reset(); // //dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); // tDwMain.Eng2ThaiAllRow(); // if (columnName == "expense_code") // { // string expendCode = ""; // try // { // expendCode = dw_main.GetItemString(1, "expense_code"); // } // catch { } // if (expendCode == "TRN") // { // //โอนภายใน เรียกเลขที่บัญชีของสมาชิก // HdMemberNo.Value = dw_main.GetItemString(1, "member_no"); // HdReturn.Value = "15"; // กำหนดค่าเพื่อให้เรียก DLG เลือกบัญชีเงินฝาก ใน SheetLoadComplete() // } // } // //if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); // try // { // dw_otherclr.Reset(); // dw_otherclr.ImportString(LtXmlOtherlr .Text , FileSaveAsType.Xml); // } // catch { dw_otherclr.Reset(); } // try // { // dw_coll.Reset(); // dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); // } // catch { dw_coll.Reset(); // } // try // { // dw_clear.Reset(); // dw_clear.ImportString(strList.xml_clear, FileSaveAsType.Xml); // } // catch { dw_clear.Reset(); } // } // catch (Exception ex) // { // LtServerMessage .Text = WebUtil.ErrorMessage(ex); // HdReturn.Value = "12"; // กำหนดค่าเพื่อให้เรียก OpenNew() ใหม่อีกครั้ง หลังจากแสดง DLG ใน SheetLoadComplete() // } //} private void JsPostMember() { try { String columnName = HdColumnName.Value; String dwMainXML = dw_main.Describe("DataWindow.Data.XML"); String dwCollXML = dw_coll.Describe("DataWindow.Data.XML"); String dwClearXML = dw_clear.Describe("DataWindow.Data.XML"); String t = "10"; t = dw_main.GetItemString(1, "loantype_code"); String dwkeepingXML = null; String dwreqloopXML = null; str_itemchange strList = new str_itemchange(); strList.column_name = columnName; strList.xml_main = dwMainXML; strList.xml_guarantee = dwCollXML; strList.xml_clear = dwClearXML; strList.import_flag = true; strList.format_type = "CAT"; int result = shrlonService.LoanRightItemChangeMain(state.SsWsPass, ref strList); //Boom ส่วนเรียกเก็บ Keeping try { dwkeepingXML = string.IsNullOrEmpty(strList.xml_keep) ? "" : strList.xml_keep; if ((dwkeepingXML != "") && (dwkeepingXML != null)) { dw_keeping.Reset(); dw_keeping.ImportString(dwkeepingXML, FileSaveAsType.Xml); } } catch { dw_keeping.Reset(); } ////Boom ส่วน ฉ.โอน Reqloop กู้ปืน ไม่ได้ใช้ ReqLoop //try //{ // dwreqloopXML = string.IsNullOrEmpty(strList.xml_reqloop) ? "" : strList.xml_reqloop; // Session["xml_reqloop"] = dwreqloopXML; // dw_reqloop.Reset(); // if (dwreqloopXML.Trim() != "") // { // dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); // } // else { dw_reqloop.InsertRow(0); } //} //catch { dw_reqloop.Reset(); } LtXmlKeeping.Text = dwkeepingXML; LtXmlReqloop.Text = dwreqloopXML; Session["strItemchange"] = strList; if ((strList.xml_message != null) && (strList.xml_message != "")) { dw_message.Reset(); dw_message.ImportString(strList.xml_message, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } //Boom เอาข้อมูลส่วนหลัก แสดงทางหน้าจอ //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); dw_main.Reset(); dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); // ShowBranch(); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); //Boom ตรวจสอบขั้นตอนว่าจะต้องดำเนินการต่อไปหรือไม่ if (result == 8) { HdReturn.Value = result.ToString(); HdColumnName.Value = strList.column_name; HdMemberNo.Value = dw_main.GetItemString(1, "member_no"); } if (columnName == "expense_code") { string expendCode = ""; try { expendCode = dw_main.GetItemString(1, "expense_code"); } catch { } if (expendCode == "TRN") { //โอนภายใน เรียกเลขที่บัญชีของสมาชิก HdMemberNo.Value = dw_main.GetItemString(1, "member_no"); HdReturn.Value = "15"; // กำหนดค่าเพื่อให้เรียก DLG เลือกบัญชีเงินฝาก ใน SheetLoadComplete() } else if (expendCode == "CBT") { ShowBranch(); } } tDwMain.Eng2ThaiAllRow(); //if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); try { dw_otherclr.Reset(); dw_otherclr.ImportString(LtXmlOtherlr.Text, FileSaveAsType.Xml); } catch { dw_otherclr.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_clear.Reset(); dw_clear.ImportString(strList.xml_clear, FileSaveAsType.Xml); } catch { dw_clear.Reset(); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); HdReturn.Value = "12"; // กำหนดค่าเพื่อให้เรียก OpenNew() ใหม่อีกครั้ง หลังจากแสดง DLG ใน SheetLoadComplete() } } private void JsPostColl() { try { String strXmlKeep = LtXmlKeeping.Text; String strXmlReqloop = LtXmlReqloop.Text; String columnName = HdColumnName.Value; String dwMainXML = dw_main.Describe("DataWindow.Data.XML"); String dwCollXML = dw_coll.Describe("DataWindow.Data.XML"); String dwClearXML = dw_clear.Describe("DataWindow.Data.XML"); String t = dw_main.GetItemString(1, "loantype_code"); str_itemchange strList = new str_itemchange(); // ตรวจสอบว่า HdRowNumber มีค่าหรือไม่ ถ้าไม่มี ไม่ต้องทำอะไร if (HdRowNumber.Value.ToString() != "") { int rowNumber = Convert.ToInt32(HdRowNumber.Value.ToString()); if ((columnName == "checkmancollperiod") || (columnName == "setcolldetail")) { dw_coll.SetItemString(rowNumber, "ref_collno", HdMemberNo.Value); dwCollXML = dw_coll.Describe("DataWindow.Data.XML"); } String refCollNo = ""; try { refCollNo = dw_coll.GetItemString(rowNumber, "ref_collno"); HdMemberNo.Value = refCollNo; } catch { refCollNo = ""; } strList.column_name = columnName; strList.xml_main = dwMainXML; strList.xml_guarantee = dwCollXML; strList.xml_clear = dwClearXML; strList.import_flag = true; strList.format_type = "CAT"; strList.column_data = dw_coll.GetItemString(rowNumber, "loancolltype_code") + refCollNo; // เรียก service สำหรับการเปลี่ยนแปลงค่า ของ DW_coll int result = shrlonService.LoanRightItemChangeColl(state.SsWsPass, ref strList); Session["strItemchange"] = strList; if ((strList.xml_message != null) && (strList.xml_message != "")) { //dw_message.Reset(); //dw_message.ImportString(strList.xml_message, FileSaveAsType.Xml); DwUtil.ImportData(strList.xml_message, dw_message, null, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); HdMsgWarning.Value = dw_message.GetItemString(1, "msgicon"); } if (result == 8) { HdReturn.Value = result.ToString(); HdColumnName.Value = strList.column_name; } try { dw_otherclr.Reset(); dw_otherclr.ImportString(LtXmlOtherlr.Text, FileSaveAsType.Xml); } catch { dw_otherclr.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_keeping.Reset(); dw_keeping.ImportString(strXmlKeep, FileSaveAsType.Xml); } catch { dw_keeping.Reset(); //dw_keeping.InsertRow(0); } try { dw_reqloop.Reset(); dw_reqloop.ImportString(strXmlReqloop, FileSaveAsType.Xml); } catch { dw_reqloop.Reset(); } } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void JsPostClear() { try { String strXmlKeep = LtXmlKeeping.Text; String strXmlReqloop = LtXmlReqloop.Text; String columnName = HdColumnName.Value; String dwMainXML = dw_main.Describe("DataWindow.Data.XML"); String dwCollXML = dw_coll.Describe("DataWindow.Data.XML"); String dwClearXML = dw_clear.Describe("DataWindow.Data.XML"); String t = dw_main.GetItemString(1, "loantype_code"); str_itemchange strList = new str_itemchange(); strList.column_name = columnName; strList.xml_main = dwMainXML; strList.xml_guarantee = dwCollXML; strList.xml_clear = dwClearXML; strList.import_flag = true; strList.format_type = "CAT"; int result = shrlonService.LoanRightItemChangeClear(state.SsWsPass, ref strList); Session["strItemchange"] = strList; if ((strList.xml_message != null) && (strList.xml_message != "")) { dw_message.Reset(); dw_message.ImportString(strList.xml_message, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } if (result == 8) { HdReturn.Value = result.ToString(); HdColumnName.Value = strList.column_name; } dw_main.Reset(); dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); try { dw_coll.Reset(); dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_keeping.Reset(); dw_keeping.ImportString(strXmlKeep, FileSaveAsType.Xml); } catch { dw_keeping.Reset(); //dw_keeping.InsertRow(0); } try { dw_reqloop.Reset(); dw_reqloop.ImportString(strXmlReqloop, FileSaveAsType.Xml); } catch { dw_reqloop.Reset(); } } catch (Exception ex) {LtServerMessage.Text = WebUtil.ErrorMessage(ex);} } private void LoadDwCollR() { try { str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); dw_coll.Reset(); dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); } catch(Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void OpenNew() { dw_clear.Reset(); dw_coll.Reset(); dw_keeping.Reset(); dw_main.Reset(); dw_message.Reset(); dw_reqloop.Reset(); dw_main.InsertRow(0); dw_message.InsertRow(0); dw_reqloop.InsertRow(0); dw_main.DisplayOnly = false; dw_clear.DisplayOnly = false; dw_coll.DisplayOnly = false; dw_keeping.DisplayOnly = false; dw_reqloop.DisplayOnly = false; dw_message.DisplayOnly = false; //ประกาศ dddw try { //DataWindowChild dwMainLnType = dw_main.GetChild("loantype_code_1"); //String StrXml = commonService.GetDDDWXml(state.SsWsPass, "dddw_sl_loantype"); //dwMainLnType.ImportString(StrXml, FileSaveAsType.Xml); DwUtil.RetrieveDDDW(dw_main, "loantype_code_1", "sl_loan_requestment.pbl", null); dw_main.SetItemString(1, "loantype_code", "28"); //กำหนดค่าเริ่มต้น เป็นกู้ปืน //DataWindowChild dwExpenseCode = dw_main.GetChild("expense_code"); //String StrXMLEC = commonService.GetDDDWXml(state.SsWsPass, "dddw_sl_loanrequest_ucfmoneytype"); //dwExpenseCode.ImportString(StrXMLEC, FileSaveAsType.Xml); DwUtil.RetrieveDDDW(dw_main, "expense_code", "sl_loan_requestment.pbl", null); dw_main.SetItemDateTime(1, "loanrequest_date", state.SsWorkDate); dw_main.SetItemDateTime(1, "loanrcvfix_date", state.SsWorkDate); dw_main.SetItemDateTime(1, "startkeep_date", state.SsWorkDate); tDwMain.Eng2ThaiAllRow(); HdColumnName.Value = "loantype_code"; JsPostMember(); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } if (dw_main.RowCount > 1) { dw_main.DeleteRow(dw_main.RowCount); } dw_reqloop.Visible = false; dw_message.Visible = false; } private void OpenOldDocNo() { str_itemchange strList = new str_itemchange(); str_requestopen strRequestOpen = new str_requestopen(); strList = WebUtil.str_itemchange_session(this); string docno = dw_main.GetItemString(1, "loanrequest_docno"); String strXmlKeep = LtXmlKeeping.Text; String strXmlReqloop = LtXmlReqloop.Text; String dwkeepingXML = null; String dwreqloopXML = null; strRequestOpen.request_no = docno; strRequestOpen.format_type = "CAT"; strRequestOpen.xml_main = dw_main.Describe("DataWindow.Data.XML"); strRequestOpen.xml_clear = ""; strRequestOpen.xml_guarantee = ""; strRequestOpen.xml_insurance = ""; strRequestOpen.xml_intspc = ""; strRequestOpen.xml_otherclr = ""; try { strRequestOpen = shrlonService.LoanRequestOpen(state.SsWsPass, strRequestOpen); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } //นำข้อมูลเก็บไว้ใน DataWindow dw_main.Reset(); dw_main.ImportString(strRequestOpen.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strRequestOpen.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); string expendBank = ""; try { expendBank = dw_main.GetItemString(1, "expense_bank"); } catch { expendBank = ""; } //ตรวจสอบ ธนาคารว่ามีหรือไม่ if (expendBank != "") { // เรียก Method ShowBranch() สำหรับแสดงสาขาธนาคาร ShowBranch(); } tDwMain.Eng2ThaiAllRow(); try { dw_clear.Reset(); dw_clear.ImportString(strRequestOpen.xml_clear, FileSaveAsType.Xml); }catch { dw_clear.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(strRequestOpen.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_otherclr.Reset(); dw_otherclr.ImportString(LtXmlOtherlr.Text, FileSaveAsType.Xml); } catch { dw_otherclr.Reset(); } try { dwkeepingXML = shrlonService.GetLastKeeping(state.SsWsPass, strRequestOpen.xml_main); dwreqloopXML = shrlonService.ReqLoopOpen(state.SsWsPass, strRequestOpen.xml_main); dw_reqloop.Reset(); if (dwreqloopXML.Trim() != "") dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); dwreqloopXML = shrlonService.ItemChangeReqLoop(state.SsWsPass, strRequestOpen.xml_main, dwreqloopXML); if ((dwkeepingXML != "") && (dwkeepingXML != null)) { dw_keeping.Reset(); dw_keeping.ImportString(dwkeepingXML, FileSaveAsType.Xml); } if ((dwreqloopXML != "") && (dwreqloopXML != null)) { dw_reqloop.Reset(); dw_reqloop.ImportString(dwreqloopXML, FileSaveAsType.Xml); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } strList.xml_otherclr = strRequestOpen.xml_otherclr; strList.xml_main = strRequestOpen.xml_main; strList.xml_guarantee = strRequestOpen.xml_guarantee; strList.xml_clear = strRequestOpen.xml_clear; strList.xml_insurance = strRequestOpen.xml_insurance; strList.xml_message = strRequestOpen.xml_message; Session["strItemchange"] = strList; LtXmlOtherlr.Text = strRequestOpen.xml_otherclr; Decimal loanrequestStatus = dw_main.GetItemDecimal(1, "loanrequest_status"); if ((loanrequestStatus != 8) && (loanrequestStatus != 81) && (loanrequestStatus != 11)) { dw_main.DisplayOnly = true; dw_clear.DisplayOnly = true; dw_coll.DisplayOnly = true; dw_keeping.DisplayOnly = true; dw_reqloop.DisplayOnly = true; dw_message.DisplayOnly = true; dw_otherclr.DisplayOnly = true; } else { dw_main.DisplayOnly = false; dw_clear.DisplayOnly = false; dw_coll.DisplayOnly = false; dw_keeping.DisplayOnly = false; dw_reqloop.DisplayOnly = false; dw_message.DisplayOnly = false; dw_otherclr.DisplayOnly = false; } } private void ResendStr() { try { genJs = ""; str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); String strXmlKeep = LtXmlKeeping.Text ; String strXmlReqloop = LtXmlReqloop .Text ; strList.xml_message = null; int result = shrlonService.LoanRightItemChangeMain(state.SsWsPass, ref strList); Session["strItemchange"] = strList; if ((strList.xml_message != null)&&(strList.xml_message != "")) { dw_message.Reset(); dw_message.ImportString(strList.xml_message, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } HdReturn.Value = result.ToString(); HdColumnName.Value = strList.column_name; dw_main.Reset(); dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); tDwMain.Eng2ThaiAllRow(); try { dw_otherclr.Reset(); dw_otherclr.ImportString(LtXmlOtherlr.Text, FileSaveAsType.Xml); } catch { dw_otherclr.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(strList.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_clear.Reset(); dw_clear.ImportString(strList.xml_clear, FileSaveAsType.Xml); } catch { dw_clear.Reset(); } try { dw_keeping.Reset(); dw_keeping.ImportString(strXmlKeep, FileSaveAsType.Xml); } catch { dw_keeping.Reset(); } try { dw_reqloop.Reset(); dw_reqloop.ImportString(strXmlReqloop, FileSaveAsType.Xml); } catch { dw_reqloop.Reset(); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void Refresh() { } private void RefreshDW() { try { //ต้องปรับให้ Reset เฉพาะแถวที่เปลี่ยนแปลงเท่านั้น dw_main.Reset(); dw_main.InsertRow(0); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void ResetColl() { try { dw_coll.Reset(); //dw_coll.InsertRow(0); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void RegenLoanClear() { String xmlMain = ""; String xmlColl = ""; String xmlClear = ""; String xmlMessage = ""; xmlMain = dw_main.Describe("DataWindow.Data.XML"); if (dw_coll.RowCount == 0) { xmlColl = null; } else { xmlColl = dw_coll.Describe("DataWindow.Data.XML"); } if (dw_clear.RowCount == 0) { xmlClear = null; } else { xmlClear = dw_clear.Describe("DataWindow.Data.XML"); } int result = shrlonService.RegenLoanClear(state.SsWsPass, ref xmlMain, ref xmlClear, ref xmlColl, ref xmlMessage); if (result == 1) { try { dw_main.Reset(); dw_main.ImportString(xmlMain, FileSaveAsType.Xml); //if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); //DwUtil.ImportData(xmlMain, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); } catch { dw_main.Reset(); } try { dw_clear.Reset(); dw_clear.ImportString(xmlClear, FileSaveAsType.Xml); } catch { dw_clear.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(xmlColl, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } } if ((xmlMessage != null) && (xmlMessage != "")) { dw_message.Reset(); dw_message.ImportString(xmlMessage, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } } private void ResumLoanClear() { //Session["xmlloandetail"] String xmlMain = ""; String xmlColl = ""; String xmlClear = ""; String xmlLoanDetail = ""; String xmlMessage = ""; xmlMain = dw_main.Describe("DataWindow.Data.XML"); xmlLoanDetail = Session["xmlloandetail"].ToString (); if (dw_coll.RowCount == 0) {xmlColl = null; } else { xmlColl = dw_coll.Describe("DataWindow.Data.XML"); } if (dw_clear.RowCount == 0) { xmlClear = null;} else { xmlClear = dw_clear.Describe("DataWindow.Data.XML");} int result = shrlonService.ResumLoanClear(state.SsWsPass, ref xmlMain, ref xmlClear, ref xmlColl, xmlLoanDetail, ref xmlMessage); if (result == 1) { try { dw_main.Reset(); dw_main.ImportString(xmlMain, FileSaveAsType.Xml); //if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); //DwUtil.ImportData(xmlMain, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); } catch { dw_main.Reset(); dw_main.InsertRow(0); } try { dw_clear.Reset(); dw_clear.ImportString(xmlClear, FileSaveAsType.Xml); } catch { dw_clear.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(xmlColl, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } LtXmlLoanDetail.Text = xmlLoanDetail; } if ((xmlMessage != null) && (xmlMessage != "")) { dw_message.Reset(); dw_message.ImportString(xmlMessage, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); } } private void SetData() { str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); if (dw_clear.RowCount == 0) { strList.xml_clear = null; } else { strList.xml_clear = dw_clear.Describe("DataWindow.Data.XML"); } if (dw_coll.RowCount == 0) { strList.xml_guarantee = null; } else { strList.xml_guarantee = dw_coll.Describe("DataWindow.Data.XML"); } Session["strItemchange"] = strList; } private void SetDWOthClr() { //SetDWOthClr ใช้เมื่อมีการเปลี่ยนแปลงค่าต่างๆ ใน dw_otherclr รายการหักอื่นๆ str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); strList.xml_main = dw_main.Describe("DataWindow.Data.XML"); if (dw_otherclr.RowCount == 0) { strList.xml_otherclr = null; } else { strList.xml_otherclr = dw_otherclr.Describe("DataWindow.Data.XML"); } String xmlMain = ""; xmlMain = shrlonService.SetSumOtherClr(state.SsWsPass, strList.xml_main, strList.xml_otherclr); try { dw_main.Reset(); dw_main.ImportString(xmlMain, FileSaveAsType.Xml); //DwUtil.ImportData(xmlMain, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } LtXmlOtherlr.Text = strList.xml_otherclr; Session["strItemchange"] = strList; } private void SetLoanType() { Session["loantype"] = dw_main.GetItemString(1, "loantype_code"); HdReturn.Value = "9"; } private void SetOldData() { str_itemchange strList = new str_itemchange(); str_requestopen strRequestOpen = new str_requestopen(); strList = WebUtil.str_itemchange_session(this); string docno = dw_main.GetItemString(1, "loanrequest_docno"); String strXmlKeep = LtXmlKeeping.Text; String strXmlReqloop = LtXmlReqloop.Text; strRequestOpen.request_no = docno; strRequestOpen.format_type = "CAT"; strRequestOpen.xml_main = strList.xml_main; strRequestOpen.xml_clear = strList.xml_clear; strRequestOpen.xml_guarantee = strList.xml_guarantee; strRequestOpen.xml_insurance = strList.xml_insurance; strRequestOpen.xml_otherclr = strList.xml_otherclr; //strRequestOpen.xml_reqperiod = ""; //สามัญ พิเศษ ไม่ต้องใส่ค่าอะไร strRequestOpen.xml_intspc = ""; try { strRequestOpen = shrlonService.LoanRequestOpen(state.SsWsPass, strRequestOpen); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } //นำข้อมูลเก็บไว้ใน DataWindow dw_main.Reset(); dw_main.ImportString(strRequestOpen.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strRequestOpen.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); string expendBank = ""; try { expendBank = dw_main.GetItemString(1, "expense_bank"); } catch { expendBank = ""; } //ตรวจสอบ ธนาคารว่ามีหรือไม่ if (expendBank != "") { // เรียก Method ShowBranch() สำหรับแสดงสาขาธนาคาร ShowBranch(); } tDwMain.Eng2ThaiAllRow(); try { dw_clear.Reset(); dw_clear.ImportString(strRequestOpen.xml_clear, FileSaveAsType.Xml); } catch { dw_clear.Reset(); } try { dw_otherclr.Reset(); dw_otherclr.ImportString(strRequestOpen.xml_otherclr, FileSaveAsType.Xml); } catch { dw_otherclr.Reset(); } try { dw_coll.Reset(); dw_coll.ImportString(strRequestOpen.xml_guarantee, FileSaveAsType.Xml); } catch { dw_coll.Reset(); } try { dw_keeping.Reset(); dw_keeping.ImportString(strXmlKeep, FileSaveAsType.Xml); } catch { dw_keeping.Reset(); //dw_keeping.InsertRow(0); } try { dw_reqloop.Reset(); dw_reqloop.ImportString(strXmlReqloop, FileSaveAsType.Xml); } catch { dw_reqloop.Reset(); } Decimal loanrequestStatus = dw_main.GetItemDecimal(1, "loanrequest_status"); if ((loanrequestStatus != 8) && (loanrequestStatus != 81) && (loanrequestStatus != 11)) { dw_main.DisplayOnly = true; dw_clear.DisplayOnly = true; dw_coll.DisplayOnly = true; dw_keeping.DisplayOnly = true; dw_reqloop.DisplayOnly = true; dw_message.DisplayOnly = true; dw_otherclr.DisplayOnly = true; } else { dw_main.DisplayOnly = false; dw_clear.DisplayOnly = false; dw_coll.DisplayOnly = false; dw_keeping.DisplayOnly = false; dw_reqloop.DisplayOnly = false; dw_message.DisplayOnly = false; dw_otherclr.DisplayOnly = false; } if ((strRequestOpen.xml_message != null) && (strRequestOpen.xml_message != "")) { dw_message.Reset(); dw_message.ImportString(strRequestOpen.xml_message, FileSaveAsType.Xml); HdMsg.Value = dw_message.GetItemString(1, "msgtext"); HdReturn.Value = "10"; // กำหนดค่าเพื่อให้เรียก OpenNew() ใหม่อีกครั้ง หลังจากแสดง DLG ใน SheetLoadComplete() } } private void SetOthClr() { //SetOthClr จะถูกเรียกใช้เมื่อปิดหน้าจอ pop up w_dlg_sl_loanrequest_otherclr.aspx str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); strList.xml_main = dw_main.Describe("DataWindow.Data.XML"); strList.xml_main = shrlonService.SetSumOtherClr(state.SsWsPass, strList.xml_main, strList.xml_otherclr); if ((strList.xml_otherclr != null) && (strList.xml_otherclr != "")) { dw_otherclr.Reset(); dw_otherclr.ImportString(LtXmlOtherlr.Text, FileSaveAsType.Xml); } else { dw_otherclr.Reset(); } dw_main.Reset(); dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); LtXmlOtherlr.Text = strList.xml_otherclr; Session["strItemchange"] = strList; } private void ShowBranch() { try { //str_itemchange strList = new str_itemchange(); DwUtil.RetrieveDDDW(dw_main, "expense_branch_1", "sl_loan_requestment.pbl", null); //int result = shrlonService.LoanRightItemChangeMain(state.SsWsPass, ref strList); String bankCode; try { bankCode = dw_main.GetItemString(1, "expense_bank").Trim(); } catch { bankCode = ""; } //if (bankCode == "02") //{ // LtServerMessage.Text = WebUtil.ErrorMessage("ไม่สามารถแสดงสาขาของธนาคารกรุงเทพได้ กรุณาเลือกธนาคารอื่นแทน"); // return; //} // String sql = @" // SELECT // CMUCFBANKBRANCH.BRANCH_ID, // CMUCFBANKBRANCH.BRANCH_NAME // FROM CMUCFBANKBRANCH where CMUCFBANKBRANCH.BANK_CODE = '" + bankCode + "'"; // DataWindowChild dwExpenseBranch = dw_main.GetChild("expense_branch_1"); // DwUtil.ImportData(sql, dwExpenseBranch, null); DataWindowChild dwExpenseBranch = dw_main.GetChild("expense_branch_1"); // DwUtil.ImportData(sql, dwExpenseBranch, null); dwExpenseBranch.SetFilter("CMUCFBANKBRANCH.BANK_CODE='" + bankCode + "'"); dwExpenseBranch.Filter(); } catch (Exception ex) {LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } private void VisibleChange() { str_itemchange strList = new str_itemchange(); strList = WebUtil.str_itemchange_session(this); string expendCode = ""; try { expendCode = dw_main.GetItemString(1, "expense_code"); } catch { } if (expendCode == null || expendCode == "") return; if ((expendCode == "CHQ") || (expendCode == "TRN") || (expendCode == "CBT") || (expendCode == "DRF") || (expendCode == "TBK")) { dw_main.Modify("t_32.visible =0"); dw_main.Modify("postagefee_amt.visible =0"); dw_main.Modify("t_50.visible =0"); dw_main.Modify("tax_amt.visible =0"); dw_main.Modify("t_31.visible =0"); dw_main.Modify("emsfee_amt.visible =0"); dw_main.Modify("t_52.visible =0"); dw_main.Modify("onlinefee_amt.visible =0"); dw_main.Modify("expense_accid_t.visible =0"); dw_main.Modify("compute_12.visible =0"); dw_main.Modify("t_44.visible =0"); dw_main.Modify("compute_11.visible =0"); dw_main.Modify("t_47.visible =0"); dw_main.Modify("postagesrv_amt.visible =0"); dw_main.Modify("t_53.visible =0"); dw_main.Modify("paytoorder_desc.visible =0"); dw_main.Modify("paytoorder_desc_1.visible =0"); //ฝั่งธนาคาร dw_main.Modify("t_20.visible =1"); dw_main.Modify("expense_bank.visible =1"); dw_main.Modify("t_30.visible =1"); dw_main.Modify("expense_bank_1.visible =1"); dw_main.Modify("t_39.visible =1"); dw_main.Modify("expense_branch.visible =1"); dw_main.Modify("t_27.visible =1"); dw_main.Modify("expense_branch_1.visible =1"); dw_main.Modify("t_38.visible =1"); dw_main.Modify("expense_accid.visible =1"); dw_main.Modify("t_40.visible =1"); dw_main.Modify("bankfee_amt.visible =1"); dw_main.Modify("t_45.visible =1"); dw_main.Modify("banksrv_amt.visible =1"); dw_main.Modify("t_41.visible =1"); dw_main.Modify("compute_10.visible =1"); try { //DataWindowChild dwExpenseBank = dw_main.GetChild("expense_bank_1"); //String StrXmlEB = commonService.GetDDDWXml(state.SsWsPass, "dddw_cm_ucfbank"); //DwUtil.ImportData(StrXmlEB, dwExpenseBank, null, FileSaveAsType.Xml); DwUtil.RetrieveDDDW(dw_main, "expense_bank_1", "sl_loan_requestment.pbl", null); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if ((expendCode == "CSH") || (expendCode == "BEX") || (expendCode == "MON") || (expendCode == "MOS") || (expendCode == "MOO")) { dw_main.Modify("t_32.visible =1"); dw_main.Modify("postagefee_amt.visible =1"); dw_main.Modify("t_50.visible =1"); dw_main.Modify("tax_amt.visible =1"); dw_main.Modify("t_31.visible =1"); dw_main.Modify("emsfee_amt.visible =1"); dw_main.Modify("t_52.visible =1"); dw_main.Modify("onlinefee_amt.visible =1"); dw_main.Modify("expense_accid_t.visible =1"); dw_main.Modify("compute_12.visible =1"); dw_main.Modify("t_44.visible =1"); dw_main.Modify("compute_11.visible =1"); dw_main.Modify("t_47.visible =1"); dw_main.Modify("postagesrv_amt.visible =1"); if (expendCode == "CSH") { dw_main.Modify("t_53.visible =0"); dw_main.Modify("paytoorder_desc.visible =0"); dw_main.Modify("paytoorder_desc_1.visible =0"); } else { dw_main.Modify("t_53.visible =1"); dw_main.Modify("paytoorder_desc.visible =1"); dw_main.Modify("paytoorder_desc_1.visible =1"); } //ฝั่งธนาคาร dw_main.Modify("t_20.visible =0"); dw_main.Modify("expense_bank.visible =0"); dw_main.Modify("t_30.visible =0"); dw_main.Modify("expense_bank_1.visible =0"); dw_main.Modify("t_39.visible =0"); dw_main.Modify("expense_branch.visible =0"); dw_main.Modify("t_27.visible =0"); dw_main.Modify("expense_branch_1.visible =0"); dw_main.Modify("t_38.visible =0"); dw_main.Modify("expense_accid.visible =0"); dw_main.Modify("t_40.visible =0"); dw_main.Modify("bankfee_amt.visible =0"); dw_main.Modify("t_45.visible =0"); dw_main.Modify("banksrv_amt.visible =0"); dw_main.Modify("t_41.visible =0"); dw_main.Modify("compute_10.visible =0"); if (expendCode == "CSH") { try { dw_main.Modify("postagefee_amt.Edit.DisplayOnly=Yes"); dw_main.Modify("tax_amt.Edit.DisplayOnly=Yes"); dw_main.Modify("emsfee_amt.Edit.DisplayOnly=Yes"); dw_main.Modify("onlinefee_amt.Edit.DisplayOnly=Yes"); dw_main.Modify("postagesrv_amt.Edit.DisplayOnly=Yes"); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else { try { dw_main.Modify("postagefee_amt.Edit.DisplayOnly=No"); dw_main.Modify("tax_amt.Edit.DisplayOnly=No"); dw_main.Modify("emsfee_amt.Edit.DisplayOnly=No"); dw_main.Modify("onlinefee_amt.Edit.DisplayOnly=No"); dw_main.Modify("postagesrv_amt.Edit.DisplayOnly=No"); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } } if ((expendCode == "MON") || (expendCode == "MOS") || (expendCode == "MOO")) { if ((strList.xml_main == null) || (strList.xml_main == "")) { strList.xml_main = dw_main.Describe("DataWindow.Data.XML"); strList.xml_main = shrlonService.ReCalFee(state.SsWsPass, strList.xml_main); dw_main.Reset(); dw_main.ImportString(strList.xml_main, FileSaveAsType.Xml); //DwUtil.ImportData(strList.xml_main, dw_main, tDwMain, FileSaveAsType.Xml); if (dw_main.RowCount > 1) dw_main.DeleteRow(dw_main.RowCount); } } } } }