private void btnexport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if ((this.gvgoods != null))
{
if (this.bsgoods.Count == 0) { return; }
IList<AllocatePurchTaskInfo> goodslist = bsgoods.List as IList<AllocatePurchTaskInfo>;
IList<AllocatePurchTaskInfo> toSaveList = new List<AllocatePurchTaskInfo>();
for (int i = 0; i < goodslist.Count; i++)
{
if (goodslist[i].PurchManList == null)
{
if (goodslist[i].GoodsType != "" && goodslist[i].Code != "")
{
IList<PurchManInfo> purchManList = AllocatePurchTaskManager.SelectPurchManExited(dbNode, goodslist[i]);
goodslist[i].PurchManList = purchManList;
}
}
for (int j = 0; j < goodslist[i].PurchManList.Count; j++)
{
AllocatePurchTaskInfo toSave = new AllocatePurchTaskInfo();
if (goodslist[i].PurchManList[j].ISOrNot == false)
{ continue; }
toSave.ISOrNot = goodslist[i].PurchManList[j].ISOrNot;
toSave.PurchManCode = goodslist[i].PurchManList[j].PurchManCode;
toSave.PurchManName = goodslist[i].PurchManList[j].PurchManName;
toSave.goodsType = goodslist[i].goodsType;
toSave.Code = goodslist[i].Code;
toSave.Name = goodslist[i].Name;
if (goodslist[i].GoodsType == "品类")
{
toSave.CategoryItemCode = "0000";
}
toSaveList.Add(toSave);
}
}
FolderBrowserDialog path = new FolderBrowserDialog();
path.ShowDialog();
if (path.SelectedPath == null || path.SelectedPath == "") { return; }
FileStream fs = new FileStream(path.SelectedPath + @"\采购任务分配设置导出.CSV", FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(fs,UnicodeEncoding.GetEncoding("GB2312"));
sw.WriteLine("编码类型" + "," + "编码" + "," + "名称" + "," + "品类基本项" + "," + "采购人编码" + "," + "采购人名称" + ",");
for (int i = 0; i < toSaveList.Count; i++)
{
sw.Write(toSaveList[i].goodsType + ",");
sw.Write(toSaveList[i].Code + ",");
sw.Write(toSaveList[i].Name + ",");
if (toSaveList[i].GoodsType == "品类")
{
sw.Write("0000" + ",");
}
else
{
sw.Write("" + ",");
}
sw.Write(toSaveList[i].PurchManCode + ",");
sw.WriteLine(toSaveList[i].PurchManName);
}
sw.Flush();
sw.Close();
XtraMessageBox.ShowSuccessMessage("导出成功");
}
}
c#数据导出为csv
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门,熙熙楼的掌柜王于贵愁眉苦脸地迎上来,“玉大人,你说我怎么就摊上这事。” “怎么了?”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着,像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上,一...
- 文/苍兰香墨 我猛地睁开眼,长吁一口气:“原来是场噩梦啊……” “哼!你这毒妇竟也来了?” 一声冷哼从身侧响起,我...