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
 /// <summary>
 /// 调用Gf_CommonCodeSQL() 方法,利用BBB_CD表结构得到不带where条件的sql语句。
 /// </summary>
 /// <returns></returns>
 private string GetQuery()
 {
     return(DataDicCommon.Gf_CommonCodeSQL());
 }