/// <summary>
/// 获取 to 表中的最大ID
/// </summary>
/// <param name="connectionName">配置文件中的 name</param>
/// <param name="tableName">表名</param>
/// <param name="pid">表中的主键ID</param>
/// <param name="type">1.sql server 2.mysql</param>
/// <returns></returns>
public int GetMaxID(string connectionName, string tableName, string keyName, TableType type = TableType.MySql)
{
OperationResult <int> maxIDResult = null;
if (type == TableType.SqlServer)
{
SynPlanSqlServerBLL sqlServerBLL = new SynPlanSqlServerBLL(connectionName);
maxIDResult = sqlServerBLL.GetMaxID(tableName, keyName);
}
else if (type == TableType.MySql)
{
SynPlanMySqlBLL mySqlBLL = new SynPlanMySqlBLL(connectionName);
maxIDResult = mySqlBLL.GetMaxID(tableName, keyName);
}
if (maxIDResult != null && maxIDResult.ResultType == OperationResultType.Success)
{
return(maxIDResult.AppendData);
}
else
{
Log(string.Format("From:{0} 数据库操作失败！原因:{1}", connectionName, maxIDResult.Message));
return(-1);
}
}
