委托实例

最新推荐文章于 2025-08-08 12:35:56 发布

dannywj1371

最新推荐文章于 2025-08-08 12:35:56 发布

阅读量476

点赞数

CC 4.0 BY-SA版权

分类专栏： .NET 文章标签： dataset exception sql null string

本文链接：https://blog.youkuaiyun.com/dannywj1371/article/details/7754189

.NET 专栏收录该内容

106 篇文章

订阅专栏

遇到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