用c#做一个网页，这个网页的主要功能是选择一个txt文件，将里面的数据载入到sql数据库里并验证重复性。

我才做了这样一个功能，给你代码：（原理：正则表达式） /// <summary> /// 将列表读取到datatable中 /// </summary> /// <returns></returns> private datatable readtext2datatable(string filename,int length) { datatable dt = new datatable(); datetime times = datetime.now; string date = times.tostring("yyyymmdd"); string time = times.tostring("hh:mm:ss"); if (filename != "") { l**t<string> filecontent = getl**t(filename, length); //datatable-设置列 dt.columns.add("ab000");//公司代码-master_t_cocode dt.columns.add("ab001");//储位区代码 dt.columns.add("ab002");//材料号 dt.columns.add("ab003");//日期-date dt.columns.add("ab004");//时间-time dt.columns.add("ab005");//出入别-1 dt.columns.add("ab006");//订单单别 dt.columns.add("ab007");//订单单号 dt.columns.add("ab008");//订单序号 dt.columns.add("ab009");//交货总数量 dt.columns.add("ab010");//批号-"" dt.columns.add("ab011");//周期 dt.columns.add("ab012");//状态-y dt.columns.add("ab013");//交货件数 dt.columns.add("ab014");//每箱数量 dt.columns.add("ab021");//xuser-master_t_empno dt.columns.add("ab022");//xdate-date dt.columns.add("ab023");//xtime-time //datatable-赋值 if(length==5) for (int i = 0; i <= filecontent.count / length - 1; i++) { datarow dr = dt.rows.add(); string[] sarr_code = filecontent[length * i].split('-'); string[] sarr_num = filecontent[length * i + 2].split('-'); dr["ab000"] = master_t_cocode; //公司代码 dr["ab001"] = filecontent[length * i + 4];//储位区代码 dr["ab002"] = filecontent[length * i + 1];//材料号 dr["ab003"] = date; //日期 dr["ab004"] = time; //时间 dr["ab005"] = "1"; //出入别 dr["ab006"] = sarr_code[0]; //订单单别 dr["ab007"] = sarr_code[1]; //订单单号 dr["ab008"] = sarr_code[2]; //订单序号 dr["ab009"] = sarr_num[0]; //交货总数量 dr["ab010"] = ""; //批号 dr["ab011"] = filecontent[length * i + 3];//周期 dr["ab012"] = "y"; //状态 dr["ab013"] = sarr_num[1]; //交货件数 dr["ab014"] = sarr_num[2]; //每箱数量 dr["ab021"] = master_t_empno; //xuser dr["ab022"] = date; //xdate dr["ab023"] = time; //xtime } if (length == 7) for (int i = 0; i <= filecontent.count / length - 1; i++) { datarow dr = dt.rows.add(); string[] sarr_code = filecontent[length * i].split('-'); dr["ab000"] = master_t_cocode; //公司代码 dr["ab001"] = filecontent[length * i + 6];//储位区代码 dr["ab002"] = filecontent[length * i + 1];//材料号 dr["ab003"] = date; //日期 dr["ab004"] = time; //时间 dr["ab005"] = "1"; //出入别 dr["ab006"] = sarr_code[0]; //订单单别 dr["ab007"] = sarr_code[1]; //订单单号 dr["ab008"] = sarr_code[2]; //订单序号 dr["ab009"] = filecontent[length * i + 2];//交货总数量 dr["ab010"] = ""; //批号 dr["ab011"] = filecontent[length * i + 5];//周期 dr["ab012"] = "y"; //状态 dr["ab013"] = filecontent[length * i + 3];//交货件数 dr["ab014"] = filecontent[length * i + 4];//每箱数量 dr["ab021"] = master_t_empno; //xuser dr["ab022"] = date; //xdate dr["ab023"] = time; //xtime } } else { dt = **; } return dt; } //读取文本中的数据项列表 private l**t<string> getl**t(string filename,int length) { l**t<string> filecontent = new l**t<string>(); if (filename != "") { using (filestream fs = new filestream(filename, filemode.open)) { string s1 = ""; string s2 = ""; boolean b = false; streamreader sr = new streamreader(fs, encoding.getencoding("gb2312")); //读取文本内容 int i = 0; while (sr.peek() > 0) { if (b) { s1 = sr.readline().trim(); if (s1 != "") { if (s1 == "x") //x前面的项－去掉 { if (filecontent.count > 0) if (filecontent[i - 1] == s2) { filecontent.removeat(filecontent.count - 1); b = false; i--; } } else if (s1 == s2) //相临重复项－无操作 { } else { if (checkinput(i, s1,length)) { filecontent.add(s1); i++; } b = false; } } } else { s2 = sr.readline().trim(); if (s2 != "") { if (s2 == "x") //x前面的项－去掉 { if (filecontent.count > 0) if (filecontent[i - 1] == s1) { filecontent.removeat(filecontent.count - 1); b = true; i--; } } else if (s2 == s1) //相临重复项－无操作 { } else { if (checkinput(i, s2,length)) { filecontent.add(s2); i++; } b = true; } } } } sr.close(); } } return filecontent; } #region 导入验证 /// <summary> /// 检查输入字符串的格式 /// </summary> /// <param name="index">对比索引</param> /// <param name="str">对比字符串</param> /// <param name="length">条码个数</param> private boolean checkinput(int index, string str, int length) { index = index % length; if (length == 5) { if (index == 0) { return **stringsplit(str); } if (index == 1) { return **stringsplitround(str); } if (index == 2) { return **numbersplit(str); } if (index == 3) { return **numberstring(str); } if (index == 4) { return **numberstringzero(str); } return false; } if (length == 7) { if (index == 0) { return **stringsplit(str); } if (index == 1) { return **stringsplitround(str); } if (index == 2) { return **numberstring(str); } if (index == 3) { return **numberstring(str); } if (index == 4) { return **numberstring(str); } if (index == 5) { return **numberstring(str); } if (index == 6) { return **numberstringzero(str); } return false; } return false; } /// <summary> /// 验证字符串是否只包含数字和分隔符,且可以以字母开头 /// </summary> /// <param name="str"></param> /// <returns></returns> private bool **stringsplit(string str) { if (str == ** || str == "") return false; //return regex.**match(str, "\\b[a-za-z0-9]{3,4}-[0-9]{8}-[0-9]{4}\\b"); match mch = regex.match(str, "\\b[a-za-z0-9]{3,4}-[0-9]{8}-[0-9]{4}\\b"); if (mch.value.length == str.length) return true; else return false; } /// <summary> /// 验证字符串是否只包含数字和分隔符,且可以以字母开头 /// </summary> /// <param name="str"></param> /// <returns></returns> private bool **stringsplitround(string str) { if (str == ** || str == "") return false; match mch = regex.match(str, "\\b[a-za-z0-9]{2,3}-[a-za-z0-9]+[-[0-9]{1,3}]?\\b"); if (mch.value.length == str.length) return true; else return false; } /// <summary> /// 验证字符串是否只包含数字和分隔符 /// </summary> /// <param name="str"></param> /// <returns></returns> private bool **numbersplit(string str) { if (str == ** || str == "") return false; match mch = regex.match(str, "\\b[1-9][0-9]*-[1-9][0-9]*-[1-9][0-9]*\\b"); if (mch.value.length == str.length) return true; else return false; } /// <summary> /// 验证字符串是否只包含数字 /// </summary> /// <param name="str">需判断的字符串</param> /// <returns></returns> private bool **numberstring(string str) { if (str == ** || str == "") return false; match mch = regex.match(str, "\\b[1-9][0-9]*\\b"); if (mch.value.length == str.length) return true; else return false; } /// <summary> /// 验证字符串是否只包含数字 /// </summary> /// <param name="str">需判断的字符串</param> /// <returns></returns> private bool **numberstringzero(string str) { if (str == ** || str == "") return false; match mch = regex.match(str, "\\b[0-9]*[1-9][0-9]*\\b"); if (mch.value.length == str.length) return true; else return false; } #endregion 20210311