using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; //using CoreSavingLibrary.WcfNCommon; //using CoreSavingLibrary.WcfDeposit; using CoreSavingLibrary.WcfNCommon; using CoreSavingLibrary.WcfNDeposit; using System.Web.Services.Protocols; using DataLibrary; using CoreSavingLibrary; using System.Collections.Generic; using System.Globalization; namespace Saving.Applications.ap_deposit.dlg { public partial class w_dlg_dp_printbook : PageWebDialog, WebDialog { //private DepositClient dep; private n_depositClient ndept; private String deptAccountNo; protected String postPrintBook; protected String postPrintBookOld; protected String printbookCard; protected String printbookHeadCard; protected String postPrintSlips; protected String JSpostCover; protected String JSPrintOut; protected String jsPrintBook2; protected String jsrePrintBookCard; #region WebDialog Members public void InitJsPostBack() { postPrintBook = WebUtil.JsPostBack(this, "postPrintBook"); postPrintBookOld = WebUtil.JsPostBack(this, "postPrintBookOld"); printbookCard = WebUtil.JsPostBack(this, "printbookCard"); printbookHeadCard = WebUtil.JsPostBack(this, "printbookHeadCard"); postPrintSlips = WebUtil.JsPostBack(this, "postPrintSlips"); JSpostCover = WebUtil.JsPostBack(this, "JSpostCover"); JSPrintOut = WebUtil.JsPostBack(this, "JSPrintOut"); jsPrintBook2 = WebUtil.JsPostBack(this, "jsPrintBook2"); jsrePrintBookCard = WebUtil.JsPostBack(this, "jsrePrintBookCard"); } public void WebDialogLoadBegin() { ndept = wcf.NDeposit; this.ConnectSQLCA(); DwNewBook.SetTransaction(sqlca); DwStm.SetTransaction(sqlca); if (!IsPostBack) { HdIsPostBack.Value = "false"; if (state.SsCoopId != "000401")//ตรอน { // tss1.Style["display"] = "none"; Button3.Style["display"] = "none"; } if (state.SsCoopId == "000101" || state.SsCoopId == "000401")//ตรอน { // tss1.Style["display"] = "none"; DwPrintPrompt2.Style["display"] = "none"; Button5.Style["display"] = "none"; Button4.Style["display"] = "none"; Button8.Style["display"] = "none"; } if (state.SsCoopId != "000501")//แม่จัน { // tss1.Style["display"] = "none"; Button6.Style["display"] = "none"; } if (state.SsCoopId == "000501")//แม่จัน { // tss1.Style["display"] = "none"; Button8.Style["display"] = "none"; } try { HdAccountNo.Value = Request["deptAccountNo"]; deptAccountNo = HdAccountNo.Value; DwStm.Retrieve(deptAccountNo, state.SsCoopControl); String xmlInitDwNewBook = ""; ndept.of_init_printbook(state.SsWsPass, deptAccountNo, state.SsCoopId, ref xmlInitDwNewBook); //DwPrintPrompt.InsertRow(0); string smltest = DwPrintPrompt.Describe("Datawindow.Data.Xml"); //DwPrintPrompt.ImportString( xmlInitDwNewBook, Sybase.DataWindow.FileSaveAsType.Xml); DwUtil.ImportData(xmlInitDwNewBook, DwPrintPrompt, null, Sybase.DataWindow.FileSaveAsType.Xml); DwUtil.RetrieveDataWindow(DwPrintPrompt2, "dp_conteck.pbl", null, deptAccountNo, state.SsCoopControl); DwUtil.RetrieveDataWindow(DwMain, "dp_conteck.pbl", null, deptAccountNo, state.SsCoopControl); DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", DwPrintPrompt2.GetItemDecimal(1, "lastrec_no_card") + 1); } catch (SoapException ex) { LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex)); DwPrintPrompt.InsertRow(0); DwPrintPrompt2.InsertRow(0); DwStm.InsertRow(0); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); DwPrintPrompt.InsertRow(0); DwPrintPrompt2.InsertRow(0); DwStm.InsertRow(0); } } else { HdIsPostBack.Value = "true"; this.RestoreContextDw(DwPrintPrompt); this.RestoreContextDw(DwPrintPrompt2); this.RestoreContextDw(DwStm); } this.deptAccountNo = HdAccountNo.Value; } public void CheckJsPostBack(string eventArg) { if (eventArg == "postPrintBook") { try { Int16 seq = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastrec_no_pb")); Int16 page = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastpage_no_pb")); Int16 line = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastline_no_pb")); //XmlConfigService xml = new XmlConfigService(); int ai_status = 1;// xml.DepositPrintMode; String as_xml_return = ""; string printset = state.SsPrinterSet; state.SsBookVersion = ""; String returnValue = ""; ndept.of_print_book(state.SsWsPass, deptAccountNo, state.SsCoopId, seq, page, line, true, state.SsPrinterSet, ref returnValue, Convert.ToInt16(ai_status), ref as_xml_return); String[] re = returnValue.Split('@'); int rePage = int.Parse(re[0]); int reReq = int.Parse(re[1]); if (state.SsCoopControl == "000501")//แม่จัน พิมพ์การ์ด { HdIsZeroPage.Value = "false"; } else { HdIsZeroPage.Value = rePage == 0 ? "true" : "false"; } HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่ //HdIsNewBook.Value = "true"; //if (ai_status == 1) //{ // Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25); //} //else if (ai_status == 2) //{ Printing.DeptPrintBook(this, as_xml_return); Retrivess(); if (rePage > 0) { DwPrintPrompt.SetItemDecimal(1, "lastrec_no_pb", reReq); DwPrintPrompt.SetItemDecimal(1, "lastline_no_pb", 1); WebUtil.QuerySdt("update dpdeptmaster set lastline_no_pb = 1 where deptaccount_no='" + deptAccountNo + "' and coop_id = '" + state.SsCoopControl + "' "); Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintBook", "rePrintBook('" + deptAccountNo + "')", true); } //} //ooo.Attributes.Add("style", "display:none"); //DwPrintPrompt.SetItemDecimal(1, "lastpage_no_pb", rePage); //DwPrintPrompt.SetItemDecimal(1, "lastrec_no_pb", reReq); //DwPrintPrompt.SetItemDecimal(1, "lastline_no_pb", 1); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if (eventArg == "jsPrintBook2") { try { Int16 seq = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastrec_no_pb")); Int16 page = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastpage_no_pb")); Int16 line = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastline_no_pb")); //XmlConfigService xml = new XmlConfigService(); int ai_status = 1;// xml.DepositPrintMode; String as_xml_return = ""; string printset = state.SsPrinterSet; state.SsBookVersion = ""; String returnValue = ""; ndept.of_print_book(state.SsWsPass, deptAccountNo, state.SsCoopId, seq, page, line, true, state.SsPrinterSet, ref returnValue, Convert.ToInt16(ai_status), ref as_xml_return); String[] re = returnValue.Split('@'); int rePage = int.Parse(re[0]); int reReq = int.Parse(re[1]); if (state.SsCoopControl == "000501")//แม่จัน พิมพ์การ์ด { HdIsZeroPage.Value = "false"; } else { HdIsZeroPage.Value = rePage == 0 ? "true" : "false"; } HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่ //HdIsNewBook.Value = "true"; //if (ai_status == 1) //{ // Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25); //} //else if (ai_status == 2) //{ Printing.DeptPrintBook(this, as_xml_return); Retrivess(); if (rePage > 0) { DwPrintPrompt.SetItemDecimal(1, "lastrec_no_pb", reReq); DwPrintPrompt.SetItemDecimal(1, "lastline_no_pb", 1); WebUtil.QuerySdt("update dpdeptmaster set lastline_no_pb = 1 where deptaccount_no='" + deptAccountNo + "' and coop_id = '" + state.SsCoopControl + "' "); Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintBook", "rePrintBook('" + deptAccountNo + "')", true); } //} //ooo.Attributes.Add("style", "display:none"); //DwPrintPrompt.SetItemDecimal(1, "lastpage_no_pb", rePage); //DwPrintPrompt.SetItemDecimal(1, "lastrec_no_pb", reReq); //DwPrintPrompt.SetItemDecimal(1, "lastline_no_pb", 1); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if (eventArg == "postPrintBookOld") { try { state.SsBookVersion = "Old"; Int16 seq = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastrec_no_pb")); Int16 page = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastpage_no_pb")); Int16 line = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastline_no_pb")); //XmlConfigService xml = new XmlConfigService(); int ai_status = 1;// xml.DepositPrintMode; String as_xml_return = ""; string printset = state.SsPrinterSet; String returnValue = ""; ndept.of_print_book(state.SsWsPass, deptAccountNo, state.SsCoopId, seq, page, line, true, state.SsPrinterSet, ref returnValue, Convert.ToInt16(ai_status), ref as_xml_return); String[] re = returnValue.Split('@'); int rePage = int.Parse(re[0]); int reReq = int.Parse(re[1]); HdIsZeroPage.Value = rePage == 0 ? "true" : "false"; HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่ //HdIsNewBook.Value = "true"; //if (ai_status == 1) //{ // Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25); //} //else if (ai_status == 2) //{ Printing.DeptPrintBook(this, as_xml_return); //} DwPrintPrompt.SetItemDecimal(1, "lastpage_no_pb", rePage); DwPrintPrompt.SetItemDecimal(1, "lastrec_no_pb", reReq); DwPrintPrompt.SetItemDecimal(1, "lastline_no_pb", 1); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if (eventArg == "printbookCard") { string deptAccountNo = HdAccountNo.Value; try { Int16 seq = Convert.ToInt16(HDrec_card.Value); Int16 page = Convert.ToInt16(HDpg.Value); Int16 line = Convert.ToInt16(HDlast.Value); //XmlConfigService xml = new XmlConfigService(); int ai_status = 1;// xml.DepositPrintMode; String as_xml_return = ""; string printset = state.SsPrinterSet; state.SsBookVersion = ""; String returnValue = ""; //ndept.of_print_bookcard(state.SsWsPass, deptAccountNo, state.SsCoopId, seq, page, line, true, state.SsPrinterSet, ref returnValue, Convert.ToInt16(ai_status), ref as_xml_return); String[] re = returnValue.Split('@'); int rePage = int.Parse(re[0]); int reReq = int.Parse(re[1]); HdIsZeroPage.Value = "false"; //HdIsZeroPage.Value = rePage == 0 ? "true" : "false"; //HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่ //HdIsNewBook.Value = "true"; //if (ai_status == 1) //{ // Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25); //} //else if (ai_status == 2) //{ Printing.PrintApplet(this, "dept_printcard", as_xml_return); Retrivess(); if (rePage > 0) { //DwPrintPrompt.SetItemDecimal(1, "lastrec_no_card", reReq); DwPrintPrompt.SetItemDecimal(1, "lastline_no_card", 0); //WebUtil.QuerySdt("update dpdeptmaster set lastline_no_card = 1 where deptaccount_no='" + deptAccountNo + "' and coop_id = '" + state.SsCoopControl + "' "); Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintBookCard", "rePrintBookCard('" + deptAccountNo + "')", true); //Gcoop.GetEl("HDrec_card").value = objDwPrintPrompt2.GetItem(1, "lastrec_no_card"); //Gcoop.GetEl("HDlast").value = objDwPrintPrompt2.GetItem(1, "lastline_no_card"); //Gcoop.GetEl("HDpg").value = objDwPrintPrompt2.GetItem(1, "lastpage_no_card"); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if (eventArg == "jsrePrintBookCard") { string deptAccountNo = HdAccountNo.Value; try { Int16 seq = Convert.ToInt16(HDrec_card.Value); Int16 page = 1; Int16 line = 0; //XmlConfigService xml = new XmlConfigService(); int ai_status = 1;// xml.DepositPrintMode; String as_xml_return = ""; string printset = state.SsPrinterSet; state.SsBookVersion = ""; String returnValue = ""; ndept.of_print_bookcard(state.SsWsPass, deptAccountNo, state.SsCoopId, seq, page, line, true, state.SsPrinterSet, ref returnValue, Convert.ToInt16(ai_status), ref as_xml_return); String[] re = returnValue.Split('@'); int rePage = int.Parse(re[0]); int reReq = int.Parse(re[1]); HdIsZeroPage.Value = "false"; Printing.PrintApplet(this, "dept_printcard", as_xml_return); Retrivess(); if (rePage > 0) { DwPrintPrompt.SetItemDecimal(1, "lastrec_no_card", reReq); DwPrintPrompt.SetItemDecimal(1, "lastline_no_card", 1); WebUtil.QuerySdt("update dpdeptmaster set lastline_no_card = 1 where deptaccount_no='" + deptAccountNo + "' and coop_id = '" + state.SsCoopControl + "' "); Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintBookCard", "rePrintBookCard('" + deptAccountNo + "')", true); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } else if (eventArg == "printbookHeadCard") { Printing.PrintHead_CardDept(this, HdAccountNo.Value, state.SsCoopControl); HdIsZeroPage.Value = "false"; // DwMain.GetItemString(1, "deptaccount_no"); } else if (eventArg == "postPrintSlips") { Sdt d = WebUtil.QuerySdt("select deptslip_no from dpdeptslip where deptaccount_no='" + HdAccountNo.Value + "' and recppaytype_code='CCA'"); if (d.Next()) { Printing.PrintSlipDept2(this, d.GetString("deptslip_no"), state.SsCoopControl); } HdIsZeroPage.Value = "false"; // DwMain.GetItemString(1, "deptaccount_no"); } else if (eventArg == "JSpostCover") { string xml_return = "", xml_return_bf = ""; String apvId = state.SsUsername; short normFlag = 1; ndept.of_print_book_firstpage(state.SsWsPass, HdAccountNo.Value, state.SsCoopId, state.SsWorkDate, state.SsUsername, "", "00", apvId, normFlag, state.SsPrinterSet, 0, 1, ref xml_return); if (xml_return != "") { Printing.DeptPrintBookFirstPage(this, xml_return); } } else if (eventArg == "JSPrintOut") { String sl_xml_lnconno = ""; if (DwMain.RowCount > 0) { sl_xml_lnconno = DwMain.Describe("DataWindow.Data.XML"); // Printing.LoanPrintCont(this, sl_xml_lnconno); Printing.PrintApplet(this, "deptout", sl_xml_lnconno); } } } private void Retrivess() { try { HdAccountNo.Value = Request["deptAccountNo"]; deptAccountNo = HdAccountNo.Value; DwStm.Retrieve(deptAccountNo, state.SsCoopControl); String xmlInitDwNewBook = ""; ndept.of_init_printbook(state.SsWsPass, deptAccountNo, state.SsCoopId, ref xmlInitDwNewBook); //DwPrintPrompt.InsertRow(0); string smltest = DwPrintPrompt.Describe("Datawindow.Data.Xml"); //DwPrintPrompt.ImportString( xmlInitDwNewBook, Sybase.DataWindow.FileSaveAsType.Xml); DwUtil.ImportData(xmlInitDwNewBook, DwPrintPrompt, null, Sybase.DataWindow.FileSaveAsType.Xml); DwUtil.RetrieveDataWindow(DwPrintPrompt2, "dp_conteck.pbl", null, deptAccountNo, state.SsCoopControl); DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", DwPrintPrompt2.GetItemDecimal(1, "lastrec_no_card") + 1); } catch (SoapException ex) { LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex)); DwPrintPrompt.InsertRow(0); DwPrintPrompt2.InsertRow(0); DwStm.InsertRow(0); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); DwPrintPrompt.InsertRow(0); DwPrintPrompt2.InsertRow(0); DwStm.InsertRow(0); } } public void WebDialogLoadEnd() { DwPrintPrompt.SaveDataCache(); DwPrintPrompt2.SaveDataCache(); } #endregion } }