Exemplo n.º 1
0
    protected void GetData()
    {
        UserInfoUtil userInfo  = (UserInfoUtil)SessionUtil.Session["UserInfo"];
        string       ID        = Request.QueryString["ID"].Trim();
        string       CompanyCD = userInfo.CompanyCD;
        DataTable    dt        = StorageInOtherBus.GetStorageInOtherInfo(ID, CompanyCD);
        DataTable    dt1       = StorageInOtherBus.GetStorageInOtherDetailInfo(ID, CompanyCD);

        rd.Load(Server.MapPath(@"~/PrinttingModel/StorageManager/C_StorageInOther.rpt"));
        CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.V_StorageInOther"));
        ReportDocument rd1 = rd.Subreports["C_StorageInOtherDetail.rpt"];

        rd1.SetDataSource(dt1);
        //绑定数据
        rd.SetDataSource(dt);
        rd.Refresh();
        this.CrystalReportViewer1.ReportSource = rd;
        rd.SetParameterValue("Name", userInfo.EmployeeName);
    }
    protected void LoadPrintInfo()
    {
        PrintParameterSettingModel model = new PrintParameterSettingModel();

        model.CompanyCD     = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.BillTypeFlag  = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
        model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_INOTHER;

        StorageInOtherModel InOtherM_ = new StorageInOtherModel();

        InOtherM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        InOtherM_.ID        = this.BillID.ToString();

        #region 初始化 取基本信息及明细信息的字段以及对应的标题
        /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
        string[,] aBase;
        string[,] aDetail;
        if (GetIsDisplayPrice() != "none")
        {
            aBase = new string[, ] {
                { "{ExtField1}", "ExtField1" },
                { "{ExtField2}", "ExtField2" },
                { "{ExtField3}", "ExtField3" },
                { "{ExtField4}", "ExtField4" },
                { "{ExtField5}", "ExtField5" },
                { "{ExtField6}", "ExtField6" },
                { "{ExtField7}", "ExtField7" },
                { "{ExtField8}", "ExtField8" },
                { "{ExtField9}", "ExtField9" },
                { "{ExtField10}", "ExtField10" },
                { "入库单编号", "InNo" },
                { "入库单主题", "Title" },
                { "源单类型", "FromType" },
                { "源单编号", "BackNo" },
                { "往来单位", "OtherCorpName" },
                { "往来单位类型", "CorpBigType" },
                { "交货人", "TakerName" },
                { "验收人", "CheckerName" },
                { "入库人", "ExecutorName" },
                { "入库时间", "EnterDate" },
                { "入库部门", "DeptName" },
                { "入库原因", "ReasonTypeName" },
                { "摘要", "Summary" },
                { "批次", "BatchNo" },
                { "数量合计", "CountTotal" },
                { "金额合计", "A_TotalPrice" },
                { "制单人", "CreatorName" },
                { "制单日期", "CreateDate" },
                { "确认人", "ConfirmorName" },
                { "确认日期", "ConfirmDate" },
                { "结单人", "CloserName" },
                { "结单日期", "CloseDate" },
                { "最后更新人", "ModifiedUserName" },
                { "最后更新日期", "ModifiedDate" },
                { "单据状态", "BillStatus" },
                { "备注", "Remark" },
            };
            if (HiddenMoreUnit.Value == "true")
            {
                aDetail = new string[, ] {
                    { "序号", "SortNo" },
                    { "物品编号", "ProductNo" },
                    { "物品名称", "ProductName" },
                    { "颜色", "ColorName" },
                    { "规格", "Specification" },
                    { "基本单位", "UnitID" },
                    { "单位", "UsedUnitName" },             //++
                    { "仓库", "StorageName" },
                    { "源单数量", "FromBillCount" },
                    { "已入库数量", "InNumber" },
                    { "未入库数量", "NotInCount" },
                    { "基本数量", "ProductCount" },
                    { "数量", "UsedUnitCount" },            //++
                    { "单价", "UnitPrice" },
                    { "金额", "B_TotalPrice" },
                };
            }
            else
            {
                aDetail = new string[, ] {
                    { "序号", "SortNo" },
                    { "物品编号", "ProductNo" },
                    { "物品名称", "ProductName" },
                    { "颜色", "ColorName" },
                    { "规格", "Specification" },
                    { "单位", "UnitID" },
                    { "仓库", "StorageName" },
                    { "源单数量", "FromBillCount" },
                    { "已入库数量", "InNumber" },
                    { "未入库数量", "NotInCount" },
                    { "实收数量", "InCount" },
                    { "单价", "UnitPrice" },
                    { "金额", "B_TotalPrice" },
                };
            }
        }
        else
        {
            aBase = new string[, ] {
                { "{ExtField1}", "ExtField1" },
                { "{ExtField2}", "ExtField2" },
                { "{ExtField3}", "ExtField3" },
                { "{ExtField4}", "ExtField4" },
                { "{ExtField5}", "ExtField5" },
                { "{ExtField6}", "ExtField6" },
                { "{ExtField7}", "ExtField7" },
                { "{ExtField8}", "ExtField8" },
                { "{ExtField9}", "ExtField9" },
                { "{ExtField10}", "ExtField10" },
                { "入库单编号", "InNo" },
                { "入库单主题", "Title" },
                { "源单类型", "FromType" },
                { "源单编号", "BackNo" },
                { "往来单位", "OtherCorpName" },
                { "往来单位类型", "CorpBigType" },
                { "交货人", "TakerName" },
                { "验收人", "CheckerName" },
                { "入库人", "ExecutorName" },
                { "入库时间", "EnterDate" },
                { "入库部门", "DeptName" },
                { "入库原因", "ReasonTypeName" },
                { "摘要", "Summary" },
                { "批次", "BatchNo" },
                { "数量合计", "CountTotal" },
                { "制单人", "CreatorName" },
                { "制单日期", "CreateDate" },
                { "确认人", "ConfirmorName" },
                { "确认日期", "ConfirmDate" },
                { "结单人", "CloserName" },
                { "结单日期", "CloseDate" },
                { "最后更新人", "ModifiedUserName" },
                { "最后更新日期", "ModifiedDate" },
                { "单据状态", "BillStatus" },
                { "备注", "Remark" },
            };
            if (HiddenMoreUnit.Value == "true")
            {
                aDetail = new string[, ] {
                    { "序号", "SortNo" },
                    { "物品编号", "ProductNo" },
                    { "物品名称", "ProductName" },
                    { "颜色", "ColorName" },
                    { "规格", "Specification" },
                    { "基本单位", "UnitID" },
                    { "单位", "UsedUnitName" },             //++
                    { "仓库", "StorageName" },
                    { "源单数量", "FromBillCount" },
                    { "已入库数量", "InNumber" },
                    { "未入库数量", "NotInCount" },
                    { "基本数量", "ProductCount" },
                    { "数量", "UsedUnitCount" },            //++
                };
            }
            else
            {
                aDetail = new string[, ] {
                    { "序号", "SortNo" },
                    { "物品编号", "ProductNo" },
                    { "物品名称", "ProductName" },
                    { "颜色", "ColorName" },
                    { "规格", "Specification" },
                    { "单位", "UnitID" },
                    { "仓库", "StorageName" },
                    { "源单数量", "FromBillCount" },
                    { "已入库数量", "InNumber" },
                    { "未入库数量", "NotInCount" },
                    { "实收数量", "InCount" },
                };
            }
        }
        #endregion


        #region 1.扩展属性
        int       countExt   = 0;
        DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageInOther");
        if (dtExtTable.Rows.Count > 0)
        {
            for (int i = 0; i < dtExtTable.Rows.Count; i++)
            {
                for (int x = 0; x < (aBase.Length / 2) - 15; x++)
                {
                    if (x == i)
                    {
                        aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
                        countExt++;
                    }
                }
            }
        }
        #endregion

        #region 2.所设的打印模板设置

        DataTable dbPrint         = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
        DataTable dtDetail        = StorageInOtherBus.GetStorageInOtherDetailInfo(InOtherM_.ID, InOtherM_.CompanyCD);
        DataTable dtMain          = StorageInOtherBus.GetStorageInOtherInfo(InOtherM_.ID, InOtherM_.CompanyCD);
        string    strBaseFields   = "";
        string    strDetailFields = "";

        if (dbPrint.Rows.Count > 0)
        {
            #region 设置过打印模板设置时 直接取出表里设置的值
            isSeted.Value   = "1";
            strBaseFields   = dbPrint.Rows[0]["BaseFields"].ToString();
            strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
            #endregion
        }
        else
        {
            #region 未设置过打印模板设置 默认显示所有的
            isSeted.Value = "0";

            /*未设置过打印模板设置时,默认显示的字段  基本信息字段*/
            for (int m = 10; m < aBase.Length / 2; m++)
            {
                strBaseFields = strBaseFields + aBase[m, 1] + "|";
            }
            /*未设置过打印模板设置时,默认显示的字段 基本信息字段+扩展信息字段*/
            if (countExt > 0)
            {
                for (int i = 0; i < countExt; i++)
                {
                    strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
                }
            }
            /*未设置过打印模板设置时,默认显示的字段 明细信息字段*/
            for (int n = 0; n < aDetail.Length / 2; n++)
            {
                strDetailFields = strDetailFields + aDetail[n, 1] + "|";
            }
            #endregion

            /*两种都可以*/
        }
        #endregion

        #region 3.输出主表信息
        if (!string.IsNullOrEmpty(strBaseFields))
        {
            tableBase.InnerHtml = WritePrintPageTable("其他入库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, true);
        }
        #endregion

        #region 4.输出明细信息
        if (!string.IsNullOrEmpty(strDetailFields))
        {
            tableDetail.InnerHtml = WritePrintPageTable("其他入库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, false);
        }
        #endregion
    }