C# DataRow.GetString方法代码示例

 public UserProfile Build_UserProfile(DataRow dr)
 {
     UserProfile user = new UserProfile();
     user.UserId = Convert.ToInt32(dr.Get<uint>("userId"));
     user.Nombre = dr.GetString("nombre");
     user.Empresa = dr.GetString("empresa");
     user.Website = dr.GetString("website1");
     return user;
 }

 protected virtual ForumCategory ParseBasicPageContentRow(DataRow dr)
 {
     var category = new ForumCategory()
     {
         Id = dr.Get<int>("CategoryId"),
         Name = dr.GetString("CategoryName"),
         Order = dr.Get<int>("CategoryOrder")
     };
     return category;
 }

        private static string InternalTextArea(Tk5FieldInfoEx field, DataRow row, HtmlAttribute addition, bool needId)
        {
            TkDebug.AssertArgumentNull(field, "field", null);

            HtmlAttributeBuilder builder = new HtmlAttributeBuilder();
            AddInputAttribute(field, builder);
            AddNormalAttribute(field, builder, field.NickName, needId);
            builder.Add(addition);

            return string.Format(ObjectUtil.SysCulture, "<textarea {0}>{1}</textarea>{2}",
                builder.CreateAttribute(), StringUtil.EscapeHtml(row.GetString(field.NickName)),
                ERROR_LABEL);
        }

    string CreateHeadAttrs(IFieldInfoEx field, int index, int sortField, DataRow sortRow)
    {
        HtmlAttributeBuilder builder = new HtmlAttributeBuilder();
        Tk5FieldInfoEx tk5Field = field.Convert<Tk5FieldInfoEx>();
        if (tk5Field.DataType == TkDataType.Text || (tk5Field.ListDetail != null && tk5Field.ListDetail.TextHead))
        {
            builder.Add("class", "text-left text-nowrap");
        }
        else
        {
            builder.Add("data-sort", index.ToString());
            string order = sortRow.GetString("Order");
            string sortClass = string.Empty;
            if (index == sortField)
            {
                order = order == "DESC" ? "ASC" : "DESC";
                sortClass = "sort-" + order;
            }
            builder.Add("data-order", order);
            builder.Add("class", HtmlUtil.MergeClass("text-left text-nowrap", sortClass.ToLower()));
        }

        return builder.CreateAttribute();
    }

        protected virtual Forum ParseForumDataRow(DataRow dr)
        {
            Forum f = new Forum();
            f.Name = dr.GetString("ForumName");
            f.Description = dr.GetString("ForumDescription");
            f.ShortName = dr.GetString("ForumShortName");
            f.Id = dr.Get<int>("ForumId");
            f.TopicCount = dr.Get<int>("ForumTopicCount");
            f.MessageCount = dr.Get<int>("ForumMessageCount");

            return f;
        }

 private Template ParseTemplateDataRow(DataRow dr)
 {
     Template t = new Template();
     t.Id = dr.Get<int>("TemplateId");
     t.Key = dr.GetString("TemplateKey");
     t.Description = dr.GetString("TemplateDescription");
     return t;
 }

 private static ProductType GetProductType(DataRow dr)
 {
     return new ProductType
     {
         Name= dr.GetString("ProductType"),
         ProviderName =  dr.GetString("ProviderName"),
         Id = dr.GetGuid("ProductTypeID"),
     };
 }

 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),
     };
 }

        public virtual Topic ParseBasicTopicDataRow(DataRow dr, bool parseAccessRights)
        {
            Topic t = new Topic();
            t.Id = dr.Get<int>("TopicId");
            t.Date = dr.GetDate("TopicCreationDate");
            t.Title = dr.GetString("TopicTitle");
            t.ShortName = dr.GetString("TopicShortName");
            t.Description = dr.GetString("TopicDescription");
            t.Replies = dr.Get<int>("TopicReplies");
            t.Views = dr.Get<int>("TopicViews");
            t.IsClosed = dr.Get<bool>("TopicIsClose");
            t.IsSticky = dr.GetNullable<int?>("TopicOrder") >= 0;
            if (parseAccessRights)
            {
                t.ReadAccessRole = dr.GetNullableStruct<UserRole>("ReadAccessGroupId");
                t.PostAccessRole = dr.Get<UserRole>("PostAccessGroupId");
            }

            return t;
        }

        private static string InternalCombo(Tk5FieldInfoEx field, string name, DataRow row, DataSet model, bool needId)
        {
            HtmlAttributeBuilder builder = new HtmlAttributeBuilder();
            AddNormalAttribute(field, builder, name, needId);

            TkDebug.AssertNotNull(field.Decoder, "Combo控件需要配置Decoder", field);
            DataTable codeTable = model.Tables[field.Decoder.RegName];
            StringBuilder options = new StringBuilder();
            if (field.IsEmpty)
            {
                string emptyTitle;
                if (field.Extension != null && field.Extension.EmptyTitle != null)
                    emptyTitle = field.Extension.EmptyTitle;
                else
                    emptyTitle = string.Empty;
                options.Append("<option value=\"\">").Append(emptyTitle).AppendLine("</option>");
            }
            string value = row.GetString(name);
            if (codeTable != null)
            {
                foreach (DataRow codeRow in codeTable.Rows)
                {
                    string codeValue = codeRow.GetString("Value");
                    options.AppendFormat(ObjectUtil.SysCulture, "<option value=\"{0}\"{1}>{2}</option>\r\n",
                        codeValue, codeValue == value ? " selected" : string.Empty,
                        codeRow.GetString("Name"));
                }
            }

            return string.Format(ObjectUtil.SysCulture, "<select {0}>{1}</select>{2}",
                builder.CreateAttribute(), options, ERROR_LABEL);
        }

        protected virtual User ParseUserInfo(DataRow dr)
        {
            User user = new User();
            user.Id = dr.Get<int>("UserId");
            user.UserName = dr.GetString("UserName");
            user.Role = dr.Get<UserRole>("UserGroupId");
            user.RoleName = dr.GetString("UserGroupName");
            user.RegistrationDate = dr.GetDate("UserRegistrationDate");

            decimal offSet = dr.Get<decimal>("UserTimeZone");
            user.TimeZone = new TimeSpan((long)(offSet * (decimal)TimeSpan.TicksPerHour));

            //se obtiene el perfil desde construnario
            UserProfileAcces profileaccess = new UserProfileAcces(MysqlconnectionString);
            user.Construnario_Profile = profileaccess.Get_UserProfilebyUserName(user.UserName );

            return user;
        }

		private void PrepareOutput(DataRow row)
		{
			if (OutputFields == null)
			{
				return;
			}
			foreach (string OutputField in OutputFields)
			{
				if (!string.IsNullOrEmpty(OutputField))
				{
					Outputs.Add(row.GetString(OutputField));
				}
			}
		}

        public static string Hidden(this Tk5FieldInfoEx field, DataRow row, bool needId)
        {
            TkDebug.AssertArgumentNull(field, "field", null);

            return InternalHidden(field, row.GetString(field.NickName), needId);
        }

        private static string InternalEasySearch(Tk5FieldInfoEx field, string nickName, DataRow row, bool needId)
        {
            HtmlAttributeBuilder hiddenBuilder = new HtmlAttributeBuilder();
            hiddenBuilder.Add("type", "hidden");
            hiddenBuilder.Add("value", row.GetString(nickName));
            string hiddenName = "hd" + nickName;
            if (needId)
                hiddenBuilder.Add("id", hiddenName);
            hiddenBuilder.Add("name", hiddenName);
            HtmlAttributeBuilder textBuilder = new HtmlAttributeBuilder();
            textBuilder.Add("type", "text");
            textBuilder.Add("data-regName", field.Decoder.RegName);
            AddInputAttribute(field, textBuilder);
            AddNormalAttribute(field, textBuilder, nickName, needId);
            textBuilder.Add("value", row.GetString(nickName + "_Name"));

            string easyUrl = "Library/WebModuleContentPage.tkx?Source=EasySearch&useSource=true".AppVirutalPath();
            string dialogUrl = ("Library/WebModuleRedirectPage.tkx?Source=EasySearchRedirect&useSource=true&RegName="
                + field.Decoder.RegName).AppVirutalPath();

            return string.Format(ObjectUtil.SysCulture, Html.EasySearch,
                hiddenBuilder.CreateAttribute(), textBuilder.CreateAttribute(), ERROR_LABEL,
                StringUtil.EscapeHtmlAttribute(easyUrl), StringUtil.EscapeHtmlAttribute(dialogUrl));
        }

 private static HtmlAttributeBuilder InternalCheckBox(Tk5FieldInfoEx field, DataRow row, bool needId)
 {
     string checkValue;
     string uncheckValue;
     GetCheckValue(field, out checkValue, out uncheckValue);
     HtmlAttributeBuilder builder = new HtmlAttributeBuilder();
     builder.Add("type", "checkbox");
     builder.Add("value", checkValue);
     builder.Add("data-uncheck-value", uncheckValue);
     if (row.GetString(field.NickName) == checkValue)
         builder.Add((HtmlAttribute)"checked");
     AddNormalAttribute(field, builder, field.NickName, needId, true);
     return builder;
 }