不可调用成员';String.Length';不能像方法一样使用
本文关键字:方法 一样 不能 调用 成员 String Length | 更新日期: 2023-09-27 18:21:52
我正在尝试让一个脚本组件为我正在处理的HRIS包工作。我得到了一个不可调用的错误。我不熟悉C#,所以我不知道如何纠正这个问题。我正在处理一个fried,它修改了另一个STO成员之前给我的代码。
.Length();是导致冲突的原因,"for"语句末尾的"i"也是如此。
修改后的代码如下。
/* Microsoft SQL Server Integration Services Script Component
* Write scripts using Microsoft Visual C# 2008.
* ScriptMain is the entry point class of the script.*/
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
using System.Text.RegularExpressions;
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
public override void PreExecute()
{
base.PreExecute();
/*
Add your code here for preprocessing or remove if not needed
*/
}
public override void PostExecute()
{
base.PostExecute();
/*
Add your code here for postprocessing or remove if not needed
You can set read/write variables here, for example:
Variables.MyIntVar = 100
*/
}
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
const string pFirstName = @"^[A-Z]([-']?[a-z]+)*";
const string pSuffix = @"((Jr|Sr|I|V|X)( ?))+";
const string pInitial = @"(?<='s)[A-Z](?='s)";
const string pLastName = @"(?!(?:Jr|Sr|I|V|X|^))([A-Z][-''s]?[a-z]+)";
string fullName = Row.Name.ToString();
string firstName = Regex.Match(fullName, pFirstName).Value;
string suffix = Regex.Match(fullName, pSuffix).Value;
string initial = Regex.Match(fullName, pInitial).Value;
string lastName = Regex.Match(fullName, pLastName).Value;
/*
* 20130708 - Edited by Armando Allison
*
*
* 1. Get the length of the entire full name
* 2. Get the firstName length value
* 3. Get the initial length value
* 4. Get the suffix length value
* 5. Get the lastName length value
*
*
*/
int length_full = fullName.Length(); //length of fullName
int length_first = firstName.Length(); //length of the firstName
int length_suffix = suffix.Length(); //length of the suffix
int length_initial = initial.Length(); // length of the initial
int length_lastName = lastName.Length(); //length of the lastName
int compare_length = 0;
compare_length = length_full - (length_first - length_initial - length_suffix); // if it pulled the data correctly, lastName length should equal compare_length
if (length_lastName == compare_length)
{
if (!string.IsNullOrEmpty(initial))
lastName += " " + initial;
if (!string.IsNullOrEmpty(suffix))
lastName += " " + suffix;
Row.FirstName = firstName;
Row.LastName = lastName;
}
else
{
// if the lastName doesnt match the compare_length
// you will have to do some more editing.
// 1. put entire full name into a string array
// 2. remove all the suffix, initial, and firstName
// 3. then output the entire lastName in a for loop with the remaining full name array
// remove to remove the other parts of the array that is not needed
// Pseudo code
char[] entire_name;
entire_name = new char[length_full];
entire_name = fullName.ToCharArray(0, length_full);
for (i = compare_length; i < length_full - 1; i++)
{
lastName = (String)entire_name[i];
}
// loop entire array to include the entire full name
// next remove the parts of the array that is not needed
// then output just the last name with another for loop
}
}
}
Length()
不是一个方法,而是一个属性。只需使用不带括号的Length
。
Length是string类型的属性,因此请删除Paradishesion。只需致电:
suffix.Length;
还有
for(int i = compare_length; i < length_full - 1; i++)
{
//Do something
}
因为您必须在循环中将i定义为int。
另外,
lastName = (String)entire_name[i];
是错误的
用途:
lastName = entire_name[i].ToString();
编译错误对我来说似乎很清楚
int length_full = fullName.Length();
应该是:
int length_full = fullName.Length;
其他线路也是如此。这是因为String.Length
是一个属性,而不是一个方法。
除了修复代码外,你还应该再次查看编译错误,并找出为什么你觉得它令人困惑——这可能有助于你找到你应该更加熟悉的C#部分。我强烈建议您在之前更加熟悉C#的基础知识,否则您会对数据库等其他事情做太多的处理,这将使以后诊断任何问题变得更加容易。
Length
是一个属性,而不是函数。只需去掉括号。
Length
是一个属性,而不是一个方法,您可以省略()
:
int length_full = fullName.Length;
for循环末尾的"i"问题应该能够通过用替换循环声明来修复
for(int i = compare_length; i < length_full - 1; i++)
只使用下面显示的Length而不是Length()its not方法。
fullName.Length;