基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

用于扫描鼠标键盘的条码信息并记录到CSV文件中, 根据F1/F2不同的功能键调出不同的功能界面.

        /// <summary>
        /// 更新CSV中内容
        /// </summary>
        /// <returns>更新成功返回true, 否则返回false</returns>
        private bool updateFromCsv(string filepath)
        {
            #region 读取CSV内容到datatable中
            string uwip = "1S"   this.mtm   this.sn;
            DataTable mycsvdt = new DataTable("BluePrint");
            try
            {
                int intColCount = 0;
                DataRow mydr;
                DataColumn mydc;
                bool blnFlag = true;
                bool existFlag = false; // CSV文件中是否存在该流水号对应记录

                string strline;
                string[] aryline;
                StreamReader mysr = new StreamReader(filepath, System.Text.Encoding.UTF8);
                while ((strline = mysr.ReadLine()) != null)
                {
                    aryline = strline.Split(new char[] { ',' });
                    intColCount = aryline.Length;

                    //给datatable加上列名
                    if (blnFlag)
                    {
                        blnFlag = false;
                        for (int i = 0; i < aryline.Length; i  )
                        {
                            mydc = new DataColumn(i.ToString());
                            mycsvdt.Columns.Add(mydc);
                        }
                    }

                    if (!uwip.Equals(aryline[3].Trim().ToUpper()))
                    {
                        //填充数据并加入到datatable中
                        mydr = mycsvdt.NewRow();
                        for (int i = 0; i < intColCount; i  )
                        {
                            mydr[i] = aryline[i];
                        }
                        mycsvdt.Rows.Add(mydr);
                    }
                    else
                    {
                        //存在相同流水号的记录,更新之
                        existFlag = true;
                        mydr = mycsvdt.NewRow();
                        mydr[0] = this.so;
                        mydr[1] = this.mtm;
                        mydr[2] = this.order;
                        mydr[3] = uwip;
                        mydr[4] = this.mousePart;
                        mydr[5] = this.mouseVenvorPart;
                        mydr[6] = this.kybPart;
                        mydr[7] = this.kybVendorPart;
                        mydr[8] = this.moQty;
                        mycsvdt.Rows.Add(mydr);
                    }
                }
                mysr.Close();

                if (!existFlag)
                {
                    //不存在同流水号的记录,新增之
                    mydr = mycsvdt.NewRow();
                    mydr[0] = this.so;
                    mydr[1] = this.mtm;
                    mydr[2] = this.order;
                    mydr[3] = uwip;
                    mydr[4] = this.mousePart;
                    mydr[5] = this.mouseVenvorPart;
                    mydr[6] = this.kybPart;
                    mydr[7] = this.kybVendorPart;
                    mydr[8] = this.moQty;
                    mycsvdt.Rows.Add(mydr);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return false;
            }
            #endregion

            #region 将datatable内容写回到CSV中
            try
            {
                FileStream fs_csv = new FileStream(filepath, FileMode.Create, FileAccess.Write, FileShare.None);
                StreamWriter sw_csv = new StreamWriter(fs_csv);
                for (int i = 0; i < mycsvdt.Rows.Count; i  )
                {
                    string strContent = "";
                    for (int j = 0; j < mycsvdt.Columns.Count; j  )
                    {
                        if (j   1 == mycsvdt.Columns.Count)
                            strContent  = mycsvdt.Rows[i][j];
                        else
                            strContent  = mycsvdt.Rows[i][j]   ",";
                    }
                    sw_csv.Write(strContent   "\n");
                }

                sw_csv.Close();
                fs_csv.Close();

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return false;
            }
            #endregion
        }

        /// <summary>
        /// 从CSV文件删除指定流水号的记录
        /// </summary>
        /// <param name="filepath">是指csv文件的路径</param>
        /// <param name="uwip">用来查询目标流水号</param>
        /// <returns>删除成功返回true, 否则返回false</returns>
        private bool delFromCsv(string filepath, string uwip)
        {
            #region 读取CSV内容到datatable中
            DataTable mycsvdt = new DataTable("BluePrint");
            bool existFlag = false; //流水号对应记录是否存在
            try
            {   
                int intColCount = 0;
                DataRow mydr;
                DataColumn mydc;
                bool blnFlag = true;

                string strline;
                string[] aryline;
                StreamReader mysr = new StreamReader(filepath, System.Text.Encoding.UTF8);
                while ((strline = mysr.ReadLine()) != null)
                {
                    aryline = strline.Split(new char[] { ',' });
                    intColCount = aryline.Length;

                    //给datatable加上列名
                    if (blnFlag)
                    {
                        blnFlag = false;
                        for (int i = 0; i < aryline.Length; i  )
                        {
                            mydc = new DataColumn(i.ToString());
                            mycsvdt.Columns.Add(mydc);
                        }
                    }

                    if (!uwip.Equals(aryline[3].Trim().ToUpper()))
                    {
                        //填充数据并加入到datatable中
                        mydr = mycsvdt.NewRow();
                        for (int i = 0; i < intColCount; i  )
                        {
                            mydr[i] = aryline[i];
                        }
                        mycsvdt.Rows.Add(mydr);
                    }
                    else
                    {
                        existFlag = true;
                    }
                }
                mysr.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return false;
            }
            #endregion

            // 若流水号对应记录不存在则勿需删除
            if (!existFlag) return true;

            #region 将datatable内容写回到CSV中
            try
            {
                FileStream fs_csv = new FileStream(filepath, FileMode.Create, FileAccess.Write, FileShare.None);
                StreamWriter sw_csv = new StreamWriter(fs_csv);
                for (int i = 0; i < mycsvdt.Rows.Count; i  )
                {
                    string strContent = "";
                    for (int j = 0; j < mycsvdt.Columns.Count; j  )
                    {
                        if (j   1 == mycsvdt.Columns.Count)
                            strContent  = mycsvdt.Rows[i][j];
                        else
                            strContent  = mycsvdt.Rows[i][j]   ",";
                    }
                    sw_csv.Write(strContent   "\n");
                }

                sw_csv.Close();
                fs_csv.Close();

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return false;
            }
            #endregion
        }