public static bool UpdateAndMoveTicketRecordWithError(Int64 Row)
{
ClassLibrary.JMySQLDataBase mysqlDB = new ClassLibrary.JMySQLDataBase(ClassLibrary.JConfig.AUTServerName, ClassLibrary.JConfig.AUTUserName, ClassLibrary.JConfig.AUTPassword, ClassLibrary.JConfig.AUTDataBase);
try
{
mysqlDB.setQuery("Update cardinfo_bin_temp_log set TryCount = TryCount + 1 where Code in (" + Row + ")");
mysqlDB.Query_Execute();
mysqlDB.setQuery("Insert into cardinfo_bin_log(code,recordNumber,data,error,errNumber) Select code,recordNumber, data, error,errNumber from cardinfo_bin_temp_log where TryCount >= 3");
mysqlDB.Query_Execute();
mysqlDB.setQuery("delete from cardinfo_bin_temp_log where TryCount >= 3");
mysqlDB.Query_Execute();
mysqlDB.setQuery(@"
insert into cardinfo_bin
select Code,recordNumber,`data`,TryCount from cardinfo_bin_temp_log where
code not in (select code from cardinfo_bin) and TryCount > 0;
delete from cardinfo_bin_temp_log where TryCount > 0;
");
mysqlDB.Query_Execute();
return(true);
}
finally
{
mysqlDB.Dispose();
}
return(false);
}
public static bool MoveTicketRecord(Int64 Row, string error, int errorNumber)
{
ClassLibrary.JMySQLDataBase mysqlDB = new ClassLibrary.JMySQLDataBase(ClassLibrary.JConfig.AUTServerName, ClassLibrary.JConfig.AUTUserName, ClassLibrary.JConfig.AUTPassword, ClassLibrary.JConfig.AUTDataBase);
try
{
mysqlDB.setQuery("Insert into cardinfo_bin_log(code,recordNumber,data,error,errNumber) Select code,recordNumber, data, '" +
error +
"' as error, '" + errorNumber +
"' as errNumber from cardinfo_bin_temp_log where Code in (" + Row + ")");
mysqlDB.Query_Execute();
mysqlDB.setQuery("delete from cardinfo_bin_temp_log where Code in (" + Row + ")");
mysqlDB.Query_Execute();
return(true);
}
finally
{
mysqlDB.Dispose();
}
return(false);
}
public static bool MoveAVLRecord(DataRow row, string error, int errorNumber)
{
ClassLibrary.JMySQLDataBase mysqlDB = new ClassLibrary.JMySQLDataBase(ClassLibrary.JConfig.AUTServerName, ClassLibrary.JConfig.AUTUserName, ClassLibrary.JConfig.AUTPassword, ClassLibrary.JConfig.AUTDataBase);
try
{
mysqlDB.setQuery("Insert into avlinfo_bin_log(recordNumber,data,error,errNumber) Select recordNumber, data, '" + error + "' as error, '" + errorNumber + "' as errNumber from avlinfo_bin where recordNumber=" + row["recordNumber"].ToString());
if (mysqlDB.Query_Execute() >= 0)
{
mysqlDB.setQuery("delete from avlinfo_bin where recordNumber = '" + row["recordNumber"].ToString() + "'");
if (mysqlDB.Query_Execute() >= 0)
{
return(true);
}
return(false);
}
}
finally
{
mysqlDB.Dispose();
}
return(false);
}