/// <summary> /// 给定表名,获得下一个ID,实现主键的自动增长 /// </summary> /// <param name="tableName"></param> /// <returns></returns> public string GetNextId(string tblName) { string strResult = dal.ExecuteScalar("UP_GetMaxId", new SqlParameter("@TableName", tblName)).ToString(); //判断有无数据 if (strResult.Length != 0) { int i = Convert.ToInt32( strResult.Substring(strResult.Length - 4)); i++; return(tblName + i.ToString()); } else { return(tblName + "1001"); } }