protected void btnImport_Click(object sender, ImageClickEventArgs e) { StorageInProcessModel model = new StorageInProcessModel(); string EnterDateStart = string.Empty; string EnterDateEnd = string.Empty; string StorageID = string.Empty; string FromBillNo = string.Empty; model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; model.InNo = txtInNo.Value; model.Title = txtTitle.Value; model.ProcessDept = txtDeptProcessID.Value; model.DeptID = txtDeptID.Value; model.BillStatus = sltBillStatus.Value; model.Executor = txtExecutorID.Value; model.Processor = txtProcessorID.Value; EnterDateStart = txtEnterDateStart.Value; EnterDateEnd = txtEnterDateEnd.Value; StorageID = ddlStorageID.SelectedValue; string BatchNo = txtBatchNo.Value; FromBillNo = txtFromBillID.Value; string orderBy = txtorderBy.Value; if (!string.IsNullOrEmpty(orderBy)) { if (orderBy.Split('_')[1] == "a") { orderBy = orderBy.Split('_')[0] + " asc"; } else { orderBy = orderBy.Split('_')[0] + " desc"; } } DataTable dt = StorageInProcessBus.GetStorageInProcessTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, StorageID, FromBillNo, orderBy); if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice) { OutputToExecl.ExportToTableFormat(this, dt, new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" }, new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatusName" }, "生产完工入库列表"); } else { OutputToExecl.ExportToTableFormat(this, dt, new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" }, new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatusName" }, "生产完工入库列表"); } }