一、系统架构设计
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});}