/// <summary> /// 获取ID /// </summary> /// <returns></returns> public int GetMaxID() { //获取可用ID var cmd = builderFactory.Select("Max(id)").From("Scores").ToCommand(); var oldID = cmd.ExecuteScalar(connFactory); return(oldID == null || oldID.ToString() == "" ? 1 : Convert.ToInt32(oldID) + 1); }