Example #1
0
        /// <summary>
        /// 次方法针对Report Run后 提供调用列表的列表Code
        /// </summary>
        /// <param name="RP_Code"></param>
        /// <returns></returns>
        public string GetFields_List_Code(int RP_Code)
        {
            string        _eer  = "-1";
            bool          _In   = false;
            MD_UserEntity _user = BL_UserEntity.GetUserInfo();

            if (_user == null)
            {
                return(_eer);
            }
            Fields_list FL = _D_re.GetFields_list(RP_Code);

            if (FL == null || FL.List == null)
            {
                return(_eer);
            }

            if (Language.GetLang2() == EM_Language.en_us)
            {
                _In = true;
            }

            CT_Reports o = GetReplaceReport(_In, new CT_Param_Value()
            {
                RP_Code = RP_Code, PV_Type = 0, PV_CG_Code = -1, PV_UType = _user.User.UG_UType, PV_AD_OM_Code = _user.DealerEmpl.DE_AD_OM_Code
            });

            if (o == null)
            {
                return(_eer);
            }
            _D_re.insertReport_Hist(_user.User.AU_Code, RP_Code, o.RP_Query, o.RP_Name_EN, o.RP_Name_CN);
            return(FL.List[0].FL_Code.ToString());
        }
Example #2
0
        /// <summary>
        /// CT_Fields_list
        /// </summary>
        /// <param name="RP_Code"></param>
        /// <returns></returns>
        public Fields_list GetFields_list(int RP_Code)
        {
            string  sql = " SELECT FL.* FROM CT_Fields_lists FL INNER JOIN CT_Reports RP ON FL.FL_RP_Code=RP.RP_Code WHERE RP.RP_Code=" + RP_Code + ";";
            DataSet ds  = SqlHelper.ExecuteDataset(sql);

            Fields_list o = new Fields_list();

            o.List = DataHelper.ConvertToList <CT_Fields_list>(ds);
            return(o);
        }