public int GetMaxCommandID(DbConn PubConn)
{
return(SqlHelper.Visit(ps =>
{
StringBuilder stringSql = new StringBuilder();
stringSql.Append(@"select max(id) from tb_command s where s.commandstate=2");
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, stringSql.ToString(), ps.ToParameters());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (!LibConvert.IsDbNull(ds.Tables[0].Rows[0][0]))
{
return LibConvert.ObjToInt(ds.Tables[0].Rows[0][0]);
}
}
return 0;
}));
}