Exemple #1
0
        /////////1023
        public static void Gf_CommonCode_DD_SP(Control oSpread, int code_col, int name_col, string cd_mana_no, string sFilter, string sAuthority, Collection Sc)
        {
            Collection rControl = new Collection();

            rControl.Add(code_col, null, null, null);



            Collection fControl = new Collection();

            fControl.Add("CD", null, null, null);
            if (name_col > -1)
            {
                rControl.Add(name_col, null, null, null);
                fControl.Add("CD_NAME", null, null, null);
            }


            string sJoin = " CD_MANA_NO = \'" + cd_mana_no + "\' ";

            if ((sFilter != null) && sFilter.Trim().Length > 0)
            {
                sJoin += (string)(" AND " + sFilter);
            }
            DataDicCommon.Gf_Spread_DD(oSpread, rControl, fControl, DataDicCommon.Gf_CommonCodeSQL(), "", 0, sJoin, code_col, sAuthority, Sc);
        }
Exemple #2
0
        //1023

        public static void Gf_EtcCommon_DD_SP(Control oSpread, int code_col, int name_col, string code_field, string name_field, string sQuery, string sFilter)
        {
            Collection rControl = new Collection();

            rControl.Add(code_col, null, null, null);
            if (name_col > -1)
            {
                rControl.Add(name_col, null, null, null);
            }

            Collection fControl = new Collection();

            fControl.Add(code_field, null, null, null);
            fControl.Add(name_field, null, null, null);

            DataDicCommon.Gf_Spread_DD(oSpread, rControl, fControl, sQuery, "", 0, sFilter, 1);
        }
Exemple #3
0
        //1023
        public static void Gf_EtcCommon_DD_SP(Control oSpread, Collection rc, Collection fc, string sQuery, string sFilter, string sAuthority, Collection Sc)
        {
            string col = rc[1].ToString();

            DataDicCommon.Gf_Spread_DD(oSpread, rc, fc, sQuery, "", 0, sFilter, int.Parse(col), sAuthority, Sc);
        }