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.WcfNShrlon; //using CoreSavingLibrary.WcfNShrlon; using Sybase.DataWindow; using DataLibrary; namespace Saving.Applications.mbshr { public partial class w_sheet_mbshr_apv_mbnew : PageWebSheet, WebSheet { private n_shrlonClient shrlonService; //private n_shrlonClient shrlonService; private DwThDate tDwOption; private DwThDate tDwList; public String pbl = "mb_apvmbnew.pbl"; protected String postInit; protected String postSetStatus; protected String postRequestStatus; protected String postSetMemberNo; string coop_tron = "000101"; //=========================== public void InitJsPostBack() { postInit = WebUtil.JsPostBack(this, "postInit"); postSetStatus = WebUtil.JsPostBack(this, "postSetStatus"); postRequestStatus = WebUtil.JsPostBack(this, "postRequestStatus"); postSetMemberNo = WebUtil.JsPostBack(this, "postSetMemberNo"); ///=========================== tDwOption = new DwThDate(Dw_option, this); tDwOption.Add("apply_sdate", "apply_stdate"); tDwOption.Add("apply_edate", "apply_etdate"); tDwOption.Add("membdatefix_sdate", "membdatefix_stdate"); tDwOption.Add("membdatefix_edate", "membdatefix_etdate"); tDwList = new DwThDate(Dw_list, this); tDwList.Add("approve_date", "approve_tdate"); } public void WebSheetLoadBegin() { try { shrlonService = wcf.NShrlon; //shrlonService = wcf.NShrlon; } catch { LtServerMessage.Text = WebUtil.ErrorMessage("ติดต่อ Web Service ไม่ได้"); } if (!IsPostBack) { JspostNewClear(); JspostInit(); } else { this.RestoreContextDw(Dw_option); this.RestoreContextDw(Dw_list); } } public void CheckJsPostBack(string eventArg) { if (eventArg == "postInit") { JspostInit(); } else if (eventArg == "postSetStatus") { JspostSetStatus(); } else if (eventArg == "postRequestStatus") { JspostRequestStatus(); } else if (eventArg == "postSetMemberNo") { JspostSetMemberNo(); } } public void SaveWebSheet() { try { str_mbreqnew astr_mbreqnew = new str_mbreqnew(); JspostSetMemberNo(); int clas = 0; if (state.SsCoopControl == "000501") { clas = 3; } astr_mbreqnew.xml_reqlist = Dw_list.Describe("DataWindow.Data.XML"); //int result = shrlonService.SaveMBreqApv(state.SsWsPass, ref astr_mbreqnew); int result = shrlonService.of_saveapv_mbnew(state.SsWsPass, ref astr_mbreqnew); //int result = shrlonService.of_saveapv_mbnew(state.SsWsPass, ref astr_mbreqnew); if (result == 1) { ////////////////////////Update Addrass/////////////////////////////////// int r = Convert.ToInt16(HdRow.Value); String member_no = Dw_list.GetItemString(r,"member_no").ToString(); String tambol_code = "", amphur_code = "", province_code = "", membtype_code = ""; String sql_address_code = @"select tambol_code,amphur_code,province_code,membtype_code from mbmembmaster where member_no = '" + member_no + "'"; Sdt dt_address_code = WebUtil.QuerySdt(sql_address_code); if (dt_address_code.Next()) { tambol_code = dt_address_code.GetString("tambol_code"); amphur_code = dt_address_code.GetString("amphur_code"); province_code = dt_address_code.GetString("province_code"); membtype_code = dt_address_code.GetString("membtype_code"); } String sql_tambol_code = @"select tambol_desc from mbucftambol where tambol_code = '" + tambol_code + "'"; String sql_amphur_code = @"select district_desc from mbucfdistrict where district_code = '" + amphur_code + "'"; String sql_province_code = @"select province_desc from mbucfprovince where province_code = '" + province_code + "'"; Sdt dt_tambol_code = WebUtil.QuerySdt(sql_tambol_code); Sdt dt_amphur_code = WebUtil.QuerySdt(sql_amphur_code); Sdt dt_province_code = WebUtil.QuerySdt(sql_province_code); if (dt_tambol_code.Next()) { tambol_code = dt_tambol_code.GetString("tambol_desc"); } if (dt_amphur_code.Next()) { amphur_code = dt_amphur_code.GetString("district_desc"); } if (dt_province_code.Next()) { province_code = dt_province_code.GetString("province_desc"); } if (membtype_code == "") { membtype_code = ",membtype_code= '10' "; } else { membtype_code = ""; } String update_addrass = "update mbmembmaster set t_tambol = '" + tambol_code + "' , t_amphur = '" + amphur_code + "' , t_province = '" + province_code + "',mblntype_level = " + clas + " ,membtype_level = " + clas + " " + membtype_code + " where member_no = '" + member_no + "' and coop_id ='" + state.SsCoopControl + "'"; WebUtil.Query(update_addrass); WebUtil.Query("update shsharemaster set lastrec_no=1,lastline_no=1,lastpage_no=1 where member_no = '" + member_no + "'"); ///////////////////////////////////////////////////////////// ////Name //sqlUpdate = "update mbmembmaster set membtype_level = 0 where membtype_level is null "; //WebUtil.Query(sqlUpdate); updateDoccumentNo(Dw_list.GetItemDecimal(Convert.ToInt16(HdRow.Value), "member_type")); LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกข้อมูลเรียบร้อยแล้ว"); JspostNewClear(); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } private void updateDoccumentNo(Decimal member_type) { String document_code=""; if (member_type == 1) { document_code = "MBMEMBERNO"; } //สมาชิกสมทบ else if (member_type == 2) { document_code = "MBMEMBERCONO"; } else if (member_type == 3) { document_code = "MBMEMBERCONO_STUDENT"; } String sqlupdate = "update cmdocumentcontrol set last_documentno = last_documentno+1 where document_code = '" + document_code + "'and coop_id = '" + state.SsCoopControl + "'"; WebUtil.Query(sqlupdate); } public void WebSheetLoadEnd() { Dw_option.SaveDataCache(); Dw_list.SaveDataCache(); } //===================== private void JspostNewClear() { try { Dw_option.Reset(); Dw_option.InsertRow(0); //Dw_option.SetItemDate(1, "apply_sdate", state.SsWorkDate); //Dw_option.SetItemDate(1, "apply_edate", state.SsWorkDate); //Dw_option.SetItemDate(1, "membdatefix_sdate", state.SsWorkDate); //Dw_option.SetItemDate(1, "membdatefix_edate", state.SsWorkDate); tDwOption.Eng2ThaiAllRow(); DwUtil.RetrieveDDDW(Dw_option, "membgroup_scode_1", pbl, state.SsCoopId); DwUtil.RetrieveDDDW(Dw_option, "membgroup_ecode_1", pbl, state.SsCoopId); string[] minmaxmemgroup = ReportUtil.GetMinMaxMembgroup(); Dw_option.SetItemString(1, "membgroup_scode_1", ""); Dw_option.SetItemString(1, "membgroup_ecode_1", ""); Dw_list.Reset(); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } private void JspostInit() { try { str_mbreqnew astr_mbreqnew = new str_mbreqnew(); astr_mbreqnew.xml_reqopt = Dw_option.Describe("DataWindow.Data.XML"); //int result = shrlonService.InitApvNewMemberList(state.SsWsPass, ref astr_mbreqnew); int result = shrlonService.of_initlist_apvmbnew(state.SsWsPass, ref astr_mbreqnew); //int result = shrlonService.of_initlist_apvmbnew(state.SsWsPass, ref astr_mbreqnew); if (result == 1) { Dw_list.Reset(); DwUtil.ImportData(astr_mbreqnew.xml_reqlist, Dw_list, null, FileSaveAsType.Xml); for (int i = 1; i <= Dw_list.RowCount; i++) { Dw_list.SetItemString(i, "member_no", "AUTO"); } } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบข้อมูลใบคำขอสมัครสมาชิก/ยังไม่มีสมาชิกสมัครใหม่"); } } private void JspostSetStatus() { try { String btn_name = Hdbutton.Value.Trim(); //รออนุมัติ if (btn_name == "b_wait") { for (int i = 1; i <= Dw_list.RowCount; i++) { Dw_list.SetItemString(i, "member_no", "AUTO"); Dw_list.SetItemString(i, "approve_id", state.SsUsername); Dw_list.SetItemString(i, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(i, "appl_status", 8); Dw_list.SetItemString(i, "approve_tdate", "00/00/0000"); tDwList.Thai2EngAllRow(); Dw_list.SelectRow(0, false); Dw_list.SelectRow(i, true); Dw_list.SetRow(i); } } //อนุมติ else if (btn_name == "b_apv") { for (int i = 1; i <= Dw_list.RowCount; i++) { Dw_list.SetItemString(i, "approve_id", state.SsUsername); Dw_list.SetItemString(i, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(i, "appl_status", 1); Dw_list.SetItemDate(i, "approve_date", state.SsWorkDate); tDwList.Eng2ThaiAllRow(); Dw_list.SelectRow(0, false); Dw_list.SelectRow(i, true); Dw_list.SetRow(i); } } //ไม่อนุมัติ else if (btn_name == "b_noapv") { for (int i = 1; i <= Dw_list.RowCount; i++) { Dw_list.SetItemString(i, "member_no", "AUTO"); Dw_list.SetItemString(i, "approve_id", state.SsUsername); Dw_list.SetItemString(i, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(i, "appl_status", 0); Dw_list.SetItemDate(i, "approve_date", state.SsWorkDate); tDwList.Eng2ThaiAllRow(); Dw_list.SelectRow(0, false); Dw_list.SelectRow(i, true); Dw_list.SetRow(i); } } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } private void JspostRequestStatus() { try { int rowcurrent = int.Parse(HdRow.Value); Decimal request_status = Dw_list.GetItemDecimal(rowcurrent, "appl_status"); if (request_status == 1) { JspostSetMemberNo(); Dw_list.SetItemString(rowcurrent, "approve_id", state.SsUsername); Dw_list.SetItemString(rowcurrent, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(rowcurrent, "appl_status", 1); //if (state.SsCoopId != coop_tron) //{ //String MBMEMBERNO = ""; //MBMEMBERNO = wcf.NCommon.of_getnewdocno(state.SsWsPass, state.SsCoopControl, "MBMEMBERNO"); //Dw_list.SetItemString(rowcurrent, "member_no", MBMEMBERNO); //} Dw_list.SetItemDate(rowcurrent, "approve_date", state.SsWorkDate); tDwList.Eng2ThaiAllRow(); } else if (request_status == 0) { Dw_list.SetItemString(rowcurrent, "member_no", "AUTO"); Dw_list.SetItemString(rowcurrent, "approve_id", state.SsUsername); Dw_list.SetItemString(rowcurrent, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(rowcurrent, "appl_status", 0); Dw_list.SetItemDate(rowcurrent, "approve_date", state.SsWorkDate); tDwList.Eng2ThaiAllRow(); } else { Dw_list.SetItemString(rowcurrent, "member_no", "AUTO"); Dw_list.SetItemString(rowcurrent, "approve_id", state.SsUsername); Dw_list.SetItemString(rowcurrent, "coop_id", state.SsCoopId); Dw_list.SetItemDecimal(rowcurrent, "appl_status", 8); Dw_list.SetItemString(rowcurrent, "approve_tdate", "00/00/0000"); tDwList.Thai2EngAllRow(); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } private void JspostSetMemberNo() { try { //for (int i = 1; i <= Dw_list.RowCount; i++) int r = Convert.ToInt16(HdRow.Value); //{ decimal appl_status = Dw_list.GetItemDecimal(r, "appl_status"); decimal member_type = Dw_list.GetItemDecimal(r, "member_type"); string appl_docno = Dw_list.GetItemString(r, "appl_docno"); string document_code = "", ls_memberno, member_no = "", membgroup_code = ""; decimal last_documentno = 0, last_member = 0; //สถานะอนุมติ if (appl_status == 1) { if (state.SsCoopControl == "000301") { document_code = "MBMEMBERNO"; } else { //สมาชิกปกติ if (member_type == 1) { document_code = "MBMEMBERNO"; } //สมาชิกสมทบ else if (member_type == 2) { document_code = "MBMEMBERCONO"; } else if (member_type == 3) { document_code = "MBMEMBERCONO_STUDENT"; } } //ตรวจสอบว่ามีการกำหนดเลขไปหรือยัง member_no = Dw_list.GetItemString(r, "member_no").Trim(); if (member_no == "AUTO") { //หาเลขลำดับล่าสุด try { String sql = @"select last_documentno from cmdocumentcontrol where coop_id = '" + state.SsCoopControl + "' and document_code = '" + document_code + "'"; Sdt dt = WebUtil.QuerySdt(sql); if (dt.Next()) { last_documentno = Convert.ToDecimal(dt.GetString("last_documentno")); } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } last_member = last_documentno + 1; ls_memberno = Convert.ToString(last_member); if (state.SsCoopControl == "000501" && member_type == 3)//แม่จัน { try { String sql = @"select membgroup_code from mbreqappl where coop_id = '" + state.SsCoopId + "' and appl_docno = '" + appl_docno + "'"; Sdt dt = WebUtil.QuerySdt(sql); if (dt.Next()) { membgroup_code = dt.GetString("membgroup_code").Trim(); } ls_memberno = "000000" + ls_memberno; ls_memberno = ls_memberno.Substring(ls_memberno.Length - 4); // ls_memberno = WebUtil.MemberNoFormat2(ls_memberno); ls_memberno = membgroup_code +"*" +ls_memberno; } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } else{ try { String sql = @"select membgroup_code from mbreqappl where coop_id = '" + state.SsCoopId + "' and appl_docno = '" + appl_docno + "'"; Sdt dt = WebUtil.QuerySdt(sql); if (dt.Next()) { membgroup_code = dt.GetString("membgroup_code").Trim(); } ls_memberno = "00000" + ls_memberno; ls_memberno = ls_memberno.Substring(ls_memberno.Length - 5); // ls_memberno = WebUtil.MemberNoFormat2(ls_memberno); ls_memberno = membgroup_code + ls_memberno; String sqlupdate = "update cmdocumentcontrol set last_documentno = last_documentno+1 where document_code = '" + document_code + "'and coop_id = '" + state.SsCoopControl + "'"; WebUtil.Query(sqlupdate); } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } // ls_memberno = WebUtil.MemberNoFormat2(ls_memberno); Dw_list.SetItemString(r, "member_no", ls_memberno); } } } catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); } } } }