using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Globalization;
using DataLibrary;
using System.Data;

namespace Saving.Applications.trading
{
    public partial class ws_sl_reprint2 : PageWebSheet, WebSheet
    {
        [JsPostBack]
        public string PostRetrieve { get; set; }
        [JsPostBack]
        public string PostPrint { get; set; }
        [JsPostBack]
        public string PostPrint2 { get; set; }

        TradingService _TradService = new TradingService();
        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
            dsList.InitDsList(this);
        }

        public void WebSheetLoadBegin()
        {
            if (!IsPostBack)
            {
                //dsMain.DdCode();
                dsMain.DATA[0].SLIP_DATE_E = _TradService.GetWorkDate(state.SsCoopId, state.SsStoreId);
                dsMain.DATA[0].SLIP_DATE_S = _TradService.GetWorkDate(state.SsCoopId, state.SsStoreId);
                string member_no = "";
                string entry_id = "";
                string sliptype_code = "";
                string document_no_s = "";
                string document_no_e = "";
                DateTime slip_date_s = dsMain.DATA[0].SLIP_DATE_S;
                DateTime slip_date_e = dsMain.DATA[0].SLIP_DATE_E;
 


                dsList.Retrieve(member_no, entry_id, sliptype_code, document_no_s, document_no_e, slip_date_s, slip_date_e);
                     
                     
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == PostRetrieve)
            {
                try
                {
                    string member_no = "";
                    string entry_id = "";
                    string sliptype_code = "";
                    string document_no_s = "";
                    string document_no_e = "";
                    DateTime slip_date_s = dsMain.DATA[0].SLIP_DATE_S;
                    DateTime slip_date_e = dsMain.DATA[0].SLIP_DATE_E;

                    member_no = dsMain.DATA[0].MEMBER_NO;
                   
                    document_no_s = dsMain.DATA[0].document_no_e;
                    document_no_e = dsMain.DATA[0].document_no_e;
                     

                        dsList.Retrieve(member_no, entry_id, sliptype_code, document_no_s, document_no_e, slip_date_s, slip_date_e);
                     
                     
                }
                catch { }
            } 
            else if (eventArg == PostPrint)
            {
                string rslip = "";
                int[] prt_arr = new int[dsList.RowCount];


                for (int i = 0; i < dsList.RowCount; i++)
                {
                    if (dsList.DATA[i].checkselect == 1)
                    {

                        string sql = @"select slip_no,stscales_slipone.member_no,mem_full,registration,price,weight_before,weight_after,weight_net,moisture_amt
,etc_amt,weight_balance,make_money,stscales_slipone.product_no,
make_money_text, mbmembmaster.membgroup_code ,product_desc ,'( '||TO_CHAR(time_before, 'HH24:MI')||' )' as time_before
,'( '||TO_CHAR(time_after, 'HH24:MI')||' )' as time_after,ft_cnvtdate(slip_date,3) as slip_date,
 ('หักน้ำหนักกระสอบ        '||weight_sack ||'    กก.')  as weight_sack, 'สหกรณ์การเกษตรแม่จัน จำกัด  สำนักงานใหญ่' as coop_name,
'47 หมู่ 8 ต.แม่จัน อ.แม่จัน จ.เชียงราย 57110  Tel. 053153696  Fax. 053653193' as addr_no,total_amt
from stscales_slipone inner join stproductmaster on stscales_slipone.product_no = stproductmaster.product_no 
inner join mbmembmaster on stscales_slipone.member_no = mbmembmaster.member_no  where stscales_slipone.coop_id = '" + state.SsCoopId + "' and slip_no = '" + dsList.DATA[i].SLIP_NO + "'";
                        DataTable data = WebUtil.Query(sql);
                        Printing.PrintApplet(this, "RECEIPT_SCALES2", data);
                       // Printing.PrintAppletPB(this, "RECEIPT_SCALES", data);

                    }
                }
               
            }
        }

        private static string XmlReadVar(string responseData, string szVar)
        {
            int i1stLoc = responseData.IndexOf("<" + szVar + ">");
            if (i1stLoc < 0)
                return string.Empty;
            int ilstLoc = responseData.IndexOf("</" + szVar + ">");
            if (ilstLoc < 0)
                return string.Empty;
            int len = szVar.Length;
            return responseData.Substring(i1stLoc + len + 2, ilstLoc - i1stLoc - len - 2);
        }

        public void SaveWebSheet()
        {

        }

        public void WebSheetLoadEnd()
        {

        }
    }
}