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_oil_check
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.DSMAINDataTable DATA { get; set; }
        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DSMAIN;
            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 initstore_id()
        {
            String sql = @"select store_desc from ststore where coop_id={0} and store_id={1}";
            sql = WebUtil.SQLFormat(sql, state.SsCoopId, "001");
            Sdt dt = WebUtil.QuerySdt(sql);
            if (dt.Next())
            {
                DATA[0].store_id = dt.GetString("store_desc");
            }

        }
        public void DdProductgroup_Code()
        {
            String sql = @"SELECT to_char(operate_date,'DD/MM/YYYY') as operate_date, 1 as sorter
                            FROM stoilcheck WHERE COOP_ID ={0} group by operate_date
                            union select 'กรุณาเลือก',0 from dual order by sorter, operate_date
                            ";
            sql = WebUtil.SQLFormat(sql, state.SsCoopId);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "operate_date", "operate_date", "operate_date");
        }
    }
}