/// <summary> /// 获取下个模拟量编号 /// </summary> /// <returns></returns> public int GetNextAnalogNo() { /*int max = _dataContext.AnalogInfos.Select(x => x.AI_No).Max(); * return max + 1;*/ string strSql = "SELECT IDENT_CURRENT('[AnalogInfo]')"; var maxList = _dataContext.ExecuteQuery <Decimal>(strSql); int max = 0; foreach (var m in maxList) { if (max < Convert.ToInt32(m)) { max = Convert.ToInt32(m); } } return(max + 1); }