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" %>