刚看到网上一篇博文里用sql实现了行列转置sql server /只用一个pivot函数就可以实现sql server 很多行的复杂实现提到转置立刻想起还在求学阶段曾经做过的一个练习用c语言实现二维数组的转置相信大家都做过这个练习下面利用c#利器也实现一遍没有实际意义练练手而已
二维数组转置
Code
class Program
{
public static string[] Rotate(string[] array)
{
int x = arrayGetUpperBound(); //一维
int y = arrayGetUpperBound(); //二维
string[] newArray = new string[y + x + ]; //构造转置二维数组
for (int i = ; i <= x; i++)
{
for (int j = ; j <= y; j++)
{
newArray[j i] = array[i j];
}
}
return newArray;
}
static void Main(string[] args)
{
string[] array = new string[ ];
for (int i = ; i < ; i++)
{
for (int j = ; j < ; j++)
{
array[i j] = iToString() + jToString();
}
}
//显示原数组
ConsoleWriteLine(Source Array:);
for (int i = ; i < ; i++)
{
string soureResult = stringEmpty;
for (int j = ; j < ; j++)
{
soureResult += array[i j] + ;
}
ConsoleWriteLine(soureResult);
}
string[] newArray = Rotate(array);
//显示转置后的数组
ConsoleWriteLine(Destiney Array:);
for (int i = ; i < ; i++)
{
string dstResult = stringEmpty;
for (int j = ; j < ; j++)
{
dstResult += newArray[i j] + ;
}
ConsoleWriteLine(dstResult);
}
ConsoleReadLine();
}
}
二维数组列表List<>的转置
这个是想到在实际项目中操作集合经常用到泛型List顺便实现一下它的转置思路很简单根据我们已经实现了转置所以就要想方设法把泛型List转换成二维数组然后转置接着将转换后的数组再转换成泛型List呵呵笔者偷懒惯了其实应该还有其他的方法不管了先实现看下效果
Code
class Program
{
/// <summary>
/// 二维数组转置函数
/// </summary>
/// <param name=array></param>
/// <returns></returns>
public static string[] Rotate(string[] array)
{
int x = arrayGetUpperBound(); //一维
int y = arrayGetUpperBound(); //二维
string[] newArray = new string[y + x + ]; //构造转置二维数组
for (int i = ; i <= x; i++)
{
for (int j = ; j <= y; j++)
{
newArray[j i] = array[i j];
}
}
return newArray;
}
/// <summary>
/// 将二维列表(List)转换成二维数组二维数组转置然后将二维数组转换成列表
/// </summary>
/// <param name=original></param>
/// <returns></returns>
public static List<List<string>> Rotate(List<List<string>> original)
{
List<string>[] array = originalToArray();
List<List<string>> lists = new List<List<string>>();
if (arrayLength==)
{
throw new IndexOutOfRangeException(Index OutOf Range);
}
int x = array[]Count;
int y = originalCount;
//将列表抓换成数组
string[] twoArray = new string[y x];
for (int i = ; i < y; i++)
{
int j = ;
foreach (string s in array[i])
{
twoArray[i j] = s;
j++;
}
}
string[] newTwoArray = new string[x y];
newTwoArray = Rotate(twoArray);//转置
//二维数组转换成二维List集合
for (int i = ; i < x; i++)
{
List<string> list = new List<string>();
for (int j = ; j < y; j++)
{
listAdd(newTwoArray[i j]);
}
listsAdd(list);
}
return lists;
}
static void Main(string[] args)
{
List<List<string>> sourceList = new List<List<string>>(); //测试的二维List
for (int i = ; i < ; i++)
{
List<string> list = new List<string>();
for (int j = ; j < ; j++)
{
listAdd(iToString() + jToString());
}
sourceListAdd(list);
}
//显示原列表
ConsoleWriteLine(Source List:);
for (int i = ; i < sourceListCount; i++)
{
string soureResult = stringEmpty;
for (int j = ; j < sourceList[i]Count; j++)
{
soureResult += sourceList[i][j] + ;
}
ConsoleWriteLine(soureResult);
}
List<List<string>> dstList = Rotate(sourceList);
//显示转置后的列表
ConsoleWriteLine(Destiney List:);
for (int i = ; i < dstListCount; i++)
{
string dstResult = stringEmpty;
for (int j = ; j < dstList[i]Count; j++)
{
dstResult += dstList[i][j] + ;
}
ConsoleWriteLine(dstResult);
}
ConsoleReadLine();
}
}
