// 获得表中列信息
// select *
// from UFDLImport.INFORMATION_SCHEMA.COLUMNS
// where table_name = 'OMPlan'
// order by table_name,ordinal_position
public static ClsGetSQL Instance()
{
if (clsGetSQL == null)
{
lock (lockHelper)
{
if (clsGetSQL == null)
{
clsGetSQL = new ClsGetSQL();
}
}
}
return(clsGetSQL);
}
public static bool GetChange(string tablename, string tablenames, string tablenamel, string id, ClsGetSQL clsGetSQL, System.Collections.ArrayList aList)
{
string sSQL = "";
sSQL = "select isnull(max(HistoryNum)+1,1) as HistoryId from " + tablename + "History";
long HistoryNum = long.Parse(clsSQLCommond.ExecQuery(sSQL).Rows[0][0].ToString());
sSQL = "select isnull(max(HistoryId)+1,1) as HistoryId from " + tablename + "History";
long HistoryId = long.Parse(clsSQLCommond.ExecQuery(sSQL).Rows[0][0].ToString());
sSQL = "select isnull(max(HistoryId)+1,1) as HistoryId from " + tablenames + "History";
long HistoryIds = long.Parse(clsSQLCommond.ExecQuery(sSQL).Rows[0][0].ToString());
sSQL = "select isnull(max(HistoryId)+1,1) as HistoryId from " + tablenamel + "History";
long HistoryIdsl = long.Parse(clsSQLCommond.ExecQuery(sSQL).Rows[0][0].ToString());
sSQL = "select * from " + tablename + " where ID=" + id;
DataTable dtalter = clsSQLCommond.ExecQuery(sSQL);
sSQL = "select * from " + tablenames + " where ID=" + id;
DataTable dtsalter = clsSQLCommond.ExecQuery(sSQL);
sSQL = "select * from " + tablenamel + " where ID=" + id;
DataTable dtslalter = clsSQLCommond.ExecQuery(sSQL);
sSQL = "select * from " + tablename + "History where 1=-1";
DataTable dtalterHistory = clsSQLCommond.ExecQuery(sSQL);
sSQL = "select * from " + tablenames + "History where 1=-1";
DataTable dtsHistory = clsSQLCommond.ExecQuery(sSQL);
sSQL = "select * from " + tablenamel + "History where 1=-1";
DataTable dtslHistory = clsSQLCommond.ExecQuery(sSQL);
for (int i = 0; i < dtalter.Rows.Count; i++)
{
DataRow dwalter = dtalterHistory.NewRow();
dwalter["HistoryId"] = HistoryId;
dwalter["HistoryTime"] = DateTime.Now.ToString().Trim();
dwalter["HistoryNum"] = HistoryNum;
for (int j = 0; j < dtalter.Columns.Count; j++)
{
if (dtalter.Rows[i][j].ToString() != "")
{
dwalter[dtalter.Columns[j].ColumnName] = dtalter.Rows[i][j].ToString();
}
}
dtalterHistory.Rows.Add(dwalter);
sSQL = clsGetSQL.GetInsertSQL(系统服务.ClsBaseDataInfo.sDataBaseName, tablename + "History", dtalterHistory, dtalterHistory.Rows.Count - 1);
aList.Add(sSQL);
HistoryId = HistoryId + 1;
}
for (int i = 0; i < dtsalter.Rows.Count; i++)
{
DataRow dwalter = dtsHistory.NewRow();
dwalter["HistoryId"] = HistoryIds;
dwalter["HistoryTime"] = DateTime.Now.ToString().Trim();
dwalter["HistoryNum"] = HistoryNum;
for (int j = 0; j < dtsalter.Columns.Count; j++)
{
if (dtsalter.Rows[i][j].ToString() != "")
{
dwalter[dtsalter.Columns[j].ColumnName] = dtsalter.Rows[i][j].ToString();
}
}
dtsHistory.Rows.Add(dwalter);
sSQL = clsGetSQL.GetInsertSQL(系统服务.ClsBaseDataInfo.sDataBaseName, tablenames + "History", dtsHistory, dtsHistory.Rows.Count - 1);
aList.Add(sSQL);
HistoryIds = HistoryIds + 1;
}
for (int i = 0; i < dtslalter.Rows.Count; i++)
{
DataRow dwalter = dtslHistory.NewRow();
dwalter["HistoryId"] = HistoryIdsl;
dwalter["HistoryTime"] = DateTime.Now.ToString().Trim();
dwalter["HistoryNum"] = HistoryNum;
for (int j = 0; j < dtslalter.Columns.Count; j++)
{
if (dtslalter.Rows[i][j].ToString() != "")
{
dwalter[dtslalter.Columns[j].ColumnName] = dtslalter.Rows[i][j].ToString();
}
}
dtslHistory.Rows.Add(dwalter);
sSQL = clsGetSQL.GetInsertSQL(系统服务.ClsBaseDataInfo.sDataBaseName, tablenamel + "History", dtslHistory, dtslHistory.Rows.Count - 1);
aList.Add(sSQL);
HistoryIdsl = HistoryIdsl + 1;
}
return(true);
}
