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 }