版权声明：转载原创文章请以超链接形式请注明原文章出处，尊重作者，尊重原创！
恰饭广告
参考文档：https://bbs.csdn.net/topics/230048997
业务需求：marc数据转为dt，dt导入mysql，馆藏字段值若不为正整数将默认为0
实现效果：
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
让我恰个饭吧.ヘ(￣ω￣ヘ)
支付宝 ——————- 微信
恰饭广告
