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.WcfNShrlon; using System.Globalization; using Sybase.DataWindow; using DataLibrary; namespace Saving.Applications.shrlon { public partial class w_sheet_sl_share_edit : PageWebSheet, WebSheet { private DwThDate tDwMain; private n_shrlonClient shrlonService; private n_commonClient commonService; protected String jsSearch; protected String jsClickSharecontract; protected String DeleteRowDetail; protected String InsertRowDetail; CultureInfo th = System.Globalization.CultureInfo.GetCultureInfo("th-TH"); Sta ta; String pbl = "sl_share_edit.pbl"; public void InitJsPostBack() { //tDwMain = new DwThDate(dw_main, this); //tDwMain.Add("operate_date", "operate_tdate"); //tDwMain.Add("slip_date", "slip_tdate"); jsSearch = WebUtil.JsPostBack(this, "jsSearch"); jsClickSharecontract = WebUtil.JsPostBack(this, "jsClickSharecontract"); InsertRowDetail = WebUtil.JsPostBack(this, "InsertRowDetail"); DeleteRowDetail = WebUtil.JsPostBack(this, "DeleteRowDetail"); } public void WebSheetLoadBegin() { try { shrlonService = wcf.NShrlon; commonService = wcf.NCommon; } catch { LtServerMessage.Text = WebUtil.ErrorMessage("ติดต่อ Web Service ไม่ได้"); return; } if (IsPostBack) { this.RestoreContextDw(dw_main); this.RestoreContextDw(dw_statement); this.RestoreContextDw(dw_list); this.RestoreContextDw(dw_detail); } if (dw_main.RowCount < 1) { dw_main.InsertRow(1); dw_detail.InsertRow(1); dw_list.InsertRow(1); } this.ConnectSQLCA(); } public void CheckJsPostBack(string eventArg) { if (eventArg == "jsSearch") { jsMember(); } else if (eventArg == "InsertRowDetail") { int row = Convert.ToInt32(Hiddenrow.Value); dw_statement.InsertRow(0); this.SetFocusScript("ref_docno"); int y = dw_statement.RowCount; string member_no = dw_main.GetItemString(1, "member_no"); // String operate_date = dw_statement.GetItemString(u, "operate_tdate"); try { String sql2 = @"insert into shsharestatement(COOP_ID , MEMBER_NO , SHARETYPE_CODE , SEQ_NO , SLIP_DATE , OPERATE_DATE , SHARE_DATE , ACCOUNT_DATE , REF_DOCNO , REF_SLIPNO , SHRITEMTYPE_CODE , PERIOD , SHARE_AMOUNT , SHARESTK_AMT , SHRARREARBF_AMT , SHRARREAR_AMT , MONEYTYPE_CODE , ITEM_STATUS , ENTRY_ID , ENTRY_DATE , ENTRY_BYCOOPID , STATUS_DESC , REMARK , CALDIV_STATUS ) values ({0},{1},{2},{3},{4},{5},{6},{7},'CNV','CNV' ,{10},1,0,0,0,0,{16},{17},{18}, {19},{20},'','',{23} ) "; sql2 = WebUtil.SQLFormat(sql2, state.SsCoopId, member_no, "01", dw_detail.GetItemDecimal(1, "last_stm_no") + 1, state.SsWorkDate, state.SsWorkDate, state.SsWorkDate, state.SsWorkDate, "CNV", "CNV", "SPX", 1, 0, 0, 0, 0, "CSH", 1, state.SsUsername, state.SsWorkDate, state.SsCoopId, "ee", "ee", 0); WebUtil.QuerySdt(sql2); WebUtil.QuerySdt("update shsharemaster set last_stm_no = " + (dw_detail.GetItemDecimal(1, "last_stm_no") + 1) + " where member_no ='" + member_no + "' and coop_id ='"+state.SsCoopId+"' "); DwUtil.RetrieveDataWindow(dw_detail, "sharetype_code", null, member_no, dw_list.GetItemString(1, "sharetype_code")); DwUtil.RetrieveDataWindow(dw_statement, "sharetype_code", null, member_no, dw_list.GetItemString(1, "sharetype_code"));// dw_statement.DeleteRow(row); Sdt d = WebUtil.QuerySdt("select operate_date,slip_date,seq_no from shsharestatement where member_no = '" + member_no + "' and coop_id = '" + state.SsCoopControl + "' order by seq_no asc "); int h = 1; while (d.Next()) { DateTime operate_tdate = Convert.ToDateTime(d.GetDate("operate_date")).AddYears(543); dw_statement.SetItemString(h, "operate_tdate", operate_tdate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); DateTime slip_date = Convert.ToDateTime(d.GetDate("slip_date")).AddYears(543); dw_statement.SetItemString(h, "slip_tdate", slip_date.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "operate_date", d.GetDate("operate_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "operate_tdate", d.GetDate("operate_date").ToString("dd/MM/yyyy")); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "slip_date", d.GetDate("slip_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "slip_tdate", d.GetDate("slip_date").ToString("dd/MM/yyyy")); h++; } } catch (Exception es) { } } else if (eventArg == "DeleteRowDetail") { int row = Convert.ToInt32(Hiddenrow.Value); int h = dw_statement.RowCount; decimal ros = 0; try { ros = dw_statement.GetItemDecimal(row, "seq_no"); } catch (Exception ex) { ros = 0; } if (ros == 0) { DwUtil.RetrieveDataWindow(dw_statement, "sharetype_code", null, dw_main.GetItemString(1, "member_no"), dw_list.GetItemString(1, "sharetype_code"));// dw_statement.DeleteRow(row); Sdt d = WebUtil.QuerySdt("select operate_date,slip_date,seq_no from shsharestatement where member_no = '" + dw_main.GetItemString(1, "member_no") + "' and coop_id = '" + state.SsCoopControl + "' order by seq_no asc "); int h2 = 1; while (d.Next()) { DateTime operate_tdate = Convert.ToDateTime(d.GetDate("operate_date")).AddYears(543); dw_statement.SetItemString(h2, "operate_tdate", operate_tdate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); DateTime slip_date = Convert.ToDateTime(d.GetDate("slip_date")).AddYears(543); dw_statement.SetItemString(h2, "slip_tdate", slip_date.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "operate_date", d.GetDate("operate_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "operate_tdate", d.GetDate("operate_date").ToString("dd/MM/yyyy")); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "slip_date", d.GetDate("slip_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "slip_tdate", d.GetDate("slip_date").ToString("dd/MM/yyyy")); h2++; } } else { try { string sqlStr2 = "delete from shsharestatement where member_no={0} and seq_no={1}"; sqlStr2 = WebUtil.SQLFormat(sqlStr2, dw_main.GetItemString(1, "member_no"), dw_statement.GetItemString(row, "seq_no")); WebUtil.QuerySdt(sqlStr2); } catch (Exception es) { LtServerMessage.Text = es.ToString(); } jsMember(); } } else if (eventArg == "jsClickSharecontract") { String row = HDcolumnnumber.Value; int rows = Convert.ToInt32(row); String member_no = ""; member_no = HdMemberNo.Value; member_no = WebUtil.MemberNoFormat(member_no); String sharetype_code = dw_list.GetItemString(rows, "sharetype_code"); // DwUtil.RetrieveDataWindow(dw_list, "LOANCONTRACT_NO", null, loancontract); DwUtil.RetrieveDataWindow(dw_detail, "sharetype_code", null, member_no, sharetype_code); DwUtil.RetrieveDataWindow(dw_statement, "sharetype_code", null, member_no, sharetype_code); DwUtil.RetrieveDataWindow(dw_list, "member_no", null, member_no); Sdt d = WebUtil.QuerySdt("select operate_date,slip_date,seq_no from shsharestatement where member_no = '" + member_no + "' and coop_id = '" + state.SsCoopControl + "' order by seq_no asc "); int h = 1; while (d.Next()) { DateTime operate_tdate = Convert.ToDateTime(d.GetDate("operate_date")).AddYears(543); dw_statement.SetItemString(h, "operate_tdate", operate_tdate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); DateTime slip_date = Convert.ToDateTime(d.GetDate("slip_date")).AddYears(543); dw_statement.SetItemString(h, "slip_tdate", slip_date.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "operate_date", d.GetDate("operate_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "operate_tdate", d.GetDate("operate_date").ToString("dd/MM/yyyy")); // dw_statement.SetItemDate(d.GetInt32("seq_no"), "slip_date", d.GetDate("slip_date")); // dw_statement.SetItemString(d.GetInt32("seq_no"), "slip_tdate", d.GetDate("slip_date").ToString("dd/MM/yyyy")); h++; } } } public void jsMember() { try { String member_no = ""; member_no = WebUtil.MemberNoFormat( HdMemberNo.Value); // member_no = Dw_main.GetItemString(1, "member_no"); //member_no = selectMemNo(member_no); // dw_main.SetItemString(1, "member_no", member_no); DwUtil.RetrieveDataWindow(dw_main, "member_no", null, member_no); // DwUtil.RetrieveDDDW(dw_main, "member_no", member_no); DwUtil.RetrieveDataWindow(dw_list, "member_no", null, member_no); // String sharetype_code = dw_list.GetItemString(1, "sharetype_code"); // DwUtil.RetrieveDataWindow(dw_list, "LOANCONTRACT_NO", null, loancontract); DwUtil.RetrieveDataWindow(dw_detail, "sharetype_code", null, member_no, sharetype_code); DwUtil.RetrieveDataWindow(dw_statement, "sharetype_code", null, member_no, sharetype_code); DwUtil.RetrieveDataWindow(dw_list, "member_no", null, member_no); Sdt d = WebUtil.QuerySdt("select operate_date,slip_date,seq_no from shsharestatement where member_no = '"+member_no+"' and coop_id = '"+state.SsCoopControl+"' order by seq_no asc "); int y = 1; while (d.Next()) { DateTime operate_tdate = Convert.ToDateTime(d.GetDate("operate_date")).AddYears(543); dw_statement.SetItemString(y, "operate_tdate", operate_tdate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); DateTime slip_date = Convert.ToDateTime(d.GetDate("slip_date")).AddYears(543); dw_statement.SetItemString(y, "slip_tdate", slip_date.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture)); y++; } } catch { } } public void SaveWebSheet() { try { String sql = "update shsharemaster set sharebegin_amt=" + dw_detail.GetItemDecimal(1, "sharebegin_amt") + " , sharestk_amt=" + dw_detail.GetItemDecimal(1, "sharestk_amt") + " , " + "last_period=" + dw_detail.GetItemDecimal(1, "last_period") + " , last_stm_no=" + dw_detail.GetItemDecimal(1, "last_stm_no") + " ,sequest_status=" + dw_detail.GetItemDecimal(1, "sequest_status") + " ,sharemaster_status=" + dw_detail.GetItemDecimal(1, "sharemaster_status") + " where member_no = '" + dw_main.GetItemString(1, "member_no") + "' and coop_id = '" + state.SsCoopControl + "' "; WebUtil.QuerySdt(sql); if (dw_statement.RowCount>1){ for (int u = 1; u <= dw_statement.RowCount; u++) { DateTime operate_tdate = DateTime.ParseExact(dw_statement.GetItemString(u, "operate_tdate"), "dd/MM/yyyy", th); DateTime slip_tdate = DateTime.ParseExact(dw_statement.GetItemString(u, "slip_tdate"), "dd/MM/yyyy", th); String ref_docno = ""; try { ref_docno = dw_statement.GetItemString(u, "ref_docno"); } catch (Exception es) { ref_docno = ""; } // String operate_date = dw_statement.GetItemString(u, "operate_tdate"); String sql2 = "update shsharestatement set operate_date={0},slip_date={1},ref_docno='" + ref_docno + "' ,share_amount=" + (dw_statement.GetItemDecimal(u, "share_amount") / 10) + " ,sharestk_amt=" + (dw_statement.GetItemDecimal(u, "sharestk_amt") / 10) + " where member_no ='" + dw_main.GetItemString(1, "member_no") + "' and coop_id = '" + state.SsCoopControl + "' and seq_no = " + dw_statement.GetItemDecimal(u, "seq_no") + " "; sql2 = WebUtil.SQLFormat(sql2, operate_tdate, slip_tdate); WebUtil.QuerySdt(sql2); } // DwUtil.UpdateDataWindow(dw_detail, pbl, "shsharemaster"); } LtServerMessage.Text = WebUtil.CompleteMessage("แก้ไข เรียบร้อย"); jsMember(); } catch (Exception e) { LtServerMessage.Text = e.ToString(); } // throw new NotImplementedException(); } public void WebSheetLoadEnd() { throw new NotImplementedException(); } } }