双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒,抽取你的专属好礼

— 惊喜奖品抢先看 —

数组转DataTable

_小黑_ _小黑_ 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区


/// <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

...全文
评论 1
收藏 已收藏
分享
返回顶部
_小黑_
C# 111,129 成员 642,540 内容