private static void TestForAllInOneInterface(object obj)
{
string extSql = (string)obj;
MySqlDrive mySql = new MySqlDrive("Server=192.168.200.152;UserId=root;Password=xpsh;Database=huala_goods");
//MySqlDrive mySql = new MySqlDrive("Server=192.168.200.24;UserId=qa;Password=123456;Database=xinyunlian_member");
mySql.OnDriveStateChange += mySql_OnDriveStateChange;
mySql.OnGetErrorMessage += mySql_OnGetErrorMessage;
mySql.OnGetInfoMessage += mySql_OnGetInfoMessage;
//DataTable myTable = mySql.ExecuteQuery("select store_name , SUID,UUID from store limit 100 , 50");
DataTable myTable = mySql.ExecuteQuery(extSql);
if (myTable != null)
{
foreach (DataRow rows in myTable.Rows)
{
bool isDataOk = true;
foreach (var filed in rows.ItemArray)
{
if (filed == null)
{
isDataOk = false;
break;
}
}
if (!isDataOk)
{
Console.WriteLine("find Error data");
break;
}
int ThreadId = Thread.CurrentThread.ManagedThreadId;
Console.WriteLine(String.Format("【ThreadId:{1}】{0} :开始同步.......", rows[0].ToString(), ThreadId));
//string tempRespans = MyCommonHelper.NetHelper.MyWebTool.MyHttp.SendData(String.Format("https://wxv4.huala.com/huala/seller/login/AllInOneNative?suid={0}&uuid={1}", rows[1].ToString(), rows[2].ToString()));
string tempRespans = myHttp.SendData(String.Format("https://wxwyjtest.huala.com/huala/seller/login/AllInOneNative?suid={0}&uuid={1}", rows[1].ToString(), rows[2].ToString()));
if (tempRespans.Contains("\"success\":true"))
{
Console.WriteLine("同步完成");
}
else
{
Console.WriteLine("同步错误");
}
System.Diagnostics.Debug.WriteLine("--------------------------------------------------------------------------------");
System.Diagnostics.Debug.WriteLine(String.Format("https://wxwyjtest.huala.com/huala/seller/login/AllInOneNative?suid={0}&uuid={1}", rows[1].ToString(), rows[2].ToString()));
System.Diagnostics.Debug.WriteLine(tempRespans);
}
}
else
{
Console.WriteLine(mySql.NowError);
}
mySql.OnDriveStateChange -= mySql_OnDriveStateChange;
mySql.OnGetErrorMessage -= mySql_OnGetErrorMessage;
mySql.OnGetInfoMessage -= mySql_OnGetInfoMessage;
mySql.Dispose();
}
public override IDatabaseDrive CreateDatabaseDrive(string connectString) => MySqlDrive.GetInstance(connectString);
public CaseProtocolExecutionForMysql(myConnectForMysql yourConnectInfo)
{
isConnect = false;
myExecutionDeviceInfo = yourConnectInfo;
mySqlDrive = new MySqlDrive(myExecutionDeviceInfo.connectStr);
}
