本文整理汇总了C#中System.Data.DataRow.GetInt方法的典型用法代码示例。如果您正苦于以下问题:C# DataRow.GetInt方法的具体用法?C# DataRow.GetInt怎么用?C# DataRow.GetInt使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataRow
的用法示例。
在下文中一共展示了DataRow.GetInt方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ParseContent
private string ParseContent(DataRow dr, string tempate, int rowcount)
{
var sOutput = tempate;
var replyId = dr.GetInt("ReplyId");
var topicId = dr.GetInt("TopicId");
var postId = replyId == 0 ? topicId : replyId;
var contentId = dr.GetInt("ContentId");
var dateCreated = dr.GetDateTime("DateCreated");
var dateUpdated = dr.GetDateTime("DateUpdated");
var authorId = dr.GetInt("AuthorId");
var username = dr.GetString("Username");
var firstName = dr.GetString("FirstName");
var lastName = dr.GetString("LastName");
var displayName = dr.GetString("DisplayName");
var userTopicCount = dr.GetInt("TopicCount");
var userReplyCount = dr.GetInt("ReplyCount");
var postCount = userTopicCount + userReplyCount;
var userCaption = dr.GetString("UserCaption");
var body = dr.GetString("Body");
var subject = dr.GetString("Subject");
var tags = dr.GetString("Tags");
var signature = dr.GetString("Signature");
var ipAddress = dr.GetString("IPAddress");
var memberSince = dr.GetDateTime("MemberSince");
var avatarDisabled = dr.GetBoolean("AvatarDisabled");
var userRoles = dr.GetString("UserRoles");
var isUserOnline = dr.GetBoolean("IsUserOnline");
var replyStatusId = dr.GetInt("StatusId");
var totalPoints = _enablePoints ? dr.GetInt("UserTotalPoints") : 0;
var answerCount = dr.GetInt("AnswerCount");
var rewardPoints = dr.GetInt("RewardPoints");
var dateLastActivity = dr.GetDateTime("DateLastActivity");
var signatureDisabled = dr.GetBoolean("SignatureDisabled");
// Populate the user object with the post author info.
var up = new User
{
UserId = authorId,
UserName = username,
FirstName = firstName.Replace("&#", "&#"),
LastName = lastName.Replace("&#", "&#"),
DisplayName = displayName.Replace("&#", "&#"),
Profile =
{
UserCaption = userCaption,
Signature = signature,
DateCreated = memberSince,
AvatarDisabled = avatarDisabled,
Roles = userRoles,
ReplyCount = userReplyCount,
TopicCount = userTopicCount,
AnswerCount = answerCount,
RewardPoints = rewardPoints,
DateLastActivity = dateLastActivity,
PrefBlockAvatars = UserPrefHideAvatars,
PrefBlockSignatures = UserPrefHideSigs,
IsUserOnline = isUserOnline,
SignatureDisabled = signatureDisabled
}
};
//Perform Profile Related replacements
sOutput = TemplateUtils.ParseProfileTemplate(sOutput, up, PortalId, ModuleId, ImagePath, CurrentUserType, true, UserPrefHideAvatars, UserPrefHideSigs, ipAddress, UserId, TimeZoneOffset);
// Replace Tags Control
if (string.IsNullOrWhiteSpace(tags))
sOutput = TemplateUtils.ReplaceSubSection(sOutput, string.Empty, "[AF:CONTROL:TAGS]", "[/AF:CONTROL:TAGS]");
else
{
sOutput = sOutput.Replace("[AF:CONTROL:TAGS]", string.Empty);
sOutput = sOutput.Replace("[/AF:CONTROL:TAGS]", string.Empty);
var tagList = string.Empty;
foreach (var tag in tags.Split(','))
{
if (tagList != string.Empty)
tagList += ", ";
tagList += "<a href=\"" + Utilities.NavigateUrl(TabId, string.Empty, new[] { ParamKeys.ViewType + "=search", ParamKeys.Tags + "=" + HttpUtility.UrlEncode(tag) }) + "\">" + tag + "</a>";
}
sOutput = sOutput.Replace("[AF:LABEL:TAGS]", tagList);
}
// Use a string builder from here on out.
var sbOutput = new StringBuilder(sOutput);
// Row CSS Classes
if (rowcount % 2 == 0)
{
sbOutput.Replace("[POSTINFOCSS]", "afpostinfo afpostinfo1");
sbOutput.Replace("[POSTTOPICCSS]", "afposttopic afpostreply1");
sbOutput.Replace("[POSTREPLYCSS]", "afpostreply afpostreply1");
}
else
{
sbOutput.Replace("[POSTTOPICCSS]", "afposttopic afpostreply2");
sbOutput.Replace("[POSTINFOCSS]", "afpostinfo afpostinfo2");
sbOutput.Replace("[POSTREPLYCSS]", "afpostreply afpostreply2");
}
//.........这里部分代码省略.........
示例2: BuildUser
static User BuildUser(DataRow r)
{
var firstName = r.GetString("FirstName");
var lastName = r.GetString("LastName");
return new User {
Id = r.GetInt("CustomerID"),
UserName = "{0}{1}".FormatWith(firstName, lastName),
FirstName = firstName,
LastName = lastName,
Email = r.GetString("EmailAddress"),
PasswordHash = r.GetString("PasswordHash"),
PasswordSalt = r.GetString("PasswordSalt")
};
}
示例3: GetProduct
private static Product GetProduct(DataRow dr)
{
return new Product
{
Sku = dr.GetString("SKU"),
GatewayId = dr.GetGuid("GatewayId"),
TypeId = dr.GetGuid("Type"),
TrialPeriodDays = dr.GetInt("TrialPeriodDays"),
InitialPrice = dr.GetDouble("InitialPrice"),
RecurringPrice = dr.GetDouble("RecurringPrice"),
SubscriptionDuration = dr.GetNullableInt("SubscriptionDuration"),
AvailableDuration = dr.GetNullableInt("AvailableDuration"),
LastUpdatedBy = dr.GetString("LastUpdatedBy"),
LastUpdatedOn = dr.GetDate("LastUpdatedOn"),
CreatedOn = dr.GetDate("CreatedOn"),
CreatedBy = dr.GetString("CreatedBy"),
RefId = dr.GetInt("RefId"),
IsCurrent = dr.GetBoolean("Current", false),
Active = dr.GetBoolean("Active", false),
};
}