本文整理汇总了C#中System.Data.SqlClient.SqlDataReader.SafeGetString方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDataReader.SafeGetString方法的具体用法？C# SqlDataReader.SafeGetString怎么用？C# SqlDataReader.SafeGetString使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlDataReader的用法示例。
在下文中一共展示了SqlDataReader.SafeGetString方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CopyFaqQuestionsToBO
public static FaqInfo CopyFaqQuestionsToBO(SqlDataReader rdr)
{
FaqInfo faqquestion = new FaqInfo
{
Id = rdr.GetInt32(0),
Link = rdr.SafeGetString(1),
LinkTitle = rdr.SafeGetString(2),
LinkBody = rdr.SafeGetString(3),
CatId = rdr.GetInt32(4),
Language = rdr.SafeGetString(5),
Order = rdr.GetInt32(6)
};
return faqquestion;
}示例2: CopyCategoryToBO
public static CategoryInfo CopyCategoryToBO(SqlDataReader rdr)
{
//CAT_ID, CAT_NAME, CAT_STATUS, CAT_MODERATION, CAT_SUBSCRIPTION, CAT_ORDER
CategoryInfo category = new CategoryInfo
{
Id = rdr.GetInt32(0),
Name = rdr.SafeGetString(1),
Status = rdr.GetInt16(2),
ModerationLevel = rdr.SafeGetInt32(3),
SubscriptionLevel = rdr.SafeGetInt32(4),
Order = rdr.GetInt32(5)
};
return category;
}示例3: CopyForumToBO
public static ForumInfo CopyForumToBO(SqlDataReader rdr)
{
//"F.FORUM_ID,F.CAT_ID,F.F_STATUS,F.F_SUBJECT,F.F_URL,F.F_TOPICS" +
//",F.F_COUNT,F.F_LAST_POST,F.F_PRIVATEFORUMS,F.F_TYPE,F.F_LAST_POST_AUTHOR,F.F_A_TOPICS,F.F_A_COUNT,F.F_MODERATION" +
//",F.F_SUBSCRIPTION,F.F_ORDER, F.F_COUNT_M_POSTS,F.F_LAST_POST_TOPIC_ID,F.F_LAST_POST_REPLY_ID,F.F_POLLS,F.F_DESCRIPTION" +
//",F.F_L_ARCHIVE,F.F_ARCHIVE_SCHED,T.T_SUBJECT,M.M_NAME ";
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.GetSnitzDate(7),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastArchived = rdr.GetSnitzDate(21),
ArchiveFrequency = rdr.SafeGetInt32(22),
LastPostSubject = rdr.SafeGetString(23),
LastPostAuthorName = rdr.SafeGetString(24)
};
return forum;
}示例4: CopyForumToBO
public static ForumInfo CopyForumToBO(SqlDataReader rdr)
{
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.SafeGetString(7).ToDateTime(),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastPostSubject = rdr.SafeGetString(21),
LastPostAuthorName = rdr.SafeGetString(22)
};
//if (forum.LastPostAuthorId != null)
//{
// var author = new PostAuthor().GetAuthor(forum.LastPostAuthorId.Value);
// forum.LastPostAuthor = author;
//}
return forum;
}示例5: CopyMemberToBO
public static MemberInfo CopyMemberToBO(SqlDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo
{
Id = rdr.GetInt32(0),
Status = rdr.GetInt16(1),
Username = rdr.GetString(2),
NTUsername = rdr.SafeGetString(3),
Email = rdr.SafeGetString(4),
Country = rdr.SafeGetString(5),
HomePage = rdr.SafeGetString(6),
Signature = rdr.SafeGetString(7),
MemberLevel = rdr.GetInt16(8),
AIM = rdr.SafeGetString(9),
Yahoo = rdr.SafeGetString(10),
ICQ = rdr.SafeGetString(11),
MSN = rdr.SafeGetString(12),
PostCount = rdr.SafeGetInt32(13) ?? 0,
MemberSince = rdr.SafeGetString(14).ToDateTime().Value,
LastVisitDate = rdr.SafeGetString(15).ToDateTime(),
LastPostDate = rdr.SafeGetString(16).ToDateTime(),
Title = rdr.SafeGetString(17), //MemberTitle(rdr.SafeGetString(17)),
AllowSubscriptions = (rdr["M_SUBSCRIPTION"] as int?) == 1,
HideEmail = (rdr["M_HIDE_EMAIL"] as int?) == 1,
ReceiveEmails = (rdr["M_RECEIVE_EMAIL"] as int?) == 1,
MembersIP = rdr.SafeGetString(21),
ViewSignatures = (rdr["M_VIEW_SIG"] as int?) == 1,
UseSignature = (rdr["M_SIG_DEFAULT"] as int?) == 1,
Voted = (rdr["M_VOTED"] as int?) == 1,
AllowEmail = (rdr["M_ALLOWEMAIL"] as int?) == 1,
Avatar = rdr.SafeGetString(26),
Theme = rdr.SafeGetString(27),
TimeOffset = rdr.GetInt32(28),
DateOfBirth = rdr.SafeGetString(29)
};
}
catch(Exception ex)
{
SqlDataReader rdrtest = rdr;
string test = ex.Message;
}
string title = member.Title;
member.Rank = new RankInfo(member.Username,ref title,member.PostCount);
member.Title = title;
return member;
}示例6: CopyTopicToBO
public static TopicInfo CopyTopicToBO(SqlDataReader rdr)
{
TopicInfo topic;
try
{
topic = new TopicInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
Status = rdr.GetInt16(3),
Subject = rdr.SafeGetString(4),
AuthorId = rdr.GetInt32(5),
ReplyCount = rdr.GetInt32(6),
Views = rdr.GetInt32(7),
LastPostDate = rdr.SafeGetString(8).ToDateTime(),
Date = rdr.SafeGetString(9).ToDateTime().Value,
PosterIp = rdr.SafeGetString(10),
LastPostAuthorId = rdr.SafeGetInt32(11),
IsSticky = rdr.GetInt16(12) == 1,
LastEditDate = rdr.SafeGetString(13).ToDateTime(),
LastEditedById = rdr.SafeGetInt32(14),
UseSignatures = rdr.GetInt16(15) == 1,
LastReplyId = rdr.SafeGetInt32(16),
UnModeratedReplies = rdr.GetInt32(17),
Message = rdr.SafeGetString(18)
};
if (rdr.FieldCount > 19)
{
topic.LastPostAuthorName = rdr.SafeGetString(19);
topic.AuthorName = rdr.SafeGetString(20);
topic.EditorName = rdr.SafeGetString(21);
if (rdr.FieldCount > 22)
{
topic.AuthorViewSig = rdr.GetInt16(22) == 1;
topic.AuthorSignature = rdr.SafeGetString(23);
}
}
}
catch (System.Exception)
{
return null;
}
return topic;
}示例7: CopySearchResultToBO
public static SearchResult CopySearchResultToBO(SqlDataReader rdr, ref int rowcount)
{
SearchResult result = new SearchResult()
{
CategoryStatus = rdr.GetInt16(1),
CategorySubscriptionLevel = rdr.GetInt32(2),
CategoryTitle = rdr.SafeGetString(3),
ForumSubject = rdr.SafeGetString(4),
ForumSubscriptionLevel = rdr.GetInt32(5),
ForumStatus = rdr.GetInt16(6),
ForumAccessType = rdr.GetInt32(7),
ForumPassword = rdr.SafeGetString(8),
CatId = rdr.GetInt32(9),
ForumId = rdr.GetInt32(10),
Id = rdr.GetInt32(11),
AuthorId = rdr.GetInt32(12),
Subject = rdr.SafeGetString(13),
Status = rdr.GetInt16(14),
LastPostDate = rdr.GetSnitzDate(15),
LastPostAuthorId = rdr.SafeGetInt32(16),
LastReplyId = rdr.SafeGetInt32(17),
ReplyCount = rdr.GetInt32(18),
UnModeratedReplies = rdr.GetInt32(19),
Views = rdr.GetInt32(20),
AuthorName = rdr.SafeGetString(22),
LastPostAuthorName = rdr.SafeGetString(23)
};
rowcount = rdr.GetInt32(24);
return result;
}示例8: CopyReplyToBO
public static ReplyInfo CopyReplyToBO(SqlDataReader rdr)
{
ReplyInfo reply = new ReplyInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
ForumId = rdr.GetInt32(2),
TopicId = rdr.GetInt32(3),
AuthorId = rdr.GetInt32(4),
Date = rdr.GetString(5).ToDateTime().Value,
PosterIp = rdr.SafeGetString(6),
Status = rdr.GetInt16(7),
LastEditDate = rdr.SafeGetString(8).ToDateTime(),
LastEditedById = rdr.SafeGetInt32(9),
UseSignatures = rdr.GetInt16(10) == 1,
Message = rdr.SafeGetString(11)
};
if (rdr.FieldCount > 12)
{
reply.AuthorName = rdr.SafeGetString(12);
reply.EditorName = rdr.SafeGetString(13);
reply.AuthorViewSig = rdr.GetInt16(14) == 1;
reply.AuthorSignature = rdr.SafeGetString(15);
}
return reply;
}示例9: CopyPrivateMessageToBO
public static PrivateMessageInfo CopyPrivateMessageToBO(SqlDataReader rdr)
{
//M_ID,M_SUBJECT,M_FROM,M_TO,M_SENT,M_MESSAGE,M_PMCOUNT,M_READ,M_MAIL,M_OUTBOX
PrivateMessageInfo pm = new PrivateMessageInfo()
{
Id = rdr.GetInt32(0),
Subject = rdr.SafeGetString(1),
FromMemberId = rdr.GetInt32(2),
ToMemberId = rdr.GetInt32(3),
SentDate = rdr.SafeGetString(4),
Message = rdr.SafeGetString(5),
Count = rdr.SafeGetString(6),
Read = rdr.GetInt32(7),
Mail = rdr.SafeGetString(8),
OutBox = rdr.GetInt32(9),
ToMemberName = rdr.SafeGetString(10),
FromMemberName = rdr.SafeGetString(11)
};
pm.Sent = pm.SentDate.ToDateTime();
return pm;
}示例10: SetupSalesArea
private void SetupSalesArea(SalesArea s, SqlDataReader r)
{
s.Id = r.SafeGetGuid(r.GetOrdinal("Id"));
s.OrderCode = r.SafeGetString(r.GetOrdinal("OrderCode"));
s.SalesAreaName = r.SafeGetString(r.GetOrdinal("SalesArea"));
}示例11: SetupPaymentTerm
private void SetupPaymentTerm(PaymentTerm p, SqlDataReader reader)
{
p.Id = reader.SafeGetGuid(reader.GetOrdinal("Id"));
p.Code = reader.SafeGetInt(reader.GetOrdinal("Code")).Value;
p.Description = reader.SafeGetString(reader.GetOrdinal("Description"));
}示例12: CopyEventToBO
private EventInfo CopyEventToBO(SqlDataReader rdr)
{
//Id,Title,Type,Audience,Author,EventDate,Description
EventInfo forumevent = new EventInfo
{
Id = rdr.GetInt32(0),
Title = rdr.SafeGetString(1),
Type = rdr.GetInt32(2),
Audience = rdr.SafeGetString(3),
MemberId = rdr.GetInt32(4),
Date = rdr.GetSnitzDate(5).Value,
Description = rdr.SafeGetString(6),
RecurringFrequency = (RecurringFrequencies) rdr.SafeGetInt32(7)
};
var mem = new Member();
forumevent.Author = new AuthorInfo(mem.GetById(forumevent.MemberId));
return forumevent;
}示例13: CopyMemberToBO
public static MemberInfo CopyMemberToBO(SqlDataReader rdr)
{
MemberInfo member = null;
try
{
member = new MemberInfo
{
Id = rdr.GetInt32(0),
Status = rdr.SafeGetInt16(1),
Username = rdr.SafeGetString(2),
NTUsername = rdr.SafeGetString(3),
Email = rdr.SafeGetString(4),
Country = rdr.SafeGetString(5),
HomePage = rdr.SafeGetString(6),
Signature = rdr.SafeGetString(7),
MemberLevel = rdr.SafeGetInt16(8),
AIM = rdr.SafeGetString(9),
Yahoo = rdr.SafeGetString(10),
ICQ = rdr.SafeGetString(11),
Skype = rdr.SafeGetString(12),
PostCount = rdr.SafeGetInt32(13) ?? 0,
MemberSince = rdr.GetSnitzDate(14).Value,
LastVisitDate = rdr.GetSnitzDate(15),
LastPostDate = rdr.GetSnitzDate(16),
Title = rdr.SafeGetString(17), //MemberTitle(rdr.SafeGetString(17)),
AllowSubscriptions = rdr.SafeGetInt16(18) == 1,
HideEmail = rdr.SafeGetInt16(19) == 1,
ReceiveEmails = rdr.SafeGetInt16(20) == 1,
MembersIP = rdr.SafeGetString(21),
ViewSignatures = rdr.SafeGetInt16(22) == 1,
UseSignature = rdr.SafeGetInt16(23) == 1,
Voted = rdr.SafeGetInt16(24) == 1,
AllowEmail = rdr.SafeGetInt16(25) == 1,
Avatar = rdr.SafeGetString(26),
Theme = rdr.SafeGetString(27),
TimeOffset = rdr.SafeGetDouble(28),
DateOfBirth = rdr.SafeGetString(29),
Age = rdr.SafeGetString(30),
Password = rdr.GetString(31),
ValidationKey = rdr.SafeGetString(32),
IsValid = rdr.SafeGetInt16(33) == 1,
LastUpdateDate = rdr.GetSnitzDate(34),
MaritalStatus = rdr.SafeGetString(35),
Firstname = rdr.SafeGetString(36),
Lastname = rdr.SafeGetString(37),
Occupation = rdr.SafeGetString(38),
Gender = rdr.SafeGetString(39),
Hobbies = rdr.SafeGetString(40),
LatestNews = rdr.SafeGetString(41),
FavouriteQuote = rdr.SafeGetString(42),
Biography = rdr.SafeGetString(43),
FavLink1 = rdr.SafeGetString(44),
FavLink2 = rdr.SafeGetString(45),
City = rdr.SafeGetString(46),
State = rdr.SafeGetString(47),
UseDaylightSaving = rdr.SafeGetInt16(48) == 1,
TimeZone = rdr.SafeGetString(49)
};
}
catch(Exception ex)
{
//SqlDataReader rdrtest = rdr;
//string test = ex.Message;
}
string title = member.Title;
//member.Rank = new RankInfo(member.Username,ref title,member.PostCount);
member.Title = title;
return member;
}示例14: CopyPrivateMessageToBO
public static PrivateMessageInfo CopyPrivateMessageToBO(SqlDataReader rdr)
{
PrivateMessageInfo pm = new PrivateMessageInfo
{
Id = rdr.GetInt32(0),
Subject = rdr.SafeGetString(1),
FromMemberId = rdr.GetInt32(2),
ToMemberId = rdr.GetInt32(3),
SentDate = rdr.SafeGetString(4),
Message = rdr.SafeGetString(5),
Count = rdr.SafeGetString(6),
Read = rdr.GetInt32(7),
//Mail = Convert.ToInt32(rdr.SafeGetString(8)),
OutBox = rdr.SafeGetInt16(9),
ToMemberName = rdr.SafeGetString(10),
FromMemberName = rdr.SafeGetString(11)
};
pm.Sent = pm.SentDate.ToDateTime();
return pm;
}示例15: SetupContractor
private void SetupContractor(Contractor c, SqlDataReader reader)
{
c.Id = reader.SafeGetGuid(reader.GetOrdinal("Id")).Value;
c.Name = reader.SafeGetString(reader.GetOrdinal("Name"));
c.Ref = reader.SafeGetString(reader.GetOrdinal("Ref"));
c.Mobile = reader.SafeGetInt64(reader.GetOrdinal("Mobile"));
c.SalesAreaName = reader.SafeGetString(reader.GetOrdinal("SalesArea"));
c.TravelDistance = reader.SafeGetInt(reader.GetOrdinal("TravelDistance")).Value;
c.TravelTime = reader.SafeGetInt(reader.GetOrdinal("TravelTime")).Value;
}