Ejemplo n.º 1
0
        /// <summary>
        /// 根据代理机构代码返回MC
        /// </summary>
        /// <param name="_strAGNM"></param>
        /// <returns></returns>        
        public static string getAGame(string _strAGNM)
        {
            try
            {

                CfgDataManagerDataContext db = new CfgDataManagerDataContext();
                Table<ZPT_SJWH_DLJGPZB> tbZpt = db.ZPT_SJWH_DLJGPZB;

                var result = from item in tbZpt
                             where item.DAILIJGDM.Equals(_strAGNM.Trim())
                             select item;

                if (result.Count() > 0)
                {
                    return result.First().DAILIJGMC.Trim();
                }
                else
                {
                    return _strAGNM;
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex.ToString());
                return _strAGNM;
            }
        }
Ejemplo n.º 2
0
        static DmManager()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
            CfgDataManagerDataContext db = new CfgDataManagerDataContext();
            Table<CountryConfig> tbCountryConfig = db.CountryConfig;

            var result = from item in tbCountryConfig
                         select new
                         {
                             Key = item.DaiMa.Trim(),
                             Value = item.MingCheng.Trim(),
                         };
            DicGsDm = result.ToDictionary(c => c.Key, c => c.Value);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 获取用户自定义信息
        /// </summary>
        /// <param name="_strApNo"></param>
        /// <param name="_strUid"></param>
        /// <returns></returns>
        public static string getUsetInfo(string _strApNo, int _nUid)
        {
            string strInfo = "";
            try
            {
                CfgDataManagerDataContext db = new CfgDataManagerDataContext();
                Table<Tb_UsetPatentInfo> tbUsetInfo = db.Tb_UsetPatentInfo;

                strInfo = db.Tb_UsetPatentInfo.First(p => p.UId.Equals(_nUid) && p.ApNo.Equals(_strApNo)).Info;
            }
            catch (Exception ex)
            {
                logger.Error(ex.ToString());
            }
            return strInfo;
        }