protected void Page_Load(object sender, EventArgs e)
{
Response.Clear();
string str_sql = "";
IDbHelper sql = GetHelper();
DbDataReader rd = sql.ExecuteReader(CommandType.Text, "select [name] from sysobjects where xtype='U'");
while (rd.Read())
{
string tableName = rd["name"].ToString();
if (tableName.ToLower() == "sysuser")
{
continue;
}
IDbHelper Helper = new SqlHelper(Voodoo.Setting.DataBase.ConnStr);
DataTable dt = Helper.ExecuteDataTable(CommandType.Text, string.Format("select * from [{0}]",tableName));
string str_insert = string.Format("SET IDENTITY_INSERT [{0}] ON ;\n insert into [{0}](", tableName);
for (int i = 0; i < dt.Columns.Count; i++)
{
str_insert += "[" + dt.Columns[i].ColumnName + "]";
if (i != dt.Columns.Count - 1)
{
str_insert += ",";
}
}
str_insert += ") values(";
for (int i = 0; i < dt.Rows.Count; i++)
{
str_sql += str_insert;
for (int j = 0; j < dt.Columns.Count; j++)
{
str_sql += "N'" + dt.Rows[i][j].ToString().Replace("'", "''") + "'";
if (j != dt.Columns.Count - 1)
{
str_sql += ",";
}
}
str_sql += string.Format(")\n SET IDENTITY_INSERT [{0}] OFF ;\n\n\n",tableName);
}
}
rd.Close();
rd.Dispose();
//Response.Write(str_sql);
Voodoo.IO.File.Write(Server.MapPath("~/e/installer/tabledata.txt"), str_sql, System.IO.FileMode.Create);
Response.Write("已经生成到：" + Server.MapPath("~/e/installer/tabledata.txt"));
Response.End();
}
