public static KeyDataQueueData GetFirst() { StringBuilder sql = new StringBuilder(); sql.Append("select TOP 1 * from KeyDataQueue order by sTime"); DataTable dt = WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString()); if (dt.Rows.Count == 0) { return(null); } else { return(KeyDataQueueDataFactory.Construct(dt.Rows[0])); } }
public static KeyDataQueueData Get(Int32 _id) { StringBuilder sql = new StringBuilder(); sql.Append("select * from KeyDataQueue where ID="); sql.Append(""); sql.Append(_id.ToString()); sql.Append(""); DataTable dt = WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString()); if (dt.Rows.Count == 0) { return(null); } else { return(KeyDataQueueDataFactory.Construct(dt.Rows[0])); } }