/// <summary>
/// 查询相对于的表的列名
/// </summary>
/// <param name="loacalDataBase">数据库</param>
/// <param name="loacaDataTable">表名</param>
/// <returns>返回所有的列名</returns>
private ArrayList GetCloumnByTable(string loacalDataBase, string loacaDataTable)
{
try
{
string strConnction = string.Concat(new string[] {
"SERVER=", CacheGeneral.GetCache("key_localIP").ToString(),
";DATABASE=", loacalDataBase,
";UID=", CacheGeneral.GetCache("key_userAccount").ToString(),
";PWD=", CacheGeneral.GetCache("key_userPwd").ToString(),
});
string strSql = string.Concat(new string[] {
" SELECT COLUMN_NAME,DATA_TYPE,T.VALUE,T.IS_IDENTITY",
" FROM ", loacalDataBase, ".INFORMATION_SCHEMA.COLUMNS ",
" INNER JOIN (SELECT B.NAME,C.VALUE,B.IS_IDENTITY FROM SYS.TABLES A ",
" INNER JOIN SYS.COLUMNS B ON A.OBJECT_ID = B.OBJECT_ID ",
" INNER JOIN SYS.EXTENDED_PROPERTIES C ON C.MAJOR_ID = B.OBJECT_ID AND C.MINOR_ID = B.COLUMN_ID) T ON COLUMN_NAME=T.NAME ",
" WHERE TABLE_NAME = '", loacaDataTable, "'"
});
ArrayList fieldByConAndSql = dbHelper.GetFieldByConAndSql(strConnction, strSql);
return(fieldByConAndSql);
}
catch (Exception ex)
{
Log4net.log4netCreate(typeof(GeneratedFileController), log4netPath)
.Error("GetCloumnByTable(string loacalDataBase, string loacaDataTable) ---- > " + ex.Message);
throw;
}
}
/// <summary>
/// 写入 Txt 文件
/// </summary>
/// <param name="path">写入文件路径,已写入缓存</param>
/// <param name="content">内容</param>
/// <returns>bool 是否成功</returns>
private bool WriterTxt(string content, string path = "")
{
path = CacheGeneral.GetCache("TemplatePath").ToString();
if (string.IsNullOrEmpty(path))
{
return(false);
}
StreamWriter stream = null;
try
{
stream = new StreamWriter(path, false, Encoding.UTF8);
stream.Write(content);
return(true);
}
catch (Exception ex)
{
Log4net.log4netCreate(typeof(GeneratedFileController), log4netPath).Error(" WriterTxt(string path, string content) ----> " + ex.Message);
return(false);
}
finally
{
stream.Close();
stream.Dispose();
}
}
//根据数据库联动表名
public JsonResult LoginTable(string localDB)
{
try
{
string strConnction = string.Concat(new string[] {
"SERVER=", CacheGeneral.GetCache("key_localIP").ToString(),
";DATABASE=MASTER;UID=", CacheGeneral.GetCache("key_userAccount").ToString(),
";PWD=", CacheGeneral.GetCache("key_userPwd").ToString()
});
string sqlStr = @"SELECT TABLE_NAME FROM " + localDB + ".INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME";
string message = (string)null;
ArrayList dataByConAndSql = dbHelper.GetDataByConAndSql(strConnction, sqlStr, out message);
return(Json(new { message = "Success", content = JsonConvert.SerializeObject(dataByConAndSql) }));
}
catch (Exception ex)
{
Log4net.log4netCreate(typeof(GeneratedFileController), log4netPath)
.Error("LoginTable(string localDB) ---- > " + ex.Message);
return(Json(new { message = "Fail", content = "表查询错误," + ex.Message }));
}
}
