protected void btnImport_Click(object sender, ImageClickEventArgs e) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; StorageQualityCheckReportModel model = new StorageQualityCheckReportModel(); model.CompanyCD = companyCD; model.Title = this.txtSubject.Text.Trim(); model.ReportNo = this.txtReportNo.Text.Trim(); model.FromType = sltFromType.Value.Trim(); model.FromReportNo = this.tbReportNo.Value; model.CheckType = sltCheckType.Value.Trim(); model.CheckMode = sltCheckMode.Value.Trim(); model.Checker = int.Parse(hiddenChecker.Value); model.ApplyDeptID = int.Parse(hiddenCheckDept.Value); string FlowStatus = ddlFlowStatus.Value; string theBeginTime = BeginTime.Value; string theEndTime = EndTime.Value; model.BillStatus = this.sltBillStatus.Value; int TotalCount = 0; model.Attachment = " ID Desc"; if (this.hiddenOrder.Value != "0") { string[] myOrder = this.hiddenOrder.Value.Split('_'); if (myOrder[1] == "a") { model.Attachment = myOrder[0] + " asc "; } else { model.Attachment = myOrder[0] + " desc "; } } model.Creator = -100; model.Confirmor = -100; string EFIndex = GetBillExAttrControl1.GetExtIndexValue; string EFDesc = GetBillExAttrControl1.GetExtTxtValue; DataTable dt = CheckReportBus.SearchReport(model, theBeginTime, theEndTime, FlowStatus, EFIndex, EFDesc, ref TotalCount); //导出标题 string headerTitle = "单据编号|单据主题|源单类型|往来单位|往来单位类别|质检类别|检验方式|报检人员|报检部门|报检日期|单据状态|审批状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "ReportNo|Title|FromTypeName|OtherCorpName|BigTypeName|CheckTypeName|CheckModeName|EmployeeName|DeptName|CheckDate|BillStatus|FlowStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "质检报告单列表"); }
private void CustTreeShow(string CustType, TreeNode treenode) { if (CustType == CUST_PROVIDER) { //获取供应商信息 DataTable dt = ProviderInfoBus.GetProviderInfo(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { TreeNode node = new TreeNode(); string spanId = "node_" + rows["ID"].ToString(); node.Text = " <input name=\"select\" id=\"ra" + rows["ID"] + "\" value=\"" + rows["ID"].ToString() + "|" + rows["CustName"].ToString() + "|2|供应商" + "\" type=\"radio\" />" + rows["CustName"].ToString() + ""; //node.Value = rows["ID"].ToString(); //node.ImageUrl = "../../../Images/treeimg/page.gif"; // node.NavigateUrl = string.Format("javascript:SelectedNodeChanged('{0}','{1}');", rows["CustName"].ToString() + "|" + rows["ID"].ToString() + "|2|供应商", spanId); treenode.ChildNodes.Add(node); } } } else if (CustType == CUST_CUST) { //获取客户信息 DataTable dt = CustInfoBus.GetCustInfo(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { TreeNode node = new TreeNode(); string spanId = "node_" + rows["ID"].ToString(); node.Text = " <input name=\"select\" id=\"ra" + rows["ID"] + "\" value=\"" + rows["ID"].ToString() + "|" + rows["CustName"].ToString() + "|1|客户" + "\" type=\"radio\" />" + rows["CustName"].ToString() + ""; //node.Value = rows["ID"].ToString(); //node.ImageUrl = "../../../Images/treeimg/page.gif"; //node.NavigateUrl = string.Format("javascript:SelectedNodeChanged('{0}','{1}');", rows["CustName"].ToString() + "|" + rows["ID"].ToString() + "|1|客户", spanId); treenode.ChildNodes.Add(node); } } } else if (CustType == CUST_OTHER) { //获取其他客户信息 DataTable dt = CheckReportBus.GetOtherInfo(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { TreeNode node = new TreeNode(); string spanId = "node_" + rows["ID"].ToString(); node.Text = " <input name=\"select\" id=\"ra" + rows["ID"] + "\" value=\"" + rows["ID"].ToString() + "|" + rows["CustName"].ToString() + "|7|其他客户" + "\" type=\"radio\" />" + rows["CustName"].ToString() + ""; //node.Value = rows["ID"].ToString(); //node.ImageUrl = "../../../Images/treeimg/page.gif"; // node.NavigateUrl = string.Format("javascript:SelectedNodeChanged('{0}','{1}');", rows["CustName"].ToString() + "|" + rows["ID"].ToString() + "|7|其他客户", spanId); treenode.ChildNodes.Add(node); } } } else if (CustType == CUST_FOREIGN) {//获取外协 DataTable dt = CheckReportBus.GetForeignInfo(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { TreeNode node = new TreeNode(); string spanId = "node_" + rows["ID"].ToString(); node.Text = " <input name=\"select\" id=\"ra" + rows["ID"] + "\" value=\"" + rows["ID"].ToString() + "|" + rows["CustName"].ToString() + "|5|外协加工厂" + "\" type=\"radio\" />" + rows["CustName"].ToString() + ""; //node.Value = rows["ID"].ToString(); //node.ImageUrl = "../../../Images/treeimg/page.gif"; // node.NavigateUrl = string.Format("javascript:SelectedNodeChanged('{0}','{1}');", rows["CustName"].ToString() + "|" + rows["ID"].ToString() + "|5|外协加工厂", spanId); treenode.ChildNodes.Add(node); } } } }
protected void LoadPrintInfo() { PrintParameterSettingModel pModel = new PrintParameterSettingModel(); pModel.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; pModel.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_QUALITYCHECK); pModel.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_CHECKREPORT; /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/ string[,] aBase = { { "{ExtField1}", "ExtField1" }, { "{ExtField2}", "ExtField2" }, { "{ExtField3}", "ExtField3" }, { "{ExtField4}", "ExtField4" }, { "{ExtField5}", "ExtField5" }, { "{ExtField6}", "ExtField6" }, { "{ExtField7}", "ExtField7" }, { "{ExtField8}", "ExtField8" }, { "{ExtField9}", "ExtField9" }, { "{ExtField10}", "ExtField10" }, { "单据编号", "ReportNo" }, { "主题", "Title" }, { "源单类型", "FromType" }, { "源单编号", "FromReportNo" }, { "往来单位", "OtherCorpName" }, { "往来单位大类", "CorpBigType" }, { "生产负责人", "PrincipalName" }, { "生产部门", "DeptName" }, { "质检类别", "CheckType" }, { "检验日期", "CheckDate" }, { "报检人员", "ApplyUserName" }, { "报检部门", "ApplyDeptName" }, { "检验人员", "CheckerName" }, { "检验部门", "CheckDeptName" }, { "检验方案", "CheckContent" }, { "物品编号", "ProdNo" }, { "物品名称", "ProductName" }, { "单位", "CodeName" }, { "规格", "Specification" }, { "报检数量", "CheckNum" }, { "抽样数量", "SampleNum" }, { "检验方式", "CheckMode" }, { "合格数量", "PassNum" }, { "不合格数量", "NoPass" }, { "合格率(%)", "PassPercent" }, { "检验标准", "CheckStandard" }, { "检验结果描述 ", "CheckResult" }, { "检验结果 ", "IsPass" }, { "是否需要复检", "isRecheck" }, { "单据状态", "BillStatus" }, { "制单人", "CreatorName" }, { "制单日期", "CreateDate" }, { "确认人", "ConfirmorName" }, { "确认日期", "ConfirmDate" }, { "结单人", "CloserName" }, { "结单日期", "CloseDate" }, { "最后更新人", "ModifiedUserID" }, { "最后更新日期", "ModifiedDate" }, { "备注", "Remark" }, }; string[,] aDetail = { { "序号", "SortNo" }, { "检验项目", "CheckItem" }, { "检验指标", "CheckStandard" }, { "检验值", "CheckValue" }, { "检验结论", "CheckResult" }, { "检验结果", "isPass" }, { "检验数量", "CheckNum" }, { "合格数量", "PassNum" }, { "不合格数", "NotPassNum" }, { "检验人员", "Checker" }, { "检验部门", "CheckDeptID" }, { "标准值", "StandardValue" }, { "指标上限", "NormUpLimit" }, { "指标下限", "LowerLimit" }, { "备注", "Remark" }, }; #region 扩展属性 DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.QualityCheckReport"); int countExt = 0; for (int i = 0; i < dtExtTable.Rows.Count; i++) { aBase[i, 0] = dtExtTable.Rows[i]["EFDesc"].ToString(); countExt++; } #endregion DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(pModel); DataTable dt = CheckReportBus.GetReportInfo(this.intID); DataTable dtDetail = CheckReportBus.GetDetailInfo(this.intID); dtDetail.Columns.Add("SortNo", typeof(string)); for (int i = 0; i < dtDetail.Rows.Count; i++) { dtDetail.Rows[i]["SortNo"] = i + 1; } string strBaseFields = ""; string strDetailFields = ""; if (dbPrint.Rows.Count > 0) { isSeted.Value = "1"; strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString(); strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString(); } else { isSeted.Value = "0"; strBaseFields = GetDefaultFields(aBase); /*基本信息字段+扩展信息字段*/ if (countExt > 0) { for (int i = 0; i < countExt; i++) { strBaseFields += "|ExtField" + (i + 1); } } strDetailFields = GetDefaultFields(aDetail); } #region 主表信息 if (!string.IsNullOrEmpty(strBaseFields)) { tableBase.InnerHtml = WritePrintPageTable("质检报告单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, true); } #endregion #region 明细信息 if (!string.IsNullOrEmpty(strDetailFields)) { tableDetail.InnerHtml = WritePrintPageTable("质检报告单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, false); } #endregion }