ERP打印入库单(四十)
ERP打印入库单(四十)
需求描述:此购进单的基本信息,购进单位,入库单位,入库时间……此购进单批号,产品名称,生产企业,等基本信息。实现能够循环加载打印。本单金额小计,整单金额合计计算。技术需求:界面设计,循环加载数据实现函数:根据产品编号查询产品生产企业实现函数:根据产品查询产品规格实现函数:根据产品查询产品单位实现金额数字转换大写
金额大小写转换的类:
namespace CommTool{ ///
根据产品编号查询产品的生产企业
-- Description: 根据产品编号查询产品的生产企业-- =============================================CREATE FUNCTION [dbo].[FN_getMadeEnterpriseByProID]( @ProID INT)RETURNS NVARCHAR(100)ASBEGIN DECLARE @MadeEnterprise NVARCHAR(100) SELECT @MadeEnterprise=MadeEnterprise FROM dbo.BiotbProduct WHERE ProID=@ProID RETURN @MadeEnterpriseEND
根据产品编号查询产品规格:
-- Description: 根据产品编号查询产品规格-- =============================================CREATE FUNCTION [dbo].[FN_getProSpecbyProID]( @ProID INT)RETURNS NVARCHAR(100)ASBEGIN -- Declare the return variable here DECLARE @Spec NVARCHAR(100) -- Add the T-SQL statements to compute the return value here SELECT @Spec=spec FROM BiotbProduct WHERE ProID=@ProID -- Return the result of the function RETURN @SpecEND
根据产品编号查询产品单位:
-- Description: 根据产品编号查询产品单位-- =============================================CREATE FUNCTION [dbo].[FN_getProUnitbyProID]( @proID INT)RETURNS NVARCHAR(50)ASBEGIN -- Declare the return variable here DECLARE @Unit NVARCHAR(50) -- Add the T-SQL statements to compute the return value here SELECT @Unit=Unit FROM dbo.BiotbProduct WHERE ProID=@proID -- Return the result of the function RETURN @UnitEND
构建查询打印的视图数据:
CREATE VIEW [dbo].[View_PurchaseInfoPrint]ASSELECT SendComName=dbo.getCompanyNameByCompanyID(SendComID),AppUserName=dbo.getUserNameByUserID(AppUserID),AuditingUser=dbo.getUserNameByUserID(AcceptUserid),stockUserName=dbo.getUserNameByUserID(Stockuserid),StockName=dbo.FN_getStockNameByStockID(StockID),StockDate=dbo.Fn_getSotckTimeByPurchaseID(PurchaseID),* FROM dbo.BioPurchaseAppInfoCREATE VIEW [dbo].[View_PurchaseBatchInfoPrint]ASSELECT ProName, Spec=dbo.FN_getProSpecbyProID(ProID), MadeEnterprise=dbo.FN_getMadeEnterpriseByProID(ProID), Unit=dbo.FN_getProUnitbyProID(ProID), ProCount, ProPrice, ProBatchPriceTotal=(ProPrice*realityProCount), InvoicePrice, PurchaseProID, PurchaseID, ProID, makeDate, batchNum, expirationDate, ProBatchID, stockDate, boxNum, BatchProCount, realityProCount FROM View_PurchaseProBatchInfo
根据仓库编号查询仓库名称:
-- Description: 根据仓库编号查询仓库名称-- =============================================CREATE FUNCTION [dbo].[FN_getStockNameByStockID]( -- Add the parameters for the function here @stockID INT)RETURNS NVARCHAR(100)ASBEGIN DECLARE @StockName NVARCHAR(100) SELECT @StockName=StockName FROM dbo.BioErpStockTable WHERE ID=@stockID RETURN @StockNameEND
打印的前端代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RuKuPrint.aspx.cs" Inherits="BioErpWeb.Print.RuKuPrint" %>