private void ComputationGroupExportToExcel(HttpContext context) { string fileName = "计量单位组.xls"; List <DXInfo.Models.tbComputationGroup> lComputationGroup = new List <DXInfo.Models.tbComputationGroup>(); //using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) //{ var q = QueryCondition(context); lComputationGroup = q.OrderBy(o => o.cnvcGroupCode).ToList(); //} DataTable dt = List2DataTable(context, lComputationGroup); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnvcGroupCode"; field.HeaderText = "计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupName"; field.HeaderText = "计量单位组名称"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void ProductCLassExportToExcel(HttpContext context) { string fileName = "存货分类.xls"; List <DXInfo.Models.tbProductClass> lProductClass = new List <DXInfo.Models.tbProductClass>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); lProductClass = q.OrderBy(o => o.cnvcProductClassCode).ToList(); //} DataTable dt = List2DataTable(context, lProductClass); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnvcProductType"; field.HeaderText = "产品组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductTypeComments"; field.HeaderText = "产品组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductClassCode"; field.HeaderText = "类别编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductClassName"; field.HeaderText = "类别名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnDays"; field.HeaderText = "过期天数"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComments"; field.HeaderText = "描述"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbDeptExportToExcel(HttpContext context) { string fileName = "部门.xls"; List <DXInfo.Models.tbDept> ltbDept = new List <DXInfo.Models.tbDept>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); ltbDept = q.OrderBy(o => o.cnvcDeptID).ToList(); //} DataTable dt = List2DataTable(context, ltbDept); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcDeptName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDeptID"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDeptType"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcParentDeptID"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComments"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnPriority"; field.HeaderText = ""; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbComputationUnitExportToExcel(HttpContext context) { string fileName = "计量单位.xls"; List <DXInfo.Models.tbComputationUnit> ltbComputationUnit = new List <DXInfo.Models.tbComputationUnit>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); ltbComputationUnit = q.OrderBy(o => o.cnvcComunitCode).ToList(); //} DataTable dt = List2DataTable(context, ltbComputationUnit); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcComunitCode"; field.HeaderText = "计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComUnitName"; field.HeaderText = "计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCode"; field.HeaderText = "计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCodeComments"; field.HeaderText = "计量单位组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbMainUnit"; field.HeaderText = "是否主计量单位"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniChangRate"; field.HeaderText = "换算率"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void ComputationGroupExportToExcel(HttpContext context) { string fileName = "库存统计表.xls"; List <tbStockReportData> ltbStockReportData = new List <tbStockReportData>(); //using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) //{ var q = QueryCondition(context); ltbStockReportData = q.OrderBy(o => o.cnvcInvCode).ToList(); //} DataTable dt = List2DataTable(context, ltbStockReportData); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnvcInvCode"; field.HeaderText = "存货编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvName"; field.HeaderText = "存货名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSTComUnitName"; field.HeaderText = "单位"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnInitQuantity"; field.HeaderText = "期初数量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnInQuantity"; field.HeaderText = "本期入库数量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnOutQuantity"; field.HeaderText = "本期出库数量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnEndQuantity"; field.HeaderText = "结余数量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnSTPrice"; field.HeaderText = "单位成本"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnEndAmount"; field.HeaderText = "库存成本"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbSupplierExportToExcel(HttpContext context) { string fileName = "供应商.xls"; List <AMSCM.Models.tbSupplier> ltbSupplier = new List <AMSCM.Models.tbSupplier>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); ltbSupplier = q.OrderBy(o => o.cnvcCode).ToList(); } DataTable dt = List2DataTable(context, ltbSupplier); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcAddress"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPostCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPhone"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcFax"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcEmail"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcLinkName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCreateOper"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndCreateDate"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbInvalid"; field.HeaderText = ""; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbBillOfMaterialsExportToExcel(HttpContext context) { string fileName = "配方.xls"; List <AMSCM.Models.tbBillOfMaterials> ltbBillOfMaterials = new List <AMSCM.Models.tbBillOfMaterials>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); ltbBillOfMaterials = q.OrderBy(o => o.cnvcPartInvCode).OrderBy(o => o.cnvcComponentInvCode).ToList(); } DataTable dt = List2DataTable(context, ltbBillOfMaterials); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcPartProductType"; field.HeaderText = "母件产品组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartProductTypeName"; field.HeaderText = "母件产品组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartInvCCode"; field.HeaderText = "母件产品类别编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartInvCName"; field.HeaderText = "母件产品类别名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartInvCode"; field.HeaderText = "母件存货编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartInvName"; field.HeaderText = "母件存货编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartGroupCode"; field.HeaderText = "母件计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartGroupName"; field.HeaderText = "母件计量单位组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartProduceUnitCode"; field.HeaderText = "母件生产计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPartProduceUnitName"; field.HeaderText = "母件生产计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnBaseQtyD"; field.HeaderText = "母件基础用量"; view.Columns.Add(field); //子件 field = new BoundField(); field.DataField = "cnvcComponentProductType"; field.HeaderText = "子件产品组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentProductTypeName"; field.HeaderText = "子件产品组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentInvCCode"; field.HeaderText = "子件产品类别编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentInvCName"; field.HeaderText = "子件产品类别名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentInvCode"; field.HeaderText = "子件存货编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentInvName"; field.HeaderText = "子件存货名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentGroupCode"; field.HeaderText = "子件计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentGroupName"; field.HeaderText = "子件计量单位组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentProduceUnitCode"; field.HeaderText = "子件生产计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComponentProduceUnitName"; field.HeaderText = "子件生产计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnBaseQtyN"; field.HeaderText = "子件用量"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbStockDetailExportToExcel(HttpContext context) { string fileName = "库存子表.xls"; List <AMSCM.Models.tbStockDetail> ltbStockDetail = new List <AMSCM.Models.tbStockDetail>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); ltbStockDetail = q.OrderBy(o => o.cnnMainId).ToList(); } DataTable dt = List2DataTable(context, ltbStockDetail); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnnId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnMainId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComUnitCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnQuantity"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcMainComUnitCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnMainQuantity"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnPrice"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnAmount"; field.HeaderText = ""; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void InventoryExportToExcel(HttpContext context) { string fileName = "存货档案.xls"; List <DXInfo.Models.tbInventory> lInventory = new List <DXInfo.Models.tbInventory>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); lInventory = q.OrderBy(o => o.cnvcInvCode).ToList(); //} DataTable dt = List2DataTable(context, lInventory); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnbProductBill"; field.HeaderText = "允许生产订单"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvCode"; field.HeaderText = "存货编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvName"; field.HeaderText = "存货名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvStd"; field.HeaderText = "规格型号"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvCCode"; field.HeaderText = "存货类别编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcInvCCodeComments"; field.HeaderText = "存货类别名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbSale"; field.HeaderText = "是否销售"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbPurchase"; field.HeaderText = "是否外购"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbSelf"; field.HeaderText = "是否自制"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbComsume"; field.HeaderText = "是否生产耗用"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniInvCCost"; field.HeaderText = "参考成本(元)"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniInvNCost"; field.HeaderText = "最新成本(元)"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniSafeNum"; field.HeaderText = "安全库存量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniLowSum"; field.HeaderText = "最低库存量"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndSDate"; field.HeaderText = "启用日期"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndEDate"; field.HeaderText = "停用日期"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCreatePerson"; field.HeaderText = "建档人编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCreatePersonComments"; field.HeaderText = "建档人姓名"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcModifyPerson"; field.HeaderText = "变更人编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcModifyPersonComments"; field.HeaderText = "变更人姓名"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndModifyDate"; field.HeaderText = "变更日期"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcValueType"; field.HeaderText = "计价方式编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcValueTypeComments"; field.HeaderText = "计价方式名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCode"; field.HeaderText = "计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCodeComments"; field.HeaderText = "计量单位组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComUnitCode"; field.HeaderText = "主计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComUnitCodeComments"; field.HeaderText = "主计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSAComUnitCode"; field.HeaderText = "销售计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSAComUnitCodeComments"; field.HeaderText = "销售计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPUComUnitCode"; field.HeaderText = "采购计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcPUComUnitCodeComments"; field.HeaderText = "采购计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSTComUnitCode"; field.HeaderText = "库存计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSTComUnitCodeComments"; field.HeaderText = "库存计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProduceUnitCode"; field.HeaderText = "生产计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProduceUnitCodeComments"; field.HeaderText = "生产计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnfRetailPrice"; field.HeaderText = "零售价格"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcShopUnitCode"; field.HeaderText = "零售计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcShopUnitCodeComments"; field.HeaderText = "零售计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcFeel"; field.HeaderText = "口感"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcOrganise"; field.HeaderText = "组织"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcColor"; field.HeaderText = "内馅"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcTaste"; field.HeaderText = "表面装饰"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnExpire"; field.HeaderText = "过期限制(天)"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnDue"; field.HeaderText = "到期提示(天)"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbStockMainExportToExcel(HttpContext context) { string fileName = "库存主表.xls"; List <DXInfo.Models.tbStockMain> ltbStockMain = new List <DXInfo.Models.tbStockMain>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); ltbStockMain = q.OrderBy(o => o.cnnMainId).ToList(); //} DataTable dt = List2DataTable(context, ltbStockMain); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnnId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcSupplierCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhCode"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDeptId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcOperType"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndCreateDate"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCreaterId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCreaterName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndCheckDate"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCheckerId"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcCheckerName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cndBusinessDate"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnYear"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnMonth"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnStatus"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComments"; field.HeaderText = ""; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbWarehouseExportToExcel(HttpContext context) { string fileName = "仓库.xls"; List <DXInfo.Models.tbWarehouse> ltbWarehouse = new List <DXInfo.Models.tbWarehouse>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var q = QueryCondition(context); ltbWarehouse = q.OrderBy(o => o.cnvcWhCode).ToList(); //} DataTable dt = List2DataTable(context, ltbWarehouse); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcWhCode"; field.HeaderText = "仓库编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhName"; field.HeaderText = "仓库名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDepID"; field.HeaderText = "部门编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDepIDComments"; field.HeaderText = "部门名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhAddress"; field.HeaderText = "地址"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhPhone"; field.HeaderText = "电话"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhPerson"; field.HeaderText = "负责人编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhPersonComments"; field.HeaderText = "负责人姓名"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcWhComments"; field.HeaderText = "描述"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbInvalidComments"; field.HeaderText = "是否失效"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }