美文网首页
c#数据导出为csv

c#数据导出为csv

作者: 小兔哈尼 | 来源:发表于2018-09-21 11:12 被阅读0次
    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

          本文链接:https://www.haomeiwen.com/subject/msdanftx.html