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);
}
