C# 发票扫码录入工具源码(wpf)

C#语言基础

下载此实例

开发语言：C#
实例大小：10.65M
下载次数：105
浏览次数：1876
发布时间：2019-03-04
实例类别：C#语言基础
发布人：crazycode
文件格式：.zip
所需积分：2

相关标签： C# 扫描枪工具扫码

网友评论举报投诉收藏该页

下载此实例

实例介绍

[下载地址]

【实例简介】

【实例截图】

from clipboard

【核心代码】

using Microsoft.Win32;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace QRCodeScanner
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window, INotifyPropertyChanged
    {
        public MainWindow()
        {
            InitializeComponent();
            listener.ScanerEvent  = Listener_ScanerEvent;
            this.Loaded  = MainWindow_Loaded;
            this.Unloaded  = MainWindow_Unloaded;
            this.DataContext = this;
        }

        private void MainWindow_Unloaded(object sender, RoutedEventArgs e)
        {
            listener.Stop();
        }

        private void MainWindow_Loaded(object sender, RoutedEventArgs e)
        {
            listener.Start();
        }

        private ScanerHook listener = new ScanerHook();

        private bool isBusy = false;

        private ObservableCollection<InvoiceModel> invoiceList = new ObservableCollection<InvoiceModel>();
        public ObservableCollection<InvoiceModel> InvoiceList
        {
            get { return invoiceList; }
            set
            {
                invoiceList = value;
                RaisePropertyChanged("InvoiceList");
            }
        }

        //public List<InvoiceModel> invoiceList = new List<InvoiceModel>();

        private void Listener_ScanerEvent(ScanerHook.ScanerCodes codes)
        {
            var items = codes.Result.Split(',', '，');

            if (items.Length < 6)
                return;

            var model = new InvoiceModel
            {
                //   TypeCode = items[1],
                Code = items[2],
                Number = items[3],
                Amount = Convert.ToDecimal(items[4]),
                MakeDate = items[5],
                CheckNumber = items[6],
                ScanDate = DateTime.Now.ToString("yyyy-MM-dd"),
                ScanTime = DateTime.Now.ToString("HH:mm"),
                Remark = "自动",
            };

            InsertOne(model);
        }

        private void btnNew_Click(object sender, RoutedEventArgs e)
        {
            NewView view = new NewView((obj) =>
            {
                if (obj != null && obj is InvoiceModel)
                {
                    var model = obj as InvoiceModel;

                    model.Remark = "手动";
                    model.ScanDate = DateTime.Now.ToString("yyyy-MM-dd");
                    model.ScanTime = DateTime.Now.ToString("HH:mm");

                    return InsertOne(obj as InvoiceModel);
                }
                return false;
            });
            view.ShowDialog();
        }

        private Boolean InsertOne(InvoiceModel one)
        {
            if (invoiceList.Count > 0)
            {
                var exist = InvoiceList.Where(f => f.Number == one.Number && f.Code == one.Code);
                if (exist.Count() != 0)
                {
                    //listener.Stop();
                    //isBusy = true;
                    if (MessageBox.Show(string.Format("发票号：{0} 已存在，是否添加？", one.Code), "扫描提示", MessageBoxButton.YesNo, MessageBoxImage.Information) == MessageBoxResult.No)
                    {
                        //  listener.Start();
                        // isBusy = false;
                        return false;
                    }
                }
            }

            one.RowNumber = invoiceList.Count > 0 ? invoiceList.Max(f => f.RowNumber)   1 : 1;
            invoiceList.Add(one);
            return true;
        }

        private Boolean UpdateOne(InvoiceModel one)
        {
            if (invoiceList.Count > 0)
            {
                var exist = InvoiceList.SingleOrDefault(f => f.RowNumber == one.RowNumber);
                if (exist != null)
                {
                    var index = InvoiceList.IndexOf(exist);
                    InvoiceList[index] = one;
                }
            }

            return true;
        }

        private void btnModify_Click(object sender, RoutedEventArgs e)
        {
            var model = (sender as Button).DataContext as InvoiceModel;
            NewView view = new NewView((obj) =>
            {
                if (obj != null && obj is InvoiceModel)
                {
                    return UpdateOne(obj as InvoiceModel);
                }
                return false;
            }, model);
            view.ShowDialog();
        }

        private void btnDelete_Click(object sender, RoutedEventArgs e)
        {
            var model = (sender as Button).DataContext as InvoiceModel;
            var cur = InvoiceList.SingleOrDefault(f => f.RowNumber == model.RowNumber);
            InvoiceList.Remove(cur);
        }

        #region PropertyChanged
        public event PropertyChangedEventHandler PropertyChanged;

        /// <summary>
        /// 属性改变事件
        /// </summary>
        /// <param name="name"></param>
        private void RaisePropertyChanged(string name)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(name));
            }
        }
        #endregion

        private void btnExport_Click(object sender, RoutedEventArgs e)
        {
            if (invoiceList.Count == 0)
            {
                MessageBox.Show("未输入任何内容！");
                return;
            }

            SaveFileDialog fileDialog = new SaveFileDialog();
            fileDialog.RestoreDirectory = true;
            fileDialog.Filter = "Excel(2007-2013)|*.xlsx|Excel(97-2003)|*.xls";
            if (fileDialog.ShowDialog() != true)
            {
                return;
            }


            IWorkbook workbook = new XSSFWorkbook();
            ISheet sheet = workbook.CreateSheet("sheet1");
            IRow rowHead = sheet.CreateRow(0);

            int index = 0;
            rowHead.CreateCell(index  , CellType.String).SetCellValue("NO");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("批次号");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("发票代码");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("发票号码");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("合计金额");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("开票日期");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("扫描日期");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("扫描时间");
            rowHead.CreateCell(index  , CellType.String).SetCellValue("备注");

            //填写内容
            for (int i = 0; i < invoiceList.Count; i  )
            {
                int columnIndex = 0;
                IRow row = sheet.CreateRow(i   1);

                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].RowNumber);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].BatchCode);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].Code);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].Number);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].Amount.ToString());
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].MakeDate);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].ScanDate);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].ScanTime);
                row.CreateCell(columnIndex  , CellType.String).SetCellValue(invoiceList[i].Remark);
            }

            for (int i = 0; i < invoiceList.Count; i  )
            {
                sheet.AutoSizeColumn(i);
            }

            sheet.DisplayGridlines = true;

            using (FileStream stream = File.OpenWrite(fileDialog.FileName))
            {
                workbook.Write(stream);
                stream.Close();
            }
            MessageBox.Show("导出数据成功!", "提示", MessageBoxButton.OK, MessageBoxImage.Information);
            GC.Collect();
        }
    }
}

标签： C# 扫描枪工具扫码

实例下载地址

C# 发票扫码录入工具源码(wpf)

点此下载实例

不能下载？内容有错？点击这里报错 + 投诉 + 提问

好例子网口号：伸出你的我的手 — 分享！

网友评论

我要评论

小贴士

感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。

类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。

关于好例子网

本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见版权及免责申明

C# 发票扫码录入工具源码(wpf)

同类人气实例

实例介绍

实例下载地址

C# 发票扫码录入工具源码(wpf)

相关软件

相关文章

网友评论

小贴士

关于好例子网

下载周排行

下载总排行