| 发表于:2007-09-19 11:23:548楼 得分:0 |
////////////////////////////////////////////cs代码。 using system; using system.data; using system.configuration; using system.collections; using system.web; using system.web.security; using system.web.ui; using system.web.ui.webcontrols; using system.web.ui.webcontrols.webparts; using system.web.ui.htmlcontrols; using system.io; using system.text.regularexpressions; using system.data.oledb; [ajaxpro.ajaxnamespace( "adminparaimp ")] public partial class admin_paraimp : system.web.ui.page { protected void page_load(object sender, eventargs e) { controlhelper.addstylesheet(this.page, "./styles/article.css "); controlhelper.addscript(this.page, "./scripts/paraimp.js "); lotcls.attributes.add( "onchange ", "setfirst(this); "); ajaxpro.utility.registertypeforajax(typeof(admin_paraimp)); } [ajaxpro.ajaxmethod] public string getclslists(string cls) { //paranode.items.clear(); //paranode.items.add(new listitem( "0 ", "正在载入数据…… ")); data db = new data(); datatable dt = db.select( "select * from tb_paraclsdad where lotclsid= " + cls); db.close(); string retval = " "; int tag=0; foreach (datarow r in dt.rows) { if (tag == 0) { retval = r[ "paraclsname "].tostring() + ": " + r[ "paraclsdad "].tostring(); tag = 1; } else { retval += " ¦ " + r[ "paraclsname "].tostring() + ": " + r[ "paraclsdad "].tostring(); } } dt.dispose(); return retval; } [ajaxpro.ajaxmethod] public string getparalists(string paraclsdad) { data db = new data(); datatable dt = db.select( "select * from tb_paracls where paraclsdad= " + paraclsdad); db.close(); string retval = " "; int tag = 0; foreach (datarow r in dt.rows) { if (tag == 0) { retval = r[ "pcname "].tostring() + ": " + r[ "pcid "].tostring(); tag = 1; } else { retval += " ¦ " + r[ "pcname "].tostring() + ": " + r[ "pcid "].tostring(); } } dt.dispose(); return retval; } [ajaxpro.ajaxmethod] public int btnsumbit_click(string pcid,string pcname,string paralist) { //if (ctlupload.postedfile.contentlength < 5) //{ // //response.write( "失败-文件太小了 "); // ; //} //// string pcid = "a001 ";// request.form[ "ctl00_contentplaceholder1_paranode "];//paranode.selectedvalue; if (!chk.natureint(pcid)) { page.registerclientscriptblock( "err ", " <script> alert( '请选择正确有效的参数名+[ " + pcid + "] '); </script> "); //return 0; } //string fname = server.mappath( "../uploads/ ") + datetime.now.tostring( "yyyy-mm-dd_hh-mm-ss_fff ") + ".txt "; //ctlupload.postedfile.saveas(fname); //string ret = txtparalist.text; //streamreader cin = file.opentext(fname); //string curline= " "; ////string pattern=@ "^\d{4}\x20\d{3}\x20\d{1,10}\x20\d{1,10}\x20\d{1,10}\x20\d{1,2}\x20\d{1,2}$ "; ////匹配模式:6001 701 2368 359 246 10 2 string pattern = @ "^\*\d{4}\*.\*\d{3}\*.\*\d{0,10}\*.\*\d{0,10}\*.\*\d{0,10}\*.\*\d{1,2}\*$ "; //匹配模式*6005*.*164*.*02368*.*23659*.*0569*.*1* string[] lines = paralist.replace(convert.tochar(13).tostring(), " ").split( '\n '); int ret = 0; for (int i = 0; i < lines.length; i++) { data db = new data(); if (regex.ismatch(lines[i], pattern)) { string[] paras = lines[i].replace( "* ", " ").split( '. '); string len = ((int)(paras[2].length + paras[3].length + paras[4].length)).tostring(); string sql = "insert into tb_para(pcname,pcid,paraterm,parareal,paraa,parab,parac,paracnt,parahit) values "; sql += "( ' " + pcname + " ', " + pcid + ", ' " + paras[0] + " ', ' " + paras[1] + " ', ' " + paras[2] + " ', ' " + paras[3] + " ', ' " + paras[4] + " ', " + len + ", " + paras[5] + ") "; db.EXEC(sql); ret++; } else { ;// ret = convert.toint16(lines[i][lines[i].length - 1]); } db.close(); } return ret; } } | | |
|