17,740
社区成员
发帖
与我相关
我的任务
分享
private void Get_tbl_Result(string tablename, string objectid, string counterlist, int omcid, SqlConnection localconn)
{
DataTable tableData = new DataTable();
tableData.TableName = tablename;
bool ret = false;
//组合出SQL
string sql = "";
sql = sql + " select a.NeFdn,a.ObjectMember0," + counterlist + ",'" + OmcDatetimeStr + "' as scantime";
sql = sql + " from tbl_ObjectInstance a, " + tablename + " b ";
sql = sql + " where a.ObjectTypeId=" + objectid;
sql = sql + " and (a.InvalidTime is NULL or a.InvalidTime>EndTime) and b.ObjectNo=a.ObjectNo";
sql = sql + " and b.ObjectNo=a.ObjectNo";
sql = sql + " and b.StartTime='" + OmcDatetimeStr + "'";
//执行SQL
AseCommand command;
AseConnection pmconn1 = new AseConnection(PmConnstr_1_1); ;
if (pmconn1.State == ConnectionState.Closed)
pmconn1.Open();
command = new AseCommand(sql, pmconn1);
command.CommandTimeout = 60*1000;
AseDataAdapter da = new AseDataAdapter(command);
try
{
da.Fill(tableData);
WritePmData_table(tableData, localconn);
tableData.Clear();
tableData.Dispose();
tableData = null;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
ret = true;
}
catch (Exception ex)
{
writeerror(tablename + "出错:" + ex.Message + ";" + sql);
ret = false;
}
if (pmconn1.State == ConnectionState.Open)
pmconn1.Close();
pmconn1.Dispose();
command.Dispose();
da.Dispose();
}
if (this.dt_ObjType_BSC6000.Rows.Count == 0)
{
this.writelog("初始数据采集");
this.GetPMData(PmConnstr_1, 1);//就这一个有问题,另外两个没问题,只是数据库连接串不同
this.GetPMData(PmConnstr_2,3);
this.GetPMData(PmConnstr_3, 4);
}