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;
using DataLibrary;

namespace Saving.Applications.trading.ws_td_product_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.DtdsMainDataTable DATA { get; set; }
        public void InitdsMain(PageWeb pw)
        {
            css1.Visible = false;
            css2.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DtdsMain;
            this.EventItemChanged = "OnDsMainChanged";
            this.EventClicked = "OnDsMainClicked";
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");
            this.Button.Add("bt_search_productno");
            this.Register();
        }


        public void RetrieveMain(string productno)
        {
            string sql = @"SELECT  STPRODUCTMASTER.PRODUCT_NO ,
                                   STPRODUCTMASTER.COOP_ID ,           
	                               STPRODUCTMASTER.TERMINAL_NO ,
                                   STPRODUCTMASTER.PRODUCT_DESC ,
                                   STPRODUCTMASTER.BUSSINESS_CODE ,
                                   STPRODUCTMASTER.PRODUCTGROUP_CODE ,
                                   STPRODUCTMASTER.PRODUCTTYPE_CODE ,
                                   STPRODUCTMASTER.DISCOUNT_CODE ,
                                   STPRODUCTMASTER.UNIT_CODE ,
                                   STPRODUCTMASTER.BRAND_NAME ,
                                   STPRODUCTMASTER.MODEL_NO ,
                                   STPRODUCTMASTER.BAR_CODE ,
                                   STPRODUCTMASTER.DEPT_FLAG ,
                                   STPRODUCTMASTER.PRODUCT_SET_FLAG ,
                                   '        ' as store_id,
                                        (select     max( a.debt_name ) from ststockslip a 
		                                 where      a.slip_no in ( select max( b.refdoc_no ) 
		                                 from       ststocklot b 
		                                 where      b.product_no = stproductmaster.product_no and 
		                                            b.coop_id = stproductmaster.coop_id and 
		                                            b.store_id = store_id and b.stocklot_status in ( '0' , '1' ) ) ) as lotname    
		                   FROM   STPRODUCTMASTER      WHERE ( STPRODUCTMASTER.PRODUCT_NO = {0} ) And
                                  (STPRODUCTMASTER.COOP_ID = {1} ) 
                           ORDER BY STPRODUCTMASTER.COOP_ID          ASC,
                                    STPRODUCTMASTER.PRODUCT_NO          ASC";
            sql = WebUtil.SQLFormat(sql, productno, state.SsCoopId);
            DataTable dt = WebUtil.Query(sql);
            if(dt.Rows.Count > 0)
            this.ImportData(dt);
        }

        public void DdBussiness(string coopid)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"
                            SELECT  trim(STBUSSINESS.BUSSINESS_CODE) as BUSSINESS_CODE,   
                                    STBUSSINESS.BUSSINESS_DESC,
                                    1 as sorter  
                            FROM    STBUSSINESS
                            WHERE   STBUSSINESS.COOP_ID = {0}
                            union select '','-- เลือก --',0 from STBUSSINESS order by sorter, BUSSINESS_CODE ASC";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "bussiness_code", "BUSSINESS_DESC", "BUSSINESS_CODE");
            }
            else
            {
                string sql = @"
                            SELECT  trim(STBUSSINESS.BUSSINESS_CODE) as BUSSINESS_CODE,   
                                    STBUSSINESS.BUSSINESS_DESC,
                                    1 as sorter  
                            FROM    STBUSSINESS
                            WHERE   STBUSSINESS.COOP_ID = {0}
                            union select '','-- เลือก --',0 from dual order by sorter, BUSSINESS_CODE ASC";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "bussiness_code", "BUSSINESS_DESC", "BUSSINESS_CODE");
            }
        }

        public void DdProducttype(string coopid, string PRODUCTGROUP_CODE)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"SELECT PRODUCTTYPE_CODE,PRODUCTTYPE_DESC, 1 as sorter
                            FROM STPRODUCTTYPE WHERE COOP_ID ={0} and trim(PRODUCTGROUP_CODE) = {1}
                            union select '','-- เลือก --',0 from STPRODUCTTYPE order by sorter, PRODUCTTYPE_CODE";
                sql = WebUtil.SQLFormat(sql, coopid, state.SsStoreId);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "producttype_code", "PRODUCTTYPE_DESC", "PRODUCTTYPE_CODE");
            }
            else
            {
                
                string sql = @"SELECT PRODUCTTYPE_CODE,PRODUCTTYPE_DESC, 1 as sorter
                            FROM STPRODUCTTYPE WHERE COOP_ID ={0} and trim(PRODUCTGROUP_CODE) = {1}
                            union select '','-- เลือก --',0 from dual order by sorter, PRODUCTTYPE_CODE";
                sql = WebUtil.SQLFormat(sql, coopid, PRODUCTGROUP_CODE);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "producttype_code", "PRODUCTTYPE_DESC", "PRODUCTTYPE_CODE");
                
            }
        }
        public void DdBussinessRE(string coopid, string bussiness_code) {
            string sql = @"select trim(bussiness_code) bussiness_code, bussiness_desc bussiness_desc
from stbussiness where coop_id = {0} and trim(bussiness_code) = {1}
union select bussiness_code ,bussiness_desc from stbussiness order by bussiness_code";
            sql = WebUtil.SQLFormat(sql, coopid, bussiness_code);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "BUSSINESS_CODE", "bussiness_desc", "bussiness_code");
        }

        public void DdProducttypeRE(string coopid, string producttype_code, string productgroup_code)
        {
            string sql = @"select trim(producttype_code) producttype_code, producttype_desc producttype_desc
from stproducttype where coop_id = {0} and trim(producttype_code) = {1}
union select producttype_code ,producttype_desc from stproducttype where productgroup_code = {2} order by producttype_code";
            sql = WebUtil.SQLFormat(sql, coopid, producttype_code, productgroup_code);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "producttype_code", "producttype_desc", "producttype_code");
        }

        public void DdProductsubtype(string coopid, string PRODUCTTYPE_CODE)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"SELECT trim( PRODUCTSUBTYPE_CODE) PRODUCTSUBTYPE_CODE,CONCAT(PRODUCTSUBTYPE_CODE,' ',PRODUCTSUBTYPE_DESC) PRODUCTSUBTYPE_DESC, 1 as sorter
                            FROM STPRODUCTSUBTYPE WHERE COOP_ID ={0} and trim(PRODUCTTYPE_CODE) = {1}
                            union select '','-- เลือก --',0 from STPRODUCTSUBTYPE order by sorter, PRODUCTSUBTYPE_CODE";
                sql = WebUtil.SQLFormat(sql, coopid, PRODUCTTYPE_CODE);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "PRODUCTSUBTYPE_CODE", "PRODUCTSUBTYPE_DESC", "PRODUCTSUBTYPE_CODE");
            }
            else
            {
                string sql = @"SELECT trim( PRODUCTSUBTYPE_CODE) PRODUCTSUBTYPE_CODE,trim(PRODUCTSUBTYPE_CODE || ' ' ||PRODUCTSUBTYPE_DESC) PRODUCTSUBTYPE_DESC, 1 as sorter
                            FROM STPRODUCTSUBTYPE WHERE COOP_ID ={0} and trim(PRODUCTTYPE_CODE) = {1}
                            union select '','-- เลือก --',0 from dual order by sorter, PRODUCTSUBTYPE_CODE";
                sql = WebUtil.SQLFormat(sql, coopid, PRODUCTTYPE_CODE);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "PRODUCTSUBTYPE_CODE", "PRODUCTSUBTYPE_DESC", "PRODUCTSUBTYPE_CODE");
            }

         }

        public void DdProductsubtypeDF()
        {
            string sql = @" select '-- เลือก --' PRODUCTSUBTYPE_DESC,0 PRODUCTSUBTYPE_CODE from dual ";
            sql = WebUtil.SQLFormat(sql);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "PRODUCTSUBTYPE_CODE", "PRODUCTSUBTYPE_DESC", "PRODUCTSUBTYPE_CODE");
        }

        public void DdTerminal(string coopid)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"
                             SELECT     STTERMINAL.TERMINAL_NO,   
                                        STTERMINAL.TERMINAL_NAME,
                                        1 as sorter  
                             FROM       STTERMINAL  
                             WHERE      STTERMINAL.COOP_ID = {0}
                                union select '','-- เลือก --',0 from STTERMINAL order by sorter, TERMINAL_NO";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "terminal_no", "TERMINAL_NAME", "TERMINAL_NO");
            }
            else
            {
                string sql = @"
                             SELECT     STTERMINAL.TERMINAL_NO,   
                                        STTERMINAL.TERMINAL_NAME,
                                        1 as sorter  
                             FROM       STTERMINAL  
                             WHERE      STTERMINAL.COOP_ID = {0}
                                union select '','-- เลือก --',0 from dual order by sorter, TERMINAL_NO";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "terminal_no", "TERMINAL_NAME", "TERMINAL_NO");
            }
        }

        public void DdDiscount(string coopid)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"
                             SELECT      STPRODUCTDISCOUNT.DISCOUNT_CODE,   
                                         STPRODUCTDISCOUNT.DISCOUNT_DESC,
                                         1 as sorter   
                             FROM        STPRODUCTDISCOUNT
                                union select '','-- เลือก --',0 from STPRODUCTDISCOUNT order by sorter, DISCOUNT_CODE"
                                ;
                sql = WebUtil.SQLFormat(sql);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "discount_code", "DISCOUNT_DESC", "DISCOUNT_CODE");
            }
            else
            {
                string sql = @"
                             SELECT      STPRODUCTDISCOUNT.DISCOUNT_CODE,   
                                         STPRODUCTDISCOUNT.DISCOUNT_DESC,
                                         1 as sorter   
                             FROM        STPRODUCTDISCOUNT
                                union select '','-- เลือก --',0 from dual order by sorter, DISCOUNT_CODE"
                                ;
                sql = WebUtil.SQLFormat(sql);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "discount_code", "DISCOUNT_DESC", "DISCOUNT_CODE");
            }
        }

        public void DdProductgroup(string coopid)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"SELECT trim(PRODUCTGROUP_CODE) as PRODUCTGROUP_CODE,trim(PRODUCTGROUP_DESC) as PRODUCTGROUP_DESC, 1 as sorter
                            FROM STPRODUCTGROUP WHERE COOP_ID ={0} and trim(PRODUCTGROUP_CODE) = {1}
                            union select '','-- เลือก --',0 from STPRODUCTGROUP order by sorter, PRODUCTGROUP_CODE";
                sql = WebUtil.SQLFormat(sql, coopid, state.SsStoreId);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "PRODUCTGROUP_CODE", "PRODUCTGROUP_DESC", "PRODUCTGROUP_CODE");
            }
            else
            {
                string sql = @"SELECT trim(PRODUCTGROUP_CODE) as PRODUCTGROUP_CODE,trim(PRODUCTGROUP_DESC) as PRODUCTGROUP_DESC, 1 as sorter
                            FROM STPRODUCTGROUP WHERE COOP_ID ={0}
                            union select '','-- เลือก --',0 from dual order by sorter, PRODUCTGROUP_CODE";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "PRODUCTGROUP_CODE", "PRODUCTGROUP_DESC", "PRODUCTGROUP_CODE");
            }
        }
        public void DdUnit(string coopid)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"SELECT UNIT_CODE,UNIT_DESC, 1 as sorter
                            FROM STPRODUCTUNIT WHERE COOP_ID ={0}
                            union select '','-- เลือก --',0 from STPRODUCTUNIT order by sorter, UNIT_CODE";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "unit_code", "UNIT_DESC", "UNIT_CODE");
            }
            else
            {
                string sql = @"SELECT UNIT_CODE,UNIT_DESC, 1 as sorter
                            FROM STPRODUCTUNIT WHERE COOP_ID ={0}
                            union select '','-- เลือก --',0 from dual order by sorter, UNIT_CODE";
                sql = WebUtil.SQLFormat(sql, coopid);
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "unit_code", "UNIT_DESC", "UNIT_CODE");
            }
        }
    }
}