Access、Sql 获取当前插入的主键ID

 public int AddSale(SaleModel model)
        {
            int id = 0;
            string query = "select @@identity";
            string sqlText = string.Format("insert into Sale(SCount,SumMoney,SUser,SJoinTime,Hide) values ('{0}','{1}','{2}','{3}',0)", model.SCount, model.SumMoney, model.SUser, model.SJoinTime);
            //LogWrite(sqlText);
            OleDbCommand cmd = new OleDbCommand(sqlText, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            cmd.CommandText = query;
            id = (int)cmd.ExecuteScalar();
            conn.Close();            
            return id;
        }