委托实例

遇到sql语句取出很多条数据的情况，页面显示需要分组的时候使用 #region GetIFDSpeedDial        public static IFDSpeedDialList GetIFDSpeedDial(int accountId)        {            IFDSpeedDialList speedDials = new IFDSpeedDialList();            string sql = string.Format(@"select * from mb_account_speed_dial where ACCTID=@acct_id order by Name");            try            {                DataSet ds = SqlHelper.ExecuteDataset(Conn.IOF, CommandType.Text, sql, iofHelper.NewParameter("@acct_id", accountId));                if (ds != null && ds.Tables[0].Rows.Count > 0)                {                    foreach (DataRow dr in ds.Tables[0].Rows)                    {   // 返回一个数组中的对象                        IFDSpeedDial speedDial = speedDials.SpeedDailList.Find(delegate(IFDSpeedDial p) { return p.PhoneNumber == dr["DNIS_OUT"].ToString(); });                        bool addSpeedDial = false;                        if (speedDial == null)                        {                            addSpeedDial = true;                            speedDial = new IFDSpeedDial();                            speedDial.CountryCode = dr["D_COUNTRY_CODE"].ToString();                            speedDial.PhoneNumber = dr["DNIS_OUT"].ToString();                            speedDial.Name = dr["NAME"].ToString();                        }                        if (dr["TYPE"].ToString() == "1")                        {                            speedDial.CallBackNumber = dr["SPEED_DIAL"].ToString();                            speedDial.CCountryCode = dr["S_COUNTRY_CODE"].ToString();                        }                        else                        {                            speedDial.SpeedDialNumber = dr["SPEED_DIAL"].ToString();                            speedDial.SCountryCode = dr["S_COUNTRY_CODE"].ToString();                        }                        if (addSpeedDial)                        {                            speedDials.SpeedDailList.Add(speedDial);                        }                    }                }                speedDials.BaseResult.Code = 0;            }            catch (Exception ex)            {                speedDials.BaseResult.Code = 401;                speedDials.BaseResult.Message = ex.Message + ex.StackTrace + ex.InnerException;                log.ErrorException("MoboHelper.GetIFDSpeedDial", ex);            }            return speedDials;        }        #endregion