using System; using CoreSavingLibrary; 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.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Xml.Linq; //using CoreSavingLibrary.WcfNCommon; //using CoreSavingLibrary.WcfDeposit; using CoreSavingLibrary.WcfNCommon; // new common using CoreSavingLibrary.WcfNDeposit;// new deposit using Sybase.DataWindow; using System.Web.Services.Protocols; using DataLibrary; namespace Saving.Applications.ap_deposit { public partial class w_sheet_dp_reprint_slip : PageWebSheet, WebSheet { protected string postAccount; protected string PrintSlip; //private DepositClient depService; private n_depositClient ndept; public void InitJsPostBack() { postAccount = WebUtil.JsPostBack(this, "postAccount"); PrintSlip = WebUtil.JsPostBack(this, "PrintSlip"); } public void WebSheetLoadBegin() { this.ConnectSQLCA(); DwData.SetTransaction(sqlca); DwDetail.SetTransaction(sqlca); try { //depService = wcf.Deposit; ndept = wcf.NDeposit; } catch { } if (!IsPostBack) { DwData.InsertRow(0); } else { this.RestoreContextDw(DwData); this.RestoreContextDw(DwDetail); } } public void CheckJsPostBack(string eventArg) { if (eventArg == "postAccount") { JspostAccount(); } else if (eventArg == "PrintSlip") { JsPrintSlip(); } } public void SaveWebSheet() { } public void WebSheetLoadEnd() { DwData.SaveDataCache(); DwDetail.SaveDataCache(); } private void JspostAccount() { string ls_member_no, ls_member_name, ls_member_surname, ls_member_group_no; string ls_account_no, ls_account_name, ls_account_type; string ls_sqlext, ls_temp, ls_coopid; ls_sqlext = ""; String sqlFirst = ""; if (Sta.IS_MYSQL_MODE) { sqlFirst = @" SELECT DPDEPTSLIP.DEPTSLIP_NO, DPDEPTSLIP.DEPTSLIP_DATE, DPDEPTSLIP.RECPPAYTYPE_CODE, DPDEPTSLIP.DEPTSLIP_AMT, DPDEPTSLIP.ENTRY_ID, DPDEPTMASTER.DEPTACCOUNT_NO, DPDEPTMASTER.MEMBER_NO, DPDEPTMASTER.DEPTACCOUNT_NAME, DPDEPTMASTER.DEPTTYPE_CODE, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMBGROUP_CODE, DPDEPTMASTER.DEPT_OBJECTIVE, DPDEPTSLIP.ENTRY_DATE, DPDEPTSLIP.DPSTM_NO, DPDEPTSLIP.CASH_TYPE, DPDEPTSLIP.INT_AMT, DPDEPTSLIP.ACCUINT_AMT, DPDEPTSLIP.DEPTGROUP_CODE, DPDEPTSLIP.DEPTSLIP_NETAMT, DPDEPTSLIP.REFER_SLIPNO, DPDEPTSLIP.COOP_ID FROM DPDEPTSLIP, DPDEPTMASTER, MBMEMBMASTER, DPUCFRECPPAYTYPE WHERE ( dpdeptmaster.member_no = mbmembmaster.member_no ) and ( dpdeptmaster.coop_id = mbmembmaster.coop_id ) and ( DPDEPTSLIP.DEPTACCOUNT_NO = DPDEPTMASTER.DEPTACCOUNT_NO ) and ( DPDEPTSLIP.RECPPAYTYPE_CODE = DPUCFRECPPAYTYPE.RECPPAYTYPE_CODE ) and ( DPDEPTSLIP.DEPTCOOP_ID = DPDEPTMASTER.COOP_ID ) and ( DPDEPTSLIP.DEPTCOOP_ID = DPUCFRECPPAYTYPE.COOP_ID ) and ( DPDEPTSLIP.RECPPAYTYPE_CODE not in ( 'WIN','INR','FEE','TAX' ) ) AND ( DPDEPTSLIP.SHOWFOR_DEPT = 1 ) "; } else { sqlFirst = @" SELECT DPDEPTSLIP.DEPTSLIP_NO, DPDEPTSLIP.DEPTSLIP_DATE, DPDEPTSLIP.RECPPAYTYPE_CODE, DPDEPTSLIP.DEPTSLIP_AMT, DPDEPTSLIP.ENTRY_ID, DPDEPTMASTER.DEPTACCOUNT_NO, DPDEPTMASTER.MEMBER_NO, DPDEPTMASTER.DEPTACCOUNT_NAME, DPDEPTMASTER.DEPTTYPE_CODE, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, MBMEMBMASTER.MEMBGROUP_CODE, DPDEPTMASTER.DEPT_OBJECTIVE, DPDEPTSLIP.ENTRY_DATE, DPDEPTSLIP.DPSTM_NO, DPDEPTSLIP.CASH_TYPE, DPDEPTSLIP.INT_AMT, DPDEPTSLIP.ACCUINT_AMT, DPDEPTSLIP.DEPTGROUP_CODE, DPDEPTSLIP.DEPTSLIP_NETAMT, DPDEPTSLIP.REFER_SLIPNO, DPDEPTSLIP.COOP_ID FROM DPDEPTSLIP, DPDEPTMASTER, MBMEMBMASTER, DPUCFRECPPAYTYPE WHERE ( dpdeptmaster.member_no = mbmembmaster.member_no (+)) and ( dpdeptmaster.coop_id = mbmembmaster.coop_id (+)) and ( DPDEPTSLIP.DEPTACCOUNT_NO = DPDEPTMASTER.DEPTACCOUNT_NO ) and ( DPDEPTSLIP.RECPPAYTYPE_CODE = DPUCFRECPPAYTYPE.RECPPAYTYPE_CODE ) and ( DPDEPTSLIP.DEPTCOOP_ID = DPDEPTMASTER.COOP_ID ) and ( DPDEPTSLIP.DEPTCOOP_ID = DPUCFRECPPAYTYPE.COOP_ID ) and ( ( DPDEPTSLIP.RECPPAYTYPE_CODE not in ( 'WIN','INR','FEE','TAX' ) ) AND ( DPDEPTSLIP.SHOWFOR_DEPT = 1 ) ) AND rownum <= 500 "; } try { ls_member_no = DwData.GetItemString(1, "member_no"); } catch { ls_member_no = ""; } try { ls_member_name = DwData.GetItemString(1, "member_name"); } catch { ls_member_name = ""; } try { ls_member_surname = DwData.GetItemString(1, "member_surname"); } catch { ls_member_surname = ""; } try { ls_member_group_no = DwData.GetItemString(1, "member_group_no"); } catch { ls_member_group_no = ""; } try { ls_account_no = DwData.GetItemString(1, "account_no"); } catch { ls_account_no = ""; } try { ls_account_name = DwData.GetItemString(1, "account_name"); } catch { ls_account_name = ""; } try { ls_account_type = DwData.GetItemString(1, "account_type"); } catch { ls_account_type = ""; } try { ls_coopid = state.SsCoopId.Trim();//DwData.GetItemString(1, "coop_id"); } catch { ls_coopid = ""; } //-- if (ls_member_no.Length > 0) { ls_sqlext = " and ( dpdeptmaster.member_no = '" + ls_member_no + "') "; } if (ls_member_name.Length > 0) { ls_sqlext += " and ( mbmembmaster.memb_name like '" + ls_member_name + "%') "; } if (ls_member_surname.Length > 0) { ls_sqlext += " and ( mbmembmaster.memb_surname like '" + ls_member_surname + "%') "; } if (ls_member_group_no.Length > 0) { ls_sqlext += " and ( mbmembmaster.membgroup_code = '" + ls_member_group_no + "') "; } if (ls_account_no.Length > 0) { ls_sqlext += " and ( dpdeptmaster.deptaccount_no Like '%" + ls_account_no + "%' ) "; } if (ls_account_name.Length > 0) { ls_sqlext += " and ( dpdeptmaster.deptaccount_name Like '" + ls_account_name + "%') "; } if (ls_account_type.Length > 0) { ls_sqlext += " and ( dpdeptmaster.depttype_code = '" + ls_account_type + "') "; } if (ls_coopid.Length > 0) { ls_sqlext += " and ( dpdeptslip.coop_id = '" + ls_coopid + "') "; } if (ls_sqlext == null) ls_sqlext = ""; ls_sqlext += " ORDER BY DPDEPTSLIP.DEPTSLIP_DATE DESC,DPDEPTSLIP.DEPTSLIP_NO DESC "; ls_temp = sqlFirst + ls_sqlext; DataTable dt = WebUtil.Query(ls_temp); DwUtil.ImportData(dt, DwDetail, null); } private void JsPrintSlip() { string deptSlipNo = HdDeptSlip.Value; String type = DwDetail.GetItemString(Convert.ToInt32(Hiddenrow.Value), "recppaytype_code"); try { if (Sta.IS_MYSQL_MODE) { int printStatus = xmlconfig.DepositPrintMode; string xml_return = ""; int re = ndept.of_print_slip(state.SsWsPass, deptSlipNo, state.SsCoopId, state.SsPrinterSet, 1, ref xml_return); if (xml_return != "") { if (type.Substring(0, 1) == "D" || type.Substring(0, 1) == "O") { Printing.PrintApplet(this, "dp_dept_slip", xml_return); } else if (type.Substring(0,1) == "W") { Printing.PrintApplet(this, "dp_width_slip", xml_return); } else //ปิดบัญชี { Printing.PrintApplet(this, "dp_close_slip", xml_return); } } } else { if (state.SsCoopControl == "000501" && type == "INT") { Printing.PrintSlipDept(this, deptSlipNo, state.SsCoopControl); } else { int printStatus = xmlconfig.DepositPrintMode; string xml_return = ""; int re = ndept.of_print_slip(state.SsWsPass, deptSlipNo, state.SsCoopId, state.SsPrinterSet, 1, ref xml_return); if (xml_return != "") { if (state.SsCoopControl == "000301") { if (type == "DCA" || type == "OCA") { Printing.PrintApplet(this, "dept_slip2", xml_return); } else { Printing.PrintApplet(this, "dept_slip", xml_return); } } else { Printing.PrintApplet(this, "dept_slip", xml_return); } } } } LtServerMessage.Text = WebUtil.CompleteMessage("เสร็จสมบูรณ์..."); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); } } } }