/// <summary>
        /// 得到客专ID
        /// </summary>
        /// <param name="context"></param>
        /// <returns></returns>
        private string GetKzId(HttpContext context)
        {
            string        AppNameOrWSpell = context.Request.Params["q"];
            StringBuilder builder         = new StringBuilder();

            if (String.IsNullOrEmpty(AppNameOrWSpell) == false)
            {
                CORPINFO     bu1  = new CORPINFO();
                TrainShouRu1 tsbu = new TrainShouRu1();

                List <SearchField> condition = new List <SearchField>();
                SearchField        search1   = new SearchField("ABBNAME", AppNameOrWSpell, SearchOperator.Contains);
                SearchField        search2   = new SearchField("WHOLESPELL", AppNameOrWSpell, SearchOperator.Contains);
                SearchField        search3   = new SearchField("CORPNAME", AppNameOrWSpell, SearchOperator.Contains);

                condition.Add(search1 | search2 | search3);
                int       rows = 0;
                DataTable dt   = bu1.GetListData(condition, -1, -1, out rows);
                //DataTable newdt = this.SelectDistinct(dt, "NAME1");//返回过滤后的DataTable

                foreach (DataRow dr in dt.Rows)
                {
                    DataTable dt1 = tsbu.GetkzList(dr["CORPNAME"].ToString());
                    if (dt1 != null)
                    {
                        foreach (DataRow dr1 in dt1.Rows)
                        {
                            builder.AppendLine(dr1["Title"].ToString().Trim());
                        }
                    }
                }
            }
            return(builder.ToString());
        }
Ejemplo n.º 2
0
        protected override void OnInit(EventArgs e)
        {
            //this.Repeater1.ItemCommand += new RepeaterCommandEventHandler(Repeater1_ItemCommand);
            this.Repeater1.ItemDataBound += new RepeaterItemEventHandler(Repeater1_ItemDataBound);
            this.Button1.Click           += new EventHandler(Button1_Click);
            this.Button2.Click           += new EventHandler(Button2_Click);
            this.dqhAll.CheckedChanged   += new EventHandler(dqhAll_CheckedChanged);
            TrainShouRu1 bu = new TrainShouRu1();

            dt = bu.GetkzList("");
            //CorpInfoBU bu = new CorpInfoBU();
            //dt = bu.GetCorpName();
            base.OnInit(e);
        }