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

namespace Saving.Applications.shrlon.ws_sl_npl_sue_baac_ctrl
{
    public partial class DsLaw : DataSourceFormView
    {
        public DataSet1.DT_LAWDataTable DATA { get; set; }

        public void InitDsLaw(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DT_LAW;
            this.EventItemChanged = "OnDsLawItemChanged";
            this.EventClicked = "OnDsLawClicked";
            this.InitDataSource(pw, FormView1, this.DATA, "dsLaw");
            this.TableName = "LNNPLSUE";
            this.Register();
        }

        public void Retrieve(string sue_no)
        {
            string sql = @" select  
                                    lnnplsue.coop_id ,
                                    lnnplsue.sue_no ,
                                    lnnplsue.court_name ,
                                    lnnplsue.judge_date ,
                                    lnnplsue.lawtype_code ,
                                    lnnplsue.caseblack_no ,
                                    lnnplsue.casered_no ,
                                    lnnplsue.workstep_code ,
                                    lnnplsue.debtclass_code ,
                                    lnnplsue.remark ,
                                    lnnplsue.judge_event ,
                                    lnnplsue.noticecontrol_date
                            from lnnplsue
                            where
                                    ( lnnplsue.sue_no = {1} and lnnplsue.coop_id = {0})";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl, sue_no);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
            //Ddlawtype();
            //Ddworkstep();
            //Dddebtclass();
        }


        //        public void Ddlawtype()
        //        {
        //            string sql = @"select
        //                                lawtype_code, lawtype_code||'  '||lawtype_desc as display
        //                                from lnucfnpllawtype
        //                               order by lawtype_code";
        //            DataTable dt = WebUtil.Query(sql);
        //            this.DropDownDataBind(dt, "lawtype_code", "display", "lawtype_code");

        //        }

        //        public void Ddworkstep()
        //        {
        //            string sql = @"select
        //                                workstep_code, workstep_code||'  '||workstep_desc as display, 1 as sorter
        //                                from lnucfnplworkstep
        //                                union
        //                                select '','',0 from dual order by sorter, workstep_code";
        //            DataTable dt = WebUtil.Query(sql);
        //            this.DropDownDataBind(dt, "workstep_code", "display", "workstep_code");

        //        }

        //        public void Dddebtclass()
        //        {
        //            string sql = @"select
        //                                debtclass_code, debtclass_code||'  '||debtclass_desc as display, 1 as sorter
        //                                from lnucfnpldebtclass
        //                                union
        //                                select '','',0 from dual order by sorter, debtclass_code";
        //            DataTable dt = WebUtil.Query(sql);
        //            this.DropDownDataBind(dt, "debtclass_code", "display", "debtclass_code");

        //        }

    }
}