基于C# WinForm实现的带条码打印的固定资产管理

一、系统架构设计

1. 技术架构

// 技术栈组成-开发框架：.NET Framework4.8-UI框架：Windows Forms-条码生成：BarcodeLib（开源库）-数据库：SQL Server2019-打印组件：Microsoft Print to PDF（或专用条码打印机驱动）

2. 功能模块划分

二、核心功能实现

1. 条码生成模块

publicclassBarcodeGenerator{publicBitmapGenerateCode128(stringcontent,intwidth=300,intheight=150){using(varbarcode=newBarcodeLib.Barcode()){barcode.Encode(BarcodeLib.TYPE.CODE128,content);barcode.Resize(width,height);returnbarcode.GetBitmap();}}// 生成二维码（支持微信/支付宝扫描）publicBitmapGenerateQRCode(stringcontent){varqr=newQRCoder();returnqr.GetGraphic(20);}}

2. 资产管理核心逻辑

publicclassAssetService{privatereadonlyAppDbContext_db=new();// 资产唯一编号生成publicstringGenerateAssetCode(){return"ZC"+DateTime.Now:yyyyMMddHHmmss+newRandom().Next(1000,9999).ToString("D4");}// 资产状态跟踪publicenumAssetStatus{在库,使用中,维修中,报废}// 折旧计算（直线法）publicdecimalCalculateDepreciation(decimaloriginalCost,DateTimestartDate,DateTimeendDate){intmonths=(endDate-startDate).Days/30;returnoriginalCost*0.2m/12*months;// 假设残值率20%}}

3. 条码打印服务

publicclassPrintService{privatePrintDocument_printDoc=new();publicvoidPrintLabel(stringassetCode,stringassetName){varbitmap=newBarcodeGenerator().GenerateCode128($"{assetCode}-{assetName}");_printDoc.PrintPage+=(s,e)=>{e.Graphics.DrawImage(bitmap,10,10);};_printDoc.Print();}// 批量打印优化publicvoidBatchPrint(IEnumerable<Asset>assets){varprintQueue=newPrintQueue();foreach(varassetinassets){varlabel=GenerateLabel(asset);printQueue.AddJob(label);}printQueue.Start();}}

三、数据库设计

1. 核心表结构

--资产主表 CREATETABLEAssets(AssetID INT PRIMARYKEYIDENTITY,AssetCodeNVARCHAR(50)UNIQUE,AssetNameNVARCHAR(100),CategoryID INTREFERENCESCategories(CategoryID),LocationNVARCHAR(100),PurchaseDateDATE,StatusNVARCHAR(20)CHECK(StatusIN('在库','使用中','维修中','报废')),BarCodeImageVARBINARY(MAX));--条码规则表 CREATETABLEBarcodeRules(RuleID INTPRIMARYKEY,FormatTemplateNVARCHAR(50),--如"ZC{YY}{MM}{SEQ}"CurrentSeq INT DEFAULT0);

四、界面设计实现

1. 资产录入界面

<!--使用TableLayoutPanel布局--><GroupBoxText="资产信息"><TableLayoutPanel><RowStyles><RowStyleHeight="30"/><RowStyleHeight="30"/><RowStyleHeight="30"/></RowStyles><ColumnsStyles><ColumnStyleWidth="120"/><ColumnStyleWidth="200"/></ColumnsStyles><Controls><LabelText="资产编号"/><TextBoxName="txtAssetCode"ReadOnly="True"/><LabelText="资产名称"/><TextBoxName="txtAssetName"/><LabelText="条码打印"/><ButtonName="btnPrint"Click="PrintBarcode"/></Controls></TableLayoutPanel></GroupBox>

2. 打印预览界面

privatevoidShowPrintPreview(){varprintPreview=newPrintPreviewDialog();printPreview.Document=_printDoc;printPreview.ShowDialog();}// 打印事件处理privatevoidbtnPrint_Click(objectsender,EventArgse){varasset=GetCurrentAsset();varlabel=GenerateLabel(asset);_printDoc.PrintPage+=(s,ev)=>ev.Graphics.DrawImage(label,10,10);_printDoc.Print();}

五、关键技术实现

1. 条码标签设计

// 自定义标签模板publicBitmapCreateLabelTemplate(stringassetCode,stringassetName){varbitmap=newBitmap(400,200);using(varg=Graphics.FromImage(bitmap)){g.FillRectangle(Brushes.White,0,0,400,200);g.DrawString($"资产编号：{assetCode}",newFont("宋体",12),Brushes.Black,10,10);g.DrawString($"资产名称：{assetName}",newFont("宋体",12),Brushes.Black,10,40);g.DrawImage(BarcodeGenerator.GenerateCode128(assetCode),10,70);}returnbitmap;}

2. 打印优化方案

// 打印队列管理publicclassPrintQueue{privateQueue<Bitmap>_jobs=new();publicvoidAddJob(Bitmapjob){_jobs.Enqueue(job);}publicvoidStart(){while(_jobs.Count>0){varjob=_jobs.Dequeue();using(varprintDoc=newPrintDocument()){printDoc.PrintPage+=(s,e)=>e.Graphics.DrawImage(job,10,10);printDoc.Print();}}}}

参考代码 带条码打印的固定资产管理系统源码www.youwenfan.com/contentcsn/92788.html

六、扩展功能建议

1. RFID集成

// RFID读写器接口publicinterfaceIRFIDReader{stringReadTag();voidWriteTag(stringdata);}// 实现类publicclassImpinjReader:IRFIDReader{publicstringReadTag(){// 调用Impinj SDK实现}publicvoidWriteTag(stringdata){// 写入资产编号到RFID标签}}

2. 移动端盘点

// Web API接口[HttpPost("api/inventory")]publicIActionResultScanAsset(stringbarcode){varasset=_assetService.FindByCode(barcode);returnOk(new{Status="success",Asset=asset});}