static void Main(string[] args) { //string a="<img src=\"/uploads/2016editor/5/31/11/4b1a48f0-8608-49c6-86be-6a7aaeb6c67f.jpg\" alt=\"\" /></span></p><p><span style=\"font-size:16px;\"><img src=\"/uploads/2016editor/5/31/11/cac9b691-0ffc-4cc9-a030-f2273d4c6884.jpg\" alt=\"\" />"; //delete(); //Untils.GetHtml(a); //return; //selectMember(); //string a = string.Empty; ; //Untils.GetHtmlImageUrl(a); //delete(10593); //string a = "测试啊<p><img src='/dadt/yndt/201103/W020110322380977845026.jpg'><img src='http://blog2.cnool.net/dadt/yndt/201103/W020110322380977845026.jpg'></p><img src='/dadt/yndt/201103/W020110322380977845026.jpg'>"; //Untils.GetHtml(a); //string[] b = new string[] { "/dadt/yndt/201103/w020110322380977845026.jpg", "/dadt/yndt/201103.jpg" }; //string a = "<p><img src='/dadt/W020110322380977845026.jpg' alt='' /></p><p><img src='/dadt/yndt/201103/W020110322380977845026.jpg'/></p><img src='http://cnool.net/dadt/yndt/201103/W0201103223809778450262.jpg'/>"; //string sw = Untils.GetHtml(a); string username = string.Empty; string blogName = string.Empty; string sql = string.Empty; int status = 0; string loginName = string.Empty; int userId = 0; try { DataTable dt = new DataTable(); DataConnection dc = new DataConnection(); sql = "select * from DataTransfer where Status=0 "; dt = dc.FillDataTable(sql); if (dt == null || dt.Rows.Count == 0) { Console.WriteLine("没有记录"); return; } else { foreach (DataRow dr in dt.Rows) { username = Convert.ToString(dr["UserName"]); string realName = Convert.ToString(dr["RealName"]); string ip = Convert.ToString(dr["IP"]); status = Convert.ToInt32(dr["Status"]); //获取Member用户表的数据 sql = "select * from ra_pbMember where LoginName= '" + username + "'"; //dt = dc.FillDataTable(sql); DataRow drMember = dc.FillDataRow(sql); userId = Convert.ToInt32(drMember["ID"]); loginName = Convert.ToString(drMember["LoginName"]); string face = Convert.ToString(drMember["Face"]); Admin admin = new Admin(); admin.username = loginName; admin.realname = realName; admin.create_time = DateTime.Now; admin.last_login_ip = ip; admin.roles_name = "单元运营者"; string[] SearchkeyList = Untils.ConvertToSearchkey("单元运营者"); admin.role_name_list = SearchkeyList; admin.isvalid = true; admin.role_list = Array.ConvertAll <string, int>(Untils.ConvertToSearchkey(Convert.ToString(Convert.ToString(10002))), s => int.Parse(s));//string[]转化int[] var adminInfo = AdminManage.getAdminByName(loginName); bool result = false; if (adminInfo == null) { result = AdminManage.CreateAdmin(admin); } else { Untils.WriteProgramLog(loginName + " 已存在!"); result = true; } if (result) { result = UnitManage.InsertUnit(userId, loginName, face); if (result) { sql = "update DataTransfer set Status=1 where UserName='******'"; dc.ExeSql(sql); Untils.WriteProgramLog(loginName + " 导入数据成功!"); } else { Untils.WriteProgramLog(loginName + " 导入数据失败!"); } } else { Untils.WriteProgramLog(loginName + " 导入Admin数据失败!"); } } } } catch (Exception e) { Untils.WriteProgramLog("something wrong in A method: " + e.Message); throw; } }