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

namespace Saving.CriteriaIReport.u_cri_coopid_storeid_date
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.DataTable1DataTable DATA { get; set; }
        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DataTable1;
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");
            this.Register();
        }
        public void initcoop_name()
        {
            String sql = @"select coop_name from cmcoopmaster where coop_id={0}";
            sql = WebUtil.SQLFormat(sql, state.SsCoopId);
            Sdt dt = WebUtil.QuerySdt(sql);
            if (dt.Next())
            {
                DATA[0].coop_id = dt.GetString("coop_name");
            }

        }
        public void DdStore_id()
        {
            String sql = @"SELECT store_id,store_desc, 2 as sorter
                            FROM ststore WHERE COOP_ID ={0} and store_id between '001' and '999'
                            union select '000' store_id , 'กรุณาเลือก' store_desc ,0 sorter from dual 
						 union select '0' store_id , '---- ทั้งหมด ----' store_desc ,1 sorter from dual order by sorter, store_id";
            sql = WebUtil.SQLFormat(sql, state.SsCoopId);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "store_id", "store_desc", "store_id");
        }
    }
}