public void WriteLog(object[] parms)
{
string tagID = (string)parms[0];
string moduleid = (string)parms[1];
string basic = (string)parms[2];
tagID = tagID.Replace(" ", "");
string createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string sql = @"
insert into rt_rfid_writedlog(tagid,moduleid,createtime,basicbuff,pointbuff)
values('{0}','{1}','{2}','{3}','')
";
sql = string.Format(sql, tagID, moduleid, createtime, basic);
if (m_dbType == DB_Type.MySql)
{
DBOperation.ExecuteNonQuery(m_mysql_conn, sql);
}
else if (m_dbType == DB_Type.SqlServer)
{
// DBOperation.ExecuteMSSqlServerNonQuery(m_ms_conn1, sql);
}
}
public void WriteLog(object[] parms)
{
string tagID = (string)parms[0];
string moduleid = (string)parms[1];
string basic = (string)parms[2];
tagID = tagID.Replace(" ", "");
string createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
#if SQLSERVER_TengHui
string sql = @"
insert into dbo.rfid_writedlog(tagid,serial_nbr,create_date,basicbuff,pointbuff)
values('{0}','{1}','{2}','{3}','')
";
sql = string.Format(sql, tagID, moduleid, createtime, basic);
DBOperation.ExecuteMSSqlServerNonQuery(connect_string, sql);
#endif
#if SQLSERVER_LOCALHOST
string sql = @"
insert into mes_main.dbo.rfid_writedlog(tagid,serial_nbr,create_date,basicbuff,pointbuff)
values('{0}','{1}','{2}','{3}','')
";
sql = string.Format(sql, tagID, moduleid, createtime, basic);
DBOperation.ExecuteMSSqlServerNonQuery(connect_string, sql);
#endif
#if MYSQL_CLOUD
string sql = @"
insert into rt_rfid_writedlog(tagid,ModuleID,CreateTime,basicbuff,pointbuff)
values('{0}','{1}','{2}','{3}','')
";
sql = string.Format(sql, tagID, moduleid, createtime, basic);
DBOperation.ExecuteNonQuery(connect_string, sql);
#endif
}
