C# IRecord.GetStringOrEmpty方法代码示例

        internal static void MapBandInfoList(IRecord record, List<BandInfo> list)
        {
            BandInfo m = new BandInfo();
            m.BandId = record.GetInt32OrDefault(0, 0);
            m.BandName = record.GetStringOrEmpty(1);
            m.Info1 = record.GetStringOrEmpty(2);
            m.Info2 = record.GetStringOrEmpty(3);
            m.Info3 = record.GetStringOrEmpty(4);
            m.Remark = record.GetStringOrEmpty(5);

            list.Add(m);
        }

        internal static void MapSeachResultList(IRecord record, List<SearchResult> list,ObjectTypeDefine objectType)
        {
            SearchResult m = new SearchResult();
            m.ObjectType = objectType;
            m.ObjectId = record.GetInt32OrDefault(0, 0);
            m.Title = record.GetStringOrEmpty(1);
            m.Body = record.GetStringOrEmpty(2);
            m.SImage = record.GetStringOrEmpty(3);
            m.BandId = record.GetInt32OrDefault(4, 0);
            m.PublishDate = record.GetDateTimeOrEmpty(5);

            list.Add(m);
        }

 internal static void MapList(IRecord record, List<SpamKeyword> list)
 {
     SpamKeyword m = new SpamKeyword();
     m.Id = record.GetInt32OrDefault(0, 0);
     m.Keyword = record.GetStringOrEmpty(1);
     m.Status = record.GetInt32OrDefault(2, 0);
     m.AddUserID = record.GetInt32OrDefault(3, 0);
     m.AddDate = record.GetDateTime(4);
     list.Add(m);
 }

 internal static void MapList(IRecord record, List<ShopRegion> list)
 {
     ShopRegion m = new ShopRegion();
     m.Id = record.GetInt32OrDefault(0, 0);
     m.Name = record.GetStringOrEmpty(1);
     m.ParentId = record.GetInt32OrDefault(2, 0);
     m.TransferPrice = record.GetDouble(3);
     m.TransferPrice1 = record.GetDouble(4);
     m.TransferPrice2 = record.GetDouble(5);
     list.Add(m);
 }

 internal static void MapList(IRecord record, List<Show> list)
 {
     Show m = new Show();
     m.ShowId = record.GetInt32OrDefault(0, 0);
     m.Title = record.GetStringOrEmpty(1);
     m.Body = record.GetStringOrEmpty(2);
     m.SImage = record.GetStringOrEmpty(3);
     m.LImage = record.GetStringOrEmpty(4);
     m.BandId = record.GetInt32OrDefault(5, 0);
     m.ShowDate = record.GetDateTime(6);
     m.ShowPlace = record.GetStringOrEmpty(7);
     m.AddUserID = record.GetInt32OrDefault(8, 0);
     m.AddDate = record.GetDateTime(9);
     m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0));
     m.EndDate = record.GetDateTime(11);
     list.Add(m);
 }

        internal static void MapMusicTitleList(IRecord record, List<MusicTitle> list)
        {
            MusicTitle m = new MusicTitle();
            m.MusicId = record.GetInt32OrDefault(0, 0);
            m.Title = record.GetStringOrEmpty(1);
            m.Body = record.GetStringOrEmpty(2);
            m.SImage = record.GetStringOrEmpty(3);
            m.LImage = record.GetStringOrEmpty(4);
            m.BandId = record.GetInt32OrDefault(5, 0);
            m.PublishDate = record.GetDateTime(6);
            m.PublishYear = record.GetInt32OrDefault(7, 0);
            m.AddUserID = record.GetInt32OrDefault(8, 0);
            m.AddDate = record.GetDateTime(9);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(10, 0));

            list.Add(m);
        }

        internal static void MapMusicSongList(IRecord record, List<MusicSongList> list)
        {
            MusicSongList m = new MusicSongList();
            m.ListId = record.GetInt32OrDefault(0, 0);
            m.MusicId = record.GetInt32OrDefault(1, 0);
            m.SongName = record.GetStringOrEmpty(2);
            m.SongFile = record.GetStringOrEmpty(3);
            m.SongTime = record.GetStringOrEmpty(4);
            m.AddUserID = record.GetInt32OrDefault(5, 0);
            m.AddDate = record.GetDateTime(6);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(7, 0));

            list.Add(m);
        }

        internal static void MapImageList(IRecord record, List<Image> list)
        {
            Image m = new Image();

            m.ImageId = record.GetInt32OrDefault(0, 0);
            m.AlbumId = record.GetInt32OrDefault(1, 0);
            m.ImageName = record.GetStringOrEmpty(2);
            m.ImageFile = record.GetStringOrEmpty(3);
            m.AddUserID = record.GetInt32OrDefault(4, 0);
            m.AddDate = record.GetDateTime(5);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(6, 0));
            m.SImageFile = record.GetStringOrEmpty(7);
            m.PublishDate = record.GetDateTimeOrEmpty(8);
            list.Add(m);
        }

        internal static void MapAlbumList(IRecord record, List<Album> list)
        {
            Album m = new Album();
            m.AlbumId = record.GetInt32OrDefault(0, 0);
            m.Title = record.GetStringOrEmpty(1);
            m.BandId = record.GetInt32OrDefault(2, 0);
            m.PublishDate = record.GetDateTime(3);
            m.PublishYear = record.GetInt32OrDefault(4, 0);
            m.PublishMonth = record.GetInt32OrDefault(5, 0);
            m.AddUserID = record.GetInt32OrDefault(6, 0);
            m.AddDate = record.GetDateTime(7);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(8, 0));
            m.TotalCount = record.GetInt32OrDefault(9, 0);
            m.SImage = record.GetStringOrEmpty(10);
            m.LImage = record.GetStringOrEmpty(11);

            list.Add(m);
        }

        internal static void MapList(IRecord record, List<News> list)
        {
            News m = new News();
            m.NewsId = record.GetInt32OrDefault(0, 0);
            m.Title = record.GetStringOrEmpty(1);
            m.Body = record.GetStringOrEmpty(2);
            m.Preview = record.GetStringOrEmpty(3);
            m.SImage = record.GetStringOrEmpty(4);
            m.LImage = record.GetStringOrEmpty(5);
            m.NewsType = record.GetInt32OrDefault(6, 0);
            m.Hits = record.GetInt32OrDefault(7, 0);
            m.PublishDate = record.GetDateTime(8);
            m.AddUserID = record.GetInt32OrDefault(9, 0);
            m.AddDate = record.GetDateTime(10);
            m.Status = (PublishStatus)(record.GetInt32OrDefault(11, 0));
            m.Remark = record.GetStringOrEmpty(12);

            list.Add(m);
        }

        internal static void MapUserInfo(IRecord record, DiscuzUserInfo userinfo)
        {
            int offset = 0;
            userinfo.Uid = record.GetInt32(offset++);// Int32.Parse(reader["uid"].ToString());
            userinfo.Username = record.GetStringOrEmpty(offset++);// reader["username"].ToString();
            userinfo.Nickname = record.GetStringOrEmpty(offset++);//reader["nickname"].ToString();
            userinfo.Password = record.GetStringOrEmpty(offset++);//reader["password"].ToString();
            userinfo.Secques = record.GetStringOrEmpty(offset++);//reader["secques"].ToString();
            userinfo.Gender = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["gender"].ToString());
            userinfo.Adminid = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["adminid"].ToString());
            userinfo.Groupid = record.GetInt16OrDefault(offset++, 0);// Int16.Parse(reader["groupid"].ToString());
            userinfo.Groupexpiry = record.GetInt32OrDefault(offset++, 0);//  Int32.Parse(reader["groupexpiry"].ToString());
            userinfo.Extgroupids = record.GetStringOrEmpty(offset++);// reader["extgroupids"].ToString();
            userinfo.Regip = record.GetStringOrEmpty(offset++);// reader["regip"].ToString();
            userinfo.Joindate = record.GetDateTimeOrEmpty(offset++);// reader["joindate"].ToString();
            userinfo.Lastip = record.GetStringOrEmpty(offset++);// reader["lastip"].ToString();
            userinfo.Lastvisit = record.GetDateTimeOrEmpty(offset++);//reader["lastvisit"].ToString();
            userinfo.Lastactivity = record.GetDateTimeOrEmpty(offset++);//reader["lastactivity"].ToString();
            userinfo.Lastpost = record.GetDateTimeOrEmpty(offset++);//reader["lastpost"].ToString();
            userinfo.Lastpostid = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["lastpostid"].ToString());
            userinfo.Lastposttitle = record.GetStringOrEmpty(offset++);// reader["lastposttitle"].ToString();
            userinfo.Posts = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["posts"].ToString());
            userinfo.Digestposts = record.GetInt16OrDefault(offset++, 0);//Int16.Parse(reader["digestposts"].ToString());
            userinfo.Oltime = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["oltime"].ToString());
            userinfo.Pageviews = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["pageviews"].ToString());
            userinfo.Credits = record.GetDecimal(offset++); //Int32.Parse(reader["credits"].ToString());
            userinfo.Extcredits1 = record.GetDecimal(offset++);// float.Parse(reader["extcredits1"].ToString());
            userinfo.Extcredits2 = record.GetDecimal(offset++);//float.Parse(reader["extcredits2"].ToString());
            userinfo.Extcredits3 = record.GetDecimal(offset++);//float.Parse(reader["extcredits3"].ToString());
            userinfo.Extcredits4 = record.GetDecimal(offset++);//float.Parse(reader["extcredits4"].ToString());
            userinfo.Extcredits5 = record.GetDecimal(offset++);//float.Parse(reader["extcredits5"].ToString());
            userinfo.Extcredits6 = record.GetDecimal(offset++);//float.Parse(reader["extcredits6"].ToString());
            userinfo.Extcredits7 = record.GetDecimal(offset++);//float.Parse(reader["extcredits7"].ToString());
            userinfo.Extcredits8 = record.GetDecimal(offset++);// float.Parse(reader["extcredits8"].ToString());
            userinfo.Avatarshowid = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["avatarshowid"].ToString());
            userinfo.Email = record.GetStringOrEmpty(offset++);// reader["email"].ToString();
            userinfo.Bday = record.GetStringOrEmpty(offset++);// reader["bday"].ToString();
            userinfo.Sigstatus = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["sigstatus"].ToString());
            userinfo.Tpp = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["tpp"].ToString());
            userinfo.Ppp = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["ppp"].ToString());
            userinfo.Templateid = record.GetInt16OrDefault(offset++, 0); // Int16.Parse(reader["templateid"].ToString());
            userinfo.Pmsound = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["pmsound"].ToString());
            userinfo.Showemail = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["showemail"].ToString());
            userinfo.Invisible = record.GetInt32OrDefault(offset++, 0); // Int32.Parse(reader["invisible"].ToString());
            userinfo.Newpm = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["newpm"].ToString());
            userinfo.Newpmcount = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["newpmcount"].ToString());
            userinfo.Accessmasks = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["accessmasks"].ToString());
            userinfo.Onlinestate = record.GetInt32OrDefault(offset++, 0); //Int32.Parse(reader["onlinestate"].ToString());
            userinfo.Spaceid = record.GetInt32OrDefault(offset++, 0);// Int32.Parse(reader["spaceid"].ToString());
            userinfo.Newsletter = record.GetInt32OrDefault(offset++, 0); //(ReceivePMSettingType)Int32.Parse(reader["newsletter"].ToString());
            offset++;//fields.userid
            userinfo.Website = record.GetStringOrEmpty(offset++);
            userinfo.Icq = record.GetStringOrEmpty(offset++);
            userinfo.Qq = record.GetStringOrEmpty(offset++);
            userinfo.Yahoo = record.GetStringOrEmpty(offset++);
            userinfo.Msn = record.GetStringOrEmpty(offset++);
            userinfo.Skype = record.GetStringOrEmpty(offset++);
            userinfo.Location = record.GetStringOrEmpty(offset++);
            userinfo.Customstatus = record.GetStringOrEmpty(offset++);

            userinfo.Avatar = record.GetStringOrEmpty(offset++);
            userinfo.Avatarwidth = record.GetInt32OrDefault(offset++, 0);
            userinfo.Avatarheight = record.GetInt32OrDefault(offset++, 0);

            userinfo.Medals = record.GetStringOrEmpty(offset++);
            userinfo.Authstr = record.GetStringOrEmpty(offset++);
            userinfo.Authtime = record.GetDateTimeOrEmpty(offset++);
            userinfo.Authflag = record.GetByteOrDefault(offset++,0);
            userinfo.Bio = record.GetStringOrEmpty(offset++);
            userinfo.Signature = record.GetStringOrEmpty(offset++);
            userinfo.Sightml = record.GetStringOrEmpty(offset++);
            userinfo.Realname = record.GetStringOrEmpty(offset++);
            userinfo.Idcard = record.GetStringOrEmpty(offset++);
            userinfo.Mobile = record.GetStringOrEmpty(offset++);
            userinfo.Phone = record.GetStringOrEmpty(offset++);
        }

 internal static void MapList(IRecord record, List<ShopItem> list)
 {
     ShopItem m = new ShopItem();
     m.Id = record.GetInt32OrDefault(0, 0);
     m.Name = record.GetStringOrEmpty(1);
     m.Description = record.GetStringOrEmpty(2);
     m.Price = record.GetDouble(3);
     m.SImage = record.GetStringOrEmpty(4);
     m.LImage = record.GetStringOrEmpty(5);
     m.PublishDate = record.GetDateTimeOrEmpty(6);
     m.AddUserID = record.GetInt32OrDefault(7, 0);
     m.AddDate = record.GetDateTime(8);
     m.Status = (PublishStatus)(record.GetInt32OrDefault(9, 0));
     m.Body = record.GetStringOrEmpty(10);
     m.Hits = record.GetInt32OrDefault(11, 0);
     m.BaseCountEachdeliver = record.GetInt32OrDefault(12, 5);
     m.Weight = record.GetDouble(13);
     list.Add(m);
 }

 internal static void MapList(IRecord record, List<ShopOrder> list)
 {
     ShopOrder m = new ShopOrder();
     m.Id = record.GetInt32OrDefault(0, 0);
     m.UserId = record.GetInt32OrDefault(1, 0);
     m.AddDate = record.GetDateTimeOrEmpty(2);
     m.Ordertype = (OrderType)(record.GetInt32OrDefault(3, 0));
     m.Address = record.GetStringOrEmpty(4);
     m.Email = record.GetStringOrEmpty(5);
     m.Mobile = record.GetStringOrEmpty(6);
     m.Paymoney = record.GetDouble(7);
     m.Paytype = (PayType)(record.GetInt32OrDefault(8, 0));
     m.Payresult = (PayResult)(record.GetInt32OrDefault(9, 0));
     m.Payremark = record.GetStringOrEmpty(10);
     m.Paythirdnum = record.GetStringOrEmpty(11);
     m.Paydate = record.GetDateTime(12);
     m.ZipCode = record.GetStringOrEmpty(13);
     m.UserName = record.GetStringOrEmpty(14);
     m.RegionId = record.GetInt32OrDefault(15, 0);
     m.Freight = record.GetDouble(16);
      m.RegionStr = record.GetStringOrEmpty(17);
     list.Add(m);
 }