项目需求:Marc数据转换DataTable

版权声明:转载原创文章请以超链接形式请注明原文章出处,尊重作者,尊重原创!


恰饭广告




参考文档:https://bbs.csdn.net/topics/230048997

业务需求:marc数据转为dt,dt导入mysql,馆藏字段值若不为正整数将默认为0

实现效果:

marc转换dt

js前端:

$("#confirmImport").click(function () {
        var fisbn = $("#fisbn").val();
        var sisbn = $("#sisbn").val();
        var fbookName = $("#fbookName").val();
        var sbookName = $("#sbookName").val();
        var fprice = $("#fprice").val();
        var sprice = $("#sprice").val();
        var fnum = $("#fnum").val();
        var snum = $("#snum").val();
        if (fisbn == "" || sisbn == "" || fbookName == "" || sbookName == "" || fprice == "" || sprice == "" || fnum == "" || snum == "") {
           alert("不能含有未填项");
        }
        else if (fisbn.length != 3 || fbookName.length != 3 || fprice.length != 3 || fnum.length != 3) {
           alert("字段号不能小于3位数");
        }
        else {
            $("#myModal1").modal("show");
            $("#close").hide();
            $.ajax({
                type: 'Post',
                url: 'collectionManagement.aspx',
                data: {
                    fisbn: fisbn,
                    sisbn: sisbn,
                    fbookName: fbookName,
                    sbookName: sbookName,
                    fprice: fprice,
                    sprice: sprice,
                    fnum: fnum,
                    snum: snum,
                    action: "import"
                },
                dataType: 'text',
                success: function (data) {
                    if (data.indexOf("导入成功") >= 0) {
                        $("#myModalLabe1").html(data);
                        $("#close").show();
                        $("#img").attr("src", "../imgs/success.png");
                        sessionStorage.setItem("import", "导入成功");
                    } else if (data.indexOf("导入失败") >= 0) {
                        $("#myModalLabe1").html(data);
                        $("#close").show();
                        $("#img").attr("src", "../imgs/lose.png");
                        sessionStorage.setItem("import", "导入失败");
                    }
                    else {
                        sessionStorage.setItem("import", "导入失败");
                        $("#close").show();
                        alert(data);
                    }
                }
            });
        }
    });

C#后台:

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;

namespace bms.Bll
{
    public class MarcToDt
    {
        private static StreamReader FileReadStream;
        private static FileStream CheckStream;
        private static string FilePath;

        /// <summary>
        /// 计算由汉字引起的偏移地址误差,返回汉字个数
        /// </summary>
        ///<param name="Buff">待统计的字符串</param>
        ///<param name="StartIndex">开始位置</param>
        ///<param name="EndIndex">截至位置</param>
        /// <returns></returns>
        private int GetOffSet(string Buff, int StartIndex, int EndIndex)
        {
            char[] temp = Buff.ToCharArray();
            int LetterCount = 0, HanZiCount = 0;
            for (int i = StartIndex; i < EndIndex; i++)
            {
                int test = (int)temp[i];
                if (test < 128)
                {
                    LetterCount++;
                }
                else
                {
                    HanZiCount++;
                }
                if (HanZiCount * 2 + LetterCount == EndIndex - StartIndex)
                {
                    return HanZiCount;
                }
            }
            return HanZiCount;
        }

        /// <summary>
        /// 返回Buff中的字段号为 Member, 子字段号为 ZiMember 的数据
        /// </summary>
        /// <param name="Buff"></param>
        /// <param name="Member">字段号</param>
        /// <param name="SubMember">子字段号</param>
        /// <param name="Data_Addr">地址区基地址</param>
        /// <returns></returns>
        private string GetRecord(string Buff, string Member, string SubMember, string IndexRecord, int Data_Addr)
        {
            string temp1 = ((char)30).ToString(); //子记录分隔符
            string temp2 = ((char)31).ToString(); //子字段分隔符
            if (SubMember != "")
            {
                SubMember = temp2 + SubMember;
            }
            string SubMbrData = "";
            int Address;
            int Len;
            string Sub;
            int SubMbrIndex;
            int SubMbrLen;
            for (int i = 0; i < IndexRecord.Length / 12; i++)
            {
                if (Member == IndexRecord.Substring(i * 12, 3))
                {
                    //子记录相对于数据区偏移地址
                    Address = int.Parse(IndexRecord.Substring(i * 12 + 7, 5));
                    //子记录长度
                    Len = int.Parse(IndexRecord.Substring(i * 12 + 3, 4));
                    //子记录数据
                    int test = GetOffSet(Buff, 0, Address + Data_Addr);
                    Len -= GetOffSet(Buff, Data_Addr + Address - test, Data_Addr + Address - test + Len);

                    Sub = Buff.Substring(Data_Addr + Address - test, Len);
                    int a = Sub.Length;
                    test = Sub.IndexOf(temp2);
                    if (Sub.IndexOf(temp2) == Sub.Length - 1)
                    {
                        //如果该子记录无子字段
                        return Sub.Substring(0, Sub.Length - 1);
                    }
                    //子字段开始位置0
                    SubMbrIndex = Sub.IndexOf(SubMember) + SubMember.Length;
                    //子字段长度

                    int test11 = Sub.IndexOf(temp2, SubMbrIndex + 2);


                    bool IsEnd = (Sub.IndexOf(temp2, SubMbrIndex) == -1);
                    if (!IsEnd)
                    {
                        SubMbrLen = Sub.IndexOf(temp2, SubMbrIndex) - SubMbrIndex;
                    }
                    else
                    {
                        SubMbrLen = Sub.IndexOf(temp1, SubMbrIndex) - SubMbrIndex;
                    }
                    //子字段数据
                    int NextIndex = Sub.IndexOf(temp2, SubMbrIndex + 1); //下一个子字段分隔符的位置
                    if (NextIndex == -1)
                    {
                        SubMbrData = Sub.Substring(SubMbrIndex, SubMbrLen);
                    }
                    else
                    {
                        SubMbrData = Sub.Substring(SubMbrIndex, SubMbrLen);
                    }

                    break;
                }
            }
            char[] test22 = SubMbrData.ToCharArray();
            return SubMbrData;
        }

