private void btnUpdateExcel_Click(object sender, EventArgs e)
{
var dialog = this.ofdKcExcel.ShowDialog();
if (dialog == DialogResult.OK)
{
var bytes = File.ReadAllBytes(this.ofdKcExcel.FileName);
KuCunFilePath = ofdKcExcel.FileName;
using (var ms = new MemoryStream(bytes))
{
var result = ExcelHelper.ReadKuCunInfosExcel(ms);
FillDataInfos(result, this.dgvKuCunInfo);
this.KuCunInfoList = KuCunInfo.MapCunInfos(result);
}
using (var ms = new MemoryStream(bytes))
{
var result = ExcelHelper.ReadFaHuoInfosExcel(ms);
var data = FaHuoTaskItemView.MapTaskItems(result);
FillDataInfos(data, this.dgvFaHuoTaskInfo);
FaHuoTaskItemList = FaHuoTaskItem.MapTaskItems(result);
}
}
CheckExecResult();
}
private static List <KuCunInfo> InitKuCunInfos()
{
var baseKuCunInfo = new KuCunInfo()
{
XingHao = "A",
LunHao = 40,
PaiHao = 30,
Length = 200,
};
var kuCunInfo = new List <KuCunInfo>()
{
new KuCunInfo()
{
XingHao = baseKuCunInfo.XingHao,
LunHao = baseKuCunInfo.LunHao + 1,
PaiHao = baseKuCunInfo.PaiHao + 1,
Length = 200,
IsWheel = "否"
},
new KuCunInfo()
{
XingHao = baseKuCunInfo.XingHao,
LunHao = baseKuCunInfo.LunHao + 1,
PaiHao = baseKuCunInfo.PaiHao + 1,
Length = 300,
IsWheel = "否"
},
new KuCunInfo()
{
XingHao = baseKuCunInfo.XingHao,
LunHao = baseKuCunInfo.LunHao + 1,
PaiHao = baseKuCunInfo.PaiHao + 1,
Length = 600,
IsWheel = "否"
},
new KuCunInfo()
{
XingHao = baseKuCunInfo.XingHao,
LunHao = baseKuCunInfo.LunHao + 1,
PaiHao = baseKuCunInfo.PaiHao + 1,
Length = 1000,
IsWheel = "是"
},
};
return(kuCunInfo);
}
/// <summary>
/// 上传库存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btnKcInfo_Click(object sender, EventArgs e)
{
var dialog = this.ofdKcExcel.ShowDialog();
if (dialog == DialogResult.OK)
{
var bytes = File.ReadAllBytes(this.ofdKcExcel.FileName);
KuCunFilePath = ofdKcExcel.FileName;
using (var ms = new MemoryStream(bytes))
{
var result = ExcelHelper.ReadKuCunInfosExcel(ms);
FillDataInfos(result, this.dgvKuCunInfo);
this.KuCunInfoList = KuCunInfo.MapCunInfos(result);
}
}
await CheckExecResult();
}