public void SetDBInfoTest()
{
DataBaseOperAt.SetDBInfo("192.168.2.18", 3306, "alarmsystem", "root", "mypassword", Enum_DataBase.MySQL);
string str = DBHelpMySql.connectionString;
Assert.AreEqual("1", str);
}
public void VideoInfo_DataRowToVideoInfoTest()
{
StringBuilder sbExecSQL = new StringBuilder();
sbExecSQL.Append("SELECT TOP 1 * FROM T_VideoTable ");
sbExecSQL.Append("WHERE HostNumber ='9998' ");
DataTable dtResult = DataBaseOperAt.QuerySQL(sbExecSQL.ToString()).Tables[0];
VideoInfo v = SK3000DataConvert.VideoInfo_DataRowToVideoInfo(dtResult.Rows[0]).DeepCloneObject();
List <VideoInfo> lst = new List <VideoInfo>();
lst.Add(v);
List <VideoInfo> lstV = lst.DeepCloneList().ToList();
Assert.AreEqual(v.VideoType, Enum_VideoType.XMaiVideo);
}
public void ExecSQLTest1()
{
StringBuilder sbExecSQL = new StringBuilder();
int intIndex = 0;
int intResult = 0;
while (intIndex < 100000)
{
sbExecSQL = new StringBuilder();
sbExecSQL.Append("INSERT T_EventRecord(Cen_Code,Dev_ID,Ev_Content) Value ");
for (int i = 0; i < 10000; i++)
{
sbExecSQL.Append("('05950002','00000000011000','测试数据" + intIndex + "'),");
intIndex++;
}
sbExecSQL.Length = sbExecSQL.Length - 1;
intResult = DataBaseOperAt.ExecSQL(sbExecSQL.ToString());
}
Assert.AreEqual(intResult, 1);
}
public void ExecSQLTest()
{
StringBuilder sbExecSQL = new StringBuilder();
int intIndex = 0;
int intResult = 0;
while (intIndex < 1000000)
{
sbExecSQL = new StringBuilder();
sbExecSQL.Append("INSERT T_Device(Cen_Code,Dev_UniqueCode) Value ");
for (int i = 0; i < 100000; i++)
{
sbExecSQL.Append("('05950002','" + intIndex.ToString().PadLeft(14, '0') + "'),");
intIndex++;
}
sbExecSQL.Length = sbExecSQL.Length - 1;
intResult = DataBaseOperAt.ExecSQL(sbExecSQL.ToString());
}
Assert.AreEqual(intResult, 1);
}
public SK3000DataConvertTests()
{
//DataBaseOperAt.SetDBInfo("121.41.87.203", 1433, "报警点基本信息", "sa", "security999", Enum_DataBase.MSSQLServer);
//DataBaseOperAt.SetDBInfo("192.168.5.15", 43399, "报警点基本信息", "sa", "security999", Enum_DataBase.MSSQLServer);
DataBaseOperAt.SetDBInfo("192.168.2.19", 1433, "报警点基本信息1", "sa", "security999", Enum_DataBase.MSSQLServer);
}
public DataBaseOperAtTests()
{
DataBaseOperAt.SetDBInfo("192.168.2.19 ", 3306, "skl9000test3", "root", "security999", Enum_DataBase.MySQL);
}
