-
本版专家分：4369结帖率 97.93% -
/// <summary>
/// 获取KEY
/// </summary>
/// <returns></returns>
private string[][] GetKey(string[,] arr)
{
string[][] key = new string[arr.GetLength(0)][];
//for (int i = 0; i < arr.GetLength(0); i++)
//{
// key[i] =new string [arr.GetLength(1)];
// for (int j = 0; j < arr.GetLength(1); j++)
// {
// key[i][j] = arr[i, j];
// }
//}
key[0] = new string[4];
key[0][0] = "key";
key[0][1] = "item";
key[0][2] = "type";
key[0][3] = "other";
key[1] = new string[4];
key[1][0] = "1";
key[1][1] = "sell-in";
key[1][2] = "in";
key[1][3] = "aa";
key[2] = new string[4];
key[2][0] = "2";
key[2][1] = "sell-out";
key[2][2] = "out";
key[2][3] = "bb";
return key;
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
private string[][] GetData()
{
string[][] data = new string[6][];
data[0] = new string[5];
data[0][0] = "FCT";
data[0][1] = "FCT";
data[0][2] = "FCT";
data[0][3] = "FCT";
data[0][4] = "FCT";
data[1] = new string[5];
data[1][0] = "201801";
data[1][1] = "201802";
data[1][2] = "201803";
data[1][3] = "201804";
data[1][4] = "201805";
data[2] = new string[5];
data[2][0] = "2018-1-1";
data[2][1] = "2018-1-1";
data[2][2] = "2018-1-1";
data[2][3] = "2018-1-1";
data[2][4] = "2018-1-1";
data[3] = new string[5];
data[3][0] = "2018-1-1";
data[3][1] = "2018-1-8";
data[3][2] = "2018-1-15";
data[3][3] = "2018-1-22";
data[3][4] = "2018-1-29";
data[4] = new string[5];
data[4][0] = "123";
data[4][1] = "234";
data[4][2] = "345";
data[4][3] = "456";
data[4][4] = "567";
data[5] = new string[5];
data[5][0] = "333";
data[5][1] = "444";
data[5][2] = "555";
data[5][3] = "666";
data[5][4] = "777";
return data;
}
//以上数组 想转成 以下DataTable
key item type other dataType DataWeek DataMonth DataDate qty
1 sell-in in aa fct 201801 Jan-18 2018-1-1 123
1 sell-in in aa fct 201802 Jan-18 2018-1-8 234
1 sell-in in aa fct 201803 Jan-18 2018-1-15 345
1 sell-in in aa fct 201804 Jan-18 2018-1-22 456
1 sell-in in aa fct 201805 Feb-18 2018-1-29 567
2 sell-out out bb fct 201801 Jan-18 2018-1-1 333
2 sell-out out bb fct 201802 Jan-18 2018-1-8 444
2 sell-out out bb fct 201803 Jan-18 2018-1-15 555
2 sell-out out bb fct 201804 Jan-18 2018-1-22 666
2 sell-out out bb fct 201805 Feb-18 2018-1-29 777
-
本版专家分：4369
-
for (int i = 0; i <= key.GetLength(0); i++)
{
DataColumn dc = new DataColumn(key[0][i]);
dtSource.Columns.Add(dc);
}
dtSource.Columns.Add("DataType");
dtSource.Columns.Add("DataMonth");
dtSource.Columns.Add("DataWeek");
dtSource.Columns.Add("DataDate");
dtSource.Columns.Add("QTY");
for (int i = 1; i < key.Length; i++)//循环主数据的行
{
for (int j = 0; j < 5; j++)//循环数据的列
{
DataRow dr = dtSource.NewRow();
dr["item"] = key[i][1];//获取主数据ITEM列在数组的第1列
dr["key"] = key[i][0];
dr["type"] = key[i][2];
dr["other"] = key[i][3];
dr["DataType"] = data[0][j];//获取DataType在数据的第0行
dr["DataMonth"] = data[2][j];
dr["DataWeek"] = data[1][j];
dr["DataDate"] = data[3][j];
dr["QTY"] = data[i + 3][j];//获取QTY 由于主数据和数据相差3行所以加3
dtSource.Rows.Add(dr);
}
}
-
本版专家分：14877 -
private class 佛诞
{
public string 名称 { get; set; }
public int 日期 { get; set; }
public 佛诞(string 称号, int 诞日)
{ 名称 = 称号; 日期 = 诞日; }
}
佛诞[] 佛诞组 = new 佛诞[] { new 佛诞("那摩阿弥陀佛！圣诞", 1117), new 佛诞("那摩地藏王菩萨！圣诞", 729), new 佛诞("那摩地藏王菩萨！圣诞", 730)
, new 佛诞("那摩释迦牟尼佛！圣诞", 48), new 佛诞("那摩释迦牟尼佛！出家", 28), new 佛诞("那摩释迦牟尼佛！成道", 128), new 佛诞("那摩释迦牟尼佛！涅槃", 215)
, new 佛诞("那摩观世音菩萨！圣诞", 219), new 佛诞("那摩观世音菩萨！出家", 919), new 佛诞("那摩观世音菩萨！成道", 619), new 佛诞("那摩大势至菩萨！圣诞", 713)
, new 佛诞("那摩普贤菩萨！圣诞", 221), new 佛诞("那摩文殊师利菩萨！圣诞", 44), new 佛诞("那摩禅宗达摩祖师！圣诞", 105), new 佛诞("那摩慧能禅宗六祖！圣诞", 29), new 佛诞("那摩慧能禅宗六祖！圆寂", 83)
, new 佛诞("那摩华严菩萨！圣诞", 1229), new 佛诞("那摩药师佛！圣诞", 930), new 佛诞("那摩燃灯古佛！圣诞", 822), new 佛诞("那摩定光佛！圣诞", 16), new 佛诞("那摩弥勒菩萨！圣诞；春节", 11)
, new 佛诞("那摩福德土地正神！圣诞", 22), new 佛诞("那摩准提菩萨！圣诞", 316), new 佛诞("那摩药王菩萨！圣诞", 428), new 佛诞("那摩伽蓝菩萨！圣诞", 518)
, new 佛诞("那摩韦驮菩萨！圣诞", 63), new 佛诞("那摩第五殿阎罗天子！圣诞", 18), new 佛诞("那摩帝释天尊！圣诞", 19), new 佛诞("那摩妈祖升仙！重阳节", 729)
, new 佛诞("那摩妈祖！圣诞", 323), new 佛诞("那摩文昌帝君！圣诞", 23), new 佛诞("那摩第四殿五官王！圣诞", 218), new 佛诞("那摩第六殿卞城王！圣诞", 38)
, new 佛诞("那摩中岳大帝；后土娘娘！圣诞", 319), new 佛诞("那摩子孙娘娘！圣诞", 320), new 佛诞("那摩第七殿泰山王！圣诞", 327), new 佛诞("那摩地藏王菩萨！圣诞", 729)
, new 佛诞("佛欢喜日！盂兰盆节", 715), new 佛诞("元宵节！", 115), new 佛诞("端午节", 55), new 佛诞("七夕情人节", 77), new 佛诞("中秋节", 815), new 佛诞("中秋节", 815)
, new 佛诞("腊八节", 128), new 佛诞("小年", 1223), new 佛诞("除夕", 1230), new 佛诞("道教中元节", 715)};
也就几句代码的完成事。使用LINQ就一句话的事。
