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;
}
}