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 Sybase.DataWindow;
using DataLibrary;
using System.IO;
namespace Saving.Applications.keeping
{
public partial class w_sheet_kp_opr_exp_savedisk : PageWebSheet, WebSheet
{
DataStore DStore;
public String pbl = "kp_exp_savedisk.pbl";
protected String postInit;
protected String postChangeOption;
private DwThDate tDw_main;
//==============================
public void InitJsPostBack()
{
postInit = WebUtil.JsPostBack(this, "postInit");
postChangeOption = WebUtil.JsPostBack(this, "postChangeOption");
//==================================
tDw_main = new DwThDate(Dw_main, this);
tDw_main.Add("operate_date", "operate_tdate");
//===================================
DwUtil.RetrieveDDDW(Dw_choice, "format_text", pbl, state.SsCoopId);
}
public void WebSheetLoadBegin()
{
this.ConnectSQLCA();
Dw_detail.SetTransaction(sqlca);
try
{
if (!IsPostBack)
{
JspostNewClear();
}
else
{
this.RestoreContextDw(Dw_choice);
this.RestoreContextDw(Dw_main);
this.RestoreContextDw(Dw_detail);
}
}
catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
}
public void CheckJsPostBack(string eventArg)
{
if (eventArg == "postInit")
{
JspostInit();
}
else if (eventArg == "postChangeOption")
{
JspostChangeOption();
}
}
public void SaveWebSheet()
{
try
{
String ls_filename = "", ls_path = "", ls_trndate = "";
String format_text = Dw_choice.GetItemString(1, "format_text");
String filename = "";
DateTime ldtm_trndate = new DateTime();
//ออก Text File แบบเงินเดือน TMT
if (format_text == "001" || format_text == "002")
{
filename = "FN8";
DStore = new DataStore();
DStore.LibraryList = WebUtil.PhysicalPath + @"Saving\DataWindow\keeping\kp_exp_savedisk.pbl";
DStore.DataWindowObject = "d_kp_dsksrv_hrtext";
String ls_datacode, ls_salaryid;
int li_row, li_count;
Decimal ldc_moneyamt = 0;
ls_datacode = Dw_main.GetItemString(1, "data_code");
ldtm_trndate = Dw_main.GetItemDate(1, "operate_date");
ls_trndate = ldtm_trndate.ToString("dd.MM.yyyy");
ls_filename = filename + (ldtm_trndate.Year).ToString() + ldtm_trndate.ToString("MMdd") + ".txt";
ls_path = WebUtil.PhysicalPath + @"Saving\filecommon\" + filename + (ldtm_trndate.Year).ToString() + ldtm_trndate.ToString("MMdd") + ".txt";
li_row = DStore.InsertRow(0);
DStore.SetItemString(li_row, "PERNR", "หมายเลขพนักงาน");
DStore.SetItemString(li_row, "DATE", "วันเริ่มต้น");
DStore.SetItemString(li_row, "WAGETYPE", "กลุ่มข้อมูลย่อย");
DStore.SetItemString(li_row, "AMOUNT", "จำนวนเงิน");
DStore.SetItemString(li_row, "NUMBER", "จำนวน/หน่วย");
DStore.SetItemString(li_row, "ZUORD", "เลขที่การกำหนด");
li_row = DStore.InsertRow(0);
li_row = DStore.InsertRow(0);
// li_count = Dw_detail.RowCount;
li_count = int.Parse(HdRowCount.Value);
for (int i = 1; i <= li_count; i++)
{
try { ls_salaryid = Dw_detail.GetItemString(i, "salary_id").Trim(); }
catch { ls_salaryid = ""; }
ldc_moneyamt = Dw_detail.GetItemDecimal(i, "total");
li_row = DStore.InsertRow(0);
DStore.SetItemString(li_row, "PERNR", ls_salaryid);
DStore.SetItemString(li_row, "DATE", ls_trndate);
DStore.SetItemString(li_row, "WAGETYPE", ls_datacode);
DStore.SetItemString(li_row, "AMOUNT", ldc_moneyamt.ToString());
}
DStore.SaveAs(ls_path, FileSaveAsType.Text, true);
}
//กรณี Export เป็นแบบเงินฝาก
else
{
String company_bank = Dw_main.GetItemString(1, "company_bank").Trim();
String company_accid = Dw_main.GetItemString(1, "company_accid").Trim();
String company_name = Dw_main.GetItemString(1, "company_name").Trim();
String transfer_type = Dw_main.GetItemString(1, "transfer_type").Trim();
String transfer_code = Dw_main.GetItemString(1, "transfer_code").Trim();
// DateTime ldtm_operate = new DateTime();
//สมาชิกปกติ โอนธนาคาร
if (format_text == "003")
{
filename = "D00603";
}
else
{
//สมาชิกสมทบ โอนธนาคาร
filename = "D00703";
}
DStore = new DataStore();
DStore.LibraryList = WebUtil.PhysicalPath + @"Saving\DataWindow\keeping\kp_exp_savedisk.pbl";
DStore.DataWindowObject = "d_kp_dsksrv_linetext";
String ls_memberno, ls_space,ls_space1, ls_space2, ls_space3, ls_space4, ls_expaccid, ls_memname, ls_surname, ls_name;
int li_row, li_count, li_running;
Decimal ldc_moneyamt = 0,ldc_moneytotal = 0;
ldtm_trndate = Dw_main.GetItemDate(1, "operate_date");
ls_trndate = ldtm_trndate.ToString("ddMMyy");
ls_filename = filename + (ldtm_trndate.Year.ToString()) + ldtm_trndate.ToString("MMdd") + ".txt";
ls_path = WebUtil.PhysicalPath + @"Saving\filecommon\" + filename + (ldtm_trndate.Year.ToString()) + ldtm_trndate.ToString("MMdd") + ".txt";
//Header
li_row = DStore.InsertRow(0);
li_running = 1;
ls_space = " ";
ls_space1 = " ";
String linetext = "H" + li_running.ToString("000000") + company_bank + company_accid + company_name + ls_space + ls_trndate + ls_space1;
DStore.SetItemString(li_row, "line_text", linetext);
li_count = Dw_detail.RowCount;
ls_space2 = " ";
ls_space3 = " ";
ls_space4 = " ";
//Detail
for (int i = 1; i <= li_count; i++)
{
try { ls_memberno = Dw_detail.GetItemString(i, "member_no").Trim(); }
catch { ls_memberno = ""; }
//ตัดเลขสมาชิกเหลือ 6
ls_memberno = ls_memberno.Substring(2, 6);
try { ls_expaccid = Dw_detail.GetItemString(i, "expense_accid").Trim(); }
catch { ls_expaccid = ""; }
try { ls_name = Dw_detail.GetItemString(i, "memb_name").Trim(); }
catch { ls_name = ""; }
try { ls_surname = Dw_detail.GetItemString(i, "memb_surname").Trim(); }
catch { ls_surname = ""; }
ls_memname = ls_name + " " + ls_surname;
ldc_moneyamt = Dw_detail.GetItemDecimal(i, "total");
ldc_moneytotal = ldc_moneytotal + ldc_moneyamt;
li_row = DStore.InsertRow(0);
linetext = "D" + li_row.ToString("000000") + company_bank + ls_expaccid + "D" + (ldc_moneyamt * 100).ToString("000000000000") +transfer_code + "9" + ls_space2 + ldtm_trndate.ToString("yyMMdd") + ls_space3 + ls_memberno + " " + ls_memname;
DStore.SetItemString(li_row, "line_text", linetext);
}
//footer
li_row = DStore.InsertRow(0);
//if (transfer_type == "D")
//{
linetext = "T" + li_row.ToString("000000") + company_bank + company_accid + Dw_detail.RowCount.ToString("0000000") + (ldc_moneytotal * 100).ToString("000000000000000") + "0000000" + "000000000000000" + ls_space4;
//}
//else
//{
// linetext = "T" + li_row.ToString("000000") + company_bank + company_accid + "0000000" + "000000000000000" + Dw_detail.RowCount.ToString("0000000") + (ldc_moneytotal * 100).ToString("000000000000000") + ls_space4;
//}
DStore.SetItemString(li_row, "line_text", linetext);
DStore.SaveAs(ls_path, FileSaveAsType.Text, false);
}
LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกข้อมูลเสร็จแล้ว " + ls_filename + "");
JspostNewClear();
}
catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
}
public void WebSheetLoadEnd()
{
Dw_choice.SaveDataCache();
Dw_main.SaveDataCache();
Dw_detail.SaveDataCache();
}
private void JspostNewClear()
{
Dw_choice.Reset();
Dw_choice.InsertRow(0);
Dw_main.DataWindowObject = "d_kp_exp_savedisk_option";
Dw_main.Reset();
Dw_main.InsertRow(0);
Dw_main.SetItemString(1, "year", Convert.ToString(DateTime.Now.Year + 543));
Dw_main.SetItemString(1, "month", Convert.ToString(DateTime.Now.Month));
Dw_main.SetItemDate(1, "operate_date", state.SsWorkDate);
Dw_main.SetItemString(1, "data_code", "2490");
Dw_detail.Reset();
tDw_main.Eng2ThaiAllRow();
}
private void JspostInit()
{
try
{
//เปลี่ยน datawindow ก่อน
String filename = "";
String ls_filename = "", ls_path = "", ls_trndate = "";
DateTime ldtm_trndate = new DateTime();
decimal memmain_flag ;
decimal memco_flag ;
string ls_sql = "";
string ls_sqlsal = "";
string ls_sqlcbt = "";
string membgroup_code = "";
string membtype_code = "";
string member_type = "";
// int li_row = 0;
string format_text = Dw_choice.GetItemString(1, "format_text");
String year = Dw_main.GetItemString(1, "year");
String month = Dw_main.GetItemString(1, "month");
if (month.Length != 2)
{
month = "0" + month;
}
String recv_period = year + month;
//หาประเภทสมาชิกก่อน ดึงเฉพาะปกติ หรือ สมทบ หรือดึงทั้งคู่
ls_sql = "select memmain_flag,memco_flag from kpcfdisk where disk_code = '" + format_text + "'";
Sdt dtdisk = WebUtil.QuerySdt(ls_sql);
if (dtdisk.Next())
{
memmain_flag = dtdisk.GetDecimal("memmain_flag");
memco_flag = dtdisk.GetDecimal("memco_flag");
//กรณีที่เป็นปกติอย่างเดียว
if (memmain_flag == 1 && memco_flag == 0)
{
member_type = "'1'";
}
//กรณีที่เป็นสมทบอย่างเดียว
else if (memmain_flag == 0 && memco_flag == 1)
{
member_type = "'2'";
}
//กรณีที่เลือกทั้งคู่ ปกติและสมทบ
else
{
member_type = "'1','2'";
}
}
//sqlดึงข้อมูล
//กรณีที่เป็น เงินเดือน TMT
if (format_text == "001" || format_text == "002")
{
ls_sqlsal = "Select kp.member_no,mm.salary_id,kp.membgroup_code,sum(ke.item_payment) as total " +
"From kptempreceive kp, kpreceiveexpense ke, mbmembmaster mm " +
"Where (kp.coop_id = ke.coop_id) And " +
"(kp.kpslip_no = ke.kpslip_no) And " +
"(kp.coop_id = mm.coop_id) And " +
"(kp.member_no = mm.member_no) And " +
"(ke.expense_code = 'SAL') And " +
"(ke.recv_period = '" + recv_period + "') And " +
"(ke.item_payment > 0) And " +
"mm.member_type in (" + member_type + ") And " +
"trim(kp.membgroup_code) in (Select trim(membgroup_code) From kpcfdiskmembgroup " +
"Where disk_code = '" + format_text + "') And " +
"mm.membtype_code in (Select membtype_code From kpcfdiskmembtype Where disk_code = '" + format_text + "') " +
"Group by kp.member_no,mm.salary_id,kp.membgroup_code ";
Sdt dtsal = WebUtil.QuerySdt(ls_sqlsal);
if (dtsal.Rows.Count > 0)
{
filename = "FN8";
DStore = new DataStore();
DStore.LibraryList = WebUtil.PhysicalPath + @"Saving\DataWindow\keeping\kp_exp_savedisk.pbl";
DStore.DataWindowObject = "d_kp_dsksrv_hrtext";
String ls_datacode, ls_salaryid;
int li_row;
Decimal ldc_moneyamt = 0;
ls_datacode = Dw_main.GetItemString(1, "data_code");
ldtm_trndate = Dw_main.GetItemDate(1, "operate_date");
ls_trndate = ldtm_trndate.ToString("dd.MM.yyyy");
ls_filename = filename + (ldtm_trndate.Year).ToString() + ldtm_trndate.ToString("MMdd") + ".txt";
ls_path = WebUtil.PhysicalPath + @"Saving\filecommon\" + filename + (ldtm_trndate.Year).ToString() + ldtm_trndate.ToString("MMdd") + ".txt";
li_row = DStore.InsertRow(0);
DStore.SetItemString(li_row, "PERNR", "หมายเลขพนักงาน");
DStore.SetItemString(li_row, "DATE", "วันเริ่มต้น");
DStore.SetItemString(li_row, "WAGETYPE", "กลุ่มข้อมูลย่อย");
DStore.SetItemString(li_row, "AMOUNT", "จำนวนเงิน");
DStore.SetItemString(li_row, "NUMBER", "จำนวน/หน่วย");
DStore.SetItemString(li_row, "ZUORD", "เลขที่การกำหนด");
li_row = DStore.InsertRow(0);
li_row = DStore.InsertRow(0);
while (dtsal.Next())
{
try { ls_salaryid = dtsal.GetString("salary_id").Trim(); }
catch { ls_salaryid = ""; }
try { ldc_moneyamt = dtsal.GetDecimal("total"); }
catch { ldc_moneyamt = 0; }
li_row = DStore.InsertRow(0);
DStore.SetItemString(li_row, "PERNR", ls_salaryid);
DStore.SetItemString(li_row, "DATE", ls_trndate);
DStore.SetItemString(li_row, "WAGETYPE", ls_datacode);
DStore.SetItemString(li_row, "AMOUNT", ldc_moneyamt.ToString());
}
DStore.SaveAs(ls_path, FileSaveAsType.Text, true);
LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกข้อมูลเสร็จแล้ว " + ls_filename + "");
JspostNewClear();
}
else
{
LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบข้อมูลที่ต้องการออก TextFile");
JspostNewClear();
}
}
//กรณีที่เป็น บัญชี CBT
else
{
ls_sqlcbt = " Select kp.member_no,mm.salary_id,kp.membgroup_code,ft_memgrp(kp.coop_id,kp.membgroup_code) as memgrp, " +
"mm.memb_name,mm.memb_surname, sum(ke.item_payment) as total " +
"From kptempreceive kp, kpreceiveexpense ke, mbmembmaster mm " +
"Where (kp.coop_id = ke.coop_id) And " +
"(kp.kpslip_no = ke.kpslip_no) And " +
"(kp.coop_id = mm.coop_id) And " +
"(kp.member_no = mm.member_no) And " +
"(ke.expense_code = 'CBT') And " +
"(ke.recv_period = '" + recv_period + "') And " +
"(ke.item_payment > 0) And " +
"mm.member_type in (" + member_type + ") And " +
"trim(kp.membgroup_code) in (Select trim(membgroup_code) From kpcfdiskmembgroup " +
"Where disk_code = '" + format_text + "') And " +
"mm.membtype_code in (Select membtype_code From kpcfdiskmembtype Where disk_code = '" + format_text + "') " +
"Group By mm.memb_name, mm.memb_surname, kp.member_no, mm.salary_id, ke.expense_accid, kp.membgroup_code, ft_memgrp(kp.coop_id,kp.membgroup_code) " +
"Order By kp.member_no";
Sdt dtcbt = WebUtil.QuerySdt(ls_sqlcbt);
if (dtcbt.Rows.Count > 0)
{
String company_bank = Dw_main.GetItemString(1, "company_bank").Trim();
String company_accid = Dw_main.GetItemString(1, "company_accid").Trim();
String company_name = Dw_main.GetItemString(1, "company_name").Trim();
String transfer_type = Dw_main.GetItemString(1, "transfer_type").Trim();
String transfer_code = Dw_main.GetItemString(1, "transfer_code").Trim();
//สมาชิกปกติ โอนธนาคาร
if (format_text == "003")
{
filename = "D00603";
}
else
{
//สมาชิกสมทบ โอนธนาคาร
filename = "D00703";
}
DStore = new DataStore();
DStore.LibraryList = WebUtil.PhysicalPath + @"Saving\DataWindow\keeping\kp_exp_savedisk.pbl";
DStore.DataWindowObject = "d_kp_dsksrv_linetext";
String ls_memberno, ls_space, ls_space1, ls_space2, ls_space3, ls_space4, ls_expaccid, ls_memname, ls_surname, ls_name;
int li_row, li_count, li_running;
Decimal ldc_moneyamt = 0, ldc_moneytotal = 0;
ldtm_trndate = Dw_main.GetItemDate(1, "operate_date");
ls_trndate = ldtm_trndate.ToString("ddMMyy");
ls_filename = filename + (ldtm_trndate.Year.ToString()) + ldtm_trndate.ToString("MMdd") + ".txt";
ls_path = WebUtil.PhysicalPath + @"Saving\filecommon\" + filename + (ldtm_trndate.Year.ToString()) + ldtm_trndate.ToString("MMdd") + ".txt";
//Header
li_row = DStore.InsertRow(0);
li_running = 1;
ls_space = " ";
ls_space1 = " ";
String linetext = "H" + li_running.ToString("000000") + company_bank + company_accid + company_name + ls_space + ls_trndate + ls_space1;
DStore.SetItemString(li_row, "line_text", linetext);
li_count = Dw_detail.RowCount;
ls_space2 = " ";
ls_space3 = " ";
ls_space4 = " ";
//Detail
while (dtcbt.Next())
{
try { ls_memberno = dtcbt.GetString("member_no").Trim(); }
catch { ls_memberno = ""; }
//ตัดเลขสมาชิกเหลือ 6
ls_memberno = ls_memberno.Substring(2, 6);
try { ls_expaccid = dtcbt.GetString("expense_accid").Trim(); }
catch { ls_expaccid = ""; }
try { ls_name = dtcbt.GetString("memb_name").Trim(); }
catch { ls_name = ""; }
try { ls_surname = dtcbt.GetString("memb_surname").Trim(); }
catch { ls_surname = ""; }
ls_memname = ls_name + " " + ls_surname;
try { ldc_moneyamt = dtcbt.GetDecimal("total"); }
catch { ldc_moneyamt = 0; }
ldc_moneytotal = ldc_moneytotal + ldc_moneyamt;
li_row = DStore.InsertRow(0);
linetext = "D" + li_row.ToString("000000") + company_bank + ls_expaccid + "D" + (ldc_moneyamt * 100).ToString("000000000000") + transfer_code + "9" + ls_space2 + ldtm_trndate.ToString("yyMMdd") + ls_space3 + ls_memberno + " " + ls_memname;
DStore.SetItemString(li_row, "line_text", linetext);
}
//footer
li_row = DStore.InsertRow(0);
linetext = "T" + li_row.ToString("000000") + company_bank + company_accid + Dw_detail.RowCount.ToString("0000000") + (ldc_moneytotal * 100).ToString("000000000000000") + "0000000" + "000000000000000" + ls_space4;
DStore.SetItemString(li_row, "line_text", linetext);
DStore.SaveAs(ls_path, FileSaveAsType.Text, false);
LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกข้อมูลเสร็จแล้ว " + ls_filename + "");
JspostNewClear();
}
else
{
LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบข้อมูลที่ต้องการออก TextFile");
JspostNewClear();
}
}
//กรณีเป็นเงินเดือน
//if (format_text == "001" || format_text == "002")
//{
// //mai 570313
// //หาว่าแผ่น disk นั้น เอาเฉพาะปกติหรือสบทบ หรือทั้งสอง
// //Dw_detail.Reset();
// //DwUtil.RetrieveDataWindow(Dw_detail, pbl, null, recv_period);
//}
////กรณีเป็นโอน bank ต้องดึงตามสังกัดและmembtype
//else
//{
// // DwUtil.RetrieveDataWindow(Dw_detail, pbl, null, recv_period, format_text);
// //หา membgroup_code ของแผ่นดิสก์
// // ls_sql = Dw_detail.GetSqlSelect();
// // ls_sql = ls_sql + "AND KE.RECV_PERIOD = '" + recv_period + "'";
// // string memtype_all = "";
// // string sqlmemgroupall = "";
// // string sqlmemtypeall = "";
// // String sqlmembgroup = @"select membgroup_code from kpcfdiskmembgroup where disk_code = '" + format_text + "' and coop_id = '" + state.SsCoopId + "' order by disk_code,membgroup_code";
// // Sdt dtgroup = WebUtil.QuerySdt(sqlmembgroup);
// // //กรณีมีแถวข้อมูล
// // if (dtgroup.Rows.Count > 0)
// // {
// // sqlmemgroupall = " AND trim(KP.MEMBGROUP_CODE) in (select trim(membgroup_code) from kpcfdiskmembgroup where disk_code = '"+format_text+"')";
// // }
// // else
// // {
// // sqlca.Rollback();
// // }
// // //หา membtype_code ของแผ่นดิสก์
// // String sqlmembtype = @"select membtype_code from kpcfdiskmembtype where disk_code = '" + format_text + "' and coop_id = '" + state.SsCoopId + "' order by disk_code,membtype_code";
// // Sdt dtmembtype = WebUtil.QuerySdt(sqlmembtype);
// // //กรณีมีแถวข้อมูล
// // if (dtmembtype.Rows.Count > 0)
// // {
// // sqlmemgroupall = " AND MM.MEMBTYPE_CODE in (select membtype_code from kpcfdiskmembtype where disk_code = '" + format_text + "')";
// // }
// // else
// // {
// // sqlca.Rollback();
// // }
// // ls_sql = ls_sql + sqlmemgroupall + sqlmemtypeall;
// // Dw_detail.SetTransaction(sqlca);
// // Dw_detail.SetSqlSelect(ls_sql);
// //// DwUtil.RetrieveDataWindow(Dw_detail, pbl, null, null);
// // Dw_detail.Retrieve();
//}
//HdRowCount.Value = Dw_detail.RowCount.ToString();
}
catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
}
//private void JsChangeDataWindow()
//{
// try
// {
// String format_text = Dw_choice.GetItemString(1, "format_text");
// //String member_type = Dw_main.GetItemString(1, "member_type");
// //กรณีเป็นเงินเดือน สมาชิกปกติ
// if (format_text == "001")
// {
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_sal_1";
// }
// //กรณีเป็นเงินเดือน สมาชิกสมทบ
// else if (format_text == "002")
// {
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_sal_2";
// }
// //กรณีเป็นเงินฝาก สมาชิกปกติ
// else if (format_text == "003")
// {
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_cbt_1";
// }
// //กรณีเป็นเงินฝาก สมาชิกสมทบ
// else if (format_text == "004")
// {
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_cbt_2";
// }
// // Dw_detail.Reset();
// }
// catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
//}
private void JspostChangeOption()
{
try
{
String format_text = Dw_choice.GetItemString(1, "format_text");
//กรณีเป็นเงินเดือน 001,002
if (format_text == "001" || format_text == "002")
{
Dw_main.DataWindowObject = "d_kp_exp_savedisk_option";
}
//กรณีเป็นเงินธนาคาร 003,004
else
{
Dw_main.DataWindowObject = "d_kp_exp_savedisk_option_tdp";
}
JspostSetData();
//mai แก้ไข datawindow
//กรณีเป็นเงินเดือน สมาชิกปกติ
//if (format_text == "001")
//{
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_sal_1";
//}
////กรณีเป็นเงินเดือน สมาชิกสมทบ
//else if (format_text == "002")
//{
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_sal_2";
//}
////กรณีเป็นเงินฝาก สมาชิกปกติ
//else if (format_text == "003")
//{
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_cbt_1";
//}
////กรณีเป็นเงินฝาก สมาชิกสมทบ
//else if (format_text == "004")
//{
// Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_cbt_2";
//}
//mai แก้ไข 570313
if (format_text == "001" || format_text == "002")
{
Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_tmt";
}
else
{
Dw_detail.DataWindowObject = "d_kp_exp_savedisk_data_cbt";
}
}
catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
}
private void JspostSetData()
{
try
{
String format_text = Dw_choice.GetItemString(1, "format_text");
//SAL เงินเดือน
if (format_text == "001" || format_text == "002")
{
Dw_main.Reset();
Dw_main.InsertRow(0);
Dw_main.SetItemString(1, "year", Convert.ToString(DateTime.Now.Year + 543));
Dw_main.SetItemString(1, "month", Convert.ToString(DateTime.Now.Month));
Dw_main.SetItemDate(1, "operate_date", state.SsWorkDate);
Dw_main.SetItemString(1, "data_code", "2490");
Dw_detail.Reset();
tDw_main.Eng2ThaiAllRow();
}
else
{
//CBT ธนาคาร
Dw_main.Reset();
Dw_main.InsertRow(0);
Dw_main.SetItemString(1, "year", Convert.ToString(DateTime.Now.Year + 543));
Dw_main.SetItemString(1, "month", Convert.ToString(DateTime.Now.Month));
Dw_main.SetItemDate(1, "operate_date", state.SsWorkDate);
DwUtil.RetrieveDDDW(Dw_main, "company_bank", pbl, null);
Dw_main.SetItemString(1, "company_bank", "034");
Dw_main.SetItemString(1, "company_accid", "010001007401");
Dw_main.SetItemString(1, "company_name", "SAVINGCOOP");
Dw_main.SetItemString(1, "transfer_type", "C");
//สมาชิกปกติบัญชี
if (format_text == "003")
{
Dw_main.SetItemString(1, "transfer_code", "06");
}
else
{
Dw_main.SetItemString(1, "transfer_code", "01");
}
Dw_detail.Reset();
tDw_main.Eng2ThaiAllRow();
}
}
catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message); }
}
public Sybase.DataWindow.Web.WebDataWindowControl Dw_choice { get; set; }
public Sybase.DataWindow.Web.WebDataWindowControl Dw_main { get; set; }
public Sybase.DataWindow.Web.WebDataWindowControl Dw_detail { get; set; }
}
}