        /// <summary>
        /// 判断是否为正整数
        /// </summary>
        /// <param name="strSrc"></param>
        /// <returns></returns>
        private bool isInt(string str)
        {
            bool blResult = true;//默认状态下是数字 
            if (str == "")
                blResult = false;
            else
            {
                foreach (char Char in str)
                {
                    if (!char.IsNumber(Char))
                    {
                        blResult = false;
                        break;
                    }
                }
                if (blResult)
                {
                    if (int.Parse(str) == 0)
                        blResult = false;
                }
            }
            return blResult;
        }

        /// <summary>
        /// 判断是否为>0数字
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        private bool isNum(string str)
        {
            Regex reg1 = new Regex(@"^[-]?\d+[.]?\d*$");
            if (reg1.IsMatch(str) && Convert.ToDouble(str) >= 0)
            {
                return true;
            }
            else
            {
                return false; //非数字
            }
        }

        /// <summary>
        /// marc转换为馆藏dt
        /// </summary>
        /// <param name="Path"></param>
        /// <returns></returns>
        public DataTable MarcTodt(string Path,string fisbn,string sisbn,string fbookName,string sbookName,string fprice,string sprice,string fnum,string snum)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("id", System.Type.GetType("System.String"));
            dt.Columns.Add("ISBN", System.Type.GetType("System.String"));
            dt.Columns.Add("书名", System.Type.GetType("System.String"));
            dt.Columns.Add("定价", System.Type.GetType("System.String"));
            dt.Columns.Add("馆藏数量", System.Type.GetType("System.String"));
            DataColumn[] pris = new DataColumn[1];
            CheckStream = new FileStream(Path, FileMode.Open, FileAccess.Read, FileShare.Read);
            FileReadStream = new StreamReader(Path, System.Text.Encoding.Default);
            FilePath = Path;
            string BuffStr;
            int CurrLine = 1;
            while ((int)(FileReadStream.Peek()) >= 0)
            {
                try
                {
                    BuffStr = FileReadStream.ReadLine();//读取FileReadStream中一行字符,并赋值给BuffStr
                    if (BuffStr.Length > 0)
                    {
                        dt.Rows.Add(GetData(BuffStr,fisbn,sisbn,fbookName,sbookName,fprice,sprice,fnum,snum)); //加入到dt中
                        CurrLine++;

                    }
                }
                catch
                {

                    CurrLine--;
                }
            }
            FileReadStream.Close();
            dt.TableName = Path;
            return dt;
        }

        private string[] GetData(string Buff, string fisbn, string sisbn, string fbookName, string sbookName, string fprice, string sprice, string fnum, string snum)
        {
            if (Buff.Length == 0)
            {
                return new string[8];
            }
            string id = "";
            string isbn = "";
            string bookName = "";
            string price = "";
            string num = "0";
            int IndexLen = int.Parse(Buff.Substring(12, 5)) - 25;
            string IndexRecord = Buff.Substring(24, IndexLen); //目次区内容
            int Data_Address = int.Parse(Buff.Substring(12, 5)); //数据区地址
            isbn = GetRecord(Buff, fisbn, sisbn, IndexRecord, Data_Address).Trim().Replace("-", "");
            bookName = GetRecord(Buff, fbookName, sbookName, IndexRecord, Data_Address).Trim();
            price = GetRecord(Buff, fprice, sprice, IndexRecord, Data_Address).Trim().Replace("CNY", "");
            string num2 = GetRecord(Buff, fnum, snum, IndexRecord, Data_Address).Trim();
            //if (!isNum(price2))
            //{
            //    price = "0";
            //}
            //else
            //{
            //    price = price2;
            //}
            if (!isInt(num2))
            {
                num = "0";
            }
            else
            {
                num = num2;
            }
            string[] ret = { id,isbn, bookName, price, num };
            return ret;
        }
    }
}

Marc字段查看软件及测试数据:下载

原文链接:https://www.idaobin.com/archives/2007.html

让我恰个饭吧.ヘ( ̄ω ̄ヘ)

支付宝 ——————- 微信
图片加载中图片加载中



恰饭广告

发表评论

电子邮件地址不会被公开。 必填项已用*标注

− 2 = 6